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

Packages that use DBExpr

Package	Description
org.apache.empire.db	This package contains the core Empire-DB implementation classes.
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.order
org.apache.empire.db.expr.set	This package contains SQL-generator classes for set expressions used in the set clause.
org.apache.empire.db.generic
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 DBExpr in org.apache.empire.db

Subclasses of DBExpr in org.apache.empire.db

Modifier and Type	Class	Description
class	DBCmdParam	This class defines a parameter for a prepared statement query.
class	DBColumn	This is the base class for all database columns that have a physical representation.
class	DBColumnExpr	This class is the base class for all expressions that represent a single value.
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.
class	DBCommandExpr	This abstract class handles the creation of the SQL-Commands.
protected static class	DBCommandExpr.DBCmdColumn	This class wraps a column of sql command in a special command column object.
protected static class	DBCommandExpr.DBCmdQuery
class	DBGeneratedValue	DBGeneratedValue Abstract base class for Auto generated values
static class	DBGeneratedValue.DBFuncGeneratedValue	DBFuncGeneratedValue Auto-generates a record value from other record fields The template must contain the column names wrapped in square brackets like e.g.
static class	DBGeneratedValue.DBTriggerGeneratedValue	DBTriggerGeneratedValue Value is generated by Trigger
class	DBQuery	This class can be used to wrap a query from a DBCommand and use it like a DBRowSet. You may use this class for two purposes: In oder to define subqueries simply define a command object with the subquery and wrap it inside a DBQuery.
class	DBQueryColumn
class	DBRowSet	This class is the base class for all the DBTable, DBView and DBQuery classes this class contains all the columns of the tables, views or queries
class	DBTable	This class represent one table of the database.
class	DBTableColumn	This class represent one column of a table.
class	DBView	This class represents a database view.
static class	DBView.DBViewColumn	DBViewColumn

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

Modifier and Type	Method	Description
final DBCompareColExpr	DBColumnExpr.in(DBExpr expr)	Creates and returns an expression for the SQL "not in" operator.
final DBFuncExpr	DBColumnExpr.indexOf(Object str, DBExpr fromPos)	Creates and returns a sql-expression that returns the position of a string in the current column expression.
final DBCompareColExpr	DBColumnExpr.notIn(DBExpr expr)	Creates and returns an expression for the SQL "not in" operator.
DBFuncExpr	DBColumnExpr.substring(int pos, DBExpr count)	Overloaded.
final DBFuncExpr	DBColumnExpr.substring(DBExpr pos)	Creates and returns a sql-expression for the substring(...) function.
DBFuncExpr	DBColumnExpr.substring(DBExpr pos, int count)	Overloaded.
final DBFuncExpr	DBColumnExpr.substring(DBExpr pos, DBExpr count)	Creates and returns a sql-expression for the substring(...) function.

Method parameters in org.apache.empire.db with type arguments of type DBExpr

Modifier and Type	Method	Description
protected void	DBCommandExpr.addListExpr(DBSQLBuilder sql, List<? extends DBExpr> list, long context, String separator)	Internally used to build a string from a list of database expressions

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

Subclasses of DBExpr in org.apache.empire.db.expr.column

Modifier and Type	Class	Description
class	DBAbstractFuncExpr	This implements some basic functionality for SQL functions based on a column expression
class	DBAliasExpr	This class allows column renaming in SQL.
class	DBCalcExpr	This class is used for performing calculations in SQL It handles the mathematical operations ("+", "-", "*", "/") for the current column.
class	DBCaseExpr	This class represents a SQL case expression like "case when ?
class	DBCaseMapExpr	This class is used to create a SQL CASE constraint in the form of case {expr} when {value1} then {result1} when {value2} then {result2} ...
class	DBCaseWhenExpr	This class is used to create a SQL CASE constraint in the form of case when {cond1} then {result1} when {cond2} then {result2} ...
class	DBCmdResultExpr
class	DBCoalesceExpr
class	DBConcatExpr	This class is used for performing string concatenation in SQL
class	DBConcatFuncExpr	DBConcatExpression
class	DBConvertExpr	This class is used to convert a value to a different data type.
class	DBCountExpr	This class is used to add the "count" statement to the SQL-Command.
class	DBDecodeExpr	This class is used to decode a set of keys to the corresponding target values.
class	DBFuncExpr	This class is used for performing various SQL functions on a column or column expression.
class	DBParenthesisExpr	This class allows column renaming in SQL.
class	DBScalarExpr	This class is used for declaring scalar functions in SQL (like e.g. random).
class	DBValueExpr	This class is used for declaring constant values in SQL.
class	DBVarArgsFuncExpr

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

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 DBExpr in org.apache.empire.db.expr.compare

