可否把city2.json发一份所有省份城市的 about androidpicker HOT 1 CLOSED

import com.alibaba.fastjson.JSON;
import com.alibaba.fastjson.serializer.SerializerFeature;

import java.io.BufferedWriter;
import java.io.FileOutputStream;
import java.io.OutputStreamWriter;
import java.sql.*;
import java.util.ArrayList;

public class Main {

    public static void main(String[] args) throws Exception {
        Class.forName("org.sqlite.JDBC");
        Connection conn = DriverManager.getConnection("jdbc:sqlite:test.db");
        Statement stat = conn.createStatement();
        saveToJsonString("test.json", queryProvince(stat));
        for (int i = 1; i < 11; i++) {
            ArrayList<County> counties = queryCounty(stat, i);
            saveToJsonString("city" + i + ".json", counties);
        }
        stat.close();
        conn.close();
    }

    private static void saveToJsonString(String name, Object object) {
        String jsonStr = JSON.toJSONString(object, SerializerFeature.PrettyFormat);
        System.out.println(jsonStr);
        try {
            BufferedWriter writer = new BufferedWriter(new OutputStreamWriter(
                    new FileOutputStream(name), "utf-8"));
            writer.write(jsonStr);
            writer.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }

    private static ArrayList<Province> queryProvince(Statement stat) throws SQLException {
        ArrayList<Province> provinces = new ArrayList<Province>();
        ResultSet provinceRs = stat.executeQuery("select id,name,sign_key from province");
        while (provinceRs.next()) {
            Province province = new Province();
            province.value = provinceRs.getString("sign_key");
            province.text = provinceRs.getString("name").trim();
            int id = provinceRs.getInt("id");
            ArrayList<City> cities = queryCity(stat, id);
            saveToJsonString("province" + id + ".json", cities);
            province.children.addAll(cities);
            provinces.add(province);
        }
        provinceRs.close();
        return provinces;
    }

    private static ArrayList<City> queryCity(Statement stat, int provinceId) throws SQLException {
        ArrayList<City> cities = new ArrayList<City>();
        ResultSet cityRs = stat.executeQuery("select id,name,sign_key from city where parent_key=" + provinceId);
        while (cityRs.next()) {
            City city = new City();
            city.value = cityRs.getString("sign_key");
            city.text = cityRs.getString("name").trim();
//            int id = cityRs.getInt("id");
//            ArrayList<County> counties = queryCounty(stat, id);
//            saveToJsonString("city" + id + ".json", cities);
//            city.children.addAll(counties);
            cities.add(city);
        }
        cityRs.close();
        return cities;
    }

    private static ArrayList<County> queryCounty(Statement stat, int cityId) throws SQLException {
        ArrayList<County> counties = new ArrayList<County>();
        ResultSet countyRs = stat.executeQuery("select id,name,sign_key from county where parent_key=" + cityId);
        while (countyRs.next()) {
            County county = new County();
            county.value = countyRs.getString("sign_key");
            county.text = countyRs.getString("name").trim();
            counties.add(county);
        }
        countyRs.close();
        return counties;
    }

}