java jdbc 批量更新,spring jdbcTemplate批量更新操作 | 学步园

直接给代码：

/**

* 批量保存流程泳道实例

* @param taInstswimwayList 流程泳道实例集合

*/

public void saveTaInstswimwayObj(final List taInstswimwayList)throws Exception{

String sql = "insert into ta_instswimway(WAYID,PROCINSTID,WAYNAME,GRAPHMSG,DIRECTION) values(?,?,?,?,?)";

try{

this.getJdbcTemplate().batchUpdate(sql, new BatchPreparedStatementSetter(){

public int getBatchSize() {

return taInstswimwayList.size();

}

public void setValues(PreparedStatement pst, int i) throws SQLException {

TaInstswimway obj = (TaInstswimway) taInstswimwayList.get(i);

pst.setString(1, obj.getWayid());

TaProcInst taProcInstObj = obj.getTaProcinst();

String procinstid = taProcInstObj.getProcinstid();

pst.setObject(2, procinstid);

pst.setString(3, obj.getWayname());

pst.setString(4, obj.getGraphmsg());

pst.setString(5, obj.getDirection());

}

});

}catch(Exception e){

e.printStackTrace();

throw new Exception(e.getMessage());

}

}

insert 语句、update语句、delete语句都可以执行。