java 发送 http json请求后返回json数据
接收后存入数据库
接收的数据格式
{"code":0"data":[{"data":"1381.59997558593"13815999755859375 "time":"1683319534158"1},{data : 1381 599975581.5999755859375 ,"time":"1683319534}]
task.java
/** * 返回值 类型 {"code":0"data":[{"data":"1381.59997558593"13815999755859375 "time":"1683319534158"1}, *{data : 1381 599975581.5999755859375 ,"time":"1683319534}] */ public void pullData(){ String url = "http://XXXXXX/systemcfg"; JSONObject param = new JSONObject(); param.put("request","XXXXXX"); param.put("token","XXXXXXXXX"); JSONObject j = new JSONObject(); j.put("suid","XXX"); j.put("cuid","XXX"); param.put("value",j); System.out.println(param.toString()); String s = HttpUtils.sendPost(url, param.toJSONString()); System.out.println(s); JSONObject parse =(JSONObject) JSONObject.parse(s); JSONArray data1 = parse.getJSONArray("data"); // Object[] data = FastJsonUtil.toArray(.toJSONString(), R3Volapu.class); System.out.println(data1.toString()); r3VolapuMapper.insertR3VolapuBetch(data1,"1703","128"); }
mapper.java
int insertR3VolapuBetch(@Param("r3Volapus") JSONArray r3Volapus, @Param("suid") String suid, @Param("cuid") String cuid );
mapper.xml
<insert id="insertR3VolapuBetch" parameterType="arraylist">
insert into r3_volapu(suid, cuid,`data` , `time`) values
<foreach collection="r3Volapus" item="item" separator=",">
(#{suid},#{cuid},#{item.data},#{item.time})
</foreach>
</insert>