资讯详情

使用Stream生成菜单、地区树

使用Stream生成菜单，区域树

文章目录

    • 使用Stream生成菜单，区域树
      • 一、定义基类
      • 二、定义一个Menu类
      • 三、定义一个City类
      • 四、定义工具类
      • 五、测试
      • 六、附城市地区文件：

一、定义基类

/** * 生成菜单树的类需要继承 * @param <T> 泛型 */ public class BaseTreeData<T> { 
              protected Integer id;     protected Integer parentId;     protected List<T> childList;      public BaseTreeData(Integer id, Integer parentId) { 
                 this.id = id;         this.parentId = parentId;     }      public BaseTreeData(Integer id, Integer parentId, List<T> childList) { 
                 this.id = id;         this.parentId = parentId;         this.childList = childList;     }      public Integer getId() { 
                 return id;     }      public void setId(Integer id) { 
                 this.id = id;     }      public Integer getParentId() { 
        
        return parentId;
    }

    public void setParentId(Integer parentId) { 
        
        this.parentId = parentId;
    }

    public List<T> getChildList() { 
        
        return childList;
    }

    public void setChildList(List<T> childList) { 
        
        this.childList = childList;
    }
}

二、定义一个Menu类

public class Menu extends BaseTreeData<Menu> { 
        
    private String menuName;

    public Menu(Integer id, String menuName, Integer parentId) { 
        
        super(id,parentId);
        this.menuName= menuName;
    }

    public String getMenuName() { 
        
        return name;
    }
}

三、定义一个City类

public class City extends BaseTreeData<City> { 
        
    private String cityName;
    private String cityCode;

    public City(Integer id, String cityName, String cityCode, Integer parentId) { 
        
       super(id,parentId);
       this.cityName=cityName;
       this.cityCode=cityCode;
    }

    public String getCityName() { 
        
        return cityName;
    }

    public String getCityCode() { 
        
        return cityCode;
    }
}

四、定义一个工具类

public class TreeFormatUtil { 
        

    public static <E extends BaseTreeData<E>> List<E> getTreedData(List<E> dataList, Integer rootId) { 
        
        return dataList.stream()
                .filter(data -> Objects.equals(data.getParentId(), rootId))
                .peek(data -> data.setChildList(getChildren(data, dataList)))
                .collect(Collectors.toList());
    }

    private static <E extends BaseTreeData<E>> List<E> getChildren(E root, List<E> dataList) { 
        
        return dataList.stream()
                .filter(data -> data.getParentId().equals(root.getId()))
                .peek(data -> data.setChildList(getChildren(data, dataList)))
                .collect(Collectors.toList());
    }
}

五、测试

public class TreeTest { 
        
    public static void main(String[] args) throws IOException { 
        

        List<City> cities = new LinkedList<>();

        File file = new File("cities.txt");

        FileReader fileReader = new FileReader(file);
        BufferedReader bufferedReader = new BufferedReader(fileReader);
        String s = null;
        while ((s = bufferedReader.readLine()) != null) { 
        
            String[] split = s.split("'");
            //获取id
            Integer id = Integer.parseInt(split[1]);
            String cityName = split[5];
            Integer parentId = Integer.parseInt(split[7]);
            String cityCode = split[3];
            cities.add(new City(id, cityName, cityCode, parentId));

        }
        bufferedReader.close();
        fileReader.close();

        List<City> cityTree = TreeFormatUtil.getTreedData(cities, 0);

        System.out.println(JSON.toJSONString(cityTree, true));

        List<Menu> menus = Arrays.asList(
                new Menu(1, "后台管理", 0),
                new Menu(2, "用户管理", 1),
                new Menu(3, "菜单管理", 1),
                new Menu(4, "前端管理", 0),
                new Menu(5, "字典管理", 4),
                new Menu(6, "数据库管理", 4)
        );

        List<Menu> menuTree = TreeFormatUtil.getTreedData(menus, 0);
        System.out.println(JSON.toJSONString(menuTree, true));

    }

}

六、附城市地区文件：

