JDBC批量删除☞方法一

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();
  }