Advertisement
Guest User

Untitled

a guest
Sep 27th, 2017
135
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.95 KB | None | 0 0
  1. public void displayTable(){
  2. try
  3. {
  4. Class.forName("com.mysql.jdbc.Driver");
  5. Connection connect = DriverManager.getConnection("jdbc:mysql://localhost:3306/employee", "root", "");
  6. Statement st = connect.createStatement();
  7.  
  8. rs = st.executeQuery("SELECT empno,firstname,lastname,deptcode,phoneno,hiredate,job from employee");
  9.  
  10. model = (DefaultTableModel)empTable.getModel();
  11.  
  12. model.setRowCount(0);
  13. while(rs.next()){
  14. String row[]={rs.getString(1),rs.getString(2),rs.getString(3),rs.getString(4),rs.getString(5),rs.getString(6),rs.getString(7)};
  15. model.addRow(row);
  16. }
  17.  
  18. connect.close();
  19.  
  20. }
  21. catch(SQLException sqe){
  22. System.out.println("SQL error: " + sqe.toString());
  23. }
  24. catch(ClassNotFoundException cnf) {
  25. System.out.println("Class not found error : " + cnf.toString());
  26. }
  27.  
  28. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement