使用Jackson将Postgres嵌套JSON记录反序列化为POJO

你的需求是把PostgreSQL返回的JSON结构转成类似Python字典的Java灵活结构，无需自定义反序列化器，Jackson原生就支持这种场景，下面是两种最便捷的实现方式：

方式一：反序列化为Map<String, Map<String, Object>> #

直接修改DTO类的字段类型为嵌套Map，Jackson会自动完成反序列化逻辑：

import com.fasterxml.jackson.annotation.JsonAlias;
import java.util.Map;

public class PaymentConfigDTO {
    @JsonAlias({"secrets"})
    private Map<String, Map<String, Object>> processorCredentials;

    // 生成Getter和Setter方法
    public Map<String, Map<String, Object>> getProcessorCredentials() {
        return processorCredentials;
    }

    public void setProcessorCredentials(Map<String, Map<String, Object>> processorCredentials) {
        this.processorCredentials = processorCredentials;
    }
}

反序列化及取值示例 #

假设从数据库拿到字符串形式的JSON数据：

import com.fasterxml.jackson.databind.ObjectMapper;

public class Main {
    public static void main(String[] args) throws Exception {
        String dbJson = "{\"flutterwave\": {\"secret\": \"SECRET KEYS\"}, \"dlocal\": {\"xkey\": \"X KEY VALUE\", \"xlogin\": \"X LOGIN VALUE\"}}";
        ObjectMapper objectMapper = new ObjectMapper();
        
        PaymentConfigDTO dto = objectMapper.readValue(dbJson, PaymentConfigDTO.class);
        
        // 直接获取嵌套键值对
        String flutterwaveSecret = dto.getProcessorCredentials().get("flutterwave").get("secret").toString();
        String dlocalXkey = dto.getProcessorCredentials().get("dlocal").get("xkey").toString();
    }
}

方式二：使用JsonNode动态取值 #

如果不需要强类型约束，也可以用Jackson的JsonNode类型，它和Python字典的使用逻辑类似，支持动态获取嵌套值：

import com.fasterxml.jackson.annotation.JsonAlias;
import com.fasterxml.jackson.databind.JsonNode;

public class PaymentConfigDTO {
    @JsonAlias({"secrets"})
    private JsonNode processorCredentials;

    // Getter和Setter方法
    public JsonNode getProcessorCredentials() {
        return processorCredentials;
    }

    public void setProcessorCredentials(JsonNode processorCredentials) {
        this.processorCredentials = processorCredentials;
    }
}

取值示例 #

// 反序列化后直接取值
String flutterwaveSecret = dto.getProcessorCredentials().get("flutterwave").get("secret").asText();
// 用path()方法可避免空指针，键不存在时返回默认值
String fallbackValue = dto.getProcessorCredentials().path("unknown").path("key").asText("default");

处理PostgreSQL原生JSON类型 #

如果JDBC驱动返回的是PostgreSQL专属的PGobject类型（而非字符串），可先转换为字符串再反序列化：

PGobject pgJson = (PGobject) resultSet.getObject("your_json_column");
String jsonStr = pgJson.getValue();
// 后续用ObjectMapper反序列化即可

内容的提问来源于stack exchange，提问作者Oluwaseun Peter