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

类 SqlUpdateBuilder

java.lang.Object

com.sh.wf.module.helper.SqlUpdateBuilder

public class SqlUpdateBuilder
extends Object

Description: 添加、修改SQL构造

Title:首亨软件 - TSS/CRM等

从以下版本开始:

2020年7月24日

嵌套类概要

嵌套类

修饰符和类型	类	说明
static class	SqlUpdateBuilder.SqlUpdateBuilderCol

字段概要

字段

修饰符和类型	字段	说明
protected static org.apache.logging.log4j.Logger	_log4j
static final int	DELETE
static final int	ERROR
static final int	EXISTS
static final int	INSERT
static final int	INSERT_IGNORE
static final int	INSERT_UPDATE
static final int	INSERT_UPDATE_DUPLICATE_KEY
static final int	NOT_EXISTS
static final int	REPLACE
static final int	UPDATE

构造器概要

构造器

构造器	说明
SqlUpdateBuilder()
SqlUpdateBuilder(DataCenter dc)
SqlUpdateBuilder(DataCenter dc, String tableName)
SqlUpdateBuilder(String tableName)

方法概要

修饰符和类型	方法	说明
SqlUpdateBuilder	addBigIntCol(String colName, Object obj)
SqlUpdateBuilder	addCol(String colName, String colType, Object obj)
SqlUpdateBuilder	addCol(String colName, String colType, Object obj, boolean isWhereCondition)
SqlUpdateBuilder	addCol(String colName, String colType, Object obj, boolean isWhereCondition, boolean isIn)
SqlUpdateBuilder	addCol(String colName, String colType, Object obj, boolean isWhereCondition, boolean isIn, boolean isSelfExp)
SqlUpdateBuilder	addDoubleCol(String colName, Object obj)
SqlUpdateBuilder	addIntegerCol(String colName, Object obj)
SqlUpdateBuilder	addObjectCol(String colName, Object obj)
SqlUpdateBuilder	addSelf(String exp)
SqlUpdateBuilder	addStringCol(String colName, Object obj)
SqlUpdateBuilder	addSystemTime(String colName)
SqlUpdateBuilder	addTextCol(String colName, Object obj)
SqlUpdateBuilder	addTimestampCol(String colName, String time, String format)
SqlUpdateBuilder	addTimestampCol(String colName, Timestamp timestamp)
SqlUpdateBuilder	addTimestampCol(String colName, LocalDateTime localDateTime)
SqlUpdateBuilder	addTimestampCol(String colName, Date date)
SqlUpdateBuilder	addTimestampColZone(String colName, String time, String format)
SqlUpdateBuilder	addWhereBigIntCol(String colName, Object obj)
SqlUpdateBuilder	addWhereBigIntCol_in(String colName, String obj)
SqlUpdateBuilder	addWhereCol(String colName, String colType, Object obj)
SqlUpdateBuilder	addWhereCol_in(String colName, String colType, String obj)
SqlUpdateBuilder	addWhereDoubleCol(String colName, Object obj)
SqlUpdateBuilder	addWhereIntegerCol(String colName, Object obj)
SqlUpdateBuilder	addWhereIntegerCol_in(String colName, String obj)
SqlUpdateBuilder	addWhereObjectol(String colName, Object obj)
SqlUpdateBuilder	addWhereSelf(String exp)
SqlUpdateBuilder	addWhereStringCol(String colName, Object obj)
SqlUpdateBuilder	addWhereStringCol_in(String colName, String obj)
SqlUpdateBuilder	addWhereTextCol(String colName, Object obj)
SqlUpdateBuilder	asDelete()
SqlUpdateBuilder	asInsert()
SqlUpdateBuilder	asInsertIgnore()
SqlUpdateBuilder	asInsertOrUpdate()
SqlUpdateBuilder	asInsertOrUpdateOnDuplicateKey()	使用on duplicate key update方式判断添加或修改数据，只有MySQL有效
SqlUpdateBuilder	asReplace()
SqlUpdateBuilder	asUpdate()
String[]	delete(boolean commit)	执行删除操作
int	getAutoGeneratedValue()	获取自增长值
SqlUpdateBuilder.SqlUpdateBuilderCol	getBuilderCol(String colName)
SqlUpdateBuilder.SqlUpdateBuilderCol	getBuilderWhereCol(String colName)
double	getColDoubleValue(String colName)
double	getColDoubleValue(String colName, double defaultValue)
int	getColIntValue(String colName)
int	getColIntValue(String colName, int defaultValue)
List<SqlUpdateBuilder.SqlUpdateBuilderCol>	getColList()
long	getColLongValue(String colName)
long	getColLongValue(String colName, long defaultValue)
String	getColStringValue(String colName)
Object	getColValue(String colName)	查询值
DataCenter	getDc()
int	getOperateType()
SqlUpdateBuilder.SqlUpdateBuilderCol	getSqlUpdateBuilderCol(String colName)
SqlUpdateBuilder.SqlUpdateBuilderCol	getSqlUpdateBuilderCol(String colName, boolean isWhereCondition)	获取列信息
String	getTableName()
List<SqlUpdateBuilder.SqlUpdateBuilderCol>	getWhereColList()
SqlUpdateBuilder	insertEnable(boolean flag)
SqlUpdateBuilder	insertEnable(String colName, boolean flag)
SqlUpdateBuilder	insertValueRightExpress(String express)
SqlUpdateBuilder	insertValueRightExpress(String colName, String express)
boolean	isColExists(String colName)	判断列是否存在，包括条件列或更新列
boolean	isOnlyInsert()
boolean	isOnlyUpdate()
int	isRecordExists()	判断记录是否存在
Datastore	isRecordExistsAndData(String... cols)
boolean	isUpdateColExists(String colName)	判断列是否存在
boolean	isWhereColExists(String colName)	判断条件列是否存在
SqlUpdateBuilder	onlyInsert()
SqlUpdateBuilder	onlyUpdate()
SqlUpdateBuilder	printLog(boolean logEnable)
SqlUpdateBuilder	printLog(org.apache.logging.log4j.Logger log4j, boolean logEnable)
SqlUpdateBuilder	removeCol(String colName)	删除指定的列
SqlUpdateBuilder	reset()
SqlUpdateBuilder	resetParameter()	重置参数，不改变表名
SqlUpdateBuilder	setDc(DataCenter dc)
SqlUpdateBuilder	setGetAutoValue(boolean autoValue)
SqlUpdateBuilder	setOnlyInsert(boolean onlyInsert)
SqlUpdateBuilder	setOnlyUpdate(boolean onlyUpdate)
SqlUpdateBuilder	setTableName(String tableName)
SqlUpdateBuilder	setWhereColOperator(String flag)
SqlUpdateBuilder	setWhereColOperator(String colName, String flag)	设置where条件列的操作符，默认为 =
String[]	update()
String[]	update(boolean commit)	执行数据库操作
SqlUpdateBuilder	updateEnable(boolean flag)
SqlUpdateBuilder	updateEnable(String colName, boolean flag)
SqlUpdateBuilder	updateValueRightExpress(String express)
SqlUpdateBuilder	updateValueRightExpress(String colName, String express)

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

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

