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>

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

Implements a SQL DSL for building select statements.

Author:

Jeff Butler

Nested Class Summary

Nested Classes

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

Method Summary

Modifier and Type	Method and Description
R	build()
SelectDSL.FetchFirstFinisher	fetchFirst(long fetchFirstRows)
SelectDSL.LimitFinisher	limit(long limit)
SelectDSL.OffsetFirstFinisher	offset(long offset)
static QueryExpressionDSL.FromGatherer<SelectModel>	select(BasicColumn... selectList)
static QueryExpressionDSL.FromGatherer<SelectModel>	select(Collection<BasicColumn> selectList)
static <R> QueryExpressionDSL.FromGatherer<R>	select(Function<SelectModel,R> adapterFunction, BasicColumn... selectList)
static <R> QueryExpressionDSL.FromGatherer<R>	select(Function<SelectModel,R> adapterFunction, Collection<BasicColumn> selectList)
static QueryExpressionDSL.FromGatherer<SelectModel>	selectDistinct(BasicColumn... selectList)
static QueryExpressionDSL.FromGatherer<SelectModel>	selectDistinct(Collection<BasicColumn> selectList)
static <R> QueryExpressionDSL.FromGatherer<R>	selectDistinct(Function<SelectModel,R> adapterFunction, BasicColumn... selectList)
static <R> QueryExpressionDSL.FromGatherer<R>	selectDistinct(Function<SelectModel,R> adapterFunction, Collection<BasicColumn> selectList)

Methods inherited from class java.lang.Object

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

Method Detail

select

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

select

public static QueryExpressionDSL.FromGatherer<SelectModel> select(Collection<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<BasicColumn> selectList)

selectDistinct

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

selectDistinct

public static QueryExpressionDSL.FromGatherer<SelectModel> selectDistinct(Collection<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<BasicColumn> selectList)

limit

public SelectDSL.LimitFinisher limit(long limit)

offset

public SelectDSL.OffsetFirstFinisher offset(long offset)

fetchFirst

public SelectDSL.FetchFirstFinisher fetchFirst(long fetchFirstRows)

build

@NotNull
public R build()

Specified by:

build in interface Buildable<R>