Advertisement
Guest User

Untitled

a guest
Sep 26th, 2017
72
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.98 KB | None | 0 0
  1. try
  2. {
  3. Class.forName("com.mysql.jdbc.Driver");
  4. Connection connect = DriverManager.getConnection("jdbc:mysql://localhost:3306/employee", "root", "");
  5. PreparedStatement pt = connect.prepareStatement("INSERT INTO employee (firstname,lastname,deptcode,phoneno,hiredate,job) values(?,?,?,?,?,?)");
  6.  
  7. // pt.setString(1, empnoTField.getText());
  8. pt.setString(1, fnameTField.getText());
  9. pt.setString(2, lnameTField.getText());
  10. pt.setString(3, deptCodeCombo.getSelectedItem().toString());
  11. pt.setString(4, phoneTField.getText());
  12. //pt.setString(6, monthCombo.getSelectedItem().toString() + "/" + dayCombo.getSelectedItem().toString() + "/" + yearCombo.getSelectedItem().toString());
  13. pt.setString(5, hiredate.getText());
  14. pt.setString(6, jobTField.getText());
  15.  
  16. pt.executeUpdate();
  17. connect.close();
  18. JOptionPane.showMessageDialog(this, "New Employee Save!","Confirmation",JOptionPane.INFORMATION_MESSAGE);
  19.  
  20.  
  21. //empnoTField.setText(null);
  22. fnameTField.setText(null);
  23. lnameTField.setText(null);
  24. deptCodeCombo.setSelectedIndex(0);
  25. phoneTField.setText(null);
  26. //monthCombo.setSelectedIndex(0);
  27. //dayCombo.setSelectedIndex(0);
  28. //yearCombo.setSelectedIndex(0);
  29. hiredate.setText(null);
  30. jobTField.setText(null);
  31.  
  32. // NewRecord.setVisible(false);
  33. displayTable();
  34. }
  35.  
  36. catch(SQLException sqe){
  37. System.out.println("SQl error: " + sqe.toString());
  38. }
  39. catch(ClassNotFoundException cnf){
  40. System.out.println("Class not found error: " + cnf.toString());
  41. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement