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

Packages that use DBSQLBuilder

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.dbms
org.apache.empire.dbms.derby	This package contains classes necessary to support the Apache Derby database system.
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.sqlserver	This package contains classes necessary to support the Microsoft SQL-Server database system.

Uses of DBSQLBuilder in org.apache.empire.db

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

Modifier and Type	Method	Description
DBSQLBuilder	DBSQLBuilder.append(char c)
DBSQLBuilder	DBSQLBuilder.append(double d)
DBSQLBuilder	DBSQLBuilder.append(long l)
DBSQLBuilder	DBSQLBuilder.append(CharSequence sqlLiteral)
DBSQLBuilder	DBSQLBuilder.append(CharSequence sqlLiteral, int start, int end)
DBSQLBuilder	DBSQLBuilder.append(DBSqlPhrase phrase)
protected DBSQLBuilder	DBCombinedCmd.createSQLBuilder(String initalSQL)
protected DBSQLBuilder	DBCommand.createSQLBuilder(String initalSQL)
protected DBSQLBuilder	DBCommandExpr.createSQLBuilder(String initalSQL)	creates a new DBSQLBuilder

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

Modifier and Type	Method	Description
protected void	DBDDLGenerator.addAlterTableStmt(DBColumn col, DBSQLBuilder sql, DBSQLScript script)
protected void	DBDDLGenerator.addCreateIndexStmt(DBIndex index, DBSQLBuilder sql, DBSQLScript script)
protected void	DBDDLGenerator.addCreateRelationStmt(DBRelation rel, DBSQLBuilder sql, DBSQLScript script)
protected void	DBDDLGenerator.addCreateTableStmt(DBTable table, DBSQLBuilder sql, DBSQLScript script)
protected void	DBDDLGenerator.addCreateViewStmt(DBView v, DBSQLBuilder sql, DBSQLScript script)
protected void	DBCommand.addDeleteForTable(DBSQLBuilder sql, DBRowSet table)
protected void	DBCommand.addDeleteWithJoins(DBSQLBuilder sql, DBRowSet table)
protected void	DBCommand.addFrom(DBSQLBuilder sql)
protected void	DBCommand.addGrouping(DBSQLBuilder sql)
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
protected void	DBCommand.addOrder(DBSQLBuilder sql)
protected void	DBCommand.addSelect(DBSQLBuilder sql)
void	DBCmdParam.addSQL(DBSQLBuilder sql, long context)
void	DBColumn.addSQL(DBSQLBuilder sql, long context)	Adds the colunm name to the SQL-Command.
void	DBCommandExpr.addSQL(DBSQLBuilder sql, long context)	Creates the SQL-Command.
void	DBCommandExpr.DBCmdColumn.addSQL(DBSQLBuilder sql, long context)	create the SQL-Command set the expression name to the SQL-Command
void	DBCommandExpr.DBCmdQuery.addSQL(DBSQLBuilder sql, long context)	Creates the SQL-Command adds the select statement into the SQL-Command.
abstract void	DBExpr.addSQL(DBSQLBuilder sql, long context)	Used to build the SQL command.
void	DBGeneratedValue.DBFuncGeneratedValue.addSQL(DBSQLBuilder sql, long context)
void	DBGeneratedValue.DBTriggerGeneratedValue.addSQL(DBSQLBuilder sql, long context)
void	DBQuery.addSQL(DBSQLBuilder sql, long context)	Adds the select SQL Command of this object to the specified StringBuilder object.
void	DBTable.addSQL(DBSQLBuilder sql, long context)	Adds the table's name to the supplied sql command buffer.
void	DBView.addSQL(DBSQLBuilder sql, long context)	Creates the SQL-Command adds the alias name to the SQL-Command.
final void	DBSQLScript.addStmt(DBSQLBuilder sql)	Adds a statement to the script. The supplied StringBuilder will be reset to a length of 0
protected void	DBCommand.addUpdateForTable(DBSQLBuilder sql, DBRowSet table)
protected void	DBCommand.addUpdateWithJoins(DBSQLBuilder sql, DBRowSet table)
protected final void	DBCommand.addWhere(DBSQLBuilder sql)
protected void	DBCommand.addWhere(DBSQLBuilder sql, long context)
protected boolean	DBDDLGenerator.appendColumnDataType(DataType type, double size, DBTableColumn c, DBSQLBuilder sql)	appends the data type of a column
protected void	DBDDLGenerator.appendColumnDesc(DBTableColumn c, boolean alter, DBSQLBuilder sql)	Appends a table column definition to a ddl statement
protected void	DBDDLGenerator.appendElementName(DBSQLBuilder sql, String name)
protected void	DBDDLGenerator.appendIndexColumn(DBIndex index, DBColumnExpr idxColumn, DBSQLBuilder sql)	Appends an column expression to an index
protected void	DBDDLGenerator.appendIndexType(DBIndex index, DBSQLBuilder sql)	Appends the index type when creating an index
void	DBDatabase.appendQualifiedName(DBSQLBuilder sql, String name, Boolean quoteName)	Adds a full qualified object name including schema prefix and database link postfix (if any).
void	DBCombinedCmd.getSelect(DBSQLBuilder sql, int flags)	Creates the SQL-Command.
void	DBCommand.getSelect(DBSQLBuilder sql, int flags)	Creates a select SQL-Statement
abstract void	DBCommandExpr.getSelect(DBSQLBuilder sql, int flags)	returns an SQL select command

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

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

