com.ontimize.db.handler
Interface SQLStatementHandler
- All Known Implementing Classes:
- DefaultSQLStatementHandler
- public interface SQLStatementHandler
|
Method Summary |
void |
addSpecialCharacters(char[] c)
|
boolean |
checkColumnName(java.lang.String columnName)
|
SQLStatementBuilder.SQLStatement |
createCountQuery(java.lang.String table,
java.util.Hashtable conditions,
java.util.Vector wildcards)
|
SQLStatementBuilder.SQLStatement |
createDeleteQuery(java.lang.String table,
java.util.Hashtable keysValues)
|
SQLStatementBuilder.SQLStatement |
createInsertQuery(java.lang.String table,
java.util.Hashtable attributes)
|
SQLStatementBuilder.SQLStatement |
createJoinSelectQuery(java.lang.String principalTable,
java.lang.String secondaryTable,
java.util.Vector principalKeys,
java.util.Vector secondaryKeys,
java.util.Vector principalTableRequestedColumns,
java.util.Vector secondaryTableRequestedColumns,
java.util.Hashtable principalTableConditions,
java.util.Hashtable secondaryTableConditions,
java.util.Vector wildcards,
java.util.Vector columnSorting,
boolean forceDistinct)
|
SQLStatementBuilder.SQLStatement |
createJoinSelectQuery(java.lang.String mainTable,
java.lang.String secondaryTable,
java.util.Vector mainKeys,
java.util.Vector secondaryKeys,
java.util.Vector mainTableRequestedColumns,
java.util.Vector secondaryTableRequestedColumns,
java.util.Hashtable mainTableConditions,
java.util.Hashtable secondaryTableConditions,
java.util.Vector wildcards,
java.util.Vector columnSorting,
boolean forceDistinct,
boolean descending)
|
java.lang.String |
createQueryConditionsWithoutWhere(java.util.Hashtable conditions,
java.util.Vector wildcard,
java.util.Vector values)
|
SQLStatementBuilder.SQLStatement |
createSelectQuery(java.lang.String table,
java.util.Vector requestedColumns,
java.util.Hashtable conditions,
java.util.Vector wildcards)
|
SQLStatementBuilder.SQLStatement |
createSelectQuery(java.lang.String table,
java.util.Vector requestedColumns,
java.util.Hashtable conditions,
java.util.Vector wildcards,
java.util.Vector columnSorting)
|
SQLStatementBuilder.SQLStatement |
createSelectQuery(java.lang.String table,
java.util.Vector requestedColumns,
java.util.Hashtable conditions,
java.util.Vector wildcards,
java.util.Vector columnSorting,
boolean descending)
|
SQLStatementBuilder.SQLStatement |
createSelectQuery(java.lang.String table,
java.util.Vector requestedColumns,
java.util.Hashtable conditions,
java.util.Vector wildcards,
java.util.Vector columnSorting,
boolean descending,
boolean forceDistinct)
|
SQLStatementBuilder.SQLStatement |
createSelectQuery(java.lang.String table,
java.util.Vector requestedColumns,
java.util.Hashtable conditions,
java.util.Vector wildcards,
java.util.Vector columnSorting,
int recordCount)
|
SQLStatementBuilder.SQLStatement |
createSelectQuery(java.lang.String table,
java.util.Vector requestedColumns,
java.util.Hashtable conditions,
java.util.Vector wildcards,
java.util.Vector columnSorting,
int recordCount,
boolean descending)
|
SQLStatementBuilder.SQLStatement |
createSelectQuery(java.lang.String table,
java.util.Vector requestedColumns,
java.util.Hashtable conditions,
java.util.Vector wildcards,
java.util.Vector columnSorting,
int recordCount,
boolean descending,
boolean forceDistinct)
|
SQLStatementBuilder.SQLStatement |
createSelectQuery(java.lang.String table,
java.util.Vector requestedColumns,
java.util.Hashtable conditions,
java.util.Vector wildcards,
java.util.Vector columnSorting,
int recordCount,
int offset)
|
SQLStatementBuilder.SQLStatement |
createSelectQuery(java.lang.String table,
java.util.Vector requestedColumns,
java.util.Hashtable conditions,
java.util.Vector wildcards,
java.util.Vector columnSorting,
int recordCount,
int offset,
boolean descending)
|
SQLStatementBuilder.SQLStatement |
createSelectQuery(java.lang.String table,
java.util.Vector requestedColumns,
java.util.Hashtable conditions,
java.util.Vector wildcards,
java.util.Vector columnSorting,
int recordCount,
int offset,
boolean descending,
boolean forceDistinct)
|
SQLStatementBuilder.SQLStatement |
createUpdateQuery(java.lang.String table,
java.util.Hashtable attributesValues,
java.util.Hashtable keysValues)
|
SQLStatementBuilder.SQLConditionValuesProcessor |
getQueryConditionsProcessor()
|
SQLStatementBuilder.SQLNameEval |
getSQLNameEval()
|
boolean |
isDelimited()
|
boolean |
isPageable()
|
boolean |
isUseAsInSubqueries()
|
java.lang.String |
qualify(java.lang.String col,
java.lang.String table)
|
void |
resultSetToEntityResult(java.sql.ResultSet resultSet,
EntityResult entityResult,
int recordNumber,
int offset,
boolean delimited,
java.util.List columnNames)
|
void |
resultSetToEntityResult(java.sql.ResultSet resultSet,
EntityResult entityResult,
java.util.List columnNames)
|
void |
setSQLConditionValuesProcessor(SQLStatementBuilder.SQLConditionValuesProcessor processor)
|
void |
setSQLNameEval(SQLStatementBuilder.SQLNameEval eval)
|
void |
setUseAsInSubqueries(boolean useAsInSubqueries)
|
addSpecialCharacters
public void addSpecialCharacters(char[] c)
createCountQuery
public SQLStatementBuilder.SQLStatement createCountQuery(java.lang.String table,
java.util.Hashtable conditions,
java.util.Vector wildcards)
createDeleteQuery
public SQLStatementBuilder.SQLStatement createDeleteQuery(java.lang.String table,
java.util.Hashtable keysValues)
createInsertQuery
public SQLStatementBuilder.SQLStatement createInsertQuery(java.lang.String table,
java.util.Hashtable attributes)
createJoinSelectQuery
public SQLStatementBuilder.SQLStatement createJoinSelectQuery(java.lang.String principalTable,
java.lang.String secondaryTable,
java.util.Vector principalKeys,
java.util.Vector secondaryKeys,
java.util.Vector principalTableRequestedColumns,
java.util.Vector secondaryTableRequestedColumns,
java.util.Hashtable principalTableConditions,
java.util.Hashtable secondaryTableConditions,
java.util.Vector wildcards,
java.util.Vector columnSorting,
boolean forceDistinct)
createJoinSelectQuery
public SQLStatementBuilder.SQLStatement createJoinSelectQuery(java.lang.String mainTable,
java.lang.String secondaryTable,
java.util.Vector mainKeys,
java.util.Vector secondaryKeys,
java.util.Vector mainTableRequestedColumns,
java.util.Vector secondaryTableRequestedColumns,
java.util.Hashtable mainTableConditions,
java.util.Hashtable secondaryTableConditions,
java.util.Vector wildcards,
java.util.Vector columnSorting,
boolean forceDistinct,
boolean descending)
createSelectQuery
public SQLStatementBuilder.SQLStatement createSelectQuery(java.lang.String table,
java.util.Vector requestedColumns,
java.util.Hashtable conditions,
java.util.Vector wildcards)
createSelectQuery
public SQLStatementBuilder.SQLStatement createSelectQuery(java.lang.String table,
java.util.Vector requestedColumns,
java.util.Hashtable conditions,
java.util.Vector wildcards,
java.util.Vector columnSorting)
createSelectQuery
public SQLStatementBuilder.SQLStatement createSelectQuery(java.lang.String table,
java.util.Vector requestedColumns,
java.util.Hashtable conditions,
java.util.Vector wildcards,
java.util.Vector columnSorting,
boolean descending)
createSelectQuery
public SQLStatementBuilder.SQLStatement createSelectQuery(java.lang.String table,
java.util.Vector requestedColumns,
java.util.Hashtable conditions,
java.util.Vector wildcards,
java.util.Vector columnSorting,
boolean descending,
boolean forceDistinct)
createSelectQuery
public SQLStatementBuilder.SQLStatement createSelectQuery(java.lang.String table,
java.util.Vector requestedColumns,
java.util.Hashtable conditions,
java.util.Vector wildcards,
java.util.Vector columnSorting,
int recordCount)
createSelectQuery
public SQLStatementBuilder.SQLStatement createSelectQuery(java.lang.String table,
java.util.Vector requestedColumns,
java.util.Hashtable conditions,
java.util.Vector wildcards,
java.util.Vector columnSorting,
int recordCount,
boolean descending)
createSelectQuery
public SQLStatementBuilder.SQLStatement createSelectQuery(java.lang.String table,
java.util.Vector requestedColumns,
java.util.Hashtable conditions,
java.util.Vector wildcards,
java.util.Vector columnSorting,
int recordCount,
boolean descending,
boolean forceDistinct)
createSelectQuery
public SQLStatementBuilder.SQLStatement createSelectQuery(java.lang.String table,
java.util.Vector requestedColumns,
java.util.Hashtable conditions,
java.util.Vector wildcards,
java.util.Vector columnSorting,
int recordCount,
int offset)
createSelectQuery
public SQLStatementBuilder.SQLStatement createSelectQuery(java.lang.String table,
java.util.Vector requestedColumns,
java.util.Hashtable conditions,
java.util.Vector wildcards,
java.util.Vector columnSorting,
int recordCount,
int offset,
boolean descending)
createSelectQuery
public SQLStatementBuilder.SQLStatement createSelectQuery(java.lang.String table,
java.util.Vector requestedColumns,
java.util.Hashtable conditions,
java.util.Vector wildcards,
java.util.Vector columnSorting,
int recordCount,
int offset,
boolean descending,
boolean forceDistinct)
createUpdateQuery
public SQLStatementBuilder.SQLStatement createUpdateQuery(java.lang.String table,
java.util.Hashtable attributesValues,
java.util.Hashtable keysValues)
getQueryConditionsProcessor
public SQLStatementBuilder.SQLConditionValuesProcessor getQueryConditionsProcessor()
getSQLNameEval
public SQLStatementBuilder.SQLNameEval getSQLNameEval()
qualify
public java.lang.String qualify(java.lang.String col,
java.lang.String table)
setSQLConditionValuesProcessor
public void setSQLConditionValuesProcessor(SQLStatementBuilder.SQLConditionValuesProcessor processor)
setSQLNameEval
public void setSQLNameEval(SQLStatementBuilder.SQLNameEval eval)
isUseAsInSubqueries
public boolean isUseAsInSubqueries()
setUseAsInSubqueries
public void setUseAsInSubqueries(boolean useAsInSubqueries)
checkColumnName
public boolean checkColumnName(java.lang.String columnName)
createQueryConditionsWithoutWhere
public java.lang.String createQueryConditionsWithoutWhere(java.util.Hashtable conditions,
java.util.Vector wildcard,
java.util.Vector values)
isPageable
public boolean isPageable()
isDelimited
public boolean isDelimited()
resultSetToEntityResult
public void resultSetToEntityResult(java.sql.ResultSet resultSet,
EntityResult entityResult,
java.util.List columnNames)
throws java.lang.Exception
- Throws:
java.lang.Exception
resultSetToEntityResult
public void resultSetToEntityResult(java.sql.ResultSet resultSet,
EntityResult entityResult,
int recordNumber,
int offset,
boolean delimited,
java.util.List columnNames)
throws java.lang.Exception
- Throws:
java.lang.Exception