Guest User

Untitled

a guest
Sep 20th, 2016
23
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.74 KB | None | 0 0
  1. DefaultTableModel dm=(DefaultTableModel)tbl.getModel();
  2.  
  3. try{
  4. Class.forName("java.sql.Driver");
  5. Connection conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/gunu","root","tiger");
  6. Statement stmt=conn.createStatement();
  7. String qry="select * from teacher;";
  8. ResultSet rs=stmt.executeQuery(qry);
  9. while(rs.next()){
  10. String val1,val2,val3,val4,val5,val6;
  11. val1=rs.getString("no");
  12. val2=rs.getString("name");
  13. val3=rs.getString("age");
  14. val4=rs.getString("dept");
  15. val5=rs.getString("dojoin");
  16. val6=rs.getString("salary");
  17. Object row[]={val1,val2,val3,val4,val5,val6};
  18. dm.addRow(row);
  19.  
  20. }
  21.  
  22. }catch(Exception e){
  23. System.out.println(e);
  24. }
Add Comment
Please, Sign In to add comment