使用DefaultTableModel插入后未刷新JTable

Question

public class GUIClients {

ClientDatabase cDB = new ClientDatabase();
DefaultTableModel tableModel = new DefaultTableModel();

JTable table = new JTable(tableModel);

JScrollPane scrollPane = new JScrollPane(table);
JPanel panel = new JPanel(new BorderLayout());

public JPanel createPanel() {
    cDB.createTable(tableModel);
    table.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);
    panel.add(scrollPane);
    panel.add(table, BorderLayout.CENTER);
    panel.add(table.getTableHeader(), BorderLayout.NORTH);
    ...
    return panel;
}

public class InsertDialog extends GUIClients {
...
saveB = new JButton("Save");
    saveB.addActionListener(new ActionListener() {
        public void actionPerformed(ActionEvent e) {
            try {
                cl = cDB.getClient(InsertDialog.this);   
                cDB.insert(cl);

                tableModel.setRowCount(0);

                cDB.createTable(tableModel);
                table.setModel(tableModel);

                dialogPanel.dispose();
            } catch (SQLException ex) {
                System.out.println(ex.getMessage());
            }
        }
    });
dialogPanel.add(saveB);
...

public class ClientDatabase implements Database {

public static ResultSet rs;

public void createTable(DefaultTableModel d) {
    try {
        d.addColumn("ID");
        d.addColumn("Name");
        d.addColumn("Surname");
        d.addColumn("Mobile");
        d.addColumn("Email");
        d.addColumn("Notes");

        rs.beforeFirst();
        while (rs.next()) {
            int id = rs.getInt("ID");
            String name = rs.getString("NAME");
            String surname = rs.getString("SURNAME");
            String mobile = rs.getString("MOBILE");
            String email = rs.getString("EMAIL");
            String notes = rs.getString("NOTES");
            d.addRow(new Object[]{id, name, surname, mobile, email, notes});
        }

    } catch (SQLException e) {
        System.out.println(e.getMessage());
    }

}
...

Answer 1

我有一个方法，它成功地插入一个新记录到我的数据库。

然后您还负责同时将数据添加到TableModel中。

您可以使用DefaultTableModel的AddRow(...)或InsertRow(..)方法更新TableModel中的日期，然后JTable将被更新。