|
Oracle Fusion Middleware Java API Reference for Oracle Extension SDK Reference 11g Release 1 (11.1.1.5.0) E13403-06 |
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Object
oracle.javatools.db.AbstractDBObject
oracle.javatools.db.AbstractChildDBObject
oracle.javatools.db.sql.AbstractSQLFragment
oracle.javatools.db.sql.AbstractSQLQuery
public abstract class AbstractSQLQuery
Abstract implementation of a SQLQuery. It implements all the methods for DeclarativeSQLQuery but doesn't explicitly implement the interface (to allow non-declarative queries to share the implementation). Subclasses that are meant to be declarative should override.
Nested Class Summary |
---|
Nested classes/interfaces inherited from class oracle.javatools.db.AbstractDBObject |
---|
AbstractDBObject.ChildSupport |
Field Summary |
---|
Fields inherited from class oracle.javatools.db.sql.AbstractSQLFragment |
---|
DEFAULT_SEPARATOR, EMPTY, EMPTY_ARRAY, NEWLINE, SPACE |
Fields inherited from interface oracle.javatools.db.sql.SQLQuery |
---|
TYPE |
Fields inherited from interface oracle.javatools.db.sql.SQLFragment |
---|
CONNECTBY, FROM, GROUPBY, HAVING, NOCYCLE, ORDERBY, SELECT, STARTWITH, WHERE |
Fields inherited from interface oracle.javatools.db.DBObject |
---|
COMMENT |
Constructor Summary | |
---|---|
protected |
AbstractSQLQuery() |
Method Summary | |
---|---|
void |
addFromObject(FromObject f) |
void |
addFromObject(int index, FromObject f) |
void |
addOrderByObject(int index, OrderByObject o) |
void |
addOrderByObject(OrderByObject o) |
void |
addSelectObject(int index, SelectObject s) |
void |
addSelectObject(SelectObject s) |
protected void |
appendFromSQL(java.lang.StringBuilder sql) |
protected void |
appendSelectSQL(java.lang.StringBuilder sql) |
protected void |
clearQueryString() Should be called by any operation that changes the query. |
DBObject |
findOwnedObject(DBObjectID id) Returns a child of this object that has the given ID. |
java.lang.String |
getDistinctSource() Get the source string used to define the DISTINCT/UNIQUE/ALL property for the query |
FromObject[] |
getFromObjects() Get all the from objects for this query. |
GroupByObject |
getGroupByObject() Gets the "GROUP BY ... |
HierarchicalQueryObject |
getHierarchicalQueryObject() Get the "CONNECT BY ... |
OrderByObject[] |
getOrderByObjects() Get all the OrderBy objects for this query. |
java.lang.String |
getQueryString() Gets the query string. |
SelectObject[] |
getSelectObjects() Returns all the objects that make up the SELECT clause. |
java.lang.String |
getSQLText() Gets the SQL for the query. |
java.lang.String |
getType() Returns the type of this object. |
WhereObject |
getWhereObject() Gets the WHERE clause for this query. |
int |
indexOf(FromObject f) |
int |
indexOf(OrderByObject o) |
int |
indexOf(SelectObject s) |
boolean |
isDistinct() Return true if the query only returns DISTINCT/UNIQUE rows. |
void |
moveFromObject(FromObject f, int newIndex) |
void |
moveOrderByObject(OrderByObject o, int newIndex) |
void |
moveSelectObject(SelectObject s, int newIndex) |
boolean |
removeFromObject(FromObject f) |
boolean |
removeOrderByObject(OrderByObject o) |
boolean |
removeSelectObject(SelectObject s) |
void |
setDistinct(boolean isDistinct) Set the DISTINCT/UNIQUE/ALL property for the query. |
void |
setDistinctSource(java.lang.String distinctSource) Set the source string used to define the DISTINCT/UNIQUE/ALL property for the query |
void |
setFromObjects(FromObject[] froms) |
void |
setGroupByObject(GroupByObject groupby) |
void |
setHierarchicalQueryObject(HierarchicalQueryObject connectby) |
void |
setID(DBObjectID id) Sets the object ID associated with this object. |
void |
setOrderByObjects(OrderByObject[] orderBys) |
void |
setQueryString(java.lang.String query) Sets the query string. |
void |
setSelectObjects(SelectObject[] selects) |
void |
setWhereObject(WhereObject where) |
Methods inherited from class oracle.javatools.db.sql.AbstractSQLFragment |
---|
appendToBuffer, argsToString, getTextOrNull, getTextOrNull, setParent, surroundWithBrackets, surroundWithBrackets, toString |
Methods inherited from class oracle.javatools.db.AbstractChildDBObject |
---|
copyToImpl, findParent, getParent, getProperty, setProperty |
Methods inherited from class oracle.javatools.db.AbstractDBObject |
---|
changeParent, compareToImpl, copyObject, copyTo, copyTo, copyTo, copyTo, equals, equalsImpl, findOwnedObject, findOwnedObject, getChildSupport, getID, getName, getOwnedObjects, getOwnedObjects, getOwnedObjectsImpl, getProperties, getProperty, getReferenceIDs, getReferenceIDsImpl, hashCode, includeOwnedObject, includesType, includesType, removeThisAsParent, replaceReferenceIDs, setName, setProperties |
Methods inherited from class java.lang.Object |
---|
clone, finalize, getClass, notify, notifyAll, wait, wait, wait |
Methods inherited from interface oracle.javatools.db.sql.SQLQuery |
---|
isDeclarative |
Methods inherited from interface oracle.javatools.db.ChildDBObject |
---|
getParent, setParent |
Methods inherited from interface oracle.javatools.db.DBObject |
---|
copyTo, copyTo, copyTo, findOwnedObject, getID, getName, getOwnedObjects, getOwnedObjects, getReferenceIDs, replaceReferenceIDs, setName |
Methods inherited from interface oracle.javatools.util.DynamicPropertySet |
---|
getProperties, getProperty, getProperty, setProperties, setProperty |
Constructor Detail |
---|
protected AbstractSQLQuery()
Method Detail |
---|
public java.lang.String getType()
DBObject
getType
in interface DBObject
getType
in class AbstractSQLFragment
public java.lang.String getSQLText()
getSQLText
in interface SQLFragment
protected void appendSelectSQL(java.lang.StringBuilder sql)
protected void appendFromSQL(java.lang.StringBuilder sql)
public java.lang.String getQueryString()
public void setQueryString(java.lang.String query)
protected void clearQueryString()
public SelectObject[] getSelectObjects()
getSelectObjects
in interface SQLQuery
public void setSelectObjects(SelectObject[] selects)
public void addSelectObject(SelectObject s)
public void addSelectObject(int index, SelectObject s)
public boolean removeSelectObject(SelectObject s)
public void moveSelectObject(SelectObject s, int newIndex)
public int indexOf(SelectObject s)
public FromObject[] getFromObjects()
SQLQuery
getFromObjects
in interface SQLQuery
public void setFromObjects(FromObject[] froms)
public void addFromObject(FromObject f)
public void addFromObject(int index, FromObject f)
public boolean removeFromObject(FromObject f)
public void moveFromObject(FromObject f, int newIndex)
public int indexOf(FromObject f)
public OrderByObject[] getOrderByObjects()
SQLQuery
getOrderByObjects
in interface SQLQuery
public void setOrderByObjects(OrderByObject[] orderBys)
public void addOrderByObject(OrderByObject o)
public void addOrderByObject(int index, OrderByObject o)
public boolean removeOrderByObject(OrderByObject o)
public void moveOrderByObject(OrderByObject o, int newIndex)
public int indexOf(OrderByObject o)
public void setWhereObject(WhereObject where)
public WhereObject getWhereObject()
SQLQuery
getWhereObject
in interface SQLQuery
public void setHierarchicalQueryObject(HierarchicalQueryObject connectby)
public HierarchicalQueryObject getHierarchicalQueryObject()
SQLQuery
getHierarchicalQueryObject
in interface SQLQuery
public void setGroupByObject(GroupByObject groupby)
public GroupByObject getGroupByObject()
SQLQuery
getGroupByObject
in interface SQLQuery
public void setDistinct(boolean isDistinct)
true - the query only DISTINCT/UNIQUE rows false - the query returns ALL rows (this is the default)
public boolean isDistinct()
public void setDistinctSource(java.lang.String distinctSource)
public java.lang.String getDistinctSource()
public void setID(DBObjectID id)
DBObject
setID
in interface DBObject
setID
in class AbstractDBObject
id
- the DBObjectID to be associated with this objectpublic DBObject findOwnedObject(DBObjectID id)
AbstractDBObject
findOwnedObject
in interface DBObject
findOwnedObject
in class AbstractDBObject
id
- the id to look for
|
Oracle Fusion Middleware Java API Reference for Oracle Extension SDK Reference 11g Release 1 (11.1.1.5.0) E13403-06 |
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |