com.sh.wf.module.helper

类 SQLBatchMoreBuilder

java.lang.Object

com.sh.wf.module.helper.SQLBatchMoreBuilder

public class SQLBatchMoreBuilder
extends java.lang.Object

Description: 多表批量操作

Title:首亨软件 - 聚天平台

版本:

4.0 注意：同一张表批量操作时，不管是insert还是update，条件列或更新列一定要一致 如：有添加有修改，则主键列一定要加入到whereCol中，否则就与insert时的列不一致了

作者:

江兴春

构造器概要

构造器

构造器和说明
SQLBatchMoreBuilder(DataCenter dc)

方法概要

限定符和类型	方法和说明
SQLBatchMoreBuilder	addBigIntCol(java.lang.String tableName, java.lang.String colName, java.lang.Object obj)
SQLBatchMoreBuilder	addCol(java.lang.String tableName, java.lang.String colName, java.lang.String colType, java.lang.Object obj)
SQLBatchMoreBuilder	addDoubleCol(java.lang.String tableName, java.lang.String colName, java.lang.Object obj)
SQLBatchMoreBuilder	addIntegerCol(java.lang.String tableName, java.lang.String colName, java.lang.Object obj)
SQLBatchMoreBuilder	addObjectCol(java.lang.String tableName, java.lang.String colName, java.lang.Object value)
SQLBatchMoreBuilder	addStringCol(java.lang.String tableName, java.lang.String colName, java.lang.Object obj)
SQLBatchMoreBuilder	addSystemTime(java.lang.String tableName, java.lang.String colName)
SQLBatchMoreBuilder	addTextCol(java.lang.String tableName, java.lang.String colName, java.lang.Object obj)
SQLBatchMoreBuilder	addTimestampCol(java.lang.String tableName, java.lang.String colName, java.util.Date date)
SQLBatchMoreBuilder	addTimestampCol(java.lang.String tableName, java.lang.String colName, java.time.LocalDateTime localDateTime)
SQLBatchMoreBuilder	addTimestampCol(java.lang.String tableName, java.lang.String colName, java.lang.String time, java.lang.String format)
SQLBatchMoreBuilder	addTimestampCol(java.lang.String tableName, java.lang.String colName, java.sql.Timestamp timestamp)
SQLBatchMoreBuilder	addWhereBigIntCol_in(java.lang.String tableName, java.lang.String colName, java.lang.String obj)
SQLBatchMoreBuilder	addWhereBigIntCol(java.lang.String tableName, java.lang.String colName, java.lang.Object obj)
SQLBatchMoreBuilder	addWhereCol_in(java.lang.String tableName, java.lang.String colName, java.lang.String colType, java.lang.String obj)
SQLBatchMoreBuilder	addWhereCol(java.lang.String tableName, java.lang.String colName, java.lang.String colType, java.lang.Object obj)
SQLBatchMoreBuilder	addWhereDoubleCol(java.lang.String tableName, java.lang.String colName, java.lang.Object obj)
SQLBatchMoreBuilder	addWhereIntegerCol_in(java.lang.String tableName, java.lang.String colName, java.lang.String obj)
SQLBatchMoreBuilder	addWhereIntegerCol(java.lang.String tableName, java.lang.String colName, java.lang.Object obj)
SQLBatchMoreBuilder	addWhereStringCol_in(java.lang.String tableName, java.lang.String colName, java.lang.String obj)
SQLBatchMoreBuilder	addWhereStringCol(java.lang.String tableName, java.lang.String colName, java.lang.Object obj)
SQLBatchMoreBuilder	addWhereTextCol(java.lang.String tableName, java.lang.String colName, java.lang.Object obj)
SQLBatchMoreBuilder	asInsert()
SQLBatchMoreBuilder	asInsert(java.lang.String tableName)
SQLBatchMoreBuilder	asInsertIgnore()
SQLBatchMoreBuilder	asInsertIgnore(java.lang.String tableName)
SQLBatchMoreBuilder	asInsertOrUpdate()
SQLBatchMoreBuilder	asInsertOrUpdate(java.lang.String tableName)
SQLBatchMoreBuilder	asUpdate()
SQLBatchMoreBuilder	asUpdate(java.lang.String tableName)
java.lang.String[]	endBatch(boolean commit)
java.lang.String[]	endBatchRow()
java.lang.String[]	endBatchRow(java.lang.String tableName)
java.util.Map<java.lang.String,SQLBatchBuilder>	getBuilderMap()
SQLBatchBuilder	getSQLBatchBuilder(java.lang.String tableName)
SQLBatchMoreBuilder	onlyInsert()
SQLBatchMoreBuilder	onlyInsert(java.lang.String tableName)
SQLBatchMoreBuilder	onlyUpdate()
SQLBatchMoreBuilder	onlyUpdate(java.lang.String tableName)
SQLBatchMoreBuilder	refreshEveryCount(int refreshCount)
SQLBatchMoreBuilder	refreshEveryCount(java.lang.String tableName, int refreshCount)
SQLBatchMoreBuilder	reset()
SQLBatchMoreBuilder	setTableName(java.lang.String... tableNames)
SQLBatchMoreBuilder	setTableNameAlias(java.lang.String tableName, java.lang.String alias) 设置表名
SQLBatchMoreBuilder	startBatchRow()
SQLBatchMoreBuilder	startBatchRow(java.lang.String tableName)

