jdbcTemplate批量插入、更新

jdbcTemplate批量插入、更新

 

解决方法：

List<Map<String, String>> extList = new ArrayList<Map<String, String>>();

 

HashMap<String, String> ext = new HashMap<String, String>(){

  {

       put("key", key);  

       put("value", value);  

   }

};

extList.add(ext);

StringBuilder sb = new StringBuilder();

sb.append("insert ignore into tb_call_ext(ext_id,c_id,ext_key,ext_val) values(?,?,?,?) ");

int[] extresult = jdbcTemplate.batchUpdate(sb.toString(), new BatchPreparedStatementSetter() {

@Override

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

//批量操作代码：http://www.yayihouse.com/yayishuwu/chapter/2085

});