JAVA操作数据库进行批处理
//保存销售信息列表到数据库public boolean saveClothSaleInfo(List<ClothSaleInfoVO> saleInfoList){Connection conn = null;PreparedStatement pstm = null;String sql = "insert into cloth_sale_info(sale_number,cloth_id,user_id) values(?,?,?)";try {conn = DBUtil.getConnection();pstm = conn.prepareStatement(sql);for (ClothSaleInfoVO clothSaleInfo : saleInfoList) {pstm.setLong(1, clothSaleInfo.getSaleNumber());pstm.setInt(2, clothSaleInfo.getClothId());pstm.setInt(3, clothSaleInfo.getUserId());pstm.addBatch();}pstm.executeBatch();return true;} catch (SQLException e) {e.printStackTrace();return false;} finally {DBUtil.close(conn, pstm, null);}}
?