Uses of Class
org.apache.empire.db.DBCommand

Packages that use DBCommand

Package	Description
org.apache.empire.data.bean	This package contains implmentations of Empire's data and metadata interfaces for JavaBeans of Data Tranfer Objects (DTO's).
org.apache.empire.db	This package contains the core Empire-DB implementation classes.
org.apache.empire.db.context
org.apache.empire.db.expr.column	This package contains SQL-generator classes for column expressions.
org.apache.empire.db.expr.compare	This package contains SQL-generator classes for compare expressions used in the where and having clause.
org.apache.empire.db.expr.join	This package contains SQL-generator classes for join expressions used in the from clause.
org.apache.empire.db.expr.set	This package contains SQL-generator classes for set expressions used in the set clause.
org.apache.empire.db.list
org.apache.empire.dbms
org.apache.empire.dbms.h2	This package contains classes necessary to support the H2 database system.
org.apache.empire.dbms.hsql	This package contains classes necessary to support the HSQLDB database system.
org.apache.empire.dbms.mysql	This package contains classes necessary to support the MySQL database system.
org.apache.empire.dbms.oracle	This package contains classes necessary to support the Oracle database system.
org.apache.empire.dbms.postgresql	This package contains classes necessary to support the PostgreSQL database system.
org.apache.empire.dbms.sqlite
org.apache.empire.dbms.sqlserver	This package contains classes necessary to support the Microsoft SQL-Server database system.

Uses of DBCommand in org.apache.empire.data.bean

Methods in org.apache.empire.data.bean that return DBCommand

Modifier and Type	Method	Description
DBCommand	BeanResult.getCommand()	Returns the current command Used to add constraints, order, grouping etc.

Constructors in org.apache.empire.data.bean with parameters of type DBCommand

Modifier	Constructor	Description
	BeanResult(Class<T> beanType, DBCommand cmd)	Create a bean result from a command object.

Uses of DBCommand in org.apache.empire.db

Fields in org.apache.empire.db declared as DBCommand

Modifier and Type	Field	Description
protected DBCommand	DBCmdParam.cmd

Methods in org.apache.empire.db that return DBCommand

Modifier and Type	Method	Description
DBCommand	DBCommand.clone()	Creates a clone of this class.
DBCommand	DBContext.createCommand()
DBCommand	DBDatabase.createCommand()	Creates a new Command object for this database Deprecated instead use context.createCommand();
protected DBCommand	DBRowSet.createRecordCommand(DBContext context)	Creates a new command object for record handing May use Prepared statements even if disabled in context
DBCommand	DBCmdParam.getCmd()	Returns the command this parameter belongs to
protected DBCommand	DBQuery.getCommandFromExpression()	returns the command from the underlying command expression or throws an exception
final DBCommand	DBCommand.groupAll()	Adds all select expressions which are not aggregates to the Group By clause
final DBCommand	DBCommand.groupBy(Collection<? extends DBColumnExpr> columns)	Adds a collection of columns to the Group By clause of an sql statement.
DBCommand	DBCommand.groupBy(DBColumnExpr columnExpr)	Adds a column expression to the Group By clause of an sql statement.
final DBCommand	DBCommand.groupBy(DBColumnExpr... exprs)	Adds a list of columns to the Group By clause of an sql statement.
DBCommand	DBCommand.having(DBCompareExpr expr)	adds a constraint to the having clause.
final DBCommand	DBCommand.join(DBColumn[] left, DBColumn[] right, DBJoinType joinType, DBCompareExpr... addlConstraints)	Multi-Column version of column based join expression
final DBCommand	DBCommand.join(DBColumnExpr left, DBColumn right, DBJoinType joinType, DBCompareExpr... addlConstraints)	Adds a join based on two columns to the list of join expressions.
final DBCommand	DBCommand.join(DBColumnExpr left, DBColumn right, DBCompareExpr... addlConstraints)	Adds an inner join based on two columns to the list of join expressions.
final DBCommand	DBCommand.join(DBRowSet left, DBRowSet right)	Adds a cross join for two tables or views New in release 3.1: Use left.on(right)) instead
final DBCommand	DBCommand.join(DBRowSet rowset, DBCompareExpr cmp)	Adds an inner join based on a compare expression to the command.
final DBCommand	DBCommand.join(DBRowSet rowset, DBCompareExpr cmp, DBJoinType joinType)	Adds a join based on a compare expression to the command.
DBCommand	DBCommand.join(DBJoinExpr join)	Adds a join to the list of join expressions.
final DBCommand	DBCommand.join(DBJoinExpr join, DBJoinType joinType)	Adds a join to the list of join expressions.
final DBCommand	DBCommand.joinLeft(DBColumnExpr left, DBColumn right, DBCompareExpr... addlConstraints)	Adds a left join based on two columns to the list of join expressions.
final DBCommand	DBCommand.joinLeft(DBJoinExpr join)	Adds a left join to the list of join expressions.
final DBCommand	DBCommand.joinRight(DBColumnExpr left, DBColumn right, DBCompareExpr... addlConstraints)	Adds a right join based on two columns to the list of join expressions.
final DBCommand	DBCommand.joinRight(DBJoinExpr join)	Adds a left join to the list of join expressions.
DBCommand	DBCommand.limitRows(int limitRows)	Overridden to change return type from DBCommandExpr to DBCommand
protected DBCommand	DBView.newCommand()	Use this to create a new View command inside the createCommand() method!
DBCommand	DBCommand.orderBy(DBColumnExpr... exprs)	Overridden to change return type from DBCommandExpr to DBCommand
DBCommand	DBCommand.orderBy(DBColumnExpr expr, boolean desc)	Overridden to change return type from DBCommandExpr to DBCommand
DBCommand	DBCommand.orderBy(DBOrderByExpr... exprs)	Overridden to change return type from DBCommandExpr to DBCommand
DBCommand	DBCommand.orderByUpper(DBColumnExpr... expr)	Overridden to change return type from DBCommandExpr to DBCommand
DBCommand	DBCommand.orderByUpper(DBColumnExpr expr, boolean desc)	Overridden to change return type from DBCommandExpr to DBCommand
DBCommand	DBCommand.qualifyAll()	Makes sure all selected columns are identified by their proper names (qualified)
final DBCommand	DBCommand.select(Collection<? extends DBColumnExpr> columns)	Adds a collection of columns to the select phrase of an sql statement.
DBCommand	DBCommand.select(DBColumnExpr expr)	Adds a DBColumnExpr object to the Select collection
final DBCommand	DBCommand.select(DBColumnExpr... exprs)	Adds a list of columns to the select phrase of an sql statement.
DBCommand	DBCommand.selectDistinct()	Sets whether or not the select statement should contain the distinct directive .
final DBCommand	DBCommand.selectQualified(Collection<? extends DBColumnExpr> columns)	Adds a collection of columns to the select phrase of an sql statement.
DBCommand	DBCommand.selectQualified(DBColumnExpr... columns)	Adds a list of columns with their qualified name to the select phrase of an sql statement.
final DBCommand	DBCommand.selectSetExpressions()	Selects all set expressions that have been set for this command
final DBCommand	DBCommand.selectSetExpressions(List<DBSetExpr> setExprList)	Selects all set expressions i.e. converts all calls like cmd.set(COL.to(VALUE)) into a select of the form cmd.select(VALUE.as(COL))
DBCommand	DBCommand.set(DBSetExpr expr)	Adds a single set expressions to this command Use column.to(...) to create a set expression
final DBCommand	DBCommand.set(DBSetExpr... exprs)	Adds a list of set expressions to this command Use column.to(...) to create a set expression
DBCommand	DBCommand.skipRows(int skipRows)	Overridden to change return type from DBCommandExpr to DBCommand
DBCommand	DBCommand.where(DBCompareExpr expr)	Adds a constraint to the where phrase of the sql statement If another restriction already exists for the same column it will be replaced.
final DBCommand	DBCommand.where(DBCompareExpr... exprs)	Adds a list of constraints to the where phrase of the sql statement If another restriction already exists for the same column it will be replaced.

