Guest User

Untitled

a guest
Jan 15th, 2019
108
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.78 KB | None | 0 0
  1. try {
  2. Connection con1;
  3. PreparedStatement insert;
  4. Class.forName("com.mysql.jdbc.Driver");
  5. con1 = DriverManager.getConnection("jdbc:mysql://localhost/javapos","root","");
  6. insert = con1.prepareStatement("SELECT name,status FROM category");
  7. ResultSet Rs = insert.executeQuery();
  8. while(Rs.next()){
  9. DefaultTableModel model = (DefaultTableModel) jTable1.getModel();
  10. String name = Rs.getString("name");
  11. String status = Rs.getString("status");
  12. model.addRow(new Object[]{name,status });
  13. }
  14. jTable1.setModel(model);
  15. } catch (Exception e) {
  16.  
  17. System.out.println("Failed " + e);
  18.  
  19. }
  20. }
Add Comment
Please, Sign In to add comment