com.github.sqlbuilder.jonathanhds.select

Class Where

java.lang.Object

com.github.sqlbuilder.jonathanhds.select.Where

public class Where
extends Object

Constructor Summary

Constructors

Constructor and Description
Where(com.github.sqlbuilder.jonathanhds.select.Context context)

Method Summary

Methods

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)
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()
<E> E	single(RowMapper<E> rowMapper)

Methods inherited from class java.lang.Object

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

Constructor Detail

Where

public Where(com.github.sqlbuilder.jonathanhds.select.Context context)

Method Detail

orderBy

public OrderBy orderBy()

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

Throws:

SQLException

single

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

Throws:

SQLException