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

Packages that use DBCommandExpr

Package	Description
org.apache.empire.db	This package contains the core Empire-DB implementation classes.
org.apache.empire.db.exceptions	This package contains classes for exception handling of database related errors.
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.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 DBCommandExpr in org.apache.empire.db

Subclasses of DBCommandExpr in org.apache.empire.db

Modifier and Type	Class	Description
class	DBCombinedCmd	This class is used for combining two DBCommandExpr objects to a new single DBCommandExpr This may be used to create "UNION" or "INTERSECT" queries
class	DBCommand	This abstract class handles the creation of the SQL-Commands.

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

Modifier and Type	Field	Description
protected final DBCommandExpr	DBQuery.cmdExpr
protected DBCommandExpr	DBCombinedCmd.left
protected DBCommandExpr	DBCombinedCmd.right

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

Modifier and Type	Method	Description
DBCommandExpr	DBCommandExpr.clone()	Creates a clone of this class.
abstract DBCommandExpr	DBView.createCommand()	Returns the command required to create the view This is function is only used for the creation of DDL statements
DBCommandExpr	DBQuery.getCommandExpr()	returns the underlying command expression
DBCommandExpr	DBCommandExpr.intersect(DBCommandExpr other)	Constructs a new DBCombinedCmd object with this object, the key word= "INTERSECT" and the selected DBCommandExpr.
DBCommandExpr	DBCommandExpr.limitRows(int numRows)	set the maximum number of rows to return when executing a query command A negative value will remove the limit.
DBCommandExpr	DBCombinedCmd.orderBy(DBOrderByExpr... exprs)
DBCommandExpr	DBCommandExpr.orderBy(DBColumnExpr... exprs)	Adds a list of columns to the orderBy clause in ascending order
DBCommandExpr	DBCommandExpr.orderBy(DBColumnExpr expr, boolean desc)	Adds an order by with ascending or descending order
DBCommandExpr	DBCommandExpr.orderBy(DBOrderByExpr... exprs)	Adds an order by expression the command
DBCommandExpr	DBCommandExpr.orderByUpper(DBColumnExpr... exprs)	Adds a list of columns to the orderBy clause in ascending order
DBCommandExpr	DBCommandExpr.orderByUpper(DBColumnExpr expr, boolean desc)	Adds a case insensitive order by with ascending or descending order
DBCommandExpr	DBCommandExpr.skipRows(int numRows)	sets the offset of the first row to return when executing a query command.
DBCommandExpr	DBCommandExpr.union(DBCommandExpr other)	Constructs a new DBCombinedCmd object with this object, the key word= "UNION" and the selected DBCommandExpr.
DBCommandExpr	DBCommandExpr.unionAll(DBCommandExpr other)	Constructs a new DBCombinedCmd object with this object, the key word= "UNION ALL" and the selected DBCommandExpr.

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

