JDBC批量操作
来源：互联网 发布：mac安装器遇到一个错误 编辑：程序博客网 时间：2024/05/20 05:57
pst = conn.prepareStatement(sql);for(Msg msg:msges){pst.setString(index++, msg.getId());pst.setString(index++, msg.getPublisher());pst.setString(index++, msg.getReceiver());pst.setString(index++, msg.getBody());pst.setString(index++, msg.getTime());pst.setString(index++, msg.getState());pst.setString(index++, msg.getType());pst.addBatch();}pst.executeBatch();String sql = "delete from " + TAB + " b" + " where b." + ID + "=?";pst = conn.prepareStatement(sql);for(String uid:ids){pst.setString(1, uid);pst.addBatch();}pst.executeBatch();