Modifier and Type	Method	Description
void	DBDecodeExpr.addDecodeParts(DBSQLBuilder sql)
final void	DBAbstractFuncExpr.addSQL(DBSQLBuilder sql, String template, Object[] params, long context)	Creates the SQL-Command adds a function to the SQL-Command.
void	DBAliasExpr.addSQL(DBSQLBuilder sql, long context)	Creates the SQL-Command adds the alias name to the SQL-Command.
void	DBCalcExpr.addSQL(DBSQLBuilder sql, long context)	Creates the SQL-Command adds the mathematical operations for the specified DBColumnExpr object and value to the.
void	DBCaseMapExpr.addSQL(DBSQLBuilder sql, long context)
void	DBCaseWhenExpr.addSQL(DBSQLBuilder sql, long context)
void	DBCmdResultExpr.addSQL(DBSQLBuilder sql, long context)
void	DBCoalesceExpr.addSQL(DBSQLBuilder sql, long context)
void	DBConcatExpr.addSQL(DBSQLBuilder sql, long context)	Creates the SQL-Command concatenate a specified column with a specified value sets the column with a specified value to the SQL-Command.
void	DBConcatFuncExpr.addSQL(DBSQLBuilder sql, long context)
void	DBConvertExpr.addSQL(DBSQLBuilder sql, long context)
void	DBCountExpr.addSQL(DBSQLBuilder sql, long context)	Creates the SQL-Command adds the String "count(*)" to the SQL-Command.
void	DBDecodeExpr.addSQL(DBSQLBuilder sql, long context)
void	DBFuncExpr.addSQL(DBSQLBuilder sql, long context)	Creates the SQL-Command adds a function to the SQL-Command.
void	DBParenthesisExpr.addSQL(DBSQLBuilder sql, long context)	Creates the SQL-Command adds the alias name to the SQL-Command.
void	DBScalarExpr.addSQL(DBSQLBuilder sql, long context)	Creates the SQL-Command.
void	DBValueExpr.addSQL(DBSQLBuilder sql, long context)	Creates the SQL-Command.
void	DBVarArgsFuncExpr.addSQL(DBSQLBuilder sql, long context)

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

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

