批量插入

public void saveAll(final List<User> list) {
try {
this.getHibernateTemplate().execute(new HibernateCallback<Object>() {
public Object doInHibernate(Session session)
throws HibernateException, SQLException {
Connection connection = session.connection();
String sql = "insert into user(ID,NAME,AGE,CREATE_TIME) values(?,?,?,?)";
PreparedStatement ps = connection.prepareStatement(sql);
String sql1 = "insert into log(ID,NAME,AGE) values(?,?,?) values(?,?,?)";
PreparedStatement ps1 = connection.prepareStatement(sql1);
List<Map<String, Object>> list = new ArrayList<Map<String, Object>>();
for (int i = 0; i < list.size(); i++) {
User bean = list.get(i);
ps.setString(1, user.getId());
ps.setString(2, user.getName());
ps.setString(3, user.getAge()); 
ps.setTimestamp(4, new java.sql.Timestamp(user.getCreateTime().getTime()));
ps.addBatch();
ps1.setString(1, user.getId());
ps1.setString(2, user.getName());
ps1.setString(3, user.getAge()); 
ps1.addBatch();
}
ps.executeBatch();
ps1.executeBatch();
ps.close();
ps1.close();
session.flush();
session.close();
return null;
}
});


} catch (Exception e) {
throw new Exception("保存错误 错误信息：" + e.getMessage());
}
}