Package org.mybatis.dynamic.sql.dsl

Class SelectDSL

java.lang.Object

org.mybatis.dynamic.sql.dsl.SelectDSL

All Implemented Interfaces:

ForAndWaitOperations<SelectDSL>, GroupByOperations<SelectDSL>, HavingOperations<SelectDSL.QueryExpressionHavingBuilder>, JoinOperations<SelectDSL.JoinSpecificationFinisher>, LimitAndOffsetOperations<SelectDSL,SelectModel>, OrderByOperations<SelectDSL>, WhereOperations<SelectDSL.QueryExpressionWhereBuilder>, Buildable<SelectModel>, ConfigurableStatement<SelectDSL>

public class SelectDSL
extends Object
implements JoinOperations<SelectDSL.JoinSpecificationFinisher>, WhereOperations<SelectDSL.QueryExpressionWhereBuilder>, OrderByOperations<SelectDSL>, GroupByOperations<SelectDSL>, HavingOperations<SelectDSL.QueryExpressionHavingBuilder>, LimitAndOffsetOperations<SelectDSL,SelectModel>, ForAndWaitOperations<SelectDSL>, ConfigurableStatement<SelectDSL>, Buildable<SelectModel>

Nested Class Summary

Nested Classes

Modifier and Type	Class	Description
class	SelectDSL.JoinSpecificationFinisher
class	SelectDSL.QueryExpressionHavingBuilder
class	SelectDSL.QueryExpressionWhereBuilder
class	SelectDSL.UnionBuilder

Nested classes/interfaces inherited from interface org.mybatis.dynamic.sql.dsl.JoinOperations

JoinOperations.JoinOnGatherer<F extends BooleanOperations<?>>

Nested classes/interfaces inherited from interface org.mybatis.dynamic.sql.dsl.LimitAndOffsetOperations

LimitAndOffsetOperations.FetchFirstFinisher<T>, LimitAndOffsetOperations.LimitFinisher<T,M>, LimitAndOffsetOperations.OffsetFirstFinisher<T,M>

Method Summary

Modifier and Type	Method	Description
SelectDSL.QueryExpressionHavingBuilder	applyHaving(HavingApplier havingApplier)
SelectDSL.QueryExpressionWhereBuilder	applyWhere(WhereApplier whereApplier)
SelectModel	build()
SelectDSL	configureStatement(Consumer<StatementConfiguration> consumer)
LimitAndOffsetOperations.FetchFirstFinisher<SelectDSL>	fetchFirstWhenPresent(@Nullable Long fetchFirstRows)
SelectDSL	from(SqlTable table)
SelectDSL	from(SqlTable table, String tableAlias)
SelectDSL	from(Buildable<SelectModel> select)
SelectDSL	from(Buildable<SelectModel> select, String tableAlias)
SelectDSL	groupBy(Collection<? extends BasicColumn> columns)
SelectDSL.QueryExpressionHavingBuilder	having(SqlCriterion initialCriterion)
SelectDSL.JoinSpecificationFinisher	join(JoinType joinType, SqlTable joinTable, String tableAlias, SqlCriterion initialCriterion)
SelectDSL.JoinSpecificationFinisher	join(JoinType joinType, TableExpression joinTable, SqlCriterion initialCriterion)
LimitAndOffsetOperations.LimitFinisher<SelectDSL,SelectModel>	limitWhenPresent(@Nullable Long limit)
LimitAndOffsetOperations.OffsetFirstFinisher<SelectDSL,SelectModel>	offsetWhenPresent(@Nullable Long offset)
SelectDSL	orderBy(Collection<? extends SortSpecification> columns)
static SelectDSL	select(Collection<? extends BasicColumn> selectList)
static SelectDSL	select(BasicColumn... selectList)
static SelectDSL	selectDistinct(Collection<? extends BasicColumn> selectList)
static SelectDSL	selectDistinct(BasicColumn... selectList)
SelectDSL	setForClause(String forClause)
SelectDSL	setWaitClause(String waitClause)
SelectDSL.UnionBuilder	union()
SelectDSL.UnionBuilder	unionAll()
SelectDSL.QueryExpressionWhereBuilder	where()
SelectDSL.QueryExpressionWhereBuilder	where(SqlCriterion initialCriterion)

Methods inherited from class java.lang.Object

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

Methods inherited from interface org.mybatis.dynamic.sql.dsl.ForAndWaitOperations

forKeyShare, forNoKeyUpdate, forShare, forUpdate, nowait, skipLocked

Methods inherited from interface org.mybatis.dynamic.sql.dsl.GroupByOperations

groupBy

Methods inherited from interface org.mybatis.dynamic.sql.dsl.HavingOperations

having, having, having, having

Methods inherited from interface org.mybatis.dynamic.sql.dsl.JoinOperations

fullJoin, fullJoin, fullJoin, fullJoin, fullJoin, fullJoin, fullJoin, fullJoin, join, join, join, join, join, join, join, join, leftJoin, leftJoin, leftJoin, leftJoin, leftJoin, leftJoin, leftJoin, leftJoin, rightJoin, rightJoin, rightJoin, rightJoin, rightJoin, rightJoin, rightJoin, rightJoin

Methods inherited from interface org.mybatis.dynamic.sql.dsl.LimitAndOffsetOperations

fetchFirst, limit, offset

Methods inherited from interface org.mybatis.dynamic.sql.dsl.OrderByOperations

orderBy

Methods inherited from interface org.mybatis.dynamic.sql.dsl.WhereOperations

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

Method Details

select

public static SelectDSL select(BasicColumn... selectList)

select

public static SelectDSL select(Collection<? extends BasicColumn> selectList)

selectDistinct

public static SelectDSL selectDistinct(BasicColumn... selectList)

selectDistinct

public static SelectDSL selectDistinct(Collection<? extends BasicColumn> selectList)

from

public SelectDSL from(Buildable<SelectModel> select)

from

public SelectDSL from(Buildable<SelectModel> select,
 String tableAlias)

from

public SelectDSL from(SqlTable table)

from

public SelectDSL from(SqlTable table,
 String tableAlias)

join

public SelectDSL.JoinSpecificationFinisher join(JoinType joinType,
 TableExpression joinTable,
 SqlCriterion initialCriterion)

Specified by:

join in interface JoinOperations<SelectDSL.JoinSpecificationFinisher>

join

public SelectDSL.JoinSpecificationFinisher join(JoinType joinType,
 SqlTable joinTable,
 String tableAlias,
 SqlCriterion initialCriterion)

Specified by:

join in interface JoinOperations<SelectDSL.JoinSpecificationFinisher>

where

public SelectDSL.QueryExpressionWhereBuilder where()

Specified by:

where in interface WhereOperations<SelectDSL.QueryExpressionWhereBuilder>

where

public SelectDSL.QueryExpressionWhereBuilder where(SqlCriterion initialCriterion)

Specified by:

where in interface WhereOperations<SelectDSL.QueryExpressionWhereBuilder>

applyWhere

public SelectDSL.QueryExpressionWhereBuilder applyWhere(WhereApplier whereApplier)

Specified by:

applyWhere in interface WhereOperations<SelectDSL.QueryExpressionWhereBuilder>

orderBy

public SelectDSL orderBy(Collection<? extends SortSpecification> columns)

Specified by:

orderBy in interface OrderByOperations<SelectDSL>

groupBy

public SelectDSL groupBy(Collection<? extends BasicColumn> columns)

Specified by:

groupBy in interface GroupByOperations<SelectDSL>

having

public SelectDSL.QueryExpressionHavingBuilder having(SqlCriterion initialCriterion)

Specified by:

having in interface HavingOperations<SelectDSL.QueryExpressionHavingBuilder>

applyHaving

public SelectDSL.QueryExpressionHavingBuilder applyHaving(HavingApplier havingApplier)

Specified by:

applyHaving in interface HavingOperations<SelectDSL.QueryExpressionHavingBuilder>

limitWhenPresent

public LimitAndOffsetOperations.LimitFinisher<SelectDSL,SelectModel> limitWhenPresent(@Nullable Long limit)

Specified by:

limitWhenPresent in interface LimitAndOffsetOperations<SelectDSL,SelectModel>

offsetWhenPresent

public LimitAndOffsetOperations.OffsetFirstFinisher<SelectDSL,SelectModel> offsetWhenPresent(@Nullable Long offset)

Specified by:

offsetWhenPresent in interface LimitAndOffsetOperations<SelectDSL,SelectModel>

fetchFirstWhenPresent

public LimitAndOffsetOperations.FetchFirstFinisher<SelectDSL> fetchFirstWhenPresent(@Nullable Long fetchFirstRows)

Specified by:

fetchFirstWhenPresent in interface LimitAndOffsetOperations<SelectDSL,SelectModel>

setWaitClause

public SelectDSL setWaitClause(String waitClause)

Specified by:

setWaitClause in interface ForAndWaitOperations<SelectDSL>

setForClause

public SelectDSL setForClause(String forClause)

Specified by:

setForClause in interface ForAndWaitOperations<SelectDSL>

union

public SelectDSL.UnionBuilder union()

unionAll

public SelectDSL.UnionBuilder unionAll()

configureStatement

public SelectDSL configureStatement(Consumer<StatementConfiguration> consumer)

Specified by:

configureStatement in interface ConfigurableStatement<SelectDSL>

build

public SelectModel build()

Specified by:

build in interface Buildable<SelectModel>