com.ontimize.db.handler

Interface SQLStatementHandler

All Known Implementing Classes:

DefaultSQLStatementHandler, HSQLDBSQLStatementHandler, MySQLSQLStatementHandler, OracleSQLStatementHandler, PostgresSQLStatementHandler, SQLServerSQLStatementHandler

public interface SQLStatementHandler

Method Summary

Methods

Modifier and Type	Method and Description
String	addInnerMultilanguageColumns(String subSqlQuery, Vector attributtes, Hashtable hLocaleTablesAV)
String	addMultilanguageLeftJoinTables(String table, Vector tables, LinkedHashMap hOtherLocaleTablesKey, LocalePair localeId)
String	addOuterMultilanguageColumns(String sqlQuery, String table, Hashtable hLocaleTablesAV)
String	addOuterMultilanguageColumnsPageable(String sqlQuery, String table, Hashtable hLocaleTablesAV)
void	addSpecialCharacters(char[] c)
boolean	checkColumnName(String columnName)
SQLStatementBuilder.SQLStatement	createCountQuery(String table, Hashtable conditions, Vector wildcards, Vector countColumns)
SQLStatementBuilder.SQLStatement	createDeleteQuery(String table, Hashtable keysValues)
SQLStatementBuilder.SQLStatement	createInsertQuery(String table, Hashtable attributes)
SQLStatementBuilder.SQLStatement	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	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	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	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	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)
String	createQueryConditionsWithoutWhere(Hashtable conditions, Vector wildcard, Vector values)
SQLStatementBuilder.SQLStatement	createSelectQuery(String table, Vector requestedColumns, Hashtable conditions, Vector wildcards)
SQLStatementBuilder.SQLStatement	createSelectQuery(String table, Vector requestedColumns, Hashtable conditions, Vector wildcards, Vector columnSorting)
SQLStatementBuilder.SQLStatement	createSelectQuery(String table, Vector requestedColumns, Hashtable conditions, Vector wildcards, Vector columnSorting, boolean descending)
SQLStatementBuilder.SQLStatement	createSelectQuery(String table, Vector requestedColumns, Hashtable conditions, Vector wildcards, Vector columnSorting, boolean descending, boolean forceDistinct)
SQLStatementBuilder.SQLStatement	createSelectQuery(String table, Vector requestedColumns, Hashtable conditions, Vector wildcards, Vector columnSorting, int recordCount)
SQLStatementBuilder.SQLStatement	createSelectQuery(String table, Vector requestedColumns, Hashtable conditions, Vector wildcards, Vector columnSorting, int recordCount, boolean descending)
SQLStatementBuilder.SQLStatement	createSelectQuery(String table, Vector requestedColumns, Hashtable conditions, Vector wildcards, Vector columnSorting, int recordCount, boolean descending, boolean forceDistinct)
SQLStatementBuilder.SQLStatement	createSelectQuery(String table, Vector requestedColumns, Hashtable conditions, Vector wildcards, Vector columnSorting, int recordCount, int offset)
SQLStatementBuilder.SQLStatement	createSelectQuery(String table, Vector requestedColumns, Hashtable conditions, Vector wildcards, Vector columnSorting, int recordCount, int offset, boolean descending)
SQLStatementBuilder.SQLStatement	createSelectQuery(String table, Vector requestedColumns, Hashtable conditions, Vector wildcards, Vector columnSorting, int recordCount, int offset, boolean descending, boolean forceDistinct)
SQLStatementBuilder.SQLStatement	createUpdateQuery(String table, Hashtable attributesValues, Hashtable keysValues)
void	generatedKeysToEntityResult(ResultSet resultSet, EntityResult entityResult, List generatedKeys)
SQLStatementBuilder.SQLConditionValuesProcessor	getQueryConditionsProcessor()
SQLStatementBuilder.SQLNameEval	getSQLNameEval()
boolean	isDelimited()
boolean	isPageable()
boolean	isUseAsInSubqueries()
String	qualify(String col, String table)
void	resultSetToEntityResult(ResultSet resultSet, EntityResult entityResult, int recordNumber, int offset, boolean delimited, List columnNames)
void	resultSetToEntityResult(ResultSet resultSet, EntityResult entityResult, List columnNames)
void	setObject(int index, Object value, PreparedStatement preparedStatement, boolean truncDates)
void	setSQLConditionValuesProcessor(SQLStatementBuilder.SQLConditionValuesProcessor processor)
void	setSQLNameEval(SQLStatementBuilder.SQLNameEval eval)
void	setUseAsInSubqueries(boolean useAsInSubqueries)

Method Detail

addSpecialCharacters

void addSpecialCharacters(char[] c)

createCountQuery

SQLStatementBuilder.SQLStatement createCountQuery(String table,
                                                Hashtable conditions,
                                                Vector wildcards,
                                                Vector countColumns)

createDeleteQuery

SQLStatementBuilder.SQLStatement createDeleteQuery(String table,
                                                 Hashtable keysValues)

createInsertQuery

SQLStatementBuilder.SQLStatement createInsertQuery(String table,
                                                 Hashtable attributes)

createJoinSelectQuery

SQLStatementBuilder.SQLStatement createJoinSelectQuery(String principalTable,
                                                     String secondaryTable,
                                                     Vector principalKeys,
                                                     Vector secondaryKeys,
                                                     Vector principalTableRequestedColumns,
                                                     Vector secondaryTableRequestedColumns,
                                                     Hashtable principalTableConditions,
                                                     Hashtable secondaryTableConditions,
                                                     Vector wildcards,
                                                     Vector columnSorting,
                                                     boolean forceDistinct)

createJoinSelectQuery

SQLStatementBuilder.SQLStatement 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)

createJoinFromSubselectsQuery

SQLStatementBuilder.SQLStatement 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)

createLeftJoinSelectQuery

SQLStatementBuilder.SQLStatement 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)

createLeftJoinSelectQueryPageable

SQLStatementBuilder.SQLStatement 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)

createSelectQuery

SQLStatementBuilder.SQLStatement createSelectQuery(String table,
                                                 Vector requestedColumns,
                                                 Hashtable conditions,
                                                 Vector wildcards)

createSelectQuery

SQLStatementBuilder.SQLStatement createSelectQuery(String table,
                                                 Vector requestedColumns,
                                                 Hashtable conditions,
                                                 Vector wildcards,
                                                 Vector columnSorting)

createSelectQuery

SQLStatementBuilder.SQLStatement createSelectQuery(String table,
                                                 Vector requestedColumns,
                                                 Hashtable conditions,
                                                 Vector wildcards,
                                                 Vector columnSorting,
                                                 boolean descending)

createSelectQuery

SQLStatementBuilder.SQLStatement createSelectQuery(String table,
                                                 Vector requestedColumns,
                                                 Hashtable conditions,
                                                 Vector wildcards,
                                                 Vector columnSorting,
                                                 boolean descending,
                                                 boolean forceDistinct)

createSelectQuery

SQLStatementBuilder.SQLStatement createSelectQuery(String table,
                                                 Vector requestedColumns,
                                                 Hashtable conditions,
                                                 Vector wildcards,
                                                 Vector columnSorting,
                                                 int recordCount)

createSelectQuery

SQLStatementBuilder.SQLStatement createSelectQuery(String table,
                                                 Vector requestedColumns,
                                                 Hashtable conditions,
                                                 Vector wildcards,
                                                 Vector columnSorting,
                                                 int recordCount,
                                                 boolean descending)

createSelectQuery

SQLStatementBuilder.SQLStatement createSelectQuery(String table,
                                                 Vector requestedColumns,
                                                 Hashtable conditions,
                                                 Vector wildcards,
                                                 Vector columnSorting,
                                                 int recordCount,
                                                 boolean descending,
                                                 boolean forceDistinct)

createSelectQuery

SQLStatementBuilder.SQLStatement createSelectQuery(String table,
                                                 Vector requestedColumns,
                                                 Hashtable conditions,
                                                 Vector wildcards,
                                                 Vector columnSorting,
                                                 int recordCount,
                                                 int offset)

createSelectQuery

SQLStatementBuilder.SQLStatement createSelectQuery(String table,
                                                 Vector requestedColumns,
                                                 Hashtable conditions,
                                                 Vector wildcards,
                                                 Vector columnSorting,
                                                 int recordCount,
                                                 int offset,
                                                 boolean descending)

createSelectQuery

SQLStatementBuilder.SQLStatement createSelectQuery(String table,
                                                 Vector requestedColumns,
                                                 Hashtable conditions,
                                                 Vector wildcards,
                                                 Vector columnSorting,
                                                 int recordCount,
                                                 int offset,
                                                 boolean descending,
                                                 boolean forceDistinct)

createUpdateQuery

SQLStatementBuilder.SQLStatement createUpdateQuery(String table,
                                                 Hashtable attributesValues,
                                                 Hashtable keysValues)

getQueryConditionsProcessor

SQLStatementBuilder.SQLConditionValuesProcessor getQueryConditionsProcessor()

getSQLNameEval

SQLStatementBuilder.SQLNameEval getSQLNameEval()

qualify

String qualify(String col,
             String table)

setSQLConditionValuesProcessor

void setSQLConditionValuesProcessor(SQLStatementBuilder.SQLConditionValuesProcessor processor)

setSQLNameEval

void setSQLNameEval(SQLStatementBuilder.SQLNameEval eval)

isUseAsInSubqueries

boolean isUseAsInSubqueries()

setUseAsInSubqueries

void setUseAsInSubqueries(boolean useAsInSubqueries)

checkColumnName

boolean checkColumnName(String columnName)

createQueryConditionsWithoutWhere

String createQueryConditionsWithoutWhere(Hashtable conditions,
                                       Vector wildcard,
                                       Vector values)

isPageable

boolean isPageable()

isDelimited

boolean isDelimited()

resultSetToEntityResult

void resultSetToEntityResult(ResultSet resultSet,
                           EntityResult entityResult,
                           List columnNames)
                             throws Exception

Throws:

Exception

resultSetToEntityResult

void resultSetToEntityResult(ResultSet resultSet,
                           EntityResult entityResult,
                           int recordNumber,
                           int offset,
                           boolean delimited,
                           List columnNames)
                             throws Exception

Throws:

Exception

generatedKeysToEntityResult

void generatedKeysToEntityResult(ResultSet resultSet,
                               EntityResult entityResult,
                               List generatedKeys)
                                 throws Exception

Throws:

Exception

setObject

void setObject(int index,
             Object value,
             PreparedStatement preparedStatement,
             boolean truncDates)
               throws SQLException

Throws:

SQLException

addMultilanguageLeftJoinTables

String addMultilanguageLeftJoinTables(String table,
                                    Vector tables,
                                    LinkedHashMap hOtherLocaleTablesKey,
                                    LocalePair localeId)
                                      throws SQLException

Throws:

SQLException

addInnerMultilanguageColumns

String addInnerMultilanguageColumns(String subSqlQuery,
                                  Vector attributtes,
                                  Hashtable hLocaleTablesAV)

addOuterMultilanguageColumns

String addOuterMultilanguageColumns(String sqlQuery,
                                  String table,
                                  Hashtable hLocaleTablesAV)

addOuterMultilanguageColumnsPageable

String addOuterMultilanguageColumnsPageable(String sqlQuery,
                                          String table,
                                          Hashtable hLocaleTablesAV)