Package com.invirgance.convirgance.jdbc.sql

Class WhereStatement<P extends SQLStatement>

java.lang.Object

com.invirgance.convirgance.jdbc.sql.WhereStatement<P>

Type Parameters:

P - the parent type

All Implemented Interfaces:

SQLStatement

Direct Known Subclasses:

BooleanAndStatement, BooleanNotStatement, BooleanOrStatement

public class WhereStatement<P extends SQLStatement>
extends Object
implements SQLStatement

Author:

jbanes

Constructor Summary

Constructors

Constructor	Description
WhereStatement(DatabaseSchemaLayout layout)

Method Summary

Modifier and Type	Method	Description
BooleanAndStatement<WhereStatement>	and()
P	done()
WhereStatement	end()
WhereStatement<P>	equals(Column column, Column value)
WhereStatement<P>	equals(Column column, BindVariable value)
WhereStatement<P>	equals(Column column, Object value)
WhereStatement<P>	equals(ExpressionStatement column, ExpressionStatement value)
WhereStatement<P>	equals(Object column, Object value)
WhereStatement<P>	filter(Column column, ComparisonOperator operator, Column value)
WhereStatement<P>	filter(Column column, ComparisonOperator operator, BindVariable value)
WhereStatement<P>	filter(Column column, ComparisonOperator operator, Object value)
WhereStatement<P>	filter(ExpressionStatement column, ComparisonOperator operator, ExpressionStatement value)
WhereStatement<P>	filter(Object column, ComparisonOperator operator, Object value)
ComparisonStatement[]	getClauses()
SQLStatement	getParent()	If this statement is part of a larger statement, this returns the parent statement.
WhereStatement<P>	greaterThan(Column column, Column value)
WhereStatement<P>	greaterThan(Column column, BindVariable value)
WhereStatement<P>	greaterThan(Column column, Object value)
WhereStatement<P>	greaterThan(ExpressionStatement column, ExpressionStatement value)
WhereStatement<P>	greaterThan(Object column, Object value)
WhereStatement<P>	greaterThanOrEquals(Column column, Column value)
WhereStatement<P>	greaterThanOrEquals(Column column, BindVariable value)
WhereStatement<P>	greaterThanOrEquals(Column column, Object value)
WhereStatement<P>	greaterThanOrEquals(ExpressionStatement column, ExpressionStatement value)
WhereStatement<P>	greaterThanOrEquals(Object column, Object value)
WhereStatement<P>	isNotNull(Column column)
WhereStatement<P>	isNotNull(BindVariable column)
WhereStatement<P>	isNotNull(ExpressionStatement column)
WhereStatement<P>	isNotNull(Object column)
WhereStatement<P>	isNull(Column column)
WhereStatement<P>	isNull(BindVariable column)
WhereStatement<P>	isNull(ExpressionStatement column)
WhereStatement<P>	isNull(Object column)
WhereStatement<P>	lessThan(Column column, Column value)
WhereStatement<P>	lessThan(Column column, BindVariable value)
WhereStatement<P>	lessThan(Column column, Object value)
WhereStatement<P>	lessThan(ExpressionStatement column, ExpressionStatement value)
WhereStatement<P>	lessThan(Object column, Object value)
WhereStatement<P>	lessThanOrEquals(Column column, Column value)
WhereStatement<P>	lessThanOrEquals(Column column, BindVariable value)
WhereStatement<P>	lessThanOrEquals(Column column, Object value)
WhereStatement<P>	lessThanOrEquals(ExpressionStatement column, ExpressionStatement value)
WhereStatement<P>	lessThanOrEquals(Object column, Object value)
BooleanNotStatement<WhereStatement>	not()
WhereStatement<P>	notEquals(Column column, Column value)
WhereStatement<P>	notEquals(Column column, BindVariable value)
WhereStatement<P>	notEquals(Column column, Object value)
WhereStatement<P>	notEquals(ExpressionStatement column, ExpressionStatement value)
WhereStatement<P>	notEquals(Object column, Object value)
BooleanOrStatement<WhereStatement>	or()
SQLRenderer	render(SQLRenderer renderer)
void	setParent(SQLStatement parent)
String	toString()
WhereStatement	where()

Methods inherited from class java.lang.Object

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

Methods inherited from interface com.invirgance.convirgance.jdbc.sql.SQLStatement

query, query

Constructor Details

WhereStatement

public WhereStatement(DatabaseSchemaLayout layout)

Method Details

getClauses

public ComparisonStatement[] getClauses()

getParent

public SQLStatement getParent()

Description copied from interface: SQLStatement

