这段代码展示了如何使用SqlMapClientTemplate进行数据库的批量操作，包括批量更新（batchUpdate）、批量插入（batchInsert）和批量删除（batchDelete）。方法内部通过循环遍历列表并调用executor相应的方法执行SQL语句，最后执行executor.executeBatch()提交批处理。
public void batchUpdate(final String statementName, final List list) {
try {
if (list != null) {
this.getSqlMapClientTemplate().execute(new SqlMapClientCallback() {
public Object doInSqlMapClient(SqlMapExecutor executor) throws SQLException {
executor.startBatch();
for (int i = 0, n = list.size(); i < n; i++) {
executor.update(statementName, list.get(i));
}
executor.executeBatch();
return null;
}
});
}
} catch (Exception e) {
if (log.isDebugEnabled()) {
e.printStackTrace();
log.debug("batchUpdate error: id [" + statementName + "], parameterObject ["+ list + "]. Cause: "+ e.getMessage());
}
}
}
public void batchInsert(final String statementName, final List list) {
try {
if (list != null) {
this.getSqlMapClientTemplate().execute(new SqlMapClientCallback() {
public Object doInSqlMapClient(SqlMapExecutor executor) throws SQLException {
executor.startBatch();
for (int i = 0, n = list.size(); i < n; i++) {
executor.insert(statementName, list.get(i));
}
executor.executeBatch();
return null;
}
});
}
} catch (Exception e) {
if (log.isDebugEnabled()) {
e.printStackTrace();
log.debug("batchInsert error: id [" + statementName + "], parameterObject ["+ list + "]. Cause: "+ e.getMessage());
}
}
}
public void batchDelete(final String statementName, final List list) {
try {
if (list != null) {
this.getSqlMapClientTemplate().execute(new SqlMapClientCallback() {
public Object doInSqlMapClient(SqlMapExecutor executor) throws SQLException {
executor.startBatch();
for (int i = 0, n = list.size(); i < n; i++) {
executor.delete(statementName, list.get(i));
}
executor.executeBatch();
return null;
}
});
}
} catch (Exception e) {
if (log.isDebugEnabled()) {
e.printStackTrace();
log.debug("batchDelete error: id [" + statementName + "], parameterObject ["+ list + "]. Cause: "+ e.getMessage());
}
}
}
扫一扫
299
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
