Advertisement
Guest User

Untitled

a guest
Sep 17th, 2016
66
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.95 KB | None | 0 0
  1. public void deleteRec(JComboBox code)
  2. {
  3.  
  4. try
  5. {
  6. Class.forName("com.mysql.jdbc.Driver");
  7. Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/stock","root","");
  8. String query = "SELECT stockCode FROM stock_transaction WHERE stockCode = '" + code.getSelectedItem() + "'";
  9. Statement stmt = con.createStatement();
  10. ResultSet rs = stmt.executeQuery(query);
  11. if(!rs.next())
  12. {
  13. PreparedStatement st = con.prepareStatement("DELETE FROM stock_transaction WHERE stockCode = ?");
  14. st.setString(1, (String)code.getSelectedItem());
  15. st.executeUpdate();
  16. }
  17. con.close();
  18. }
  19. catch(Exception e)
  20. {
  21. JOptionPane.showMessageDialog(null, "This is the error: " + e);
  22. }
  23. try
  24. {
  25. Class.forName("com.mysql.jdbc.Driver");
  26. Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/stock","root","");
  27. String query = "SELECT stockCode FROM stock_master WHERE stockCode = '" + code.getSelectedItem() + "'";
  28. Statement stmt = con.createStatement();
  29. ResultSet rs = stmt.executeQuery(query);
  30. if(!rs.next())
  31. {
  32. PreparedStatement st = con.prepareStatement("DELETE FROM stock_master WHERE stockCode = ?");
  33. st.setString(1, (String)code.getSelectedItem());
  34. st.executeUpdate();
  35. }
  36. con.close();
  37. }
  38. catch(Exception e)
  39. {
  40. JOptionPane.showMessageDialog(null, "This is the error: " + e);
  41. }
  42.  
  43. }
  44.  
  45. buttonDelete.addActionListener(new ActionListener() {
  46. @Override
  47. public void actionPerformed(ActionEvent e)
  48. {
  49. deleteRec(comboBoxStockCode);
  50. }
  51. });
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement