程序包 com.sh.wf.module.helper

类 SQLBatchMoreBuilder

java.lang.Object

com.sh.wf.module.helper.SQLBatchMoreBuilder

public class SQLBatchMoreBuilder
extends Object

Description: 多表批量操作

Title:首亨软件 - 聚天平台

字段概要

字段

修饰符和类型	字段	说明
protected static org.apache.logging.log4j.Logger	log4j

构造器概要

构造器

构造器	说明
SQLBatchMoreBuilder(DataCenter dc)

方法概要

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

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

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

字段详细资料

log4j

protected static org.apache.logging.log4j.Logger log4j

构造器详细资料

SQLBatchMoreBuilder

public SQLBatchMoreBuilder(DataCenter dc)

方法详细资料

setTableName

public SQLBatchMoreBuilder setTableName(String... tableNames)

setTableNameAlias

public SQLBatchMoreBuilder setTableNameAlias(String tableName,
 String alias)

设置表名

参数:

tableName - 表名

alias - 别名

返回:

getBuilderMap

public Map<String,SQLBatchBuilder> getBuilderMap()

getSQLBatchBuilder

public SQLBatchBuilder getSQLBatchBuilder(String tableName)

reset

public SQLBatchMoreBuilder reset()

asInsert

public SQLBatchMoreBuilder asInsert()

asInsert

public SQLBatchMoreBuilder asInsert(String tableName)

asInsertIgnore

public SQLBatchMoreBuilder asInsertIgnore()

asInsertIgnore

public SQLBatchMoreBuilder asInsertIgnore(String tableName)

asUpdate

public SQLBatchMoreBuilder asUpdate()

asUpdate

public SQLBatchMoreBuilder asUpdate(String tableName)

asInsertOrUpdate

public SQLBatchMoreBuilder asInsertOrUpdate()

asInsertOrUpdate

public SQLBatchMoreBuilder asInsertOrUpdate(String tableName)

onlyInsert

public SQLBatchMoreBuilder onlyInsert()

onlyInsert

public SQLBatchMoreBuilder onlyInsert(String tableName)

onlyUpdate

public SQLBatchMoreBuilder onlyUpdate()

onlyUpdate

public SQLBatchMoreBuilder onlyUpdate(String tableName)

refreshEveryCount

public SQLBatchMoreBuilder refreshEveryCount(int refreshCount)

refreshEveryCount

public SQLBatchMoreBuilder refreshEveryCount(String tableName,
 int refreshCount)

startBatchRow

public SQLBatchMoreBuilder startBatchRow()

startBatchRow

public SQLBatchMoreBuilder startBatchRow(String tableName)

endBatchRow

public String[] endBatchRow()

endBatchRow

public String[] endBatchRow(String tableName)

endBatch

public String[] endBatch(boolean commit)

addWhereCol

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

addWhereCol_in

public SQLBatchMoreBuilder addWhereCol_in(String tableName,
 String colName,
 String colType,
 String obj)

addWhereStringCol

public SQLBatchMoreBuilder addWhereStringCol(String tableName,
 String colName,
 Object obj)

addWhereStringCol_in

public SQLBatchMoreBuilder addWhereStringCol_in(String tableName,
 String colName,
 String obj)

addWhereTextCol

public SQLBatchMoreBuilder addWhereTextCol(String tableName,
 String colName,
 Object obj)

addWhereIntegerCol

public SQLBatchMoreBuilder addWhereIntegerCol(String tableName,
 String colName,
 Object obj)

addWhereIntegerCol_in

public SQLBatchMoreBuilder addWhereIntegerCol_in(String tableName,
 String colName,
 String obj)

addWhereBigIntCol

public SQLBatchMoreBuilder addWhereBigIntCol(String tableName,
 String colName,
 Object obj)

addWhereBigIntCol_in

public SQLBatchMoreBuilder addWhereBigIntCol_in(String tableName,
 String colName,
 String obj)

addWhereDoubleCol

public SQLBatchMoreBuilder addWhereDoubleCol(String tableName,
 String colName,
 Object obj)

addCol

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

addStringCol

public SQLBatchMoreBuilder addStringCol(String tableName,
 String colName,
 Object obj)

addTextCol

public SQLBatchMoreBuilder addTextCol(String tableName,
 String colName,
 Object obj)

addIntegerCol

public SQLBatchMoreBuilder addIntegerCol(String tableName,
 String colName,
 Object obj)

addBigIntCol

public SQLBatchMoreBuilder addBigIntCol(String tableName,
 String colName,
 Object obj)

addDoubleCol

public SQLBatchMoreBuilder addDoubleCol(String tableName,
 String colName,
 Object obj)

addTimestampCol

public SQLBatchMoreBuilder addTimestampCol(String tableName,
 String colName,
 String time,
 String format)

addTimestampColZone

public SQLBatchMoreBuilder addTimestampColZone(String tableName,
 String colName,
 String time,
 String format)

addTimestampCol

public SQLBatchMoreBuilder addTimestampCol(String tableName,
 String colName,
 Timestamp timestamp)

addTimestampCol

public SQLBatchMoreBuilder addTimestampCol(String tableName,
 String colName,
 Date date)

addTimestampCol

public SQLBatchMoreBuilder addTimestampCol(String tableName,
 String colName,
 LocalDateTime localDateTime)

addObjectCol

public SQLBatchMoreBuilder addObjectCol(String tableName,
 String colName,
 Object value)

addSystemTime

public SQLBatchMoreBuilder addSystemTime(String tableName,
 String colName)