play.db.helper

Class SqlSelect

java.lang.Object

play.db.helper.SqlQuery

play.db.helper.SqlSelect

Direct Known Subclasses:

JpqlSelect

public class SqlSelect
extends SqlQuery

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
static class	SqlSelect.Where

Nested classes/interfaces inherited from class play.db.helper.SqlQuery

SqlQuery.Concat

Field Summary

Fields

Modifier and Type	Field and Description
protected SqlQuery.Concat	from
protected SqlQuery.Concat	groupBy
protected SqlQuery.Concat	join
protected SqlQuery.Concat	limit
protected SqlQuery.Concat	orderBy
protected SqlQuery.Concat	select
protected SqlQuery.Concat	where

Fields inherited from class play.db.helper.SqlQuery

params

Constructor Summary

Constructors

Constructor and Description
SqlSelect()
SqlSelect(SqlSelect src)

Method Summary

Modifier and Type	Method and Description
SqlSelect	andWhere(SqlSelect.Where... expr)
SqlSelect	andWhere(String... expr)
SqlSelect	from(String... expr)
SqlSelect	groupBy(String... expr)
SqlSelect	innerJoin(String... expr)
SqlSelect	leftJoin(String... expr)
SqlSelect	limit(long lines)
SqlSelect	limit(long offset, long lines)
SqlSelect	orderBy(String... expr)
SqlSelect	orWhere(SqlSelect.Where... expr)
SqlSelect	orWhere(String... expr)
SqlSelect	param(Object obj)
SqlSelect	params(Object... objs)
SqlSelect	select(String... expr)
String	toString()
SqlSelect.Where	where()
SqlSelect	where(SqlSelect.Where... expr)
SqlSelect	where(String... expr)

Methods inherited from class play.db.helper.SqlQuery

getParams, inlineParam, paramCurrentIndex, pmark, pmark, quote, whereIn

Methods inherited from class java.lang.Object

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

Field Detail

select

protected final SqlQuery.Concat select

from

protected final SqlQuery.Concat from

join

protected final SqlQuery.Concat join

where

protected final SqlQuery.Concat where

groupBy

protected final SqlQuery.Concat groupBy

orderBy

protected final SqlQuery.Concat orderBy

limit

protected final SqlQuery.Concat limit

Constructor Detail

SqlSelect

public SqlSelect()

SqlSelect

public SqlSelect(SqlSelect src)

Method Detail

param

public SqlSelect param(Object obj)

Overrides:

param in class SqlQuery

params

public SqlSelect params(Object... objs)

Overrides:

params in class SqlQuery

select

public SqlSelect select(String... expr)

from

public SqlSelect from(String... expr)

innerJoin

public SqlSelect innerJoin(String... expr)

leftJoin

public SqlSelect leftJoin(String... expr)

where

public SqlSelect where(String... expr)

andWhere

public SqlSelect andWhere(String... expr)

orWhere

public SqlSelect orWhere(String... expr)

groupBy

public SqlSelect groupBy(String... expr)

orderBy

public SqlSelect orderBy(String... expr)

limit

public SqlSelect limit(long lines)

limit

public SqlSelect limit(long offset,
                       long lines)

where

public SqlSelect.Where where()

where

public SqlSelect where(SqlSelect.Where... expr)

andWhere

public SqlSelect andWhere(SqlSelect.Where... expr)

orWhere

public SqlSelect orWhere(SqlSelect.Where... expr)

toString

public String toString()

Overrides:

toString in class Object