Advertisement
Guest User

Untitled

a guest
Sep 27th, 2017
80
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.08 KB | None | 0 0
  1. public void displayUpdate(){
  2.  
  3.  
  4. try
  5. {
  6. Class.forName("com.mysql.jdbc.Driver");
  7. Connection connect = DriverManager.getConnection("jdbc:mysql://localhost:3306/employee", "root", "");
  8. Statement st = connect.createStatement();
  9. rs = st.executeQuery("SELECT empno, firstname,lastname,deptcode,phoneno,hiredate,job FROM employee where empno = " + currentid);
  10.  
  11. rs.next();
  12.  
  13. empnoTField1.setText(rs.getString(1));
  14. fnameTField1.setText(rs.getString(2));
  15. lnameTField1.setText(rs.getString(3));
  16. deptCodeCombo1.setSelectedItem(rs.getString(4));
  17. phoneTField1.setText(rs.getString(5));
  18. hiredate1.setText(rs.getString(6));
  19.  
  20.  
  21. jobTField1.setText(rs.getString(7));
  22.  
  23. connect.close();
  24. }
  25. catch(SQLException sqe){
  26. System.out.println("SQL error: " + sqe.toString());
  27. }
  28. catch(ClassNotFoundException cnf) {
  29. System.out.println("Class not found error : " + cnf.toString());
  30. }
  31.  
  32.  
  33. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement