无法使用JAVA从postgres检索JSON列表

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

String url = "jdbc:postgresql://localhost:5432/database_name";
String username = "your_username";
String password = "your_password";

try {
    Connection connection = DriverManager.getConnection(url, username, password);
    // 连接成功后的操作
} catch (SQLException e) {
    e.printStackTrace();
}

try {
    Statement statement = connection.createStatement();
    String query = "SELECT json_column FROM table_name";
    ResultSet resultSet = statement.executeQuery(query);

    while (resultSet.next()) {
        String json = resultSet.getString("json_column");
        // 对JSON数据进行处理
    }

    resultSet.close();
    statement.close();
} catch (SQLException e) {
    e.printStackTrace();
}

import org.json.JSONArray;
import org.json.JSONObject;

// ...

String json = resultSet.getString("json_column");
JSONArray jsonArray = new JSONArray(json);

for (int i = 0; i < jsonArray.length(); i++) {
    JSONObject jsonObject = jsonArray.getJSONObject(i);
    // 处理每个JSON对象
}