数据的update/insert, 可以用BATCH UPDATE方法

 

batch update method;

 

private void update(List<String> userIds) {final String updateSql = "UPDATE TABLE SET DISC_TS = ?  WHERE USER_ID = ? ";getJdbcTemplate().batchUpdate(updateSql,new BatchPreparedStatementSetter() {@Overridepublic void setValues(final PreparedStatement ps,final int i) throws SQLException {ps.setTimestamp(1, ?);ps.setString(2, userIds.get(i));}@Overridepublic int getBatchSize() {return userIds.size();}});}