net.ymate.platform.persistence.jdbc.query

Class Select

java.lang.Object

net.ymate.platform.persistence.jdbc.query.QueryHandleAdapter<T>

net.ymate.platform.persistence.jdbc.query.Query<Select>

net.ymate.platform.persistence.jdbc.query.Select

public final class Select
extends Query<Select>

Select语句对象

Author:

刘镇 (suninformation@163.com) on 15/5/12 下午5:59

Nested Class Summary

Nested classes/interfaces inherited from class net.ymate.platform.persistence.jdbc.query.Query

Query.Executor<T>

Field Summary

Fields inherited from class net.ymate.platform.persistence.jdbc.query.Query

LINE_END_FLAG

Constructor Summary

Constructors

Constructor and Description
Select(IDatabase owner, String dataSourceName)
Select(IDatabase owner, String dataSourceName, String prefix, String from, String alias, boolean safePrefix)

Method Summary

Modifier and Type	Method and Description
Select	alias(String alias) 设置Select语句的别名
long	count()
static Select	create()
static Select	create(Class<? extends IEntity> entityClass)
static Select	create(Class<? extends IEntity> entityClass, String alias)
static Select	create(IDatabase owner)
static Select	create(IDatabase owner, String dataSourceName)
static Select	create(IDatabase owner, String dataSourceName, Class<? extends IEntity> entityClass)
static Select	create(IDatabase owner, String dataSourceName, Class<? extends IEntity> entityClass, String alias)
static Select	create(IDatabase owner, String dataSourceName, String from)
static Select	create(IDatabase owner, String dataSourceName, String from, boolean safePrefix)
static Select	create(IDatabase owner, String dataSourceName, String prefix, Class<? extends IEntity> entityClass)
static Select	create(IDatabase owner, String dataSourceName, String prefix, Class<? extends IEntity> entityClass, String alias)
static Select	create(IDatabase owner, String dataSourceName, String from, String alias)
static Select	create(IDatabase owner, String dataSourceName, String from, String alias, boolean safePrefix)
static Select	create(IDatabase owner, String dataSourceName, String prefix, String from, String alias)
static Select	create(Query<?> query)
static Select	create(Query<?> query, String prefix, String from, String alias, boolean safePrefix)
static Select	create(Select select)
static Select	create(String from)
static Select	create(String from, boolean safePrefix)
static Select	create(String prefix, Class<? extends IEntity> entityClass)
static Select	create(String prefix, Class<? extends IEntity> entityClass, String alias)
static Select	create(String from, String alias)
static Select	create(String from, String alias, boolean safePrefix)
static Select	create(String prefix, String from, String alias)
Select	distinct()
Select	field(Fields fields)
Select	field(Fields fields, boolean wrapIdentifier)
Select	field(IFunction func)
Select	field(IFunction func, String alias)
Select	field(String field)
Select	field(String field, boolean wrapIdentifier)
Select	field(String prefix, Fields fields)
Select	field(String prefix, Fields fields, boolean wrapIdentifier)
Select	field(String prefix, String field)
Select	field(String prefix, String field, boolean wrapIdentifier)
Select	field(String prefix, String field, String alias)
Select	field(String prefix, String field, String alias, boolean wrapIdentifier)
Fields	fields()
<T> IResultSet<T>	find(IResultSetHandler<T> handler)
<T> IResultSet<T>	find(IResultSetHandler<T> handler, Page page)
<T> T	findFirst(IResultSetHandler<T> handler)
Select	forUpdate(IDBLocker dbLocker)
Select	from(Class<? extends IEntity> entityClass)
Select	from(Class<? extends IEntity> entityClass, boolean safePrefix)
Select	from(Class<? extends IEntity> entityClass, String alias)
Select	from(Class<? extends IEntity> entityClass, String alias, boolean safePrefix)
Select	from(Select select)
Select	from(String tableName)
Select	from(String prefix, Class<? extends IEntity> entityClass, String alias)
Select	from(String prefix, Class<? extends IEntity> entityClass, String alias, boolean safePrefix)
Select	from(String tableName, String alias)
Select	from(String prefix, String from, String alias)
Select	from(String prefix, String from, String alias, boolean safePrefix)
Select	groupBy(Fields fields)
Select	groupBy(Fields fields, boolean wrapIdentifier)
Select	groupBy(Fields fields, boolean desc, boolean wrapIdentifier)
Select	groupBy(GroupBy groupBy)
Select	groupBy(String field)
Select	groupBy(String field, boolean wrapIdentifier)
Select	groupBy(String field, boolean desc, boolean wrapIdentifier)
Select	groupBy(String prefix, Fields fields)
Select	groupBy(String prefix, Fields fields, boolean wrapIdentifier)
Select	groupBy(String prefix, Fields fields, boolean desc, boolean wrapIdentifier)
Select	groupBy(String prefix, String field)
Select	groupBy(String prefix, String field, boolean wrapIdentifier)
Select	groupBy(String prefix, String field, boolean desc, boolean wrapIdentifier)
Select	groupByDesc(Fields fields)
Select	groupByDesc(Fields fields, boolean wrapIdentifier)
Select	groupByDesc(String field)
Select	groupByDesc(String field, boolean wrapIdentifier)
Select	groupByDesc(String prefix, Fields fields)
Select	groupByDesc(String prefix, Fields fields, boolean wrapIdentifier)
Select	groupByDesc(String prefix, String field)
Select	groupByDesc(String prefix, String field, boolean wrapIdentifier)
Select	groupByRollup()
Select	having(Cond cond)
Select	innerJoin(Select select, Cond on)
Select	innerJoin(String from, Cond on)
Select	innerJoin(String from, String alias, Cond on)
Select	innerJoin(String prefix, String from, String alias, Cond on)
Select	innerJoin(String prefix, String from, String alias, Cond on, boolean safePrefix)
Select	join(Join join)
Select	leftJoin(Select select, Cond on)
Select	leftJoin(String from, Cond on)
Select	leftJoin(String from, String alias, Cond on)
Select	leftJoin(String prefix, String from, String alias, Cond on)
Select	leftJoin(String prefix, String from, String alias, Cond on, boolean safePrefix)
Select	orderBy(OrderBy orderBy)
Select	orderByAsc(Fields fields)
Select	orderByAsc(Fields fields, boolean wrapIdentifier)
Select	orderByAsc(String field)
Select	orderByAsc(String field, boolean wrapIdentifier)
Select	orderByAsc(String prefix, Fields fields)
Select	orderByAsc(String prefix, Fields fields, boolean wrapIdentifier)
Select	orderByAsc(String prefix, String field)
Select	orderByAsc(String prefix, String field, boolean wrapIdentifier)
Select	orderByDesc(Fields fields)
Select	orderByDesc(Fields fields, boolean wrapIdentifier)
Select	orderByDesc(String field)
Select	orderByDesc(String field, boolean wrapIdentifier)
Select	orderByDesc(String prefix, Fields fields)
Select	orderByDesc(String prefix, Fields fields, boolean wrapIdentifier)
Select	orderByDesc(String prefix, String field)
Select	orderByDesc(String prefix, String field, boolean wrapIdentifier)
Select	page(Integer page)
Select	page(Integer page, Integer pageSize)
Select	page(Page page)
Params	params()
Select	rightJoin(Select select, Cond on)
Select	rightJoin(String from, Cond on)
Select	rightJoin(String from, String alias, Cond on)
Select	rightJoin(String prefix, String from, String alias, Cond on)
Select	rightJoin(String prefix, String from, String alias, Cond on, boolean safePrefix)
SQL	toSQL()
String	toString()
Select	union(Select select)
Select	union(Union union)
Select	unionAll(Select select)
Where	where()
Select	where(Cond cond)
Select	where(Where where)

