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

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

All Implemented Interfaces:

PrepareStatementBuildSupport, JoinOnSupport<UpdateSql>, PrepareStatementSupport, SetSupport<UpdateSql>, UpdateTableSupport<UpdateSql>, UseAliasSupport, WhereSupport<UpdateSql>, UpdateSql
```
public class UpdateSqlImpl
extends SqlLogImpl
implements UpdateSql, UseAliasSupport, PrepareStatementBuildSupport
```
UpdateSql实现

Version:

2.0

Author:

IBIT程序猿

Constructor Summary

Constructors
Constructor and Description

UpdateSqlImpl(Mapper<?> mapper)

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

Method Summary

All Methods Instance Methods Concrete Methods
Modifier and Type	Method and Description
`UpdateSql`	`andWhere(CriteriaItem item)` `WHERE AND` 语句
`UpdateSql`	`andWhere(List<Criteria> criterion)` `WHERE AND` 语句
`UpdateSql`	`complexFullJoinOn(Table table, List<CriteriaItem> criteriaItems)` `FULL JOIN table t1 on t1.column1=t0.column2, t1.column3=t0.column4 AND t1.column5=?`语句
`UpdateSql`	`complexInnerJoinOn(Table table, List<CriteriaItem> criteriaItems)` `INNER JOIN table t1 on t1.column1=t0.column2, t1.column3=t0.column4 AND t1.column5=?`语句
`UpdateSql`	`complexLeftJoinOn(Table table, List<CriteriaItem> criteriaItems)` `LEFT JOIN table t1 on t1.column1=t0.column2, t1.column3=t0.column4 AND t1.column5=?`语句
`UpdateSql`	`complexRightJoinOn(Table table, List<CriteriaItem> criteriaItems)` `RIGHT JOIN table t1 on t1.column1=t0.column2, t1.column3=t0.column4 AND t1.column5=?`语句
`UpdateSql`	`decreaseSet(Column column, Number value)` 设置自减
`int`	`executeUpdate()` 执行更新
`UpdateSql`	`fullJoinOn(Table table, List<Column> columnPairs)` `FULL JOIN table t1 ON t1.column1=t0.column2, t1.column3=t0.column4`语句
`PrepareStatement`	`getPrepareStatement()` 获取预查询SQL
`UpdateSql`	`increaseSet(Column column, Number value)` 设置自增长
`UpdateSql`	`innerJoinOn(Table table, List<Column> columnPairs)` `INNER JOIN table t1 ON t1.column1=t0.column2, t1.column3=t0.column4`语句
`boolean`	`isUseAlias()` 是否使用别名
`UpdateSql`	`joinOn(JoinOn joinOn)` JoinOn操作
`UpdateSql`	`joinOn(List<JoinOn> joinOns)` JoinOn操作
`UpdateSql`	`joinOn(Table table, List<Column> columnPairs)` `JOIN table t1 ON t1.column1=t0.column2, t1.column3=t0.column4`语句
`UpdateSql`	`leftJoinOn(Table table, List<Column> columnPairs)` `LEFT JOIN table t1 ON t1.column1=t0.column2, t1.column3=t0.column4`语句
`UpdateSql`	`orWhere(CriteriaItem item)` `WHERE OR`语句
`UpdateSql`	`orWhere(List<Criteria> criterion)` `WHERE OR`语句
`UpdateSql`	`rightJoinOn(Table table, List<Column> columnPairs)` `RIGHT JOIN table t1 ON t1.column1=t0.column2, t1.column3=t0.column4`语句
`UpdateSql`	`set(Column column, Object value)` 设置具体值
`UpdateSql`	`set(List<SetItem> items)` 批量增加设置内容
`UpdateSql`	`set(SetItem item)` 增加设置内容
`UpdateSql`	`update(List<Table> tables)` `UPDATE table1 t1, table2 t2...` 语句, t1, t2表示"表别名"
`UpdateSql`	`update(Table table)` `UPDATE table1 t1` 语句, t1表示"表别名"
`UpdateSql`	`updateDefault()` `UPDATE table1 t1` 语句, t1表示"表别名"
`UpdateSql`	`where(Criteria criteria)` `WHERE` 语句
`UpdateSql`	`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
  - UpdateSqlImpl
```
public UpdateSqlImpl(Mapper<?> mapper)
```
- Method Detail
  - isUseAlias
```
public boolean isUseAlias()
```
    Description copied from interface: UseAliasSupport
    
    是否使用别名
    
    Specified by:
    
    isUseAlias in interface UseAliasSupport
    
    Returns:
    
    是否使用别名
  - update
```
public UpdateSql update(Table table)
```
    Description copied from interface: UpdateTableSupport
    
    `UPDATE table1 t1` 语句, t1表示"表别名"
    
    Specified by:
    
    update in interface UpdateTableSupport<UpdateSql>
    
    Parameters:
    
    table - 表对象
    
    Returns:
    
    SQL对象
    
    See Also:
    
    Table
  - update
```
public UpdateSql update(List<Table> tables)
```
    Description copied from interface: UpdateTableSupport
    
    `UPDATE table1 t1, table2 t2...` 语句, t1, t2表示"表别名"
    
    Specified by:
    
    update in interface UpdateTableSupport<UpdateSql>
    
    Parameters:
    
    tables - 表对象列表
    
    Returns:
    
    SQL对象
    
    See Also:
    
    Table
  - set
```
public UpdateSql set(SetItem item)
```
    Description copied from interface: SetSupport
    
    增加设置内容
    
    Specified by:
    
    set in interface SetSupport<UpdateSql>
    
    Parameters:
    
    item - 设置项
    
    Returns:
    
    SQL对象
  - set
```
public UpdateSql set(List<SetItem> items)
```
    Description copied from interface: SetSupport
    
    批量增加设置内容
    
    Specified by:
    
    set in interface SetSupport<UpdateSql>
    
    Parameters:
    
    items - 设置项
    
    Returns:
    
    SQL对象
  - set
```
public UpdateSql set(Column column,
                     Object value)
```
    Description copied from interface: SetSupport
    
    设置具体值
    
    Specified by:
    
    set in interface SetSupport<UpdateSql>
    
    Parameters:
    
    column - 列
    
    value - 值
    
    Returns:
    
    设置item
  - increaseSet
```
public UpdateSql increaseSet(Column column,
                             Number value)
```
    Description copied from interface: SetSupport
    
    设置自增长
    
    Specified by:
    
    increaseSet in interface SetSupport<UpdateSql>
    
    Parameters:
    
    column - 列
    
    value - 值
    
    Returns:
    
    自增长item
  - decreaseSet
```
public UpdateSql decreaseSet(Column column,
                             Number value)
```
    Description copied from interface: SetSupport
    
    设置自减
    
    Specified by:
    
    decreaseSet in interface SetSupport<UpdateSql>
    
    Parameters:
    
    column - 列
    
    value - 值
    
    Returns:
    
    自减item
  - joinOn
```
public UpdateSql joinOn(JoinOn joinOn)
```
    Description copied from interface: JoinOnSupport
    
    JoinOn操作
    
    Specified by:
    
    joinOn in interface JoinOnSupport<UpdateSql>
    
    Parameters:
    
    joinOn - JoinOn操作
    
    Returns:
    
    SQL对象
  - joinOn
```
public UpdateSql joinOn(List<JoinOn> joinOns)
```
    Description copied from interface: JoinOnSupport
    
    JoinOn操作
    
    Specified by:
    
    joinOn in interface JoinOnSupport<UpdateSql>
    
    Parameters:
    
    joinOns - JoinOn操作列表
    
    Returns:
    
    SQL对象
  - joinOn
```
public UpdateSql 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<UpdateSql>
    
    Parameters:
    
    table - 需要join的表对象
    
    columnPairs - on相关的"列-对"
    
    Returns:
    
    SQL对象
    
    See Also:
    
    Column
  - leftJoinOn
```
public UpdateSql 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<UpdateSql>
    
    Parameters:
    
    table - 需要join的表对象
    
    columnPairs - DbColumn pairs
    
    Returns:
    
    SQL对象
    
    See Also:
    
    Column
  - rightJoinOn
```
public UpdateSql 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<UpdateSql>
    
    Parameters:
    
    table - 需要join的表对象
    
    columnPairs - DbColumn pairs
    
    Returns:
    
    SQL对象
    
    See Also:
    
    Column
  - fullJoinOn
```
public UpdateSql 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<UpdateSql>
    
    Parameters:
    
    table - 需要join的表对象
    
    columnPairs - DbColumn pairs
    
    Returns:
    
    SQL对象
    
    See Also:
    
    Column
  - innerJoinOn
```
public UpdateSql 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<UpdateSql>
    
    Parameters:
    
    table - 需要join的表对象
    
    columnPairs - DbColumn pairs
    
    Returns:
    
    SQL对象
    
    See Also:
    
    Column
  - complexLeftJoinOn
