/**
1000条去数据库修改一次
* update.
* @param cloundSign cloundSign
* @throws DataAccessException DataAccessException
* 批量更新
* @throws SQLException
*/
public void updateCloundSignBatch(final List<CloundSign> clList) throws DataAccessException, SQLException {
if (logger.isDebugEnabled()) {
logger.debug("进入updateCloundSignBatch, 输入参数[" + clList + "]");
}
/*this.getSqlMapClient().startBatch();
for (CloundSign cloundSign : clList) {
this.getSqlMapClientTemplate().update(
"CloundSign_updateCloundSign", cloundSign);
}*/
getSqlMapClientTemplate().execute(new SqlMapClientCallback() {
public Object doInSqlMapClient(SqlMapExecutor executor)
throws SQLException {
executor.startBatch();
int batchCommit = 0;
for (CloundSign clound : clList) {
executor.update("CloundSign_updateCloundSign", clound);
batchCommit++;
if (batchCommit >= 1000) {
executor.executeBatch();
batchCommit = 0;
}
}
if (batchCommit != 0) {
executor.executeBatch();
}
return null;
}
});
this.getSqlMapClient().executeBatch();
if (logger.isDebugEnabled()) {
logger.debug("离开updateCloundSignBatch");
}
}