de.must.dataobj

Class WhereCondition

java.lang.Object

de.must.dataobj.WhereConditionStd

de.must.dataobj.WhereCondition

public class WhereCondition
extends WhereConditionStd

A class to concatenate where conditions with automatically filled in "and". "'" are replaced by "''" in column values. Thus, fragments like "don't ..." may be searched without causing SQL failures. SQL Dialects are matched if DataObject is specified (except simple append(String)).

See Also:

for filtering using prepared statements

Nested Class Summary

Nested classes/interfaces inherited from class de.must.dataobj.WhereConditionStd

WhereConditionStd.AppendVariant

Field Summary

Fields inherited from class de.must.dataobj.WhereConditionStd

AND, EQUALS, GREATER, GREATER_EQUALS, IS_NOT_NULL, LIKE, LOWER, LOWER_EQUALS, NOT_EQUALS, OR, sqlDialect

Constructor Summary

Constructors

Constructor and Description
WhereCondition() Constructs a new where condition.
WhereCondition(DataObject dataObject) Constructs a new where condition, prepared to comply to the SQL dialect given by the specified DataObject class.
WhereCondition(DataObject dataObject, NumericAttribute a, int columnValue) Constructs a new where condition, prepared to comply to the SQL dialect given by the specified DataObject class.

Method Summary

Modifier and Type	Method and Description
void	append(AbstractTextAttribute a, java.lang.String columnValue) Appends a condition fragment with automatic control of "equals" or "like".
void	append(AbstractTextAttribute a, java.lang.String relation, java.lang.String columnValue) Appends a condition fragment with automatic control of "equals" or "like".
void	append(BooleanAttribute a, boolean columnValue) Appends a boolean condition fragment.
void	append(DateAttribute a, java.lang.String relation, java.sql.Date dateToCompare) Appends a date selection fragment to the where condition.
void	append(int preferredCombination, java.lang.String conditionFragement) Appends a fragment to the where condition if not null and not an empty string.
void	append(int combination, java.lang.String columnName, boolean b) Appends a boolean condition fragment.
void	append(int combination, java.lang.String columnName, boolean b, DataObject dataObject) Appends a boolean condition fragment.
void	append(int combination, java.lang.String columnName, boolean b, SqlDialect sqlDialect) Appends a boolean condition fragment.
void	append(int combination, java.lang.String columnName, java.sql.Date dateToCompare, DataObject dataObject) Appends a date selection fragment to the where condition.
void	append(int combination, java.lang.String columnName, int columnValue) Appends a condition fragment for a integer value.
void	append(int preferredCombination, java.lang.String preamble, java.lang.String conditionFragement) Appends a fragment to the where condition if not null and not an empty string.
void	append(int combination, java.lang.String columnName, java.lang.String relation, java.sql.Date dateToCompare) Appends a date selection fragment to the where condition.
void	append(int combination, java.lang.String columnName, java.lang.String relation, java.sql.Date dateToCompare, DataObject dataObject) Appends a date selection fragment to the where condition.
void	append(int combination, java.lang.String columnName, java.lang.String relation, double columnValue) Appends a condition fragment for a integer value.
void	append(int combination, java.lang.String columnName, java.lang.String relation, double columnValue, boolean zeroAlsoNull) Appends a condition fragment for a integer value.
void	append(int combination, java.lang.String columnName, java.lang.String relation, int columnValue) Appends a condition fragment for a integer value.
void	append(int combination, java.lang.String columnName, java.lang.String relation, int columnValue, boolean zeroAlsoNull) Appends a condition fragment for a integer value.
void	append(int combination, java.lang.String preamble, java.lang.String columnName, java.lang.String relation, java.sql.Date dateToCompare) Appends a date selection fragment to the where condition if not null and not empty.
void	append(int combination, java.lang.String preamble, java.lang.String columnName, java.lang.String relation, java.sql.Date dateToCompare, boolean treatNullDateValuesAsVeryEarly) Appends a date selection fragment to the where condition if not null and not empty.
void	append(int combination, java.lang.String preamble, java.lang.String columnName, java.lang.String relation, java.sql.Date dateToCompare, DataObject dataObject) Appends a date selection fragment to the where condition if not null and not empty.
void	append(int combination, java.lang.String preamble, java.lang.String columnName, java.lang.String relation, java.sql.Date dateToCompare, DataObject dataObject, boolean treatNullDateValuesAsVeryEarly) Appends a date selection fragment to the where condition if not null and not empty.
void	append(int combination, java.lang.String preamble, java.lang.String columnName, java.lang.String relation, java.sql.Date dateToCompare, SqlDialect sqlDialect) Appends a date selection fragment to the where condition if not null and not empty.
void	append(int combination, java.lang.String preamble, java.lang.String columnName, java.lang.String relation, java.sql.Date dateToCompare, SqlDialect sqlDialect, boolean treatNullDateValuesAsVeryEarly) Appends a date selection fragment to the where condition if not null and not empty.
void	append(int combination, java.lang.String preamble, java.lang.String columnName, java.lang.String relation, double columnValue, boolean zeroAlsoNull) Appends a condition fragment for a double value.
void	append(int combination, java.lang.String preamble, java.lang.String columnName, java.lang.String relation, java.lang.String columnValue, boolean emptyAlsoNull) Appends a condition fragment with automatic control of "equals" or "like".
void	append(int combination, java.lang.String preamble, java.lang.String columnName, java.lang.String relation, java.sql.Timestamp timestampToCompare, boolean treatNullDateValuesAsVeryEarly)
void	append(int combinationToUse, WhereCondition anotherWhereCondition) Adds another where condition to this where condition managing additional brackets if necessary.
void	append(NumericAttribute a, int columnValue) Appends a condition fragment with automatic control of "equals" or "like".
void	append(NumericAttribute a, java.lang.String relation, int columnValue) Appends a condition fragment for a integer value.
void	append(java.lang.String conditionFragement) Appends a fragment to the where condition if not null and not an empty string.
void	append(java.lang.String columnName, boolean columnValue) Appends a boolean condition fragment.
void	append(java.lang.String columnName, boolean b, DataObject dataObject) Appends a boolean condition fragment.
void	append(java.lang.String columnName, java.sql.Date dateToCompare, DataObject dataObject) Appends a date selection fragment to the where condition if not null and not empty.
void	append(java.lang.String columnName, double columnValue) Appends a condition fragment for a integer value.
void	append(java.lang.String columnName, int columnValue) Appends a condition fragment.
void	append(java.lang.String columnName, int columnValue, boolean zeroAlsoNull) Appends a condition fragment for a integer value.
void	append(java.lang.String columnName, SearchContent searchContent)
void	append(java.lang.String columnName, SearchContent searchContent, WhereConditionStd.AppendVariant variant) Appends to where condition has search content has content.
void	append(java.lang.String columnName, java.lang.String columnValue) Appends a condition fragment with automatic control of "equals" or "like".
void	append(java.lang.String columnName, java.lang.String columnValue, boolean emptyAlsoNull) Appends a condition fragment with automatic control of "equals" or "like".
void	append(java.lang.String columnName, java.lang.String relation, java.sql.Date dateToCompare) Appends a date selection fragment to the where condition.
void	append(java.lang.String columnName, java.lang.String relation, java.sql.Date dateToCompare, DataObject dataObject) Appends a date selection fragment to the where condition.
void	append(java.lang.String columnName, java.lang.String relation, java.sql.Date dateToCompare, DataObject dataObject, boolean treatNullDateValuesAsVeryEarly) Appends a date selection fragment to the where condition.
void	append(java.lang.String columnName, java.lang.String relation, int columnValue) Appends a condition fragment for a integer value.
void	append(java.lang.String columnName, java.lang.String relation, java.lang.String columnValue) Appends a condition fragment with automatic control of "equals" or "like".
void	append(java.lang.String columnName, java.lang.String relation, java.sql.Timestamp timestampToCompare)
void	append(java.lang.String columnName, java.lang.String columnValue, WhereConditionStd.AppendVariant variant)
void	append(VarcharAttribute a, SearchContent searchContent)
void	append(VarcharAttribute a, java.lang.String columnValue) Appends a condition fragment with automatic control of "equals" or "like".
void	append(VarcharAttribute a, java.lang.String columnValue, WhereConditionStd.AppendVariant variant)
void	append(WhereCondition anotherWhereCondition) Adds another where condition to this where condition managing additional brackets if necessary.
void	appendContains(java.lang.String[] columns, java.lang.String searchValue)
void	appendEntireWordSearch(java.lang.String columnName, java.lang.String word)
void	appendEntireWordSearch(java.lang.String columnName, java.lang.String word, boolean orInsteadOfAnd)
void	appendEntireWordSearch(java.lang.String columnName, java.lang.String word, java.lang.String delimiters) Appends a where-condition part searching for an expression as an entire word or word group separated by ';' or ','.
void	appendEntireWordSearch(java.lang.String columnName, java.lang.String word, java.lang.String delimiters, boolean orInsteadOfAnd) Appends a where-condition part searching for an expression as an entire word or word group separated by ';' or ','.
void	appendEqualsOrEmpty(java.lang.String columnName, java.lang.String columnValue) Appends a condition fragment searching for empty values or exact matching.
void	appendEqualsOrEmptyAsOrCombination(java.lang.String columnName, java.lang.String columnValue) Appends a condition fragment searching for empty values or exact matching.
void	appendLike(java.lang.String[] columns, java.lang.String searchValue)
void	appendLike(java.lang.String[] columns, java.lang.String searchValue, boolean searchDateVariants)
void	appendLikeOrContains(java.lang.String[] columns, java.lang.String searchValue)
void	appendLowerEqual(java.lang.String columnName, java.sql.Date dateToCompare) Appends a date lower equals condition fragment to the where condition if not null.
void	appendLowerEqual(java.lang.String columnName, java.sql.Date dateToCompare, boolean treatNullDateValuesAsVeryEarly) Appends a date lower equals condition fragment to the where condition if not null.
void	appendLowerEqual(java.lang.String columnName, java.sql.Date dateToCompare, DataObject dataObject) Appends a date lower equals condition fragment to the where condition if not null.
void	appendLowerEqual(java.lang.String columnName, java.sql.Date dateToCompare, DataObject dataObject, boolean treatNullDateValuesAsVeryEarly) Appends a date lower equals condition fragment to the where condition if not null.
void	appendOr(AbstractAttribute a, java.lang.String columnValue) Appends a condition fragment with automatic control of "equals" or "like" - combination to previous fragments is 'or'.
void	appendOr(java.lang.String conditionFragement) Appends a fragment to the where condition if not null and not an empty string as OR condition.
void	appendOr(java.lang.String columnName, java.sql.Date dateToCompare) Appends a date selection fragment to the where condition if not null and not empty.
void	appendOr(java.lang.String columnName, int columnValue) Appends a condition fragment.
void	appendOr(java.lang.String columnName, java.lang.String columnValue) Appends a condition fragment with automatic control of "equals" or "like" - combination to previous fragments is 'or'.
void	appendOr(java.lang.String columnName, java.lang.String relation, java.lang.String columnValue) Appends a condition fragment with automatic control of "equals" or "like" - combination to previous fragments is 'or'.
void	appendOr(WhereCondition anotherWhereCondition) Adds another where condition to this where condition managing additional brackets if necessary as OR condition.
void	closeBracket() Closes the bracket by extending this where condition by ')'.
static java.lang.String	getEntireWordCondition(java.lang.String columnName, java.lang.String word, java.lang.String delimiters) Returns a where condition part searching for an expression as an entire word or word group separated by ';', ','.or '\n'
static java.lang.String	getEntireWordCondition(java.lang.String columnName, java.lang.String word, java.lang.String delimiters, boolean oracleIgnoreCase) Returns a where condition part searching for an expression as an entire word or word group separated by ';', ','.or '\n'
static java.lang.String	getEntireWordCondition(java.lang.String columnName, java.lang.String word, java.lang.String delimiters, DataObject dataObject) Returns a where condition part searching for an expression as an entire word or word group separated by ';', ','.or '\n'
static java.lang.String	getEqualsFor(SqlDialect sqlDialect, java.lang.String columnName) Returns the appropriate SQL expression to test for equality.
static java.lang.String	getEqualsIncludingCol(DataObject dataObject, java.lang.String columnName)
static java.lang.String	getWhereFragement(DataObject dataObject, java.lang.String columnName, java.lang.String columnValue)
void	openBracket() Opens a bracket.
void	openBracketAsOrCombination() Opens a bracket.
void	setAutomaticAsteriskToPercent(boolean automaticAsteriskToPercent) Sets automatic exchange from * to % on or off.
java.lang.String	toString() Returns the complete where condition as a string.

