CountSqlImpl (ibit-mybatis-码云(gitee.com))

java.lang.Object
- tech.ibit.mybatis.sqlbuilder.sql.impl.SqlLogImpl
- - tech.ibit.mybatis.sqlbuilder.sql.impl.CountSqlImpl

All Implemented Interfaces:

CountSql, ColumnSupport<CountSql>, DistinctSupport<CountSql>, FromSupport<CountSql>, GroupBySupport<CountSql>, HavingSupport<CountSql>, PrepareStatementBuildSupport, JoinOnSupport<CountSql>, PrepareStatementSupport, UseAliasSupport, WhereSupport<CountSql>
```
public class CountSqlImpl
extends SqlLogImpl
implements CountSql, UseAliasSupport, PrepareStatementBuildSupport
```
CountSql实现

Version:

2.0

Author:

IBIT程序猿

Constructor Summary

Constructors
Constructor and Description

CountSqlImpl(Mapper<?> mapper)
构造函数

CountSqlImpl(Mapper<?> mapper, boolean needToInit)
构造函数

Constructors
Constructor and Description
`CountSqlImpl(Mapper<?> mapper)` 构造函数
`CountSqlImpl(Mapper<?> mapper, boolean needToInit)` 构造函数

Method Summary

All Methods Instance Methods Concrete Methods
Modifier and Type	Method and Description
`CountSql`	`andHaving(CriteriaItem havingItem)` `HAVING AND item`语句
`CountSql`	`andHaving(List<Criteria> havings)` `HAVING AND (havings)`语句
`CountSql`	`andWhere(CriteriaItem item)` `WHERE AND` 语句
`CountSql`	`andWhere(List<Criteria> criterion)` `WHERE AND` 语句
`CountSql`	`column(IColumn column)` `t.column`语句, "t": 为表的别名
`CountSql`	`column(List<? extends IColumn> columns)` `t.column1, t.column2, ...`语句, "t": 为表的别名
`CountSql`	`columnPo(Class<?> poClass)` 传入实体类
`CountSql`	`complexFullJoinOn(Table table, List<CriteriaItem> criteriaItems)` `FULL JOIN table t1 on t1.column1=t0.column2, t1.column3=t0.column4 AND t1.column5=?`语句
`CountSql`	`complexInnerJoinOn(Table table, List<CriteriaItem> criteriaItems)` `INNER JOIN table t1 on t1.column1=t0.column2, t1.column3=t0.column4 AND t1.column5=?`语句
`CountSql`	`complexLeftJoinOn(Table table, List<CriteriaItem> criteriaItems)` `LEFT JOIN table t1 on t1.column1=t0.column2, t1.column3=t0.column4 AND t1.column5=?`语句
`CountSql`	`complexRightJoinOn(Table table, List<CriteriaItem> criteriaItems)` `RIGHT JOIN table t1 on t1.column1=t0.column2, t1.column3=t0.column4 AND t1.column5=?`语句
`CountSql`	`distinct()` distinct 操作
`CountSql`	`distinct(boolean distinct)` distinct 操作
`int`	`executeCount()` 计数
`CountSql`	`from(List<Table> tables)` `FROM table1 t1, table2 t2...` 语句, t1, t2表示"表别名"
`CountSql`	`from(Table table)` `FROM table1 t1` 语句, t1表示"表别名"
`CountSql`	`fromDefault()` 计算默认的表
`CountSql`	`fullJoinOn(Table table, List<Column> columnPairs)` `FULL JOIN table t1 ON t1.column1=t0.column2, t1.column3=t0.column4`语句
`PrepareStatement`	`getPrepareStatement()` 获取预查询SQL
`CountSql`	`groupBy(Column groupBy)` `GROUP BY t1.column`语句
`CountSql`	`groupBy(List<Column> groupBys)` `GROUP BY t1.column1, t2.column2, ...`语句
`CountSql`	`having(Criteria having)` `HAVING`语句
`CountSql`	`having(List<Criteria> havings)` `HAVING`语句
`CountSql`	`innerJoinOn(Table table, List<Column> columnPairs)` `INNER JOIN table t1 ON t1.column1=t0.column2, t1.column3=t0.column4`语句
`boolean`	`isUseAlias()` 是否使用别名
`CountSql`	`joinOn(JoinOn joinOn)` JoinOn操作
`CountSql`	`joinOn(List<JoinOn> joinOns)` JoinOn操作
`CountSql`	`joinOn(Table table, List<Column> columnPairs)` `JOIN table t1 ON t1.column1=t0.column2, t1.column3=t0.column4`语句
`CountSql`	`leftJoinOn(Table table, List<Column> columnPairs)` `LEFT JOIN table t1 ON t1.column1=t0.column2, t1.column3=t0.column4`语句
`CountSql`	`orHaving(CriteriaItem havingItem)` `HAVING OR item`语句
`CountSql`	`orHaving(List<Criteria> havings)` `HAVING OR (havings)`语句（多个OR关系）
`CountSql`	`orWhere(CriteriaItem item)` `WHERE OR`语句
`CountSql`	`orWhere(List<Criteria> criterion)` `WHERE OR`语句
`CountSql`	`rightJoinOn(Table table, List<Column> columnPairs)` `RIGHT JOIN table t1 ON t1.column1=t0.column2, t1.column3=t0.column4`语句
`void`	`setColumnSupport(ColumnSupportImpl<CountSql> columnSupport)` Sets the columnSupport
`void`	`setDistinctSupport(DistinctSupportImpl<CountSql> distinctSupport)` Sets the distinctSupport
`void`	`setFromSupport(FromSupportImpl<CountSql> fromSupport)` Sets the fromSupport
`void`	`setGroupBySupport(GroupBySupportImpl<CountSql> groupBySupport)` Sets the groupBySupport
`void`	`setHavingSupport(HavingSupportImpl<CountSql> havingSupport)` Sets the havingSupport
`void`	`setJoinOnSupport(JoinOnSupportImpl<CountSql> joinOnSupport)` Sets the joinOnSupport
`void`	`setWhereSupport(WhereSupportImpl<CountSql> whereSupport)` Sets the whereSupport
`CountSql`	`where(Criteria criteria)` `WHERE` 语句
`CountSql`	`where(List<Criteria> criterion)` `WHERE` 语句

