Populate JTable With Database Data

[Joe Mastro]

I am trying to populate a JTable from a jButton event with data that I'm retrieving from an sqlite db. I have no trouble connecting to database and populating the 'data' and 'row' vectors but when I try to pass them to my JTable (jtblReqList) it does not seem to populate. I am under the impression that I should be able to popluate the JTable with the data contained in the vectors without using any of the table models. Any help is appreciated....thanks.

    private void jButton1_actionPerformed(ActionEvent e) {

        try {
            Class.forName("org.sqlite.JDBC");
            Connection conn =
                DriverManager.getConnection("jdbc:sqlite:C:\\sqlite\\Java_Wrapper\\sample.s3db");
            Statement stat = conn.createStatement();
            ResultSet rs;
            rs = stat.executeQuery("select * from User;");
            ResultSetMetaData md = rs.getMetaData();
            int columnCount = md.getColumnCount();
            Vector columns = new Vector(columnCount);

          //store column names
            for(int i=1; i<=columnCount; i++)
              columns.add(md.getColumnName(i));
            
          Vector data = new Vector();
          Vector row;
          
            while (rs.next()) {
             
              row = new Vector(columnCount);
                 for(int i=1; i<=columnCount; i++)
                 {
                     row.add(rs.getString(i));
                 }
                 data.add(row);
                
                //Debugging
                System.out.println("First Name = " + rs.getString("FirstName"));
                System.out.println("Last Name = " + rs.getString("LastName"));              
            }
            
            //Display in JTable
            jtblReqList  = new JTable(data, columns);         
                
            rs.close();
            conn.close();
        } catch (SQLException sqle) {
          JOptionPane.showMessageDialog(new JFrame(), sqle + "\n"+"Please contact your system administrator.","Error",JOptionPane.ERROR_MESSAGE);

            sqle.printStackTrace();
        } catch (ClassNotFoundException cnfe) {
            JOptionPane.showMessageDialog(new JFrame(), cnfe + "\n"+"Please contact your system administrator.","Error",JOptionPane.ERROR_MESSAGE);
            
            cnfe.printStackTrace();
        }
    }

[Paul Clapham]

You're creating a JTable, but I don't see what that has to do with your GUI. I don't see any code where you add that JTable to any GUI.

Typically what you do is to create a GUI, including a JTable. Then when you get the data from the DB you put it into a DataModel, then update the existing JTable by calling its setModel() method (warning... name of method pulled from unreliable memory). Creating a new JTable is generally pointless as it isn't part of the GUI. Trying to get it into the GUI is also difficult to do, but since setting the data model of the one which is already there works, you don't need to futz with that either.

[Rob Spoor]

Welcome to the Ranch, Joe!
Can you please UseCodeTags from now on? I've added them for you, and you can see how much easier it is to read your code.

[Nitin Surana]

May be this link will help you.

http://www.onlinexamples.com/showfullexample.action?idexamples=76&title=Update%20Jtable%20Dynamically%20In%20The%20Gui%20Say%20For%20E.g.%20In%20A%20Jframe

[Joe Mastro]

Awesome, thanks everyone. As Paul stated there was no reason to create a new JTable when I already had one existing on my JFrame. I used the DefaultTable model in Nitin's link and set my JTable (jtblReqList) to the model and this at the very least populated the JTable.

 DefaultTableModel tableModel = new DefaultTableModel(data, columns);
 jtblReqList.setModel(tableModel);