登录时从数据库填充 JTable

我正在使用 JDBC 从 Oracle 数据库连接填充 JTable。它目前正在工作，但我正在尝试对破坏它的代码进行修改。

目前，它在创建 JTable 时通过查询数据库来填充 JTable。

我正在尝试将此功能移至 ActionListener。基本上，我想创建一个空表，然后当用户按下 JButton 时，它应该运行 sql 查询并填充和重绘该表。我已经尝试了我能想到的一切，我忍不住认为这是一个基本的，但我的逻辑让我失败。

目前的实施：

private void makeTable() {
    Vector columnNames = new Vector();
    Vector data = new Vector();
    String userName = "aUsername";
    String password = "aPassword";
    try {
        DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
        Connection connection = DriverManager.getConnection("redactedDatabaseConnection", userName, password);
        String sql = "select upper(choreName) as Chore, dueDate as due, completedDate as completed, fname as completedby from chore inner join choreCompletion on chore.choreid = chorecompletion.choreid inner join users on users.userID = choreCompletion.completedby";  

        Statement statement = connection.prepareStatement(sql);
        ResultSet rset = statement.executeQuery(sql);
        ResultSetMetaData metaData = rset.getMetaData();
        int columns = metaData.getColumnCount();
        for (int i = 1; i <= columns; i++) {
            columnNames.addElement(metaData.getColumnName(i));
        }
        while (rset.next()) {
            Vector row = new Vector(columns);
            for (int i = 1; i <= columns; i++) {
                row.addElement(rset.getObject(i));
            }
            data.addElement(row);
        }
        rset.close();
        statement.close();
        connection.close();
    } catch (SQLException ex) {ex.printStackTrace();}
    JTable choresTable = new JTable(data, columnNames);
    TableColumn column;
    for (int i = 0; i<choresTable.getColumnCount(); i++) {
        column = choresTable.getColumnModel().getColumn(i);
        column.setMaxWidth(250);
    }
    JScrollPane scrollPane = new JScrollPane(choresTable);
    scrollPane.getViewport().setBackground(new Color(144, 167, 204));
}

编辑： 目前尝试实施

import javax.swing.*;
import javax.swing.table.*;
import java.awt.*;
import java.awt.event.*;
import java.sql.*;
import java.util.Vector;

@SuppressWarnings("unchecked")
public class FillTable extends JFrame
{
private Vector columnNames, data, row;
private Connection connection;
private final String dbUsername = "aUsername";
private final String dbPassword = "aPassword";

private JTable groceryTable;
private TableColumn column;
private JScrollPane pane;
private JPanel panel;

public FillTable()
{
    try {
        DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
    } catch(Exception e){
        e.printStackTrace();
    }
    createComponents();
    setSize(800,800);
    setTitle("A filled Table");
}

public static void main(String[] args)
{
    JFrame frame = new FillTable();
    frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
    frame.setUndecorated(false);
    frame.setLocationRelativeTo(null);
    frame.setResizable(true);
    frame.setVisible(true);
}

class ButtonListener implements ActionListener
{
    public void actionPerformed(ActionEvent e)
    {
        try {
            connection = DriverManager.getConnection("redactedServerInfo", dbUsername, dbPassword);
            String sql = "select upper(name) as Grocery, fname as ordered_by, dateordered as date_ordered from groceries inner join grocerylist on groceries.groceryid=grocerylist.groceryid inner join users on grocerylist.orderedby= users.userid";  
            Statement statement = connection.prepareStatement(sql);
            ResultSet rset = statement.executeQuery(sql);
            ResultSetMetaData metaData = rset.getMetaData();
            int columns = metaData.getColumnCount();
            for (int i=1; i<= columns; i++) {
                columnNames.addElement(metaData.getColumnName(i));
            }
            while (rset.next()) {
                row = new Vector(columns);
                for(int i=1;i<=columns;i++) {
                    row.addElement(rset.getObject(i));
                }
                data.addElement(row);
            }
            rset.close();
            statement.close();
        } catch (Exception ex) {
            ex.printStackTrace();
        }

        for(int i=0;i<groceryTable.getColumnCount(); i++) {
            column = groceryTable.getColumnModel().getColumn(i);
            column.setMaxWidth(250);
        }
        pane.repaint();
        pane.revalidate();
        groceryTable.repaint();
        groceryTable.revalidate();
        panel.repaint();
        panel.revalidate();
        repaint();
        revalidate();
    }
}

private void createComponents()
{
    JButton button = new JButton("Press me");

    ActionListener buttonListener = new ButtonListener();
    button.addActionListener(buttonListener);

    columnNames = new Vector();
    data = new Vector();
    row = new Vector();

    groceryTable = new JTable(data, columnNames);

    pane = new JScrollPane(groceryTable);

    panel = new JPanel();
    panel.add(button);
    panel.add(pane);
    add(panel);
}   

}

创建包含 0 行作为字段的表。

After

connection.close();

Do

choresTable.setModel(new DefaultTableModel(data, columnNames));

因此，带有模型的临时表创建代码可以移至通用创建代码。

设置model https://docs.oracle.com/javase/9/docs/api/javax/swing/table/DefaultTableModel.html足以重绘。