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

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

All Implemented Interfaces:

DeleteSql, DeleteSupport<DeleteSql>, FromSupport<DeleteSql>, PrepareStatementBuildSupport, JoinOnSupport<DeleteSql>, PrepareStatementSupport, UseAliasSupport, WhereSupport<DeleteSql>
```
public class DeleteSqlImpl
extends SqlLogImpl
implements DeleteSql, UseAliasSupport, PrepareStatementBuildSupport
```
DeleteSql实现

Version:

2.0

Author:

IBIT程序猿

Constructor Summary

Constructors
Constructor and Description

DeleteSqlImpl(Mapper<?> mapper)

Constructors
Constructor and Description
`DeleteSqlImpl(Mapper<?> mapper)`

Method Summary

All Methods Instance Methods Concrete Methods
Modifier and Type	Method and Description
`DeleteSql`	`andWhere(CriteriaItem item)` `WHERE AND` 语句
`DeleteSql`	`andWhere(List<Criteria> criterion)` `WHERE AND` 语句
`DeleteSql`	`complexFullJoinOn(Table table, List<CriteriaItem> criteriaItems)` `FULL JOIN table t1 on t1.column1=t0.column2, t1.column3=t0.column4 AND t1.column5=?`语句
`DeleteSql`	`complexInnerJoinOn(Table table, List<CriteriaItem> criteriaItems)` `INNER JOIN table t1 on t1.column1=t0.column2, t1.column3=t0.column4 AND t1.column5=?`语句
`DeleteSql`	`complexLeftJoinOn(Table table, List<CriteriaItem> criteriaItems)` `LEFT JOIN table t1 on t1.column1=t0.column2, t1.column3=t0.column4 AND t1.column5=?`语句
`DeleteSql`	`complexRightJoinOn(Table table, List<CriteriaItem> criteriaItems)` `RIGHT JOIN table t1 on t1.column1=t0.column2, t1.column3=t0.column4 AND t1.column5=?`语句
`DeleteSql`	`delete(List<Table> tables)` `DELETE t1., t2. ...` 语句, t1, t2表示"表别名"
`DeleteSql`	`delete(Table table)` `DELETE t1.*` 语句, t1表示"表别名"
`DeleteSql`	`deleteFrom(List<Table> tables)` 删除表，item和from同时设置
`DeleteSql`	`deleteFrom(Table table)` 删除表，item和from同时设置
`DeleteSql`	`deleteFromDefault()` 删除表，从mapper获取
`int`	`executeDelete()` 执行删除
`DeleteSql`	`from(List<Table> tables)` `FROM table1 t1, table2 t2...` 语句, t1, t2表示"表别名"
`DeleteSql`	`from(Table table)` `FROM table1 t1` 语句, t1表示"表别名"
`DeleteSql`	`fullJoinOn(Table table, List<Column> columnPairs)` `FULL JOIN table t1 ON t1.column1=t0.column2, t1.column3=t0.column4`语句
`PrepareStatement`	`getPrepareStatement()` 获取预查询SQL
`DeleteSql`	`innerJoinOn(Table table, List<Column> columnPairs)` `INNER JOIN table t1 ON t1.column1=t0.column2, t1.column3=t0.column4`语句
`boolean`	`isUseAlias()` 是否使用别名
`DeleteSql`	`joinOn(JoinOn joinOn)` JoinOn操作
`DeleteSql`	`joinOn(List<JoinOn> joinOns)` JoinOn操作
`DeleteSql`	`joinOn(Table table, List<Column> columnPairs)` `JOIN table t1 ON t1.column1=t0.column2, t1.column3=t0.column4`语句
`DeleteSql`	`leftJoinOn(Table table, List<Column> columnPairs)` `LEFT JOIN table t1 ON t1.column1=t0.column2, t1.column3=t0.column4`语句
`DeleteSql`	`orWhere(CriteriaItem item)` `WHERE OR`语句
`DeleteSql`	`orWhere(List<Criteria> criterion)` `WHERE OR`语句
`DeleteSql`	`rightJoinOn(Table table, List<Column> columnPairs)` `RIGHT JOIN table t1 ON t1.column1=t0.column2, t1.column3=t0.column4`语句
`DeleteSql`	`where(Criteria criteria)` `WHERE` 语句
`DeleteSql`	`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
  - DeleteSqlImpl
```
public DeleteSqlImpl(Mapper<?> mapper)
```
- Method Detail
  - delete
```
public DeleteSql delete(Table table)
```
    Description copied from interface: DeleteSupport
    
    `DELETE t1.*` 语句, t1表示"表别名"
    
    Specified by:
    
    delete in interface DeleteSupport<DeleteSql>
    
    Parameters:
    
    table - 表对象
    
    Returns:
    
    SQL对象
    
    See Also:
    
    Table
  - delete
```
public DeleteSql delete(List<Table> tables)
```
    Description copied from interface: DeleteSupport
    
    `DELETE t1.*, t2.* ...` 语句, t1, t2表示"表别名"
    
    Specified by:
    
    delete in interface DeleteSupport<DeleteSql>
    
    Parameters:
    
    tables - 表对象列表
    
    Returns:
    
    SQL对象
    
    See Also:
    
    Table
  - from
```
public DeleteSql from(Table table)
```
    Description copied from interface: FromSupport
    
    `FROM table1 t1` 语句, t1表示"表别名"
    
    Specified by:
    
    from in interface FromSupport<DeleteSql>
    
    Parameters:
    
    table - 表对象
    
    Returns:
    
    SQL对象
    
    See Also:
    
    Table
  - from
```
public DeleteSql from(List<Table> tables)
```
    Description copied from interface: FromSupport
    
    `FROM table1 t1, table2 t2...` 语句, t1, t2表示"表别名"
    
    Specified by:
    
    from in interface FromSupport<DeleteSql>
    
    Parameters:
    
    tables - 表对象列表
    
    Returns:
    
    SQL对象
    
    See Also:
    
    Table
  - joinOn
```
public DeleteSql joinOn(JoinOn joinOn)
```
    Description copied from interface: JoinOnSupport
    
    JoinOn操作
    
    Specified by:
    
    joinOn in interface JoinOnSupport<DeleteSql>
    
    Parameters:
    
    joinOn - JoinOn操作
    
    Returns:
    
    SQL对象
  - joinOn
```
public DeleteSql joinOn(List<JoinOn> joinOns)
```
    Description copied from interface: JoinOnSupport
    
    JoinOn操作
    
    Specified by:
    
    joinOn in interface JoinOnSupport<DeleteSql>
    
    Parameters:
    
    joinOns - JoinOn操作列表
    
    Returns:
    
    SQL对象
  - joinOn
```
public DeleteSql 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<DeleteSql>
    
    Parameters:
    
    table - 需要join的表对象
    
    columnPairs - on相关的"列-对"
    
    Returns:
    
    SQL对象
    
    See Also:
    
    Column
  - leftJoinOn