Modifier and Type	Method	Description
void	DBCompareColExpr.addCompareExpr(DBSQLBuilder sql, long context)	Add the comparison operator and value to the SQL-Command.
void	DBCompareAndOrExpr.addSQL(DBSQLBuilder sql, long context)	Creates the SQL-Command sets the specified compare value (the varible boolOP) between the two DBCompareExpr objects.
void	DBCompareColExpr.addSQL(DBSQLBuilder sql, long context)	Creates the SQL-Command.
void	DBCompareNotExpr.addSQL(DBSQLBuilder sql, long context)	Creates the SQL-Command sets the specified compare value (the varible boolOP) between the two DBCompareExpr objects.
void	DBCompareParenthesisExpr.addSQL(DBSQLBuilder sql, long context)
void	DBExistsExpr.addSQL(DBSQLBuilder sql, long context)	Creates the SQL-Command.

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

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

Modifier and Type	Method	Description
void	DBColumnJoinExpr.addSQL(DBSQLBuilder sql, long context)	Not allowed, this operation have to be done in the DBCommand object.
void	DBCompareJoinExpr.addSQL(DBSQLBuilder sql, long context)
void	DBCrossJoinExpr.addSQL(DBSQLBuilder sql, long context)	Not allowed, this operation have to be done in the DBCommand object.

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

Methods in org.apache.empire.db.expr.order with parameters of type DBSQLBuilder

Modifier and Type	Method	Description
void	DBOrderByExpr.addSQL(DBSQLBuilder sql, long context)	Adds a column expression to the orderBy clause followed by the desc keyword if the order should be descending

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

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

Modifier and Type	Method	Description
void	DBSetExpr.addSQL(DBSQLBuilder sql, long context)	Creates the SQL-Command.

Uses of DBSQLBuilder in org.apache.empire.dbms

Subclasses of DBSQLBuilder in org.apache.empire.dbms

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

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

Modifier and Type	Method	Description
DBSQLBuilder	DBMSHandler.createSQLBuilder()	This function creates a DBSQLBuilder for this DBMS
DBSQLBuilder	DBMSHandlerBase.createSQLBuilder()	This function creates a DBSQLBuilder for this DBMS

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

Modifier and Type	Method	Description
void	DBMSHandler.appendObjectName(DBSQLBuilder sql, String name, Boolean useQuotes)	Appends a table, view or column name to an SQL phrase.
void	DBMSHandlerBase.appendObjectName(DBSQLBuilder sql, String name, Boolean useQuotes)	Appends a table, view or column name to an SQL phrase.

Uses of DBSQLBuilder in org.apache.empire.dbms.derby

Methods in org.apache.empire.dbms.derby with parameters of type DBSQLBuilder

Modifier and Type	Method	Description
protected boolean	DerbyDDLGenerator.appendColumnDataType(DataType type, double size, DBTableColumn c, DBSQLBuilder sql)
protected void	DerbyDDLGenerator.appendColumnDesc(DBTableColumn c, boolean alter, DBSQLBuilder sql)

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

Methods in org.apache.empire.dbms.h2 with parameters of type DBSQLBuilder

Modifier and Type	Method	Description
protected boolean	H2DDLGenerator.appendColumnDataType(DataType type, double size, DBTableColumn c, DBSQLBuilder sql)
void	DBMSHandlerH2.DBCommandH2.getSelect(DBSQLBuilder sql, int flags)

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

Methods in org.apache.empire.dbms.hsql with parameters of type DBSQLBuilder

Modifier and Type	Method	Description
protected void	DBCommandHSql.addUpdateWithJoins(DBSQLBuilder sql, DBRowSet table)
void	DBCommandHSql.getSelect(DBSQLBuilder sql, int flags)

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

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

Modifier and Type	Class	Description
static class	DBMSHandlerMySQL.DBSQLBuilderMySQL	Provides a DBSQLBuilder implementation for MySQL

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

Modifier and Type	Method	Description
DBSQLBuilder	DBMSHandlerMySQL.createSQLBuilder()	Creates a new MySQL SQL-Builder.

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