字段详细资料

_log4j

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

INSERT

public static final int INSERT

另请参阅:

• 常量字段值

UPDATE

public static final int UPDATE

另请参阅:

• 常量字段值

REPLACE

public static final int REPLACE

另请参阅:

• 常量字段值

INSERT_UPDATE

public static final int INSERT_UPDATE

另请参阅:

• 常量字段值

INSERT_IGNORE

public static final int INSERT_IGNORE

另请参阅:

• 常量字段值

INSERT_UPDATE_DUPLICATE_KEY

public static final int INSERT_UPDATE_DUPLICATE_KEY

另请参阅:

• 常量字段值

DELETE

public static final int DELETE

另请参阅:

• 常量字段值

EXISTS

public static final int EXISTS

另请参阅:

• 常量字段值

ERROR

public static final int ERROR

另请参阅:

• 常量字段值

NOT_EXISTS

public static final int NOT_EXISTS

另请参阅:

• 常量字段值

构造器详细资料

SqlUpdateBuilder

public SqlUpdateBuilder()

SqlUpdateBuilder

public SqlUpdateBuilder(DataCenter dc,
 String tableName)

SqlUpdateBuilder

public SqlUpdateBuilder(DataCenter dc)

SqlUpdateBuilder

public SqlUpdateBuilder(String tableName)

