com.ontimize.db

Class SQLStatementBuilder

java.lang.Object

com.ontimize.db.SQLStatementBuilder

public abstract class SQLStatementBuilder
extends Object

The SQLStatementBuilder class builds SQL statements

This class is used by every entity to build the SQL Statements needed to query the database.

Author:

Imatia Innovation S.L.

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
static class	SQLStatementBuilder.BasicExpression Default implementation of Expression interfaces.
static class	SQLStatementBuilder.BasicField Default implementation of Field interfaces.
static class	SQLStatementBuilder.BasicOperator Default implementation of Operator interfaces.
static class	SQLStatementBuilder.DefaultSQLConditionValuesProcessor This class provides default implementations for the SQLConditionValuesProcessor interface.
static interface	SQLStatementBuilder.Expression This interface defines the basic methods that must be implemented by any class that defines a expression to be processed in SQLConditionValuesProcessor
static class	SQLStatementBuilder.ExtendedSQLConditionValuesProcessor This class provides a implementation of the SQLConditionValuesProcessor interface.
static interface	SQLStatementBuilder.Field This interface defines the basic methods that must be implemented by any class that stores the name of the column that is used by the Expression when it's processed by SQLConditionValuesProcessor.
static class	SQLStatementBuilder.NoWildCard This class is used for avoid using wildcard when the condition string is created in SQLConditionValuesProcessor
static interface	SQLStatementBuilder.Operator This interface defines the basic methods that must be implemented by every class that defines the operation that is used by the Expression when it's processed by SQLConditionValuesProcessor.
static class	SQLStatementBuilder.OperatorUtilities
static interface	SQLStatementBuilder.SQLConditionValuesProcessor This interface defines the basic method that must be implemented by any class that creates the condition string for a SQL Statement.
static class	SQLStatementBuilder.SQLExpression This class is used to store a SQL Statement and the required values to be processed in SQLConditionValuesProcessor.
static interface	SQLStatementBuilder.SQLNameEval
static class	SQLStatementBuilder.SQLOrder
static class	SQLStatementBuilder.SQLStatement This class is used to store the information to create a SQL statement and the required values.

Field Summary

Fields

Modifier and Type	Field and Description
static String	ACCESS_HANDLER
static String	AND
static String	AS
static String	ASTERISK
static char	ASTERISK_CHAR
static boolean	checkParenthesis
static String	CLOSE_PARENTHESIS
static String	CLOSE_SQUARE_BRACKET
static String	COMMA
static String	COUNT
static String	COUNT_COLUMN
static String	COUNT_COLUMN_NAME
static boolean	DEBUG Debugging purposes variable.
static String	DEFAULT_HANDLER
static String	DELETE_FROM
static String	DESC
static String	DISTINCT
static String	EQUAL
static String	EQUAL_XQUESTIONMARK
static String	FROM
static String	GENERATED_KEY_COLUMN_NAME
static String	HSQLDB_HANDLER
static String	IN
static String	INNER_JOIN
static String	INSERT_INTO
static char	INTERROG
static String	IS_NULL
static String	LEFT_JOIN
static String	LESS_EQUAL
static String	LESS_EQUAL_XQUESTIONMARK
static String	LESS_XQUESTIONMARK
static String	LIKE
static char	LOW_LINE
static String	MORE_EQUAL
static String	MORE_EQUAL_XQUESTIONMARK
static String	MORE_XQUESTIONMARK
static String	MYSQL_HANDLER
static String	NOT_EQUAL
static String	NOT_EQUAL_ID
static String	NOT_EQUAL_XQUESTIONMARK
static String	NOT_IN
static String	NOT_LIKE
static String	NULL
static String	ON
static String	OPEN_PARENTHESIS
static String	OPEN_SQUARE_BRACKET
static String	OR
static String	ORACLE_HANDLER
static String	ORDER_BY
static char	PERCENT
static String	PIPES
static String	POSTGRES_HANDLER
static String	QUESTIONMARK
protected static Hashtable	registerHandlers
static String	SELECT
static String	SET
static String	SPACE
static String	SQLSERVER_HANDLER
static String	TOP
static String	UPDATE
static boolean	useAsInSubqueries Deprecated. Use:
static String	VALUES
static String	WHERE