```
public UpdateSql 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<UpdateSql>
    
    Parameters:
    
    table - 需要join的表对象
    
    criteriaItems - 条件
    
    Returns:
    
    SQL对象
  - complexRightJoinOn
```
public UpdateSql 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<UpdateSql>
    
    Parameters:
    
    table - 需要join的表对象
    
    criteriaItems - 条件
    
    Returns:
    
    SQL对象
  - complexFullJoinOn
```
public UpdateSql 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<UpdateSql>
    
    Parameters:
    
    table - 需要join的表对象
    
    criteriaItems - 条件
    
    Returns:
    
    SQL对象
  - complexInnerJoinOn
```
public UpdateSql 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<UpdateSql>
    
    Parameters:
    
    table - 需要join的表对象
    
    criteriaItems - 条件
    
    Returns:
    
    SQL对象
  - where
```
public UpdateSql where(Criteria criteria)
```
    Description copied from interface: WhereSupport
    
    `WHERE` 语句
    
    Specified by:
    
    where in interface WhereSupport<UpdateSql>
    
    Parameters:
    
    criteria - WHERE相关条件
    
    Returns:
    
    SQL对象
    
    See Also:
    
    Criteria
  - where
```
public UpdateSql where(List<Criteria> criterion)
```
    Description copied from interface: WhereSupport
    
    `WHERE` 语句
    
    Specified by:
    
    where in interface WhereSupport<UpdateSql>
    
    Parameters:
    
    criterion - WHERE相关条件列表
    
    Returns:
    
    SQL对象
    
    See Also:
    
    Criteria
  - andWhere
```
public UpdateSql andWhere(CriteriaItem item)
```
    Description copied from interface: WhereSupport
    
    `WHERE AND` 语句
    
    Specified by:
    
    andWhere in interface WhereSupport<UpdateSql>
    
    Parameters:
    
    item - WHERE相关条件
    
    Returns:
    
    SQL对象
    
    See Also:
    
    Criteria
  - andWhere
```
public UpdateSql andWhere(List<Criteria> criterion)
```
    Description copied from interface: WhereSupport
    
    `WHERE AND` 语句
    
    Specified by:
    
    andWhere in interface WhereSupport<UpdateSql>
    
    Parameters:
    
    criterion - WHERE相关条件列表
    
    Returns:
    
    SQL对象
    
    See Also:
    
    Criteria
  - orWhere
```
public UpdateSql orWhere(CriteriaItem item)
```
    Description copied from interface: WhereSupport
    
    `WHERE OR`语句
    
    Specified by:
    
    orWhere in interface WhereSupport<UpdateSql>
    
    Parameters:
    
    item - WHERE相关条件
    
    Returns:
    
    SQL对象
    
    See Also:
    
    Criteria
  - orWhere
```
public UpdateSql orWhere(List<Criteria> criterion)
```
    Description copied from interface: WhereSupport
    
    `WHERE OR`语句
    
    Specified by:
    
    orWhere in interface WhereSupport<UpdateSql>
    
    Parameters:
    
    criterion - WHERE相关条件列表
    
    Returns:
    
    SQL对象
    
    See Also:
    
    Criteria
  - updateDefault
```
public UpdateSql updateDefault()
```
    Description copied from interface: UpdateSql
    
    `UPDATE table1 t1` 语句, t1表示"表别名"
    
    Specified by:
    
    updateDefault in interface UpdateSql
    
    Returns:
    
    SQL对象
  - getPrepareStatement
```
public PrepareStatement getPrepareStatement()
```
    Description copied from interface: PrepareStatementSupport
    
    获取预查询SQL
    
    Specified by:
    
    getPrepareStatement in interface PrepareStatementSupport
    
    Returns:
    
    预查询SQL
  - executeUpdate
```
public int executeUpdate()
```
    Description copied from interface: UpdateSql
    
    执行更新
    
    Specified by:
    
    executeUpdate in interface UpdateSql
    
    Returns:
    
    更新条数

Class UpdateSqlImpl

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

UpdateSqlImpl

Method Detail

isUseAlias

update

update

set

set

set

increaseSet

decreaseSet

joinOn

joinOn

joinOn

leftJoinOn

rightJoinOn

fullJoinOn

innerJoinOn

complexLeftJoinOn

complexRightJoinOn

complexFullJoinOn

complexInnerJoinOn

where

where

andWhere

andWhere

orWhere

orWhere

updateDefault

getPrepareStatement

executeUpdate