JesuisEva

multipleSelect/delete

Jan 15th, 2013
53
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.05 KB | None | 0 0
  1. List lijst = klantList.getSelectedValuesList();
  2. String s = lijst.toString();
  3. String[] split = s.split(" ");
  4. String factnr = split[0];
  5. for (Object nieuweLijst : lijst) {
  6.  
  7. try{
  8. Connection con = Week5.getConnection();
  9. Statement stmt = con.createStatement();
  10. String SQL = "DELETE FROM lineitem WHERE factuurnr = '"+factnr+"' ";
  11. int delete = stmt.executeUpdate(SQL);
  12. String SQL2 = "DELETE FROM factuur WHERE factuurnr = '"+factnr+"' ";
  13. int delete2 = stmt.executeUpdate(SQL2);
  14.  
  15. if(delete == 1 & delete2 == 1){
  16. JOptionPane.showMessageDialog(null, "De order is verwijderd");
  17. }else{
  18. JOptionPane.showMessageDialog(null, "De order is niet verwijderd");
  19. }
  20.  
  21. }catch (SQLException err) {
  22. JOptionPane.showMessageDialog(rootPane, err);
  23. }
  24. }
  25. updateTable();
Advertisement
Add Comment
Please, Sign In to add comment