Module org.mybatis.dynamic.sql

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>

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	Description
class	SelectDSL.FetchFirstFinisher
class	SelectDSL.LimitFinisher
class	SelectDSL.OffsetFinisher
class	SelectDSL.OffsetFirstFinisher
class	SelectDSL.RowsOnlyFinisher

Method Summary

Modifier and Type	Method	Description
R	build()
SelectDSL.FetchFirstFinisher	fetchFirst(long fetchFirstRows)
SelectDSL.LimitFinisher	limit(long limit)
SelectDSL.OffsetFirstFinisher	offset(long offset)
static QueryExpressionDSL.FromGatherer<SelectModel>	select(Collection<BasicColumn> selectList)
static <R> QueryExpressionDSL.FromGatherer<R>	select(Function<SelectModel,R> adapterFunction, Collection<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<BasicColumn> selectList)
static <R> QueryExpressionDSL.FromGatherer<R>	selectDistinct(Function<SelectModel,R> adapterFunction, Collection<BasicColumn> selectList)
static <R> QueryExpressionDSL.FromGatherer<R>	selectDistinct(Function<SelectModel,R> adapterFunction, BasicColumn... selectList)
static QueryExpressionDSL.FromGatherer<SelectModel>	selectDistinct(BasicColumn... selectList)
static <T> QueryExpressionDSL.FromGatherer<MyBatis3SelectModelAdapter<T>>	selectDistinctWithMapper(Function<SelectStatementProvider,T> mapperMethod, BasicColumn... selectList)	Deprecated. in favor of various select methods in MyBatis3Utils.
static <T> QueryExpressionDSL.FromGatherer<MyBatis3SelectModelAdapter<T>>	selectWithMapper(Function<SelectStatementProvider,T> mapperMethod, BasicColumn... selectList)	Deprecated. in favor of various select methods in MyBatis3Utils.

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)

selectWithMapper

@Deprecated
public static <T> QueryExpressionDSL.FromGatherer<MyBatis3SelectModelAdapter<T>> selectWithMapper(Function<SelectStatementProvider,T> mapperMethod,
                                                                                                  BasicColumn... selectList)

Deprecated.

in favor of various select methods in MyBatis3Utils. This method will be removed without direct replacement in a future version

Select records by executing a MyBatis3 Mapper.

Type Parameters:

T - the return type from a MyBatis mapper - typically a List or a single record

Parameters:

mapperMethod - MyBatis3 mapper method that performs the select

selectList - the column list to select

Returns:

the partially created query

selectDistinctWithMapper

@Deprecated
public static <T> QueryExpressionDSL.FromGatherer<MyBatis3SelectModelAdapter<T>> selectDistinctWithMapper(Function<SelectStatementProvider,T> mapperMethod,
                                                                                                          BasicColumn... selectList)

Deprecated.

in favor of various select methods in MyBatis3Utils. This method will be removed without direct replacement in a future version

Select records by executing a MyBatis3 Mapper.

Type Parameters:

T - the return type from a MyBatis mapper - typically a List or a single record

Parameters:

mapperMethod - MyBatis3 mapper method that performs the select

selectList - the column list to select

Returns:

the partially created query

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>