Guest User

Untitled

a guest
Dec 6th, 2017
117
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.94 KB | None | 0 0
  1. private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
  2. // TODO add your handling code here:
  3.  
  4. DefaultTableModel model = new DefaultTableModel(new String[]{"Heading 1", "Heading 2", "Heading 3"}, 0);
  5. try {
  6.  
  7.  
  8.  
  9. Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/mysql", "root", "");
  10.  
  11. Statement stmt = conn.createStatement();
  12.  
  13. String sql = "SELECT * FROM tablename";
  14. ResultSet rs = stmt.executeQuery(sql);
  15. while (rs.next()) {
  16. String v1 = rs.getString("className");
  17. String v2 = rs.getString("homeWork");
  18. String v3 = rs.getString("dueDate");
  19.  
  20. model.addRow(new Object[]{v1,v2, v3});
  21. }
  22. jTable1.setModel(model);
  23. } catch (SQLException ex) {
  24.  
  25. }
  26.  
  27. }
Add Comment
Please, Sign In to add comment