oracle.javatools.db.sql
Class AbstractSQLQuery

java.lang.Object
  oracle.javatools.db.AbstractDBObject
      oracle.javatools.db.sql.AbstractSQLFragment
          oracle.javatools.db.sql.AbstractSQLQuery

All Implemented Interfaces:

Copyable, DBObject, DynamicPropertySet, SQLFragment, SQLQuery

Direct Known Subclasses:

NonDeclarativeSQLQuery, OracleSQLQuery

public abstract class AbstractSQLQuery

extends AbstractSQLFragment

implements SQLQuery

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.

Since:

10.1.3

Field Summary

protected java.util.List	m_fromObjs
protected GroupByObject	m_groupby
protected java.util.List	m_orderByObjs
protected java.util.List	m_selectObjs
protected WhereObject	m_where

Fields inherited from class oracle.javatools.db.sql.AbstractSQLFragment

EMPTY, EMPTY_ARRAY, NEWLINE, SPACE

Fields inherited from interface oracle.javatools.db.sql.SQLQuery

TYPE

Fields inherited from interface oracle.javatools.db.sql.SQLFragment

FROM, GROUPBY, HAVING, ORDERBY, SELECT, WHERE

Fields inherited from interface oracle.javatools.db.DBObject

COMMENT

Constructor Summary

protected

AbstractSQLQuery()

Method Summary

void	addFromObject(FromObject s)
void	addFromObject(int index, FromObject s)
void	addOrderByObject(int index, OrderByObject s)
void	addOrderByObject(OrderByObject o)
void	addSelectObject(int index, SelectObject s)
void	addSelectObject(SelectObject s)
protected void	appendFromSQL(java.lang.StringBuffer sql)
protected void	appendSelectSQL(java.lang.StringBuffer sql)
protected void	copyToImpl(AbstractSQLQuery target)
protected boolean	equalsImpl(AbstractSQLQuery other)
FromObject[]	getFromObjects() Get all the from objects for this query.
GroupByObject	getGroupByObject() Gets the "GROUP BY ...
OrderByObject[]	getOrderByObjects() Get all the OrderBy objects for this query.
protected void	getOwnedObjectsImpl(java.util.Collection c, java.lang.String type) Returns all child objects of the query.
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.
View	getView() Support for Views - returns the (parent) View for this query if there is one.
WhereObject	getWhereObject() Gets the WHERE clause for this query.
int	indexOf(FromObject f)
int	indexOf(OrderByObject o)
int	indexOf(SelectObject s)
void	moveFromObject(FromObject f, int newIndex)
void	moveOrderByObject(OrderByObject o, int newIndex)
void	moveSelectObject(SelectObject s, int newIndex)
boolean	removeFromObject(FromObject s)
boolean	removeOrderByObject(OrderByObject o)
boolean	removeSelectObject(SelectObject s)
void	setFromObjects(FromObject[] froms)
void	setGroupByObject(GroupByObject groupby)
void	setOrderByObjects(OrderByObject[] orderBys)
void	setSelectObjects(SelectObject[] selects)
void	setView(View view) Support for Views - Sets the (parent) View for this query.
void	setWhereObject(WhereObject where)

Methods inherited from class oracle.javatools.db.sql.AbstractSQLFragment

appendToBuffer, changeParent, copyList, copyList, getChildren, getParent, getTextOrNull, hashCode, removeParent, setParent, setParents, toString

Methods inherited from class oracle.javatools.db.AbstractDBObject

compareToImpl, copyToImpl, equalsImpl, findOwnedObject, getID, getName, getOwnedObjects, getOwnedObjects, getProperties, getProperty, getProperty, getReferenceIDs, getReferenceIDsImpl, replaceReferenceIDs, setID, setName, setProperties, setProperty

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, notify, notifyAll, wait, wait, wait

Methods inherited from interface oracle.javatools.db.sql.SQLFragment

getChildren, getParent, setParent

Methods inherited from interface oracle.javatools.db.DBObject

copyTo, findOwnedObject, getID, getName, getOwnedObjects, getOwnedObjects, getReferenceIDs, replaceReferenceIDs, setID, setName

Methods inherited from interface oracle.javatools.util.DynamicPropertySet