Modifier and Type	Method	Description
void	DBSQLBuilder.append(DBCommandExpr subQueryCmd)
protected DataListHead	DBUtils.createDefaultDataListHead(DBCommandExpr cmd, Class<? extends DataListEntry> entryClass)	Crates a default DataListHead for a DataListEntry class
<T> DBBeanListFactory<T>	DBUtils.getCommandBeanListFactory(Class<T> beanType, DBCommandExpr cmd)	gets or creates DBBeanListFactory for the given rowset
void	DBReader.getRecordData(DBCommandExpr cmd)	Opens the reader by executing the given SQL command and moves to the first row. If true is returned data of the row can be accessed through the functions on the RecordData interface. This function is intended for single row queries and provided for convenience. However it behaves exacly as calling reader.open() and reader.moveNext()
protected void	DBUtils.handleQueryNoResult(DBCommandExpr cmd, Class<?> resultType)	Called when a query has no result
DBCommandExpr	DBCommandExpr.intersect(DBCommandExpr other)	Constructs a new DBCombinedCmd object with this object, the key word= "INTERSECT" and the selected DBCommandExpr.
final void	DBReader.open(DBCommandExpr cmd)	Opens the reader by executing the given SQL command.
void	DBReader.open(DBCommandExpr cmd, boolean scrollable)	Opens the reader by executing the given SQL command. After the reader is open, the reader's position is before the first record. Use moveNext or iterator() to step through the rows. Data of the current row can be accessed through the functions on the RecordData interface.
<T> T	DBUtils.queryBean(DBCommandExpr cmd, Class<T> beanType)	Queries a single Java Bean for a given command
<T> T	DBUtils.queryBean(DBCommandExpr cmd, DBBeanListFactory<T> factory)	queries a single Java Bean for a given command
<T> List<T>	DBUtils.queryBeanList(DBCommandExpr cmd, Class<T> beanType, Object parent)	Queries a list of Java beans for a given command
<T> List<T>	DBUtils.queryBeanList(DBCommandExpr cmd, Class<T> beanType, DBRowSet rowset, Object parent)	Queries a list of Java beans for a given command
final <T> List<T>	DBUtils.queryBeanList(DBCommandExpr cmd, DBBeanListFactory<T> factory, Object parent)	Queries a list of Java beans for a given command
<T> List<T>	DBUtils.queryBeanList(DBCommandExpr cmd, DBBeanListFactory<T> factory, Object parent, int first, int pageSize)	Query a list of simple Java objects (beans)
final DataListEntry	DBUtils.queryDataEntry(DBCommandExpr cmd)	Queries a single DataListEntry item
final <T extends DataListEntry> T	DBUtils.queryDataEntry(DBCommandExpr cmd, Class<T> entryClass)	Queries a single DataListEntry item
final <T extends DataListEntry> T	DBUtils.queryDataEntry(DBCommandExpr cmd, Class<T> entryClass, boolean failOnNoResult)	Deprecated.
final <T extends DataListEntry> T	DBUtils.queryDataEntry(DBCommandExpr cmd, Class<T> entryClass, DataListHead head)	Queries a single DataListEntry item
final List<DataListEntry>	DBUtils.queryDataList(DBCommandExpr cmd)	Queries a list of DataListEntry items
final List<DataListEntry>	DBUtils.queryDataList(DBCommandExpr cmd, int first, int maxItems)	Queries a list of DataListEntry items
final <T extends DataListEntry> List<T>	DBUtils.queryDataList(DBCommandExpr cmd, Class<T> entryClass)	Queries a list of DataListEntry items
final <T extends DataListEntry> List<T>	DBUtils.queryDataList(DBCommandExpr cmd, Class<T> entryClass, int first, int maxItems)	Queries a list of DataListEntry items
final <T extends DataListEntry> List<T>	DBUtils.queryDataList(DBCommandExpr cmd, Class<T> entryClass, DataListHead head)	Queries a list of DataListEntry items
<T extends DataListEntry> List<T>	DBUtils.queryDataList(DBCommandExpr cmd, DataListFactory<T> factory, int first, int pageSize)	Executes a query and returns a list of DataListEntry items
final List<Object[]>	DBUtils.queryObjectList(DBCommandExpr cmd)	Returns the result of a query as a list Object-Arrays This function should only be used for small lists.
final Options	DBUtils.queryOptionList(DBCommandExpr cmd)	Returns a list of key value pairs from an sql query.
final int	DBUtils.queryOptionList(DBCommandExpr cmd, Options options)	Fills an option list provided with the result from a query.
final <T> List<T>	DBUtils.querySimpleList(Class<T> c, DBCommandExpr cmd)	Returns a one dimensional array from an sql query.
final <T> int	DBUtils.querySimpleList(Class<T> c, DBCommandExpr cmd, Collection<T> result)	Adds the first column of a query result to a collection.
final List<Object>	DBUtils.querySimpleList(DBCommandExpr cmd)	Returns a one dimensional array from an sql query.
final int	DBUtils.querySingleInt(DBCommandExpr cmd)	Returns the value of the first row/column of a sql-query as an int.
final int	DBUtils.querySingleInt(DBCommandExpr cmd, int defaultValue)	Returns the value of the first row/column of a sql-query as an int.
final long	DBUtils.querySingleLong(DBCommandExpr cmd)	Returns the value of the first row/column of a sql-query as a long.
final long	DBUtils.querySingleLong(DBCommandExpr cmd, long defaultValue)	Returns the value of the first row/column of a sql-query as a long.
final Object[]	DBUtils.querySingleRow(DBCommandExpr cmd)	Returns all values of the first row of a sql-query as an array.
final Object[]	DBUtils.querySingleRow(DBCommandExpr cmd, boolean failOnNoResult)	Returns all values of the first row of a sql-query as an array.
final String	DBUtils.querySingleString(DBCommandExpr cmd)	Returns the value of the first row/column of a sql-query as a string.
final String	DBUtils.querySingleString(DBCommandExpr cmd, String defaultValue)	Returns the value of the first row/column of a sql-query as a string.
final Object	DBUtils.querySingleValue(DBCommandExpr cmd)	Returns the value of the first row/column of a sql-query as an object.
final Object	DBUtils.querySingleValue(DBCommandExpr cmd, boolean failOnNoResult)	Returns the value of the first row/column of a sql-query as an object.
final <T> T	DBUtils.querySingleValue(DBCommandExpr cmd, Class<T> resultType, boolean failOnNoResult)	Returns the value of the first row/column of a sql-query as an object.
DBCommandExpr	DBCommandExpr.union(DBCommandExpr other)	Constructs a new DBCombinedCmd object with this object, the key word= "UNION" and the selected DBCommandExpr.
DBCommandExpr	DBCommandExpr.unionAll(DBCommandExpr other)	Constructs a new DBCombinedCmd object with this object, the key word= "UNION ALL" and the selected DBCommandExpr.

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

Modifier	Constructor	Description
	DBCmdQuery(DBCommandExpr cmd, DBDatabase db, DBColumnExpr[] exprList)	Creates a new DBCmdQueryObject
	DBCombinedCmd(DBCommandExpr left, String keyWord, DBCommandExpr right)	Constructs a new DBFuncExpr object and sets the specified parameters to this object.
	DBQuery(DBCommandExpr cmd)	Creates a DBQuery object from a given command object.
	DBQuery(DBCommandExpr cmd, String alias)	Creates a DBQuery object from a given command object.
	DBQuery(DBCommandExpr cmd, DBColumn keyColumn)	Constructs a new DBQuery object initialize the query object.
	DBQuery(DBCommandExpr cmd, DBColumn[] keyColumns)	Constructor initializes the query object.
	DBQuery(DBCommandExpr cmd, DBColumn[] keyColumns, String alias)	Constructor initializes the query object.
	DBQuery(DBCommandExpr cmd, DBColumn keyColumn, String alias)	Constructs a new DBQuery object initialize the query object.

Uses of DBCommandExpr in org.apache.empire.db.exceptions

Constructors in org.apache.empire.db.exceptions with parameters of type DBCommandExpr

Modifier	Constructor	Description
	CommandWithoutSelectException(DBCommandExpr cmd)

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

Constructors in org.apache.empire.db.expr.column with parameters of type DBCommandExpr

Modifier	Constructor	Description
	DBCmdResultExpr(DBCommandExpr cmdExpr)

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

Fields in org.apache.empire.db.expr.compare declared as DBCommandExpr

Modifier and Type	Field	Description
final DBCommandExpr	DBExistsExpr.cmd

Constructors in org.apache.empire.db.expr.compare with parameters of type DBCommandExpr

Modifier	Constructor	Description
	DBExistsExpr(DBCommandExpr cmd)	Constructs a DBExistsExpr object set the specified parameters to this object.
	DBExistsExpr(DBCommandExpr cmd, DBCompareExpr compareExpr)	Constructs a DBExistsExpr object set the specified parameters to this object.

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

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

Modifier and Type	Method	Description
void	DBBeanListFactory.prepareQuery(DBCommandExpr cmd, DBContext context)
void	DBBeanListFactoryImpl.prepareQuery(DBCommandExpr cmd, DBContext context)

Uses of DBCommandExpr in org.apache.empire.dbms

Subclasses of DBCommandExpr 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 DBCommandExpr

Modifier and Type	Method	Description
DBCommandExpr	DBMSHandler.createCombinedCommand(DBCommandExpr left, String keyWord, DBCommandExpr right)	This function gives the dbms a chance to provide a custom implementation for a combined command such as UNION or INTERSECT
DBCommandExpr	DBMSHandlerBase.createCombinedCommand(DBCommandExpr left, String keyWord, DBCommandExpr right)	This function gives the dbms a chance to provide a custom implementation for a combined command such as UNION or INTERSECT

Methods in org.apache.empire.dbms with parameters of type DBCommandExpr

Modifier and Type	Method	Description
DBCommandExpr	DBMSHandler.createCombinedCommand(DBCommandExpr left, String keyWord, DBCommandExpr right)	This function gives the dbms a chance to provide a custom implementation for a combined command such as UNION or INTERSECT
DBCommandExpr	DBMSHandlerBase.createCombinedCommand(DBCommandExpr left, String keyWord, DBCommandExpr right)	This function gives the dbms a chance to provide a custom implementation for a combined command such as UNION or INTERSECT

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

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

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

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

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

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

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

Subclasses of DBCommandExpr 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 DBCommandExpr

Modifier and Type	Method	Description
DBCommandExpr	DBMSHandlerMySQL.createCombinedCommand(DBCommandExpr left, String keyWord, DBCommandExpr right)

Methods in org.apache.empire.dbms.mysql with parameters of type DBCommandExpr

Modifier and Type	Method	Description
DBCommandExpr	DBMSHandlerMySQL.createCombinedCommand(DBCommandExpr left, String keyWord, DBCommandExpr right)

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

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

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

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

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

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

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

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

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

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

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

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