public void batchInsert(List<T> list){
JdbcTemplate jdbcTemplate=(JdbcTemplate) SpringUtils.getBean(JdbcTemplate.class);
String sql = "insert into T(F1, F2, F3,F4,F5) values(?, ?, ?, ?, ?)";
jdbcTemplate.batchUpdate(sql, new BatchPreparedStatementSetter() {
@Override
public void setValues(PreparedStatement preparedStatement, int i) throws SQLException {
preparedStatement.setString(1, list.get(i).getF1());
preparedStatement.setString(2, list.get(i).getF2());
preparedStatement.setString(3, list.get(i).getF3());
preparedStatement.setString(4, list.get(i).getF4());
preparedStatement.setString(5, list.get(i).getF5());
}
@Override
public int getBatchSize() {
return list.size();
}
});
}
04-14
“相关推荐”对你有帮助么?
-
非常没帮助
-
没帮助
-
一般
-
有帮助
-
非常有帮助
提交