```
public DeleteSql 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<DeleteSql>
    
    Parameters:
    
    table - 需要join的表对象
    
    columnPairs - DbColumn pairs
    
    Returns:
    
    SQL对象
    
    See Also:
    
    Column
  - rightJoinOn
```
public DeleteSql 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<DeleteSql>
    
    Parameters:
    
    table - 需要join的表对象
    
    columnPairs - DbColumn pairs
    
    Returns:
    
    SQL对象
    
    See Also:
    
    Column
  - fullJoinOn
```
public DeleteSql 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<DeleteSql>
    
    Parameters:
    
    table - 需要join的表对象
    
    columnPairs - DbColumn pairs
    
    Returns:
    
    SQL对象
    
    See Also:
    
    Column
  - innerJoinOn
```
public DeleteSql 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<DeleteSql>
    
    Parameters:
    
    table - 需要join的表对象
    
    columnPairs - DbColumn pairs
    
    Returns:
    
    SQL对象
    
    See Also:
    
    Column
  - complexLeftJoinOn
```
public DeleteSql 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<DeleteSql>
    
    Parameters:
    
    table - 需要join的表对象
    
    criteriaItems - 条件
    
    Returns:
    
    SQL对象
  - complexRightJoinOn
```
public DeleteSql 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<DeleteSql>
    
    Parameters:
    
    table - 需要join的表对象
    
    criteriaItems - 条件
    
    Returns:
    
    SQL对象
  - complexFullJoinOn
```
public DeleteSql 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<DeleteSql>
    
    Parameters:
    
    table - 需要join的表对象
    
    criteriaItems - 条件
    
    Returns:
    
    SQL对象
  - complexInnerJoinOn
```
public DeleteSql 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<DeleteSql>
    
    Parameters:
    
    table - 需要join的表对象
    
    criteriaItems - 条件
    
    Returns:
    
    SQL对象
  - where
