core.tut.pori.dao.clause

Class AndClause

java.lang.Object

core.tut.pori.dao.clause.WhereClause

core.tut.pori.dao.clause.AndClause

All Implemented Interfaces:

SQLClause

Direct Known Subclasses:

OrClause

public class AndClause
extends WhereClause

A simple SQL WHERE AND clause. This class will always prefix the clause with AND, and giving multiple values equals to SQL AND IN (?,?,...) Passing null object, null array or empty array equals to providing the clause with SQL NULL. An array can also have a null value.

Nested Class Summary

Nested classes/interfaces inherited from class core.tut.pori.dao.clause.WhereClause

WhereClause.ClauseType

Nested classes/interfaces inherited from interface core.tut.pori.dao.clause.SQLClause

SQLClause.SQLType

Constructor Summary

Constructors

Constructor and Description
AndClause(java.lang.String column, boolean[] values)
AndClause(java.lang.String column, java.util.Collection<? extends java.lang.Object> values, SQLClause.SQLType type)
AndClause(java.lang.String column, double[] values)
AndClause(java.lang.String column, int[] values)
AndClause(java.lang.String column, long[] values)
AndClause(java.lang.String column, java.lang.Object[] values, SQLClause.SQLType type) Note: this does creates an IN () clause based on the list of values, NOT multiple AND clauses that include all of the given values.
AndClause(java.lang.String column, java.lang.Object value, SQLClause.SQLType type)

Method Summary

Modifier and Type	Method and Description
WhereClause.ClauseType	getClauseType()
java.lang.Object[]	getValues() Note: null value is accepted IF NULL is also set on the valueType map, otherwise behavior is undefined The values will be added in-order in places designated by ? in the sql string
SQLClause.SQLType[]	getValueTypes()
AndClause	setNot(boolean not)
void	setValues(java.lang.Object[] values, SQLClause.SQLType type)
void	toSQLString(java.lang.StringBuilder sql) print this clause the the given builder, the output should NOT include AND or OR keyword, this will be automatically added when needed

Methods inherited from class java.lang.Object

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

Constructor Detail

AndClause

public AndClause(java.lang.String column,
                 int[] values)

Parameters:

column -

values -

AndClause

public AndClause(java.lang.String column,
                 long[] values)

Parameters:

column -

values -

AndClause

public AndClause(java.lang.String column,
                 double[] values)

Parameters:

column -

values -

AndClause

public AndClause(java.lang.String column,
                 boolean[] values)

Parameters:

column -

values -

AndClause

public AndClause(java.lang.String column,
                 java.lang.Object value,
                 SQLClause.SQLType type)

Parameters:

column -

value - can be null

type - type of data

AndClause

public AndClause(java.lang.String column,
                 java.util.Collection<? extends java.lang.Object> values,
                 SQLClause.SQLType type)

Parameters:

column -

values -

type -

AndClause

public AndClause(java.lang.String column,
                 java.lang.Object[] values,
                 SQLClause.SQLType type)

Note: this does creates an IN () clause based on the list of values, NOT multiple AND clauses that include all of the given values. This is because no column can have more than a single value, and thus, creating AND for all of the given values would not make sense.

Parameters:

column -

values - can be null

type - type of data

Method Detail

getValueTypes

public SQLClause.SQLType[] getValueTypes()

Returns:

value types

getValues

public java.lang.Object[] getValues()

Description copied from interface: SQLClause

Note: null value is accepted IF NULL is also set on the valueType map, otherwise behavior is undefined The values will be added in-order in places designated by ? in the sql string

Returns:

values

setValues

public void setValues(java.lang.Object[] values,
                      SQLClause.SQLType type)

Parameters:

values -

type -

toSQLString

public void toSQLString(java.lang.StringBuilder sql)

Description copied from interface: SQLClause

print this clause the the given builder, the output should NOT include AND or OR keyword, this will be automatically added when needed

setNot

public AndClause setNot(boolean not)

Parameters:

not - set this to be NOT clause on true, remove NOT declaration on false

Returns:

this

getClauseType

public WhereClause.ClauseType getClauseType()

Specified by:

getClauseType in class WhereClause

Returns:

type of the clause