Package org.mybatis.dynamic.sql.select

Class SelectDSL<R>

java.lang.Object

org.mybatis.dynamic.sql.select.SelectDSL<R>

Type Parameters:

R - the type of model produced by this builder, typically SelectModel

All Implemented Interfaces:

ForAndWaitOperations<SelectDSL<R>>, LimitAndOffsetOperations<SelectDSL<R>,R>, OrderByOperations<SelectDSL<R>>, Buildable<R>, ConfigurableStatement<SelectDSL<R>>

public class SelectDSL<R>
extends Object
implements ForAndWaitOperations<SelectDSL<R>>, LimitAndOffsetOperations<SelectDSL<R>,R>, OrderByOperations<SelectDSL<R>>, ConfigurableStatement<SelectDSL<R>>, Buildable<R>

Implements a SQL DSL for building select statements.

Author:

Jeff Butler

Nested Class Summary

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
R	build()
SelectDSL<R>	configureStatement(Consumer<StatementConfiguration> consumer)
LimitAndOffsetOperations.FetchFirstFinisher<SelectDSL<R>>	fetchFirstWhenPresent(@Nullable Long fetchFirstRows)
LimitAndOffsetOperations.LimitFinisher<SelectDSL<R>,R>	limitWhenPresent(@Nullable Long limit)
LimitAndOffsetOperations.OffsetFirstFinisher<SelectDSL<R>,R>	offsetWhenPresent(@Nullable Long offset)
SelectDSL<R>	orderBy(Collection<? extends SortSpecification> columns)
static QueryExpressionDSL<SelectModel>	select(Collection<? extends BasicColumn> selectList)
static <R> QueryExpressionDSL<R>	select(Function<SelectModel,R> adapterFunction, Collection<? extends BasicColumn> selectList)
static <R> QueryExpressionDSL<R>	select(Function<SelectModel,R> adapterFunction, BasicColumn... selectList)
static QueryExpressionDSL<SelectModel>	select(BasicColumn... selectList)
static QueryExpressionDSL<SelectModel>	selectDistinct(Collection<? extends BasicColumn> selectList)
static <R> QueryExpressionDSL<R>	selectDistinct(Function<SelectModel,R> adapterFunction, Collection<? extends BasicColumn> selectList)
static <R> QueryExpressionDSL<R>	selectDistinct(Function<SelectModel,R> adapterFunction, BasicColumn... selectList)
static QueryExpressionDSL<SelectModel>	selectDistinct(BasicColumn... selectList)
SelectDSL<R>	setForClause(String forClause)
SelectDSL<R>	setWaitClause(String waitClause)

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.LimitAndOffsetOperations

fetchFirst, limit, offset

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

orderBy

Method Details

select

public static QueryExpressionDSL<SelectModel> select(BasicColumn... selectList)

select

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

select

public static <R> QueryExpressionDSL<R> select(Function<SelectModel,R> adapterFunction,
 BasicColumn... selectList)

select

public static <R> QueryExpressionDSL<R> select(Function<SelectModel,R> adapterFunction,
 Collection<? extends BasicColumn> selectList)

selectDistinct

public static QueryExpressionDSL<SelectModel> selectDistinct(BasicColumn... selectList)

selectDistinct

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

selectDistinct

public static <R> QueryExpressionDSL<R> selectDistinct(Function<SelectModel,R> adapterFunction,
 BasicColumn... selectList)

selectDistinct

public static <R> QueryExpressionDSL<R> selectDistinct(Function<SelectModel,R> adapterFunction,
 Collection<? extends BasicColumn> selectList)

orderBy

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

Specified by:

orderBy in interface OrderByOperations<R>

limitWhenPresent

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

Specified by:

limitWhenPresent in interface LimitAndOffsetOperations<SelectDSL<R>,R>

offsetWhenPresent

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

Specified by:

offsetWhenPresent in interface LimitAndOffsetOperations<SelectDSL<R>,R>

fetchFirstWhenPresent

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

Specified by:

fetchFirstWhenPresent in interface LimitAndOffsetOperations<SelectDSL<R>,R>

setWaitClause

public SelectDSL<R> setWaitClause(String waitClause)

Specified by:

setWaitClause in interface ForAndWaitOperations<R>

setForClause

public SelectDSL<R> setForClause(String forClause)

Specified by:

setForClause in interface ForAndWaitOperations<R>

configureStatement

public SelectDSL<R> configureStatement(Consumer<StatementConfiguration> consumer)

Specified by:

configureStatement in interface ConfigurableStatement<R>

build

public R build()

Specified by:

build in interface Buildable<R>