org.sqlorm.querybuilder
Interface ItfSelectBuilder

All Known Implementing Classes:

SelectBuilder, SurogateAndOrListSelectBuilder

public interface ItfSelectBuilder

Method Summary

MultiJoinOnExpr	crossJoin(ITableName table)
MultiJoinOnExpr	crossJoin(ITableName table, String alias)
MultiJoinOnExpr	crossJoin(String table)
MultiJoinOnExpr	crossJoin(String table, String alias)
ItfSelectBuilder	distinct()
ItfSelectBuilder	from(ITableName from)
ItfSelectBuilder	from(ITableName from, String alias)
ItfSelectBuilder	from(ItfSelectBuilder subSelect, String alias)
ItfSelectBuilder	from(String from)
ItfSelectBuilder	from(String from, String alias)
ItfSelectBuilder	groupBy(ITableName table)
ItfSelectBuilder	groupBy(String... tableNames)
SurogateAndOrListSelectBuilder	having()
MultiJoinOnExpr	innerJoin(ITableName table)
MultiJoinOnExpr	innerJoin(ITableName table, String alias)
MultiJoinOnExpr	innerJoin(String table)
MultiJoinOnExpr	innerJoin(String table, String alias)
ItfSelectBuilder	internal_setAlias(String alias)
ItfSelectBuilder	internal_setIsNestedSelect()
MultiJoinOnExpr	leftJoin(ITableName table)
MultiJoinOnExpr	leftJoin(ITableName table, String alias)
MultiJoinOnExpr	leftJoin(String table)
MultiJoinOnExpr	leftJoin(String table, String alias)
ItfSelectBuilder	orderBy(ITableName table)
ItfSelectBuilder	orderBy(String tableName)
ItfSelectBuilder	orderByAsc(ITableName table)
ItfSelectBuilder	orderByAsc(String tableName)
ItfSelectBuilder	orderByDesc(ITableName table)
ItfSelectBuilder	orderByDesc(String tableName)
MultiJoinOnExpr	outerJoin(ITableName table)
MultiJoinOnExpr	outerJoin(ITableName table, String alias)
MultiJoinOnExpr	outerJoin(String table)
MultiJoinOnExpr	outerJoin(String table, String alias)
MultiJoinOnExpr	rightJoin(ITableName table)
MultiJoinOnExpr	rightJoin(ITableName table, String alias)
MultiJoinOnExpr	rightJoin(String table)
MultiJoinOnExpr	rightJoin(String table, String alias)
ItfSelectBuilder	select(IColumnName column)
ItfSelectBuilder	select(IColumnName column, String alias)
ItfSelectBuilder	select(String column) Select a column
ItfSelectBuilder	select(String column, String alias) Select a column
String	toSql() Call this method for generating an SQL expression from your object.
void	toSql(StringBuilder sb, String indent)
SurogateAndOrListSelectBuilder	where()

Method Detail

crossJoin

MultiJoinOnExpr crossJoin(String table)

crossJoin

MultiJoinOnExpr crossJoin(String table,
                          String alias)

crossJoin

MultiJoinOnExpr crossJoin(ITableName table)

crossJoin

MultiJoinOnExpr crossJoin(ITableName table,
                          String alias)

distinct

ItfSelectBuilder distinct()

from

ItfSelectBuilder from(ItfSelectBuilder subSelect,
                      String alias)

from

ItfSelectBuilder from(String from)

from

ItfSelectBuilder from(String from,
                      String alias)

from

ItfSelectBuilder from(ITableName from)

from

ItfSelectBuilder from(ITableName from,
                      String alias)

groupBy

ItfSelectBuilder groupBy(String... tableNames)

innerJoin

MultiJoinOnExpr innerJoin(String table)

innerJoin

MultiJoinOnExpr innerJoin(String table,
                          String alias)

leftJoin

MultiJoinOnExpr leftJoin(String table)

leftJoin

MultiJoinOnExpr leftJoin(String table,
                         String alias)

orderBy

ItfSelectBuilder orderBy(String tableName)

orderByAsc

ItfSelectBuilder orderByAsc(String tableName)

orderByDesc

ItfSelectBuilder orderByDesc(String tableName)

outerJoin

MultiJoinOnExpr outerJoin(String table)

outerJoin

MultiJoinOnExpr outerJoin(String table,
                          String alias)

rightJoin

MultiJoinOnExpr rightJoin(String table)

rightJoin

MultiJoinOnExpr rightJoin(String table,
                          String alias)

groupBy

ItfSelectBuilder groupBy(ITableName table)

innerJoin

MultiJoinOnExpr innerJoin(ITableName table)

innerJoin

MultiJoinOnExpr innerJoin(ITableName table,
                          String alias)

leftJoin

MultiJoinOnExpr leftJoin(ITableName table)

leftJoin

MultiJoinOnExpr leftJoin(ITableName table,
                         String alias)

orderBy

ItfSelectBuilder orderBy(ITableName table)

orderByAsc

ItfSelectBuilder orderByAsc(ITableName table)

orderByDesc

ItfSelectBuilder orderByDesc(ITableName table)

outerJoin

MultiJoinOnExpr outerJoin(ITableName table)

outerJoin

MultiJoinOnExpr outerJoin(ITableName table,
                          String alias)

rightJoin

MultiJoinOnExpr rightJoin(ITableName table)

rightJoin

MultiJoinOnExpr rightJoin(ITableName table,
                          String alias)

select

ItfSelectBuilder select(String column)

Select a column

Parameters:

column - the column to add to the SELECT part of an SQL expression

Returns:

this

select

ItfSelectBuilder select(IColumnName column)

select

ItfSelectBuilder select(String column,
                        String alias)

Select a column

Parameters:

column - The column to add to the SELECT part of an SQL expression

alias - the AS part when aliasing

Returns:

this

select

ItfSelectBuilder select(IColumnName column,
                        String alias)

internal_setAlias

ItfSelectBuilder internal_setAlias(String alias)

internal_setIsNestedSelect

ItfSelectBuilder internal_setIsNestedSelect()

toSql

String toSql()

Call this method for generating an SQL expression from your object.

Returns:

An SQL expresion

where

SurogateAndOrListSelectBuilder where()

having

SurogateAndOrListSelectBuilder having()

toSql

void toSql(StringBuilder sb,
           String indent)