Uses of Class
com.ontimize.db.SQLStatementBuilder.SQLStatement

Packages that use SQLStatementBuilder.SQLStatement

Package	Description
com.ontimize.db
com.ontimize.db.handler
com.ontimize.gui.i18n

Uses of SQLStatementBuilder.SQLStatement in com.ontimize.db

Methods in com.ontimize.db that return SQLStatementBuilder.SQLStatement

Modifier and Type	Method and Description
static SQLStatementBuilder.SQLStatement	SQLStatementBuilder.createCountQuery(String table, Hashtable conditions, Vector wildcards, Vector countColumns) Returns a SQLStatement class that stores the information needed to execute a query that obtains the number of query records
static SQLStatementBuilder.SQLStatement	SQLStatementBuilder.createDeleteQuery(String table, Hashtable keysValues) Returns a SQLStatement class that stores the information needed to execute a delete query.
static SQLStatementBuilder.SQLStatement	SQLStatementBuilder.createInsertQuery(String table, Hashtable attributes) Returns a SQLStatement class that stores the information needed to execute a insert query.
static SQLStatementBuilder.SQLStatement	SQLStatementBuilder.createJoinSelectQuery(String principalTable, String secondaryTable, Vector principalKeys, Vector secondaryKeys, Vector principalTableRequestedColumns, Vector secondaryTableRequestedColumns, Hashtable principalTableConditions, Hashtable secondaryTableConditions, Vector wildcards, Vector columnSorting, boolean forceDistinct) Returns a SQLStatement class that stores the information needed to execute a select query against two table used a join.
static SQLStatementBuilder.SQLStatement	SQLStatementBuilder.createJoinSelectQuery(String mainTable, String secondaryTable, Vector mainKeys, Vector secondaryKeys, Vector mainTableRequestedColumns, Vector secondaryTableRequestedColumns, Hashtable mainTableConditions, Hashtable secondaryTableConditions, Vector wildcards, Vector columnSorting, boolean forceDistinct, boolean descending) Returns a SQLStatement class that stores the information needed to execute a select query against two table used a join.
static SQLStatementBuilder.SQLStatement	SQLStatementBuilder.createSelectQuery(String table, Vector requestedColumns, Hashtable conditions, Vector wildcards) Returns a SQLStatement class that stores the information needed to execute a select query.
static SQLStatementBuilder.SQLStatement	SQLStatementBuilder.createSelectQuery(String table, Vector requestedColumns, Hashtable conditions, Vector wildcards, Vector columnSorting) Returns a SQLStatement class that stores the information needed to execute a select query.
static SQLStatementBuilder.SQLStatement	SQLStatementBuilder.createSelectQuery(String table, Vector requestedColumns, Hashtable conditions, Vector wildcards, Vector columnSorting, boolean descending) Returns a SQLStatement class that stores the information needed to execute a select query.
static SQLStatementBuilder.SQLStatement	SQLStatementBuilder.createSelectQuery(String table, Vector requestedColumns, Hashtable conditions, Vector wildcards, Vector columnSorting, boolean descending, boolean forceDistinct) Returns a SQLStatement class that stores the information needed to execute a select query.
static SQLStatementBuilder.SQLStatement	SQLStatementBuilder.createSelectQuery(String table, Vector requestedColumns, Hashtable conditions, Vector wildcards, Vector columnSorting, int recordCount) Returns a SQLStatement class that stores the information needed to execute a select query.
static SQLStatementBuilder.SQLStatement	SQLStatementBuilder.createSelectQuery(String table, Vector requestedColumns, Hashtable conditions, Vector wildcards, Vector columnSorting, int recordCount, boolean descending) Returns a SQLStatement class that stores the information needed to execute a select query.
static SQLStatementBuilder.SQLStatement	SQLStatementBuilder.createSelectQuery(String table, Vector requestedColumns, Hashtable conditions, Vector wildcards, Vector columnSorting, int recordCount, boolean descending, boolean forceDistinct) Returns a SQLStatement class that stores the information needed to execute a select query.
static SQLStatementBuilder.SQLStatement	SQLStatementBuilder.createUpdateQuery(String table, Hashtable attributesValues, Hashtable keysValues) Returns a SQLStatement class that stores the information needed to execute a update query.

Uses of SQLStatementBuilder.SQLStatement in com.ontimize.db.handler