Methods in org.apache.empire.db with parameters of type DBCommand

Modifier and Type	Method	Description
void	DBCmdParamList.add(DBCommand cmd, DataType type, Object value)
void	DBSQLScript.addDelete(DBCommand cmd, DBTable table)	Adds an delete statement
void	DBSQLScript.addInsert(DBCommand cmd)	Adds an insert statement
protected boolean	DBQuery.addJoinRestriction(DBCommand cmd, DBColumn updCol, DBColumn joinCol, Object[] key, DBRecordBase record)	Adds join restrictions to the supplied command object.
void	DBSQLScript.addUpdate(DBCommand cmd)	Adds an update statement
void	DBCmdParamList.completeParamUsage(DBCommand cmd)	internally used to remove unused Command Params from list Note: Only one thread my generate an SQL statement
int	DBContext.executeDelete(DBTable from, DBCommand cmd)
int	DBContext.executeInsert(DBCommand cmd)
int	DBContext.executeInsertInto(DBTable table, DBCommand cmd)
int	DBContext.executeUpdate(DBCommand cmd)
final List<DBRecord>	DBUtils.queryRecordList(DBCommand cmd, DBRowSet rowset)	Executes a query and returns a list of DBRecord items
final <R extends DBRecordBase> List<R>	DBUtils.queryRecordList(DBCommand cmd, DBRowSet rowset, Class<R> recordType)	Executes a query and returns a list of DBRecord items
<R extends DBRecordBase> List<R>	DBUtils.queryRecordList(DBCommand cmd, DBRecordListFactory<R> factory, int first, int pageSize)	Executes a query and returns a list of DBRecord items
int	DBUtils.queryRowCount(DBCommand cmd)	Returns the number of rows returned by executing the select statement
protected void	DBRowSet.readRecord(DBRecordBase record, DBCommand cmd)	Reads a single record from the database using the given command object. If a record is found the DBRecord object will hold all record data.
void	DBCmdParamList.resetParamUsage(DBCommand cmd)	internally used to reset the command param usage count.

Constructors in org.apache.empire.db with parameters of type DBCommand

Modifier	Constructor	Description
protected	DBCmdParam(DBCommand cmd, DataType type, Object value)	Protected constructor used e.g. by DBCommand.addParam(...)

Uses of DBCommand in org.apache.empire.db.context

Methods in org.apache.empire.db.context that return DBCommand

Modifier and Type	Method	Description
final DBCommand	DBContextBase.createCommand()	Creates a new Command object for the given database

Methods in org.apache.empire.db.context with parameters of type DBCommand

Modifier and Type	Method	Description
final int	DBContextBase.executeDelete(DBTable from, DBCommand cmd)	Executes a Delete statement from a command object
final int	DBContextBase.executeInsert(DBCommand cmd)	Executes an Insert statement from a command object
final int	DBContextBase.executeInsertInto(DBTable table, DBCommand cmd)	Executes an InsertInfo statement from a command object
final int	DBContextBase.executeUpdate(DBCommand cmd)	Executes an Update statement from a command object

Uses of DBCommand in org.apache.empire.db.expr.column

Methods in org.apache.empire.db.expr.column with parameters of type DBCommand

Modifier and Type	Method	Description
void	DBAbstractFuncExpr.prepareParams(DBCommand cmd, DBExpr parent)
void	DBAliasExpr.prepareParams(DBCommand cmd, DBExpr parent)
void	DBCoalesceExpr.prepareParams(DBCommand cmd, DBExpr parent)
void	DBDecodeExpr.prepareParams(DBCommand cmd, DBExpr parent)
void	DBParenthesisExpr.prepareParams(DBCommand cmd, DBExpr parent)
void	DBPreparable.prepareParams(DBCommand cmd, DBExpr parent)	Prepares an expression for a query This function is called by DBCommand in order to add values as query parameters instead of being literally included in the sql statement Please Note: This function is internally called.
void	DBScalarExpr.prepareParams(DBCommand cmd, DBExpr parent)
void	DBValueExpr.prepareParams(DBCommand cmd, DBExpr parent)

Uses of DBCommand in org.apache.empire.db.expr.compare

Methods in org.apache.empire.db.expr.compare with parameters of type DBCommand

Modifier and Type	Method	Description
DBCompareExpr	DBCompareAndOrExpr.copy(DBCommand newCmd)	Copy Command
DBCompareExpr	DBCompareColExpr.copy(DBCommand newCmd)	Copy Command
abstract DBCompareExpr	DBCompareExpr.copy(DBCommand newCmd)	internally used for command cloning
DBCompareExpr	DBCompareNotExpr.copy(DBCommand newCmd)	Copy Command
DBCompareExpr	DBCompareParenthesisExpr.copy(DBCommand newCmd)
DBCompareExpr	DBExistsExpr.copy(DBCommand newCmd)	Copy Command
void	DBCompareAndOrExpr.prepareParams(DBCommand cmd, DBExpr parent)
void	DBCompareColExpr.prepareParams(DBCommand cmd, DBExpr parent)
void	DBCompareNotExpr.prepareParams(DBCommand cmd, DBExpr parent)
void	DBCompareParenthesisExpr.prepareParams(DBCommand cmd, DBExpr parent)
void	DBExistsExpr.prepareParams(DBCommand cmd, DBExpr parent)

Uses of DBCommand in org.apache.empire.db.expr.join

Methods in org.apache.empire.db.expr.join with parameters of type DBCommand

Modifier and Type	Method	Description
DBJoinExpr	DBColumnJoinExpr.copy(DBCommand newCmd)	Copy Command
DBJoinExpr	DBCompareJoinExpr.copy(DBCommand newCmd)	Copy Command
DBJoinExpr	DBCrossJoinExpr.copy(DBCommand newCmd)	Copy Command
abstract DBJoinExpr	DBJoinExpr.copy(DBCommand newCmd)	Copy Command
void	DBColumnJoinExpr.prepareParams(DBCommand cmd, DBExpr parent)
void	DBCompareJoinExpr.prepareParams(DBCommand cmd, DBExpr parent)
void	DBCrossJoinExpr.prepareParams(DBCommand cmd, DBExpr parent)

Uses of DBCommand in org.apache.empire.db.expr.set

Methods in org.apache.empire.db.expr.set with parameters of type DBCommand

Modifier and Type	Method	Description
DBSetExpr	DBSetExpr.copy(DBCommand newCmd)	Copy Command

Uses of DBCommand in org.apache.empire.db.list

Methods in org.apache.empire.db.list with parameters of type DBCommand

Modifier and Type	Method	Description
void	DBRecordListFactory.prepareQuery(DBCommand cmd, DBContext context)
void	DBRecordListFactoryImpl.prepareQuery(DBCommand cmd, DBContext context)

Uses of DBCommand in org.apache.empire.dbms

Subclasses of DBCommand in org.apache.empire.dbms

Modifier and Type	Class	Description
static final class	DBMSHandlerBase.DBMSCommand	DBMSCommand A Default DBCommand implementation with no additional features

Methods in org.apache.empire.dbms that return DBCommand

Modifier and Type	Method	Description
DBCommand	DBMSHandler.createCommand(boolean autoPrepareStmt)	This function creates a DBCommand for this DBMS
DBCommand	DBMSHandlerBase.createCommand(boolean autoPrepareStmt)	This function creates a DBCommand derived object this database

Uses of DBCommand in org.apache.empire.dbms.h2

Subclasses of DBCommand in org.apache.empire.dbms.h2

Modifier and Type	Class	Description
static class	DBMSHandlerH2.DBCommandH2	Defines the H2 command type.

Methods in org.apache.empire.dbms.h2 that return DBCommand

Modifier and Type	Method	Description
DBCommand	DBMSHandlerH2.createCommand(boolean autoPrepareStmt)	Creates a new H2 command object.
DBCommand	DBMSHandlerH2.DBCommandH2.limitRows(int limitRows)
DBCommand	DBMSHandlerH2.DBCommandH2.skipRows(int skipRows)

Uses of DBCommand in org.apache.empire.dbms.hsql

Subclasses of DBCommand in org.apache.empire.dbms.hsql

Modifier and Type	Class	Description
class	DBCommandHSql	This class handles the special features of an HSqlDB database.

Methods in org.apache.empire.dbms.hsql that return DBCommand

Modifier and Type	Method	Description
DBCommand	DBMSHandlerHSql.createCommand(boolean autoPrepareStmt)	Override standard command

Uses of DBCommand in org.apache.empire.dbms.mysql

Subclasses of DBCommand in org.apache.empire.dbms.mysql

Modifier and Type	Class	Description
static class	DBMSHandlerMySQL.DBCommandMySQL	Defines the MySQL command type.

Methods in org.apache.empire.dbms.mysql that return DBCommand

Modifier and Type	Method	Description
DBCommand	DBMSHandlerMySQL.createCommand(boolean autoPrepareStmt)	Creates a new MySQL command object.
DBCommand	DBMSHandlerMySQL.DBCommandMySQL.limitRows(int numRows)
DBCommand	DBMSHandlerMySQL.DBCommandMySQL.skipRows(int numRows)

Uses of DBCommand in org.apache.empire.dbms.oracle

Subclasses of DBCommand in org.apache.empire.dbms.oracle

Modifier and Type	Class	Description
class	DBCommandOracle	This class handles the special features of an oracle database.

Methods in org.apache.empire.dbms.oracle that return DBCommand

Modifier and Type	Method	Description
DBCommand	DBMSHandlerOracle.createCommand(boolean autoPrepareStmt)	Creates a new Oracle command object.

Uses of DBCommand in org.apache.empire.dbms.postgresql

Subclasses of DBCommand in org.apache.empire.dbms.postgresql

Modifier and Type	Class	Description
class	DBCommandPostgres	Defines the PostgreSQL command type.

Methods in org.apache.empire.dbms.postgresql that return DBCommand

Modifier and Type	Method	Description
DBCommand	DBCommandPostgres.limitRows(int numRows)
DBCommand	DBCommandPostgres.skipRows(int numRows)

Methods in org.apache.empire.dbms.postgresql with parameters of type DBCommand

Modifier and Type	Method	Description
DBCompareExpr	PostgresAtAt.copy(DBCommand newCmd)
void	PostgresAtAt.prepareParams(DBCommand cmd, DBExpr parent)

Uses of DBCommand in org.apache.empire.dbms.sqlite

Subclasses of DBCommand in org.apache.empire.dbms.sqlite

Modifier and Type	Class	Description
static class	DBMSHandlerSQLite.DBCommandSQLite	Defines the SQLite command type.

Methods in org.apache.empire.dbms.sqlite that return DBCommand

Modifier and Type	Method	Description
DBCommand	DBMSHandlerSQLite.createCommand(boolean autoPrepareStmt)	Creates a new SQLite command object.

Uses of DBCommand in org.apache.empire.dbms.sqlserver

Subclasses of DBCommand in org.apache.empire.dbms.sqlserver

Modifier and Type	Class	Description
static class	DBMSHandlerMSSQL.DBCommandMSSQL	Provides a DBCommand implementation for Microsoft SQL-Server

Methods in org.apache.empire.dbms.sqlserver that return DBCommand

Modifier and Type	Method	Description
DBCommand	DBMSHandlerMSSQL.createCommand(boolean autoPrepareStmt)	Creates a new Microsoft SQL-Server command object.
DBCommand	DBMSHandlerMSSQL.DBCommandMSSQL.limitRows(int numRows)
DBCommand	DBMSHandlerMSSQL.DBCommandMSSQL.skipRows(int skipRows)