Constructor Summary

Constructors

Constructor and Description
SQLStatementBuilder()

Method Summary

Methods

Modifier and Type	Method and Description
static void	addSpecialCharacters(char[] c) Adds characters to the list of special characters.
static SQLStatementBuilder.SQLStatement	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	createDeleteQuery(String table, Hashtable keysValues) Returns a SQLStatement class that stores the information needed to execute a delete query.
static SQLStatementBuilder.SQLStatement	createInsertQuery(String table, Hashtable attributes) Returns a SQLStatement class that stores the information needed to execute a insert query.
static 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) Returns a SQLStatement class that stores the information needed to execute a select query against two table used a join.
static 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) Returns a SQLStatement class that stores the information needed to execute a select query against two table used a join.
static StringBuffer	createQueryConditionsSearchValue(Object oValue, Vector values, boolean bracket, Object oKey)
static String	createQueryConditionsWithoutWhere(Hashtable conditions, Vector wildcard, Vector values)
static SQLStatementBuilder.SQLStatement	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	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	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	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	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	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	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	createUpdateQuery(String table, Hashtable attributesValues, Hashtable keysValues) Returns a SQLStatement class that stores the information needed to execute a update query.
static SQLStatementBuilder.SQLConditionValuesProcessor	getQueryConditionsProcessor() Returns a instance of SQLConditionValuesProcessor that be used in this class to create the condition string
static SQLStatementBuilder.SQLNameEval	getSQLNameEval()
static SQLStatementHandler	getSQLStatementHandler(String handlerID)
static boolean	isUseAsInSubqueries()
static String	qualify(String col, String table) Returns a String with the qualified name.
static void	registerSQLStatementHandler(String handlerID, SQLStatementHandler handler)
static void	setSQLConditionValuesProcessor(SQLStatementBuilder.SQLConditionValuesProcessor processor) Sets the SQLConditionValuesProcessor to be used in SQLStatementBuilder
static void	setSQLNameEval(SQLStatementBuilder.SQLNameEval eval)
static void	setUseAsInSubqueries(boolean useAsInSubqueries)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

DEFAULT_HANDLER

public static final String DEFAULT_HANDLER

See Also:

Constant Field Values

POSTGRES_HANDLER

public static final String POSTGRES_HANDLER

See Also:

Constant Field Values

SQLSERVER_HANDLER

public static final String SQLSERVER_HANDLER

See Also:

Constant Field Values

ORACLE_HANDLER

public static final String ORACLE_HANDLER

See Also:

Constant Field Values

HSQLDB_HANDLER

public static final String HSQLDB_HANDLER

See Also:

Constant Field Values

ACCESS_HANDLER

public static final String ACCESS_HANDLER

See Also:

Constant Field Values

MYSQL_HANDLER

public static final String MYSQL_HANDLER

See Also:

Constant Field Values

registerHandlers

protected static final Hashtable registerHandlers

useAsInSubqueries

@Deprecated
public static boolean useAsInSubqueries

Deprecated. Use:

See Also:

DefaultSQLStatementHandler.useAsInSubqueries

DEBUG

public static boolean DEBUG

Debugging purposes variable. If enabled, debugging information will be sent to standard output.

SELECT

public static final String SELECT

See Also:

Constant Field Values

DISTINCT

public static final String DISTINCT

See Also:

Constant Field Values

WHERE

public static final String WHERE

See Also:

Constant Field Values

ON

public static final String ON

See Also:

Constant Field Values

FROM

public static final String FROM

See Also:

Constant Field Values

LIKE

public static final String LIKE

See Also:

Constant Field Values

NOT_LIKE

public static final String NOT_LIKE

See Also:

Constant Field Values

AND

public static final String AND

See Also:

Constant Field Values

OR

public static final String OR

See Also:

Constant Field Values

LEFT_JOIN

public static final String LEFT_JOIN

See Also:

Constant Field Values

INNER_JOIN

public static final String INNER_JOIN

