net.ymate.platform.persistence.jdbc.base.impl

Class BatchUpdateOperator

java.lang.Object

net.ymate.platform.persistence.jdbc.base.AbstractOperator

net.ymate.platform.persistence.jdbc.base.impl.BatchUpdateOperator

All Implemented Interfaces:

IBatchUpdateOperator, IOperator

public class BatchUpdateOperator
extends AbstractOperator
implements IBatchUpdateOperator

数据库批量更新操作器实现

Author:

刘镇 (suninformation@163.com) on 2011-9-23 下午01:15:43

Field Summary

Fields inherited from class net.ymate.platform.persistence.jdbc.base.AbstractOperator

executed, expenseTime, sql

Constructor Summary

Constructors

Constructor and Description
BatchUpdateOperator(IDatabaseConnectionHolder connectionHolder)
BatchUpdateOperator(IDatabaseConnectionHolder connectionHolder, IAccessorConfig accessorConfig)
BatchUpdateOperator(String sql, IDatabaseConnectionHolder connectionHolder)
BatchUpdateOperator(String sql, IDatabaseConnectionHolder connectionHolder, IAccessorConfig accessorConfig)

Method Summary

Modifier and Type	Method and Description
IBatchUpdateOperator	addBatchParameter(SQLBatchParameter parameter) 添加批量SQL参数
IBatchUpdateOperator	addBatchSQL(String sql) 添加SQL语句
IOperator	addParameter(Object parameter) 添加SQL参数，若参数为NULL则将默认向SQL传递NULL值对象
IOperator	addParameter(SQLParameter parameter) 添加SQL参数，若参数为NULL则忽略
protected int	doExecute() 执行具体的操作过程
List<SQLBatchParameter>	getBatchParameters() 获取批量SQL参数集合
int[]	getEffectCounts() 对于 INSERT、UPDATE 或 DELETE 语句，返回行数; 对于无返回结果的SQL语句，返回 0
int	getEffectCountsTotal() 获取累计受影响的总记录数
List<SQLParameter>	getParameters() 获取SQL参数集合
static int	parseEffectCounts(int[] effectCounts)
protected String	serializeParameters()

Methods inherited from class net.ymate.platform.persistence.jdbc.base.AbstractOperator

doAppendStackTraces, doSetParameters, execute, getAccessorConfig, getConnectionHolder, getExpenseTime, getSQL, isExecuted, setAccessorConfig

Methods inherited from class java.lang.Object

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

Methods inherited from interface net.ymate.platform.persistence.jdbc.base.IOperator

execute, getAccessorConfig, getConnectionHolder, getExpenseTime, getSQL, isExecuted, setAccessorConfig

Constructor Detail

BatchUpdateOperator

public BatchUpdateOperator(IDatabaseConnectionHolder connectionHolder)

BatchUpdateOperator

public BatchUpdateOperator(IDatabaseConnectionHolder connectionHolder,
                           IAccessorConfig accessorConfig)

BatchUpdateOperator

public BatchUpdateOperator(String sql,
                           IDatabaseConnectionHolder connectionHolder)

BatchUpdateOperator

public BatchUpdateOperator(String sql,
                           IDatabaseConnectionHolder connectionHolder,
                           IAccessorConfig accessorConfig)

Method Detail

parseEffectCounts

public static int parseEffectCounts(int[] effectCounts)

serializeParameters

protected String serializeParameters()

Overrides:

serializeParameters in class AbstractOperator

doExecute

protected int doExecute()
                 throws Exception

Description copied from class: AbstractOperator

执行具体的操作过程

Specified by:

doExecute in class AbstractOperator

Returns:

返回影响行数

Throws:

Exception - 执行过程中产生的异常

getEffectCounts

public int[] getEffectCounts()

Description copied from interface: IBatchUpdateOperator

对于 INSERT、UPDATE 或 DELETE 语句，返回行数; 对于无返回结果的SQL语句，返回 0

Specified by:

getEffectCounts in interface IBatchUpdateOperator

Returns:

int[] 获取批量更新操作执行后，每组SQL影响的记录行数的数组；

getEffectCountsTotal

public int getEffectCountsTotal()

Description copied from interface: IBatchUpdateOperator

获取累计受影响的总记录数

Specified by:

getEffectCountsTotal in interface IBatchUpdateOperator

Returns:

返回累计受影响的总记录数

addBatchSQL

public IBatchUpdateOperator addBatchSQL(String sql)

Description copied from interface: IBatchUpdateOperator

添加SQL语句

Specified by:

addBatchSQL in interface IBatchUpdateOperator

Parameters:

sql - SQL语句

Returns:

返回当前批量操作器

addBatchParameter

public IBatchUpdateOperator addBatchParameter(SQLBatchParameter parameter)

Description copied from interface: IBatchUpdateOperator

添加批量SQL参数

Specified by:

addBatchParameter in interface IBatchUpdateOperator

Parameters:

parameter - 批量SQL参数对象

Returns:

返回当前批量操作器

getBatchParameters

public List<SQLBatchParameter> getBatchParameters()

Description copied from interface: IBatchUpdateOperator

获取批量SQL参数集合

Specified by:

getBatchParameters in interface IBatchUpdateOperator

Returns:

返回批量SQL参数集合

addParameter

public IOperator addParameter(Object parameter)

Description copied from interface: IOperator

添加SQL参数，若参数为NULL则将默认向SQL传递NULL值对象

Specified by:

addParameter in interface IOperator

Overrides:

addParameter in class AbstractOperator

Parameters:

parameter - SQL参数值

Returns:

返回当前操作器对象

addParameter

public IOperator addParameter(SQLParameter parameter)

Description copied from interface: IOperator

添加SQL参数，若参数为NULL则忽略

Specified by:

addParameter in interface IOperator

Overrides:

addParameter in class AbstractOperator

Parameters:

parameter - SQL参数对象

Returns:

返回当前操作器对象

getParameters

public List<SQLParameter> getParameters()

Description copied from interface: IOperator

获取SQL参数集合

Specified by:

getParameters in interface IOperator

Overrides:

getParameters in class AbstractOperator

Returns:

返回SQL参数集合