Class SQLAbstractDAO.QueryStringBuilder

java.lang.Object

com.blackrook.sql.SQLAbstractDAO.QueryStringBuilder

Enclosing class:

SQLAbstractDAO

public static class SQLAbstractDAO.QueryStringBuilder
extends Object

Query string builder.

Since:

1.3.0

Author:

Matthew Tropiano

Method Summary

Modifier and Type	Method	Description
SQLAbstractDAO.QueryStringBuilder	limit(int value)	Adds "limit" criteria.
SQLAbstractDAO.QueryStringBuilder	offset(int value)	Adds "offset" criteria.
SQLAbstractDAO.QueryStringBuilder	orderBy(Function<String,String> columnEscapeFunction, SQLAbstractDAO.Ordering... ordering)	Adds "order by" criteria.
String	toString()
SQLAbstractDAO.QueryStringBuilder	where(Function<String,String> columnEscapeFunction, SQLAbstractDAO.Criterion... criteria)	Adds "where" criteria.

Methods inherited from class Object

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

Method Details

where

public SQLAbstractDAO.QueryStringBuilder where(Function<String,String> columnEscapeFunction,
 SQLAbstractDAO.Criterion... criteria)

Adds "where" criteria.

Parameters:

columnEscapeFunction - the function to use for escaping column names (parameter is incoming column name).

criteria - the criteria.

Returns:

this builder.

orderBy

public SQLAbstractDAO.QueryStringBuilder orderBy(Function<String,String> columnEscapeFunction,
 SQLAbstractDAO.Ordering... ordering)

Adds "order by" criteria.

Parameters:

columnEscapeFunction - the function to use for escaping column names (parameter is incoming column name).

ordering - the ordering criteria.

Returns:

this builder.

limit

public SQLAbstractDAO.QueryStringBuilder limit(int value)

Adds "limit" criteria.

Parameters:

value - the limit value.

Returns:

this builder.

offset

public SQLAbstractDAO.QueryStringBuilder offset(int value)

Adds "offset" criteria.

Parameters:

value - the limit value.

Returns:

this builder.

toString

public String toString()

Overrides:

toString in class Object