Spring jdbc 批量更新

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(); 批量更新方式