Guest User

Untitled

a guest
Feb 13th, 2019
105
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.10 KB | None | 0 0
  1. private void deleteActionPerformed(java.awt.event.ActionEvent evt) {
  2. // TODO add your handling code here:
  3. try{
  4. Connection con=null;
  5. Statement st;
  6. ResultSet rs;
  7. con=DriverManager.getConnection("jdbc:mysql://localhost:3306/mall","root","");
  8. st=con.createStatement();
  9. DefaultTableModel model = (DefaultTableModel)speedster.getModel();
  10. int SelectedRowIndex = speedster.getSelectedRow();
  11. //model.removeRow(SelectedRowIndex);
  12. Object o = speedster.getValueAt(SelectedRowIndex,0);
  13. String query1 = "delete from app where uid="+o+"";
  14. while(model.getRowCount()>0)
  15. {
  16. rs = st.executeQuery("select * from app");
  17. if(rs.getString("UID")==o)
  18. {
  19. //model.removeRow(SelectedRowIndex);
  20. //String query1 = "delete from app where uid='"+o+"'";
  21. st.executeQuery(query1);
  22. }
  23. }
  24. }
  25. catch(SQLException ex)
  26. {
  27. JOptionPane.showMessageDialog(this,"Cannot delete the selected item.");
  28. }
  29. }
Add Comment
Please, Sign In to add comment