第一次插入比较难的JSON
{
"error_msg": "0",
"data": {
"yAxis": [
[
0.00,
0.01,
59.97,
34.42,
11.73,
11.16,
10.61,
0.62
],
[
17.06,
16.99,
23.31,
25.98,
17.62,
6.13,
23.19,
7.88
],
[
0.00,
0.00,
9.77,
8.56,
3.23,
1.11,
3.42,
0.25
],
[
0.00,
0.01,
50.20,
25.86,
8.50,
10.05,
7.19,
0.37
],
[
17.06,
16.99,
13.54,
17.42,
14.39,
5.02,
19.77,
7.63
]
],
"updateDate": "",
"xAxis": [
"05",
"06",
"07",
"08",
"09",
"10",
"11",
"12"
],
"selfUseData": {
"pvElec": 128.52,
"useElec": 147.30,
"buyElec": 144.51,
"sellElec": 125.73,
"chargeElec": 0,
"dischargeElec": 0,
"pvSelfConsumedRate": 0.022,
"loadSelfConsumedRate": 0.019,
"pvSelfConsumedElec": 2.79,
"loadSelfConsumedElec": 2.79,
"sellRate": 0.978,
"buyRate": 0.981
}
},
"error_code": "0"
}
2.插入到数据库的格式
INSERT INTO `` (`plant_uid`, `wisdom_device_sn`, `pv_tel`, `load_tel`, `auto_tel`, `sell_tel`, `buy_tel`, `day`, `chart_date_type`, `chart_month`) VALUES ('1150E0FB-0D1D-4051-BC32-4133BB72214E', 'M5440G2212000390', '48.77', '78.93', '15.77', '33', '63.16', '01', '2', '2022-07');
上面数据不一致,有多少天,这个pland_uid就有多少条。
3.java的写法
重点提醒,JSONArray是获取json里面的json数组,JSONObject,是获取,标准的键值对,一般都是JSONobject
package com.cx.core.service.impl;
import cn.hutool.core.util.StrUtil;
import cn.hutool.http.HttpUtil;
import cn.hutool.json.JSONArray;
import cn.hutool.json.JSONObject;
import cn.hutool.json.JSONUtil;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.cx.core.entity.BtoOperationDay;
import com.cx.core.entity.VWisdomSn;
import com.cx.core.mapper.BtoOperationDayMapper;
import com.cx.core.mapper.VWisdomSnMapper;
import com.cx.core.service.BtoOperationDayService;
import com.cx.core.utils.ApiParamUtil;
import com.cx.core.utils.SajAPI;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import java.util.Iterator;
import java.util.List;