DBCommandExpr.DBCmdColumn, DBCommandExpr.DBCmdQuery
Modifier and Type | Field and Description |
---|---|
protected int |
limitRows |
protected int |
skipRows |
autoPrepareStmt, cmdParams, groupBy, having, joins, log, select, selectDistinct, set, where
cmdQuery, orderBy
CTX_ALIAS, CTX_ALL, CTX_DEFAULT, CTX_FULLNAME, CTX_NAME, CTX_NOPARENTHESES, CTX_VALUE
Constructor and Description |
---|
DBCommandHSql(boolean autoPrepareStmt)
Constructs an HSqlDB command object.
|
Modifier and Type | Method and Description |
---|---|
protected void |
addUpdateWithJoins(StringBuilder buf,
DBRowSet table) |
void |
clearLimit()
Clears a limit or offset set by calling limit() or offset()
|
void |
getSelect(StringBuilder buf)
Creates a select SQL-Statement
|
DBCommandHSql |
limitRows(int limitRows)
Overridden to change return type from DBCommandExpr to DBCommand
|
DBCommandHSql |
skipRows(int skipRows)
Overridden to change return type from DBCommandExpr to DBCommand
|
addDeleteForTable, addDeleteWithJoins, addFrom, addGrouping, addJoin, addJoins, addOrder, addParam, addParam, addParam, addParam, addReferencedColumns, addSelect, addUpdateForTable, addWhere, addWhere, addWhereConstraints, appendCompareColExprs, clear, clearGroupBy, clearHaving, clearJoin, clearSelect, clearSelectDistinct, clearSet, clearWhere, clone, completeParamUsage, getDatabase, getDataType, getDelete, getGroupBy, getHavingConstraints, getInsert, getJoins, getParamValues, getRowSetList, getSelectExpressions, getSelectExprList, getSetExpressions, getUpdate, getWhereConstraints, groupAll, groupBy, groupBy, groupBy, hasAggegation, hasConstraintOn, hasConstraintOn, hasGroupBy, hasHavingConstraintOn, hasHavingConstraints, hasJoinOn, hasJoinOn, hasSelectExpr, hasSelectExpr, hasSetExpr, hasSetExprOn, hasWhereConstraintOn, hasWhereConstraints, having, isAutoPrepareStmt, isPreparedStatementsEnabled, isSelectDistinct, isValid, join, join, join, join, join, join, join, joinLeft, joinRight, mergeSubqueryParams, notifyParamUsage, 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, useCmdParam, where, where
addListExpr, addSQL, clearOrderBy, getCmdColumn, getInsertInto, getInsertInto, getInsertInto, getOrderBy, getSelect, hasOrderBy, intersect, result, union, unionAll
getObjectValue
checkParamNull
public DBCommandHSql(boolean autoPrepareStmt)
public DBCommandHSql limitRows(int limitRows)
DBCommand
public DBCommandHSql skipRows(int skipRows)
DBCommand
public void clearLimit()
DBCommandExpr
clearLimit
in class DBCommandExpr
public void getSelect(StringBuilder buf)
DBCommand
protected void addUpdateWithJoins(StringBuilder buf, DBRowSet table)
addUpdateWithJoins
in class DBCommand
Copyright © 2008–2022 Apache Software Foundation. All rights reserved.