Package org.mybatis.dynamic.sql.select

Class QueryExpressionDSL<R>

java.lang.Object

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

All Implemented Interfaces:

Buildable<R>

public class QueryExpressionDSL<R>
extends java.lang.Object
implements Buildable<R>

Nested Class Summary

Nested Classes

Modifier and Type	Class	Description
static class	QueryExpressionDSL.FromGatherer<R>
class	QueryExpressionDSL.GroupByFinisher
class	QueryExpressionDSL.JoinSpecificationFinisher
class	QueryExpressionDSL.JoinSpecificationStarter
class	QueryExpressionDSL.QueryExpressionWhereBuilder
class	QueryExpressionDSL.UnionBuilder

Method Summary

Modifier and Type	Method	Description
R	build()
protected QueryExpressionModel	buildModel()
SelectDSL.FetchFirstFinisher	fetchFirst(long fetchFirstRows)
QueryExpressionDSL.JoinSpecificationStarter	fullJoin(SqlTable joinTable)
QueryExpressionDSL.JoinSpecificationStarter	fullJoin(SqlTable joinTable, java.lang.String tableAlias)
QueryExpressionDSL.GroupByFinisher	groupBy(BasicColumn... columns)
QueryExpressionDSL.JoinSpecificationStarter	join(SqlTable joinTable)
QueryExpressionDSL.JoinSpecificationStarter	join(SqlTable joinTable, java.lang.String tableAlias)
QueryExpressionDSL.JoinSpecificationStarter	leftJoin(SqlTable joinTable)
QueryExpressionDSL.JoinSpecificationStarter	leftJoin(SqlTable joinTable, java.lang.String tableAlias)
SelectDSL.LimitFinisher	limit(long limit)
SelectDSL.OffsetFirstFinisher	offset(long offset)
SelectDSL<R>	orderBy(SortSpecification... columns)
QueryExpressionDSL.JoinSpecificationStarter	rightJoin(SqlTable joinTable)
QueryExpressionDSL.JoinSpecificationStarter	rightJoin(SqlTable joinTable, java.lang.String tableAlias)
static <R> QueryExpressionDSL.FromGatherer<R>	select(SelectDSL<R> selectDSL, BasicColumn... selectList)
static <R> QueryExpressionDSL.FromGatherer<R>	selectDistinct(SelectDSL<R> selectDSL, BasicColumn... selectList)
QueryExpressionDSL.UnionBuilder	union()
QueryExpressionDSL.UnionBuilder	unionAll()
QueryExpressionDSL.QueryExpressionWhereBuilder	where()
<T> QueryExpressionDSL.QueryExpressionWhereBuilder	where(BindableColumn<T> column, VisitableCondition<T> condition)
<T> QueryExpressionDSL.QueryExpressionWhereBuilder	where(BindableColumn<T> column, VisitableCondition<T> condition, SqlCriterion<?>... subCriteria)

Methods inherited from class java.lang.Object

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

Method Detail

select

public static <R> QueryExpressionDSL.FromGatherer<R> select(SelectDSL<R> selectDSL,
                                                            BasicColumn... selectList)

selectDistinct

public static <R> QueryExpressionDSL.FromGatherer<R> selectDistinct(SelectDSL<R> selectDSL,
                                                                    BasicColumn... selectList)

where

public QueryExpressionDSL.QueryExpressionWhereBuilder where()

where

public <T> QueryExpressionDSL.QueryExpressionWhereBuilder where(BindableColumn<T> column,
                                                                VisitableCondition<T> condition)

where

public <T> QueryExpressionDSL.QueryExpressionWhereBuilder where(BindableColumn<T> column,
                                                                VisitableCondition<T> condition,
                                                                SqlCriterion<?>... subCriteria)

build

public R build()

Specified by:

build in interface Buildable<R>

join

public QueryExpressionDSL.JoinSpecificationStarter join(SqlTable joinTable)

join

public QueryExpressionDSL.JoinSpecificationStarter join(SqlTable joinTable,
                                                        java.lang.String tableAlias)

leftJoin

public QueryExpressionDSL.JoinSpecificationStarter leftJoin(SqlTable joinTable)

leftJoin

public QueryExpressionDSL.JoinSpecificationStarter leftJoin(SqlTable joinTable,
                                                            java.lang.String tableAlias)

rightJoin

public QueryExpressionDSL.JoinSpecificationStarter rightJoin(SqlTable joinTable)

rightJoin

public QueryExpressionDSL.JoinSpecificationStarter rightJoin(SqlTable joinTable,
                                                             java.lang.String tableAlias)

fullJoin

public QueryExpressionDSL.JoinSpecificationStarter fullJoin(SqlTable joinTable)

fullJoin

public QueryExpressionDSL.JoinSpecificationStarter fullJoin(SqlTable joinTable,
                                                            java.lang.String tableAlias)

groupBy

public QueryExpressionDSL.GroupByFinisher groupBy(BasicColumn... columns)

orderBy

public SelectDSL<R> orderBy(SortSpecification... columns)

union

public QueryExpressionDSL.UnionBuilder union()

unionAll

public QueryExpressionDSL.UnionBuilder unionAll()

buildModel

protected QueryExpressionModel buildModel()

limit

public SelectDSL.LimitFinisher limit(long limit)

offset

public SelectDSL.OffsetFirstFinisher offset(long offset)

fetchFirst

public SelectDSL.FetchFirstFinisher fetchFirst(long fetchFirstRows)