如何将ResultSet对象转换为JSON格式输出

import java.sql.*;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import com.google.gson.Gson;

public class ResultSetToJson {
    public static void main(String[] args) {
        // 创建一个ResultSet对象
        ResultSet resultSet = getResultSet();

        // 将ResultSet对象转换为JSON格式输出
        String json = resultSetToJson(resultSet);
        System.out.println(json);
    }

    private static ResultSet getResultSet() {
        // 创建一个ResultSet对象
        // 这里只是一个示例，实际情况下需要根据具体情况创建ResultSet对象
        try {
            Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root", "password");
            Statement statement = connection.createStatement();
            ResultSet resultSet = statement.executeQuery("SELECT * FROM users");
            return resultSet;
        } catch (SQLException e) {
            e.printStackTrace();
            return null;
        }
    }

    private static String resultSetToJson(ResultSet resultSet) {
        List<Map<String, Object>> list = new ArrayList<>();
        try {
            ResultSetMetaData metaData = resultSet.getMetaData();
            int columnCount = metaData.getColumnCount();
            while (resultSet.next()) {
                Map<String, Object> map = new HashMap<>();
                for (int i = 1; i <= columnCount; i++) {
                    String columnName = metaData.getColumnName(i);
                    Object value = resultSet.getObject(i);
                    map.put(columnName, value);
                }
                list.add(map);
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }

        Gson gson = new Gson();
        String json = gson.toJson(list);
        return json;
    }
}

implementation 'com.google.code.gson:gson:2.8.9'