项目经验：jdbc实现批量添加、批量删除

来源：互联网发布：淘宝女装店铺描述范文编辑：程序博客网时间：2024/06/03 17:54

jdbc批量添加：

/** * 批量save专家意见list */public void saveBatchZjyjList(List<ZxDZjyj> zjyjList) {Connection conn = null;PreparedStatement ps = null;try {Session session = template.getSessionFactory().getCurrentSession();conn = session.connection();String sql = "insert into ZX_D_ZJYJ(uuid,hsbm,zjmc,ssdw,zc,lxfs,zjyj,cjsj) values (?,?,?,?,?,?,?,?)";ps = conn.prepareStatement(sql);for (ZxDZjyj zjyj:zjyjList) {ps.setString(1, generateUuid());ps.setString(2, zjyj.getHsbm());ps.setString(3, zjyj.getZjmc());ps.setString(4, zjyj.getSsdw());ps.setString(5, zjyj.getZc());ps.setString(6, zjyj.getLxfs());ps.setString(7, zjyj.getZjyj());ps.setTimestamp(8, Timestamp.valueOf(new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(zjyj.getCjsj())));ps.addBatch();   }ps.executeBatch();} catch (SQLException ex) {ex.printStackTrace();} finally{if (ps != null) {try {ps.close();} catch (SQLException e) {e.printStackTrace();}}if(conn != null){try {conn.close();} catch (SQLException e) {e.printStackTrace();}}}}

jdbc批量删除：

/** * 批量delete专家意见list */public void delBatchZjyjList(ZxDHsjl hsjl) {Connection conn = null;PreparedStatement ps = null;try {Session session = template.getSessionFactory().getCurrentSession();conn = session.connection();String sql = "delete from ZX_D_ZJYJ where hsbm=?";ps = conn.prepareStatement(sql);ps.setString(1, hsjl.getUuid());ps.addBatch();  ps.executeBatch();} catch (SQLException ex) {ex.printStackTrace();} finally{if(ps != null){try {ps.close();} catch (SQLException e) {e.printStackTrace();}}if(conn !=null){try {conn.close();} catch (SQLException e) {e.printStackTrace();}}}}

0 0