如何从数据库中获取多个行并将其全部显示为jTextArea或在jLabel中显示？

import java.sql.*;

public class DatabaseExample {
    public static void main(String[] args) {
        try {
            // 1. 连接数据库
            Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/mydatabase", "username", "password");

            // 2. 执行查询语句
            Statement statement = connection.createStatement();
            String query = "SELECT * FROM mytable";
            ResultSet resultSet = statement.executeQuery(query);

            // 3. 处理查询结果
            StringBuilder result = new StringBuilder();
            while (resultSet.next()) {
                // 4. 遍历结果集
                String data = resultSet.getString("column_name"); // 根据列名获取数据
                result.append(data).append("\n");
            }

            // 5. 显示数据
            jTextArea.setText(result.toString());

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