数据库中json对象的数据查询到转换为JsonObject和JsonArray

 //查询数据库
 String sql = "select * from iot_device where device_id = ? ";
 Map <String, Object> m = commonJdbcTemplate.queryForMap(sql, id); 

//JsonArray查出来的格式为：

"things_model_value": "[{\"id\": \"temp_admin\", \"value\": \"\", \"shadow\": \"\"}, {\"id\": \"switch\", \"value\": \"\", \"shadow\": \"\"}, {\"id\": \"message\", \"value\": \"\", \"shadow\": \"\"}, {\"id\": \"report_monitor\", \"value\": \"\", \"shadow\": \"\"}]"
//处理
 if(StringUtil.isNotNullOrEmpty(things_model_value)) {
            JSONArray objects = JSONArray.parseArray(things_model_value);
            m.put("things_model_value", objects);
        }
//处理后
 "things_model_value": [
      {
        "shadow": "",
        "id": "temp_admin",
        "value": ""
      },
      {
        "shadow": "",
        "id": "switch",
        "value": ""
      },
      {
        "shadow": "",
        "id": "message",
        "value": ""
      },
      {
        "shadow": "",
        "id": "report_monitor",
        "value": ""
      }
    ],

//JsonObject查出来的格式为：
"summary": "{\"chip\": \"esp8266\", \"name\": \"wumei-smart\", \"author\": \"kerwincui\", \"version\": 1.2, \"createTime\": \"2022-06-06\"}",
//处理
String summary = StringUtil.toString(m.get("summary"));
        if(StringUtil.isNotNullOrEmpty(summary)) {
            JSONObject vjson = JSONObject.parseObject(summary);
            m.put("summary", vjson);
        }
//处理后
"summary": {
      "chip": "esp8266",
      "createTime": "2022-06-06",
      "author": "kerwincui",
      "name": "wumei-smart",
      "version": 1.2
    }

//新增的时候 获取到json转成字符串放到嵌套的json中去
 JSONObject specsJson=reqJsonObj.getJSONObject("things_model_value");
 reqJsonObj.put("things_model_value",specsJson.toJSONString());