Methods inherited from class java.lang.Object
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Methods inherited from interface tech.ibit.mybatis.sqlbuilder.sql.support.impl.PrepareStatementBuildSupport
append, append, getPrepareStatement, getPrepareStatement, getPrepareStatement, getPrepareStatement

- Constructor Detail
  - CountSqlImpl
```
public CountSqlImpl(Mapper<?> mapper)
```
    构造函数
    
    Parameters:
    
    mapper - mapper
  - CountSqlImpl
```
public CountSqlImpl(Mapper<?> mapper,
                    boolean needToInit)
```
    构造函数
    
    Parameters:
    
    mapper - mapper
    
    needToInit - 是否初始化
- Method Detail
  - column
```
public CountSql column(List<? extends IColumn> columns)
```
    Description copied from interface: ColumnSupport
    
    `t.column1, t.column2, ...`语句, "t": 为表的别名
    
    Specified by:
    
    column in interface ColumnSupport<CountSql>
    
    Parameters:
    
    columns - 查询字段对象
    
    Returns:
    
    SQL对象
    
    See Also:
    
    IColumn
  - column
```
public CountSql column(IColumn column)
```
    Description copied from interface: ColumnSupport
    
    `t.column`语句, "t": 为表的别名
    
    Specified by:
    
    column in interface ColumnSupport<CountSql>
    
    Parameters:
    
    column - 查询字段对象
    
    Returns:
    
    SQL对象
    
    See Also:
    
    IColumn
  - columnPo
```
public CountSql columnPo(Class<?> poClass)
```
    Description copied from interface: ColumnSupport
    
    传入实体类
    
    Specified by:
    
    columnPo in interface ColumnSupport<CountSql>
    
    Parameters:
    
    poClass - 实体类
    
    Returns:
    
    SQL对象
  - from
```
public CountSql from(Table table)
```
    Description copied from interface: FromSupport
    
    `FROM table1 t1` 语句, t1表示"表别名"
    
    Specified by:
    
    from in interface FromSupport<CountSql>
    
    Parameters:
    
    table - 表对象
    
    Returns:
    
    SQL对象
    
    See Also:
    
    Table
  - from
```
public CountSql from(List<Table> tables)
```
    Description copied from interface: FromSupport
    
    `FROM table1 t1, table2 t2...` 语句, t1, t2表示"表别名"
    
    Specified by:
    
    from in interface FromSupport<CountSql>
    
    Parameters:
    
    tables - 表对象列表
    
    Returns:
    
    SQL对象
    
    See Also:
    
    Table
  - distinct
```
public CountSql distinct()
```
    Description copied from interface: DistinctSupport
    
    distinct 操作
    
    Specified by:
    
    distinct in interface DistinctSupport<CountSql>
    
    Returns:
    
    SQL对象
  - distinct
```
public CountSql distinct(boolean distinct)
```
    Description copied from interface: DistinctSupport
    
    distinct 操作
    
    Specified by:
    
    distinct in interface DistinctSupport<CountSql>
    
    Parameters:
    
    distinct - 是否distinct
    
    Returns:
    
    SQL对象
  - having
```
public CountSql having(Criteria having)
```
    Description copied from interface: HavingSupport
    
    `HAVING`语句
    
    Specified by:
    
    having in interface HavingSupport<CountSql>
    
    Parameters:
    
    having - having语句对象
    
    Returns:
    
    SQL对象
  - having
```
public CountSql having(List<Criteria> havings)
```
    Description copied from interface: HavingSupport
    
    `HAVING`语句
    
    Specified by:
    
    having in interface HavingSupport<CountSql>
    
    Parameters:
    
    havings - having语句对象列表
    
    Returns:
    
    SQL对象
  - andHaving
```
public CountSql andHaving(CriteriaItem havingItem)
```
    Description copied from interface: HavingSupport
    
    `HAVING AND item`语句
    
    Specified by:
    
    andHaving in interface HavingSupport<CountSql>
    
    Parameters:
    
    havingItem - having语句对象
    
    Returns:
    
    SQL对象
  - andHaving
```
public CountSql andHaving(List<Criteria> havings)
```
    Description copied from interface: HavingSupport
    
    `HAVING AND (havings)`语句
    
    Specified by:
    
    andHaving in interface HavingSupport<CountSql>
    
    Parameters:
    
    havings - having语句对象列表
    
    Returns:
    
    SQL对象
  - orHaving
```
public CountSql orHaving(CriteriaItem havingItem)
```
    Description copied from interface: HavingSupport
    
    `HAVING OR item`语句
    
    Specified by:
    
    orHaving in interface HavingSupport<CountSql>
    
    Parameters:
    
    havingItem - having语句对象
    
    Returns:
    
    SQL对象
  - orHaving
```
public CountSql orHaving(List<Criteria> havings)
```
    Description copied from interface: HavingSupport
    
    `HAVING OR (havings)`语句（多个OR关系）
    
    Specified by:
    
    orHaving in interface HavingSupport<CountSql>
    
    Parameters:
    
    havings - having语句对象列表
    
    Returns:
    
    SQL对象
  - joinOn
```
public CountSql joinOn(JoinOn joinOn)
```
    Description copied from interface: JoinOnSupport
    
    JoinOn操作
    
    Specified by:
    
    joinOn in interface JoinOnSupport<CountSql>
    
    Parameters:
    
    joinOn - JoinOn操作
    
    Returns:
    
    SQL对象
  - joinOn
```
public CountSql joinOn(List<JoinOn> joinOns)
```
    Description copied from interface: JoinOnSupport
    
    JoinOn操作
    
    Specified by:
    
    joinOn in interface JoinOnSupport<CountSql>
    
    Parameters:
    
    joinOns - JoinOn操作列表
    
    Returns:
    
    SQL对象
  - joinOn