Methods inherited from class de.must.dataobj.WhereConditionStd

getColumnNameWoTablePrefix, getColumnType, getDayBeginDate, getDayEndingDate, getDefaultRelation, getNextDayBeginDate, isToCast, isToCast, isToUseUpperCase, isToUseUpperCase

Methods inherited from class java.lang.Object

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

Constructor Detail

WhereCondition

public WhereCondition()

Constructs a new where condition. Suitable for condition that do not have to differ between SQL dialects.

WhereCondition

public WhereCondition(DataObject dataObject)

Constructs a new where condition, prepared to comply to the SQL dialect given by the specified DataObject class. To achieve this, the method ensureMetaDataIsAvailableForAllColumns() of the specified data object will be called. Thus, all data types of the column will be known.

Parameters:

dataObject - the DataObject class to refer to the SQL dialect to comply to

WhereCondition

public WhereCondition(DataObject dataObject,
                      NumericAttribute a,
                      int columnValue)

Constructs a new where condition, prepared to comply to the SQL dialect given by the specified DataObject class. To achieve this, the method ensureMetaDataIsAvailableForAllColumns() of the specified data object will be called. Thus, all data types of the column will be known.

Parameters:

dataObject - the DataObject class to refer to the SQL dialect to comply to

a - the attribute containing name of the column to be used

columnValue - the column value to be selected

Method Detail

getEntireWordCondition

public static java.lang.String getEntireWordCondition(java.lang.String columnName,
                                                      java.lang.String word,
                                                      java.lang.String delimiters)

Returns a where condition part searching for an expression as an entire word or word group separated by ';', ','.or '\n'

Parameters:

columnName - the name of the column to be searched in

word - the word or word group to be found

delimiters - the chars separating one word from the other

Returns:

the where-condition part

getEntireWordCondition

public static java.lang.String getEntireWordCondition(java.lang.String columnName,
                                                      java.lang.String word,
                                                      java.lang.String delimiters,
                                                      DataObject dataObject)

Returns a where condition part searching for an expression as an entire word or word group separated by ';', ','.or '\n'

Parameters:

columnName - the name of the column to be searched in

word - the word or word group to be found

delimiters - the chars separating one word from the other

dataObject - the DataObject class to refer to the SQL dialect to comply to

Returns:

the where-condition part

getEntireWordCondition

public static java.lang.String getEntireWordCondition(java.lang.String columnName,
                                                      java.lang.String word,
                                                      java.lang.String delimiters,
                                                      boolean oracleIgnoreCase)

Returns a where condition part searching for an expression as an entire word or word group separated by ';', ','.or '\n'

Parameters:

columnName - the name of the column to be searched in

word - the word or word group to be found

delimiters - the chars separating one word from the other

oracleIgnoreCase - whether or not the expression has to be extended to provide ignore case search

Returns:

the where-condition part

getWhereFragement

public static java.lang.String getWhereFragement(DataObject dataObject,
                                                 java.lang.String columnName,
                                                 java.lang.String columnValue)

getEqualsIncludingCol

public static java.lang.String getEqualsIncludingCol(DataObject dataObject,
                                                     java.lang.String columnName)

getEqualsFor

public static java.lang.String getEqualsFor(SqlDialect sqlDialect,
                                            java.lang.String columnName)

Returns the appropriate SQL expression to test for equality. Normally, it's =, but in some cases it has to be LIKE.

Parameters:

sqlDialect - the SQL dialect to be supported

columnName - the name of the column to check for equality

Returns:

the appropriate SQL expression to test for equality

setAutomaticAsteriskToPercent

public void setAutomaticAsteriskToPercent(boolean automaticAsteriskToPercent)

Sets automatic exchange from * to % on or off.

Parameters:

automaticAsteriskToPercent - whether or not * is automatically to be changed to %

