Package org.mybatis.dynamic.sql.dsl

Class CountDSL

java.lang.Object

org.mybatis.dynamic.sql.dsl.AbstractQueryingDSL

org.mybatis.dynamic.sql.dsl.AbstractCountDSL<SelectModel,CountDSL>

org.mybatis.dynamic.sql.dsl.CountDSL

All Implemented Interfaces:

JoinOperations<AbstractCountDSL<SelectModel,CountDSL>.JoinSpecificationFinisher>, WhereOperations<AbstractCountDSL<SelectModel,CountDSL>.CountWhereBuilder>, Buildable<SelectModel>, ConfigurableStatement<CountDSL>

public class CountDSL
extends AbstractCountDSL<SelectModel,CountDSL>

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 value. If these restrictions are not acceptable, then use the Select DSL for an unrestricted select statement.

Author:

Jeff Butler

Nested Class Summary

Nested classes/interfaces inherited from class org.mybatis.dynamic.sql.dsl.AbstractCountDSL

AbstractCountDSL.CountWhereBuilder, AbstractCountDSL.JoinSpecificationFinisher

Nested classes/interfaces inherited from interface org.mybatis.dynamic.sql.dsl.JoinOperations

JoinOperations.JoinOnGatherer<F extends BooleanOperations<?>>

Method Summary

Modifier and Type	Method	Description
SelectModel	build()
static CountDSL	count(BasicColumn column)
static CountDSL	countDistinct(BasicColumn column)
static CountDSL	countFrom(SqlTable table)
static CountDSL	countFrom(SqlTable table, String tableAlias)
protected CountDSL	getThis()

Methods inherited from class org.mybatis.dynamic.sql.dsl.AbstractCountDSL

applyWhere, buildSelectModel, configureStatement, from, from, join, join, where, where

Methods inherited from class org.mybatis.dynamic.sql.dsl.AbstractQueryingDSL

addJoinSpecification, addTableAlias, buildJoinModel, setTable, setTable, setTable, setTable, table, tableAliases

Methods inherited from class java.lang.Object

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

Methods inherited from interface org.mybatis.dynamic.sql.dsl.JoinOperations

fullJoin, fullJoin, fullJoin, fullJoin, fullJoin, fullJoin, fullJoin, fullJoin, join, join, join, join, join, join, join, join, leftJoin, leftJoin, leftJoin, leftJoin, leftJoin, leftJoin, leftJoin, leftJoin, rightJoin, rightJoin, rightJoin, rightJoin, rightJoin, rightJoin, rightJoin, rightJoin

Methods inherited from interface org.mybatis.dynamic.sql.dsl.WhereOperations

where, where, where, where, where, where, where

Method Details

getThis

protected CountDSL getThis()

Specified by:

getThis in class AbstractCountDSL<SelectModel,CountDSL>

build

public SelectModel build()

countFrom

public static CountDSL countFrom(SqlTable table)

countFrom

public static CountDSL countFrom(SqlTable table,
 String tableAlias)

count

public static CountDSL count(BasicColumn column)

countDistinct

public static CountDSL countDistinct(BasicColumn column)