Package org.apache.empire.dbms.h2

Class DBMSHandlerH2.DBCommandH2

java.lang.Object

org.apache.empire.db.DBObject

org.apache.empire.db.DBExpr

org.apache.empire.db.DBCommandExpr

org.apache.empire.db.DBCommand

org.apache.empire.dbms.h2.DBMSHandlerH2.DBCommandH2

All Implemented Interfaces:

Cloneable

Enclosing class:

DBMSHandlerH2

public static class DBMSHandlerH2.DBCommandH2
extends DBCommand

Defines the H2 command type.

Nested Class Summary

Nested classes/interfaces inherited from class org.apache.empire.db.DBCommandExpr

DBCommandExpr.DBCmdColumn, DBCommandExpr.DBCmdQuery

Field Summary

Fields

Modifier and Type	Field	Description
protected int	limitRows
protected int	skipRows

Fields inherited from class org.apache.empire.db.DBCommand

autoPrepareStmt, cmdParams, groupBy, having, joins, log, parentTables, select, selectDistinct, set, where

Fields inherited from class org.apache.empire.db.DBCommandExpr

cmdQuery, orderBy, SF_DEFAULT, SF_SKIP_FROM, SF_SKIP_GROUP, SF_SKIP_LIMIT, SF_SKIP_ORDER, SF_SKIP_SELECT, SF_SKIP_WHERE

Fields inherited from class org.apache.empire.db.DBExpr

CTX_ALIAS, CTX_ALL, CTX_DEFAULT, CTX_FULLNAME, CTX_NAME, CTX_NOPARENTHESIS, CTX_VALUE

Constructor Summary

Constructors

Constructor	Description
DBCommandH2(DBMSHandlerH2 dbms, boolean autoPrepareStmt)

Method Summary

Modifier and Type	Method	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

Methods inherited from class org.apache.empire.db.DBCommand

addDeleteForTable, addDeleteWithJoins, addFrom, addGrouping, addJoins, addKeyConstraints, 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, orderByUpper, orderByUpper, qualifyAll, removeAllCommandParams, removeCommandParams, removeConstraint, removeConstraintOn, removeHavingConstraint, removeHavingConstraintOn, removeJoinsOn, removeJoinsOn, removeSelect, removeWhereConstraint, removeWhereConstraintOn, replaceSelect, resetParamUsage, select, select, select, selectDistinct, selectQualified, selectQualified, selectSetExpressions, selectSetExpressions, set, set, setConstraint, setParentTables, useCmdParam, where, where

Methods inherited from class org.apache.empire.db.DBCommandExpr

addListExpr, addSQL, clearOrderBy, getCmdColumn, getDbms, getInsertInto, getInsertInto, getInsertInto, getOrderBy, getSelect, getSelect, hasOrderBy, intersect, not, notEmpty, result, union, unionAll

Methods inherited from class org.apache.empire.db.DBObject

checkParamNull

Methods inherited from class java.lang.Object

equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Details

limitRows

protected int limitRows

skipRows

protected int skipRows

Constructor Details

DBCommandH2

public DBCommandH2(DBMSHandlerH2 dbms,
 boolean autoPrepareStmt)

Method Details

limitRows

public DBCommand limitRows(int limitRows)

Description copied from class: DBCommand

Overridden to change return type from DBCommandExpr to DBCommand

Overrides:

limitRows in class DBCommand

Parameters:

limitRows - the number of rows to limit

Returns:

itself (this)

skipRows

public DBCommand skipRows(int skipRows)

Description copied from class: DBCommand

Overridden to change return type from DBCommandExpr to DBCommand

Overrides:

skipRows in class DBCommand

Parameters:

skipRows - the number of rows to skip

Returns:

itself (this)

clearLimit

public void clearLimit()

Description copied from class: DBCommandExpr

Clears a limit or offset set by calling limit() or offset()

Overrides:

clearLimit in class DBCommandExpr

getSelect

public void getSelect(DBSQLBuilder sql,
 int flags)

Description copied from class: DBCommand

Creates a select SQL-Statement

Overrides:

getSelect in class DBCommand

Parameters:

sql - the sql builder to add the command to

flags - bitwise context flags for sql building (see "Select Context Flags")