Modifying column headers of JTable with MySQL data

Question

I have a JTable that retrieves information from a MySQL database table. The column headers are named just like how they are in the database.

Here is the code to create the JTable:

JScrollPane spBlockViewSchedule = new JScrollPane();
spBlockViewSchedule.setBounds(10, 285, 763, 185);
pnlBlockSched.add(spBlockViewSchedule);

tblBlockViewSchedule = new JTable();
spBlockViewSchedule.setViewportView(tblBlockViewSchedule);

Here is the code that populates the JTable:

private void populateTable(String sql, JTable table) {
        try {
            pst = DbConnection.conn.prepareStatement(sql);
            rs = pst.executeQuery();

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

        table.setModel(DbUtils.resultSetToTableModel(rs));
    }

How do I change the column names displayed in the JTable without changing the column names of the database table itself?

Answer 1

Create an empty DefaultTableModel with code like:

String[] columnNames = {"Course Code", "Subject Code", "Year Level", ...};
DefaultTableModel model = new DefaultTableModel(columnNames, 0);

Then in the code where you read the data from the ResultSet you add the data to the TableMOdel using the addRow(....) method. Something like:

while (rs.next())
{
   Vector row = new Vector();

    for (int i = 1; i <= columns; i++)
    {
        row.addElement( rs.getObject(i) );
    }

    model.addRow( row );
}

Finaly you create the table using:

JTable table = new JTable( model );

Edit:

Since you are using 3rd party code you either need to change the way you add data to the model. I gave you basic code above. You can see the Table From Database Example source code from Table From Database for a complete example.

Or, you can modify the column headers after the table is created with code like:

table.getColumn("course_code").setHeaderValue("Course Code");
...
table.repaint();

Edit 2:

You can get the TableColumn from the TableColumnModel:

TableColumnModel tcm = table.getTableColumnModel();
tcm.getColumn(0).setHeaderValue("Course Code");
...
table.repaint();