public class UpdateColumnJsonUtils {
    public static void main(String[] args) {
        String jsonString = "{\n" +
                "    \"scriptResult\": {\n" +
                "        \"loan_app_count\": 3,\n" +
                "        \"app_num_ratio_3\": 0.8,\n" +
                "        \"gender_data\": {\n" +
                "            \"a\":\"1\",\n" +
                "            \"c\":\"3\"\n" +
                "        }\n" +
                "    }\n" +
                "}";
        String newJsonString = "{\n" +
                "    \"scriptResult\": {\n" +
                "        \"loan_app_count\": 5,\n" +
                "        \"app_num_ratio_4\": 1,\n" +
                "        \"gender_data\": {\n" +
                "            \"a\":\"1\",\n" +
                "            \"b\":\"2\",\n" +
                "            \"d\":\"4\",\n" +
                "            \"e\":\"d5\"\n" +
                "        }\n" +
                "    }\n" +
                "}";
            System.out.println(getColumnJson(jsonString,newJsonString));
    }
    public static Map<String,Object> getColumnJson(String oldJsonString,String newJsonString) {
        // 將原始的JSON字符串轉(zhuǎn)換為JSONObject
        JSONObject originalJsonObject = JSON.parseObject(oldJsonString);
        JSONObject newJsonObject = JSON.parseObject(newJsonString);
        // 更新原始JSON對象中的對應鍵值對
        updateJsonObject(originalJsonObject, newJsonObject);
        // 將更新后的JSONObject轉(zhuǎn)換回JSON字符串
        Map<String,Object> map = originalJsonObject.getInnerMap();
        return map;
    }
    private static void updateJsonObject(JSONObject originalObject, JSONObject newObject) {
        for (String key : newObject.keySet()) {
            Object newValue = newObject.get(key);
            Object oldValue = originalObject.get(key);
            if (oldValue instanceof JSONObject && newValue instanceof JSONObject) {
                // 如果新舊值都是JSONObject，則遞歸更新嵌套的JSON對象
                updateJsonObject((JSONObject) oldValue, (JSONObject) newValue);
            } else {
                // 否則，直接更新對應鍵的值
                originalObject.put(key, newValue);
            }
        }
    }
}

{scriptResult={"loan_app_count":5,"gender_data":{"a":"1","b":"2","c":"3","d":"4","e":"d5"},"app_num_ratio_4":1,"app_num_ratio_3":0.8}}