java读取json文件把数据存入数据库中

迷南。 2022-11-13 04:02 338阅读 0赞

//读取json文件
        public static String readJsonFile(String fileName) {
            String jsonStr = "";
            try {
                File jsonFile = new File(fileName);
                FileReader fileReader = new FileReader(jsonFile);
                Reader reader = new InputStreamReader(new FileInputStream(jsonFile), "utf-8");
                int ch = 0;
                StringBuffer sb = new StringBuffer();
                while ((ch = reader.read()) != -1) {
                    sb.append((char) ch);
                }
                fileReader.close();
                reader.close();
                jsonStr = sb.toString();
                return jsonStr;
            } catch (IOException e) {
                e.printStackTrace();
                return null;
            }
        }
     public Result<?> test() {
            String s = readJsonFile("D:\\marks.json");
            JSONObject jobj = JSON.parseObject(s);
            JSONArray jsonArray = jobj.getJSONObject("data").getJSONObject("map_set").getJSONObject("map_code_set")
                    .getJSONObject("mapSet").getJSONArray("markers");//构建JSONArray数组
    //        JSONArray movies = jobj.getJSONObject("data").getJSONObject("map_set").
    // getJSONObject("map_code_set").getJSONObject("mapSet").getJSONArray("polyline");//构建JSONArray数组
    
            for (int i = 0; i < jsonArray.size(); i++) {
                LongMarchStation longMarchStation = new LongMarchStation();
                JSONObject key = (JSONObject) jsonArray.get(i);
                JSONObject jsonObject = ((JSONObject) jsonArray.get(i)).getJSONObject("callout");
                String id = key.get("id") + "";
                String latitude = key.get("latitude") + "";
                String longitude = key.get("longitude") + "";
                Integer min = (Integer) key.get("min");
                Integer max = (Integer) key.get("max");
                String iconPath = (String) key.get("iconPath");
                String name = (String) jsonObject.get("content");
                longMarchStation.setId(id);
                longMarchStation.setLatitude(latitude);
                longMarchStation.setLongitude(longitude);
                longMarchStation.setMax(max);
                longMarchStation.setMin(min);
                longMarchStation.setName(name);
                longMarchStation.setIconPath(iconPath);
                longMarchStationService.save(longMarchStation);
            }
    
            return Result.ok("添加成功！");
        }

JSON文件：

