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, where
cmdQuery, orderBy
CTX_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)
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, where
addListExpr, addSQL, clearOrderBy, getCmdColumn, getDbms, getInsertInto, getInsertInto, getInsertInto, getOrderBy, getSelect, hasOrderBy, intersect, result, union, unionAll
checkParamNull
public DBCommandH2(DBMSHandlerH2 dbms, boolean autoPrepareStmt)
public DBCommand limitRows(int limitRows)
DBCommand
public DBCommand skipRows(int skipRows)
DBCommand
public void clearLimit()
DBCommandExpr
clearLimit
in class DBCommandExpr
public void getSelect(DBSQLBuilder sql)
DBCommand
Copyright © 2008–2023 Apache Software Foundation. All rights reserved.