appendEqualsOrEmpty

public void appendEqualsOrEmpty(java.lang.String columnName,
                                java.lang.String columnValue)

Appends a condition fragment searching for empty values or exact matching. Applicable e.g. for profile matching.

Parameters:

columnName - the name of the column to match the specified value

columnValue - the column value to be selected

appendEqualsOrEmptyAsOrCombination

public void appendEqualsOrEmptyAsOrCombination(java.lang.String columnName,
                                               java.lang.String columnValue)

Appends a condition fragment searching for empty values or exact matching. Combination " or " will be added automatically if necessary. Applicable e.g. for profile matching.

Parameters:

columnName - the name of the column to match the specified value

columnValue - the column value to be selected

append

public void append(VarcharAttribute a,
                   SearchContent searchContent)

append

public void append(java.lang.String columnName,
                   SearchContent searchContent)

append

public void append(java.lang.String columnName,
                   SearchContent searchContent,
                   WhereConditionStd.AppendVariant variant)

Appends to where condition has search content has content.

Parameters:

columnValue - the column value to be selected

searchContent - the search content providing content

variant - the variant to append the condition fragment

append

public void append(AbstractTextAttribute a,
                   java.lang.String columnValue)

Appends a condition fragment with automatic control of "equals" or "like". Supports wildcards "*" and "%" at the end of the column value. "'" are replaced by "''" in column values. Thus, fragments like "don't ..." may be searched without causing SQL failures.

Parameters:

a - the attribute containing the column name

columnValue - the column value to be selected

append

public void append(VarcharAttribute a,
                   java.lang.String columnValue)

Appends a condition fragment with automatic control of "equals" or "like". Supports wildcards "*" and "%" at the end of the column value. "'" are replaced by "''" in column values. Thus, fragments like "don't ..." may be searched without causing SQL failures.

Parameters:

a - the attribute containing the column name

columnValue - the column value to be selected

append

public void append(VarcharAttribute a,
                   java.lang.String columnValue,
                   WhereConditionStd.AppendVariant variant)

append

public void append(java.lang.String columnName,
                   java.lang.String columnValue,
                   WhereConditionStd.AppendVariant variant)

append

public void append(java.lang.String columnName,
                   java.lang.String columnValue)

Appends a condition fragment with automatic control of "equals" or "like". Supports wildcards "*" and "%" at the end of the column value. "'" are replaced by "''" in column values. Thus, fragments like "don't ..." may be searched without causing SQL failures.

Parameters:

columnName - the name of the column to be used

columnValue - the column value to be selected

appendOr

public void appendOr(AbstractAttribute a,
                     java.lang.String columnValue)

Appends a condition fragment with automatic control of "equals" or "like" - combination to previous fragments is 'or'. Supports wildcards "*" and "%" at the end of the column value. "'" are replaced by "''" in column values. Thus, fragments like "don't ..." may be searched without causing SQL failures.

Parameters:

a - the attribute containing the column name

columnValue - the column value to be selected

appendOr

public void appendOr(java.lang.String columnName,
                     java.lang.String columnValue)

Appends a condition fragment with automatic control of "equals" or "like" - combination to previous fragments is 'or'. Supports wildcards "*" and "%" at the end of the column value. "'" are replaced by "''" in column values. Thus, fragments like "don't ..." may be searched without causing SQL failures.

Parameters:

columnName - the name of the column to be used

columnValue - the column value to be selected

appendOr

public void appendOr(java.lang.String columnName,
                     java.lang.String relation,
                     java.lang.String columnValue)

Appends a condition fragment with automatic control of "equals" or "like" - combination to previous fragments is 'or'. Supports wildcards "*" and "%" at the end of the column value. "'" are replaced by "''" in column values. Thus, fragments like "don't ..." may be searched without causing SQL failures.

Parameters:

columnName - the name of the column to be used

relation - the relation to be used (e.g. =, <>)

columnValue - the column value to be selected

append

public void append(AbstractTextAttribute a,
                   java.lang.String relation,
                   java.lang.String columnValue)

Appends a condition fragment with automatic control of "equals" or "like". Supports wildcards "*" and "%" at the end of the column value. "'" are replaced by "''" in column values. Thus, fragments like "don't ..." may be searched without causing SQL failures.

Parameters:

a - the attribute containing the column name

relation - the relation to be used (e.g. =, <>)

columnValue - the column value to be selected

append

public void append(java.lang.String columnName,
                   java.lang.String relation,
                   java.lang.String columnValue)

Appends a condition fragment with automatic control of "equals" or "like". Supports wildcards "*" and "%" at the end of the column value. "'" are replaced by "''" in column values. Thus, fragments like "don't ..." may be searched without causing SQL failures.

Parameters:

columnName - the name of the column to be used

relation - the relation to be used (e.g. =, <>)

columnValue - the column value to be selected

append

public void append(java.lang.String columnName,
                   java.lang.String columnValue,
                   boolean emptyAlsoNull)

Appends a condition fragment with automatic control of "equals" or "like". Supports wildcards "*" and "%" at the end of the column value. "'" are replaced by "''" in column values. Thus, fragments like "don't ..." may be searched without causing SQL errors.

Parameters:

columnName - the name of the column to be used

columnValue - the column value to be selected

emptyAlsoNull - whether or not null values in database should be treated in the same way as empty strings

append

public void append(int combination,
                   java.lang.String preamble,
                   java.lang.String columnName,
                   java.lang.String relation,
                   java.lang.String columnValue,
                   boolean emptyAlsoNull)

