|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
public interface SelectStatement
Interface of a SELECT statement.
Nested Class Summary | |
---|---|
static interface |
SelectStatement.OrderColumn
|
Method Summary | |
---|---|
void |
addOrderColumn(ColumnReference pColumn)
Adds a column to the ORDER BY clause. |
void |
addOrderColumn(ColumnReference pColumn,
boolean pDescending)
Adds a column to the ORDER BY clause. |
void |
addOrderColumn(SelectStatement.OrderColumn pColumn)
Adds a column to the ORDER BY clause. |
void |
addResultColumn(ColumnReference pColumn)
Adds a result column to the statement. |
int |
getMaxRows()
Returns the limit of the number of rows in the result set, or zero, if the size of the result set is unlimited. |
java.util.Iterator |
getResultColumns()
Returns the list of result columns. |
SelectTableReference |
getSelectTableReference()
Shortcut for (SelectTableReference) getTable() . |
java.util.Iterator |
getSelectTableReferences()
Returns an Iterator over all the table references. |
int |
getSkippedRows()
Returns the number of rows to skip at the result sets beginning. |
boolean |
isDistinct()
Returns whether the statement should have a DISTINCT clause. |
void |
setDistinct(boolean pDistinct)
Sets whether the statement should have a DISTINCT clause. |
void |
setMaxRows(int pMaxRows)
Limits the size of the result set to the given number of rows. |
void |
setSkippedRows(int pSkippedRows)
Indicates that the given number of rows should be skipped at the result sets beginning. |
Methods inherited from interface org.apache.ws.jaxme.sqls.ConstrainedStatement |
---|
getWhere |
Methods inherited from interface org.apache.ws.jaxme.sqls.Statement |
---|
createFunction, getSQLFactory, getTableReference, setTable |
Method Detail |
---|
SelectTableReference getSelectTableReference()
Shortcut for (SelectTableReference) getTable()
.
java.util.Iterator getSelectTableReferences()
Returns an Iterator over all the table references.
void addOrderColumn(SelectStatement.OrderColumn pColumn)
Adds a column to the ORDER BY clause.
void addOrderColumn(ColumnReference pColumn)
Adds a column to the ORDER BY clause. The column is sorted in ascending order.
void addOrderColumn(ColumnReference pColumn, boolean pDescending)
Adds a column to the ORDER BY clause. The column is sorted in
ascending or descending order, depending on the parameter
pDescending
.
pDescending
- True for descending or false for ascendingvoid addResultColumn(ColumnReference pColumn)
Adds a result column to the statement. By default all columns are returned.
java.util.Iterator getResultColumns()
Returns the list of result columns.
void setDistinct(boolean pDistinct)
Sets whether the statement should have a DISTINCT clause. By default no DISTINCT clause is present.
boolean isDistinct()
Returns whether the statement should have a DISTINCT clause. By default no DISTINCT clause is present.
void setMaxRows(int pMaxRows)
Limits the size of the result set to the given number of rows. Defaults to zero, in which case the size of the result set is unlimited.
int getMaxRows()
Returns the limit of the number of rows in the result set, or zero, if the size of the result set is unlimited.
void setSkippedRows(int pSkippedRows)
Indicates that the given number of rows should be skipped at the result sets beginning. The default is zero, in which case no rows are skipped.
int getSkippedRows()
Returns the number of rows to skip at the result sets beginning. The default is zero, in which case no rows are skipped.
|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |