高德citycode和国家citycode编码转换

背景：

有些时候要和第三方对接，对方给出的是国际citycode，自身用的是高德citycode或者其他编码，就要进行转换，我这边的话是使用手工映射的方法，使用map，代码如下 ：高德对应国际编码

//写一个转换的工具类，进行映射
public class MapCityCodeConvertUtils {
    public static final ImmutableMap<String, String> map = ImmutableMap.<String, String>builder()
//安阳市,安阳
            .put("0372", "4105")
//新乡市,新乡
            .put("0373", "4107")
//商丘市,商丘
            .put("0370", "4114")
//郑州市,郑州
            .put("0371", "4101")
//东方市,东方
            .put("0807", "469007")
//儋州市,儋州
            .put("0805", "469003")
//兰州市,兰州
            .put("0931", "6201")
//开封市,开封
            .put("0378", "4102")
//洛阳市,洛阳
            .put("0379", "4103")
//信阳市,信阳
            .put("0376", "4115")
//南阳市,南阳
            .put("0377", "4113")
//许昌市,许昌
            .put("0374", "4110")
//平顶山市,平顶山
            .put("0375", "4104")
//南充市,南充
            .put("0817", "5113")
//天水市,天水
            .put("0938", "6205")
//达州市,达州
            .put("0818", "5117")
//张掖市,张掖
            .put("0936", "6207")
//绵阳市,绵阳
            .put("0816", "5107")
//酒泉市,酒泉
            .put("0937", "6209")
//自贡市,自贡
            .put("0813", "5103")
//庆阳市,庆阳
            .put("0934", "6210")
//金昌市,金昌
            .put("0935", "6203")
//定西市,定西
            .put("0932", "6211")
//攀枝花市,攀枝花
            .put("0812", "5104")
//平凉市,平凉
            .put("0933", "6208")
//周口市,周口
            .put("0394", "4116")
//漯河市,漯河
            .put("0395", "4111")
//鹤壁市,鹤壁
            .put("0392", "4106")
//濮阳市,濮阳
            .put("0393", "4109")
//焦作市,焦作
            .put("0391", "4108")
//北京市,北京
            .put("010", "1101")
//广安市,广安
            .put("0826", "5116")
//巴中市,巴中
            .put("0827", "5119")
//遂宁市,遂宁
            .put("0825", "5109")
//鹰潭市,鹰潭
            .put("0701", "3606")
//白银市,白银
            .put("0943", "6204")
//广州市,广州
            .put("020", "4401")
//上海市,上海
            .put("021", "3101")
//天津市,天津
            .put("022", "1201")
//襄阳市,襄阳
            .put("0710", "4206")
//宜宾市,宜宾
            .put("0831", "5115")
//石嘴山市,石嘴山
            .put("0952", "6402")
//重庆市,重庆
            .put("023", "5001")
//鄂州市,鄂州
            .put("0711", "4207")
//资阳市,资阳
            .put("0832", "5120")
//吴忠市,吴忠
            .put("0953", "6403")
//沈阳市,沈阳
            .put("024", "2101")
//南京市,南京
            .put("025", "3201")
//泸州市,泸州
            .put("0830", "5105")
//银川市,银川
            .put("0951", "6401")
//三门峡市,三门峡
            .put("0398", "4112")
//武汉市,武汉
            .put("027", "4201")
//成都市,成都
            .put("028", "5101")
//驻马店市,驻马店
            .put("0396", "4117")
//西安市,西安
            .put("029", "6101")
//广元市,广元
            .put("0839", "5108")
//十堰市,十堰
            .put("0719", "4203")
//荆州市,荆州
            .put("0716", "4210")
//宜昌市,宜昌
            .put("0717", "4205")
//德阳市,德阳
            .put("0838", "5106")
//黄石市,黄石
            .put("0714", "4202")
//雅安市,雅安
            .put("0835", "5118")
//咸宁市,咸宁
            .put("0715", "4212")
//孝感市,孝感
            .put("0712", "4209")
//乐山市,乐山
            .put("0833", "5111")
//固原市,固原
            .put("0954", "6404")
//黄冈市,黄冈
            .put("0713", "4211")
//随州市,随州
            .put("0722", "4213")
//仙桃市,仙桃
            .put("0728", "429004")
//嘉峪关市,嘉峪关
            .put("1937", "6202")
//武威市,武威
            .put("1935", "6206")
//荆门市,荆门
            .put("0724", "4208")
//济源市,济源
            .put("1391", "419001")
//湘潭市,湘潭
            .put("0732", "4303")
//安顺市,安顺
            .put("0853", "5204")
//株洲市,株洲
            .put("0733", "4302")
//岳阳市,岳阳
            .put("0730", "4306")
//贵阳市,贵阳
            .put("0851", "5201")
//海东市,海东
            .put("0972", "6302")
//长沙市,长沙
            .put("0731", "4301")
//遵义市,遵义
            .put("0852", "5203")
//西宁市,西宁
            .put("0971", "6301")
//娄底市,娄底
            .put("0738", "4313")
//邵阳市,邵阳
            .put("0739", "4305")
//毕节市,毕节
            .put("0857", "5205")
//益阳市,益阳
            .put("0737", "4309")
//六盘水市,六盘水
            .put("0858", "5202")
//衡阳市,衡阳
            .put("0734", "4304")
//郴州市,郴州
            .put("0735", "4310")
//铜仁市,铜仁
            .put("0856", "5206")
//眉山市,眉山
            .put("1833", "5114")
//张家界市,张家界
            .put("0744", "4308")
//内江市,内江
            .put("1832", "5110")
//中卫市,中卫
            .put("1953", "6405")
//怀化市,怀化
            .put("0745", "4312")
//永州市,永州
            .put("0746", "4311")
//苏州市,苏州
            .put("0512", "3205")
//日照市,日照
            .put("0633", "3711")
//汕头市,汕头
            .put("0754", "4405")
//保山市,保山
            .put("0875", "5305")
//南通市,南通
            .put("0513", "3206")
//深圳市,深圳
            .put("0755", "4403")
//无锡市,无锡
            .put("0510", "3202")
//威海市,威海
            .put("0631", "3710")
//惠州市,惠州
            .put("0752", "4413")
//镇江市,镇江
            .put("0511", "3211")
//枣庄市,枣庄
            .put("0632", "3704")
//梅州市,梅州
            .put("0753", "4414")
//曲靖市,曲靖
            .put("0874", "5303")
//吐鲁番市,吐鲁番
            .put("0995", "6504")
//江门市,江门
            .put("0750", "4407")
//昆明市,昆明
            .put("0871", "5301")
//韶关市,韶关
            .put("0751", "4402")
//石河子市,石河子
            .put("0993", "659001")
//克拉玛依市,克拉玛依
            .put("0990", "6502")
//昭通市,昭通
            .put("0870", "5306")
//乌鲁木齐市,乌鲁木齐
            .put("0991", "6501")
//连云港市,连云港
            .put("0518", "3207")
//常州市,常州
            .put("0519", "3204")
//天门市,天门
            .put("1728", "429006")
//徐州市,徐州
            .put("0516", "3203")
//肇庆市,肇庆
            .put("0758", "4412")
//普洱市,普洱
            .put("0879", "5308")
//淮安市,淮安
            .put("0517", "3208")
//湛江市,湛江
            .put("0759", "4408")
//扬州市,扬州
            .put("0514", "3210")
//聊城市,聊城
            .put("0635", "3715")
//珠海市,珠海
            .put("0756", "4404")
//玉溪市,玉溪
            .put("0877", "5304")
//陇南市,陇南
            .put("2935", "6212")
//盐城市,盐城
            .put("0515", "3209")
//佛山市,佛山
            .put("0757", "4406")
//泰州市,泰州
            .put("0523", "3212")
//云浮市,云浮
            .put("0766", "4453")
//清远市,清远
            .put("0763", "4418")
//河源市,河源
            .put("0762", "4416")
//临沧市,临沧
            .put("0883", "5309")
//中山市,中山
            .put("0760", "4420")
//宿迁市,宿迁
            .put("0527", "3213")
//东莞市,东莞
            .put("0769", "4419")
//丽江市,丽江
            .put("0888", "5307")
//潮州市,潮州
            .put("0768", "4451")
//抚顺市,抚顺
            .put("0413", "2104")
//德州市,德州
            .put("0534", "3714")
//百色市,百色
            .put("0776", "4510")
//本溪市,本溪
            .put("0414", "2105")
//烟台市,烟台
            .put("0535", "3706")
//钦州市,钦州
            .put("0777", "4507")
//海口市,海口
            .put("0898", "4601")
//大连市,大连
            .put("0411", "2102")
//青岛市,青岛
            .put("0532", "3702")
//梧州市,梧州
            .put("0774", "4504")
//昌都市,昌都
            .put("0895", "5403")
//鞍山市,鞍山
            .put("0412", "2103")
//淄博市,淄博
            .put("0533", "3703")
//玉林市,玉林
            .put("0775", "4509")
//菏泽市,菏泽
            .put("0530", "3717")
//柳州市,柳州
            .put("0772", "4502")
//铁岭市,铁岭
            .put("0410", "2112")
//济南市,济南
            .put("0531", "3701")
//桂林市,桂林
            .put("0773", "4503")
//林芝市,林芝
            .put("0894", "5404")
//防城港市,防城港
            .put("0770", "4506")
//拉萨市,拉萨
            .put("0891", "5401")
//南宁市,南宁
            .put("0771", "4501")
//日喀则市,日喀则
            .put("0892", "5402")
//辽阳市,辽阳
            .put("0419", "2110")
//营口市,营口
            .put("0417", "2108")
//泰安市,泰安
            .put("0538", "3709")
//阜新市,阜新
            .put("0418", "2109")
//临沂市,临沂
            .put("0539", "3713")
//丹东市,丹东
            .put("0415", "2106")
//潍坊市,潍坊
            .put("0536", "3707")
//河池市,河池
            .put("0778", "4512")
//三亚市,三亚
            .put("0899", "4602")
//锦州市,锦州
            .put("0416", "2107")
//济宁市,济宁
            .put("0537", "3708")
//北海市,北海
            .put("0779", "4505")
//新余市,新余
            .put("0790", "3605")
//南昌市,南昌
            .put("0791", "3601")
//图木舒克市,图木舒克
            .put("1998", "659003")
//东营市,东营
            .put("0546", "3705")
//贵港市,贵港
            .put("1755", "4508")
//阿拉尔市,阿拉尔
            .put("1997", "659002")
//滨州市,滨州
            .put("0543", "3716")
//阳江市,阳江
            .put("0662", "4417")
//五家渠市,五家渠
            .put("1994", "659004")
//朝阳市,朝阳
            .put("0421", "2113")
//揭阳市,揭阳
            .put("0663", "4452")
//汕尾市,汕尾
            .put("0660", "4415")
//潜江市,潜江
            .put("2728", "429005")
//葫芦岛市,葫芦岛
            .put("0429", "2114")
//茂名市,茂名
            .put("0668", "4409")
//盘锦市,盘锦
            .put("0427", "2111")
//承德市,承德
            .put("0314", "1308")
//通化市,通化
            .put("0435", "2205")
//安庆市,安庆
            .put("0556", "3408")
//景德镇市,景德镇
            .put("0798", "3602")
//唐山市,唐山
            .put("0315", "1302")
//白城市,白城
            .put("0436", "2208")
//宿州市,宿州
            .put("0557", "3413")
//萍乡市,萍乡
            .put("0799", "3603")
//保定市,保定
            .put("0312", "1306")
//淮南市,淮南
            .put("0554", "3404")
//吉安市,吉安
            .put("0796", "3608")
//张家口市,张家口
            .put("0313", "1307")
//四平市,四平
            .put("0434", "2203")
//马鞍山市,马鞍山
            .put("0555", "3405")
//赣州市,赣州
            .put("0797", "3607")
//邯郸市,邯郸
            .put("0310", "1304")
//长春市,长春
            .put("0431", "2201")
//蚌埠市,蚌埠
            .put("0552", "3403")
//抚州市,抚州
            .put("0794", "3610")
//石家庄市,石家庄
            .put("0311", "1301")
//吉林市,吉林
            .put("0432", "2202")
//芜湖市,芜湖
            .put("0553", "3402")
//宜春市,宜春
            .put("0795", "3609")
//滁州市,滁州
            .put("0550", "3411")
//九江市,九江
            .put("0792", "3604")
//合肥市,合肥
            .put("0551", "3401")
//上饶市,上饶
            .put("0793", "3611")
//衡水市,衡水
            .put("0318", "1311")
//白山市,白山
            .put("0439", "2206")
//邢台市,邢台
            .put("0319", "1305")
//廊坊市,廊坊
            .put("0316", "1310")
//辽源市,辽源
            .put("0437", "2204")
//亳州市,亳州
            .put("0558", "3416")
//沧州市,沧州
            .put("0317", "1309")
//松原市,松原
            .put("0438", "2207")
//黄山市,黄山
            .put("0559", "3410")
//衢州市,衢州
            .put("0570", "3308")
//杭州市,杭州
            .put("0571", "3301")
//万宁市,万宁
            .put("1898", "469006")
//五指山市,五指山
            .put("1897", "469001")
//池州市,池州
            .put("0566", "3417")
//宣城市,宣城
            .put("0563", "3418")
//贺州市,贺州
            .put("1774", "4511")
//六安市,六安
            .put("0564", "3415")
//琼海市,琼海
            .put("1894", "469002")
//淮北市,淮北
            .put("0561", "3406")
//来宾市,来宾
            .put("1772", "4513")
//文昌市,文昌
            .put("1893", "469005")
//铜陵市,铜陵
            .put("0562", "3407")
//崇左市,崇左
            .put("1771", "4514")
//常德市,常德
            .put("07 36", "4307")
//舟山市,舟山
            .put("0580", "3309")
//丽水市,丽水
            .put("0578", "3311")
//伊春市,伊春
            .put("0458", "2307")
//金华市,金华
            .put("0579", "3307")
//绥化市,绥化
            .put("0455", "2312")
//台州市,台州
            .put("0576", "3310")
//秦皇岛市,秦皇岛
            .put("0335", "1303")
//黑河市,黑河
            .put("0456", "2311")
//温州市,温州
            .put("0577", "3303")
//牡丹江市,牡丹江
            .put("0453", "2310")
//宁波市,宁波
            .put("0574", "3302")
//佳木斯市,佳木斯
            .put("0454", "2308")
//绍兴市,绍兴
            .put("0575", "3306")
//哈尔滨市,哈尔滨
            .put("0451", "2301")
//湖州市,湖州
            .put("0572", "3305")
//齐齐哈尔市,齐齐哈尔
            .put("0452", "2302")
//嘉兴市,嘉兴
            .put("0573", "3304")
//大庆市,大庆
            .put("0459", "2306")
//忻州市,忻州
            .put("0350", "1409")
//呼和浩特市,呼和浩特
            .put("0471", "1501")
//厦门市,厦门
            .put("0592", "3502")
//太原市,太原
            .put("0351", "1401")
//包头市,包头
            .put("0472", "1502")
//宁德市,宁德
            .put("0593", "3509")
//呼伦贝尔市,呼伦贝尔
            .put("0470", "1507")
//福州市,福州
            .put("0591", "3501")
//鹤岗市,鹤岗
            .put("0468", "2304")
//阜阳市,阜阳
            .put("1558", "3412")
//双鸭山市,双鸭山
            .put("0469", "2305")
//鸡西市,鸡西
            .put("0467", "2303")
//七台河市,七台河
            .put("0464", "2309")
//哈密市,哈密
            .put("0902", "652201")
//朔州市,朔州
            .put("0349", "1406")
//铜川市,铜川
            .put("0919", "6102")
//吕梁市,吕梁
            .put("0358", "1411")
//运城市,运城
            .put("0359", "1408")
//晋城市,晋城
            .put("0356", "1405")
//鄂尔多斯市,鄂尔多斯
            .put("0477", "1506")
//三明市,三明
            .put("0598", "3504")
//三沙市,三沙
            .put("2898", "4603")
//临汾市,临汾
            .put("0357", "1410")
//巴彦淖尔市,巴彦淖尔
            .put("0478", "1508")
//南平市,南平
            .put("0599", "3507")
//晋中市,晋中
            .put("0354", "1407")
//通辽市,通辽
            .put("0475", "1505")
//漳州市,漳州
            .put("0596", "3506")
//长治市,长治
            .put("0355", "1404")
//赤峰市,赤峰
            .put("0476", "1504")
//龙岩市,龙岩
            .put("0597", "3508")
//大同市,大同
            .put("0352", "1402")
//乌海市,乌海
            .put("0473", "1503")
//莆田市,莆田
            .put("0594", "3503")
//阳泉市,阳泉
            .put("0353", "1403")
//乌兰察布市,乌兰察布
            .put("0474", "1509")
//泉州市,泉州
            .put("0595", "3505")
//汉中市,汉中
            .put("0916", "6107")
//宝鸡市,宝鸡
            .put("0917", "6103")
//商洛市,商洛
            .put("0914", "6110")
//安康市,安康
            .put("0915", "6109")
//榆林市,榆林
            .put("0912", "6108")
//渭南市,渭南
            .put("0913", "6105")
//咸阳市,咸阳
            .put("0910", "6104")
//延安市,延安
            .put("0911", "6106")
            .build();
}

使用映射好的工具类获取到前端传过来的citycode编码

//得到映射后的citycode
 String cityCode = AMapCityCodeConvertUtil.map.get(req.getCityCode());

2.￥以下为前提条件，可忽略！去EaxyExcel读取两套编码

@Getter
@Setter
@EqualsAndHashCode
public class IndexOrNameData {
    @ExcelProperty(index = 0)
    private String parent;
    @ExcelProperty(index = 1)
    private String cityCode;
    @ExcelProperty(index = 2)
    private String cityName;
}

@Getter
@Setter
@EqualsAndHashCode
public class LanHooCityData {
    @ExcelProperty(index = 2)
    private String cityCode;
    @ExcelProperty(index = 0)
    private String cityName;
}

@Slf4j
public class IndexOrNameDataListener extends AnalysisEventListener<IndexOrNameData> {
    /**
     * 每隔5条存储数据库，实际使用中可以100条，然后清理list ，方便内存回收
     */
    private static final int BATCH_COUNT = 5;
    private List<IndexOrNameData> cachedDataList = ListUtils.newArrayListWithExpectedSize(BATCH_COUNT);

    @Override
    public void invoke(IndexOrNameData data, AnalysisContext context) {
       System.out.println(String.format("解析到一条数据:%1s", JSON.toJSONString(data)));
        cachedDataList.add(data);
        if (cachedDataList.size() >= BATCH_COUNT) {
            saveData();
            cachedDataList = ListUtils.newArrayListWithExpectedSize(BATCH_COUNT);
        }
    }

    @Override
    public void doAfterAllAnalysed(AnalysisContext context) {
        saveData();
        log.info("所有数据解析完成！");
    }

    /**
     * 加上存储数据库
     */
    private void saveData() {
        log.info("存储数据库成功！");
    }
}

public class main {
    public static void main(String[] args) {
        String fileName = "/Users/Excel位置/Downloads/城市.xlsx";
        String fileName1 = "/Users/Excel位置/Downloads/AMap_adcode_citycode_20210406.xlsx";
        JSONObject jsonobject = JSON.parseObject("{'010':'北京','020':'广州','021':'上海','022':'天津','023':'重庆','024':'沈阳','025':'南京','027':'武汉','028':'成都','029':'西安','0310':'邯郸','0311':'石家庄','0312':'保定','0313':'张家口','0314':'承德','0315':'唐山','0316':'廊坊','0317':'沧州','0318':'衡水','0319':'邢台','0335':'秦皇岛','0349':'朔州','0350':'忻州','0351':'太原','0352':'大同','0353':'阳泉','0354':'晋中','0355':'长治','0356':'晋城','0357':'临汾','0358':'吕梁','0359':'运城','0370':'商丘','0371':'郑州','0372':'安阳','0373':'新乡','0374':'许昌','0375':'平顶山','0376':'信阳','0377':'南阳','0378':'开封','0379':'洛阳','0391':'焦作','0392':'鹤壁','0393':'濮阳','0394':'周口','0395':'漯河','0396':'驻马店','0398':'三门峡','0410':'铁岭','0411':'大连','0412':'鞍山','0413':'抚顺','0414':'本溪','0415':'丹东','0416':'锦州','0417':'营口','0418':'阜新','0419':'辽阳','0421':'朝阳','0427':'盘锦','0429':'葫芦岛','0431':'长春','0432':'吉林','0434':'四平','0435':'通化','0436':'白城','0437':'辽源','0438':'松原','0439':'白山','0451':'哈尔滨','0452':'齐齐哈尔','0453':'牡丹江','0454':'佳木斯','0455':'绥化','0456':'黑河','0457':'大兴安岭地区','0458':'伊春','0459':'大庆','0464':'七台河','0467':'鸡西','0468':'鹤岗','0469':'双鸭山','0470':'呼伦贝尔','0471':'呼和浩特','0472':'包头','0473':'乌海','0474':'乌兰察布','0475':'通辽','0476':'赤峰','0477':'鄂尔多斯','0478':'巴彦淖尔','0479':'锡林郭勒盟','0482':'兴安盟','0483':'阿拉善盟','0510':'无锡','0511':'镇江','0512':'苏州','0513':'南通','0514':'扬州','0515':'盐城','0516':'徐州','0517':'淮安','0518':'连云港','0519':'常州','0523':'泰州','0527':'宿迁','0530':'菏泽','0531':'济南','0532':'青岛','0533':'淄博','0534':'德州','0535':'烟台','0536':'潍坊','0537':'济宁','0538':'泰安','0539':'临沂','0543':'滨州','0546':'东营','0550':'滁州','0551':'合肥','0552':'蚌埠','0553':'芜湖','0554':'淮南','0555':'马鞍山','0556':'安庆','0557':'宿州','0558':'亳州','0559':'黄山','0561':'淮北','0562':'铜陵','0563':'宣城','0564':'六安','0566':'池州','0570':'衢州','0571':'杭州','0572':'湖州','0573':'嘉兴','0574':'宁波','0575':'绍兴','0576':'台州','0577':'温州','0578':'丽水','0579':'金华','0580':'舟山','0591':'福州','0592':'厦门','0593':'宁德','0594':'莆田','0595':'泉州','0596':'漳州','0597':'龙岩','0598':'三明','0599':'南平','0631':'威海','0632':'枣庄','0633':'日照','0635':'聊城','0660':'汕尾','0662':'阳江','0663':'揭阳','0668':'茂名','0691':'西双版纳傣族自治州','0692':'德宏傣族景颇族自治州','0701':'鹰潭','0710':'襄阳','0711':'鄂州','0712':'孝感','0713':'黄冈','0714':'黄石','0715':'咸宁','0716':'荆州','0717':'宜昌','0718':'恩施土家族苗族自治州','0719':'十堰','0722':'随州','0724':'荆门','0728':'仙桃','0730':'岳阳','0731':'长沙','0732':'湘潭','0733':'株洲','0734':'衡阳','0735':'郴州','07 36':'常德','0737':'益阳','0738':'娄底','0739':'邵阳','0743':'湘西土家族苗族自治州','0744':'张家界','0745':'怀化','0746':'永州','0750':'江门','0751':'韶关','0752':'惠州','0753':'梅州','0754':'汕头','0755':'深圳','0756':'珠海','0757':'佛山','0758':'肇庆','0759':'湛江','0760':'中山','0762':'河源','0763':'清远','0766':'云浮','0768':'潮州','0769':'东莞','0770':'防城港','0771':'南宁','0772':'柳州','0773':'桂林','0774':'梧州','0775':'玉林','0776':'百色','0777':'钦州','0778':'河池','0779':'北海','0790':'新余','0791':'南昌','0792':'九江','0793':'上饶','0794':'抚州','0795':'宜春','0796':'吉安','0797':'赣州','0798':'景德镇','0799':'萍乡','0801':'保亭黎族苗族自治县','0802':'白沙黎族自治县','0803':'昌江黎族自治县','0804':'澄迈县','0805':'儋州','0806':'定安县','0807':'东方','0809':'陵水黎族自治县','0812':'攀枝花','0813':'自贡','0816':'绵阳','0817':'南充','0818':'达州','0825':'遂宁','0826':'广安','0827':'巴中','0830':'泸州','0831':'宜宾','0832':'资阳','0833':'乐山','0834':'凉山彝族自治州','0835':'雅安','0836':'甘孜藏族自治州','0837':'阿坝藏族羌族自治州','0838':'德阳','0839':'广元','0851':'贵阳','0852':'遵义','0853':'安顺','0854':'黔南布依族苗族自治州','0855':'黔东南苗族侗族自治州','0856':'铜仁','0857':'毕节','0858':'六盘水','0859':'黔西南布依族苗族自治州','0870':'昭通','0871':'昆明','0872':'大理白族自治州','0873':'红河哈尼族彝族自治州','0874':'曲靖','0875':'保山','0876':'文山壮族苗族自治州','0877':'玉溪','0878':'楚雄彝族自治州','0879':'普洱','0883':'临沧','0886':'怒江傈僳族自治州','0887':'迪庆藏族自治州','0888':'丽江','0891':'拉萨','0892':'日喀则','0893':'山南','0894':'林芝','0895':'昌都','0896':'那曲','0897':'阿里地区','0898':'海口','0899':'三亚','0901':'塔城地区','0902':'哈密','0903':'和田地区','0906':'阿勒泰地区','0908':'克孜勒苏柯尔克孜自治州','0909':'博尔塔拉蒙古自治州','0910':'咸阳','0911':'延安','0912':'榆林','0913':'渭南','0914':'商洛','0915':'安康','0916':'汉中','0917':'宝鸡','0919':'铜川','0930':'临夏回族自治州','0931':'兰州','0932':'定西','0933':'平凉','0934':'庆阳','0935':'金昌','0936':'张掖','0937':'酒泉','0938':'天水','0941':'甘南藏族自治州','0943':'白银','0951':'银川','0952':'石嘴山','0953':'吴忠','0954':'固原','0970':'海北藏族自治州','0971':'西宁','0972':'海东','0973':'黄南藏族自治州','0974':'海南藏族自治州','0975':'果洛藏族自治州','0976':'玉树藏族自治州','0977':'海西蒙古族藏族自治州','0990':'克拉玛依','0991':'乌鲁木齐','0992':'胡杨河','0993':'石河子','0994':'昌吉回族自治州','0995':'吐鲁番','0996':'巴音郭楞蒙古自治州','0997':'阿克苏地区','0998':'喀什地区','0999':'伊犁哈萨克自治州',1391:'济源',1433:'延边朝鲜族自治州',1558:'阜阳',1719:'神农架林区',1728:'天门',1755:'贵港',1771:'崇左',1772:'来宾',1774:'贺州',1832:'内江',1833:'眉山',1852:'香港特别行政区',1853:'澳门特别行政区',1892:'屯昌县',1893:'文昌',1894:'琼海',1896:'临高县',1897:'五指山',1898:'万宁',1899:'琼中黎族苗族自治县',1903:'昆玉',1906:'北屯',1909:'双河',1935:'武威',1937:'嘉峪关',1953:'中卫',1994:'五家渠',1996:'铁门关',1997:'阿拉尔',1998:'图木舒克',1999:'可克达拉',2728:'潜江',2802:'乐东黎族自治县',2898:'三沙',2935:'陇南',}");
        System.out.println(jsonobject.size());
      List<IndexOrNameData> lanHooCityList =indexOrNameRead(fileName, IndexOrNameData.class, new IndexOrNameDataListener());

        List<LanHooCityData> aMapCityList =  indexOrNameRead(fileName1, LanHooCityData.class, new AnalysisEventListener() {
            @Override
            public void invoke(Object o, AnalysisContext analysisContext) {
            }

            @Override
            public void doAfterAllAnalysed(AnalysisContext analysisContext) {

            }
        });

        Map<String, String> lanHooCityCodeMap = lanHooCityList.stream().filter(i-> i.getCityName().endsWith("市")).collect(Collectors.toMap(IndexOrNameData::getCityName, IndexOrNameData::getCityCode,(key1 , key2)-> key2 ));
//        Map<String, String> aMapCityCodeMap = aMapCityList.stream().filter(i-> Objects.nonNull(i.getCityCode())&&Objects.nonNull(jsonobject.getString(i.getCityCode())) && jsonobject.getString(i.getCityCode()).startsWith(i.getCityName())).collect(Collectors.toMap(LanHooCityData::getCityName, LanHooCityData::getCityCode,(key1 , key2)-> key2 ));

        Integer count = 0;
        for (Map.Entry<String, Object> item : jsonobject.entrySet()) {
            for (Map.Entry<String, String> childItem : lanHooCityCodeMap.entrySet()) {
                if(childItem.getKey().startsWith((String) item.getValue())){
                    count ++;
                    System.out.println("//"+childItem.getKey()+","+item.getValue());
                    System.out.println(".put(\""+item.getKey()+"\",\""+childItem.getValue()+")");
                    break;

                }
            }
        }



        System.out.println("数量"+count);

    }

    public static List indexOrNameRead(String fileName ,Class c, AnalysisEventListener listener) {

        // 这里默认读取第一个sheet

        ExcelReaderBuilder qq = EasyExcel.read(fileName, c, listener);
       return  qq.sheet().doReadSync();
    }
}