See Also:

Constant Field Values

IN

public static final String IN

See Also:

Constant Field Values

NOT_IN

public static final String NOT_IN

See Also:

Constant Field Values

COMMA

public static final String COMMA

See Also:

Constant Field Values

QUESTIONMARK

public static final String QUESTIONMARK

See Also:

Constant Field Values

OPEN_PARENTHESIS

public static final String OPEN_PARENTHESIS

See Also:

Constant Field Values

CLOSE_PARENTHESIS

public static final String CLOSE_PARENTHESIS

See Also:

Constant Field Values

checkParenthesis

public static boolean checkParenthesis

ASTERISK

public static final String ASTERISK

See Also:

Constant Field Values

OPEN_SQUARE_BRACKET

public static final String OPEN_SQUARE_BRACKET

See Also:

Constant Field Values

CLOSE_SQUARE_BRACKET

public static final String CLOSE_SQUARE_BRACKET

See Also:

Constant Field Values

EQUAL_XQUESTIONMARK

public static final String EQUAL_XQUESTIONMARK

See Also:

Constant Field Values

NOT_EQUAL_XQUESTIONMARK

public static final String NOT_EQUAL_XQUESTIONMARK

See Also:

Constant Field Values

EQUAL

public static final String EQUAL

See Also:

Constant Field Values

NOT_EQUAL

public static final String NOT_EQUAL

See Also:

Constant Field Values

NOT_EQUAL_ID

public static final String NOT_EQUAL_ID

See Also:

Constant Field Values

IS_NULL

public static final String IS_NULL

See Also:

Constant Field Values

NULL

public static final String NULL

See Also:

Constant Field Values

MORE_EQUAL

public static final String MORE_EQUAL

See Also:

Constant Field Values

LESS_EQUAL

public static final String LESS_EQUAL

See Also:

Constant Field Values

MORE_EQUAL_XQUESTIONMARK

public static final String MORE_EQUAL_XQUESTIONMARK

See Also:

Constant Field Values

LESS_EQUAL_XQUESTIONMARK

public static final String LESS_EQUAL_XQUESTIONMARK

See Also:

Constant Field Values

LESS_XQUESTIONMARK

public static final String LESS_XQUESTIONMARK

See Also:

Constant Field Values

MORE_XQUESTIONMARK

public static final String MORE_XQUESTIONMARK

See Also:

Constant Field Values

AS

public static final String AS

See Also:

Constant Field Values

COUNT_COLUMN

public static final String COUNT_COLUMN

See Also:

Constant Field Values

COUNT_COLUMN_NAME

public static final String COUNT_COLUMN_NAME

See Also:

Constant Field Values

COUNT

public static final String COUNT

See Also:

Constant Field Values

TOP

public static final String TOP

See Also:

Constant Field Values

ORDER_BY

public static final String ORDER_BY

See Also:

Constant Field Values

DESC

public static final String DESC

See Also:

Constant Field Values

INSERT_INTO

public static final String INSERT_INTO

See Also:

Constant Field Values

VALUES

public static final String VALUES

See Also:

Constant Field Values

DELETE_FROM

public static final String DELETE_FROM

See Also:

Constant Field Values

UPDATE

public static final String UPDATE

See Also:

Constant Field Values

SET

public static final String SET

See Also:

Constant Field Values

SPACE

public static final String SPACE

See Also:

Constant Field Values

PIPES

public static final String PIPES

See Also:

Constant Field Values

ASTERISK_CHAR

public static char ASTERISK_CHAR

INTERROG

public static char INTERROG

PERCENT

public static char PERCENT

LOW_LINE

public static char LOW_LINE

GENERATED_KEY_COLUMN_NAME

public static final String GENERATED_KEY_COLUMN_NAME

See Also:

Constant Field Values

Constructor Detail

SQLStatementBuilder

public SQLStatementBuilder()

Method Detail

getSQLStatementHandler

public static SQLStatementHandler getSQLStatementHandler(String handlerID)

registerSQLStatementHandler

public static void registerSQLStatementHandler(String handlerID,
                               SQLStatementHandler handler)

isUseAsInSubqueries

public static boolean isUseAsInSubqueries()

setUseAsInSubqueries

public static void setUseAsInSubqueries(boolean useAsInSubqueries)

createQueryConditionsSearchValue

public static StringBuffer createQueryConditionsSearchValue(Object oValue,
                                            Vector values,
                                            boolean bracket,
                                            Object oKey)

setSQLConditionValuesProcessor

public static void setSQLConditionValuesProcessor(SQLStatementBuilder.SQLConditionValuesProcessor processor)

Sets the SQLConditionValuesProcessor to be used in SQLStatementBuilder

Parameters:

processor - the SQLConditionValuesProcessor instance that be used

createCountQuery

public static SQLStatementBuilder.SQLStatement 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

Parameters:

table - name of the table the query is executed against

conditions - condition list used in the query

wildcards - column list that can use wildcards

Returns:

a SQLStatement class

createSelectQuery

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

Returns a SQLStatement class that stores the information needed to execute a select query.

Parameters:

table - name of the table the query is executed against

requestedColumns - a Vector specifying the requested column name in the query

conditions - condition list used to created the query

wildcards -

Returns:

a SQLStatement class

See Also:

SQLStatementBuilder.SQLStatement

createSelectQuery

public static SQLStatementBuilder.SQLStatement 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.

Parameters:

table - name of the table the query is executed against

requestedColumns - a Vector specifying the requested column name in the query

conditions - condition list used to created the query

wildcards - column list that can use wildcards

columnSorting - column list where query sorting is established

recordCount - number of records requested in the query

Returns:

a SQLStatement class

See Also:

SQLStatementBuilder.SQLStatement

createSelectQuery

public static SQLStatementBuilder.SQLStatement 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.

Parameters:

table - name of the table the query is executed against

requestedColumns - a Vector specifying the requested column name in the query

conditions - condition list used to created the query

wildcards - column list that can use wildcards

columnSorting - column list where query sorting is established

recordCount - number of records requested in the query

descending - true if sorting should be descending

Returns:

a SQLStatement class

See Also:

SQLStatementBuilder.SQLStatement

createSelectQuery

public static SQLStatementBuilder.SQLStatement 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.

Parameters:

table - name of the table the query is executed against

requestedColumns - a Vector specifying the requested column name in the query

conditions - condition list used to created the query

wildcards - column list that can use wildcards

columnSorting - column list where query sorting is established

recordCount - number of records requested in the query

forceDistinct - true if query result cannot have duplicated records

descending - true if sorting should be descending

Returns:

a SQLStatement class

See Also:

SQLStatementBuilder.SQLStatement

createSelectQuery

public static SQLStatementBuilder.SQLStatement 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.

Parameters:

table - name of the table the query is executed against

requestedColumns - a Vector specifying the requested column name in the query

conditions - condition list used to created the query

wildcards - column list that can use wildcards

columnSorting - column list where query sorting is established

Returns:

a SQLStatement class

See Also:

SQLStatementBuilder.SQLStatement

createSelectQuery

public static SQLStatementBuilder.SQLStatement 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.

Parameters:

table - name of the table the query is executed against

requestedColumns - a Vector specifying the requested column name in the query

conditions - condition list used to created the query

wildcards - column list that can use wildcards

columnSorting - column list where query sorting is established

descending - true if sorting should be descending

Returns:

a SQLStatement class

See Also:

SQLStatementBuilder.SQLStatement

createSelectQuery

public static SQLStatementBuilder.SQLStatement 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.

Parameters:

table - name of the table the query is executed against

requestedColumns - a Vector specifying the requested column name in the query

conditions - condition list used to created the query

wildcards - column list that can use wildcards

columnSorting - column list where query sorting is established

forceDistinct - true if query result cannot have duplicated records

descending - true if sorting should be descending

Returns:

a SQLStatement class

See Also:

SQLStatementBuilder.SQLStatement

setSQLNameEval

public static void setSQLNameEval(SQLStatementBuilder.SQLNameEval eval)

getSQLNameEval

public static SQLStatementBuilder.SQLNameEval getSQLNameEval()

createInsertQuery

public static SQLStatementBuilder.SQLStatement createInsertQuery(String table,
                                                 Hashtable attributes)

Returns a SQLStatement class that stores the information needed to execute a insert query.

Parameters:

table - name of the table the query is executed against

attributes - attributes a Hashtable specifying pairs of key-value corresponding to the attribute (or column of a table in a database) and the value that must be stored.

Returns:

createUpdateQuery

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

Returns a SQLStatement class that stores the information needed to execute a update query.

Parameters:

table - name of the table the update is executed against

attributesValues - attributesValues the data for updating the records to. The keys specify the attributes (or columns) and the values, the values for these columns.

keysValues - keysValues the conditions that the records to be updated must fulfill. The keys specify the attributes (or columns) and the values, the values for these columns.

Returns:

See Also:

SQLStatementBuilder.SQLStatement

createDeleteQuery

public static SQLStatementBuilder.SQLStatement createDeleteQuery(String table,
                                                 Hashtable keysValues)

Returns a SQLStatement class that stores the information needed to execute a delete query.

Parameters:

table - name of the table the query is executed against

keysValues - the conditions that the records to be deleted must fulfill. The keys specify the attributes (or columns) and the values, the values for these columns.

Returns:

addSpecialCharacters

public static void addSpecialCharacters(char[] c)

Adds characters to the list of special characters.

When the query is be created if a column name contains a character of the list this column name is inserted between parenthesis in the query.

Parameters:

c - a array with the new characters

createJoinSelectQuery

public static 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)

Returns a SQLStatement class that stores the information needed to execute a select query against two table used a join.

Parameters:

principalTable - name of the principal table the query is executed against

secondaryTable - name of the secondary table the query is executed against

principalKeys - a Vector specifying the column names of the principal table that be used to combine the two tables

secondaryKeys - a Vector specifying the column names of the secondary table that be used to combine the two tables

principalTableRequestedColumns - column list that be requested in the query from principal table

secondaryTableRequestedColumns - column list that be requested in the query from secondary table

principalTableConditions - a Hashtable specifying conditions that must comply the set of records returned from principal table

secondaryTableConditions - a Hashtable specifying conditions that must comply the set of records returned from secondary table

wildcards - column list which wildcards can be used in

columnSorting - column list where query sorting is established

forceDistinct - true if query result cannot have duplicated records

Returns:

a SQLStatement class which stores the SQL Statement and the required values

qualify

public static String qualify(String col,
             String table)

Returns a String with the qualified name.

This static methods creates a qualified name from the column name and the table name. The used pattern is table_name.column_name. If the table name or the column name has special characters, square brackets are used [table_name].[column_name]

Parameters:

col - a String with the column name

table - a String with the table name

Returns:

a String with the qualified name.

createJoinSelectQuery

public static 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)

Returns a SQLStatement class that stores the information needed to execute a select query against two table used a join.

Parameters:

mainTable - name of the principal table the query is executed against

secondaryTable - name of the secondary table the query is executed against

mainKeys - a Vector specifying the column names of the principal table that be used to combine the two tables

secondaryKeys - a Vector specifying the column names of the secondary table that be used to combine the two tables

mainTableRequestedColumns - column list that be requested in the query from principal table

secondaryTableRequestedColumns - column list that be requested in the query from secondary table

mainTableConditions - a Hashtable specifying conditions that must comply the set of records returned from principal table

secondaryTableConditions - a Hashtable specifying conditions that must comply the set of records returned from secondary table

wildcards - column list which wildcards can be used in

columnSorting - column list where query sorting is established

forceDistinct - true if query result cannot have duplicated records

descending - true if sorting should be descending

Returns:

a SQLStatement class which stores the SQL Statement and the required values

getQueryConditionsProcessor

public static SQLStatementBuilder.SQLConditionValuesProcessor getQueryConditionsProcessor()

Returns a instance of SQLConditionValuesProcessor that be used in this class to create the condition string

Returns:

a SQLConditionValuesProcessor class

createQueryConditionsWithoutWhere

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