public static class DBMSHandlerMySQL.DBCommandMySQL extends DBCommand
DBCommandExpr.DBCmdColumn, DBCommandExpr.DBCmdQuery
Modifier and Type | Field and Description |
---|---|
protected int |
limit |
protected int |
skip |
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 |
---|
DBCommandMySQL(DBMSHandlerMySQL dbms,
boolean autoPrepareStmt) |
Modifier and Type | Method and Description |
---|---|
protected void |
addDeleteWithJoins(DBSQLBuilder sql,
DBRowSet table) |
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 numRows)
Overridden to change return type from DBCommandExpr to DBCommand
|
DBCommand |
skipRows(int numRows)
Overridden to change return type from DBCommandExpr to DBCommand
|
addDeleteForTable, 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, 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 DBCommandMySQL(DBMSHandlerMySQL dbms, boolean autoPrepareStmt)
public DBCommand limitRows(int numRows)
DBCommand
public DBCommand skipRows(int numRows)
DBCommand
public void clearLimit()
DBCommandExpr
clearLimit
in class DBCommandExpr
public void getSelect(DBSQLBuilder sql)
DBCommand
protected void addDeleteWithJoins(DBSQLBuilder sql, DBRowSet table)
addDeleteWithJoins
in class DBCommand
Copyright © 2008–2023 Apache Software Foundation. All rights reserved.