使用TableModel刷新JTable中的数据时出错

Question

我正在尝试从 JTable 刷新数据。

此方法从数据库中选择数据：

public Object[][] getData() {
    Object[][] data = new Object[15][10];
    try {

        String query = "SELECT * from emailApp";
        rs = st.executeQuery(query);


        int i = 0;
        while (rs.next()) {
            int id = rs.getInt("id");
            int priority = rs.getInt("priority");
            String sender = rs.getString("sender");
            String recipient = rs.getString("recipient");
            String labelDb = rs.getString("label");
            String subject = rs.getString("subject");
            String message = rs.getString("message");


            data[i][0] = id;
            data[i][1] = sender;
            data[i][2] = priority;
            data[i][3] = recipient;
            data[i][4] = labelDb;
            data[i][5] = subject;
            data[i][6] = message;
            i++;

            if(i>15) break;

        }

    } catch(Exception ex) {
        System.out.println(ex);
    }

    return data;
}

然后我使用这个方法来刷新JTable中的数据:

public void setUpTableData() {
DefaultTableModel model = (DefaultTableModel) table.getModel();
DBConnect connect = new DBConnect();
Object[][] data = connect.getData();
Object[] modelData = new Object[15];

model.setRowCount(0);
for(int i = 0; i<15; i++) {
    if(data[i][0] == null) break;
    modelData[0] = data[i][0];
    modelData[1] = data[i][1];
    modelData[2] = data[i][2];
    modelData[3] = data[i][3];
    modelData[4] = data[i][4];
    modelData[5] = data[i][5];
    modelData[6] = data[i][6];

    model.addRow(data);
    }   

model.fireTableDataChanged();
table.setModel(model);
}

错误：线程“AWT-EventQueue-0”中的异常 java.lang.ClassCastException： javax.swing.JTable$1 无法强制转换为 javax.swing.table.DefaultTableModel

然后我按下一个按钮来调用这个方法。有人能告诉我我做错了什么吗。非常感谢。

Answer 1

所以，多亏了MadProgrammer，我想通并解决了这个问题（以防有人有同样的问题）

public void refreshData() {
    DBConnect connect = new DBConnect(); 
    Object[][] data = connect.getData(); // collecting the data from DataBase after inserting, updating
    DefaultTableModel model = new DefaultTableModel(data, columnNames);  // creating a new DefaultTableModel with the new data
    table.setModel(model); // setting the DefaultTableModel to the table - Refreshing the table
}