JDBC批量删除☞方法一

最新推荐文章于 2023-01-06 15:27:27 发布

EricLiutyy

最新推荐文章于 2023-01-06 15:27:27 发布

阅读量974

点赞数

分类专栏：有用东东编程心得文章标签： jdbc delete

本文链接：https://blog.csdn.net/ericliutyy/article/details/5657776

版权

编程心得同时被 2 个专栏收录

69 篇文章 1 订阅

订阅专栏

有用东东

31 篇文章 0 订阅

订阅专栏

try {
   //con.setAutoCommit(false);
   deletePatchPst = con
     .prepareStatement("delete from recordslist where p_id=?");

   for(int i=0;i<deleteIdList.size();i++){
    deletePatchPst.setInt(1, deleteIdList.get(i));
    deletePatchPst.addBatch();
   }

   int[] counts = deletePatchPst.executeBatch();

    tableModel = new DefaultTableModel() {
     private static final long serialVersionUID = 1L;
     public boolean isCellEditable(int row, int column) {
      //if(column==4||column==5||column==6||column==7){//设置第5、
      // 6列可编辑
      return true;
      // }
      // return false;
     }
    };
    MyTable myTable1=new MyTable();
    myTable1.setModel(tableModel);
    getRecordSearchOnePageList(myTable1,searchPO,label_allItemNum,label_allPageNum,label_curPageNum);
    scrollPane.setViewportView(myTable1);
  } catch (SQLException e) {
   // TODO Auto-generated catch block
   try {
    con.rollback();
   } catch (SQLException e1) {
    // TODO Auto-generated catch block
    e1.printStackTrace();
   }//设置回滚
   e.printStackTrace();
  }