将json文件转换成insert语句的sql文件

引入是要的maven依赖:

<!-- https://mvnrepository.com/artifact/com.google.code.gson/gson -->
<dependency>
    <groupId>com.google.code.gson</groupId>
    <artifactId>gson</artifactId>
    <version>2.2.4</version>
</dependency>

转换:

package com.iot.zjdy.exampl.test;

import com.google.gson.JsonArray;
import com.google.gson.JsonElement;
import com.google.gson.JsonObject;
import com.google.gson.JsonParser;
import java.io.BufferedWriter;
import java.io.File;
import java.io.FileReader;
import java.io.FileWriter;


/**
 * Created by Yanwu 2018/2/8.
 */
public class JsonToSqlTest {
    private static final String PATH = "C:\demo\file\Cab_LN_FeaturesToJSON.json";

    public static void main(String[] args) throws Exception {
        System.out.println("========== JSON ---> 转换成 SQL 开始 ==========");
        jsonToExcel();
        System.out.println("========== JSON ---> 转换成 SQL 结束 ==========");
}

    private static void jsonToExcel() throws Exception {
        JsonParser jsonParser = new JsonParser();
        JsonObject jsonObject = (JsonObject) jsonParser.parse(new FileReader(PATH));
        JsonElement features = jsonObject.get("features");
        JsonArray asJsonArray = features.getAsJsonArray();
        for (int i = 0; i < asJsonArray.size(); i++) {
            JsonElement jsonElement = asJsonArray.get(i);
            JsonObject featuresObj = jsonElement.getAsJsonObject();
            JsonElement attributes = featuresObj.get("attributes");
            JsonObject attributesObj = attributes.getAsJsonObject();
            JsonElement swchName = attributesObj.get("swchName");
            String nameStr = swchName.toString();
            JsonElement geometry = featuresObj.get("geometry");
            JsonObject geometryObj = geometry.getAsJsonObject();
            JsonElement path = geometryObj.get("paths");
            String pathStr = path.toString();
            String replace = nameStr.replace(""", "");
            String sqlStr = "insert into poly_line (id, box_name, paths) values (" + i + ", '" + replace + "', '" + pathStr + "'); 
";
            System.out.println(sqlStr);
            File file = new File("C:\demo\file\Cab_LN.sql");
            if (!file.exists()) {
                file.createNewFile();
            }
            FileWriter fileWriter = new FileWriter(file, true);
            BufferedWriter bufferedWriter = new BufferedWriter(fileWriter);
            bufferedWriter.write(sqlStr);
            bufferedWriter.close();
        }
    }
}