java - 更新数据库后刷新JTable数据

Question

我有一个使用 Netbeans GUI 创建器创建的 JTable，并使用 Vector 对象填充该表。我希望在对数据库进行更改后更新表。我不知道该怎么做。有人可以指导我完成此操作吗？

Answer 1

Try to put this after your update code

rs=st.executeQuery("select * from Table order by columnName");
table.setModel(buildTableModel(rs));



//Create function

private TableModel buildTableModel(ResultSet rs) throws SQLException {
        ResultSetMetaData metaData = rs.getMetaData();
    // names of columns

        Vector<String> columnNames = new Vector<String>();

        int columnCount = metaData.getColumnCount();

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

            columnNames.add(metaData.getColumnName(column));

        }

        // data of the table

        Vector<Vector<Object>> data = new Vector<Vector<Object>>();

        while (rs.next()) {

            Vector<Object> vector = new Vector<Object>();

            for (int columnIndex = 1; columnIndex <= columnCount; columnIndex++) {

                vector.add(rs.getObject(columnIndex));

            }

            data.add(vector);

        }

        return new DefaultTableModel(data, columnNames);
    }