{
        "status":1,
        "info":"商家平台设置的地图",
        "data":{
            "map_set":{
                "map_types":2,
                "map_code_set":{
                    "mapSet":{
                        "markers":[
                            {
                                "id":1,
                                "latitude":"25.886205",
                                "longitude":"116.026915",
                                "min":0,
                                "max":500,
                                "page_id":29655,
                                "exam_id":93154,
                                "iconPath":"https://thirdwx.qlogo.cn/mmopen/vi_32/WaKoo1LCqEszQ3sN63XqnWxhxSianibebK9icf6tAk3tEiazrf3UvKkmd5icGPzBkemPykZDEibwbcJzLBfasxkLCr6A/132",
                                "point_reward_pic":"",
                                "callout":{
                                    "content":"瑞金",
                                    "borderRadius":10,
                                    "padding":5,
                                    "display":"ALWAYS"
                                },
                                "width":50,
                                "height":50
                            },
                            {
                                "id":2,
                                "latitude":"24.909612",
                                "longitude":"114.722471",
                                "min":501,
                                "max":1400,
                                "page_id":29656,
                                "exam_id":0,
                                "iconPath":"http://www.xinweiyun.com/weixin/editor/pics/long_march/dot.png",
                                "point_reward_pic":"",
                                "callout":{
                                    "content":"九峰山",
                                    "borderRadius":10,
                                    "padding":5,
                                    "display":"ALWAYS"
                                },
                                "width":10,
                                "height":10
                            },
                            {
                                "id":3,
                                "latitude":"25.400103",
                                "longitude":"112.948732",
                                "min":1401,
                                "max":2300,
                                "page_id":29657,
                                "exam_id":93986,
                                "iconPath":"http://www.xinweiyun.com/weixin/editor/pics/long_march/dot.png",
                                "point_reward_pic":"",
                                "callout":{
                                    "content":"宜章",
                                    "borderRadius":10,
                                    "padding":5,
                                    "display":"ALWAYS"
                                },
                                "width":10,
                                "height":10
                            },
                            {
                                "id":4,
                                "latitude":"25.526410",
                                "longitude":"111.600752",
                                "min":2301,
                                "max":3200,
                                "page_id":29662,
                                "exam_id":0,
                                "iconPath":"http://www.xinweiyun.com/weixin/editor/pics/long_march/dot.png",
                                "point_reward_pic":"",
                                "callout":{
                                    "content":"潇水",
                                    "borderRadius":10,
                                    "padding":5,
                                    "display":"ALWAYS"
                                },
                                "width":10,
                                "height":10
                            },
                            {
                                "id":6,
                                "latitude":"25.605231",
                                "longitude":"110.656443",
                                "min":3201,
                                "max":4100,
                                "page_id":29663,
                                "exam_id":0,
                                "iconPath":"http://www.xinweiyun.com/weixin/editor/pics/long_march/dot.png",
                                "point_reward_pic":"",
                                "callout":{
                                    "content":"老山界",
                                    "borderRadius":10,
                                    "padding":5,
                                    "display":"ALWAYS"
                                },
                                "width":10,
                                "height":10
                            },
                            {
                                "id":7,
                                "latitude":"26.312821",
                                "longitude":"109.629969",
                                "min":4101,
                                "max":5000,
                                "page_id":29664,
                                "exam_id":0,
                                "iconPath":"http://www.xinweiyun.com/weixin/editor/pics/long_march/dot.png",
                                "point_reward_pic":"",
                                "callout":{
                                    "content":"通道",
                                    "borderRadius":10,
                                    "padding":5,
                                    "display":"ALWAYS"
                                },
                                "width":10,
                                "height":10
                            },
                            {
                                "id":8,
                                "latitude":"26.231440",
                                "longitude":"109.139490",
                                "min":5001,
                                "max":5900,
                                "page_id":29665,
                                "exam_id":0,
                                "iconPath":"http://www.xinweiyun.com/weixin/editor/pics/long_march/dot.png",
                                "point_reward_pic":"",
                                "callout":{
                                    "content":"黎平",
                                    "borderRadius":10,
                                    "padding":5,
                                    "display":"ALWAYS"
                                },
                                "width":10,
                                "height":10
                            },
                            {
                                "id":9,
                                "latitude":"27.386932",
                                "longitude":"107.689271",
                                "min":5901,
                                "max":6800,
                                "page_id":29666,
                                "exam_id":0,
                                "iconPath":"http://www.xinweiyun.com/weixin/editor/pics/long_march/dot.png",
                                "point_reward_pic":"",
                                "callout":{
                                    "content":"乌江",
                                    "borderRadius":10,
                                    "padding":5,
                                    "display":"ALWAYS"
                                },
                                "width":10,
                                "height":10
                            },
                            {
                                "id":10,
                                "latitude":"27.696837",
                                "longitude":"106.919445",
                                "min":6801,
                                "max":8600,
                                "page_id":29667,
                                "exam_id":0,
                                "iconPath":"http://www.xinweiyun.com/weixin/editor/pics/long_march/dot.png",
                                "point_reward_pic":"",
                                "callout":{
                                    "content":"遵义",
                                    "borderRadius":10,
                                    "padding":5,
                                    "display":"ALWAYS"
                                },
                                "width":10,
                                "height":10
                            },
                            {
                                "id":11,
                                "latitude":"28.589086",
                                "longitude":"105.694926",
                                "min":8601,
                                "max":9500,
                                "page_id":29668,
                                "exam_id":93987,
                                "iconPath":"http://www.xinweiyun.com/weixin/editor/pics/long_march/dot.png",
                                "point_reward_pic":"",
                                "callout":{
                                    "content":"赤水",
                                    "borderRadius":10,
                                    "padding":5,
                                    "display":"ALWAYS"
                                },
                                "width":10,
                                "height":10
                            },
                            {
                                "id":12,
                                "latitude":"27.847691",
                                "longitude":"105.048622",
                                "min":9501,
                                "max":10400,
                                "page_id":29669,
                                "exam_id":0,
                                "iconPath":"http://www.xinweiyun.com/weixin/editor/pics/long_march/dot.png",
                                "point_reward_pic":"",
                                "callout":{
                                    "content":"扎西",
                                    "borderRadius":10,
                                    "padding":5,
                                    "display":"ALWAYS"
                                },
                                "width":10,
                                "height":10
                            },
                            {
                                "id":13,
                                "latitude":"27.125394",
                                "longitude":"106.519602",
                                "min":10401,
                                "max":11300,
                                "page_id":29670,
                                "exam_id":0,
                                "iconPath":"http://www.xinweiyun.com/weixin/editor/pics/long_march/dot.png",
                                "point_reward_pic":"",
                                "callout":{
                                    "content":"贵阳",
                                    "borderRadius":10,
                                    "padding":5,
                                    "display":"ALWAYS"
                                },
                                "width":10,
                                "height":10
                            },
                            {
                                "id":14,
                                "latitude":"25.341442",
                                "longitude":"103.036891",
                                "min":11301,
                                "max":12200,
                                "page_id":29671,
                                "exam_id":0,
                                "iconPath":"http://www.xinweiyun.com/weixin/editor/pics/long_march/dot.png",
                                "point_reward_pic":"",
                                "callout":{
                                    "content":"昆明",
                                    "borderRadius":10,
                                    "padding":5,
                                    "display":"ALWAYS"
                                },
                                "width":10,
                                "height":10
                            },
                            {
                                "id":15,
                                "latitude":"26.362788",
                                "longitude":"103.000344",
                                "min":12201,
                                "max":13100,
                                "page_id":29672,
                                "exam_id":93988,
                                "iconPath":"http://www.xinweiyun.com/weixin/editor/pics/long_march/dot.png",
                                "point_reward_pic":"",
                                "callout":{
                                    "content":"金沙江",
                                    "borderRadius":10,
                                    "padding":5,
                                    "display":"ALWAYS"
                                },
                                "width":10,
                                "height":10
                            },
                            {
                                "id":16,
                                "latitude":"26.659070",
                                "longitude":"102.244290",
                                "min":13101,
                                "max":14000,
                                "page_id":29673,
                                "exam_id":0,
                                "iconPath":"http://www.xinweiyun.com/weixin/editor/pics/long_march/dot.png",
                                "point_reward_pic":"",
                                "callout":{
                                    "content":"会理",
                                    "borderRadius":10,
                                    "padding":5,
                                    "display":"ALWAYS"
                                },
                                "width":10,
                                "height":10
                            },
                            {
                                "id":17,
                                "latitude":"27.891488",
                                "longitude":"102.271768",
                                "min":14001,
                                "max":14900,
                                "page_id":29674,
                                "exam_id":0,
                                "iconPath":"http://www.xinweiyun.com/weixin/editor/pics/long_march/dot.png",
                                "point_reward_pic":"",
                                "callout":{
                                    "content":"西昌",
                                    "borderRadius":10,
                                    "padding":5,
                                    "display":"ALWAYS"
                                },
                                "width":10,
                                "height":10
                            },
                            {
                                "id":18,
                                "latitude":"29.180941",
                                "longitude":"102.345886",
                                "min":14901,
                                "max":15300,
                                "page_id":29675,
                                "exam_id":0,
                                "iconPath":"http://www.xinweiyun.com/weixin/editor/pics/long_march/dot.png",
                                "point_reward_pic":"",
                                "callout":{
                                    "content":"大渡河",
                                    "borderRadius":10,
                                    "padding":5,
                                    "display":"ALWAYS"
                                },
                                "width":10,
                                "height":10
                            },
                            {
                                "id":19,
                                "latitude":"29.904911",
                                "longitude":"102.229472",
                                "min":15301,
                                "max":15700,
                                "page_id":29676,
                                "exam_id":0,
                                "iconPath":"http://www.xinweiyun.com/weixin/editor/pics/long_march/dot.png",
                                "point_reward_pic":"",
                                "callout":{
                                    "content":"泸定桥",
                                    "borderRadius":10,
                                    "padding":5,
                                    "display":"ALWAYS"
                                },
                                "width":10,
                                "height":10
                            },
                            {
                                "id":20,
                                "latitude":"30.368068",
                                "longitude":"102.811897",
                                "min":15701,
                                "max":16600,
                                "page_id":29677,
                                "exam_id":0,
                                "iconPath":"http://www.xinweiyun.com/weixin/editor/pics/long_march/dot.png",
                                "point_reward_pic":"",
                                "callout":{
                                    "content":"夹金山",
                                    "borderRadius":10,
                                    "padding":5,
                                    "display":"ALWAYS"
                                },
                                "width":10,
                                "height":10
                            },
                            {
                                "id":21,
                                "latitude":"30.962482",
                                "longitude":"102.640501",
                                "min":16601,
                                "max":16800,
                                "page_id":29678,
                                "exam_id":0,
                                "iconPath":"http://www.xinweiyun.com/weixin/editor/pics/long_march/dot.png",
                                "point_reward_pic":"",
                                "callout":{
                                    "content":"达维",
                                    "borderRadius":10,
                                    "padding":5,
                                    "display":"ALWAYS"
                                },
                                "width":10,
                                "height":10
                            },
                            {
                                "id":22,
                                "latitude":"32.598431",
                                "longitude":"103.063780",
                                "min":16801,
                                "max":17000,
                                "page_id":29679,
                                "exam_id":0,
                                "iconPath":"http://www.xinweiyun.com/weixin/editor/pics/long_march/dot.png",
                                "point_reward_pic":"",
                                "callout":{
                                    "content":"毛儿盖",
                                    "borderRadius":10,
                                    "padding":5,
                                    "display":"ALWAYS"
                                },
                                "width":10,
                                "height":10
                            },
                            {
                                "id":23,
                                "latitude":"32.774181",
                                "longitude":"103.625415",
                                "min":17001,
                                "max":17300,
                                "page_id":29680,
                                "exam_id":93989,
                                "iconPath":"http://www.xinweiyun.com/weixin/editor/pics/long_march/dot.png",
                                "point_reward_pic":"",
                                "callout":{
                                    "content":"松潘草地",
                                    "borderRadius":10,
                                    "padding":5,
                                    "display":"ALWAYS"
                                },
                                "width":10,
                                "height":10
                            },
                            {
                                "id":24,
                                "latitude":"33.584828",
                                "longitude":"103.228920",
                                "min":17301,
                                "max":18200,
                                "page_id":29728,
                                "exam_id":0,
                                "iconPath":"http://www.xinweiyun.com/weixin/editor/pics/long_march/dot.png",
                                "point_reward_pic":"",
                                "callout":{
                                    "content":"巴西",
                                    "borderRadius":10,
                                    "padding":5,
                                    "display":"ALWAYS"
                                },
                                "width":10,
                                "height":10
                            },
                            {
                                "id":25,
                                "latitude":"34.109182",
                                "longitude":"103.896071",
                                "min":18201,
                                "max":19100,
                                "page_id":29729,
                                "exam_id":0,
                                "iconPath":"http://www.xinweiyun.com/weixin/editor/pics/long_march/dot.png",
                                "point_reward_pic":"",
                                "callout":{
                                    "content":"腊子口",
                                    "borderRadius":10,
                                    "padding":5,
                                    "display":"ALWAYS"
                                },
                                "width":10,
                                "height":10
                            },
                            {
                                "id":26,
                                "latitude":"35.003942",
                                "longitude":"104.634985",
                                "min":19101,
                                "max":20000,
                                "page_id":29730,
                                "exam_id":0,
                                "iconPath":"http://www.xinweiyun.com/weixin/editor/pics/long_march/dot.png",
                                "point_reward_pic":"",
                                "callout":{
                                    "content":"陇西",
                                    "borderRadius":10,
                                    "padding":5,
                                    "display":"ALWAYS"
                                },
                                "width":10,
                                "height":10
                            },
                            {
                                "id":27,
                                "latitude":"35.521978",
                                "longitude":"105.732556",
                                "min":20001,
                                "max":24999,
                                "page_id":29731,
                                "exam_id":0,
                                "iconPath":"http://www.xinweiyun.com/weixin/editor/pics/long_march/dot.png",
                                "point_reward_pic":"",
                                "callout":{
                                    "content":"静宁",
                                    "borderRadius":10,
                                    "padding":5,
                                    "display":"ALWAYS"
                                },
                                "width":10,
                                "height":10
                            },
                            {
                                "id":28,
                                "latitude":"36.927945",
                                "longitude":"108.177187",
                                "min":25000,
                                "max":99999,
                                "page_id":29732,
                                "exam_id":93990,
                                "iconPath":"http://www.xinweiyun.com/weixin/editor/pics/long_march/dot.png",
                                "point_reward_pic":"",
                                "callout":{
                                    "content":"吴起",
                                    "borderRadius":10,
                                    "padding":5,
                                    "display":"ALWAYS"
                                },
                                "width":10,
                                "height":10
                            }
                        ],
                        "polyline":[
                            {
                                "points":[
                                    {
                                        "latitude":"25.886205",
                                        "longitude":"116.026915"
                                    },
                                    {
                                        "latitude":"24.909612",
                                        "longitude":"114.722471"
                                    },
                                    {
                                        "latitude":"25.400103",
                                        "longitude":"112.948732"
                                    },
                                    {
                                        "latitude":"25.526410",
                                        "longitude":"111.600752"
                                    },
                                    {
                                        "latitude":"25.605231",
                                        "longitude":"110.656443"
                                    },
                                    {
                                        "latitude":"26.312821",
                                        "longitude":"109.629969"
                                    },
                                    {
                                        "latitude":"26.231440",
                                        "longitude":"109.139490"
                                    },
                                    {
                                        "latitude":"27.386932",
                                        "longitude":"107.689271"
                                    },
                                    {
                                        "latitude":"27.696837",
                                        "longitude":"106.919445"
                                    },
                                    {
                                        "latitude":"28.589086",
                                        "longitude":"105.694926"
                                    },
                                    {
                                        "latitude":"27.847691",
                                        "longitude":"105.048622"
                                    },
                                    {
                                        "latitude":"27.125394",
                                        "longitude":"106.519602"
                                    },
                                    {
                                        "latitude":"25.341442",
                                        "longitude":"103.036891"
                                    },
                                    {
                                        "latitude":"26.362788",
                                        "longitude":"103.000344"
                                    },
                                    {
                                        "latitude":"26.659070",
                                        "longitude":"102.244290"
                                    },
                                    {
                                        "latitude":"27.891488",
                                        "longitude":"102.271768"
                                    },
                                    {
                                        "latitude":"29.180941",
                                        "longitude":"102.345886"
                                    },
                                    {
                                        "latitude":"29.904911",
                                        "longitude":"102.229472"
                                    },
                                    {
                                        "latitude":"30.368068",
                                        "longitude":"102.811897"
                                    },
                                    {
                                        "latitude":"30.962482",
                                        "longitude":"102.640501"
                                    },
                                    {
                                        "latitude":"32.598431",
                                        "longitude":"103.063780"
                                    },
                                    {
                                        "latitude":"32.774181",
                                        "longitude":"103.625415"
                                    },
                                    {
                                        "latitude":"33.584828",
                                        "longitude":"103.228920"
                                    },
                                    {
                                        "latitude":"34.109182",
                                        "longitude":"103.896071"
                                    },
                                    {
                                        "latitude":"35.003942",
                                        "longitude":"104.634985"
                                    },
                                    {
                                        "latitude":"35.521978",
                                        "longitude":"105.732556"
                                    },
                                    {
                                        "latitude":"36.927945",
                                        "longitude":"108.177187"
                                    }
                                ],
                                "width":5,
                                "color":"#FF0000",
                                "colorList":[
                                    "#BDBDBD"
                                ]
                            }
                        ],
                        "latitude":32.212801,
                        "longitude":109.863281,
                        "scale":5
                    }
                }
            },
            "my_position":{
                "id":1,
                "latitude":"25.886205",
                "longitude":"116.026915",
                "min":0,
                "max":500,
                "page_id":29655,
                "exam_id":93154,
                "iconPath":"",
                "point_reward_pic":"",
                "callout":{
                    "content":"瑞金",
                    "borderRadius":10,
                    "padding":5,
                    "display":"ALWAYS"
                },
                "my_position_key_num":0,
                "next_point_details":{
                    "id":2,
                    "latitude":"24.909612",
                    "longitude":"114.722471",
                    "min":501,
                    "max":1400,
                    "page_id":29656,
                    "exam_id":0,
                    "iconPath":"",
                    "point_reward_pic":"",
                    "callout":{
                        "content":"九峰山",
                        "borderRadius":10,
                        "padding":5,
                        "display":"ALWAYS"
                    }
                }
            }
        }
    }