在Java中将表数据读入二维数组

import java.sql.*;

public class ReadTableData {
    public static void main(String[] args) {
        String url = "jdbc:mysql://localhost:3306/mydatabase";
        String username = "root";
        String password = "password";
        String tableName = "mytable";
        
        try {
            // 连接数据库
            Connection connection = DriverManager.getConnection(url, username, password);
            
            // 执行查询语句
            Statement statement = connection.createStatement();
            String query = "SELECT * FROM " + tableName;
            ResultSet resultSet = statement.executeQuery(query);
            
            // 获取表的元数据
            ResultSetMetaData metaData = resultSet.getMetaData();
            int columnCount = metaData.getColumnCount();
            int rowCount = 0;
            
            // 计算表的行数
            while (resultSet.next()) {
                rowCount++;
            }
            
            // 创建二维数组
            String[][] tableData = new String[rowCount][columnCount];
            
            // 重新执行查询语句，将数据存储到二维数组中
            resultSet = statement.executeQuery(query);
            int row = 0;
            
            // 读取表数据并存储到二维数组中
            while (resultSet.next()) {
                for (int col = 0; col < columnCount; col++) {
                    tableData[row][col] = resultSet.getString(col + 1);
                }
                row++;
            }
            
            // 关闭连接
            resultSet.close();
            statement.close();
            connection.close();
            
            // 打印二维数组中的数据
            for (int i = 0; i < rowCount; i++) {
                for (int j = 0; j < columnCount; j++) {
                    System.out.print(tableData[i][j] + "\t");
                }
                System.out.println();
            }
            
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}