方法详细资料

printLog

public SqlUpdateBuilder printLog(boolean logEnable)

printLog

public SqlUpdateBuilder printLog(org.apache.logging.log4j.Logger log4j,
 boolean logEnable)

asInsert

public SqlUpdateBuilder asInsert()

asInsertIgnore

public SqlUpdateBuilder asInsertIgnore()

asUpdate

public SqlUpdateBuilder asUpdate()

asInsertOrUpdate

public SqlUpdateBuilder asInsertOrUpdate()

asInsertOrUpdateOnDuplicateKey

public SqlUpdateBuilder asInsertOrUpdateOnDuplicateKey()

使用on duplicate key update方式判断添加或修改数据，只有MySQL有效

返回:

asReplace

public SqlUpdateBuilder asReplace()

onlyInsert

public SqlUpdateBuilder onlyInsert()

onlyUpdate

public SqlUpdateBuilder onlyUpdate()

asDelete

public SqlUpdateBuilder asDelete()

setGetAutoValue

public SqlUpdateBuilder setGetAutoValue(boolean autoValue)

addWhereCol

public SqlUpdateBuilder addWhereCol(String colName,
 String colType,
 Object obj)

addWhereCol_in

public SqlUpdateBuilder addWhereCol_in(String colName,
 String colType,
 String obj)

addWhereStringCol

public SqlUpdateBuilder addWhereStringCol(String colName,
 Object obj)

addWhereStringCol_in

public SqlUpdateBuilder addWhereStringCol_in(String colName,
 String obj)

addWhereTextCol

public SqlUpdateBuilder addWhereTextCol(String colName,
 Object obj)

addWhereIntegerCol

public SqlUpdateBuilder addWhereIntegerCol(String colName,
 Object obj)

addWhereIntegerCol_in

public SqlUpdateBuilder addWhereIntegerCol_in(String colName,
 String obj)

addWhereBigIntCol

public SqlUpdateBuilder addWhereBigIntCol(String colName,
 Object obj)

addWhereBigIntCol_in

public SqlUpdateBuilder addWhereBigIntCol_in(String colName,
 String obj)

addWhereDoubleCol

public SqlUpdateBuilder addWhereDoubleCol(String colName,
 Object obj)

addWhereObjectol

public SqlUpdateBuilder addWhereObjectol(String colName,
 Object obj)

addCol

public SqlUpdateBuilder addCol(String colName,
 String colType,
 Object obj)

addStringCol

public SqlUpdateBuilder addStringCol(String colName,
 Object obj)

addTextCol

public SqlUpdateBuilder addTextCol(String colName,
 Object obj)

addIntegerCol

public SqlUpdateBuilder addIntegerCol(String colName,
 Object obj)

addBigIntCol

public SqlUpdateBuilder addBigIntCol(String colName,
 Object obj)

addDoubleCol

public SqlUpdateBuilder addDoubleCol(String colName,
 Object obj)

addObjectCol

public SqlUpdateBuilder addObjectCol(String colName,
 Object obj)

addTimestampCol

public SqlUpdateBuilder addTimestampCol(String colName,
 String time,
 String format)

addTimestampColZone

public SqlUpdateBuilder addTimestampColZone(String colName,
 String time,
 String format)

addTimestampCol

public SqlUpdateBuilder addTimestampCol(String colName,
 Timestamp timestamp)

addTimestampCol

public SqlUpdateBuilder addTimestampCol(String colName,
 Date date)

addTimestampCol

public SqlUpdateBuilder addTimestampCol(String colName,
 LocalDateTime localDateTime)

getBuilderCol

public SqlUpdateBuilder.SqlUpdateBuilderCol getBuilderCol(String colName)

getBuilderWhereCol

public SqlUpdateBuilder.SqlUpdateBuilderCol getBuilderWhereCol(String colName)

getSqlUpdateBuilderCol

public SqlUpdateBuilder.SqlUpdateBuilderCol getSqlUpdateBuilderCol(String colName)

getSqlUpdateBuilderCol

public SqlUpdateBuilder.SqlUpdateBuilderCol getSqlUpdateBuilderCol(String colName,
 boolean isWhereCondition)

获取列信息

参数:

colName - String

isWhereCondition - boolean

返回:

SqlUpdateBuilderCol

addSelf

public SqlUpdateBuilder addSelf(String exp)

addWhereSelf

public SqlUpdateBuilder addWhereSelf(String exp)

addCol

public SqlUpdateBuilder addCol(String colName,
 String colType,
 Object obj,
 boolean isWhereCondition)

addCol

public SqlUpdateBuilder addCol(String colName,
 String colType,
 Object obj,
 boolean isWhereCondition,
 boolean isIn)

addCol

public SqlUpdateBuilder addCol(String colName,
 String colType,
 Object obj,
 boolean isWhereCondition,
 boolean isIn,
 boolean isSelfExp)

addSystemTime

public SqlUpdateBuilder addSystemTime(String colName)

updateValueRightExpress

public SqlUpdateBuilder updateValueRightExpress(String express)

updateValueRightExpress

public SqlUpdateBuilder updateValueRightExpress(String colName,
 String express)

insertValueRightExpress

public SqlUpdateBuilder insertValueRightExpress(String express)

insertValueRightExpress

public SqlUpdateBuilder insertValueRightExpress(String colName,
 String express)

insertEnable

public SqlUpdateBuilder insertEnable(boolean flag)

insertEnable

public SqlUpdateBuilder insertEnable(String colName,
 boolean flag)

updateEnable

public SqlUpdateBuilder updateEnable(boolean flag)

updateEnable

public SqlUpdateBuilder updateEnable(String colName,
 boolean flag)

setWhereColOperator

public SqlUpdateBuilder setWhereColOperator(String flag)

setWhereColOperator

public SqlUpdateBuilder setWhereColOperator(String colName,
 String flag)

设置where条件列的操作符，默认为 =

参数:

colName -

flag -

返回:

update

public String[] update()

update

public String[] update(boolean commit)

执行数据库操作

参数:

commit - boolean

返回:

String[]

delete

public String[] delete(boolean commit)

执行删除操作

参数:

commit - boolean

返回:

String[]

isRecordExists

public int isRecordExists()

判断记录是否存在

返回:

int

isRecordExistsAndData

public Datastore isRecordExistsAndData(String... cols)

removeCol

public SqlUpdateBuilder removeCol(String colName)

删除指定的列

参数:

colName - String

返回:

SqlUpdateBuilder

isColExists

public boolean isColExists(String colName)

判断列是否存在，包括条件列或更新列

参数:

colName - boolean

返回:

boolean

isWhereColExists

public boolean isWhereColExists(String colName)

判断条件列是否存在

参数:

colName - boolean

返回:

boolean

isUpdateColExists

public boolean isUpdateColExists(String colName)

判断列是否存在

参数:

colName - String

返回:

boolean

getColStringValue

public String getColStringValue(String colName)

getColIntValue

public int getColIntValue(String colName)

getColIntValue

public int getColIntValue(String colName,
 int defaultValue)

getColLongValue

public long getColLongValue(String colName)

getColLongValue

public long getColLongValue(String colName,
 long defaultValue)

getColDoubleValue

public double getColDoubleValue(String colName)

getColDoubleValue

public double getColDoubleValue(String colName,
 double defaultValue)

getColValue

public Object getColValue(String colName)

查询值

参数:

colName - String

返回:

Object

getTableName

public String getTableName()

setTableName

public SqlUpdateBuilder setTableName(String tableName)

getDc

public DataCenter getDc()

setDc

public SqlUpdateBuilder setDc(DataCenter dc)

getColList

public List<SqlUpdateBuilder.SqlUpdateBuilderCol> getColList()

getWhereColList

public List<SqlUpdateBuilder.SqlUpdateBuilderCol> getWhereColList()

isOnlyInsert

public boolean isOnlyInsert()

setOnlyInsert

public SqlUpdateBuilder setOnlyInsert(boolean onlyInsert)

isOnlyUpdate

public boolean isOnlyUpdate()

setOnlyUpdate

public SqlUpdateBuilder setOnlyUpdate(boolean onlyUpdate)

reset

public SqlUpdateBuilder reset()

resetParameter

public SqlUpdateBuilder resetParameter()

重置参数，不改变表名

返回:

getOperateType

public int getOperateType()

getAutoGeneratedValue

public int getAutoGeneratedValue()

获取自增长值

返回:

int