如何在Java中解析Oracle 11g查询并生成JSON作为输出

Connection connection = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe", "username", "password");
Statement statement = connection.createStatement();
ResultSet resultSet = statement.executeQuery("SELECT * FROM your_table");

import com.fasterxml.jackson.databind.ObjectMapper;

// 创建ObjectMapper对象
ObjectMapper objectMapper = new ObjectMapper();

// 创建一个List来保存查询结果
List<Map<String, Object>> resultList = new ArrayList<>();

// 遍历结果集，将每一行数据保存为一个Map
while (resultSet.next()) {
    Map<String, Object> rowMap = new HashMap<>();
    ResultSetMetaData metaData = resultSet.getMetaData();
    int columnCount = metaData.getColumnCount();
    for (int i = 1; i <= columnCount; i++) {
        String columnName = metaData.getColumnName(i);
        Object columnValue = resultSet.getObject(i);
        rowMap.put(columnName, columnValue);
    }
    resultList.add(rowMap);
}

// 将List转换为JSON字符串
String json = objectMapper.writeValueAsString(resultList);