Appends a condition fragment with automatic control of "equals" or "like". Supports wildcards "*" and "%" at the end of the column value. "'" are replaced by "''" in column values. Thus, fragments like "don't ..." may be searched without causing SQL errors.

Parameters:

combination - the index of the combination with previous condition fragments

preamble - the preamble to be placed before the search fragment to be constructed, e.g. "myID in (select foreignID from AnotherTable where " - bracket may be closed automatically

columnName - the column name to be used for the comparison

relation - the relation to be used (e.g. =, <>)

columnValue - the column value to be selected

emptyAlsoNull - whether or not null values in database should be treated in the same way as empty strings

See Also:

WhereConditionStd.AND, WhereConditionStd.OR

append

public void append(NumericAttribute a,
                   int columnValue)

Appends a condition fragment with automatic control of "equals" or "like". Supports wildcards "*" and "%" at the end of the column value. "'" are replaced by "''" in column values. Thus, fragments like "don't ..." may be searched without causing SQL failures.

Parameters:

a - the attribute containing the column name

columnValue - the column value to be selected

append

public void append(java.lang.String columnName,
                   int columnValue)

Appends a condition fragment.

Parameters:

columnName - the name of the column to be used

columnValue - the column value to be selected

appendOr

public void appendOr(java.lang.String columnName,
                     int columnValue)

Appends a condition fragment.

Parameters:

columnName - the name of the column to be used

columnValue - the column value to be selected

append

public void append(java.lang.String columnName,
                   int columnValue,
                   boolean zeroAlsoNull)

Appends a condition fragment for a integer value.

Parameters:

columnName - the name of the column to be used

columnValue - the integer column value to be selected

zeroAlsoNull - whether or not null values in database should be treated in the same way as zero values

append

public void append(NumericAttribute a,
                   java.lang.String relation,
                   int columnValue)

Appends a condition fragment for a integer value.

Parameters:

a - the attribute containing the column name

relation - the relation to be used (e.g. =, <>)

columnValue - the numeric column value to select

See Also:

WhereConditionStd.AND, WhereConditionStd.OR

append

public void append(java.lang.String columnName,
                   java.lang.String relation,
                   int columnValue)

Appends a condition fragment for a integer value.

Parameters:

columnName - the name of the column to be used

relation - the relation to be used (e.g. =, <>)

columnValue - the numeric column value to select

See Also:

WhereConditionStd.AND, WhereConditionStd.OR

append

public void append(int combination,
                   java.lang.String columnName,
                   int columnValue)

Appends a condition fragment for a integer value.

Parameters:

combination - the index of the combination with previous condition fragments

columnName - the name of the column to be used

columnValue - the numeric column value to select

See Also:

WhereConditionStd.AND, WhereConditionStd.OR

append

public void append(int combination,
                   java.lang.String columnName,
                   java.lang.String relation,
                   int columnValue)

Appends a condition fragment for a integer value.

Parameters:

combination - the index of the combination with previous condition fragments

columnName - the name of the column to be used

relation - the relation to be used (e.g. =, <>)

columnValue - the numeric column value to select

See Also:

WhereConditionStd.AND, WhereConditionStd.OR

append

public void append(int combination,
                   java.lang.String columnName,
                   java.lang.String relation,
                   int columnValue,
                   boolean zeroAlsoNull)

Appends a condition fragment for a integer value.

Parameters:

combination - the index of the combination with previous condition fragments

columnName - the name of the column to be used

relation - the relation to be used (e.g. =, <>)

columnValue - the numeric column value to select

zeroAlsoNull - whether or not null values should be treated as zero

See Also:

WhereConditionStd.AND, WhereConditionStd.OR

append

public void append(java.lang.String columnName,
                   double columnValue)

Appends a condition fragment for a integer value.

Parameters:

columnName - the column name to be used for the comparison

columnValue - the numeric column value to select

append

public void append(int combination,
                   java.lang.String columnName,
                   java.lang.String relation,
                   double columnValue)

Appends a condition fragment for a integer value.

Parameters:

combination - the index of the combination with previous condition fragments

columnName - the column name to be used for the comparison

relation - the relation to be used (e.g. =, <>)

columnValue - the numeric column value to select

See Also:

WhereConditionStd.AND, WhereConditionStd.OR

append

public void append(int combination,
                   java.lang.String columnName,
                   java.lang.String relation,
                   double columnValue,
                   boolean zeroAlsoNull)

Appends a condition fragment for a integer value.

Parameters:

combination - the index of the combination with previous condition fragments

columnName - the column name to be used for the comparison

relation - the relation to be used (e.g. =, <>)

columnValue - the numeric column value to select

zeroAlsoNull - whether or not null values should be treated as zero

See Also:

WhereConditionStd.AND, WhereConditionStd.OR

append

public void append(int combination,
                   java.lang.String preamble,
                   java.lang.String columnName,
                   java.lang.String relation,
                   double columnValue,
                   boolean zeroAlsoNull)

Appends a condition fragment for a double value.

Parameters:

combination - the index of the combination with previous condition fragments

preamble - the preamble to be placed before the search fragment to be constructed, e.g. "myID in (select foreignID from AnotherTable where " - bracket may be closed automatically

columnName - the column name to be used for the comparison

relation - the relation to be used (e.g. =, <>)

columnValue - the numeric column value to select

zeroAlsoNull - whether or not null values should be treated as zero

See Also:

WhereConditionStd.AND, WhereConditionStd.OR

append

public void append(BooleanAttribute a,
                   boolean columnValue)

Appends a boolean condition fragment.

Parameters:

a - the attribute containing the column name

columnValue - the column value to be selected

append

public void append(java.lang.String columnName,
                   boolean columnValue)

Appends a boolean condition fragment.

Parameters:

columnName - the name of the column to be used

columnValue - the column value to be selected

append

public void append(java.lang.String columnName,
                   boolean b,
                   DataObject dataObject)

Appends a boolean condition fragment.

Parameters:

columnName - the name of the column to be used

columnValue - the column value to be selected

dataObject - the data object to be used to define boolean comparison

append

public void append(int combination,
                   java.lang.String columnName,
                   boolean b)

Appends a boolean condition fragment.

Parameters:

combination - the index of the combination with previous condition fragments

columnName - the name of the column to be used

columnValue - the column value to be selected

See Also:

WhereConditionStd.AND, WhereConditionStd.OR

append

public void append(int combination,
                   java.lang.String columnName,
                   boolean b,
                   DataObject dataObject)

Appends a boolean condition fragment.

Parameters:

combination - the index of the combination with previous condition fragments

columnName - the name of the column to be used

columnValue - the column value to be selected

dataObject - the data object to be used to define boolean comparison

See Also:

WhereConditionStd.AND, WhereConditionStd.OR

append

public void append(int combination,
                   java.lang.String columnName,
                   boolean b,
                   SqlDialect sqlDialect)

Appends a boolean condition fragment.

Parameters:

combination - the index of the combination with previous condition fragments

columnName - the name of the column to be used

columnValue - the column value to be selected

sqlDialect - the SQL dialect to be used to define boolean comparison

See Also:

WhereConditionStd.AND, WhereConditionStd.OR

appendEntireWordSearch

public void appendEntireWordSearch(java.lang.String columnName,
                                   java.lang.String word)

appendEntireWordSearch

public void appendEntireWordSearch(java.lang.String columnName,
                                   java.lang.String word,
                                   boolean orInsteadOfAnd)

appendEntireWordSearch

public void appendEntireWordSearch(java.lang.String columnName,
                                   java.lang.String word,
                                   java.lang.String delimiters)

Appends a where-condition part searching for an expression as an entire word or word group separated by ';' or ','.

Parameters:

columnName - the name of the column to be searched in

word - the word or word group to be found

appendEntireWordSearch

public void appendEntireWordSearch(java.lang.String columnName,
                                   java.lang.String word,
                                   java.lang.String delimiters,
                                   boolean orInsteadOfAnd)

Appends a where-condition part searching for an expression as an entire word or word group separated by ';' or ','.

Parameters:

columnName - the name of the column to be searched in

word - the word or word group to be found

orInsteadOfAnd - if true, this condition fragment is combined with 'or' instead of 'and' with existing former fragments.

appendLikeOrContains

public void appendLikeOrContains(java.lang.String[] columns,
                                 java.lang.String searchValue)

appendLike

public void appendLike(java.lang.String[] columns,
                       java.lang.String searchValue)

appendLike

public void appendLike(java.lang.String[] columns,
                       java.lang.String searchValue,
                       boolean searchDateVariants)

appendContains

public void appendContains(java.lang.String[] columns,
                           java.lang.String searchValue)

append

public void append(java.lang.String conditionFragement)

Appends a fragment to the where condition if not null and not an empty string. Fills in " and " if necessary.

Parameters:

conditionFragement - the condition fragment

appendOr

public void appendOr(java.lang.String conditionFragement)

Appends a fragment to the where condition if not null and not an empty string as OR condition.

Parameters:

conditionFragement - the condition fragment

append

public void append(int preferredCombination,
                   java.lang.String conditionFragement)

Appends a fragment to the where condition if not null and not an empty string. The condition fragment is appended without manipulations to fit SQL dialects.

Parameters:

preferredCombination - the index of the preferred combination - the specified combination will be added automatically if the search fragment doesn't already contain a combination expression.

conditionFragement - the condition fragment to be added to this where condition

See Also:

WhereConditionStd.AND, WhereConditionStd.OR

append

public void append(int preferredCombination,
                   java.lang.String preamble,
                   java.lang.String conditionFragement)

Appends a fragment to the where condition if not null and not an empty string.

Parameters:

preferredCombination - the index of the preferred combination - the specified combination will be added automatically if the search fragment doesn't already contain a combination expression.

preamble - the preamble to be placed before the search fragment to be constructed, e.g. "myID in (select foreignID from AnotherTable where " - brackets may be closed automatically

conditionFragement - the condition fragment to be added to this where condition

See Also:

WhereConditionStd.AND, WhereConditionStd.OR

appendLowerEqual

public void appendLowerEqual(java.lang.String columnName,
                             java.sql.Date dateToCompare)

Appends a date lower equals condition fragment to the where condition if not null. Usable only for where condition constructed with data object. Fills in " and " if necessary. Puts focus on date without time in case of MS Access to select all rows of the end date. Caution: seems not to work in case of join!

Parameters:

columnName - the name of the conditional date field

dateToCompare - the date to compare

appendLowerEqual

public void appendLowerEqual(java.lang.String columnName,
                             java.sql.Date dateToCompare,
                             boolean treatNullDateValuesAsVeryEarly)

Appends a date lower equals condition fragment to the where condition if not null. Usable only for where condition constructed with data object. Fills in " and " if necessary. Puts focus on date without time in case of MS Access to select all rows of the end date. Caution: seems not to work in case of join!

Parameters:

columnName - the name of the conditional date field

dateToCompare - the date to compare

treatNullDateValuesAsVeryEarly - whether or not missing date values (null) should be treated as very early

appendLowerEqual

public void appendLowerEqual(java.lang.String columnName,
                             java.sql.Date dateToCompare,
                             DataObject dataObject)

Appends a date lower equals condition fragment to the where condition if not null. Fills in " and " if necessary. Puts focus on date without time in case of MS Access to select all rows of the end date. Caution: seems not to work in case of join!

Parameters:

fieldName - the name of the conditional date field

dateToCompare - the date to compare

dataObject - the data object whose SQL dialect is to be satisfied

appendLowerEqual

public void appendLowerEqual(java.lang.String columnName,
                             java.sql.Date dateToCompare,
                             DataObject dataObject,
                             boolean treatNullDateValuesAsVeryEarly)

Appends a date lower equals condition fragment to the where condition if not null. Fills in " and " if necessary. Puts focus on date without time in case of MS Access to select all rows of the end date. Caution: seems not to work in case of join!

Parameters:

fieldName - the name of the conditional date field

dateToCompare - the date to compare

dataObject - the data object whose SQL dialect is to be satisfied

treatNullDateValuesAsVeryEarly - whether or not missing date values (null) should be treated as very early

append

public void append(java.lang.String columnName,
                   java.sql.Date dateToCompare,
                   DataObject dataObject)

Appends a date selection fragment to the where condition if not null and not empty. Fills in " and " of necessary.

Parameters:

columnName - the column name to be used for the date comparison

dateToCompare - the date value to be compared with the column

dataObject - the data object to be used to format date comparison

appendOr

public void appendOr(java.lang.String columnName,
                     java.sql.Date dateToCompare)

Appends a date selection fragment to the where condition if not null and not empty. Fills in " or " of necessary.

Parameters:

columnName - the column name to be used for the date comparison

dateToCompare - the date value to be compared with the column

append

public void append(java.lang.String columnName,
                   java.lang.String relation,
                   java.sql.Date dateToCompare,
                   DataObject dataObject)

Appends a date selection fragment to the where condition. Fills in " and " of necessary.

Parameters:

columnName - the column name to be used for the date comparison

relation - the relation to be used (e.g. =, <>)

dateToCompare - the date value to be compared with the column

dataObject - the data object to be used to format date comparison

append

public void append(java.lang.String columnName,
                   java.lang.String relation,
                   java.sql.Date dateToCompare,
                   DataObject dataObject,
                   boolean treatNullDateValuesAsVeryEarly)

Appends a date selection fragment to the where condition. Fills in " and " of necessary.

Parameters:

columnName - the column name to be used for the date comparison

relation - the relation to be used (e.g. =, <>)

dateToCompare - the date value to be compared with the column

dataObject - the data object to be used to format date comparison

treatNullDateValuesAsVeryEarly - whether or not missing date values (null) should be treated as very early

append

public void append(int combination,
                   java.lang.String columnName,
                   java.sql.Date dateToCompare,
                   DataObject dataObject)

Appends a date selection fragment to the where condition.

Parameters:

combination - the index of the combination with previous condition fragments

columnName - the column name to be used for the date comparison

dateToCompare - the date value to be compared with the column

dataObject - the data object to be used to format date comparison

See Also:

WhereConditionStd.AND, WhereConditionStd.OR

append

public void append(DateAttribute a,
                   java.lang.String relation,
                   java.sql.Date dateToCompare)

Appends a date selection fragment to the where condition. Fills in " and " of necessary.

Parameters:

a - the attribute containing the column name

relation - the relation to be used (e.g. =, <>)

dateToCompare - the date value to be compared with the column

append

public void append(java.lang.String columnName,
                   java.lang.String relation,
                   java.sql.Date dateToCompare)

Appends a date selection fragment to the where condition. Fills in " and " of necessary.

Parameters:

columnName - the column name to be used for the date comparison

relation - the relation to be used (e.g. =, <>)

dateToCompare - the date value to be compared with the column

append

public void append(int combination,
                   java.lang.String columnName,
                   java.lang.String relation,
                   java.sql.Date dateToCompare)

Appends a date selection fragment to the where condition.

Parameters:

combination - the index of the combination with previous condition fragments

columnName - the column name to be used for the date comparison

relation - the relation to be used (e.g. =, <>)

dateToCompare - the date value to be compared with the column

See Also:

WhereConditionStd.AND, WhereConditionStd.OR

append

public void append(int combination,
                   java.lang.String columnName,
                   java.lang.String relation,
                   java.sql.Date dateToCompare,
                   DataObject dataObject)

Appends a date selection fragment to the where condition.

Parameters:

combination - the index of the combination with previous condition fragments

columnName - the column name to be used for the date comparison

relation - the relation to be used (e.g. =, <>)

dateToCompare - the date value to be compared with the column

dataObject - the data object to be used to format date comparison

See Also:

WhereConditionStd.AND, WhereConditionStd.OR

append

public void append(int combination,
                   java.lang.String preamble,
                   java.lang.String columnName,
                   java.lang.String relation,
                   java.sql.Date dateToCompare,
                   DataObject dataObject)

Appends a date selection fragment to the where condition if not null and not empty. Fills in " and " of necessary.

Parameters:

combination - the index of the combination with previous condition fragments

preamble - the preamble to be placed before the search fragment to be constructed, e.g. "myID in (select foreignID from AnotherTable where " - bracket may be closed automatically

columnName - the column name to be used for the date comparison

relation - the relation to be used (e.g. =, <>)

dateToCompare - the date value to be compared with the column

dataObject - the data object to be used to format date comparison

See Also:

WhereConditionStd.AND, WhereConditionStd.OR

append

public void append(int combination,
                   java.lang.String preamble,
                   java.lang.String columnName,
                   java.lang.String relation,
                   java.sql.Date dateToCompare,
                   DataObject dataObject,
                   boolean treatNullDateValuesAsVeryEarly)

Appends a date selection fragment to the where condition if not null and not empty. Fills in " and " of necessary.

Parameters:

combination - the index of the combination with previous condition fragments

preamble - the preamble to be placed before the search fragment to be constructed, e.g. "myID in (select foreignID from AnotherTable where " - bracket may be closed automatically

columnName - the column name to be used for the date comparison

relation - the relation to be used (e.g. =, <>)

dateToCompare - the date value to be compared with the column

dataObject - the data object to be used to format date comparison

treatNullDateValuesAsVeryEarly - whether or not missing date values (null) should be treated as very early

See Also:

WhereConditionStd.AND, WhereConditionStd.OR

append

public void append(int combination,
                   java.lang.String preamble,
                   java.lang.String columnName,
                   java.lang.String relation,
                   java.sql.Date dateToCompare)

Appends a date selection fragment to the where condition if not null and not empty. Fills in " and " of necessary.

Parameters:

combination - the index of the combination with previous condition fragments

preamble - the preamble to be placed before the search fragment to be constructed, e.g. "myID in (select foreignID from AnotherTable where " - bracket may be closed automatically

columnName - the column name to be used for the date comparison

relation - the relation to be used (e.g. =, <>)

dateToCompare - the date value to be compared with the column

See Also:

WhereConditionStd.AND, WhereConditionStd.OR

append

public void append(int combination,
                   java.lang.String preamble,
                   java.lang.String columnName,
                   java.lang.String relation,
                   java.sql.Date dateToCompare,
                   boolean treatNullDateValuesAsVeryEarly)

Appends a date selection fragment to the where condition if not null and not empty. Fills in " and " of necessary.

Parameters:

combination - the index of the combination with previous condition fragments

preamble - the preamble to be placed before the search fragment to be constructed, e.g. "myID in (select foreignID from AnotherTable where " - bracket may be closed automatically

columnName - the column name to be used for the date comparison

relation - the relation to be used (e.g. =, <>)

dateToCompare - the date value to be compared with the column

treatNullDateValuesAsVeryEarly - whether or not missing date values (null) should be treated as very early

See Also:

WhereConditionStd.AND, WhereConditionStd.OR

append

public void append(int combination,
                   java.lang.String preamble,
                   java.lang.String columnName,
                   java.lang.String relation,
                   java.sql.Date dateToCompare,
                   SqlDialect sqlDialect)

Appends a date selection fragment to the where condition if not null and not empty. Fills in " and " of necessary.

Parameters:

combination - the index of the combination with previous condition fragments

preamble - the preamble to be placed before the search fragment to be constructed, e.g. "myID in (select foreignID from AnotherTable where " - bracket may be closed automatically

columnName - the column name to be used for the date comparison

relation - the relation to be used (e.g. =, <>)

dateToCompare - the date value to be compared with the column

sqlDialact - the used SQL dialect

See Also:

WhereConditionStd.AND, WhereConditionStd.OR

append

public void append(int combination,
                   java.lang.String preamble,
                   java.lang.String columnName,
                   java.lang.String relation,
                   java.sql.Date dateToCompare,
                   SqlDialect sqlDialect,
                   boolean treatNullDateValuesAsVeryEarly)

Appends a date selection fragment to the where condition if not null and not empty. Fills in " and " of necessary.

Parameters:

combination - the index of the combination with previous condition fragments

preamble - the preamble to be placed before the search fragment to be constructed, e.g. "myID in (select foreignID from AnotherTable where " - bracket may be closed automatically

columnName - the column name to be used for the date comparison

relation - the relation to be used (e.g. =, <>)

dateToCompare - the date value to be compared with the column

sqlDialact - the used SQL dialect

treatNullDateValuesAsVeryEarly - whether or not missing date values (null) should be treated as very early

See Also:

WhereConditionStd.AND, WhereConditionStd.OR

append

public void append(java.lang.String columnName,
                   java.lang.String relation,
                   java.sql.Timestamp timestampToCompare)

append

public void append(int combination,
                   java.lang.String preamble,
                   java.lang.String columnName,
                   java.lang.String relation,
                   java.sql.Timestamp timestampToCompare,
                   boolean treatNullDateValuesAsVeryEarly)

append

public void append(WhereCondition anotherWhereCondition)

Adds another where condition to this where condition managing additional brackets if necessary.

Parameters:

anotherWhereCondition - the other where condition to append

appendOr

public void appendOr(WhereCondition anotherWhereCondition)

Adds another where condition to this where condition managing additional brackets if necessary as OR condition.

Parameters:

anotherWhereCondition - the other where condition to append

append

public void append(int combinationToUse,
                   WhereCondition anotherWhereCondition)

Adds another where condition to this where condition managing additional brackets if necessary.

Parameters:

combination - the index of the combination with previous condition fragments

anotherWhereCondition - the other where condition to append

openBracket

public void openBracket()

Opens a bracket. Combination " and " will be added automatically if necessary.

openBracketAsOrCombination

public void openBracketAsOrCombination()

Opens a bracket. Combination " or " will be added automatically if necessary.

closeBracket

public void closeBracket()

Closes the bracket by extending this where condition by ')'.

toString

public java.lang.String toString()

Returns the complete where condition as a string.

Overrides:

toString in class java.lang.Object

Returns:

the complete where condition as a string