Advertisement
Guest User

Untitled

a guest
Feb 19th, 2019
112
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.17 KB | None | 0 0
  1. model = DatabaseHelper.LoadData() // returns a default table model with new data.
  2. tabel = new JTable();
  3. tabel.setModel();
  4.  
  5. public void initGUI(){
  6.  
  7. setJMenuBar(makeMenuBar());
  8. container = new JPanel(new BorderLayout());
  9.  
  10. model = db.initialiseTable(); // Load initialisation data from the database
  11.  
  12. table = new JTable();
  13. table.setModel(model);
  14. table.setPreferredScrollableViewportSize(new Dimension(500, 70));
  15. table.setFillsViewportHeight(true);
  16. scrollPane = new JScrollPane(table);
  17.  
  18. container.add(scrollPane, BorderLayout.CENTER);
  19. add(container);
  20. }
  21.  
  22. public DefaultTableModel loadData(){
  23. try {
  24. Class.forName("com.mysql.jdbc.Driver");
  25. con = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/version1", "root", "root");
  26. System.out.println("nDatabase Connection Established.n");
  27.  
  28. String query = "SELECT * FROM table WHERE test_number = 2";
  29.  
  30. stmt = con.createStatement();
  31. rs = stmt.executeQuery( query );
  32.  
  33. md = rs.getMetaData();
  34. columns = md.getColumnCount();
  35.  
  36. while (rs.next()) {
  37. Vector row = new Vector(columns);
  38.  
  39. for (int i = 1; i <=columns-1; i++){
  40. row.addElement( rs.getObject(i+1) );
  41. }
  42. data.addElement( row );
  43. }
  44. }catch(SQLException e){
  45. e.printStackTrace();
  46. }catch(ClassNotFoundException e){
  47. e.printStackTrace();
  48. }
  49.  
  50. columnNames.add(" ");
  51. columnNames.add("Column 1");
  52. columnNames.add("Column 2");
  53.  
  54. DefaultTableModel model = new DefaultTableModel(data, columnNames);
  55.  
  56. return model;
  57. }
  58.  
  59. model = new DefaultTableModel();
  60. model = db.loadData();
  61.  
  62. table = new JTable();
  63. table.setModel(model);
  64.  
  65. model = DatabaseHelper.LoadData() // returns a default table model with new data.
  66. tabel = new JTable();
  67. tabel.setModel();
  68.  
  69. model = new DefaultTableModel();
  70. model = db.loadData();
  71.  
  72. table = new JTable();
  73. table.setModel(model);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement