如何在单个JTable中连接来自两个不同表的数据

// 导入必要的类和包
import javax.swing.*;
import javax.swing.table.DefaultTableModel;
import java.sql.*;

public class JTableExample {
    public static void main(String[] args) {
        // 创建JFrame和JTable
        JFrame frame = new JFrame();
        JTable table = new JTable();

        // 创建TableModel对象
        DefaultTableModel model = new DefaultTableModel();

        // 从两个不同表中获取数据并合并
        try {
            // 连接数据库
            Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/mydatabase", "username", "password");

            // 执行查询语句
            Statement statement = connection.createStatement();
            ResultSet resultSet = statement.executeQuery("SELECT * FROM table1 JOIN table2 ON table1.id = table2.id");

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

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

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

            // 关闭连接
            resultSet.close();
            statement.close();
            connection.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }

        // 设置TableModel为JTable的数据模型
        table.setModel(model);

        // 将JTable添加到JFrame中
        frame.add(new JScrollPane(table));

        // 设置JFrame属性并显示
        frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
        frame.pack();
        frame.setVisible(true);
    }
}