If this statement is part of a larger statement, this returns the parent statement. Null is returned if this is the top-level statement.

Specified by:

getParent in interface SQLStatement

Returns:

the parent statement or null if there is no parent

setParent

public void setParent(SQLStatement parent)

Specified by:

setParent in interface SQLStatement

filter

public WhereStatement<P> filter(ExpressionStatement column,
 ComparisonOperator operator,
 ExpressionStatement value)

filter

public WhereStatement<P> filter(Object column,
 ComparisonOperator operator,
 Object value)

filter

public WhereStatement<P> filter(Column column,
 ComparisonOperator operator,
 Object value)

filter

public WhereStatement<P> filter(Column column,
 ComparisonOperator operator,
 Column value)

filter

public WhereStatement<P> filter(Column column,
 ComparisonOperator operator,
 BindVariable value)

equals

public WhereStatement<P> equals(ExpressionStatement column,
 ExpressionStatement value)

equals

public WhereStatement<P> equals(Object column,
 Object value)

equals

public WhereStatement<P> equals(Column column,
 Object value)

equals

public WhereStatement<P> equals(Column column,
 Column value)

equals

public WhereStatement<P> equals(Column column,
 BindVariable value)

notEquals

public WhereStatement<P> notEquals(ExpressionStatement column,
 ExpressionStatement value)

notEquals

public WhereStatement<P> notEquals(Object column,
 Object value)

notEquals

public WhereStatement<P> notEquals(Column column,
 Object value)

notEquals

public WhereStatement<P> notEquals(Column column,
 Column value)

notEquals

public WhereStatement<P> notEquals(Column column,
 BindVariable value)

greaterThan

public WhereStatement<P> greaterThan(ExpressionStatement column,
 ExpressionStatement value)

greaterThan

public WhereStatement<P> greaterThan(Object column,
 Object value)

greaterThan

public WhereStatement<P> greaterThan(Column column,
 Object value)

greaterThan

public WhereStatement<P> greaterThan(Column column,
 Column value)

greaterThan

public WhereStatement<P> greaterThan(Column column,
 BindVariable value)

greaterThanOrEquals

public WhereStatement<P> greaterThanOrEquals(ExpressionStatement column,
 ExpressionStatement value)

greaterThanOrEquals

public WhereStatement<P> greaterThanOrEquals(Object column,
 Object value)

greaterThanOrEquals

public WhereStatement<P> greaterThanOrEquals(Column column,
 Object value)

greaterThanOrEquals

public WhereStatement<P> greaterThanOrEquals(Column column,
 Column value)

greaterThanOrEquals

public WhereStatement<P> greaterThanOrEquals(Column column,
 BindVariable value)

lessThan

public WhereStatement<P> lessThan(ExpressionStatement column,
 ExpressionStatement value)

lessThan

public WhereStatement<P> lessThan(Object column,
 Object value)

lessThan

public WhereStatement<P> lessThan(Column column,
 Object value)

lessThan

public WhereStatement<P> lessThan(Column column,
 Column value)

lessThan

public WhereStatement<P> lessThan(Column column,
 BindVariable value)

lessThanOrEquals

public WhereStatement<P> lessThanOrEquals(ExpressionStatement column,
 ExpressionStatement value)

lessThanOrEquals

public WhereStatement<P> lessThanOrEquals(Object column,
 Object value)

lessThanOrEquals

public WhereStatement<P> lessThanOrEquals(Column column,
 Object value)

lessThanOrEquals

public WhereStatement<P> lessThanOrEquals(Column column,
 Column value)

lessThanOrEquals

public WhereStatement<P> lessThanOrEquals(Column column,
 BindVariable value)

isNull

public WhereStatement<P> isNull(ExpressionStatement column)

isNull

public WhereStatement<P> isNull(Object column)

isNull

public WhereStatement<P> isNull(Column column)

isNull

public WhereStatement<P> isNull(BindVariable column)

isNotNull

public WhereStatement<P> isNotNull(ExpressionStatement column)

isNotNull

public WhereStatement<P> isNotNull(Object column)

isNotNull

public WhereStatement<P> isNotNull(Column column)

isNotNull

public WhereStatement<P> isNotNull(BindVariable column)

and

public BooleanAndStatement<WhereStatement> and()

or

public BooleanOrStatement<WhereStatement> or()

not

public BooleanNotStatement<WhereStatement> not()

where

public WhereStatement where()

end

public WhereStatement end()

done

public P done()

render

public SQLRenderer render(SQLRenderer renderer)

Specified by:

render in interface SQLStatement

toString

public String toString()

Overrides:

toString in class Object