getProperties, getProperty, getProperty, setProperties, setProperty

Field Detail

m_selectObjs

protected java.util.List m_selectObjs

m_fromObjs

protected java.util.List m_fromObjs

m_orderByObjs

protected java.util.List m_orderByObjs

m_where

protected WhereObject m_where

m_groupby

protected GroupByObject m_groupby

Constructor Detail

AbstractSQLQuery

protected AbstractSQLQuery()

Method Detail

getType

public java.lang.String getType()

Description copied from interface: DBObject

Returns the type of this object. Valid types include things like tables, views, synonyms, and columns.

Specified by:

getType in interface DBObject

Overrides:

getType in class AbstractSQLFragment

getSQLText

public java.lang.String getSQLText()

Gets the SQL for the query.

Specified by:

getSQLText in interface SQLFragment

Returns:

a string representing the SQL text for this object.

appendSelectSQL

protected void appendSelectSQL(java.lang.StringBuffer sql)

appendFromSQL

protected void appendFromSQL(java.lang.StringBuffer sql)

getSelectObjects

public SelectObject[] getSelectObjects()

Returns all the objects that make up the SELECT clause.

Specified by:

getSelectObjects in interface SQLQuery

setSelectObjects

public void setSelectObjects(SelectObject[] selects)

addSelectObject

public void addSelectObject(SelectObject s)

addSelectObject

public void addSelectObject(int index,
                            SelectObject s)

removeSelectObject

public boolean removeSelectObject(SelectObject s)

moveSelectObject

public void moveSelectObject(SelectObject s,
                             int newIndex)

indexOf

public int indexOf(SelectObject s)

getFromObjects

public FromObject[] getFromObjects()

Description copied from interface: SQLQuery

Get all the from objects for this query.

Specified by:

getFromObjects in interface SQLQuery

setFromObjects

public void setFromObjects(FromObject[] froms)

addFromObject

public void addFromObject(FromObject s)

addFromObject

public void addFromObject(int index,
                          FromObject s)

removeFromObject

public boolean removeFromObject(FromObject s)

moveFromObject

public void moveFromObject(FromObject f,
                           int newIndex)

indexOf

public int indexOf(FromObject f)

getOrderByObjects

public OrderByObject[] getOrderByObjects()

Description copied from interface: SQLQuery

Get all the OrderBy objects for this query.

Specified by:

getOrderByObjects in interface SQLQuery

setOrderByObjects

public void setOrderByObjects(OrderByObject[] orderBys)

addOrderByObject

public void addOrderByObject(OrderByObject o)

addOrderByObject

public void addOrderByObject(int index,
                             OrderByObject s)

removeOrderByObject

public boolean removeOrderByObject(OrderByObject o)

moveOrderByObject

public void moveOrderByObject(OrderByObject o,
                              int newIndex)

indexOf

public int indexOf(OrderByObject o)

setWhereObject

public void setWhereObject(WhereObject where)

getWhereObject

public WhereObject getWhereObject()

Description copied from interface: SQLQuery

Gets the WHERE clause for this query.

Specified by:

getWhereObject in interface SQLQuery

setGroupByObject

public void setGroupByObject(GroupByObject groupby)

getGroupByObject

public GroupByObject getGroupByObject()

Description copied from interface: SQLQuery

Gets the "GROUP BY ... HAVING ..." clause for this query.

Specified by:

getGroupByObject in interface SQLQuery

getOwnedObjectsImpl

protected void getOwnedObjectsImpl(java.util.Collection c,
                                   java.lang.String type)

Returns all child objects of the query. Returns an empty array if there are none - never returns null.

Overrides:

getOwnedObjectsImpl in class AbstractDBObject

Parameters:

type - the type to search for

Returns:

a Collection of the apppropriate children.

copyToImpl

protected void copyToImpl(AbstractSQLQuery target)

equalsImpl

protected boolean equalsImpl(AbstractSQLQuery other)

getView

public View getView()

Description copied from interface: SQLQuery

Support for Views - returns the (parent) View for this query if there is one.

Specified by:

getView in interface SQLQuery

setView

public void setView(View view)

Description copied from interface: SQLQuery

Support for Views - Sets the (parent) View for this query.

Specified by:

setView in interface SQLQuery