|
|||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectorg.apache.torque.util.Query
Used to assemble an SQL SELECT query. Attributes exist for the sections of a SELECT: modifiers, columns, from clause, where clause, and order by clause. The various parts of the query are appended to buffers which only accept unique entries. This class is used primarily by BasePeer.
Field Summary | |
private static java.lang.String |
AND
|
private static java.lang.String |
FROM
|
private UniqueList |
fromTables
|
private static java.lang.String |
GROUP_BY
|
private UniqueList |
groupByColumns
|
private java.lang.String |
having
|
private static java.lang.String |
HAVING
|
private java.lang.String |
limit
|
private static java.lang.String |
LIMIT
|
private static java.lang.String |
ORDER_BY
|
private UniqueList |
orderByColumns
|
private java.lang.String |
rowcount
|
private static java.lang.String |
ROWCOUNT
|
private static java.lang.String |
SELECT
|
private UniqueList |
selectColumns
|
private UniqueList |
selectModifiers
|
private static java.lang.String |
WHERE
|
private UniqueList |
whereCriteria
|
Constructor Summary | |
Query()
|
Method Summary | |
UniqueList |
getFromClause()
Retrieve the from buffer in order to specify which tables are involved in this query. |
UniqueList |
getGroupByClause()
Retrieve the group by columns buffer in order to specify which columns are used to group the results of the query. |
java.lang.String |
getHaving()
Get the having clause. |
java.lang.String |
getLimit()
Get the limit number. |
UniqueList |
getOrderByClause()
Retrieve the order by columns buffer in order to specify which columns are used to sort the results of the query. |
java.lang.String |
getRowcount()
Get the rowcount number. |
UniqueList |
getSelectClause()
Retrieve the columns buffer in order to specify which columns are returned in this query. |
UniqueList |
getSelectModifiers()
Retrieve the modifier buffer in order to add modifiers to this query. |
UniqueList |
getWhereClause()
Retrieve the where buffer in order to specify the selection criteria E.g. |
void |
setFromClause(UniqueList tables)
Set the from clause. |
void |
setHaving(java.lang.String having)
Set the having clause. |
void |
setLimit(java.lang.String limit)
Set the limit number. |
void |
setRowcount(java.lang.String rowcount)
Set the rowcount number. |
void |
setSelectClause(UniqueList columns)
Set the columns. |
void |
setSelectModifiers(UniqueList modifiers)
Set the modifiers. |
void |
setWhereClause(UniqueList where)
Set the where clause. |
java.lang.String |
toString()
Outputs the query statement. |
Methods inherited from class java.lang.Object |
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait |
Field Detail |
private static final java.lang.String SELECT
private static final java.lang.String FROM
private static final java.lang.String WHERE
private static final java.lang.String AND
private static final java.lang.String ORDER_BY
private static final java.lang.String GROUP_BY
private static final java.lang.String HAVING
private static final java.lang.String LIMIT
private static final java.lang.String ROWCOUNT
private UniqueList selectModifiers
private UniqueList selectColumns
private UniqueList fromTables
private UniqueList whereCriteria
private UniqueList orderByColumns
private UniqueList groupByColumns
private java.lang.String having
private java.lang.String limit
private java.lang.String rowcount
Constructor Detail |
public Query()
Method Detail |
public UniqueList getSelectModifiers()
public void setSelectModifiers(UniqueList modifiers)
modifiers
- the modifierspublic UniqueList getSelectClause()
public void setSelectClause(UniqueList columns)
columns
- columns listpublic UniqueList getFromClause()
public void setFromClause(UniqueList tables)
tables
- the tablespublic UniqueList getWhereClause()
public void setWhereClause(UniqueList where)
where
- where clausepublic UniqueList getOrderByClause()
public UniqueList getGroupByClause()
public void setHaving(java.lang.String having)
having
- A String.public void setLimit(java.lang.String limit)
limit
- A String.public void setRowcount(java.lang.String rowcount)
rowcount
- A String.public java.lang.String getHaving()
public java.lang.String getLimit()
public java.lang.String getRowcount()
public java.lang.String toString()
|
|||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |