de.must.dataobj

Class WhereConditionForPrepStmts

java.lang.Object

de.must.dataobj.WhereConditionStd

de.must.dataobj.WhereConditionForPrepStmts

public class WhereConditionForPrepStmts
extends WhereConditionStd

Class to build where conditions for queries using prepared statements. Less features are supported in comparison with class WhereCondition.

See Also:

for more complex filtering

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
WhereConditionForPrepStmts(AbstractTextAttribute a, java.lang.String columnValue) Constructs a new where condition for prepared statements and append a condition fragment.
WhereConditionForPrepStmts(CharAttribute a, Identifier identifier) Constructs a new where condition for prepared statements and append a condition fragment.
WhereConditionForPrepStmts(DataObject dataObject) Constructs a new where condition.
WhereConditionForPrepStmts(NumericAttribute a, Identifier identifier) Constructs a new where condition for prepared statements and append a condition fragment.
WhereConditionForPrepStmts(NumericAttribute a, int columnValue) Constructs a new where condition for prepared statements and append a condition fragment.
WhereConditionForPrepStmts(java.lang.String columnName, java.lang.String columnValue) Constructs a new where condition for prepared statements and append a condition fragment.

Method Summary

Modifier and Type	Method and Description
void	append(AbstractTextAttribute a, java.lang.String columnValue) Appends a value selection fragment to the where condition.
void	append(AbstractTextAttribute a, java.lang.String relation, java.lang.String columnValue) Appends a value selection fragment to the where condition.
void	append(BooleanAttribute a, boolean columnValue) Appends a value selection fragment to the where condition.
void	append(NumericAttribute a, int columnValue) Appends a value selection fragment to the where condition.
void	append(NumericAttribute a, java.lang.String relation, int columnValue) Appends a value selection fragment to the where condition.
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 value selection fragment to the where condition.
protected void	append(java.lang.StringBuilder queryExpression) Appends the where condition to a query expression using the specified elements of this where condition.
void	append(java.lang.String columnName, java.sql.Date dateToCompare) Appends a date selection fragment to the where condition which seems to work only for date values !
void	append(java.lang.String columnName, double columnValue) Appends a value selection fragment to the where condition.
void	append(java.lang.String columnName, int columnValue) Appends a value selection fragment to the where condition.
void	append(java.lang.String columnName, java.lang.String columnValue) Appends a value selection fragment to the where condition.
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, int columnValue) Appends a value selection fragment to the where condition.
void	append(VarcharAttribute a, java.lang.String columnValue) Appends a value selection fragment to the where condition.
void	appendLowerEqual(DateAttribute dateAttribute, 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) Appends a date lower equals condition fragment to the where condition if not null.
protected void	fill(java.sql.PreparedStatement stmt) Fill the specified prepared statement with the values of this where condition.
int	size() Returns the number of elements of this where condition.
java.lang.String	toString()

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

WhereConditionForPrepStmts

public WhereConditionForPrepStmts(DataObject dataObject)

Constructs a new where condition.

Parameters:

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

WhereConditionForPrepStmts

public WhereConditionForPrepStmts(NumericAttribute a,
                                  Identifier identifier)

Constructs a new where condition for prepared statements and append a condition fragment. Suitable for record access using a single column to identify the record.

Parameters:

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

identifier - the identifier to be selected

WhereConditionForPrepStmts

public WhereConditionForPrepStmts(CharAttribute a,
                                  Identifier identifier)

Constructs a new where condition for prepared statements and append a condition fragment. Suitable for record access using a single column to identify the record.

Parameters:

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

identifier - the identifier to be selected

WhereConditionForPrepStmts

public WhereConditionForPrepStmts(NumericAttribute a,
                                  int columnValue)

Constructs a new where condition for prepared statements and append a condition fragment.

Parameters:

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

columnValue - the column value to be selected

WhereConditionForPrepStmts

public WhereConditionForPrepStmts(AbstractTextAttribute a,
                                  java.lang.String columnValue)

Constructs a new where condition for prepared statements and append a condition fragment.

Parameters:

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

columnValue - the column value to be selected

WhereConditionForPrepStmts

public WhereConditionForPrepStmts(java.lang.String columnName,
                                  java.lang.String columnValue)

Constructs a new where condition for prepared statements and append a condition fragment.

Parameters:

columnName - the name of the column to be used

columnValue - the column value to be selected

Method Detail

append

public void append(NumericAttribute a,
                   int columnValue)

Appends a value selection fragment to the where condition.

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 value selection fragment to the where condition.

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,
                   java.lang.String relation,
                   int columnValue)

Appends a value selection fragment to the where condition.

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(NumericAttribute a,
                   java.lang.String relation,
                   int columnValue)

Appends a value selection fragment to the where condition.

Parameters:

a - the attribute containing the column name

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

columnValue - the numeric column value to select

append

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

Appends a value selection fragment to the where condition.

Parameters:

columnName - the name of the column to be used

columnValue - the column value to be selected

append

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

Appends a value selection fragment to the where condition.

Parameters:

a - the attribute containing the column name

columnValue - the column value to be selected

append

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

Appends a value selection fragment to the where condition.

Parameters:

a - the attribute containing the column name

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

columnValue - the column value to be selected

append

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

Appends a value selection fragment to the where condition.

Parameters:

a - the attribute containing the column name

columnValue - the column value to be selected

append

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

Appends a value selection fragment to the where condition.

Parameters:

columnName - the name of the column to be used (only char and varchar, no memos, yet!)

columnValue - the column value to be selected

append

public void append(BooleanAttribute a,
                   boolean columnValue)

Appends a value selection fragment to the where condition.

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 value selection fragment to the where condition.

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,
                   java.sql.Date dateToCompare)

Appends a date selection fragment to the where condition which seems to work only for date values != null.

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)

Appends a date selection fragment to the where condition. For now, this is suitable only for date values != null: Search for date values != null and you will find only date values != null.

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

See Also:

to deal with null values

appendLowerEqual

public void appendLowerEqual(DateAttribute dateAttribute,
                             java.sql.Date dateToCompare,
                             DataObject dataObject)

Appends a date lower equals condition fragment to the where condition if not null.

Parameters:

dateAttribute - the attribute containing the column name

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)

Appends a date lower equals condition fragment to the where condition if not null.

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

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. Be advised every different condition fragment will extend the prepared statement buffer. Therefore, this method should be used for constant phrases, only.

Parameters:

conditionFragement - the condition fragment

fill

protected void fill(java.sql.PreparedStatement stmt)
             throws java.sql.SQLException

Fill the specified prepared statement with the values of this where condition.

Parameters:

stmt - the prepared statement to fill with values

Throws:

java.sql.SQLException

append

protected void append(java.lang.StringBuilder queryExpression)

Appends the where condition to a query expression using the specified elements of this where condition.

Parameters:

queryExpression - the query expression to be extended by the where condition phrase

size

public int size()

Returns the number of elements of this where condition.

Returns:

the number of elements of this where condition

toString

public java.lang.String toString()

Overrides:

toString in class java.lang.Object