Methods inherited from class net.ymate.platform.persistence.jdbc.query.Query

build, build, buildSafeTableName, buildSafeTableName, checkFieldExcluded, dataSourceName, dataSourceName, defaultTablePrefix, dialect, dialect, owner, shardingable, shardingable, shardingRule, shardingRule, wrapIdentifierField, wrapIdentifierField, wrapIdentifierField, wrapIdentifierFields

Methods inherited from class net.ymate.platform.persistence.jdbc.query.QueryHandleAdapter

getExpressionStr, queryHandler, queryHandler

Methods inherited from class java.lang.Object

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

Constructor Detail

Select

public Select(IDatabase owner,
              String dataSourceName)

Select

public Select(IDatabase owner,
              String dataSourceName,
              String prefix,
              String from,
              String alias,
              boolean safePrefix)

Method Detail

create

public static Select create()

create

public static Select create(Class<? extends IEntity> entityClass)

create

public static Select create(String prefix,
                            Class<? extends IEntity> entityClass)

create

public static Select create(Class<? extends IEntity> entityClass,
                            String alias)

create

public static Select create(String prefix,
                            Class<? extends IEntity> entityClass,
                            String alias)

create

public static Select create(String prefix,
                            String from,
                            String alias)

create

public static Select create(String from,
                            String alias)