Subclasses of DBExpr in org.apache.empire.db.expr.compare

Modifier and Type	Class	Description
class	DBCompareAndOrExpr	This class is used for combining two filter constraints by and / or operator
class	DBCompareColExpr	This class is used for defining filter constraints based on a column expression in SQL
class	DBCompareExpr	This class is a common base class for all SQL filter constraints classes
class	DBCompareNotExpr	This class is used for defining filter constraints based on a column expression in SQL
class	DBCompareParenthesisExpr	This class wraps an existing compare expression with parenthesis.
class	DBExistsExpr	This class is used for building up the SQL-Command for the EXISTS syntax.

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

Modifier and Type	Method	Description
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 DBExpr in org.apache.empire.db.expr.join

Subclasses of DBExpr in org.apache.empire.db.expr.join

Modifier and Type	Class	Description
class	DBColumnJoinExpr
class	DBCompareJoinExpr	This class is used for building a join expression of an SQL statement.
class	DBCrossJoinExpr	This class is used for building a join expression of an SQL statement.
class	DBJoinExpr	This class is used for building a join expression of an SQL statement.

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

Modifier and Type	Method	Description
void	DBColumnJoinExpr.prepareParams(DBCommand cmd, DBExpr parent)
void	DBCompareJoinExpr.prepareParams(DBCommand cmd, DBExpr parent)
void	DBCrossJoinExpr.prepareParams(DBCommand cmd, DBExpr parent)

Uses of DBExpr in org.apache.empire.db.expr.order

Subclasses of DBExpr in org.apache.empire.db.expr.order

Modifier and Type	Class	Description
class	DBOrderByExpr

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

Subclasses of DBExpr in org.apache.empire.db.expr.set

Modifier and Type	Class	Description
class	DBSetExpr	This class is used for building a set expression of a SQL update statement.

Uses of DBExpr in org.apache.empire.db.generic

Subclasses of DBExpr in org.apache.empire.db.generic

Modifier and Type	Class	Description
class	TTable<DB extends TDatabase<DB>>
class	TView<DB extends TDatabase<DB>>

Uses of DBExpr in org.apache.empire.dbms

Subclasses of DBExpr in org.apache.empire.dbms

Modifier and Type	Class	Description
static final class	DBMSHandlerBase.DBMSCommand	DBMSCommand A Default DBCommand implementation with no additional features
static class	DBMSHandlerBase.DBSeqTable	This class is used to emulate sequences by using a sequence table.

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

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

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

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

Subclasses of DBExpr 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 DBExpr in org.apache.empire.dbms.mysql

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

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

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

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

Modifier and Type	Class	Description
class	DBCommandOracle	This class handles the special features of an oracle database.
class	OracleRowNumExpr	implements a column expression for the Oracle rownum function
static class	OracleSYSDatabase.DBColComments
static class	OracleSYSDatabase.DBColInfo
static class	OracleSYSDatabase.DBConstraints
static class	OracleSYSDatabase.DBTabComments
static class	OracleSYSDatabase.DBUserConCol

Methods in org.apache.empire.dbms.oracle with parameters of type DBExpr

Modifier and Type	Method	Description
protected void	OracleDDLGenerator.createComment(DBDatabase db, String type, DBExpr expr, String comment, DBSQLScript script)

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

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

Modifier and Type	Class	Description
class	DBCommandPostgres	Defines the PostgreSQL command type.
class	PostgresAtAt	PostgresAtAt create a Postgres @@ comparator
class	PostgresBoolAndOrExpr
class	PostgresFuncExpr
class	PostgresIntervalExpr

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

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

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

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

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

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

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

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