```
public CountSql joinOn(Table table,
                       List<Column> columnPairs)
```
    Description copied from interface: JoinOnSupport
    
    `JOIN table t1 ON t1.column1=t0.column2, t1.column3=t0.column4`语句
    
    Specified by:
    
    joinOn in interface JoinOnSupport<CountSql>
    
    Parameters:
    
    table - 需要join的表对象
    
    columnPairs - on相关的"列-对"
    
    Returns:
    
    SQL对象
    
    See Also:
    
    Column
  - leftJoinOn
```
public CountSql leftJoinOn(Table table,
                           List<Column> columnPairs)
```
    Description copied from interface: JoinOnSupport
    
    `LEFT JOIN table t1 ON t1.column1=t0.column2, t1.column3=t0.column4`语句
    
    Specified by:
    
    leftJoinOn in interface JoinOnSupport<CountSql>
    
    Parameters:
    
    table - 需要join的表对象
    
    columnPairs - DbColumn pairs
    
    Returns:
    
    SQL对象
    
    See Also:
    
    Column
  - rightJoinOn
```
public CountSql rightJoinOn(Table table,
                            List<Column> columnPairs)
```
    Description copied from interface: JoinOnSupport
    
    `RIGHT JOIN table t1 ON t1.column1=t0.column2, t1.column3=t0.column4`语句
    
    Specified by:
    
    rightJoinOn in interface JoinOnSupport<CountSql>
    
    Parameters:
    
    table - 需要join的表对象
    
    columnPairs - DbColumn pairs
    
    Returns:
    
    SQL对象
    
    See Also:
    
    Column
  - fullJoinOn
```
public CountSql fullJoinOn(Table table,
                           List<Column> columnPairs)
```
    Description copied from interface: JoinOnSupport
    
    `FULL JOIN table t1 ON t1.column1=t0.column2, t1.column3=t0.column4`语句
    
    Specified by:
    
    fullJoinOn in interface JoinOnSupport<CountSql>
    
    Parameters:
    
    table - 需要join的表对象
    
    columnPairs - DbColumn pairs
    
    Returns:
    
    SQL对象
    
    See Also:
    
    Column
  - innerJoinOn
```
public CountSql innerJoinOn(Table table,
                            List<Column> columnPairs)
```
    Description copied from interface: JoinOnSupport
    
    `INNER JOIN table t1 ON t1.column1=t0.column2, t1.column3=t0.column4`语句
    
    Specified by:
    
    innerJoinOn in interface JoinOnSupport<CountSql>
    
    Parameters:
    
    table - 需要join的表对象
    
    columnPairs - DbColumn pairs
    
    Returns:
    
    SQL对象
    
    See Also:
    
    Column
  - complexLeftJoinOn
```
public CountSql complexLeftJoinOn(Table table,
                                  List<CriteriaItem> criteriaItems)
```
    Description copied from interface: JoinOnSupport
    
    `LEFT JOIN table t1 on t1.column1=t0.column2, t1.column3=t0.column4 AND t1.column5=?`语句
    
    Specified by:
    
    complexLeftJoinOn in interface JoinOnSupport<CountSql>
    
    Parameters:
    
    table - 需要join的表对象
    
    criteriaItems - 条件
    
    Returns:
    
    SQL对象
  - complexRightJoinOn
```
public CountSql complexRightJoinOn(Table table,
                                   List<CriteriaItem> criteriaItems)
```
    Description copied from interface: JoinOnSupport
    
    `RIGHT JOIN table t1 on t1.column1=t0.column2, t1.column3=t0.column4 AND t1.column5=?`语句
    
    Specified by:
    
    complexRightJoinOn in interface JoinOnSupport<CountSql>
    
    Parameters:
    
    table - 需要join的表对象
    
    criteriaItems - 条件
    
    Returns:
    
    SQL对象
  - complexFullJoinOn