```
public DeleteSql where(Criteria criteria)
```
    Description copied from interface: WhereSupport
    
    `WHERE` 语句
    
    Specified by:
    
    where in interface WhereSupport<DeleteSql>
    
    Parameters:
    
    criteria - WHERE相关条件
    
    Returns:
    
    SQL对象
    
    See Also:
    
    Criteria
  - where
```
public DeleteSql where(List<Criteria> criterion)
```
    Description copied from interface: WhereSupport
    
    `WHERE` 语句
    
    Specified by:
    
    where in interface WhereSupport<DeleteSql>
    
    Parameters:
    
    criterion - WHERE相关条件列表
    
    Returns:
    
    SQL对象
    
    See Also:
    
    Criteria
  - andWhere
```
public DeleteSql andWhere(CriteriaItem item)
```
    Description copied from interface: WhereSupport
    
    `WHERE AND` 语句
    
    Specified by:
    
    andWhere in interface WhereSupport<DeleteSql>
    
    Parameters:
    
    item - WHERE相关条件
    
    Returns:
    
    SQL对象
    
    See Also:
    
    Criteria
  - andWhere
```
public DeleteSql andWhere(List<Criteria> criterion)
```
    Description copied from interface: WhereSupport
    
    `WHERE AND` 语句
    
    Specified by:
    
    andWhere in interface WhereSupport<DeleteSql>
    
    Parameters:
    
    criterion - WHERE相关条件列表
    
    Returns:
    
    SQL对象
    
    See Also:
    
    Criteria
  - orWhere
```
public DeleteSql orWhere(CriteriaItem item)
```
    Description copied from interface: WhereSupport
    
    `WHERE OR`语句
    
    Specified by:
    
    orWhere in interface WhereSupport<DeleteSql>
    
    Parameters:
    
    item - WHERE相关条件
    
    Returns:
    
    SQL对象
    
    See Also:
    
    Criteria
  - orWhere
```
public DeleteSql orWhere(List<Criteria> criterion)
```
    Description copied from interface: WhereSupport
    
    `WHERE OR`语句
    
    Specified by:
    
    orWhere in interface WhereSupport<DeleteSql>
    
    Parameters:
    
    criterion - WHERE相关条件列表
    
    Returns:
    
    SQL对象
    
    See Also:
    
    Criteria
  - isUseAlias
```
public boolean isUseAlias()
```
    Description copied from interface: UseAliasSupport
    
    是否使用别名
    
    Specified by:
    
    isUseAlias in interface UseAliasSupport
    
    Returns:
    
    是否使用别名
  - getPrepareStatement
```
public PrepareStatement getPrepareStatement()
```
    Description copied from interface: PrepareStatementSupport
    
    获取预查询SQL
    
    Specified by:
    
    getPrepareStatement in interface PrepareStatementSupport
    
    Returns:
    
    预查询SQL
  - executeDelete
```
public int executeDelete()
```
    Description copied from interface: DeleteSql
    
    执行删除
    
    Specified by:
    
    executeDelete in interface DeleteSql
    
    Returns:
    
    删除条数
  - deleteFromDefault
```
public DeleteSql deleteFromDefault()
```
    Description copied from interface: DeleteSql
    
    删除表，从mapper获取
    
    Specified by:
    
    deleteFromDefault in interface DeleteSql
    
    Returns:
    
    SQL对象
  - deleteFrom
```
public DeleteSql deleteFrom(Table table)
```
    Description copied from interface: DeleteSql
    
    删除表，item和from同时设置
    
    Specified by:
    
    deleteFrom in interface DeleteSql
    
    Parameters:
    
    table - 表
    
    Returns:
    
    SQL对象
  - deleteFrom
```
public DeleteSql deleteFrom(List<Table> tables)
```
    Description copied from interface: DeleteSql
    
    删除表，item和from同时设置
    
    Specified by:
    
    deleteFrom in interface DeleteSql
    
    Parameters:
    
    tables - 表列表
    
    Returns:
    
    SQL对象

Class DeleteSqlImpl

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

DeleteSqlImpl

Method Detail

delete

delete

from

from

joinOn

joinOn

joinOn

leftJoinOn

rightJoinOn

fullJoinOn

innerJoinOn

complexLeftJoinOn

complexRightJoinOn

complexFullJoinOn

complexInnerJoinOn

where

where

andWhere

andWhere

orWhere

orWhere

isUseAlias

getPrepareStatement

executeDelete

deleteFromDefault

deleteFrom

deleteFrom