Bach_update in Spring

•  使用 JdbcTemplate 执行  bach update 操作

           1.实现 batch update SQL

           2.实现接口 BatchPreparedStatementSetter接口，将SQL中的占位符赋值.

           3.调用 JdbcTemplate.batchUpdate 执行 batch update 操作.

           Sample code,

 

  Static String sql = "update schema.yourtable set price = ? where id = ?"; ................... ................... BatchPreparedStatementSetter setter = new BatchPreparedStatementSetter() { Iterator i = yourCollection.iterator(); public int getBatchSize() { return batch.size(); } public void setValues( PreparedStatement ps, int index ) throws SQLException { Object o= (Object) i.next(); ps.setDouble( 1, o.getPrice() ); ps.setLong ( 2, o.getID ); } }; .................... .................... JdbcTemplate jt = new JdbcTemplate(); jt.batchUpate( sql, setter )