public int BatchUpdateAudit(List<WcspResColRef> dataSet) {
String updateSql = "update wcsp_res_col_ref set status = ? ,REJECTED_REASON = ? where ref_id = ?";
List<Object[]> list = new ArrayList<Object[]>();
for (Iterator<WcspResColRef> iterator = dataSet.iterator(); iterator
.hasNext();) {
WcspResColRef wcspResColRef = (WcspResColRef) iterator.next();
Integer status = wcspResColRef.getStatus();
String REJECTED_REASON = wcspResColRef.getRejectedReason();
Long ref_id = wcspResColRef.getRefId();
Object[] obj = { status, REJECTED_REASON, ref_id };
list.add(obj);
}
int[] reslut = {};
try {
reslut = this.jdbcTemplate.batchUpdate(updateSql, list);
} catch (Exception e) {
}
return reslut.length;
}
//Spring jdbcTemplate.batchUpdate(); 批量更新方式