Modifier and Type	Method	Description
protected void	DBMSHandlerMySQL.DBCommandMySQL.addDeleteWithJoins(DBSQLBuilder sql, DBRowSet table)
protected boolean	MySQLDDLGenerator.appendColumnDataType(DataType type, double size, DBTableColumn c, DBSQLBuilder sql)
void	DBMSHandlerMySQL.DBCommandMySQL.getSelect(DBSQLBuilder sql, int flags)

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

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

Modifier and Type	Method	Description
protected void	OracleDDLGenerator.addCreateIndexStmt(DBIndex index, DBSQLBuilder sql, DBSQLScript script)
protected void	OracleDDLGenerator.addCreateTableStmt(DBTable table, DBSQLBuilder sql, DBSQLScript script)
protected void	OracleDDLGenerator.addCreateViewStmt(DBView v, DBSQLBuilder sql, DBSQLScript script)
protected void	DBCommandOracle.addDeleteForTable(DBSQLBuilder sql, DBRowSet table)
protected void	DBCommandOracle.addDeleteWithJoins(DBSQLBuilder sql, DBRowSet table)
void	OracleRowNumExpr.addSQL(DBSQLBuilder sql, long context)	Creates the SQL-Command.
protected void	DBCommandOracle.addUpdateForTable(DBSQLBuilder sql, DBRowSet table)
protected void	DBCommandOracle.addUpdateWithJoins(DBSQLBuilder sql, DBRowSet table)
protected boolean	OracleDDLGenerator.appendColumnDataType(DataType type, double size, DBTableColumn c, DBSQLBuilder sql)
protected void	OracleDDLGenerator.appendColumnDesc(DBTableColumn c, boolean alter, DBSQLBuilder sql)
protected void	OracleDDLGenerator.appendIndexColumn(DBIndex index, DBColumnExpr idxColumn, DBSQLBuilder sql)
void	DBCommandOracle.getSelect(DBSQLBuilder sql, int flags)	Creates an Oracle specific select statement that supports special features of the Oracle DBMS like e.g.

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

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

Modifier and Type	Method	Description
void	PostgresAtAt.addSQL(DBSQLBuilder sql, long context)
void	PostgresBoolAndOrExpr.addSQL(DBSQLBuilder sql, long context)
void	PostgresFuncExpr.addSQL(DBSQLBuilder sql, long context)	Creates the SQL-Command adds a function to the SQL-Command.
void	PostgresIntervalExpr.addSQL(DBSQLBuilder sql, long context)
protected void	DBCommandPostgres.addUpdateWithJoins(DBSQLBuilder sql, DBRowSet table)
protected boolean	PostgresDDLGenerator.appendColumnDataType(DataType type, double size, DBTableColumn c, DBSQLBuilder sql)
protected void	PostgresDDLGenerator.appendColumnDesc(DBTableColumn c, boolean alter, DBSQLBuilder sql)
void	DBCommandPostgres.getSelect(DBSQLBuilder sql, int flags)

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

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

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

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

Modifier and Type	Method	Description
DBSQLBuilder	DBMSHandlerMSSQL.createSQLBuilder()	Creates a new Microsoft SQL-Server SQL-Builder.

Methods in org.apache.empire.dbms.sqlserver with parameters of type DBSQLBuilder

Modifier and Type	Method	Description
protected void	MSSqlDDLGenerator.addCreateIndexStmt(DBIndex index, DBSQLBuilder sql, DBSQLScript script)
protected void	MSSqlDDLGenerator.addCreateViewStmt(DBView v, DBSQLBuilder sql, DBSQLScript script)
protected void	DBMSHandlerMSSQL.DBCommandMSSQL.addSelect(DBSQLBuilder sql)
protected boolean	MSSqlDDLGenerator.appendColumnDataType(DataType type, double size, DBTableColumn c, DBSQLBuilder sql)
protected void	MSSqlDDLGenerator.appendIndexType(DBIndex index, DBSQLBuilder sql)
void	DBMSHandlerMSSQL.DBCommandMSSQL.getSelect(DBSQLBuilder sql, int flags)