Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DefaultTableModel dm=(DefaultTableModel)tbl.getModel();
- try{
- Class.forName("java.sql.Driver");
- Connection conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/gunu","root","tiger");
- Statement stmt=conn.createStatement();
- String qry="select * from teacher;";
- ResultSet rs=stmt.executeQuery(qry);
- while(rs.next()){
- String val1,val2,val3,val4,val5,val6;
- val1=rs.getString("no");
- val2=rs.getString("name");
- val3=rs.getString("age");
- val4=rs.getString("dept");
- val5=rs.getString("dojoin");
- val6=rs.getString("salary");
- Object row[]={val1,val2,val3,val4,val5,val6};
- dm.addRow(row);
- }
- }catch(Exception e){
- System.out.println(e);
- }
Add Comment
Please, Sign In to add comment