Methods in com.ontimize.db.handler that return SQLStatementBuilder.SQLStatement

Modifier and Type	Method and Description
SQLStatementBuilder.SQLStatement	SQLStatementHandler.createCountQuery(String table, Hashtable conditions, Vector wildcards, Vector countColumns)
SQLStatementBuilder.SQLStatement	SQLServerSQLStatementHandler.createCountQuery(String table, Hashtable conditions, Vector wildcards, Vector countColumns)
SQLStatementBuilder.SQLStatement	DefaultSQLStatementHandler.createCountQuery(String table, Hashtable conditions, Vector wildcards, Vector countColumns) Returns a SQLStatement class that stores the information needed to execute a query that obtains the number of query records
SQLStatementBuilder.SQLStatement	SQLStatementHandler.createDeleteQuery(String table, Hashtable keysValues)
SQLStatementBuilder.SQLStatement	DefaultSQLStatementHandler.createDeleteQuery(String table, Hashtable keysValues) Returns a SQLStatement class that stores the information needed to execute a delete query.
SQLStatementBuilder.SQLStatement	SQLStatementHandler.createInsertQuery(String table, Hashtable attributes)
SQLStatementBuilder.SQLStatement	DefaultSQLStatementHandler.createInsertQuery(String table, Hashtable attributes) Returns a SQLStatement class that stores the information needed to execute a insert query.
SQLStatementBuilder.SQLStatement	SQLStatementHandler.createJoinFromSubselectsQuery(String primaryAlias, String secondaryAlias, String primaryQuery, String secondaryQuery, Vector primaryKeys, Vector secondaryKeys, Vector primaryTableRequestedColumns, Vector secondaryTableRequestedColumns, Hashtable primaryTableConditions, Hashtable secondaryTableConditions, Vector wildcards, Vector columnSorting, boolean forceDistinct, boolean descending)
SQLStatementBuilder.SQLStatement	DefaultSQLStatementHandler.createJoinFromSubselectsQuery(String primaryAlias, String secondaryAlias, String primaryQuery, String secondaryQuery, Vector primaryKeys, Vector secondaryKeys, Vector primaryTableRequestedColumns, Vector secondaryTableRequestedColumns, Hashtable primaryTableConditions, Hashtable secondaryTableConditions, Vector wildcards, Vector columnSorting, boolean forceDistinct, boolean descending) Returns a SQLStatement class that stores the information needed to execute a select query against two subselects used a join.
SQLStatementBuilder.SQLStatement	SQLStatementHandler.createJoinSelectQuery(String principalTable, String secondaryTable, Vector principalKeys, Vector secondaryKeys, Vector principalTableRequestedColumns, Vector secondaryTableRequestedColumns, Hashtable principalTableConditions, Hashtable secondaryTableConditions, Vector wildcards, Vector columnSorting, boolean forceDistinct)
SQLStatementBuilder.SQLStatement	DefaultSQLStatementHandler.createJoinSelectQuery(String principalTable, String secondaryTable, Vector principalKeys, Vector secondaryKeys, Vector principalTableRequestedColumns, Vector secondaryTableRequestedColumns, Hashtable principalTableConditions, Hashtable secondaryTableConditions, Vector wildcards, Vector columnSorting, boolean forceDistinct) This class provides a implementation of the SQLConditionValuesProcessor interface.
SQLStatementBuilder.SQLStatement	SQLStatementHandler.createJoinSelectQuery(String mainTable, String secondaryTable, Vector mainKeys, Vector secondaryKeys, Vector mainTableRequestedColumns, Vector secondaryTableRequestedColumns, Hashtable mainTableConditions, Hashtable secondaryTableConditions, Vector wildcards, Vector columnSorting, boolean forceDistinct, boolean descending)
SQLStatementBuilder.SQLStatement	DefaultSQLStatementHandler.createJoinSelectQuery(String mainTable, String secondaryTable, Vector mainKeys, Vector secondaryKeys, Vector mainTableRequestedColumns, Vector secondaryTableRequestedColumns, Hashtable mainTableConditions, Hashtable secondaryTableConditions, Vector wildcards, Vector columnSorting, boolean forceDistinct, boolean descending) Returns a SQLStatement class that stores the information needed to execute a select query against two table used a join.
SQLStatementBuilder.SQLStatement	SQLStatementHandler.createLeftJoinSelectQuery(String mainTable, String subquery, String secondaryTable, Vector mainKeys, Vector secondaryKeys, Vector mainTableRequestedColumns, Vector secondaryTableRequestedColumns, Hashtable mainTableConditions, Hashtable secondaryTableConditions, Vector wildcards, Vector columnSorting, boolean forceDistinct, boolean descending)
SQLStatementBuilder.SQLStatement	DefaultSQLStatementHandler.createLeftJoinSelectQuery(String mainTable, String subquery, String secondaryTable, Vector mainKeys, Vector secondaryKeys, Vector mainTableRequestedColumns, Vector secondaryTableRequestedColumns, Hashtable mainTableConditions, Hashtable secondaryTableConditions, Vector wildcards, Vector columnSorting, boolean forceDistinct, boolean descending) Returns a SQLStatement class that stores the information needed to execute a select query against two table used a left join.
protected SQLStatementBuilder.SQLStatement	SQLServerSQLStatementHandler.createLeftJoinSelectQueryPageable(String mainTable, String subquery, String secondaryTable, Vector mainKeys, Vector secondaryKeys, Vector mainTableRequestedColumns, Vector secondaryTableRequestedColumns, Hashtable mainTableConditions, Hashtable secondaryTableConditions, Vector wildcards, Vector columnSorting, boolean forceDistinct, boolean descending, int recordCount)
protected SQLStatementBuilder.SQLStatement	OracleSQLStatementHandler.createLeftJoinSelectQueryPageable(String mainTable, String subquery, String secondaryTable, Vector mainKeys, Vector secondaryKeys, Vector mainTableRequestedColumns, Vector secondaryTableRequestedColumns, Hashtable mainTableConditions, Hashtable secondaryTableConditions, Vector wildcards, Vector columnSorting, boolean forceDistinct, boolean descending, int recordCount)
protected SQLStatementBuilder.SQLStatement	DefaultSQLStatementHandler.createLeftJoinSelectQueryPageable(String mainTable, String subquery, String secondaryTable, Vector mainKeys, Vector secondaryKeys, Vector mainTableRequestedColumns, Vector secondaryTableRequestedColumns, Hashtable mainTableConditions, Hashtable secondaryTableConditions, Vector wildcards, Vector columnSorting, boolean forceDistinct, boolean descending, int i)
SQLStatementBuilder.SQLStatement	SQLStatementHandler.createLeftJoinSelectQueryPageable(String mainTable, String subquery, String secondaryTable, Vector mainKeys, Vector secondaryKeys, Vector mainTableRequestedColumns, Vector secondaryTableRequestedColumns, Hashtable mainTableConditions, Hashtable secondaryTableConditions, Vector wildcards, Vector columnSorting, boolean forceDistinct, boolean descending, int recordNumber, int startIndex)
SQLStatementBuilder.SQLStatement	PostgresSQLStatementHandler.createLeftJoinSelectQueryPageable(String mainTable, String subquery, String secondaryTable, Vector mainKeys, Vector secondaryKeys, Vector mainTableRequestedColumns, Vector secondaryTableRequestedColumns, Hashtable mainTableConditions, Hashtable secondaryTableConditions, Vector wildcards, Vector columnSorting, boolean forceDistinct, boolean descending, int recordNumber, int startIndex)
SQLStatementBuilder.SQLStatement	MySQLSQLStatementHandler.createLeftJoinSelectQueryPageable(String mainTable, String subquery, String secondaryTable, Vector mainKeys, Vector secondaryKeys, Vector mainTableRequestedColumns, Vector secondaryTableRequestedColumns, Hashtable mainTableConditions, Hashtable secondaryTableConditions, Vector wildcards, Vector columnSorting, boolean forceDistinct, boolean descending, int recordNumber, int startIndex)
SQLStatementBuilder.SQLStatement	HSQLDBSQLStatementHandler.createLeftJoinSelectQueryPageable(String mainTable, String subquery, String secondaryTable, Vector mainKeys, Vector secondaryKeys, Vector mainTableRequestedColumns, Vector secondaryTableRequestedColumns, Hashtable mainTableConditions, Hashtable secondaryTableConditions, Vector wildcards, Vector columnSorting, boolean forceDistinct, boolean descending, int recordNumber, int startIndex)
SQLStatementBuilder.SQLStatement	DefaultSQLStatementHandler.createLeftJoinSelectQueryPageable(String mainTable, String subquery, String secondaryTable, Vector mainKeys, Vector secondaryKeys, Vector mainTableRequestedColumns, Vector secondaryTableRequestedColumns, Hashtable mainTableConditions, Hashtable secondaryTableConditions, Vector wildcards, Vector columnSorting, boolean forceDistinct, boolean descending, int recordNumber, int startIndex) Returns a SQLStatement class that stores the information needed to execute a select query against two subselects used a join.
SQLStatementBuilder.SQLStatement	SQLStatementHandler.createSelectQuery(String table, Vector requestedColumns, Hashtable conditions, Vector wildcards)
SQLStatementBuilder.SQLStatement	DefaultSQLStatementHandler.createSelectQuery(String table, Vector requestedColumns, Hashtable conditions, Vector wildcards) Returns a SQLStatement class that stores the information needed to execute a select query.
SQLStatementBuilder.SQLStatement	SQLStatementHandler.createSelectQuery(String table, Vector requestedColumns, Hashtable conditions, Vector wildcards, Vector columnSorting)
SQLStatementBuilder.SQLStatement	DefaultSQLStatementHandler.createSelectQuery(String table, Vector requestedColumns, Hashtable conditions, Vector wildcards, Vector columnSorting) Returns a SQLStatement class that stores the information needed to execute a select query.
SQLStatementBuilder.SQLStatement	SQLStatementHandler.createSelectQuery(String table, Vector requestedColumns, Hashtable conditions, Vector wildcards, Vector columnSorting, boolean descending)
SQLStatementBuilder.SQLStatement	DefaultSQLStatementHandler.createSelectQuery(String table, Vector requestedColumns, Hashtable conditions, Vector wildcards, Vector columnSorting, boolean descending) Returns a SQLStatement class that stores the information needed to execute a select query.
SQLStatementBuilder.SQLStatement	SQLStatementHandler.createSelectQuery(String table, Vector requestedColumns, Hashtable conditions, Vector wildcards, Vector columnSorting, boolean descending, boolean forceDistinct)
SQLStatementBuilder.SQLStatement	DefaultSQLStatementHandler.createSelectQuery(String table, Vector requestedColumns, Hashtable conditions, Vector wildcards, Vector columnSorting, boolean descending, boolean forceDistinct) Returns a SQLStatement class that stores the information needed to execute a select query.
SQLStatementBuilder.SQLStatement	SQLStatementHandler.createSelectQuery(String table, Vector requestedColumns, Hashtable conditions, Vector wildcards, Vector columnSorting, int recordCount)
SQLStatementBuilder.SQLStatement	DefaultSQLStatementHandler.createSelectQuery(String table, Vector requestedColumns, Hashtable conditions, Vector wildcards, Vector columnSorting, int recordCount) Returns a SQLStatement class that stores the information needed to execute a select query.
SQLStatementBuilder.SQLStatement	SQLStatementHandler.createSelectQuery(String table, Vector requestedColumns, Hashtable conditions, Vector wildcards, Vector columnSorting, int recordCount, boolean descending)
SQLStatementBuilder.SQLStatement	DefaultSQLStatementHandler.createSelectQuery(String table, Vector requestedColumns, Hashtable conditions, Vector wildcards, Vector columnSorting, int recordCount, boolean descending) Returns a SQLStatement class that stores the information needed to execute a select query.
SQLStatementBuilder.SQLStatement	SQLStatementHandler.createSelectQuery(String table, Vector requestedColumns, Hashtable conditions, Vector wildcards, Vector columnSorting, int recordCount, boolean descending, boolean forceDistinct)
SQLStatementBuilder.SQLStatement	SQLServerSQLStatementHandler.createSelectQuery(String table, Vector requestedColumns, Hashtable conditions, Vector wildcards, Vector columnSorting, int recordCount, boolean descending, boolean forceDistinct)
SQLStatementBuilder.SQLStatement	PostgresSQLStatementHandler.createSelectQuery(String table, Vector requestedColumns, Hashtable conditions, Vector wildcards, Vector columnSorting, int recordCount, boolean descending, boolean forceDistinct)
SQLStatementBuilder.SQLStatement	OracleSQLStatementHandler.createSelectQuery(String table, Vector requestedColumns, Hashtable conditions, Vector wildcards, Vector columnSorting, int recordCount, boolean descending, boolean forceDistinct)
SQLStatementBuilder.SQLStatement	MySQLSQLStatementHandler.createSelectQuery(String table, Vector requestedColumns, Hashtable conditions, Vector wildcards, Vector columnSorting, int recordCount, boolean descending, boolean forceDistinct)
SQLStatementBuilder.SQLStatement	HSQLDBSQLStatementHandler.createSelectQuery(String table, Vector requestedColumns, Hashtable conditions, Vector wildcards, Vector columnSorting, int recordCount, boolean descending, boolean forceDistinct)
SQLStatementBuilder.SQLStatement	DefaultSQLStatementHandler.createSelectQuery(String table, Vector requestedColumns, Hashtable conditions, Vector wildcards, Vector columnSorting, int recordCount, boolean descending, boolean forceDistinct) Returns a SQLStatement class that stores the information needed to execute a select query.
SQLStatementBuilder.SQLStatement	SQLStatementHandler.createSelectQuery(String table, Vector requestedColumns, Hashtable conditions, Vector wildcards, Vector columnSorting, int recordCount, int offset)
SQLStatementBuilder.SQLStatement	DefaultSQLStatementHandler.createSelectQuery(String table, Vector requestedColumns, Hashtable conditions, Vector wildcards, Vector columnSorting, int recordCount, int offset)
SQLStatementBuilder.SQLStatement	SQLStatementHandler.createSelectQuery(String table, Vector requestedColumns, Hashtable conditions, Vector wildcards, Vector columnSorting, int recordCount, int offset, boolean descending)
SQLStatementBuilder.SQLStatement	DefaultSQLStatementHandler.createSelectQuery(String table, Vector requestedColumns, Hashtable conditions, Vector wildcards, Vector columnSorting, int recordCount, int offset, boolean descending)
SQLStatementBuilder.SQLStatement	SQLStatementHandler.createSelectQuery(String table, Vector requestedColumns, Hashtable conditions, Vector wildcards, Vector columnSorting, int recordCount, int offset, boolean descending, boolean forceDistinct)
SQLStatementBuilder.SQLStatement	PostgresSQLStatementHandler.createSelectQuery(String table, Vector requestedColumns, Hashtable conditions, Vector wildcards, Vector columnSorting, int recordCount, int offset, boolean descending, boolean forceDistinct)
SQLStatementBuilder.SQLStatement	MySQLSQLStatementHandler.createSelectQuery(String table, Vector requestedColumns, Hashtable conditions, Vector wildcards, Vector columnSorting, int recordCount, int offset, boolean descending, boolean forceDistinct)
SQLStatementBuilder.SQLStatement	HSQLDBSQLStatementHandler.createSelectQuery(String table, Vector requestedColumns, Hashtable conditions, Vector wildcards, Vector columnSorting, int recordCount, int offset, boolean descending, boolean forceDistinct)
SQLStatementBuilder.SQLStatement	DefaultSQLStatementHandler.createSelectQuery(String table, Vector requestedColumns, Hashtable conditions, Vector wildcards, Vector columnSorting, int recordCount, int offset, boolean descending, boolean forceDistinct)
SQLStatementBuilder.SQLStatement	SQLStatementHandler.createUpdateQuery(String table, Hashtable attributesValues, Hashtable keysValues)
SQLStatementBuilder.SQLStatement	DefaultSQLStatementHandler.createUpdateQuery(String table, Hashtable attributesValues, Hashtable keysValues) Returns a SQLStatement class that stores the information needed to execute a update query.

Uses of SQLStatementBuilder.SQLStatement in com.ontimize.gui.i18n

Methods in com.ontimize.gui.i18n with parameters of type SQLStatementBuilder.SQLStatement

Modifier and Type	Method and Description
EntityResult	DatabaseBundleManager.executePreparedStatement(SQLStatementBuilder.SQLStatement sqlStatement, Connection con, int sessionId, List queryColumns)
protected EntityResult	DatabaseBundleManager.executeQueryStatement(SQLStatementBuilder.SQLStatement sqlStatement, int sessionId, List queryColumns, Connection con)
protected void	DatabaseBundleManager.executeUpdateStatement(SQLStatementBuilder.SQLStatement sqlStatement, int sessionId, Connection con)