Java-Swing:在数据库中检索和更新详细信息

import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import java.sql.*;

public class DatabaseApp extends JFrame {
    private JTable table;
    private JScrollPane scrollPane;

    public DatabaseApp() {
        setTitle("Database App");
        setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
        setSize(400, 300);

        // 创建表格和滚动面板
        table = new JTable();
        scrollPane = new JScrollPane(table);

        // 添加滚动面板到窗口
        add(scrollPane);

        // 连接数据库并检索数据
        try {
            // 加载数据库驱动
            Class.forName("com.mysql.jdbc.Driver");

            // 建立数据库连接
            Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/mydatabase", "username", "password");

            // 创建查询语句
            Statement statement = connection.createStatement();
            String query = "SELECT * FROM mytable";

            // 执行查询
            ResultSet resultSet = statement.executeQuery(query);

            // 创建数据模型
            DefaultTableModel model = new DefaultTableModel();

            // 获取列数
            ResultSetMetaData metaData = resultSet.getMetaData();
            int columnCount = metaData.getColumnCount();

            // 添加列名到数据模型
            for (int i = 1; i <= columnCount; i++) {
                model.addColumn(metaData.getColumnName(i));
            }

            // 添加行数据到数据模型
            while (resultSet.next()) {
                Object[] rowData = new Object[columnCount];
                for (int i = 1; i <= columnCount; i++) {
                    rowData[i - 1] = resultSet.getObject(i);
                }
                model.addRow(rowData);
            }

            // 设置数据模型到表格
            table.setModel(model);

            // 关闭数据库连接
            resultSet.close();
            statement.close();
            connection.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }

    public static void main(String[] args) {
        SwingUtilities.invokeLater(new Runnable() {
            public void run() {
                new DatabaseApp().setVisible(true);
            }
        });
    }
}