com.github.jonathanhds.sqlbuilder.select

Class Where

java.lang.Object

com.github.jonathanhds.sqlbuilder.select.Where

All Implemented Interfaces:

TerminalExpression

public class Where
extends Object
implements TerminalExpression

Field Summary

Fields

Modifier and Type	Field and Description
protected Context	context

Method Summary

Modifier and Type	Method and Description
Where	and(Object condition)
Where	and(Object condition, Object... parameters)
Where	and(Object condition, Object parameter)
Where	and(String condition, String parameter)
Where	andBetween(String columnName, Object start, Object end)
protected String	getPrefix()
GroupBy	groupBy()
GroupBy	groupBy(String... columns)
Limit	limit(int start, int size)
<E> List<E>	list(RowMapper<E> rowMapper)
Where	or(Object condition)
Where	or(Object condition, Object... parameters)
Where	or(Object condition, Object parameter)
Where	or(String condition, String parameter)
Where	orBetween(String columnName, Object start, Object end)
OrderBy	orderBy()
OrderBy	orderBy(OrderByType order, String... columns)
OrderBy	orderBy(String... columns)
<E> E	single(RowMapper<E> rowMapper)
String	toString()

Methods inherited from class java.lang.Object

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

Field Detail

context

protected final Context context

Method Detail

groupBy

public GroupBy groupBy()

groupBy

public GroupBy groupBy(String... columns)

orderBy

public OrderBy orderBy()

orderBy

public OrderBy orderBy(String... columns)

orderBy

public OrderBy orderBy(OrderByType order,
                       String... columns)

and

public Where and(Object condition)

and

public Where and(Object condition,
                 Object parameter)

and

public Where and(String condition,
                 String parameter)

and

public Where and(Object condition,
                 Object... parameters)

andBetween

public Where andBetween(String columnName,
                        Object start,
                        Object end)

or

public Where or(Object condition)

or

public Where or(Object condition,
                Object parameter)

or

public Where or(String condition,
                String parameter)

or

public Where or(Object condition,
                Object... parameters)

orBetween

public Where orBetween(String columnName,
                       Object start,
                       Object end)

limit

public Limit limit(int start,
                   int size)

list

public <E> List<E> list(RowMapper<E> rowMapper)
                 throws SQLException

Specified by:

list in interface TerminalExpression

Throws:

SQLException

single

public <E> E single(RowMapper<E> rowMapper)
             throws SQLException

Specified by:

single in interface TerminalExpression

Throws:

SQLException

getPrefix

protected String getPrefix()

toString

public String toString()

Overrides:

toString in class Object