解析JSON接口并批量插入到数据库中

最新推荐文章于 2023-03-24 16:13:51 发布

躺着数星星

最新推荐文章于 2023-03-24 16:13:51 发布

阅读量1.6k

点赞数 3

文章标签： json 前端 javascript

本文链接：https://blog.csdn.net/qq_55362295/article/details/125376737

版权

接口为NBA接口json接口
使用hutool工具类在后端进行解析（防止跨域）

 @GetMapping("/pachou")
    public String teamMessage()  {

        s = HttpUtil.get("https://china.nba.cn/stats2/season/conferencestanding.json?");

        return s;
    }

获取前端传递的数据使用fastJSON进行解析并批量插入


    @PostMapping("/addBatch")
    public Result addBatch(@RequestBody String str) {


        JSONArray jsonArray = JSONArray.parseArray(str);
        for (int i = 0; i < jsonArray.size(); i++) {
            JSONObject json = JSONObject.parseObject(jsonArray.get(i).toString());
            String profile = json.getString("profile");
            JSONObject jsons = JSONObject.parseObject(profile);
            String city = jsons.getString("city");
            String abbr = jsons.getString("abbr");
            String cityEn = jsons.getString("cityEn");
            String displayConference = jsons.getString("displayConference");
            String displayAbbr = jsons.getString("displayAbbr");
            String nameEn = jsons.getString("nameEn");
            String division = jsons.getString("division");


            Team team = new Team();
            team.setAbbr( abbr);
            team.setCityEn(cityEn);
            team.setCreateTime(DateUtil.format(new Date(), "yyyy-MM-dd hh:mm:ss"));
            team.setDisplayConference(displayConference);
            team.setDisplayAbbr(displayAbbr);
            team.setNameEn(nameEn);
            team.setDivision(division);
            teamService.save(team);
        }


        return Result.success("成功");
    }

前端vue发送请求

 //发送数据
            send: function () {
                request.get("/team/pachou").then(res => {
                    console.log(res)
                    this.standingGroups = res.payload.standingGroups[1].teams
                    console.log(this.standingGroups)
                    // JSON.stringify(this.standingGroups)

                 /*   this.standingGroups.forEach(e=>{
                        JSON.stringify(this.standingGroups)
                        console.log(JSON.stringify(this.standingGroups));
                    })*/

                    request.post("/team/addBatch",this.standingGroups).then(res => {
                        console.log(res)
                    })

                })


            },