从类继承的方法 java.lang.Object

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

构造器详细资料

SQLBatchMoreBuilder

public SQLBatchMoreBuilder(DataCenter dc)

方法详细资料

setTableName

public SQLBatchMoreBuilder setTableName(java.lang.String... tableNames)

setTableNameAlias

public SQLBatchMoreBuilder setTableNameAlias(java.lang.String tableName,
                                             java.lang.String alias)

设置表名

参数:

tableName - 表名

alias - 别名

返回:

getBuilderMap

public java.util.Map<java.lang.String,SQLBatchBuilder> getBuilderMap()

getSQLBatchBuilder

public SQLBatchBuilder getSQLBatchBuilder(java.lang.String tableName)

reset

public SQLBatchMoreBuilder reset()

asInsert

public SQLBatchMoreBuilder asInsert()

asInsert

public SQLBatchMoreBuilder asInsert(java.lang.String tableName)

asInsertIgnore

public SQLBatchMoreBuilder asInsertIgnore()

asInsertIgnore

public SQLBatchMoreBuilder asInsertIgnore(java.lang.String tableName)

asUpdate

public SQLBatchMoreBuilder asUpdate()

asUpdate

public SQLBatchMoreBuilder asUpdate(java.lang.String tableName)

asInsertOrUpdate

public SQLBatchMoreBuilder asInsertOrUpdate()

asInsertOrUpdate

public SQLBatchMoreBuilder asInsertOrUpdate(java.lang.String tableName)

onlyInsert

public SQLBatchMoreBuilder onlyInsert()

onlyInsert

public SQLBatchMoreBuilder onlyInsert(java.lang.String tableName)

onlyUpdate

public SQLBatchMoreBuilder onlyUpdate()

onlyUpdate

public SQLBatchMoreBuilder onlyUpdate(java.lang.String tableName)

refreshEveryCount

public SQLBatchMoreBuilder refreshEveryCount(int refreshCount)

refreshEveryCount

public SQLBatchMoreBuilder refreshEveryCount(java.lang.String tableName,
                                             int refreshCount)

startBatchRow

public SQLBatchMoreBuilder startBatchRow()

startBatchRow

public SQLBatchMoreBuilder startBatchRow(java.lang.String tableName)

endBatchRow

public java.lang.String[] endBatchRow()

endBatchRow

public java.lang.String[] endBatchRow(java.lang.String tableName)

endBatch

public java.lang.String[] endBatch(boolean commit)

addWhereCol

public SQLBatchMoreBuilder addWhereCol(java.lang.String tableName,
                                       java.lang.String colName,
                                       java.lang.String colType,
                                       java.lang.Object obj)

addWhereCol_in

public SQLBatchMoreBuilder addWhereCol_in(java.lang.String tableName,
                                          java.lang.String colName,
                                          java.lang.String colType,
                                          java.lang.String obj)

addWhereStringCol

public SQLBatchMoreBuilder addWhereStringCol(java.lang.String tableName,
                                             java.lang.String colName,
                                             java.lang.Object obj)

addWhereStringCol_in

public SQLBatchMoreBuilder addWhereStringCol_in(java.lang.String tableName,
                                                java.lang.String colName,
                                                java.lang.String obj)

addWhereTextCol

public SQLBatchMoreBuilder addWhereTextCol(java.lang.String tableName,
                                           java.lang.String colName,
                                           java.lang.Object obj)

addWhereIntegerCol

public SQLBatchMoreBuilder addWhereIntegerCol(java.lang.String tableName,
                                              java.lang.String colName,
                                              java.lang.Object obj)

addWhereIntegerCol_in

public SQLBatchMoreBuilder addWhereIntegerCol_in(java.lang.String tableName,
                                                 java.lang.String colName,
                                                 java.lang.String obj)

addWhereBigIntCol

public SQLBatchMoreBuilder addWhereBigIntCol(java.lang.String tableName,
                                             java.lang.String colName,
                                             java.lang.Object obj)

addWhereBigIntCol_in

public SQLBatchMoreBuilder addWhereBigIntCol_in(java.lang.String tableName,
                                                java.lang.String colName,
                                                java.lang.String obj)

addWhereDoubleCol

public SQLBatchMoreBuilder addWhereDoubleCol(java.lang.String tableName,
                                             java.lang.String colName,
                                             java.lang.Object obj)

addCol

public SQLBatchMoreBuilder addCol(java.lang.String tableName,
                                  java.lang.String colName,
                                  java.lang.String colType,
                                  java.lang.Object obj)

addStringCol

public SQLBatchMoreBuilder addStringCol(java.lang.String tableName,
                                        java.lang.String colName,
                                        java.lang.Object obj)

addTextCol

public SQLBatchMoreBuilder addTextCol(java.lang.String tableName,
                                      java.lang.String colName,
                                      java.lang.Object obj)

addIntegerCol

public SQLBatchMoreBuilder addIntegerCol(java.lang.String tableName,
                                         java.lang.String colName,
                                         java.lang.Object obj)

addBigIntCol

public SQLBatchMoreBuilder addBigIntCol(java.lang.String tableName,
                                        java.lang.String colName,
                                        java.lang.Object obj)

addDoubleCol

public SQLBatchMoreBuilder addDoubleCol(java.lang.String tableName,
                                        java.lang.String colName,
                                        java.lang.Object obj)

addTimestampCol

public SQLBatchMoreBuilder addTimestampCol(java.lang.String tableName,
                                           java.lang.String colName,
                                           java.lang.String time,
                                           java.lang.String format)

addTimestampCol

public SQLBatchMoreBuilder addTimestampCol(java.lang.String tableName,
                                           java.lang.String colName,
                                           java.sql.Timestamp timestamp)

addTimestampCol

public SQLBatchMoreBuilder addTimestampCol(java.lang.String tableName,
                                           java.lang.String colName,
                                           java.util.Date date)

addTimestampCol

public SQLBatchMoreBuilder addTimestampCol(java.lang.String tableName,
                                           java.lang.String colName,
                                           java.time.LocalDateTime localDateTime)

addObjectCol

public SQLBatchMoreBuilder addObjectCol(java.lang.String tableName,
                                        java.lang.String colName,
                                        java.lang.Object value)

addSystemTime

public SQLBatchMoreBuilder addSystemTime(java.lang.String tableName,
                                         java.lang.String colName)