create

public static Select create(String from,
                            String alias,
                            boolean safePrefix)

create

public static Select create(String from)

create

public static Select create(String from,
                            boolean safePrefix)

create

public static Select create(Select select)

create

public static Select create(IDatabase owner)

create

public static Select create(IDatabase owner,
                            String dataSourceName)

create

public static Select create(IDatabase owner,
                            String dataSourceName,
                            Class<? extends IEntity> entityClass)

create

public static Select create(IDatabase owner,
                            String dataSourceName,
                            String prefix,
                            Class<? extends IEntity> entityClass)

create

public static Select create(IDatabase owner,
                            String dataSourceName,
                            Class<? extends IEntity> entityClass,
                            String alias)

create

public static Select create(IDatabase owner,
                            String dataSourceName,
                            String prefix,
                            Class<? extends IEntity> entityClass,
                            String alias)

create

public static Select create(IDatabase owner,
                            String dataSourceName,
                            String prefix,
                            String from,
                            String alias)

create

public static Select create(IDatabase owner,
                            String dataSourceName,
                            String from,
                            String alias)

create

public static Select create(IDatabase owner,
                            String dataSourceName,
                            String from,
                            String alias,
                            boolean safePrefix)

create

public static Select create(IDatabase owner,
                            String dataSourceName,
                            String from)

create

public static Select create(IDatabase owner,
                            String dataSourceName,
                            String from,
                            boolean safePrefix)

create

public static Select create(Query<?> query)

create

public static Select create(Query<?> query,
                            String prefix,
                            String from,
                            String alias,
                            boolean safePrefix)

from

public Select from(Class<? extends IEntity> entityClass)

from

public Select from(Class<? extends IEntity> entityClass,
                   boolean safePrefix)

from

public Select from(Class<? extends IEntity> entityClass,
                   String alias)

from

public Select from(Class<? extends IEntity> entityClass,
                   String alias,
                   boolean safePrefix)

from

public Select from(String prefix,
                   Class<? extends IEntity> entityClass,
                   String alias)

from

public Select from(String prefix,
                   Class<? extends IEntity> entityClass,
                   String alias,
                   boolean safePrefix)

from

public Select from(Select select)

from

public Select from(String tableName,
                   String alias)

from

public Select from(String tableName)

from

public Select from(String prefix,
                   String from,
                   String alias)

from

public Select from(String prefix,
                   String from,
                   String alias,
                   boolean safePrefix)

fields

public Fields fields()

field

public Select field(String field)

field

public Select field(String field,
                    boolean wrapIdentifier)

field

public Select field(String prefix,
                    String field)

field

public Select field(String prefix,
                    String field,
                    boolean wrapIdentifier)

field

public Select field(String prefix,
                    String field,
                    String alias)

field

public Select field(String prefix,
                    String field,
                    String alias,
                    boolean wrapIdentifier)

field

public Select field(Fields fields)

field

public Select field(Fields fields,
                    boolean wrapIdentifier)

field

public Select field(String prefix,
                    Fields fields)

field

public Select field(String prefix,
                    Fields fields,
                    boolean wrapIdentifier)

field

public Select field(IFunction func,
                    String alias)

field

public Select field(IFunction func)

join

public Select join(Join join)

innerJoin

public Select innerJoin(Select select,
                        Cond on)

leftJoin

public Select leftJoin(Select select,
                       Cond on)

rightJoin

public Select rightJoin(Select select,
                        Cond on)

innerJoin

public Select innerJoin(String from,
                        Cond on)

leftJoin

public Select leftJoin(String from,
                       Cond on)

rightJoin

public Select rightJoin(String from,
                        Cond on)

innerJoin

public Select innerJoin(String from,
                        String alias,
                        Cond on)

leftJoin

public Select leftJoin(String from,
                       String alias,
                       Cond on)

rightJoin

public Select rightJoin(String from,
                        String alias,
                        Cond on)

innerJoin

public Select innerJoin(String prefix,
                        String from,
                        String alias,
                        Cond on)

leftJoin

public Select leftJoin(String prefix,
                       String from,
                       String alias,
                       Cond on)

rightJoin

public Select rightJoin(String prefix,
                        String from,
                        String alias,
                        Cond on)

innerJoin

public Select innerJoin(String prefix,
                        String from,
                        String alias,
                        Cond on,
                        boolean safePrefix)

leftJoin

public Select leftJoin(String prefix,
                       String from,
                       String alias,
                       Cond on,
                       boolean safePrefix)

rightJoin

