Column header name in JTable, Java

Question

I am filling a JTable with data from a database. I am have subclassed AbstractTableModel and passed the reference to the JTable. However, how do I manage to extract the column names in the database and set them as "headers" in the JTable?

Thanks in advance.

I already have this, in the console the header names display but I do not have a column in the GUI. I have attached the JTable to a tab in a tabbed pane.

@Override
public String getColumnName(int column) {
    try {
        System.out.println(dbhandler.getMetaData().getColumnName(column + 1));
        return dbhandler.getMetaData().getColumnName(column + 1);
    } catch (SQLException e) {
        e.printStackTrace();
        return "";
    }
}

What is currently displayed for the column headers? The default A, B, C..etc? — Stewart Murrie, Jan 29 '11 at 21:07

score 5 · Accepted Answer · answered Jan 29 '11 at 21:17

However, how do I manage to extract the column names in the database and set them as "headers" in the JTable?

Your table model needs to implement the getColumnName() method. Then you need to create your table model with data first. Then you create your JTable using the table model and the table will build the columns for you.

See Table from Database for code that provides a reusable table model as well as a method to populate the table for you automatically.

I do not have any columns at all, it is all rows...

You need to add the table to a JScrollPane (not a JPanel) and the headers will appear as the column header view of the scroll pane:

JScrollPane scrollPane = new JScrollPane( table );

I have done everything on your list 5 hours ago, BUT not added it to a scrollpane. Thank you so much! — LuckyLuke, Jan 29 '11 at 21:25

score 1 · Answer 2 · answered Jan 29 '11 at 20:04

1

You can do it by overriding getColumnName(int i) method of AbstractTableModel, and put your "header" Strings in this method.

answered Jan 29 '11 at 20:04

Rogach

26,050
21
93
172

score 1 · Answer 3 · answered Jan 29 '11 at 20:22

1

How do you get your data? With a "SELECT * FROM foo"?

Interface: java.sql.DatabaseMetaData

getColumns(String catalog, String schemaPattern, String tableNamePattern, String columnNamePattern) Retrieves a description of table columns available in the specified catalog.

answered Jan 29 '11 at 20:22

user unknown

35,537
11
75
121

I am sorry, but I do not understand. Could you give an example. Yes my sql query is SELECT * FROM tablename – LuckyLuke Jan 29 '11 at 20:30

score 1 · Answer 4 · answered Jan 29 '11 at 20:44

1

Did you override getColumnCount also?

answered Jan 29 '11 at 20:44

Bogdan

5,368
9
43
62

user unknown · Answer 5 · 2011-01-30T03:49:55.553

private void getColumnsFromDB (Connection connection, String tname) throws SQLException
{
    String query = "SELECT * FROM " + tname;
    Statement stmt = connection.createStatement ();
    ResultSet res = stmt.executeQuery (query);
    ResultSetMetaData rsmd = res.getMetaData ();
    int numberOfColumns = rsmd.getColumnCount ();
    boolean searchable = rsmd.isSearchable (1);
    if (searchable)
    {
        for (int j = 1; j <= numberOfColumns; ++j)
        {
            Column col = new Column (tname, rsmd, j);
            // do something with Column (col);
        }
    }
}

Class Column, Ctor:

public Column (String t, ResultSetMetaData rsmd, int j) throws SQLException
{
    table = t;
    name = rsmd.getColumnName (j);
    schema = rsmd.getSchemaName (j);
    precision = -1;
    try
    {
        precision = rsmd.getPrecision (j);
    }
    catch (NumberFormatException nfe)
    {
        System.err.println ("nfe[gtd]: " + nfe + " " + t.getName () + "." + name);
    }
    scale = rsmd.getScale (j);
    catName = rsmd.getCatalogName (j);
    coltype = rsmd.getColumnType (j);
    coltypeName = rsmd.getColumnTypeName (j);
    int nulling = rsmd.isNullable (j);
    nullable = NULLTYP [nulling];
}

I hope it works, because this code is part of a much larger Codebase, and it's long ago I worked with it.

Column header name in JTable, Java

5 Answers5