Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- model = DatabaseHelper.LoadData() // returns a default table model with new data.
- tabel = new JTable();
- tabel.setModel();
- public void initGUI(){
- setJMenuBar(makeMenuBar());
- container = new JPanel(new BorderLayout());
- model = db.initialiseTable(); // Load initialisation data from the database
- table = new JTable();
- table.setModel(model);
- table.setPreferredScrollableViewportSize(new Dimension(500, 70));
- table.setFillsViewportHeight(true);
- scrollPane = new JScrollPane(table);
- container.add(scrollPane, BorderLayout.CENTER);
- add(container);
- }
- public DefaultTableModel loadData(){
- try {
- Class.forName("com.mysql.jdbc.Driver");
- con = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/version1", "root", "root");
- System.out.println("nDatabase Connection Established.n");
- String query = "SELECT * FROM table WHERE test_number = 2";
- stmt = con.createStatement();
- rs = stmt.executeQuery( query );
- md = rs.getMetaData();
- columns = md.getColumnCount();
- while (rs.next()) {
- Vector row = new Vector(columns);
- for (int i = 1; i <=columns-1; i++){
- row.addElement( rs.getObject(i+1) );
- }
- data.addElement( row );
- }
- }catch(SQLException e){
- e.printStackTrace();
- }catch(ClassNotFoundException e){
- e.printStackTrace();
- }
- columnNames.add(" ");
- columnNames.add("Column 1");
- columnNames.add("Column 2");
- DefaultTableModel model = new DefaultTableModel(data, columnNames);
- return model;
- }
- model = new DefaultTableModel();
- model = db.loadData();
- table = new JTable();
- table.setModel(model);
- model = DatabaseHelper.LoadData() // returns a default table model with new data.
- tabel = new JTable();
- tabel.setModel();
- model = new DefaultTableModel();
- model = db.loadData();
- table = new JTable();
- table.setModel(model);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement