com.ontimize.db

Class SQLStatementBuilder.DefaultSQLConditionValuesProcessor

java.lang.Object

com.ontimize.db.SQLStatementBuilder.DefaultSQLConditionValuesProcessor

All Implemented Interfaces:

SQLStatementBuilder.SQLConditionValuesProcessor

Direct Known Subclasses:

SQLStatementBuilder.ExtendedSQLConditionValuesProcessor

Enclosing class:

SQLStatementBuilder

public static class SQLStatementBuilder.DefaultSQLConditionValuesProcessor
extends Object
implements SQLStatementBuilder.SQLConditionValuesProcessor

This class provides default implementations for the SQLConditionValuesProcessor interface.

Author:

Imatia Innovation S.L.

Field Summary

Fields

Modifier and Type	Field and Description
protected SQLStatementHandler	handler
static String	upperFunction
protected boolean	upperLike
protected boolean	upperStrings

Constructor Summary

Constructors

Constructor and Description
SQLStatementBuilder.DefaultSQLConditionValuesProcessor()
SQLStatementBuilder.DefaultSQLConditionValuesProcessor(boolean upperLike) Creates a DefaultSQLConditionValuesProcessor where every condition that uses LIKE is case-insensitive.
SQLStatementBuilder.DefaultSQLConditionValuesProcessor(boolean upperStrings, boolean upperLike) Creates a DefaultSQLConditionValuesProcessor where every condition that uses LIKE or is a column of String type is case-insensitive.

Method Summary

Methods

Modifier and Type	Method and Description
String	createQueryConditions(Hashtable conditions, Vector wildcards, Vector values) Creates the condition string for a SQL Statement.
protected SQLStatementHandler	getSQLStatementHandler()
boolean	getUpperLike()
boolean	getUpperStrings()
protected static boolean	hasParenthesis(String sqlquery) Checks if the string contains a parenthesis
void	setSQLStatementHandler(SQLStatementHandler handler)

Methods inherited from class java.lang.Object

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

Field Detail

upperLike

protected boolean upperLike

upperStrings

protected boolean upperStrings

upperFunction

public static String upperFunction

handler

protected SQLStatementHandler handler

Constructor Detail

SQLStatementBuilder.DefaultSQLConditionValuesProcessor

public SQLStatementBuilder.DefaultSQLConditionValuesProcessor()

SQLStatementBuilder.DefaultSQLConditionValuesProcessor

public SQLStatementBuilder.DefaultSQLConditionValuesProcessor(boolean upperLike)

Creates a DefaultSQLConditionValuesProcessor where every condition that uses LIKE is case-insensitive.

Inserts a upper function in both sides of LIKE conditions (UPPER(Field) LIKE UPPER(Value))

Parameters:

upperLike - true if the LIKE condition should be case-insensitive

SQLStatementBuilder.DefaultSQLConditionValuesProcessor

public SQLStatementBuilder.DefaultSQLConditionValuesProcessor(boolean upperStrings,
                                                      boolean upperLike)

Creates a DefaultSQLConditionValuesProcessor where every condition that uses LIKE or is a column of String type is case-insensitive.

Inserts a upper function in both sides of LIKE conditions (UPPER(Field) LIKE UPPER(Value)) Inserts a upper function in both sides if column type is a String (UPPER(Field) LIKE UPPER(String))

Parameters:

upperStrings - true if the String column type should be case-insensitive

upperLike - true if the LIKE condition should be case-insensitive

Method Detail

getSQLStatementHandler

protected SQLStatementHandler getSQLStatementHandler()

setSQLStatementHandler

public void setSQLStatementHandler(SQLStatementHandler handler)

Specified by:

setSQLStatementHandler in interface SQLStatementBuilder.SQLConditionValuesProcessor

hasParenthesis

protected static boolean hasParenthesis(String sqlquery)

Checks if the string contains a parenthesis

Parameters:

sqlquery - string to check

Returns:

true if the string contains a parenthesis

createQueryConditions

public String createQueryConditions(Hashtable conditions,
                           Vector wildcards,
                           Vector values)

Creates the condition string for a SQL Statement.

Specified by:

createQueryConditions in interface SQLStatementBuilder.SQLConditionValuesProcessor

Parameters:

conditions - a Hashtable specifying pairs of key-value corresponding to the attribute (or column of a table in a database) and the value that is formed by the condition.

wildcards - column list that can use wildcards

values - vector where the value of each processed conditions is stored

Returns:

getUpperLike

public boolean getUpperLike()

Specified by:

getUpperLike in interface SQLStatementBuilder.SQLConditionValuesProcessor

getUpperStrings

public boolean getUpperStrings()

Specified by:

getUpperStrings in interface SQLStatementBuilder.SQLConditionValuesProcessor