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:

Buildable<R>, ConfigurableStatement<SelectDSL<R>>

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

Implements a SQL DSL for building select statements.

Author:

Jeff Butler

Nested Class Summary

Nested Classes

Modifier and Type	Class	Description
class	SelectDSL.FetchFirstFinisher
class	SelectDSL.LimitFinisher
class	SelectDSL.OffsetFirstFinisher

Method Summary

Modifier and Type	Method	Description
R	build()
SelectDSL<R>	configureStatement(Consumer<StatementConfiguration> consumer)
SelectDSL<R>.FetchFirstFinisher	fetchFirst(long fetchFirstRows)
SelectDSL<R>.FetchFirstFinisher	fetchFirstWhenPresent(@Nullable Long fetchFirstRows)
SelectDSL<R>	forKeyShare()
SelectDSL<R>	forNoKeyUpdate()
SelectDSL<R>	forShare()
SelectDSL<R>	forUpdate()
SelectDSL<R>.LimitFinisher	limit(long limit)
SelectDSL<R>.LimitFinisher	limitWhenPresent(@Nullable Long limit)
SelectDSL<R>	nowait()
SelectDSL<R>.OffsetFirstFinisher	offset(long offset)
SelectDSL<R>.OffsetFirstFinisher	offsetWhenPresent(@Nullable Long offset)
static QueryExpressionDSL.FromGatherer<SelectModel>	select(Collection<? extends BasicColumn> selectList)
static <R> QueryExpressionDSL.FromGatherer<R>	select(Function<SelectModel,R> adapterFunction, Collection<? extends BasicColumn> selectList)
static <R> QueryExpressionDSL.FromGatherer<R>	select(Function<SelectModel,R> adapterFunction, BasicColumn... selectList)
static QueryExpressionDSL.FromGatherer<SelectModel>	select(BasicColumn... selectList)
static QueryExpressionDSL.FromGatherer<SelectModel>	selectDistinct(Collection<? extends BasicColumn> selectList)
static <R> QueryExpressionDSL.FromGatherer<R>	selectDistinct(Function<SelectModel,R> adapterFunction, Collection<? extends BasicColumn> selectList)
static <R> QueryExpressionDSL.FromGatherer<R>	selectDistinct(Function<SelectModel,R> adapterFunction, BasicColumn... selectList)
static QueryExpressionDSL.FromGatherer<SelectModel>	selectDistinct(BasicColumn... selectList)
SelectDSL<R>	skipLocked()

Methods inherited from class java.lang.Object

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

Method Details

select

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

select

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

select

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

select

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

selectDistinct

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

selectDistinct

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

selectDistinct

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

selectDistinct

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

limit

public SelectDSL<R>.LimitFinisher limit(long limit)

limitWhenPresent

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

offset

public SelectDSL<R>.OffsetFirstFinisher offset(long offset)

offsetWhenPresent

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

fetchFirst

public SelectDSL<R>.FetchFirstFinisher fetchFirst(long fetchFirstRows)

fetchFirstWhenPresent

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

forUpdate

public SelectDSL<R> forUpdate()

forNoKeyUpdate

public SelectDSL<R> forNoKeyUpdate()

forShare

public SelectDSL<R> forShare()

forKeyShare

public SelectDSL<R> forKeyShare()

skipLocked

public SelectDSL<R> skipLocked()

nowait

public SelectDSL<R> nowait()

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>