用高德提供的api获取最新的三级级联数据

高德api接口地址：https://restapi.amap.com/v3/config/district
高德接口文档地址：https://lbs.amap.com/api/webservice/guide/api/search

有了它，妈妈再也不用担心我熬夜处理省市区数据了！！

下载完的数据处理下，因为excel会自动把开头的0去掉，所以，把这两行换成文本格式，然后全局替换@为空，把它去掉就能用了
使用需要先到高德申请key，免费不要钱，不过一天限额30000，想要更高就要掏钱了，文件里有我的key，使用时请替换

 

 

package com.yhl.tos.rule.config;

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

import java.io.BufferedReader;
import java.io.FileWriter;
import java.io.IOException;
import java.io.InputStreamReader;
import java.net.URL;
import java.net.URLConnection;
import java.nio.charset.StandardCharsets;
import java.util.List;
import java.util.Map;

/**
 * 根据高德提供api爬取省市区三级级联数据
 *
 * @author sen.yang@youhualin.com
 * @since 2021-03-22 16:24:23
 */
public class District {

    private static volatile int i=0;

    /**
     * 你要把文件存到哪
     */
    private static final String url="C:\\Users\\IT_YangSen\\Desktop\\省市区.csv";

    public static void main(String[] args)  {
        try{
            //e399a25bb21f97d040765b175c8ea8f1是我自己的key,不能用自己到高德弄一个，反正不要钱
            String jsonString = sendGet("https://restapi.amap.com/v3/config/district","subdistrict=4&key=e399a25bb21f97d040765b175c8ea8f1");
            JSONObject jsonObject = JSONObject.parseObject(jsonString);
            //获取到国家及下面所有的信息 开始循环插入，这里可以写成递归调用，但是不如这样方便查看、理解
            JSONArray countryAll = jsonObject.getJSONArray("districts");
            writeFile("ID,adcode,城市编码,级别,地名,父id,四级地址\n");
            for (int i = 0; i < countryAll.size(); i++) {
                JSONObject countryLeve0 = countryAll.getJSONObject(i);
                String citycode0 = countryLeve0.getString("citycode");
                String adcode0 = countryLeve0.getString("adcode");
                String name0 = countryLeve0.getString("name");
                String center0 = countryLeve0.getString("center");
                String country = countryLeve0.getString("level");
                int level = 3;
                if (country.equals("country")) {
                    level = 3;
                }
                //插入国家
                Integer id1 = insert(0, adcode0, citycode0, name0, center0, level, name0);
                JSONArray province0 = countryLeve0.getJSONArray("districts");

                for (int j = 0; j < province0.size(); j++) {
                    JSONObject province1 = province0.getJSONObject(j);
                    String citycode1 = province1.getString("citycode");
                    String adcode1 = province1.getString("adcode");
                    String name1 = province1.getString("name");
                    String center1 = province1.getString("center");
                    String province = province1.getString("level");
                    int level1 =3;
                    if (province.equals("province")) {
                        level1 = 1;
                    }
                    //插入省
                    Integer id2 = insert(id1, adcode1, citycode1, name1, center1, level1, name0, name1);
                    JSONArray city0 = province1.getJSONArray("districts");

                    for (int z = 0; z < city0.size(); z++) {
                        JSONObject city2 = city0.getJSONObject(z);
                        String citycode2 = city2.getString("citycode");
                        String adcode2 = city2.getString("adcode");
                        String name2 = city2.getString("name");
                        String center2 = city2.getString("center");
                        String city = city2.getString("level");
                        int level2 = 3;
                        if (city.equals("city")) {
                            level2 = 2;
                        }
                        //插入市
                        Integer id3 = insert(id2, adcode2, citycode2, name2, center2, level2, name0, name1, name2);

                        JSONArray street0 = city2.getJSONArray("districts");
                        for (int w = 0; w < street0.size(); w++) {
                            JSONObject street3 = street0.getJSONObject(w);
                            String citycode3 = street3.getString("citycode");
                            String adcode3 = street3.getString("adcode");
                            String name3 = street3.getString("name");
                            String center3 = street3.getString("center");
                            String street = street3.getString("level");
                            int level3 = 3;
                            if (street.equals("street")) {
                                level3 = 2;
                            }
                            //插入区县
                            insert(id3, adcode3, citycode3, name3, center3, level3, name0, name1, name2, name3);
                            //  JSONArray street = street3.getJSONArray("districts");
                            //有需要可以继续向下遍历

                        }

                    }
                }
            }
        }catch (Exception e){
            e.printStackTrace();
        }

    }


    /**
     * 公共的插入方法
     *
     * @param parentId  父id
     * @param citycode  城市编码
     * @param adcode    区域编码  街道没有独有的adcode，均继承父类（区县）的adcode
     * @param name      城市名称 （行政区名称）
     * @param center    地理坐标
     * @param level     等级  0 国家，1省，...依次排
     * @param mergeName 把名称拼接成全名
     * @return
     */
    public static Integer insert(Integer parentId, String citycode, String adcode, String name, String center, int level, String... mergeName) {
        String megName = "";
        for (int i = 0; i < mergeName.length; i++) {
            megName = megName + mergeName[i];
            if (i < mergeName.length - 1) {
                megName = megName + "，";
            }
        }
        i++;
        writeFile(i+","+"@"+adcode.replace("[]","")+","+"@"+citycode+","+level+","+name+","+parentId+","+megName+"\n");
        return i;
    }

    public static void writeFile(String content) {
        FileWriter writer = null;
        try {
            // 打开一个写文件器，构造函数中的第二个参数true表示以追加形式写文件
            writer = new FileWriter(url, true);
            writer.write(content);
        } catch (IOException e) {
            e.printStackTrace();
        } finally {
            try {
                if(writer != null){
                    writer.close();
                }
            } catch (IOException e) {
                e.printStackTrace();
            }
        }
    }

    /**
     * 向指定URL发送GET方法的请求
     *
     * @param url
     *            发送请求的URL
     * @param param
     *            请求参数，请求参数应该是 name1=value1&name2=value2 的形式。
     * @return URL 所代表远程资源的响应结果
     */
    public static String sendGet(String url, String param) {
        String result = "";
        BufferedReader in = null;
        try {
            String urlNameString = url + "?" + param;
            URL realUrl = new URL(urlNameString);
            // 打开和URL之间的连接
            URLConnection connection = realUrl.openConnection();
            // 设置通用的请求属性
            connection.setRequestProperty("accept", "*/*");
            connection.setRequestProperty("connection", "Keep-Alive");
            connection.setRequestProperty("user-agent",
                    "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1;SV1)");
            // 建立实际的连接
            connection.connect();
            // 获取所有响应头字段
            Map<String, List<String>> map = connection.getHeaderFields();
            // 遍历所有的响应头字段
            for (String key : map.keySet()) {
                System.out.println(key + "--->" + map.get(key));
            }
            // 定义 BufferedReader输入流来读取URL的响应
            in = new BufferedReader(new InputStreamReader(connection.getInputStream(), StandardCharsets.UTF_8));
            String line;
            while ((line = in.readLine()) != null) {
                result += line;
            }
        } catch (Exception e) {
            System.out.println("发送GET请求出现异常！" + e);
            e.printStackTrace();
        }
        // 使用finally块来关闭输入流
        finally {
            try {
                if (in != null) {
                    in.close();
                }
            } catch (Exception e2) {
                e2.printStackTrace();
            }
        }
        return result;
    }
}