JTable won't display records from database

[Michael Monchu]

Hi

I am trying to display data from the database on the table, using the Vector approach. I have verified that the Vector is loaded by printing the data on the console. I am not sure why the table won't display the records.
Below is the code:

Vector columns, data;
// Constructor
public MyTable() {

        initComponents();
        connect = new Connector();
        conn = connect.getConnected();
        populateTable();
        table1 = new JTable(data, columns);
        JScrollPane jScrollPane1 = new JScrollPane(table1);
        tblAcquirer.setFillsViewportHeight(true);

}

// method to populate the Vector
public void populateTable(){
        ResultSet res;
        
        String select = "Select * from LIBRARY.TABLE";
        try{
           PreparedStatement rtvStmt = conn.prepareStatement(select);
           res = rtvStmt.executeQuery();
           ResultSetMetaData md = res.getMetaData();
           int columnCount = md.getColumnCount();

           columns = new Vector(columnCount);

           //store column names
           for(int i=1; i<=columnCount; i++)
            columns.add(md.getColumnName(i));

           data = new Vector();
           Vector row;
            
           //store row data
           while(res.next())
           {               
              row = new Vector(columnCount);
              for(int i=1; i<=columnCount; i++)
                {
                   row.add(res.getString(i));
                }
                data.add(row);
           }
            System.out.println(data);
        }
        catch(Exception xcp){
            xcp.printStackTrace();
        }
    } 

I would appreciate any form help or advice to a link where I can get help.

Regards
Michael

[Wouter Oet]

Moved to the Swing forum. Please UseCodeTags when posting code. You can edit your post with the button.

[Rob Camick]

Once a TableModel has been added to the table all updates to the model should be done through the TableModel.

So your code should be restructured to look something like:

DefaultTableModel model = populateTable(); 
table1 = new JTable( model); 

Your populateTable() method would need to change to create and then return the DefaultTableModel.

[Michael Monchu]

Hi Rob

I have modified the code the way you suggested, and it still doesn't display.

DefaultTableModel model;
//public MyTable(){
        model = populateTable();   
        table1 = new JTable(model);   
        JScrollPane jScrollPane1 = new JScrollPane(table1);   
        table1.setFillsViewportHeight(true);   

}

private final DefaultTableModel populateTable(){
        ResultSet res;
        DefaultTableModel tabModel = null;

        // some code retrieving the data from the source and loading the vector
        
         tabModel = new DefaultTableModel(data, columns);
         return tabModel;

I don't know what is it that I am doing wrong. Please help.

Regards
Michael

[Rob Camick]

See Table From Database.

The first part you don't need to worry about (unless you want to try that more complicated solution).

However, the second part contains the "Table From Database Example", which does exactly what you are trying to do. All you need to do is customize the SQL and it should work. Once you get that example working you can compare that code with your code to see what the different is.

If you need more help then you need to post a SSCCE. Of course in your SSCCE you can't include the database code, so you would replace that method with hard coded data that creates the DefaultTableModel. Once you get it working with hard coded data you should be able to replace that code with the SQL code.

[gorgoro rogers]

Michael Monchu wrote:Hi

I am trying to display data from the database on the table, using the Vector approach. I have verified that the Vector is loaded by printing the data on the console. I am not sure why the table won't display the records.
Below is the code:

Vector columns, data;
// Constructor
public MyTable() {

        initComponents();
        connect = new Connector();
        conn = connect.getConnected();
        populateTable();
        table1 = new JTable(data, columns);
        JScrollPane jScrollPane1 = new JScrollPane(table1);
        tblAcquirer.setFillsViewportHeight(true);

}

// method to populate the Vector
public void populateTable(){
        ResultSet res;
        
        String select = "Select * from LIBRARY.TABLE";
        try{
           PreparedStatement rtvStmt = conn.prepareStatement(select);
           res = rtvStmt.executeQuery();
           ResultSetMetaData md = res.getMetaData();
           int columnCount = md.getColumnCount();

           columns = new Vector(columnCount);

           //store column names
           for(int i=1; i<=columnCount; i++)
            columns.add(md.getColumnName(i));

           data = new Vector();
           Vector row;
            
           //store row data
           while(res.next())
           {               
              row = new Vector(columnCount);
              for(int i=1; i<=columnCount; i++)
                {
                   row.add(res.getString(i));
                }
                data.add(row);
           }
            System.out.println(data);
        }
        catch(Exception xcp){
            xcp.printStackTrace();
        }
    } 

I would appreciate any form help or advice to a link where I can get help.

Regards
Michael

replace this and try
public void populateTable(){
ResultSet res;

String select = "Select * from LIBRARY.TABLE";<-------------------------------------------String select
try{
PreparedStatement rtvStmt = conn.prepareStatement(select);
res = rtvStmt.executeQuery(select);<-----------------------------------------------Put here String select
ResultSetMetaData md = res.getMetaData();
int columnCount = md.getColumnCount();


you send an empty executequery you have to fill it .try it .replace also were you have to

[Michael Monchu]

Hi Rob

I used the example that you have provided, and it's working perfectly. Thanks a lot.

Regards
Michael