```
public CountSql complexFullJoinOn(Table table,
                                  List<CriteriaItem> criteriaItems)
```
    Description copied from interface: JoinOnSupport
    
    `FULL JOIN table t1 on t1.column1=t0.column2, t1.column3=t0.column4 AND t1.column5=?`语句
    
    Specified by:
    
    complexFullJoinOn in interface JoinOnSupport<CountSql>
    
    Parameters:
    
    table - 需要join的表对象
    
    criteriaItems - 条件
    
    Returns:
    
    SQL对象
  - complexInnerJoinOn
```
public CountSql complexInnerJoinOn(Table table,
                                   List<CriteriaItem> criteriaItems)
```
    Description copied from interface: JoinOnSupport
    
    `INNER JOIN table t1 on t1.column1=t0.column2, t1.column3=t0.column4 AND t1.column5=?`语句
    
    Specified by:
    
    complexInnerJoinOn in interface JoinOnSupport<CountSql>
    
    Parameters:
    
    table - 需要join的表对象
    
    criteriaItems - 条件
    
    Returns:
    
    SQL对象
  - where
```
public CountSql where(Criteria criteria)
```
    Description copied from interface: WhereSupport
    
    `WHERE` 语句
    
    Specified by:
    
    where in interface WhereSupport<CountSql>
    
    Parameters:
    
    criteria - WHERE相关条件
    
    Returns:
    
    SQL对象
    
    See Also:
    
    Criteria
  - where
```
public CountSql where(List<Criteria> criterion)
```
    Description copied from interface: WhereSupport
    
    `WHERE` 语句
    
    Specified by:
    
    where in interface WhereSupport<CountSql>
    
    Parameters:
    
    criterion - WHERE相关条件列表
    
    Returns:
    
    SQL对象
    
    See Also:
    
    Criteria
  - andWhere
```
public CountSql andWhere(CriteriaItem item)
```
    Description copied from interface: WhereSupport
    
    `WHERE AND` 语句
    
    Specified by:
    
    andWhere in interface WhereSupport<CountSql>
    
    Parameters:
    
    item - WHERE相关条件
    
    Returns:
    
    SQL对象
    
    See Also:
    
    Criteria
  - andWhere
```
public CountSql andWhere(List<Criteria> criterion)
```
    Description copied from interface: WhereSupport
    
    `WHERE AND` 语句
    
    Specified by:
    
    andWhere in interface WhereSupport<CountSql>
    
    Parameters:
    
    criterion - WHERE相关条件列表
    
    Returns:
    
    SQL对象
    
    See Also:
    
    Criteria
  - orWhere
```
public CountSql orWhere(CriteriaItem item)
```
    Description copied from interface: WhereSupport
    
    `WHERE OR`语句
    
    Specified by:
    
    orWhere in interface WhereSupport<CountSql>
    
    Parameters:
    
    item - WHERE相关条件
    
    Returns:
    
    SQL对象
    
    See Also:
    
    Criteria
  - orWhere
```
public CountSql orWhere(List<Criteria> criterion)
```
    Description copied from interface: WhereSupport
    
    `WHERE OR`语句
    
    Specified by:
    
    orWhere in interface WhereSupport<CountSql>
    
    Parameters:
    
    criterion - WHERE相关条件列表
    
    Returns:
    
    SQL对象
    
    See Also:
    
    Criteria
  - groupBy
```
public CountSql groupBy(Column groupBy)
```
    Description copied from interface: GroupBySupport
    
    `GROUP BY t1.column`语句
    
    Specified by:
    
    groupBy in interface GroupBySupport<CountSql>
    
    Parameters:
    
    groupBy - 相关列a
    
    Returns:
    
    SQL对象
    
    See Also:
    
    IColumn
  - groupBy
```
public CountSql groupBy(List<Column> groupBys)
```
    Description copied from interface: GroupBySupport
    
    `GROUP BY t1.column1, t2.column2, ...`语句
    
    Specified by:
    
    groupBy in interface GroupBySupport<CountSql>
    
    Parameters:
    
    groupBys - 相关列列表
    
    Returns:
    
    SQL对象
    
    See Also:
    
    IColumn
  - isUseAlias