INSERT INTO `region_city` VALUES ('1', '110000', '北京市', '0');
INSERT INTO `region_city` VALUES ('2', '110101', '东城区', '1');
INSERT INTO `region_city` VALUES ('3', '110102', '西城区', '1');
INSERT INTO `region_city` VALUES ('4', '110105', '朝阳区', '1');
INSERT INTO `region_city` VALUES ('5', '110106', '丰台区', '1');
INSERT INTO `region_city` VALUES ('6', '110107', '石景山区', '1');
INSERT INTO `region_city` VALUES ('7', '110108', '海淀区', '1');
INSERT INTO `region_city` VALUES ('8', '110109', '门头沟区', '1');
INSERT INTO `region_city` VALUES ('9', '110111', '房山区', '1');
INSERT INTO `region_city` VALUES ('10', '110112', '通州区', '1');
INSERT INTO `region_city` VALUES ('11', '110113', '顺义区', '1');
INSERT INTO `region_city` VALUES ('12', '110114', '昌平区', '1');
INSERT INTO `region_city` VALUES ('13', '110115', '大兴区', '1');
INSERT INTO `region_city` VALUES ('14', '110116', '怀柔区', '1');
INSERT INTO `region_city` VALUES ('15', '110117', '平谷区', '1');
INSERT INTO `region_city` VALUES ('16', '110118', '密云区', '1');
INSERT INTO `region_city` VALUES ('17', '110119', '延庆区', '1');
INSERT INTO `region_city` VALUES ('18', '120000', '天津市', '0');
INSERT INTO `region_city` VALUES ('19', '120101', '和平区', '18');
INSERT INTO `region_city` VALUES ('20', '120102', '河东区', '18');
INSERT INTO `region_city` VALUES ('21', '120103', '河西区', '18');
INSERT INTO `region_city` VALUES ('22', '120104', '南开区', '18');
INSERT INTO `region_city` VALUES ('23', '120105', '河北区', '18');
INSERT INTO `region_city` VALUES ('24', '120106', '红桥区', '18');
INSERT INTO `region_city` VALUES ('25', '120110', '东丽区', '18');
INSERT INTO `region_city` VALUES ('26', '120111', '西青区', '18');
INSERT INTO `region_city` VALUES ('27', '120112', '津南区', '18');
INSERT INTO `region_city` VALUES ('28', '120113', '北辰区', '18');
INSERT INTO `region_city` VALUES ('29', '120114', '武清区', '18');
INSERT INTO `region_city` VALUES ('30', '120115', '宝坻区', '18');
INSERT INTO `region_city` VALUES ('31', '120116', '滨海新区', '18');
INSERT INTO `region_city` VALUES ('32', '120117', '宁河区', '18');
INSERT INTO `region_city` VALUES ('33', '120118', '静海区', '18');
INSERT INTO `region_city` VALUES ('34', '120119', '蓟州区', '18');
INSERT INTO `region_city` VALUES ('35', '130000', '河北省', '0');
INSERT INTO `region_city` VALUES ('36', '130100', '石家庄市', '35');
INSERT INTO `region_city` VALUES ('37', '130102', '长安区', '36');
INSERT INTO `region_city` VALUES ('38', '130104', '桥西区', '36');
INSERT INTO `region_city` VALUES ('39', '130105', '新华区', '36');
INSERT INTO `region_city` VALUES ('40', '130107', '井陉矿区', '36');
INSERT INTO `region_city` VALUES ('41', '130108', '裕华区', '36');
INSERT INTO `region_city` VALUES ('42', '130109', '藁城区', '36');
INSERT INTO `region_city` VALUES ('43', '130110', '鹿泉区', '36');
INSERT INTO `region_city` VALUES ('44', '130111', '栾城区', '36');
INSERT INTO `region_city` VALUES ('45', '130121', '井陉县', '36');
INSERT INTO `region_city` VALUES ('46', '130123', '正定县', '36');
INSERT INTO `region_city` VALUES ('47', '130125', '行唐县', '36');
INSERT INTO `region_city` VALUES ('48', '130126', '灵寿县', '36');
INSERT INTO `region_city` VALUES ('49', '130127', '高邑县', '36');
INSERT INTO `region_city` VALUES ('50', '130128', '深泽县', '36');
INSERT INTO `region_city` VALUES ('51', '130129', '赞皇县', '36');
INSERT INTO `region_city` VALUES ('52', '130130', '无极县', '36');
INSERT INTO `region_city` VALUES ('53', '130131', '平山县', '36');
INSERT INTO `region_city` VALUES ('54', '130132', '元氏县', '36');
INSERT INTO `region_city` VALUES ('55', '130133', '赵县', '36');
INSERT INTO `region_city` VALUES ('56', '130181', '辛集市', '36');
INSERT INTO `region_city` VALUES ('57', '130183', '晋州市', '36');
INSERT INTO `region_city` VALUES ('58', '130184', '新乐市', '36');
INSERT INTO `region_city` VALUES ('59', '130200', '唐山市', '35');
INSERT INTO `region_city` VALUES ('60', '130202', '路南区', '59');
INSERT INTO `region_city` VALUES ('61', '130203', '路北区', '59');
INSERT INTO `region_city` VALUES ('62', '130204', '古冶区', '59');
INSERT INTO `region_city` VALUES ('63', '130205', '开平区', '59');
INSERT INTO `region_city` VALUES ('64', '130207', '丰南区', '59');
INSERT INTO `region_city` VALUES ('65', '130208', '丰润区', '59');
INSERT INTO `region_city` VALUES ('66', '130209', '曹妃甸区', '59');
INSERT INTO `region_city` VALUES ('67', '130223', '滦县', '59');
INSERT INTO `region_city` VALUES ('68', '130224', '滦南县', '59');
INSERT INTO `region_city` VALUES ('69', '130225', '乐亭县', '59');
INSERT INTO `region_city` VALUES ('70', '130227', '迁西县', '59');
INSERT INTO `region_city` VALUES ('71', '130229', '玉田县', '59');
INSERT INTO `region_city` VALUES ('72', '130281', '遵化市', '59');
INSERT INTO `region_city` VALUES ('73', '130283', '迁安市', '59');
INSERT INTO `region_city` VALUES ('74', '130300', '秦皇岛市', '35');
INSERT INTO `region_city` VALUES ('75', '130302', '海港区', '74');
INSERT INTO `region_city` VALUES ('76', '130303', '山海关区', '74');
INSERT INTO `region_city` VALUES ('77', '130304', '北戴河区', '74');
INSERT INTO `region_city` VALUES ('78', '130306', '抚宁区', '74');
INSERT INTO `region_city` VALUES ('79', '130321', '青龙满族自治县', '74');
INSERT INTO `region_city` VALUES ('80', '130322', '昌黎县', '74');
INSERT INTO `region_city` VALUES ('81', '130324', '卢龙县', '74');
INSERT INTO `region_city` VALUES ('82', '130400', '邯郸市', '35');
INSERT INTO `region_city` VALUES ('83', '130402', '邯山区', '82');
INSERT INTO `region_city` VALUES ('84', '130403', '丛台区', '82');
INSERT INTO `region_city` VALUES ('85', '130404', '复兴区', '82');
INSERT INTO `region_city` VALUES ('86', '130406', '峰峰矿区', '82');
INSERT INTO `region_city` VALUES ('87', '130407', '肥乡区', '82');
INSERT INTO `region_city` VALUES ('88', '130408', '永年区', '82');
INSERT INTO `region_city` VALUES ('89', '130423', '临漳县', '82');
INSERT INTO `region_city` VALUES ('90', '130424', '成安县', '82');
INSERT INTO `region_city` VALUES ('91', '130425', '大名县', '82');
INSERT INTO `region_city` VALUES ('92', '130426', '涉县', '82');
INSERT INTO `region_city` VALUES ('93', '130427', '磁县', '82');
INSERT INTO `region_city` VALUES ('94', '130430', '邱县', '82');
INSERT INTO `region_city` VALUES ('95', '130431', '鸡泽县', '82');
INSERT INTO `region_city` VALUES ('96', '130432', '广平县', '82');
INSERT INTO `region_city` VALUES ('97', '130433', '馆陶县', '82');
INSERT INTO `region_city` VALUES ('98', '130434', '魏县', '82');
INSERT INTO `region_city` VALUES ('99', '130435', '曲周县', '82');
INSERT INTO `region_city` VALUES ('100', '130481', '武安市', '82');
INSERT INTO `region_city` VALUES ('101', '130500', '邢台市', '35');
INSERT INTO `region_city` VALUES ('102', '130502', '桥东区', '101');
INSERT INTO `region_city` VALUES ('103', '130503', '桥西区', '101');
INSERT INTO `region_city` VALUES ('104', '130521', '邢台县', '101');
INSERT INTO `region_city` VALUES ('105', '130522', '临城县', '101');
INSERT INTO `region_city` VALUES ('106', '130523', '内丘县', '101');
INSERT INTO `region_city` VALUES ('107', '130524', '柏乡县', '101');
INSERT INTO `region_city` VALUES ('108', '130525', '隆尧县', '101');
INSERT INTO `region_city` VALUES ('109', '130526', '任县', '101');
INSERT INTO `region_city` VALUES ('110', '130527', '南和县', '101');
INSERT INTO `region_city` VALUES ('111', '130528', '宁晋县', '101');
INSERT INTO `region_city` VALUES ('112', '130529', '巨鹿县', '101');
INSERT INTO `region_city` VALUES ('113', '130530', '新河县', '101');
INSERT INTO `region_city` VALUES ('114', '130531', '广宗县', '101');
INSERT INTO `region_city` VALUES ('115', '130532', '平乡县', '101');
INSERT INTO `region_city` VALUES ('116', '130533', '威县', '101');
INSERT INTO `region_city` VALUES ('117', '130534', '清河县', '101');
INSERT INTO `region_city` VALUES ('118', '130535', '临西县', '101');
INSERT INTO `region_city` VALUES ('119', '130581', '南宫市', '101');
INSERT INTO `region_city` VALUES ('120', '130582', '沙河市', '101');
INSERT INTO `region_city` VALUES ('121', '130600', '保定市', '35');
INSERT INTO `region_city` VALUES ('122', '130602', '竞秀区', '121');
INSERT INTO `region_city` VALUES ('123', '130606', '莲池区', '121');
INSERT INTO `region_city` VALUES ('124', '130607', '满城区', '121');
INSERT INTO `region_city` VALUES ('125', '130608', '清苑区', '121');
INSERT INTO `region_city` VALUES ('126', '130609', '徐水区', '121');
INSERT INTO `region_city` VALUES ('127', '130623', '涞水县', '121');
INSERT INTO `region_city` VALUES ('128', '130624', '阜平县', '121');
INSERT INTO `region_city` VALUES ('129', '130626', '定兴县', '121');
INSERT INTO `region_city` VALUES ('130', '130627', '唐县', '121');
INSERT INTO `region_city` VALUES ('131', '130628', '高阳县', '121');
INSERT INTO `region_city` VALUES ('132', '130629', '容城县', '121');
INSERT INTO `region_city` VALUES ('133', '130630', '涞源县', '121');
INSERT INTO `region_city` VALUES ('134', '130631', '望都县', '121');
INSERT INTO `region_city` VALUES ('135', '130632', '安新县', '121');
INSERT INTO `region_city` VALUES ('136', '130633', '易县', '121');
INSERT INTO `region_city` VALUES ('137', '130634', '曲阳县', '121');
INSERT INTO `region_city` VALUES ('138', '130635', '蠡县', '121');
INSERT INTO `region_city` VALUES ('139', '130636', '顺平县', '121');
INSERT INTO `region_city` VALUES ('140', '130637', '博野县', '121');
INSERT INTO `region_city` VALUES ('141', '130638', '雄县', '121');
INSERT INTO `region_city` VALUES ('142', '130681', '涿州市', '121');
INSERT INTO `region_city` VALUES ('143', '130682', '定州市', '121');
INSERT INTO `region_city` VALUES ('144', '130683', '安国市', '121');
INSERT INTO `region_city` VALUES ('145', '130684', '高碑店市', '121');
INSERT INTO `region_city` VALUES ('146', '130700', '张家口市', '35');
INSERT INTO `region_city` VALUES ('147', '130702', '桥东区', '146');
INSERT INTO `region_city` VALUES ('148', '130703', '桥西区', '146');
INSERT INTO `region_city` VALUES ('149', '130705', '宣化区', '146');
INSERT INTO `region_city` VALUES ('150', '130706', '下花园区', '146');
INSERT INTO `region_city` VALUES ('151', '130708', '万全区', '146');
INSERT INTO `region_city` VALUES ('152', '130709', '崇礼区', '146');
INSERT INTO `region_city` VALUES ('153', '130722', '张北县', '146');
INSERT INTO `region_city` VALUES ('154', '130723', '康保县', '146');
INSERT INTO `region_city` VALUES ('155', '130724', '沽源县', '146');
INSERT INTO `region_city` VALUES ('156', '130725', '尚义县', '146');
INSERT INTO `region_city` VALUES ('157', '130726', '蔚县', '146');
INSERT INTO `region_city` VALUES ('158', '130727', '阳原县', '146');
INSERT INTO `region_city` VALUES ('159', '130728', '怀安县', '146');
INSERT INTO `region_city` VALUES ('160', '130730', '怀来县', '146');
INSERT INTO `region_city` VALUES ('161', '130731', '涿鹿县', '146');
INSERT INTO `region_city` VALUES ('162', '130732', '赤城县', '146');
INSERT INTO `region_city` VALUES ('163', '130800', '承德市', '35');
INSERT INTO `region_city` VALUES ('164', '130802', '双桥区', '163');
INSERT INTO `region_city` VALUES ('165', '130803', '双滦区', '163');
INSERT INTO `region_city` VALUES ('166', '130804', '鹰手营子矿区', '163');
INSERT INTO `region_city` VALUES ('167', '130821', '承德县', '163');
INSERT INTO `region_city` VALUES ('168', '130822', '兴隆县', '163');
INSERT INTO `region_city` VALUES ('169', '130824', '滦平县', '163');
INSERT INTO `region_city` VALUES ('170', '130825', '隆化县', '163');
INSERT INTO `region_city` VALUES ('171', '130826', '丰宁满族自治县', '163');
INSERT INTO `region_city` VALUES ('172', '130827', '宽城满族自治县', '163');
INSERT INTO `region_city` VALUES ('173', '130828', '围场满族蒙古族自治县', '163');
INSERT INTO `region_city` VALUES ('174', '130881', '平泉市', '163');
INSERT INTO `region_city` VALUES ('175', '130900', '沧州市', '35');
INSERT INTO `region_city` VALUES ('176', '130902', '新华区', '175');
INSERT INTO `region_city` VALUES ('177', '130903', '运河区', '175');
INSERT INTO `region_city` VALUES ('178', '130921', '沧县', '175');
INSERT INTO `region_city` VALUES ('179', '130922', '青县', '175');
INSERT INTO `region_city` VALUES ('180', '130923', '东光县', '175');
INSERT INTO `region_city` VALUES ('181', '130924', '海兴县', '175');
INSERT INTO `region_city` VALUES ('182', '130925', '盐山县', '175');
INSERT INTO `region_city` VALUES ('183', '130926', '肃宁县', '175');
INSERT INTO `region_city` VALUES ('184', '130927', '南皮县', '175');
INSERT INTO `region_city` VALUES ('185', '130928', '吴桥县', '175');
INSERT INTO `region_city` VALUES ('186', '130929', '献县', '175');
INSERT INTO `region_city` VALUES ('187', '130930', '孟村回族自治县', '175');
INSERT INTO `region_city` VALUES ('188', '130981', '泊头市', '175');
INSERT INTO `region_city` VALUES ('189', '130982', '任丘市', '175');
INSERT INTO `region_city` VALUES ('190', '130983', '黄骅市', '175');
INSERT INTO `region_city` VALUES ('191', '130984', '河间市', '175');
INSERT INTO `region_city` VALUES ('192', '131000', '廊坊市', '35');
INSERT INTO `region_city` VALUES ('193', '131002', '安次区', '192');
INSERT INTO `region_city` VALUES ('194', '131003', '广阳区', '192');
INSERT INTO `region_city` VALUES ('195', '131022', '固安县', '192');
INSERT INTO `region_city` VALUES ('196', '131023', '永清县', '192');
INSERT INTO `region_city` VALUES ('197', '131024', '香河县', '192');
INSERT INTO `region_city` VALUES ('198', '131025', '大城县', '192');
INSERT INTO `region_city` VALUES ('199', '131026', '文安县', '192');
INSERT INTO `region_city` VALUES ('200', '131028', '大厂回族自治县', '192');
INSERT INTO `region_city` VALUES ('201', '131081', '霸州市', '192');
INSERT INTO `region_city` VALUES ('202', '131082', '三河市', '192');
INSERT INTO `region_city` VALUES ('203', '131100', '衡水市', '35');
INSERT INTO `region_city` VALUES ('204', '131102', '桃城区', '203');
INSERT INTO `region_city` VALUES ('205', '131103', '冀州区', '203');
INSERT INTO `region_city` VALUES ('206', '131121', '枣强县', '203');
INSERT INTO `region_city` VALUES ('207', '131122', '武邑县', '203');
INSERT INTO `region_city` VALUES ('208', '131123', '武强县', '203');
INSERT INTO `region_city` VALUES ('209', '131124', '饶阳县', '203');
INSERT INTO `region_city` VALUES ('210', '131125', '安平县', '203');
INSERT INTO `region_city` VALUES ('211', '131126', '故城县', '203');
INSERT INTO `region_city` VALUES ('212', '131127', '景县', '203');
INSERT INTO `region_city` VALUES ('213', '131128', '阜城县', '203');
INSERT INTO `region_city` VALUES ('214', '131182', '深州市', '203');
INSERT INTO `region_city` VALUES ('215', '140000', '山西省', '0');
INSERT INTO `region_city` VALUES ('216', '140100', '太原市', '215');
INSERT INTO `region_city` VALUES ('217', '140105', '小店区', '216');
INSERT INTO `region_city` VALUES ('218', '140106', '迎泽区', '216');
INSERT INTO `region_city` VALUES ('219', '140107', '杏花岭区', '216');
INSERT INTO `region_city` VALUES ('220', '140108', '尖草坪区', '216');
INSERT INTO `region_city` VALUES ('221', '140109', '万柏林区', '216');
INSERT INTO `region_city` VALUES ('222', '140110', '晋源区', '216');
INSERT INTO `region_city` VALUES ('223', '140121', '清徐县', '216');
INSERT INTO `region_city` VALUES ('224', '140122', '阳曲县', '216');
INSERT INTO `region_city` VALUES ('225', '140123', '娄烦县', '216');
INSERT INTO `region_city` VALUES ('226', '140181', '古交市', '216');
INSERT INTO `region_city` VALUES ('227', '140200', '大同市', '215');
INSERT INTO `region_city` VALUES ('228', '140202', '城区', '227');
INSERT INTO `region_city` VALUES ('229', '140203', '矿区', '227');
INSERT INTO `region_city` VALUES ('230', '140211', '南郊区', '227');
INSERT INTO `region_city` VALUES ('231', '140212', '新荣区', '227');
INSERT INTO `region_city` VALUES ('232', '140221', '阳高县', '227');
INSERT INTO `region_city` VALUES ('233', '140222', '天镇县', '227');
INSERT INTO `region_city` VALUES ('234', '140223', '广灵县', '227');
INSERT INTO `region_city` VALUES ('235', '140224', '灵丘县', '227');
INSERT INTO `region_city` VALUES ('236', '140225', '浑源县', '227');
INSERT INTO `region_city` VALUES ('237', '140226', '左云县', '227');
INSERT INTO `region_city` VALUES ('238', '140227', '大同县', '227');
INSERT INTO `region_city` VALUES ('239', '140300', '阳泉市', '215');
INSERT INTO `region_city` VALUES ('240', '140302', '城区', '239');
INSERT INTO `region_city` VALUES ('241', '140303', '矿区', '239');
INSERT INTO `region_city` VALUES ('242', '140311', '郊区', '239');
INSERT INTO `region_city` VALUES ('243', '140321', '平定县', '239');
INSERT INTO `region_city` VALUES ('244', '140322', '盂县', '239');
INSERT INTO `region_city` VALUES ('245', '140400', '长治市', '215');
INSERT INTO `region_city` VALUES ('246', '140402', '城区', '245');
INSERT INTO `region_city` VALUES ('247', '140411', '郊区', '245');
INSERT INTO `region_city` VALUES ('248', '140421', '长治县', '245');
INSERT INTO `region_city` VALUES ('249', '140423', '襄垣县', '245');
INSERT INTO `region_city` VALUES ('250', '140424', '屯留县', '245');
INSERT INTO `region_city` VALUES ('251', '140425', '平顺县', '245');
INSERT INTO `region_city` VALUES ('252', '140426', '黎城县', '245');
INSERT INTO `region_city` VALUES ('253', '140427', '壶关县', '245');
INSERT INTO `region_city` VALUES ('254', '140428', '长子县', '245');
INSERT INTO `region_city` VALUES ('255', '140429', '武乡县', '245');
INSERT INTO `region_city` VALUES ('256', '140430', '沁县', '245');
INSERT INTO `region_city` VALUES ('257', '140431', '沁源县', '245');
INSERT INTO `region_city` VALUES ('258', '140481', '潞城市', '245');
INSERT INTO `region_city` VALUES ('259', '140500', '晋城市', '215');
INSERT INTO `region_city` VALUES ('260', '140502', '城区', '259');
INSERT INTO `region_city` VALUES ('261', '140521', '沁水县', '259');
INSERT INTO `region_city` VALUES ('262', '140522', '阳城县', '259');
INSERT INTO `region_city` VALUES ('263', '140524', '陵川县', '259');
INSERT INTO `region_city` VALUES ('264', '140525', '泽州县', '259');
INSERT INTO `region_city` VALUES ('265', '140581', '高平市', '259');
INSERT INTO `region_city` VALUES ('266', '140600', '朔州市', '215');
INSERT INTO `region_city` VALUES ('267', '140602', '朔城区', '266');
INSERT INTO `region_city` VALUES ('268', '140603', '平鲁区', '266');
INSERT INTO `region_city` VALUES ('269', '140621', '山阴县', '266');
INSERT INTO `region_city` VALUES ('270', '140622', '应县', '266');
INSERT INTO `region_city` VALUES ('271', '140623', '右玉县', '266');
INSERT INTO `region_city` VALUES ('272', '140624', '怀仁县', '266');
INSERT INTO `region_city` VALUES ('273', '140700', '晋中市', '215');
INSERT INTO `region_city` VALUES ('274', '140702', '榆次区', '273');
INSERT INTO `region_city` VALUES ('275', '140721', '榆社县', '273');
INSERT INTO `region_city` VALUES ('276', '140722', '左权县', '273');
INSERT INTO `region_city` VALUES ('277', '140723', '和顺县', '273');
INSERT INTO `region_city` VALUES ('278', '140724', '昔阳县', '273');
INSERT INTO `region_city` VALUES ('279', '140725', '寿阳县', '273');
INSERT INTO `region_city` VALUES ('280', '140726', '太谷县', '273');
INSERT INTO `region_city` VALUES ('281', '140727', '祁县', '273');
INSERT INTO `region_city` VALUES ('282', '140728', '平遥县', '273');
INSERT INTO `region_city` VALUES ('283', '140729', '灵石县', '273');
INSERT INTO `region_city` VALUES ('284', '140781', '介休市', '273');
INSERT INTO `region_city` VALUES ('285', '140800', '运城市', '215');
INSERT INTO `region_city` VALUES ('286', '140802', '盐湖区', '285');
INSERT INTO `region_city` VALUES ('287', '140821', '临猗县', '285');
INSERT INTO `region_city` VALUES ('288', '140822', '万荣县', '285');
INSERT INTO `region_city` VALUES ('289', '140823', '闻喜县', '285');
INSERT INTO `region_city` VALUES ('290', '140824', '稷山县', '285');
INSERT INTO `region_city` VALUES ('291', '140825', '新绛县', '285');
INSERT INTO `region_city` VALUES ('292', '140826', '绛县', '285');
INSERT INTO `region_city` VALUES ('293', '140827', '垣曲县', '285');
INSERT INTO `region_city` VALUES ('294', '140828', '夏县', '285');
INSERT INTO `region_city` VALUES ('295', '140829', '平陆县', '285');
INSERT INTO `region_city` VALUES ('296', '140830', '芮城县', '285');
INSERT INTO `region_city` VALUES ('297', '140881', '永济市', '285');
INSERT INTO `region_city` VALUES ('298', '140882', '河津市', '285');
INSERT INTO `region_city` VALUES ('299', '140900', '忻州市', '215');
INSERT INTO `region_city` VALUES ('300', '140902', '忻府区', '299');
INSERT INTO `region_city` VALUES ('301', '140921', '定襄县', '299');
INSERT INTO `region_city` VALUES ('302', '140922', '五台县', '299');
INSERT INTO `region_city` VALUES ('303', '140923', '代县', '299');
INSERT INTO `region_city` VALUES ('304', '140924', '繁峙县', '299');
INSERT INTO `region_city` VALUES ('305', '140925', '宁武县', '299');
INSERT INTO `region_city` VALUES ('306', '140926', '静乐县', '299');
INSERT INTO `region_city` VALUES ('307', '140927', '神池县', '299');
INSERT INTO `region_city` VALUES ('308', '140928', '五寨县', '299');
INSERT INTO `region_city` VALUES ('309', '140929', '岢岚县', '299');
INSERT INTO `region_city` VALUES ('310', '140930', '河曲县', '299');
INSERT INTO `region_city` VALUES ('311', '140931', '保德县', '299');
INSERT INTO `region_city` VALUES ('312', '140932', '偏关县', '299');
INSERT INTO `region_city` VALUES ('313', '140981', '原平市', '299');
INSERT INTO `region_city` VALUES ('314', '141000', '临汾市', '215');
INSERT INTO `region_city` VALUES ('315', '141002', '尧都区', '314');
INSERT INTO `region_city` VALUES ('316', '141021', '曲沃县', '314');
INSERT INTO `region_city` VALUES ('317', '141022', '翼城县', '314');
INSERT INTO `region_city` VALUES ('318', '141023', '襄汾县', '314');
INSERT INTO `region_city` VALUES ('319', '141024', '洪洞县', '314');
INSERT INTO `region_city` VALUES ('320', '141025', '古县', '314');
INSERT INTO `region_city` VALUES ('321', '141026', '安泽县', '314');
INSERT INTO `region_city` VALUES ('322', '141027', '浮山县', '314');
INSERT INTO `region_city` VALUES ('323', '141028', '吉县', '314');
INSERT INTO `region_city` VALUES ('324', '141029', '乡宁县', '314');
INSERT INTO `region_city` VALUES ('325', '141030', '大宁县', '314');
INSERT INTO `region_city` VALUES ('326', '141031', '隰县', '314');
INSERT INTO `region_city` VALUES ('327', '141032', '永和县', '314');
INSERT INTO `region_city` VALUES ('328', '141033', '蒲县', '314');
INSERT INTO `region_city` VALUES ('329', '141034', '汾西县', '314');
INSERT INTO `region_city` VALUES ('330', '141081', '侯马市', '314');
INSERT INTO `region_city` VALUES ('331', '141082', '霍州市', '314');
INSERT INTO `region_city` VALUES ('332', '141100', '吕梁市', '215');
INSERT INTO `region_city` VALUES ('333', '141102', '离石区', '332');
INSERT INTO `region_city` VALUES ('334', '141121', '文水县', '332');
INSERT INTO `region_city` VALUES ('335', '141122', '交城县', '332');
INSERT INTO `region_city` VALUES ('336', '141123', '兴县', '332');
INSERT INTO `region_city` VALUES ('337', '141124', '临县', '332');
INSERT INTO `region_city` VALUES ('338', '141125', '柳林县', '332');
INSERT INTO `region_city` VALUES ('339', '141126', '石楼县', '332');
INSERT INTO `region_city` VALUES ('340', '141127', '岚县', '332');
INSERT INTO `region_city` VALUES ('341', '141128', '方山县', '332');
INSERT INTO `region_city` VALUES ('342', '141129', '中阳县', '332');
INSERT INTO `region_city` VALUES ('343', '141130', '交口县', '332');
INSERT INTO `region_city` VALUES ('344', '141181', '孝义市', '332');
INSERT INTO `region_city` VALUES ('345', '141182', '汾阳市', '332');
INSERT INTO `region_city` VALUES ('346', '150000', '内蒙古自治区', '0');
INSERT INTO `region_city` VALUES ('347', '150100', '呼和浩特市', '346');
INSERT INTO `region_city` VALUES ('348', '150102', '新城区', '347');
INSERT INTO `region_city` VALUES ('349', '150103', '回民区', '347');
INSERT INTO `region_city` VALUES ('350', '150104', '玉泉区', '347');
INSERT INTO `region_city` VALUES ('351', '150105', '赛罕区', '347');
INSERT INTO `region_city` VALUES ('352', '150121', '土默特左旗', '347');
INSERT INTO `region_city` VALUES ('353', '150122', '托克托县', '347');
INSERT INTO `region_city` VALUES ('354', '150123', '和林格尔县', '347');
INSERT INTO `region_city` VALUES ('355', '150124', '清水河县', '347');
INSERT INTO `region_city` VALUES ('356', '150125', '武川县', '347');
INSERT INTO `region_city` VALUES ('357', '150200', '包头市', '346');
INSERT INTO `region_city` VALUES ('358', '150202', '东河区', '357');
INSERT INTO `region_city` VALUES ('359', '150203', '昆都仑区', '357');
INSERT INTO `region_city` VALUES ('360', '150204', '青山区', '357');
INSERT INTO `region_city` VALUES ('361', '150205', '石拐区', '357');
INSERT INTO `region_city` VALUES ('362', '150206', '白云鄂博矿区', '357');
INSERT INTO `region_city` VALUES ('363', '150207', '九原区', '357');
INSERT INTO `region_city` VALUES ('364', '150221', '土默特右旗', '357');
INSERT INTO `region_city` VALUES ('365', '150222', '固阳县', '357');
INSERT INTO `region_city` VALUES ('366', '150223', '达尔罕茂明安联合旗', '357');
INSERT INTO `region_city` VALUES ('367', '150300', '乌海市', '346');
INSERT INTO `region_city` VALUES ('368', '150302', '海勃湾区', '367');
INSERT INTO `region_city` VALUES ('369', '150303', '海南区', '367');
INSERT INTO `region_city` VALUES ('370', '150304', '乌达区', '367');
INSERT INTO `region_city` VALUES ('371', '150400', '赤峰市', '346');
INSERT INTO `region_city` VALUES ('372', '150402', '红山区', '371');
INSERT INTO `region_city` VALUES ('373', '150403', '元宝山区', '371');
INSERT INTO `region_city` VALUES ('374', '150404', '松山区', '371');
INSERT INTO `region_city` VALUES ('375', '150421', '阿鲁科尔沁旗', '371');
INSERT INTO `region_city` VALUES ('376', '150422', '巴林左旗', '371');
INSERT INTO `region_city` VALUES ('377', '150423', '巴林右旗', '371');
INSERT INTO `region_city` VALUES ('378', '150424', '林西县', '371');
INSERT INTO `region_city` VALUES ('379', '150425', '克什克腾旗', '371');
INSERT INTO `region_city` VALUES ('380', '150426', '翁牛特旗', '371');
INSERT INTO `region_city` VALUES ('381', '150428', '喀喇沁旗', '371');
INSERT INTO `region_city` VALUES ('382', '150429', '宁城县', '371');
INSERT INTO `region_city` VALUES ('383', '150430', '敖汉旗', '371');
INSERT INTO `region_city` VALUES ('384', '150500', '通辽市', '346');
INSERT INTO `region_city` VALUES ('385', '150502', '科尔沁区', '384');
INSERT INTO `region_city` VALUES ('386', '150521', '科尔沁左翼中旗', '384');
INSERT INTO `region_city` VALUES ('387', '150522', '科尔沁左翼后旗', '384');
INSERT INTO `region_city` VALUES ('388', '150523', '开鲁县', '384');
INSERT INTO `region_city` VALUES ('389', '150524', '库伦旗', '384');
INSERT INTO `region_city` VALUES ('390', '150525', '奈曼旗', '384');
INSERT INTO `region_city` VALUES ('391', '150526', '扎鲁特旗', '384');
INSERT INTO `region_city` VALUES ('392', '150581', '霍林郭勒市', '384');
INSERT INTO `region_city` VALUES ('393', '150600', '鄂尔多斯市', '346');
INSERT INTO `region_city` VALUES ('394', '150602', '东胜区', '393');
INSERT INTO `region_city` VALUES ('395', '150603', '康巴什区', '393');
INSERT INTO `region_city` VALUES ('396', '150621', '达拉特旗', '393');
INSERT INTO `region_city` VALUES ('397', '150622', '准格尔旗', '393');
INSERT INTO `region_city` VALUES ('398', '150623', '鄂托克前旗', '393');
INSERT INTO `region_city` VALUES ('399', '150624', '鄂托克旗', '393');
INSERT INTO `region_city` VALUES ('400', '150625', '杭锦旗', '393');
INSERT INTO `region_city` VALUES ('401', '150626', '乌审旗', '393');
INSERT INTO `region_city` VALUES ('402', '150627', '伊金霍洛旗', '393');
INSERT INTO `region_city` VALUES ('403', '150700', '呼伦贝尔市', '346');
INSERT INTO `region_city` VALUES ('404', '150702', '海拉尔区', '403');
INSERT INTO `region_city` VALUES ('405', '150703', '扎赉诺尔区', '403');
INSERT INTO `region_city` VALUES ('406', '150721', '阿荣旗', '403');
INSERT INTO `region_city` VALUES ('407', '150722', '莫力达瓦达斡尔族自治旗', '403');
INSERT INTO `region_city` VALUES ('408', '150723', '鄂伦春自治旗', '403');
INSERT INTO `region_city` VALUES ('409', '150724', '鄂温克族自治旗', '403');
INSERT INTO `region_city` VALUES ('410', '150725', '陈巴尔虎旗', '403');
INSERT INTO `region_city` VALUES ('411', '150726', '新巴尔虎左旗', '403');
INSERT INTO `region_city` VALUES ('412', '150727', '新巴尔虎右旗', '403');
INSERT INTO `region_city` VALUES ('413', '150781', '满洲里市', '403');
INSERT INTO `region_city` VALUES ('414', '150782', '牙克石市', '403');
INSERT INTO `region_city` VALUES ('415', '150783', '扎兰屯市', '403');
INSERT INTO `region_city` VALUES ('416', '150784', '额尔古纳市', '403');
INSERT INTO `region_city` VALUES ('417', '150785', '根河市', '403');
INSERT INTO `region_city` VALUES ('418', '150800', '巴彦淖尔市', '346');
INSERT INTO `region_city` VALUES ('419', '150802', '临河区', '418');
INSERT INTO `region_city` VALUES ('420', '150821', '五原县', '418');
INSERT INTO `region_city` VALUES ('421', '150822', '磴口县', '418');
INSERT INTO `region_city` VALUES ('422', '150823', '乌拉特前旗', '418');
INSERT INTO `region_city` VALUES ('423', '150824', '乌拉特中旗', '418');
INSERT INTO `region_city` VALUES ('424', '150825', '乌拉特后旗', '418');
INSERT INTO `region_city` VALUES ('425', '150826', '杭锦后旗', '418');
INSERT INTO `region_city` VALUES ('426', '150900', '乌兰察布市', '346');
INSERT INTO `region_city` VALUES ('427', '150902', '集宁区', '426');
INSERT INTO `region_city` VALUES ('428', '150921', '卓资县', '426');
INSERT INTO `region_city` VALUES ('429', '150922', '化德县', '426');
INSERT INTO `region_city` VALUES ('430', '150923', '商都县', '426');
INSERT INTO `region_city` VALUES ('431', '150924', '兴和县', '426');
INSERT INTO `region_city` VALUES ('432', '150925', '凉城县', '426');
INSERT INTO `region_city` VALUES ('433', '150926', '察哈尔右翼前旗', '426');
INSERT INTO `region_city` VALUES ('434', '150927', '察哈尔右翼中旗', '426');
INSERT INTO `region_city` VALUES ('435', '150928', '察哈尔右翼后旗', '426');
INSERT INTO `region_city` VALUES ('436', '150929', '四子王旗', '426');
INSERT INTO `region_city` VALUES ('437', '150981', '丰镇市', '426');
INSERT INTO `region_city` VALUES ('438', '152200', '兴安盟', '346');
INSERT INTO `region_city` VALUES ('439', '152201', '乌兰浩特市', '438');
INSERT INTO `region_city` VALUES ('440', '152202', '阿尔山市', '438');
INSERT INTO `region_city` VALUES ('441', '152221', '科尔沁右翼前旗', '438');
INSERT INTO `region_city` VALUES ('442', '152222', '科尔沁右翼中旗', '438');
INSERT INTO `region_city` VALUES ('443', '152223', '扎赉特旗', '438');
INSERT INTO `region_city` VALUES ('444', '152224', '突泉县', '438');
INSERT INTO `region_city` VALUES ('445', '152500', '锡林郭勒盟', '346');
INSERT INTO `region_city` VALUES ('446', '152501', '二连浩特市', '445');
INSERT INTO `region_city` VALUES ('447', '152502', '锡林浩特市', '445');
INSERT INTO `region_city` VALUES ('448', '152522', '阿巴嘎旗', '445');
INSERT INTO `region_city` VALUES ('449', '152523', '苏尼特左旗', '445');
INSERT INTO `region_city` VALUES ('450', '152524', '苏尼特右旗', '445');
INSERT INTO `region_city` VALUES ('451', '152525', '东乌珠穆沁旗', '445');
INSERT INTO `region_city` VALUES ('452', '152526', '西乌珠穆沁旗', '445');
INSERT INTO `region_city` VALUES ('453', '152527', '太仆寺旗', '445');
INSERT INTO `region_city` VALUES ('454', '152528', '镶黄旗', '445');
INSERT INTO `region_city` VALUES ('455', '152529', '正镶白旗', '445');
INSERT INTO `region_city` VALUES ('456', '152530', '正蓝旗', '445');
INSERT INTO `region_city` VALUES ('457', '152531', '多伦县', '445');
INSERT INTO `region_city` VALUES ('458', '152900', '阿拉善盟', '346');
INSERT INTO `region_city` VALUES ('459', '152921', '阿拉善左旗', '458');
INSERT INTO `region_city` VALUES ('460', '152922', '阿拉善右旗', '458');
INSERT INTO `region_city` VALUES ('461', '152923', '额济纳旗', '458');
INSERT INTO `region_city` VALUES ('462', '210000', '辽宁省', '0');
INSERT INTO `region_city` VALUES ('463', '210100', '沈阳市', '462');
INSERT INTO `region_city` VALUES ('464', '210102', '和平区', '463');
INSERT INTO `region_city` VALUES ('465', '210103', '沈河区', '463');
INSERT INTO `region_city` VALUES ('466', '210104', '大东区', '463');
INSERT INTO `region_city` VALUES ('467', '210105', '皇姑区', '463');
INSERT INTO `region_city` VALUES ('468', '210106', '铁西区', '463');
INSERT INTO `region_city` VALUES ('469', '210111', '苏家屯区', '463');
INSERT INTO `region_city` VALUES ('470', '210112', '浑南区', '463');
INSERT INTO `region_city` VALUES ('471', '210113', '沈北新区', '463');
INSERT INTO `region_city` VALUES ('472', '210114', '于洪区', '463');
INSERT INTO `region_city` VALUES ('473', '210115', '辽中区', '463');
INSERT INTO `region_city` VALUES ('474', '210123', '康平县', '463');
INSERT INTO `region_city` VALUES ('475', '210124', '法库县', '463');
INSERT INTO `region_city` VALUES ('476', '210181', '新民市', '463');
INSERT INTO `region_city` VALUES ('477', '210200', '大连市', '462');
INSERT INTO `region_city` VALUES ('478', '210202', '中山区', '477');
INSERT INTO `region_city

标签： 阿瓦提倾斜角传感器in咸安液位传感器进口水位计闽侯电流变送器rg3i邹平交直流电阻负载箱负载箱筠连电流变送器n4温度变送器蕉岭

锐单商城拥有海量元器件数据手册、 IC替代型号，打造 电子元器件IC百科大全！

锐单商城 - 一站式电子元器件采购平台