【PreparedStatement】批量插入

String sql = "insert into happi_data (name,data,timestamp) values (?,?,?)";
PreparedStatement ps = connection.prepareStatement(sql);
ps.setString(1, name);
ps.setBytes(2, bytes);
ps.setTimestamp(3, timestamp);
ps.addBatch();
for(Happi h:happis){
    ps.setString(1, h.name);
    ps.setBytes(2, bytes);
    ps.setTimestamp(3, timestamp);
    ps.addBatch();
}
ps.executeBatch();
ps.close();