org.mybatis.dynamic.sql.select

Class QueryExpressionDSL.JoinSpecificationFinisher

java.lang.Object

org.mybatis.dynamic.sql.select.QueryExpressionDSL.JoinSpecificationFinisher

All Implemented Interfaces:

Buildable<R>

Enclosing class:

QueryExpressionDSL<R>

public class QueryExpressionDSL.JoinSpecificationFinisher
extends Object
implements Buildable<R>

Constructor Summary

Constructors

Constructor and Description
JoinSpecificationFinisher(SqlTable table, BasicColumn joinColumn, JoinCondition joinCondition, JoinType joinType)
JoinSpecificationFinisher(SqlTable table, BasicColumn joinColumn, JoinCondition joinCondition, JoinType joinType, JoinCriterion... andJoinCriteria)

Method Summary

Modifier and Type	Method and Description
QueryExpressionDSL.JoinSpecificationFinisher	and(BasicColumn joinColumn, JoinCondition joinCondition)
R	build()
SelectDSL.FetchFirstFinisher	fetchFirst(long fetchFirstRows)
QueryExpressionDSL.JoinSpecificationStarter	fullJoin(SqlTable joinTable)
QueryExpressionDSL.JoinSpecificationStarter	fullJoin(SqlTable joinTable, String tableAlias)
QueryExpressionDSL.GroupByFinisher	groupBy(BasicColumn... columns)
QueryExpressionDSL.JoinSpecificationStarter	join(SqlTable joinTable)
QueryExpressionDSL.JoinSpecificationStarter	join(SqlTable joinTable, String tableAlias)
QueryExpressionDSL.JoinSpecificationStarter	leftJoin(SqlTable joinTable)
QueryExpressionDSL.JoinSpecificationStarter	leftJoin(SqlTable joinTable, 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, String tableAlias)
QueryExpressionDSL.UnionBuilder	union()
QueryExpressionDSL.UnionBuilder	unionAll()
QueryExpressionDSL.QueryExpressionWhereBuilder	where()
<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

Constructor Detail

JoinSpecificationFinisher

public JoinSpecificationFinisher(SqlTable table,
                                 BasicColumn joinColumn,
                                 JoinCondition joinCondition,
                                 JoinType joinType)

JoinSpecificationFinisher

public JoinSpecificationFinisher(SqlTable table,
                                 BasicColumn joinColumn,
                                 JoinCondition joinCondition,
                                 JoinType joinType,
                                 JoinCriterion... andJoinCriteria)

Method Detail

build

public R build()

Specified by:

build in interface Buildable<R>

where

public QueryExpressionDSL.QueryExpressionWhereBuilder where()

where

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

and

public QueryExpressionDSL.JoinSpecificationFinisher and(BasicColumn joinColumn,
                                                        JoinCondition joinCondition)

join

public QueryExpressionDSL.JoinSpecificationStarter join(SqlTable joinTable)

join

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

leftJoin

public QueryExpressionDSL.JoinSpecificationStarter leftJoin(SqlTable joinTable)

leftJoin

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

rightJoin

public QueryExpressionDSL.JoinSpecificationStarter rightJoin(SqlTable joinTable)

rightJoin

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

fullJoin

public QueryExpressionDSL.JoinSpecificationStarter fullJoin(SqlTable joinTable)

fullJoin

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

groupBy

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

union

public QueryExpressionDSL.UnionBuilder union()

unionAll

public QueryExpressionDSL.UnionBuilder unionAll()

orderBy

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

limit

public SelectDSL.LimitFinisher limit(long limit)

offset

public SelectDSL.OffsetFirstFinisher offset(long offset)

fetchFirst

public SelectDSL.FetchFirstFinisher fetchFirst(long fetchFirstRows)