Fetching column name with table from database

Question

I want to display column name row while accessing table. Here I tried this code... but only table displayed without column name. using java eclipse and sqlite database

    try
    {
        String query="Select * from client";
        PreparedStatement pst=conn.prepareStatement(query);
        ResultSet rs=pst.executeQuery();

        ResultSetMetaData rsmd = rs.getMetaData();
        int columnCount = rsmd.getColumnCount();

        DefaultTableModel tm = (DefaultTableModel) table.getModel();

        for(int i=1;i<=columnCount;i++)
        {
            tm.addColumn(rsmd.getColumnName(i));
        }

        while (rs.next()) 
        {
            String[] a = new String[columnCount];
            for(int i = 0; i < columnCount; i++)
            {
                a[i] = rs.getString(i+1);

            }
            tm.addRow(a);
    //      tm.fireTableDataChanged();

            rs.close();
            pst.close();
        } 
    } 

        catch(Exception e)
        {
            e.printStackTrace();
        }
}

I think (but I'm unsure what you are asking) that the code for resultSetToTableModel might help you get an answer — user180100
– user180100, Commented Mar 2, 2017 at 12:41

user3145373 ツ · Accepted Answer · 2017-03-02 13:03:30Z

3

You can use following code to get column names:

ResultSetMetaData metaData = rs.getMetaData();
int count = metaData.getColumnCount(); // get column count

for (int i = 1; i <= count; i++){
   System.out.println(metaData.getColumnLabel(i));
}

answered Mar 2, 2017 at 13:03

user3145373 ツ

8,1857 gold badges51 silver badges66 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

G.S Over a year ago

Sir, by using s.o.p displayed on console...but want to display table in swing using JTable component...so which method I have to use instead of s.o.p ?

user3145373 ツ Over a year ago

hello @G.S.. please go through stackoverflow.com/questions/21898053/… it will help you.

Ravi MCA · Accepted Answer · 2017-03-03 07:46:02Z

2

ResultSet always contains the returned rows but not the column names.

To get the column names you can use below code.

ResultSetMetaData metadata = rs.getMetaData();

int columnCount = metadata.getColumnCount();

String column_names[] = new String[ columnCount ]; // define a array to store the column names

for (int i=0; i<=columnCount; i++) {

  column_names[ i ] = metadata.getColumnLabel(i); // push column names into array
}

DefaultTableModel table_model = new DefaultTableModel( column_names, columnCount ); // create a table model based of the columns and column count

table=new JTable( table_model ); // create a new table with that model

edited Mar 3, 2017 at 7:46

answered Mar 2, 2017 at 12:59

Ravi MCA

2,6414 gold badges23 silver badges35 bronze badges

3 Comments

G.S Over a year ago

Thank you sir...but get error...java.lang.ArrayIndexOutOfBoundsException: 11

Ravi MCA Over a year ago

@G.S My bad typo error. Just initialize i=0 instead i=1

Ravi MCA Over a year ago

@G.S could you update your question with new code and error exception

Vijayan Kani · Accepted Answer · 2017-03-02 12:47:31Z

1

String column_i = table.getModel().getColumnName(i);

Iterate through 'i'; as it represents the index of the column. Cheers!

answered Mar 2, 2017 at 12:47

Vijayan Kani

3683 silver badges9 bronze badges

1 Comment

G.S Over a year ago

I tried it......................... int i = 0; String column_i = table.getModel().getColumnName(i);................Sir nothing to display in table

camickr · Accepted Answer · 2017-03-03 15:46:40Z

0

JScrollPane pane = new JScrollPane(table);
contentPane.add(table);
JscrollPane.add(table);

The above code is all confused:

First you create a scrollpane using the table (which is correct), but then you add the table to the content pane (which is incorrect). A table can only have a single parent so it gets removed from the scrollpane.
Then you try to add the table back to the scrollpane which won't work because you need to add the table to the viewport of the scrollpane, not the scrollpane directly.

So bottom line all you need is:

JScrollPane pane = new JScrollPane(table);
//contentPane.add(table);
//JscrollPane.add(table);

Edit:

First get the code working without the SQL. Use the above suggestion and then change your current code:

//table.setModel(DbUtils.resultSetToTableModel(rs));   
table.setModel( new DefaultTableModel(5,5) );

This should display an empty table with 5 rows and 5 columns.

If you see the table then the problem is with your SQL, you are returning an empty ResultSet.
If you don't see the table then you have a problems somewhere else in your code.

edited Mar 3, 2017 at 15:46

answered Mar 2, 2017 at 16:28

camickr

325k21 gold badges174 silver badges293 bronze badges

4 Comments

G.S Over a year ago

I did...but table not displayed...and here I directly form table in swing by using JTable

camickr Over a year ago

@G.S, see edit. You need to do some basic debugging by simplifying the problem.

G.S Over a year ago

@camickr...I get whole table with all data...but only header part(where column names are there) not displays..even not getting

camickr Over a year ago

@G.S, if you don't get rows of data then your SQL query is wrong.

Collectives™ on Stack Overflow

Fetching column name with table from database

4 Answers 4

2 Comments

3 Comments

1 Comment

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

3 Comments

1 Comment

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related