public static class DBMSHandlerH2.DBCommandH2 extends DBCommand
DBCommandExpr.DBCmdColumn, DBCommandExpr.DBCmdQuery| Modifier and Type | Field and Description |
|---|---|
protected int |
limitRows |
protected int |
skipRows |
autoPrepareStmt, cmdParams, groupBy, having, joins, log, parentTables, select, selectDistinct, set, wherecmdQuery, orderBy, SF_DEFAULT, SF_SKIP_FROM, SF_SKIP_GROUP, SF_SKIP_LIMIT, SF_SKIP_ORDER, SF_SKIP_SELECT, SF_SKIP_WHERECTX_ALIAS, CTX_ALL, CTX_DEFAULT, CTX_FULLNAME, CTX_NAME, CTX_NOPARENTHESIS, CTX_VALUE| Constructor and Description |
|---|
DBCommandH2(DBMSHandlerH2 dbms,
boolean autoPrepareStmt) |
| Modifier and Type | Method and Description |
|---|---|
void |
clearLimit()
Clears a limit or offset set by calling limit() or offset()
|
void |
getSelect(DBSQLBuilder sql,
int flags)
Creates a select SQL-Statement
|
DBCommand |
limitRows(int limitRows)
Overridden to change return type from DBCommandExpr to DBCommand
|
DBCommand |
skipRows(int skipRows)
Overridden to change return type from DBCommandExpr to DBCommand
|
addDeleteForTable, addDeleteWithJoins, addFrom, addGrouping, addJoins, addOrder, addParam, addParam, addParam, addParam, addReferencedColumns, addSelect, addUpdateForTable, addUpdateWithJoins, addWhere, addWhere, addWhereConstraints, appendCompareColExprs, clear, clearGroupBy, clearHaving, clearJoin, clearSelect, clearSelectDistinct, clearSet, clearWhere, clone, completeParamUsage, createSQLBuilder, findConstraintOn, getDatabase, getDataType, getDelete, getGroupBy, getHavingConstraints, getInsert, getJoins, getParams, getParamValues, getRowSetList, getSelectExpressions, getSelectExprList, getSetExpressions, getUpdate, getWhereConstraints, groupAll, groupBy, groupBy, groupBy, hasAggegation, hasConstraintOn, hasGroupBy, hasHavingConstraintOn, hasHavingConstraints, hasJoinOn, hasJoinOn, hasSelectExpr, hasSelectExpr, hasSetExpr, hasSetExprOn, hasWhereConstraintOn, hasWhereConstraints, having, isAutoPrepareStmt, isPreparedStatementsEnabled, isSelectDistinct, isValid, join, join, join, join, join, join, join, join, joinLeft, joinLeft, joinRight, joinRight, orderBy, orderBy, orderBy, qualifyAll, removeAllCommandParams, removeCommandParams, removeConstraint, removeConstraintOn, removeHavingConstraint, removeHavingConstraintOn, removeJoinsOn, removeJoinsOn, removeSelect, removeWhereConstraint, removeWhereConstraintOn, replaceSelect, resetParamUsage, select, select, select, selectDistinct, selectQualified, selectQualified, set, set, setConstraint, setParentTables, useCmdParam, where, whereaddListExpr, addSQL, clearOrderBy, getCmdColumn, getDbms, getInsertInto, getInsertInto, getInsertInto, getOrderBy, getSelect, getSelect, hasOrderBy, intersect, not, notEmpty, result, union, unionAllcheckParamNullpublic DBCommandH2(DBMSHandlerH2 dbms, boolean autoPrepareStmt)
public DBCommand limitRows(int limitRows)
DBCommandpublic DBCommand skipRows(int skipRows)
DBCommandpublic void clearLimit()
DBCommandExprclearLimit in class DBCommandExprpublic void getSelect(DBSQLBuilder sql, int flags)
DBCommandCopyright © 2008–2023 Apache Software Foundation. All rights reserved.