org.mybatis.dynamic.sql.select

Class CountDSL<R>

java.lang.Object

org.mybatis.dynamic.sql.select.AbstractQueryExpressionDSL<CountDSL<R>,R>

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

Type Parameters:

R - the type of model built by this Builder. Typically SelectModel.

All Implemented Interfaces:

Buildable<R>

public class CountDSL<R>
extends AbstractQueryExpressionDSL<CountDSL<R>,R>
implements Buildable<R>

DSL for building count queries. Count queries are specializations of select queries. They have joins and where clauses, but not the other parts of a select (group by, order by, etc.) Count queries always return a long. If these restrictions are not acceptable, then use the Select DSL for an unrestricted select statement.

Author:

Jeff Butler

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
class	CountDSL.CountWhereBuilder

Field Summary

Fields inherited from class org.mybatis.dynamic.sql.select.AbstractQueryExpressionDSL

tableAliases

Method Summary

Modifier and Type	Method and Description
R	build()
static <R> CountDSL<R>	countFrom(Function<SelectModel,R> adapterFunction, SqlTable table)
static CountDSL<SelectModel>	countFrom(SqlTable table)
protected CountDSL<R>	getThis()
CountDSL.CountWhereBuilder	where()
<T> CountDSL.CountWhereBuilder	where(BindableColumn<T> column, VisitableCondition<T> condition, SqlCriterion<?>... subCriteria)

Methods inherited from class org.mybatis.dynamic.sql.select.AbstractQueryExpressionDSL

addJoinSpecificationBuilder, buildJoinModel, fullJoin, fullJoin, fullJoin, fullJoin, join, join, join, join, leftJoin, leftJoin, leftJoin, leftJoin, rightJoin, rightJoin, rightJoin, rightJoin, table

Methods inherited from class java.lang.Object

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

Method Detail

where

public CountDSL.CountWhereBuilder where()

where

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

build

public R build()

Specified by:

build in interface Buildable<R>

countFrom

public static CountDSL<SelectModel> countFrom(SqlTable table)

countFrom

public static <R> CountDSL<R> countFrom(Function<SelectModel,R> adapterFunction,
                                        SqlTable table)

getThis

protected CountDSL<R> getThis()

Specified by:

getThis in class AbstractQueryExpressionDSL<CountDSL<R>,R>