```
public boolean isUseAlias()
```
    Description copied from interface: UseAliasSupport
    
    是否使用别名
    
    Specified by:
    
    isUseAlias in interface UseAliasSupport
    
    Returns:
    
    是否使用别名
  - fromDefault
```
public CountSql fromDefault()
```
    Description copied from interface: CountSql
    
    计算默认的表
    
    Specified by:
    
    fromDefault in interface CountSql
    
    Returns:
    
    SQL对象本身
  - setDistinctSupport
```
public void setDistinctSupport(DistinctSupportImpl<CountSql> distinctSupport)
```
    Sets the distinctSupport
    You can use getDistinctSupport() to get the value of distinctSupport
    
    Parameters:
    
    distinctSupport - distinctSupport
  - setColumnSupport
```
public void setColumnSupport(ColumnSupportImpl<CountSql> columnSupport)
```
    Sets the columnSupport
    You can use getColumnSupport() to get the value of columnSupport
    
    Parameters:
    
    columnSupport - columnSupport
  - setFromSupport
```
public void setFromSupport(FromSupportImpl<CountSql> fromSupport)
```
    Sets the fromSupport
    You can use getFromSupport() to get the value of fromSupport
    
    Parameters:
    
    fromSupport - fromSupport
  - setJoinOnSupport
```
public void setJoinOnSupport(JoinOnSupportImpl<CountSql> joinOnSupport)
```
    Sets the joinOnSupport
    You can use getJoinOnSupport() to get the value of joinOnSupport
    
    Parameters:
    
    joinOnSupport - joinOnSupport
  - setWhereSupport
```
public void setWhereSupport(WhereSupportImpl<CountSql> whereSupport)
```
    Sets the whereSupport
    You can use getWhereSupport() to get the value of whereSupport
    
    Parameters:
    
    whereSupport - whereSupport
  - setGroupBySupport
```
public void setGroupBySupport(GroupBySupportImpl<CountSql> groupBySupport)
```
    Sets the groupBySupport
    You can use getGroupBySupport() to get the value of groupBySupport
    
    Parameters:
    
    groupBySupport - groupBySupport
  - setHavingSupport
```
public void setHavingSupport(HavingSupportImpl<CountSql> havingSupport)
```
    Sets the havingSupport
    You can use getHavingSupport() to get the value of havingSupport
    
    Parameters:
    
    havingSupport - havingSupport
  - getPrepareStatement
```
public PrepareStatement getPrepareStatement()
```
    Description copied from interface: PrepareStatementSupport
    
    获取预查询SQL
    
    Specified by:
    
    getPrepareStatement in interface PrepareStatementSupport
    
    Returns:
    
    预查询SQL
  - executeCount
```
public int executeCount()
```
    Description copied from interface: CountSql
    
    计数
    
    Specified by:
    
    executeCount in interface CountSql
    
    Returns:
    
    计算结果

Class CountSqlImpl

Constructor Summary

Method Summary

Methods inherited from class java.lang.Object

Methods inherited from interface tech.ibit.mybatis.sqlbuilder.sql.support.impl.PrepareStatementBuildSupport

Constructor Detail

CountSqlImpl

CountSqlImpl

Method Detail

column

column

columnPo

from

from

distinct

distinct

having

having

andHaving

andHaving

orHaving

orHaving

joinOn

joinOn

joinOn

leftJoinOn

rightJoinOn

fullJoinOn

innerJoinOn

complexLeftJoinOn

complexRightJoinOn

complexFullJoinOn

complexInnerJoinOn

where

where

andWhere

andWhere

orWhere

orWhere

groupBy

groupBy

isUseAlias

fromDefault

setDistinctSupport

setColumnSupport

setFromSupport

setJoinOnSupport

setWhereSupport

setGroupBySupport

setHavingSupport

getPrepareStatement

executeCount