|
|||||||||||
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 |
BETWEEN
|
private static java.lang.String |
FROM
|
private org.apache.commons.collections.StringStack |
fromTables
|
private static java.lang.String |
GROUP_BY
|
private org.apache.commons.collections.StringStack |
groupByColumns
|
private java.lang.String |
having
|
private static java.lang.String |
HAVING
|
private static java.lang.String |
IN
|
private java.lang.String |
limit
|
private static java.lang.String |
LIMIT
|
private static java.lang.String |
OR
|
private static java.lang.String |
ORDER_BY
|
private org.apache.commons.collections.StringStack |
orderByColumns
|
private java.lang.String |
rowcount
|
private static java.lang.String |
ROWCOUNT
|
private static java.lang.String |
SELECT
|
private org.apache.commons.collections.StringStack |
selectColumns
|
private org.apache.commons.collections.StringStack |
selectModifiers
|
private static java.lang.String |
WHERE
|
private org.apache.commons.collections.StringStack |
whereCriteria
|
Constructor Summary | |
Query()
|
Method Summary | |
org.apache.commons.collections.StringStack |
getFromClause()
Retrieve the from buffer in order to specify which tables are involved in this query. |
org.apache.commons.collections.StringStack |
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. |
org.apache.commons.collections.StringStack |
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. |
org.apache.commons.collections.StringStack |
getSelectClause()
Retrieve the columns buffer in order to specify which columns are returned in this query. |
org.apache.commons.collections.StringStack |
getSelectModifiers()
Retrieve the modifier buffer in order to add modifiers to this query. |
org.apache.commons.collections.StringStack |
getWhereClause()
Retrieve the where buffer in order to specify the selection criteria E.g. |
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. |
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 OR
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 IN
private static final java.lang.String BETWEEN
private static final java.lang.String LIMIT
private static final java.lang.String ROWCOUNT
private org.apache.commons.collections.StringStack selectModifiers
private org.apache.commons.collections.StringStack selectColumns
private org.apache.commons.collections.StringStack fromTables
private org.apache.commons.collections.StringStack whereCriteria
private org.apache.commons.collections.StringStack orderByColumns
private org.apache.commons.collections.StringStack groupByColumns
private java.lang.String having
private java.lang.String limit
private java.lang.String rowcount
Constructor Detail |
public Query()
Method Detail |
public org.apache.commons.collections.StringStack getSelectModifiers()
public org.apache.commons.collections.StringStack getSelectClause()
public org.apache.commons.collections.StringStack getFromClause()
public org.apache.commons.collections.StringStack getWhereClause()
public org.apache.commons.collections.StringStack getOrderByClause()
public org.apache.commons.collections.StringStack 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 |