JSON数据的处理

JSON数据的处理

第一步创建json工具类

package com.example.test.util;

import com.alibaba.fastjson.JSON;
import com.alibaba.fastjson.JSONArray;
import com.alibaba.fastjson.JSONObject;


import java.io.*;


public class JsonTest {

    //读取json文件
    public  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;
        }
    }
}

第二步 编写函数 调用工具类

package com.example.test.util;

import com.alibaba.fastjson.JSON;
import com.alibaba.fastjson.JSONArray;
import com.alibaba.fastjson.JSONObject;

import java.io.File;
import java.io.FileInputStream;
import java.io.InputStreamReader;
import java.math.BigDecimal;


public class Hello {
 public static void main(String[] args) throws  Exception{
     JsonTest jsonTest = new JsonTest();
     String path = Hello.class.getClassLoader().getResource("lnglat.json").getPath();
     String s = jsonTest.readJsonFile(path);
     JSONObject jobj = JSON.parseObject(s);
     JSONArray links = jobj.getJSONArray("Southern Indian Ocean Region");


        Integer lng = 0;
        Integer lat = 0;
        Integer id=0;
        String str1="";
    String str= " INSERT INTO ids_satellite_overlay_t (id,lng,lat) VALUES ";
    String str2= "INSERT INTO test (lng,lat) VALUES ";
     for (int i = 0 ; i < links.size();i++){
         JSONObject key1 = (JSONObject)links.get(i);

             lng = (Integer) key1.get("lng");
             lat = (Integer) key1.get("lat");
             str1+="(,"+lng+","+lat+")\n,";

     }
      str1 = str1.substring(0, str1.length() -1);
        System.out.println(str1);


        System.out.println(str+str1);

 }
    }

结果如图