public Select rightJoin(String prefix,
                        String from,
                        String alias,
                        Cond on,
                        boolean safePrefix)

union

public Select union(Union union)

union

public Select union(Select select)

unionAll

public Select unionAll(Select select)

where

public Select where(Where where)

params

public Params params()

where

public Where where()

where

public Select where(Cond cond)

orderBy

public Select orderBy(OrderBy orderBy)

orderByAsc

public Select orderByAsc(String field)

orderByAsc

public Select orderByAsc(String field,
                         boolean wrapIdentifier)

orderByAsc

public Select orderByAsc(String prefix,
                         String field)

orderByAsc

public Select orderByAsc(String prefix,
                         String field,
                         boolean wrapIdentifier)

orderByAsc

public Select orderByAsc(Fields fields)

orderByAsc

public Select orderByAsc(Fields fields,
                         boolean wrapIdentifier)

orderByAsc

public Select orderByAsc(String prefix,
                         Fields fields)

orderByAsc

public Select orderByAsc(String prefix,
                         Fields fields,
                         boolean wrapIdentifier)

orderByDesc

public Select orderByDesc(String field)

orderByDesc

public Select orderByDesc(String field,
                          boolean wrapIdentifier)

orderByDesc

public Select orderByDesc(String prefix,
                          String field)

orderByDesc

public Select orderByDesc(String prefix,
                          String field,
                          boolean wrapIdentifier)

orderByDesc

public Select orderByDesc(Fields fields)

orderByDesc

public Select orderByDesc(Fields fields,
                          boolean wrapIdentifier)

orderByDesc

public Select orderByDesc(String prefix,
                          Fields fields)

orderByDesc

public Select orderByDesc(String prefix,
                          Fields fields,
                          boolean wrapIdentifier)

groupByRollup

public Select groupByRollup()

groupBy

public Select groupBy(GroupBy groupBy)

groupBy

public Select groupBy(String prefix,
                      Fields fields,
                      boolean desc,
                      boolean wrapIdentifier)

groupBy

public Select groupBy(String prefix,
                      Fields fields,
                      boolean wrapIdentifier)

groupBy

public Select groupBy(String prefix,
                      Fields fields)

groupBy

public Select groupBy(Fields fields)

groupBy

public Select groupBy(Fields fields,
                      boolean wrapIdentifier)

groupBy

public Select groupBy(Fields fields,
                      boolean desc,
                      boolean wrapIdentifier)

groupBy

public Select groupBy(String prefix,
                      String field)

groupBy

public Select groupBy(String prefix,
                      String field,
                      boolean wrapIdentifier)

groupBy

public Select groupBy(String prefix,
                      String field,
                      boolean desc,
                      boolean wrapIdentifier)

groupBy

public Select groupBy(String field)

groupBy

public Select groupBy(String field,
                      boolean wrapIdentifier)

groupBy

public Select groupBy(String field,
                      boolean desc,
                      boolean wrapIdentifier)

groupByDesc

public Select groupByDesc(String prefix,
                          Fields fields,
                          boolean wrapIdentifier)

groupByDesc

public Select groupByDesc(String prefix,
                          Fields fields)

groupByDesc

public Select groupByDesc(Fields fields)

groupByDesc

public Select groupByDesc(Fields fields,
                          boolean wrapIdentifier)

groupByDesc

public Select groupByDesc(String prefix,
                          String field)

groupByDesc

public Select groupByDesc(String prefix,
                          String field,
                          boolean wrapIdentifier)

groupByDesc

public Select groupByDesc(String field)

groupByDesc

public Select groupByDesc(String field,
                          boolean wrapIdentifier)

having

public Select having(Cond cond)

alias

public Select alias(String alias)

设置Select语句的别名

Parameters:

alias - 别名

Returns:

返回当前Select对象

distinct

public Select distinct()

forUpdate

public Select forUpdate(IDBLocker dbLocker)

page

public Select page(Page page)

page

public Select page(Integer page)

page

public Select page(Integer page,
                   Integer pageSize)

toString

public String toString()

Overrides:

toString in class Object

toSQL

public SQL toSQL()

findFirst

public <T> T findFirst(IResultSetHandler<T> handler)
                throws Exception

Throws:

Exception

find

public <T> IResultSet<T> find(IResultSetHandler<T> handler)
                       throws Exception

Throws:

Exception

find

public <T> IResultSet<T> find(IResultSetHandler<T> handler,
                              Page page)
                       throws Exception

Throws:

Exception

count

public long count()
           throws Exception

Throws:

Exception