Class Select.Default

java.lang.Object

org.huiche.core.ast.Segment.Default

org.huiche.ast.statement.clause.Where.Default<Select>

org.huiche.ast.statement.Select.Default

All Implemented Interfaces:

Serializable, SelectOperable, SetOperable, WhereOperable<Select>, Where<Select>, QueryExpr, Select, Segment, Statement

Enclosing interface:

Select

public static class Select.Default
extends Where.Default<Select>
implements Select

Select默认实现

Author:

Maning

See Also:

• Serialized Form

Nested Class Summary

Nested classes/interfaces inherited from interface Segment

Segment.Default

Nested classes/interfaces inherited from interface Select

Select.Default

Nested classes/interfaces inherited from interface Where

Where.Default<T>

Method Summary

Modifier and Type	Method	Description
DerivedTableRef	as(String alias)	指定别名,作为表子查询(派生表)
SubQueryExpression	asSubQuery()	作为标量子查询|行子查询
Select	clearSelect()	清除当前selection
Select	distinct(boolean distinct)	去重
TableRef	from()	from的表
Select	from(TableRef table)	from操作
Select	groupBy(Expression groupBy)	分组
List<Expression>	groupBys()	groupBy的字段
Select	having(Collection<? extends Condition> havings)	分组过滤
Select	having(Condition having)	分组过滤
List<Condition>	havings()	having的字段
boolean	isDistinct()	是否去重
JoinOperable<Select>	join(JoinType joinType, TableRef table)	连接查询
List<Join<Select>>	joins()	关联的表
Integer	limit()	限制条数
Select	limit(Integer limit, Integer offset)	限制条数和跳过条数
Integer	offset()	跳过条数
Select	orderBy(Collection<? extends OrderBy> orderBys)	排序
Select	orderBy(OrderBy orderBy)	排序
List<OrderBy>	orderBys()	排序
String	pseudoSql()	伪SQL,用于直接toString时显示
Select	select(Collection<?> selects)	select操作 可传入Class,作为table.* Table.of(Class) 可传入Table,当作table.* 可传入String(或lombok.
List<Object>	selections()	查询的列
SetQuery	setQuery(SetOp op, QueryExpr other)	集合查询
With	with()	CTE

Methods inherited from class Where.Default

where, where, wheres

Methods inherited from class Segment.Default

equals, hashCode, toString

Methods inherited from class Object

clone, finalize, getClass, notify, notifyAll, wait, wait, wait

Methods inherited from interface Segment

staticable

Methods inherited from interface SelectOperable

crossJoin, crossJoin, crossJoin, distinct, from, from, fullJoin, fullJoin, fullJoin, groupBy, groupBy, groupBy, groupBy, groupBy, groupBy, groupBy, groupBy, having, having, having, having, having, having, having, having, having, having, having, join, join, join, leftJoin, leftJoin, leftJoin, limit, limit, naturalJoin, naturalJoin, naturalJoin, orderBy, orderBy, orderBy, orderBy, orderBy, orderBy, orderBy, orderBy, orderBy, rightJoin, rightJoin, rightJoin, select, select, select

Methods inherited from interface SetOperable

except, exceptAll, intersect, intersectAll, union, unionAll

Methods inherited from interface Where

wheres

Methods inherited from interface WhereOperable

where, where, where, where, where, where, where, where, where, where, where, where, where

Method Details

as

public DerivedTableRef as(String alias)

Description copied from interface: SelectOperable

指定别名,作为表子查询(派生表)

Specified by:

as in interface SelectOperable

Parameters:

alias - 别名

Returns:

派生表子查询

asSubQuery

public SubQueryExpression asSubQuery()

Description copied from interface: SelectOperable

作为标量子查询|行子查询

Specified by:

asSubQuery in interface SelectOperable

Returns:

子查询

distinct

public Select distinct(boolean distinct)

Description copied from interface: SelectOperable

去重

Specified by:

distinct in interface SelectOperable

Parameters:

distinct - 是否去重

Returns:

select语句

from

public Select from(TableRef table)

Description copied from interface: SelectOperable

from操作

Specified by:

from in interface SelectOperable

Parameters:

table - 表

Returns:

select语句

groupBy

public Select groupBy(Expression groupBy)

Description copied from interface: SelectOperable

分组

Specified by:

groupBy in interface SelectOperable

Parameters:

groupBy - 分组列

Returns:

查询语句

having

public Select having(Collection<? extends Condition> havings)

Description copied from interface: SelectOperable

分组过滤

Specified by:

having in interface SelectOperable

Parameters:

havings - 条件

Returns:

查询语句

having

public Select having(Condition having)

Description copied from interface: SelectOperable

分组过滤

Specified by:

having in interface SelectOperable

Parameters:

having - 条件

Returns:

查询语句

join

public JoinOperable<Select> join(JoinType joinType,
 TableRef table)

Description copied from interface: SelectOperable

连接查询

Specified by:

join in interface SelectOperable

Parameters:

joinType - 连接类型

table - 表

Returns:

join操作

limit

public Select limit(Integer limit,
 Integer offset)

Description copied from interface: SelectOperable

限制条数和跳过条数

Specified by:

limit in interface SelectOperable

Parameters:

limit - 限制条数

offset - 跳过条数

Returns:

查询语句

orderBy

public Select orderBy(Collection<? extends OrderBy> orderBys)

Description copied from interface: SelectOperable

排序

Specified by:

orderBy in interface SelectOperable

Parameters:

orderBys - 列排序

Returns:

查询语句

orderBy

public Select orderBy(OrderBy orderBy)

Description copied from interface: SelectOperable

排序

Specified by:

orderBy in interface SelectOperable

Parameters:

orderBy - 列排序

Returns:

查询语句

select

public Select select(Collection<?> selects)

Description copied from interface: SelectOperable

select操作
可传入Class,作为table.* Table.of(Class)
可传入Table,当作table.* 可传入String(或lombok.@FieldNameConstants,本质还是String),作为列Column.of(String)
可传入Enum,当作lombok.@FieldNameConstants(asEnum = true)解析,作为列Column.of(Enum)
可传入SerializableFunction,作为列Column.of(SerializableFunction)
可传入Select,当作标量子查询,会包装为SubQueryExpression
可传入所有Expression 及其子类
可传入别名AliasSegment
可传入Literal 支持的类型(String和Enum除外),String和Enum因为当作列解析,必须使用Literal包装传入

Specified by:

select in interface SelectOperable

Parameters:

selects - 选择的列

Returns:

select语句

clearSelect

public Select clearSelect()

Description copied from interface: SelectOperable

清除当前selection

Specified by:

clearSelect in interface SelectOperable

Returns:

select语句

from

public TableRef from()

Description copied from interface: Select

from的表

Specified by:

from in interface Select

Returns:

from的表

groupBys

public List<Expression> groupBys()

Description copied from interface: Select

groupBy的字段

Specified by:

groupBys in interface Select

Returns:

groupBy的字段

havings

public List<Condition> havings()

Description copied from interface: Select

having的字段

Specified by:

havings in interface Select

Returns:

having的字段

isDistinct

public boolean isDistinct()

Description copied from interface: Select

是否去重

Specified by:

isDistinct in interface Select

Returns:

是否去重

joins

public List<Join<Select>> joins()

Description copied from interface: Select

关联的表

Specified by:

joins in interface Select

Returns:

关联的表

limit

public Integer limit()

Description copied from interface: Select

限制条数

Specified by:

limit in interface Select

Returns:

限制条数

offset

public Integer offset()

Description copied from interface: Select

跳过条数

Specified by:

offset in interface Select

Returns:

跳过条数

orderBys

public List<OrderBy> orderBys()

Description copied from interface: Select

排序

Specified by:

orderBys in interface Select

Returns:

排序

selections

public List<Object> selections()

Description copied from interface: Select

查询的列

Specified by:

selections in interface Select

Returns:

查询的列

with

public With with()

Description copied from interface: Select

CTE

Specified by:

with in interface Select

Returns:

CTE

pseudoSql

public String pseudoSql()

Description copied from interface: Segment

伪SQL,用于直接toString时显示

Specified by:

pseudoSql in interface Segment

Overrides:

pseudoSql in class Where.Default<Select>

Returns:

伪SQL

setQuery

public SetQuery setQuery(SetOp op,
 QueryExpr other)

Description copied from interface: SetOperable

集合查询

Specified by:

setQuery in interface SetOperable

Parameters:

op - 集合操作

other - 查询

Returns:

集合查询