tech.ibit.mybatis.sqlbuilder.sql.impl

Class InsertSqlImpl

java.lang.Object

tech.ibit.mybatis.sqlbuilder.sql.impl.SqlLogImpl

tech.ibit.mybatis.sqlbuilder.sql.impl.InsertSqlImpl

All Implemented Interfaces:

InsertSql, PrepareStatementBuildSupport, InsertTableSupport<InsertSql>, OnDuplicateKeyUpdateSupport<InsertSql>, PrepareStatementSupport, UseAliasSupport, ValuesSupport<InsertSql>

public class InsertSqlImpl
extends SqlLogImpl
implements InsertSql, UseAliasSupport, PrepareStatementBuildSupport

InsertSql实现

Version:

2.0

Author:

IBIT程序猿

Constructor Summary

Constructors

Constructor and Description
InsertSqlImpl(Mapper<?> mapper)

Method Summary

Modifier and Type	Method and Description
int	executeInsert() 插入
int	executeInsertWithGenerateKeys(KeyValuePair key) 插入
PrepareStatement	getPrepareStatement() 获取预查询SQL
InsertSql	insert(List<Table> tables) `INSERT INTO table1 t1, table2 t2...` 语句, t1, t2表示"表别名"
InsertSql	insert(Table table) `INSERT INTO table1 t1` 语句, t1表示"表别名"
InsertSql	insertDefault() 插入表，从mapper获取
boolean	isUseAlias() 是否使用别名
InsertSql	onDuplicateKeyUpdate(List<SetItem> items) 批量增加设置内容
InsertSql	onDuplicateKeyUpdate(SetItem item) 增加设置内容
InsertSql	values(Column column, Object value) `(column1) VALUES(?)`语句
InsertSql	values(ColumnValue columnValue) `(column1) VALUES(?)`语句
InsertSql	values(List<? extends ColumnValue> columnValues) `(column1, column2, ...) VALUES(?, ?, ...)`语句
InsertSql	values(List<Column> columns, List<Object> values) `(column1, column2, ...) VALUES(?, ?, ...)`语句

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

InsertSqlImpl

public InsertSqlImpl(Mapper<?> mapper)

Method Detail

insert

public InsertSql insert(Table table)

Description copied from interface: InsertTableSupport

`INSERT INTO table1 t1` 语句, t1表示"表别名"

Specified by:

insert in interface InsertTableSupport<InsertSql>

Parameters:

table - 表对象

Returns:

SQL对象

See Also:

Table

insert

public InsertSql insert(List<Table> tables)

Description copied from interface: InsertTableSupport

`INSERT INTO table1 t1, table2 t2...` 语句, t1, t2表示"表别名"

Specified by:

insert in interface InsertTableSupport<InsertSql>

Parameters:

tables - 表对象列表

Returns:

SQL对象

See Also:

Table

values

public InsertSql values(List<? extends ColumnValue> columnValues)

Description copied from interface: ValuesSupport

`(column1, column2, ...) VALUES(?, ?, ...)`语句

Specified by:

values in interface ValuesSupport<InsertSql>

Parameters:

columnValues - 列和值列表

Returns:

SQL对象

See Also:

ColumnValue

values

public InsertSql values(ColumnValue columnValue)

Description copied from interface: ValuesSupport

`(column1) VALUES(?)`语句

Specified by:

values in interface ValuesSupport<InsertSql>

Parameters:

columnValue - 列和值

Returns:

SQL对象

See Also:

ColumnValue

values

public InsertSql values(Column column,
                        Object value)

Description copied from interface: ValuesSupport

`(column1) VALUES(?)`语句

Specified by:

values in interface ValuesSupport<InsertSql>

Parameters:

column - 列

value - 值

Returns:

SQL对象

values

public InsertSql values(List<Column> columns,
                        List<Object> values)

Description copied from interface: ValuesSupport

`(column1, column2, ...) VALUES(?, ?, ...)`语句

Specified by:

values in interface ValuesSupport<InsertSql>

Parameters:

columns - 列列表

values - 值列表

Returns:

SQL对象

See Also:

ColumnValue

onDuplicateKeyUpdate

public InsertSql onDuplicateKeyUpdate(SetItem item)

Description copied from interface: OnDuplicateKeyUpdateSupport

增加设置内容

Specified by:

onDuplicateKeyUpdate in interface OnDuplicateKeyUpdateSupport<InsertSql>

Parameters:

item - 设置项

Returns:

SQL对象

onDuplicateKeyUpdate

public InsertSql onDuplicateKeyUpdate(List<SetItem> items)

Description copied from interface: OnDuplicateKeyUpdateSupport

批量增加设置内容

Specified by:

onDuplicateKeyUpdate in interface OnDuplicateKeyUpdateSupport<InsertSql>

Parameters:

items - 设置项

Returns:

SQL对象

isUseAlias

public boolean isUseAlias()

Description copied from interface: UseAliasSupport

是否使用别名

Specified by:

isUseAlias in interface UseAliasSupport

Returns:

是否使用别名

insertDefault

public InsertSql insertDefault()

Description copied from interface: InsertSql

插入表，从mapper获取

Specified by:

insertDefault in interface InsertSql

Returns:

SQL对象

getPrepareStatement

public PrepareStatement getPrepareStatement()

Description copied from interface: PrepareStatementSupport

获取预查询SQL

Specified by:

getPrepareStatement in interface PrepareStatementSupport

Returns:

预查询SQL

executeInsert

public int executeInsert()

Description copied from interface: InsertSql

插入

Specified by:

executeInsert in interface InsertSql

Returns:

插入条数

executeInsertWithGenerateKeys

public int executeInsertWithGenerateKeys(KeyValuePair key)

Description copied from interface: InsertSql

插入

Specified by:

executeInsertWithGenerateKeys in interface InsertSql

Parameters:

key - 生成主键接收对象

Returns:

插入条数