Advertisement
Guest User

Untitled

a guest
Aug 14th, 2017
60
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.55 KB | None | 0 0
  1. String mk =jTextField1.getText();
  2. String mn = jTextField2.getText();
  3. String ab =(String) jComboBox1.getSelectedItem();
  4. String bc = (String) jComboBox2.getSelectedItem();
  5.  
  6.  
  7. try{
  8. Class.forName("org.apache.derby.jdbc.EmbeddedDriver").newInstance();
  9. Connection con = (Connection) DriverManager.getConnection("jdbc:derby://localhost:1527/production");{
  10. String host ="jdbc:derby://localhost:1527/production";
  11.  
  12. Statement stmt = con.createStatement();
  13. String query = "update PRODUCT set FACTORY=?,PRODUCT_NAME =?,UNIT=?,OPENING_BALANCE=?";
  14. try (PreparedStatement update = con.prepareStatement(query)){
  15. update.setString(1, ab);
  16. update.setString(2, mk);
  17. update.setString(3, bc);
  18. update.setString(4, mn);
  19.  
  20. update.executeUpdate();
  21.  
  22. jTextField1.setText(null);
  23. jTextField2.setText(null);
  24. MainPanel.removeAll();
  25. MainPanel.add(jPanelStart1);
  26. MainPanel.repaint();
  27. MainPanel.revalidate();
  28. }
  29. JOptionPane.showMessageDialog(this, "Record has been inserted");
  30.  
  31. }
  32. }
  33. catch(Exception e){
  34. JOptionPane.showMessageDialog(this, "invalid entry");
  35.  
  36. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement