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)
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
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

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

public R build()

Specified by:

build in interface Buildable<R>