中国省市区三级联动表

格式：xls
大小：942.00 KB
文档页数：2

下载文档原格式

中国省市区三级联动表

在“省” 列单元格选中后，依次选择，数据 →数据验证→数据有效性（弹出数据有效性选择框）设置→允许（下拉列表）→ 序列→在来源框中填入 =INDIREC T(a57), 其中括号内的a57 为国家所在列的单元格号
“市”“ 区”列单元格也做同样的操作，仅在 =INDIREC T(这里)，括号中所对应的相应的单元格，市列选择省列单元格，区列选择市列单元格自此设置完毕，效果如下，如果觉得国家列不美观，可以把国家列隐藏起来即可
以上示例图片为效果展示图。为使用方便。介绍一个 excel的函数命令如下： "=INDIRE CT(I4)" 将文本中的省，市，区工作簿复制到要实现省市区三级联动的表内然后就是实现步骤，为了方便学习，我们将b列设为省，c 列设为市，d列设为区
为了简化记忆本次三级联动只用了一个命令就是上面的 =INDIREC T(I4) 我们将a 列设为国家，内容全部填写中国，这样方便我们使用 =INDIREC T(I4)命令本表中含有很多定义好的名称，所以使用时可以在本表中建立新的工作簿，复制 copy都是无效的
国家中国中国中国中国中国
省上海河北

省市区三级联动菜单（附数据库）

省市区三级联动菜单（附数据库）<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8" /><mce:script type="text/javascript"><select id='province' onchange='queryCity(this.options[this.selectedIndex].value)'><option value='-1' selected>请选择省份</option><?phpwhile($row=mysql_fetch_row($result)){//循环循环查询显⽰省输出数据显⽰echo "<option value='$row[1]'>$row[2]</option>/n";}></select><span id='city'></span><span id='area'></span></form></body></html><?php$provincecode=$_GET['provincecode'];//接收省键值$citycode=$_GET['citycode'];//接收城市键值$conn=mysql_connect("localhost","root","");//连接主机mysql_select_db("novel");//选择数据库mysql_query("set names 'utf8'");if($provincecode!=""){//如果传递过来的不为空则执⾏$sql="select * from city where provincecode=$provincecode";//查询城市符合属于上边传递过来的省的字段 $result=mysql_query($sql);//执⾏SQL查询语句print_r($row);><select onchange='queryArea(this.options[this.selectedIndex].value)'><option value='-1' selected>请选择城市</option><?php while($row=mysql_fetch_row($result)){//循环记录集?><option value="<?= $row[1]?>"><?=$row[2]?></option><?php }?></select><?php }?><?phpif($citycode!=""){$sql="select * from area where citycode=$citycode";$result=mysql_query($sql);echo "<select>/n";echo "<option value='-1' selected>请选择县</option>/n";while($row=mysql_fetch_row($result)){echo "<option value='$row[1]'>$row[2]</option>/n";}echo "</select>/n";}>-- phpMyAdmin SQL Dump-- version 2.11.2-- ---- 主机: localhost-- ⽣成⽇期: 2008 年 07 ⽉ 11 ⽇ 00:45-- 服务器版本: 5.0.27-- PHP 版本: 5.2.0SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";---- 数据库: `novel`--CREATE DATABASE `novel` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;USE `novel`;-- 表的结构 `area`--CREATE TABLE IF NOT EXISTS `area` (`id` int(11) NOT NULL auto_increment,`code` varchar(6) NOT NULL,`name` varchar(20) NOT NULL,`citycode` varchar(6) NOT NULL,PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3145 ; ---- 导出表中的数据 `area`--INSERT INTO `area` (`id`, `code`, `name`, `citycode`) VALUES(1, '110101', '东城区', '110100'),(2, '110102', '西城区', '110100'),(3, '110103', '崇⽂区', '110100'),(4, '110104', '宣武区', '110100'),(5, '110105', '朝阳区', '110100'),(6, '110106', '丰台区', '110100'),(7, '110107', '⽯景⼭区', '110100'),(8, '110108', '海淀区', '110100'),(9, '110109', '门头沟区', '110100'),(10, '110111', '房⼭区', '110100'),(11, '110112', '通州区', '110100'),(12, '110113', '顺义区', '110100'),(13, '110114', '昌平区', '110100'),(14, '110115', '⼤兴区', '110100'),(15, '110116', '怀柔区', '110100'),(16, '110117', '平⾕区', '110100'),(17, '110228', '密云县', '110200'),(18, '110229', '延庆县', '110200'),(19, '120101', '和平区', '120100'),(20, '120102', '河东区', '120100'),(21, '120103', '河西区', '120100'),(22, '120104', '南开区', '120100'),(23, '120105', '河北区', '120100'),(24, '120106', '红桥区', '120100'),(25, '120107', '塘沽区', '120100'),(26, '120108', '汉沽区', '120100'),(27, '120109', '⼤港区', '120100'),(28, '120110', '东丽区', '120100'),(29, '120111', '西青区', '120100'),(30, '120112', '津南区', '120100'),(31, '120113', '北⾠区', '120100'),(32, '120114', '武清区', '120100'),(33, '120115', '宝坻区', '120100'),(34, '120221', '宁河县', '120200'),(35, '120223', '静海县', '120200'),(36, '120225', '蓟　县', '120200'),(37, '130101', '市辖区', '130100'),(38, '130102', '长安区', '130100'),(39, '130103', '桥东区', '130100'),(40, '130104', '桥西区', '130100'),(41, '130105', '新华区', '130100'),(42, '130107', '井陉矿区', '130100'),(43, '130108', '裕华区', '130100'),(44, '130121', '井陉县', '130100'),(45, '130123', '正定县', '130100'),(46, '130124', '栾城县', '130100'),(47, '130125', '⾏唐县', '130100'),(48, '130126', '灵寿县', '130100'),(49, '130127', '⾼⾢县', '130100'),(50, '130128', '深泽县', '130100'),(51, '130129', '赞皇县', '130100'),(52, '130130', '⽆极县', '130100'),(53, '130131', '平⼭县', '130100'),(54, '130132', '元⽒县', '130100'),(55, '130133', '赵　县', '130100'),(56, '130181', '⾟集市', '130100'),(57, '130182', '藁城市', '130100'),(58, '130183', '晋州市', '130100'),(59, '130184', '新乐市', '130100'),(60, '130185', '⿅泉市', '130100'),(61, '130201', '市辖区', '130200'),(62, '130202', '路南区', '130200'),(63, '130203', '路北区', '130200'),(64, '130204', '古冶区', '130200'),(73, '130230', '唐海县', '130200'), (74, '130281', '遵化市', '130200'), (75, '130283', '迁安市', '130200'), (76, '130301', '市辖区', '130300'), (77, '130302', '海港区', '130300'), (78, '130303', '⼭海关区', '130300'), (79, '130304', '北戴河区', '130300'), (80, '130321', '青龙满族⾃治县', '130300'), (81, '130322', '昌黎县', '130300'), (82, '130323', '抚宁县', '130300'), (83, '130324', '卢龙县', '130300'), (84, '130401', '市辖区', '130400'), (85, '130402', '邯⼭区', '130400'), (86, '130403', '丛台区', '130400'), (87, '130404', '复兴区', '130400'), (88, '130406', '峰峰矿区', '130400'), (89, '130421', '邯郸县', '130400'), (90, '130423', '临漳县', '130400'), (91, '130424', '成安县', '130400'), (92, '130425', '⼤名县', '130400'), (93, '130426', '涉　县', '130400'), (94, '130427', '磁　县', '130400'), (95, '130428', '肥乡县', '130400'), (96, '130429', '永年县', '130400'), (97, '130430', '邱　县', '130400'), (98, '130431', '鸡泽县', '130400'), (99, '130432', '⼴平县', '130400'), (100, '130433', '馆陶县', '130400'), (101, '130434', '魏　县', '130400'), (102, '130435', '曲周县', '130400'), (103, '130481', '武安市', '130400'), (104, '130501', '市辖区', '130500'), (105, '130502', '桥东区', '130500'), (106, '130503', '桥西区', '130500'), (107, '130521', '邢台县', '130500'), (108, '130522', '临城县', '130500'), (109, '130523', '内丘县', '130500'), (110, '130524', '柏乡县', '130500'), (111, '130525', '隆尧县', '130500'), (112, '130526', '任　县', '130500'), (113, '130527', '南和县', '130500'), (114, '130528', '宁晋县', '130500'), (115, '130529', '巨⿅县', '130500'), (116, '130530', '新河县', '130500'), (117, '130531', '⼴宗县', '130500'), (118, '130532', '平乡县', '130500'), (119, '130533', '威　县', '130500'), (120, '130534', '清河县', '130500'), (121, '130535', '临西县', '130500'), (122, '130581', '南宫市', '130500'), (123, '130582', '沙河市', '130500'), (124, '130601', '市辖区', '130600'), (125, '130602', '新市区', '130600'), (126, '130603', '北市区', '130600'), (127, '130604', '南市区', '130600'), (128, '130621', '满城县', '130600'), (129, '130622', '清苑县', '130600'), (130, '130623', '涞⽔县', '130600'), (131, '130624', '⾩平县', '130600'), (132, '130625', '徐⽔县', '130600'), (133, '130626', '定兴县', '130600'), (134, '130627', '唐　县', '130600'), (135, '130628', '⾼阳县', '130600'), (136, '130629', '容城县', '130600'), (137, '130630', '涞源县', '130600'), (138, '130631', '望都县', '130600'), (139, '130632', '安新县', '130600'), (140, '130633', '易　县', '130600'), (141, '130634', '曲阳县', '130600'), (142, '130635', '蠡　县', '130600'), (143, '130636', '顺平县', '130600'), (144, '130637', '博野县', '130600'), (145, '130638', '雄　县', '130600'), (146, '130681', '涿州市', '130600'), (147, '130682', '定州市', '130600'), (148, '130683', '安国市', '130600'),(157, '130723', '康保县', '130700'),(158, '130724', '沽源县', '130700'),(159, '130725', '尚义县', '130700'),(160, '130726', '蔚　县', '130700'),(161, '130727', '阳原县', '130700'),(162, '130728', '怀安县', '130700'),(163, '130729', '万全县', '130700'),(164, '130730', '怀来县', '130700'),(165, '130731', '涿⿅县', '130700'),(166, '130732', '⾚城县', '130700'),(167, '130733', '崇礼县', '130700'),(168, '130801', '市辖区', '130800'),(169, '130802', '双桥区', '130800'),(170, '130803', '双滦区', '130800'),(171, '130804', '鹰⼿营⼦矿区', '130800'), (172, '130821', '承德县', '130800'),(173, '130822', '兴隆县', '130800'),(174, '130823', '平泉县', '130800'),(175, '130824', '滦平县', '130800'),(176, '130825', '隆化县', '130800'),(177, '130826', '丰宁满族⾃治县', '130800'), (178, '130827', '宽城满族⾃治县', '130800'), (179, '130828', '围场满族蒙古族⾃治县', '130800'), (180, '130901', '市辖区', '130900'),(181, '130902', '新华区', '130900'),(182, '130903', '运河区', '130900'),(183, '130921', '沧　县', '130900'),(184, '130922', '青　县', '130900'),(185, '130923', '东光县', '130900'),(186, '130924', '海兴县', '130900'),(187, '130925', '盐⼭县', '130900'),(188, '130926', '肃宁县', '130900'),(189, '130927', '南⽪县', '130900'),(190, '130928', '吴桥县', '130900'),(191, '130929', '献　县', '130900'),(192, '130930', '孟村回族⾃治县', '130900'), (193, '130981', '泊头市', '130900'),(194, '130982', '任丘市', '130900'),(195, '130983', '黄骅市', '130900'),(196, '130984', '河间市', '130900'),(197, '131001', '市辖区', '131000'),(198, '131002', '安次区', '131000'),(199, '131003', '⼴阳区', '131000'),(200, '131022', '固安县', '131000'),(201, '131023', '永清县', '131000'),(202, '131024', '⾹河县', '131000'),(203, '131025', '⼤城县', '131000'),(204, '131026', '⽂安县', '131000'),(205, '131028', '⼤⼚回族⾃治县', '131000'), (206, '131081', '霸州市', '131000'),(207, '131082', '三河市', '131000'),(208, '131101', '市辖区', '131100'),(209, '131102', '桃城区', '131100'),(210, '131121', '枣强县', '131100'),(211, '131122', '武⾢县', '131100'),(212, '131123', '武强县', '131100'),(213, '131124', '饶阳县', '131100'),(214, '131125', '安平县', '131100'),(215, '131126', '故城县', '131100'),(216, '131127', '景　县', '131100'),(217, '131128', '⾩城县', '131100'),(218, '131181', '冀州市', '131100'),(219, '131182', '深州市', '131100'),(220, '140101', '市辖区', '140100'),(221, '140105', '⼩店区', '140100'),(222, '140106', '迎泽区', '140100'),(223, '140107', '杏花岭区', '140100'),(224, '140108', '尖草坪区', '140100'),(225, '140109', '万柏林区', '140100'),(226, '140110', '晋源区', '140100'),(227, '140121', '清徐县', '140100'),(228, '140122', '阳曲县', '140100'),(229, '140123', '娄烦县', '140100'),(230, '140181', '古交市', '140100'),(231, '140201', '市辖区', '140200'),(232, '140202', '城　区', '140200'),(241, '140226', '左云县', '140200'), (242, '140227', '⼤同县', '140200'), (243, '140301', '市辖区', '140300'), (244, '140302', '城　区', '140300'), (245, '140303', '矿　区', '140300'), (246, '140311', '郊　区', '140300'), (247, '140321', '平定县', '140300'), (248, '140322', '盂　县', '140300'), (249, '140401', '市辖区', '140400'), (250, '140402', '城　区', '140400'), (251, '140411', '郊　区', '140400'), (252, '140421', '长治县', '140400'), (253, '140423', '襄垣县', '140400'), (254, '140424', '屯留县', '140400'), (255, '140425', '平顺县', '140400'), (256, '140426', '黎城县', '140400'), (257, '140427', '壶关县', '140400'), (258, '140428', '长⼦县', '140400'), (259, '140429', '武乡县', '140400'), (260, '140430', '沁　县', '140400'), (261, '140431', '沁源县', '140400'), (262, '140481', '潞城市', '140400'), (263, '140501', '市辖区', '140500'), (264, '140502', '城　区', '140500'), (265, '140521', '沁⽔县', '140500'), (266, '140522', '阳城县', '140500'), (267, '140524', '陵川县', '140500'), (268, '140525', '泽州县', '140500'), (269, '140581', '⾼平市', '140500'), (270, '140601', '市辖区', '140600'), (271, '140602', '朔城区', '140600'), (272, '140603', '平鲁区', '140600'), (273, '140621', '⼭阴县', '140600'), (274, '140622', '应　县', '140600'), (275, '140623', '右⽟县', '140600'), (276, '140624', '怀仁县', '140600'), (277, '140701', '市辖区', '140700'), (278, '140702', '榆次区', '140700'), (279, '140721', '榆社县', '140700'), (280, '140722', '左权县', '140700'), (281, '140723', '和顺县', '140700'), (282, '140724', '昔阳县', '140700'), (283, '140725', '寿阳县', '140700'), (284, '140726', '太⾕县', '140700'), (285, '140727', '祁　县', '140700'), (286, '140728', '平遥县', '140700'), (287, '140729', '灵⽯县', '140700'), (288, '140781', '介休市', '140700'), (289, '140801', '市辖区', '140800'), (290, '140802', '盐湖区', '140800'), (291, '140821', '临猗县', '140800'), (292, '140822', '万荣县', '140800'), (293, '140823', '闻喜县', '140800'), (294, '140824', '稷⼭县', '140800'), (295, '140825', '新绛县', '140800'), (296, '140826', '绛　县', '140800'), (297, '140827', '垣曲县', '140800'), (298, '140828', '夏　县', '140800'), (299, '140829', '平陆县', '140800'), (300, '140830', '芮城县', '140800'), (301, '140881', '永济市', '140800'), (302, '140882', '河津市', '140800'), (303, '140901', '市辖区', '140900'), (304, '140902', '忻府区', '140900'), (305, '140921', '定襄县', '140900'), (306, '140922', '五台县', '140900'), (307, '140923', '代　县', '140900'), (308, '140924', '繁峙县', '140900'), (309, '140925', '宁武县', '140900'), (310, '140926', '静乐县', '140900'), (311, '140927', '神池县', '140900'), (312, '140928', '五寨县', '140900'), (313, '140929', '岢岚县', '140900'), (314, '140930', '河曲县', '140900'), (315, '140931', '保德县', '140900'), (316, '140932', '偏关县', '140900'),(325, '141026', '安泽县', '141000'),(326, '141027', '浮⼭县', '141000'),(327, '141028', '吉　县', '141000'),(328, '141029', '乡宁县', '141000'),(329, '141030', '⼤宁县', '141000'),(330, '141031', '隰　县', '141000'),(331, '141032', '永和县', '141000'),(332, '141033', '蒲　县', '141000'),(333, '141034', '汾西县', '141000'),(334, '141081', '侯马市', '141000'),(335, '141082', '霍州市', '141000'),(336, '141101', '市辖区', '141100'),(337, '141102', '离⽯区', '141100'),(338, '141121', '⽂⽔县', '141100'),(339, '141122', '交城县', '141100'),(340, '141123', '兴　县', '141100'),(341, '141124', '临　县', '141100'),(342, '141125', '柳林县', '141100'),(343, '141126', '⽯楼县', '141100'),(344, '141127', '岚　县', '141100'),(345, '141128', '⽅⼭县', '141100'),(346, '141129', '中阳县', '141100'),(347, '141130', '交⼝县', '141100'),(348, '141181', '孝义市', '141100'),(349, '141182', '汾阳市', '141100'),(350, '150101', '市辖区', '150100'),(351, '150102', '新城区', '150100'),(352, '150103', '回民区', '150100'),(353, '150104', '⽟泉区', '150100'),(354, '150105', '赛罕区', '150100'),(355, '150121', '⼟默特左旗', '150100'), (356, '150122', '托克托县', '150100'),(357, '150123', '和林格尔县', '150100'), (358, '150124', '清⽔河县', '150100'),(359, '150125', '武川县', '150100'),(360, '150201', '市辖区', '150200'),(361, '150202', '东河区', '150200'),(362, '150203', '昆都仑区', '150200'),(363, '150204', '青⼭区', '150200'),(364, '150205', '⽯拐区', '150200'),(365, '150206', '⽩云矿区', '150200'),(366, '150207', '九原区', '150200'),(367, '150221', '⼟默特右旗', '150200'), (368, '150222', '固阳县', '150200'),(369, '150223', '达尔罕茂明安联合旗', '150200'), (370, '150301', '市辖区', '150300'),(371, '150302', '海勃湾区', '150300'),(372, '150303', '海南区', '150300'),(373, '150304', '乌达区', '150300'),(374, '150401', '市辖区', '150400'),(375, '150402', '红⼭区', '150400'),(376, '150403', '元宝⼭区', '150400'),(377, '150404', '松⼭区', '150400'),(378, '150421', '阿鲁科尔沁旗', '150400'), (379, '150422', '巴林左旗', '150400'),(380, '150423', '巴林右旗', '150400'),(381, '150424', '林西县', '150400'),(382, '150425', '克什克腾旗', '150400'), (383, '150426', '翁⽜特旗', '150400'),(384, '150428', '喀喇沁旗', '150400'),(385, '150429', '宁城县', '150400'),(386, '150430', '敖汉旗', '150400'),(387, '150501', '市辖区', '150500'),(388, '150502', '科尔沁区', '150500'),(389, '150521', '科尔沁左翼中旗', '150500'), (390, '150522', '科尔沁左翼后旗', '150500'), (391, '150523', '开鲁县', '150500'),(392, '150524', '库伦旗', '150500'),(393, '150525', '奈曼旗', '150500'),(394, '150526', '扎鲁特旗', '150500'),(395, '150581', '霍林郭勒市', '150500'), (396, '150602', '东胜区', '150600'),(397, '150621', '达拉特旗', '150600'),(398, '150622', '准格尔旗', '150600'),(399, '150623', '鄂托克前旗', '150600'), (400, '150624', '鄂托克旗', '150600'),(407, '150722', '莫⼒达⽡达斡尔族⾃治旗', '150700'), (408, '150723', '鄂伦春⾃治旗', '150700'),(409, '150724', '鄂温克族⾃治旗', '150700'), (410, '150725', '陈巴尔虎旗', '150700'),(411, '150726', '新巴尔虎左旗', '150700'),(412, '150727', '新巴尔虎右旗', '150700'),(413, '150781', '满洲⾥市', '150700'),(414, '150782', '⽛克⽯市', '150700'),(415, '150783', '扎兰屯市', '150700'),(416, '150784', '额尔古纳市', '150700'),(417, '150785', '根河市', '150700'),(418, '150801', '市辖区', '150800'),(419, '150802', '临河区', '150800'),(420, '150821', '五原县', '150800'),(421, '150822', '磴⼝县', '150800'),(422, '150823', '乌拉特前旗', '150800'),(423, '150824', '乌拉特中旗', '150800'),(424, '150825', '乌拉特后旗', '150800'),(425, '150826', '杭锦后旗', '150800'),(426, '150901', '市辖区', '150900'),(427, '150902', '集宁区', '150900'),(428, '150921', '卓资县', '150900'),(429, '150922', '化德县', '150900'),(430, '150923', '商都县', '150900'),(431, '150924', '兴和县', '150900'),(432, '150925', '凉城县', '150900'),(433, '150926', '察哈尔右翼前旗', '150900'), (434, '150927', '察哈尔右翼中旗', '150900'), (435, '150928', '察哈尔右翼后旗', '150900'), (436, '150929', '四⼦王旗', '150900'),(437, '150981', '丰镇市', '150900'),(438, '152201', '乌兰浩特市', '152200'),(439, '152202', '阿尔⼭市', '152200'),(440, '152221', '科尔沁右翼前旗', '152200'), (441, '152222', '科尔沁右翼中旗', '152200'), (442, '152223', '扎赉特旗', '152200'),(443, '152224', '突泉县', '152200'),(444, '152501', '⼆连浩特市', '152500'),(445, '152502', '锡林浩特市', '152500'),(446, '152522', '阿巴嘎旗', '152500'),(447, '152523', '苏尼特左旗', '152500'),(448, '152524', '苏尼特右旗', '152500'),(449, '152525', '东乌珠穆沁旗', '152500'),(450, '152526', '西乌珠穆沁旗', '152500'),(451, '152527', '太仆寺旗', '152500'),(452, '152528', '镶黄旗', '152500'),(453, '152529', '正镶⽩旗', '152500'),(454, '152530', '正蓝旗', '152500'),(455, '152531', '多伦县', '152500'),(456, '152921', '阿拉善左旗', '152900'),(457, '152922', '阿拉善右旗', '152900'),(458, '152923', '额济纳旗', '152900'),(459, '210101', '市辖区', '210100'),(460, '210102', '和平区', '210100'),(461, '210103', '沈河区', '210100'),(462, '210104', '⼤东区', '210100'),(463, '210105', '皇姑区', '210100'),(464, '210106', '铁西区', '210100'),(465, '210111', '苏家屯区', '210100'),(466, '210112', '东陵区', '210100'),(467, '210113', '新城⼦区', '210100'),(468, '210114', '于洪区', '210100'),(469, '210122', '辽中县', '210100'),(470, '210123', '康平县', '210100'),(471, '210124', '法库县', '210100'),(472, '210181', '新民市', '210100'),(473, '210201', '市辖区', '210200'),(474, '210202', '中⼭区', '210200'),(475, '210203', '西岗区', '210200'),(476, '210204', '沙河⼝区', '210200'),(477, '210211', '⽢井⼦区', '210200'),(478, '210212', '旅顺⼝区', '210200'),(479, '210213', '⾦州区', '210200'),(480, '210224', '长海县', '210200'),(481, '210281', '⽡房店市', '210200'),(482, '210282', '普兰店市', '210200'),(483, '210283', '庄河市', '210200'),(484, '210301', '市辖区', '210300'),。

全国省市区三级联动js

dsy.add("0_5_7",["榆次区","介休市","榆社县","箕城镇","左权县","辽阳镇","和顺县","义兴镇","昔阳县","乐平镇","寿阳县","朝阳镇","太谷县","明星镇","祁县","昭余镇","平遥县","古陶镇","灵石县","翠峰镇"]);
dsy.add("0_5_8",["尧都区","侯马市","霍州市","曲沃县","乐昌镇","翼城县","唐兴镇","襄汾县","新城镇","洪洞县","大槐树镇","古县","岳阳镇","安泽县","府城镇","浮山县","天坛镇","吉县","吉昌镇","乡宁县","昌宁镇","蒲县","蒲城镇","大宁县","昕水镇","永和县","芝河镇","隰县","龙泉镇","汾西县","永安镇"]);
dsy.add("0_4_7",["桃城区","冀州市","深州市","枣强县","枣强镇","武邑县","武邑镇","武强县","武强镇","饶阳县","饶阳镇","安平县","安平镇","故城县","郑口镇","景县","景州镇","阜城县","阜城镇"]);

三级联动，json数据、可设置默认城市

三级联动，json数据、可设置默认城市闲来⽆事，折腾个三级联动，json数据、可设置默认城市、可配置是否显⽰第三级select<!DOCTYPE html><html><head><meta charset="UTF-8"><title>省市县三级联动</title><script src="/jquery/1.9.0/jquery.js"></script><script type="text/javascript">var cityjson = '{'+ '"province" : ['+ '{"id" : "1", "name" : "北京市"},'+ '{"id" : "2", "name" : "⼭西省"},'+ '{"id" : "3", "name" : "河北省"}'+ '],'+ '"city" : ['+ '{"cid" : "1", "id" : "1", "name":"海淀区"},'+ '{"cid" : "1", "id" : "2", "name":"西城区"},'+ '{"cid" : "1", "id" : "2", "name":"东城区"},'+ '{"cid" : "1", "id" : "3", "name":"朝阳区"},'+ '{"cid" : "2", "id" : "4", "name":"太原市"},'+ '{"cid" : "2", "id" : "5", "name":"⼤同市"},'+ '{"cid" : "2", "id" : "6", "name":"阳泉市"},'+ '{"cid" : "3", "id" : "7", "name":"⽯家庄"},'+ '{"cid" : "3", "id" : "8", "name":"蚌埠市"},'+ '{"cid" : "3", "id" : "9", "name":"张家⼝"}'+ '],'+ '"county" : ['+ '{"cid" : "1", "id" : "1", "name":"中关村"},'+ '{"cid" : "1", "id" : "2", "name":"五道⼝"},'+ '{"cid" : "2", "id" : "3", "name":"西直门"},'+ '{"cid" : "2", "id" : "4", "name":"新街⼝"},'+ '{"cid" : "2", "id" : "5", "name":"⼩西天"},'+ '{"cid" : "3", "id" : "6", "name":"东直门"},'+ '{"cid" : "3", "id" : "7", "name":"雍和宫"},'+ '{"cid" : "3", "id" : "8", "name":"北新桥"},'+ '{"cid" : "5", "id" : "9", "name":"城区"},'+ '{"cid" : "5", "id" : "10", "name":"南郊区"},'+ '{"cid" : "5", "id" : "11", "name":"开发区"}'+ ']'+'}';;(function($, window, document, undefined){$.fn.showCity = function(opt){this.defaults = {'cityjson' : cityjson, //json字符串变量名'defaultShow' : false, //市、县是否显⽰,默认不显⽰'showCounty' : true, //是否显⽰县'defaultCity' : [0,0,0] //默认城市，对应id};this.options = $.extend({}, this.defaults, opt);var oCityJson = eval('('+this.options.cityjson+')'),oProvince = $('.province',this),oCity = $('.city',this),oCounty = $('.county',this),provinces = oCityJson.province,citys = oCityJson.city,countys = oCityJson.county;//创建省this.creatProvince = function(){var html = '';for(var i=0; i<provinces.length; i++){html += '<option value='+provinces[i].id+'>'+provinces[i].name+'</option>';}oProvince.append(html);};this.creat = function(){oProvince.html('<option value="0">选择省</option>');this.creatProvince();if(this.options.defaultShow){oCity.show();oCounty.show();oCity.html('<option value="0">选择市</option>');oCounty.html('<option value="0">选择县</option>');};this.defaultCity();this.checkProvince();if(this.options.showCounty){this.checkCounty();}};//默认城市this.defaultCity = function(){if(this.options.defaultCity.toString() == '0,0,0'){return;};var optionsCity = '';for(var i=0; i<provinces.length; i++){if(provinces[i].id == this.options.defaultCity[0]){oProvince.val(provinces[i].id);for(var j=0; j<citys.length; j++){if(citys[j].cid == provinces[i].id){optionsCity += '<option value='+citys[j].id+'>'+citys[j].name+'</option>'}}oCity.append(optionsCity).show();}};var optionscounty = '';for(var i=0; i<citys.length; i++){if(citys[i].id == this.options.defaultCity[1] && citys[i].cid == oProvince.val()){oCity.val(citys[i].id);if(this.options.showCounty){for(var j=0; j<countys.length; j++){if(countys[j].cid == citys[i].id){optionscounty += '<option value='+countys[j].id+'>'+countys[j].name+'</option>'; }}oCounty.append(optionscounty).show();}}};if(this.options.showCounty){for(var i=0; i<countys.length; i++){if(countys[i].id == this.options.defaultCity[2] && countys[i].cid == oCity.val()){oCounty.val(countys[i].id);}};}}this.checkProvince = function(){oProvince.bind('change',function(){var html = '<option value="0">选择市</option>';var val = $(this).val();for(var i=0; i<citys.length; i++){if(citys[i].cid == val){html += '<option value='+citys[i].id+'>'+citys[i].name+'</option>'}}oCity.html(html).show();oCounty.html('<option value="0">选择县</option>');})};this.checkCounty = function(){oCity.bind('change',function(){var html = '<option value="0">选择县</option>';var val = $(this).val();for(var i=0; i<countys.length; i++){if(countys[i].cid == val){html += '<option value='+countys[i].id+'>'+countys[i].name+'</option>'}}oCounty.html(html).show();})};return this.creat();}}(jQuery, window, document))$(function(){$('#selectItem').showCity({"defaultCity" : [2,5,10]});})</script></head><body><div class="selectItem" id="selectItem"><select class="province"></select><select class="city" style="display:none"></select> <select class="county" style="display:none"></select> </div></body></html>。

省市区三级联动（附j全国省市区json文件）

</div> <style>
label { display: inline-block; width:80px;
} #logisticPointForm div {
margin-top:10px; margin-bottom:10px; } </style> <script> $('#LatestDate').datetimebox({ required : true, onShowPanel:function(){
<div class="easyui-panel" style="padding:10px;"> <form id="logisticPointForm" method="post"> <div> <label>交接点:</label> <input class="easyui-textbox" id="PointName" name="PointName" data-options="required:true" style="width:70%;"> </div> <div> <label>选择区域:</label> <input class="easyui-combobox" id="Province" name="Province" style="width:22%" , data-options="prompt:'省',required:true,editable:false,"> <input class="easyui-combobox" id="City" name="City" style="width:22%" , data-options="prompt:'市',required:true,editable:false,"> <input class="easyui-combobox" id="County" name="County" style="width:22%" , data-options="prompt:'区/镇',required:true,editable:false,"> </div> <div> <label>详细地址:</label> <input class="easyui-textbox" id="Address" name="Address" data-options="required:true" style="width:70%;"> </div> <div> <label>对方物流员:</label> <input class="easyui-linkbutton" id="OppositeLogister" name="OppositeLogister" style="height:30px;" value="+选择物流员" onclick="sectionManageObj.choiceLogisterDialog(1)" /> <input id="OppositeLogisterId" name="OppositeLogisterId" type="hidden" /> </div> <div> <label>我方物流员:</label> <input class="easyui-linkbutton" id="MyLogister" name="MyLogister" style="height:30px;" value="+选择物流员" onclick="sectionManageObj.choiceLogisterDialog(2)"/> <input id="MyLogisterId" name="MyLogisterId" type="hidden"/> </div> <div> <label>最晚交接时间:</label>  <input class="easyui-timespinner" id="LatestDate" name="LatestDate" required="required" data-options="width:'30%',showSeconds:true"> </div> <div style="text-align:center;"> <input href="#" class="easyui-linkbutton" value="取消" style="width:100px;height:30px;text-align:center;border-radius:5px;background:dimgray;color:white;" data-options="onClick:sectionManageObj.closeAddDialog <input href="#" class="easyui-linkbutton" value="确认" style="width:100px;height:30px;text-align:center;border-radius:5px;background:dodgerblue;color:white;" data-options="onClick:sectionManageObj.addSubmitDialog </div> </form>

中国省市区县三级联动(库表结构及数据)

省级别1110000北京市2120000天津市3130000河北省4140000山西省5150000内蒙古自治区6210000辽宁省7220000吉林省8230000黑龙江省9310000上海市10320000江苏省11330000浙江省12340000安徽省13350000福建省14360000江西省15370000山东省16410000河南省17420000湖北省18430000湖南省19440000广东省20450000广西壮族自治区21460000海南省22500000重庆市23510000四川省24520000贵州省25530000云南省26540000西藏自治区27610000陕西省28620000甘肃省29630000青海省30640000宁夏回族自治区31650000新疆维吾尔自治区32710000台湾省33810000香港特别行政区34820000澳门特别行政区地级1110100市辖区1100002110200县1100003120100市辖区1200004120200县1200005130100石家庄市1300006130200唐山市1300007130300秦皇岛市1300008130400邯郸市1300009130500邢台市13000010130600保定市13000011130700张家口市13000012130800承德市13000013130900沧州市13000014131000廊坊市13000015131100衡水市13000016140100太原市14000017140200大同市14000018140300阳泉市14000022140700晋中市140000 23140800运城市140000 24140900忻州市140000 25141000临汾市140000 26141100吕梁市140000 27150100呼和浩特市150000 28150200包头市150000 29150300乌海市150000 30150400赤峰市150000 31150500通辽市150000 32150600鄂尔多斯市150000 33150700呼伦贝尔市150000 34150800巴彦淖尔市150000 35150900乌兰察布市150000 36152200兴安盟150000 37152500锡林郭勒盟150000 38152900阿拉善盟150000 39210100沈阳市210000 40210200大连市210000 41210300鞍山市210000 42210400抚顺市210000 43210500本溪市210000 44210600丹东市210000 45210700锦州市210000 46210800营口市210000 47210900阜新市210000 48211000辽阳市210000 49211100盘锦市210000 50211200铁岭市210000 51211300朝阳市210000 52211400葫芦岛市210000 53220100长春市220000 54220200吉林市220000 55220300四平市220000 56220400辽源市220000 57220500通化市220000 58220600白山市220000 59220700松原市220000 60220800白城市220000220000 61222400延边朝鲜族自62230100哈尔滨市230000 63230200齐齐哈尔市230000 64230300鸡西市230000 65230400鹤岗市230000 66230500双鸭山市230000 67230600大庆市230000 68230700伊春市230000 69230800佳木斯市230000 70230900七台河市230000 71231000牡丹江市230000 72231100黑河市230000 73231200绥化市230000230000 74232700大兴安岭地区75310100市辖区310000 76310200县310000 77320100南京市32000081320500苏州市320000 82320600南通市320000 83320700连云港市320000 84320800淮安市320000 85320900盐城市320000 86321000扬州市320000 87321100镇江市320000 88321200泰州市320000 89321300宿迁市320000 90330100杭州市330000 91330200宁波市330000 92330300温州市330000 93330400嘉兴市330000 94330500湖州市330000 95330600绍兴市330000 96330700金华市330000 97330800衢州市330000 98330900舟山市330000 99331000台州市330000 100331100丽水市330000 101340100合肥市340000 102340200芜湖市340000 103340300蚌埠市340000 104340400淮南市340000 105340500马鞍山市340000 106340600淮北市340000 107340700铜陵市340000 108340800安庆市340000 109341000黄山市340000 110341100滁州市340000 111341200阜阳市340000 112341300宿州市340000 113341400巢湖市340000 114341500六安市340000 115341600亳州市340000 116341700池州市340000 117341800宣城市340000 118350100福州市350000 119350200厦门市350000 120350300莆田市350000 121350400三明市350000 122350500泉州市350000 123350600漳州市350000 124350700南平市350000 125350800龙岩市350000 126350900宁德市350000 127360100南昌市360000 128360200景德镇市360000 129360300萍乡市360000 130360400九江市360000 131360500新余市360000 132360600鹰潭市360000 133360700赣州市360000 134360800吉安市360000 135360900宜春市360000 136361000抚州市360000139370200青岛市370000 140370300淄博市370000 141370400枣庄市370000 142370500东营市370000 143370600烟台市370000 144370700潍坊市370000 145370800济宁市370000 146370900泰安市370000 147371000威海市370000 148371100日照市370000 149371200莱芜市370000 150371300临沂市370000 151371400德州市370000 152371500聊城市370000 153371600滨州市370000 154371700荷泽市370000 155410100郑州市410000 156410200开封市410000 157410300洛阳市410000 158410400平顶山市410000 159410500安阳市410000 160410600鹤壁市410000 161410700新乡市410000 162410800焦作市410000 163410900濮阳市410000 164411000许昌市410000 165411100漯河市410000 166411200三门峡市410000 167411300南阳市410000 168411400商丘市410000 169411500信阳市410000 170411600周口市410000 171411700驻马店市410000 172420100武汉市420000 173420200黄石市420000 174420300十堰市420000 175420500宜昌市420000 176420600襄樊市420000 177420700鄂州市420000 178420800荆门市420000 179420900孝感市420000 180421000荆州市420000 181421100黄冈市420000 182421200咸宁市420000 183421300随州市420000 184422800恩施土家族苗420000420000 185429000省直辖行政单186430100长沙市430000 187430200株洲市430000 188430300湘潭市430000 189430400衡阳市430000 190430500邵阳市430000 191430600岳阳市430000 192430700常德市430000 193430800张家界市430000 194430900益阳市430000 195431000郴州市430000198431300娄底市430000430000 199433100湘西土家族苗200440100广州市440000 201440200韶关市440000 202440300深圳市440000 203440400珠海市440000 204440500汕头市440000 205440600佛山市440000 206440700江门市440000 207440800湛江市440000 208440900茂名市440000 209441200肇庆市440000 210441300惠州市440000 211441400梅州市440000 212441500汕尾市440000 213441600河源市440000 214441700阳江市440000 215441800清远市440000 216441900东莞市440000 217442000中山市440000 218445100潮州市440000 219445200揭阳市440000 220445300云浮市440000 221450100南宁市450000 222450200柳州市450000 223450300桂林市450000 224450400梧州市450000 225450500北海市450000 226450600防城港市450000 227450700钦州市450000 228450800贵港市450000 229450900玉林市450000 230451000百色市450000 231451100贺州市450000 232451200河池市450000 233451300来宾市450000 234451400崇左市450000 235460100海口市460000 236460200三亚市460000460000 237469000省直辖县级行238500100市辖区500000 239500200县500000 240500300市500000 241510100成都市510000 242510300自贡市510000 243510400攀枝花市510000 244510500泸州市510000 245510600德阳市510000 246510700绵阳市510000 247510800广元市510000 248510900遂宁市510000 249511000内江市510000 250511100乐山市510000 251511300南充市510000 252511400眉山市510000 253511500宜宾市510000 254511600广安市510000257511900巴中市510000 258512000资阳市510000510000 259513200阿坝藏族羌族510000 260513300甘孜藏族自治510000 261513400凉山彝族自治262520100贵阳市520000 263520200六盘水市520000 264520300遵义市520000 265520400安顺市520000 266522200铜仁地区520000 267522300黔西南布依族520000 268522400毕节地区520000520000 269522600黔东南苗族侗270522700黔南布依族苗520000 271530100昆明市530000 272530300曲靖市530000 273530400玉溪市530000 274530500保山市530000 275530600昭通市530000 276530700丽江市530000 277530800思茅市530000 278530900临沧市530000530000 279532300楚雄彝族自治530000 280532500红河哈尼族彝530000 281532600文山壮族苗族530000 282532800西双版纳傣族530000 283532900大理白族自治530000 284533100德宏傣族景颇530000 285533300怒江傈僳族自530000 286533400迪庆藏族自治287540100拉萨市540000 288542100昌都地区540000 289542200山南地区540000 290542300日喀则地区540000 291542400那曲地区540000 292542500阿里地区540000 293542600林芝地区540000 294610100西安市610000 295610200铜川市610000 296610300宝鸡市610000 297610400咸阳市610000 298610500渭南市610000 299610600延安市610000 300610700汉中市610000 301610800榆林市610000 302610900安康市610000 303611000商洛市610000 304620100兰州市620000 305620200嘉峪关市620000 306620300金昌市620000 307620400白银市620000 308620500天水市620000 309620600武威市620000 310620700张掖市620000 311620800平凉市620000 312620900酒泉市620000 313621000庆阳市620000316622900临夏回族自治620000620000 317623000甘南藏族自治318630100西宁市630000319632100海东地区630000630000 320632200海北藏族自治630000 321632300黄南藏族自治630000 322632500海南藏族自治630000 323632600果洛藏族自治630000 324632700玉树藏族自治630000 325632800海西蒙古族藏326640100银川市640000327640200石嘴山市640000328640300吴忠市640000329640400固原市640000330640500中卫市640000331650100乌鲁木齐市650000332650200克拉玛依市650000333652100吐鲁番地区650000334652200哈密地区650000650000 335652300昌吉回族自治650000 336652700博尔塔拉蒙古650000 337652800巴音郭楞蒙古338652900阿克苏地区650000339653000克孜勒苏柯尔650000 340653100喀什地区650000341653200和田地区650000342654000伊犁哈萨克自650000 343654200塔城地区650000344654300阿勒泰地区650000345659000省直辖行政单650000县1110101东城区1101002110102西城区1101003110103崇文区1101004110104宣武区1101005110105朝阳区1101006110106丰台区1101007110107石景山区1101008110108海淀区1101009110109门头沟区11010010110111房山区11010011110112通州区11010012110113顺义区11010013110114昌平区11010014110115大兴区11010015110116怀柔区11010016110117平谷区11010017110228密云县11020018110229延庆县11020019120101和平区12010020120102河东区12010021120103河西区12010022120104南开区12010025120107塘沽区120100 26120108汉沽区120100 27120109大港区120100 28120110东丽区120100 29120111西青区120100 30120112津南区120100 31120113北辰区120100 32120114武清区120100 33120115宝坻区120100 34120221宁河县120200 35120223静海县120200 36120225蓟　县120200 37130101市辖区130100 38130102长安区130100 39130103桥东区130100 40130104桥西区130100 41130105新华区130100 42130107井陉矿区130100 43130108裕华区130100 44130121井陉县130100 45130123正定县130100 46130124栾城县130100 47130125行唐县130100 48130126灵寿县130100 49130127高邑县130100 50130128深泽县130100 51130129赞皇县130100 52130130无极县130100 53130131平山县130100 54130132元氏县130100 55130133赵　县130100 56130181辛集市130100 57130182藁城市130100 58130183晋州市130100 59130184新乐市130100 60130185鹿泉市130100 61130201市辖区130200 62130202路南区130200 63130203路北区130200 64130204古冶区130200 65130205开平区130200 66130207丰南区130200 67130208丰润区130200 68130223滦　县130200 69130224滦南县130200 70130225乐亭县130200 71130227迁西县130200 72130229玉田县130200 73130230唐海县130200 74130281遵化市130200 75130283迁安市130200 76130301市辖区130300 77130302海港区130300 78130303山海关区130300 79130304北戴河区130300 80130321青龙满族自治130300 81130322昌黎县13030084130401市辖区130400 85130402邯山区130400 86130403丛台区130400 87130404复兴区130400 88130406峰峰矿区130400 89130421邯郸县130400 90130423临漳县130400 91130424成安县130400 92130425大名县130400 93130426涉　县130400 94130427磁　县130400 95130428肥乡县130400 96130429永年县130400 97130430邱　县130400 98130431鸡泽县130400 99130432广平县130400 100130433馆陶县130400 101130434魏　县130400 102130435曲周县130400 103130481武安市130400 104130501市辖区130500 105130502桥东区130500 106130503桥西区130500 107130521邢台县130500 108130522临城县130500 109130523内丘县130500 110130524柏乡县130500 111130525隆尧县130500 112130526任　县130500 113130527南和县130500 114130528宁晋县130500 115130529巨鹿县130500 116130530新河县130500 117130531广宗县130500 118130532平乡县130500 119130533威　县130500 120130534清河县130500 121130535临西县130500 122130581南宫市130500 123130582沙河市130500 124130601市辖区130600 125130602新市区130600 126130603北市区130600 127130604南市区130600 128130621满城县130600 129130622清苑县130600 130130623涞水县130600 131130624阜平县130600 132130625徐水县130600 133130626定兴县130600 134130627唐　县130600 135130628高阳县130600 136130629容城县130600 137130630涞源县130600 138130631望都县130600 139130632安新县130600 140130633易　县130600143130636顺平县130600 144130637博野县130600 145130638雄　县130600 146130681涿州市130600 147130682定州市130600 148130683安国市130600 149130684高碑店市130600 150130701市辖区130700 151130702桥东区130700 152130703桥西区130700 153130705宣化区130700 154130706下花园区130700 155130721宣化县130700 156130722张北县130700 157130723康保县130700 158130724沽源县130700 159130725尚义县130700 160130726蔚　县130700 161130727阳原县130700 162130728怀安县130700 163130729万全县130700 164130730怀来县130700 165130731涿鹿县130700 166130732赤城县130700 167130733崇礼县130700 168130801市辖区130800 169130802双桥区130800 170130803双滦区130800130800 171130804鹰手营子矿区172130821承德县130800 173130822兴隆县130800 174130823平泉县130800 175130824滦平县130800 176130825隆化县130800130800 177130826丰宁满族自治130800 178130827宽城满族自治130800 179130828围场满族蒙古180130901市辖区130900 181130902新华区130900 182130903运河区130900 183130921沧　县130900 184130922青　县130900 185130923东光县130900 186130924海兴县130900 187130925盐山县130900 188130926肃宁县130900 189130927南皮县130900 190130928吴桥县130900 191130929献　县130900130900 192130930孟村回族自治193130981泊头市130900 194130982任丘市130900 195130983黄骅市130900 196130984河间市130900 197131001市辖区131000 198131002安次区131000 199131003广阳区131000202131024香河县131000 203131025大城县131000 204131026文安县131000 205131028大厂回族自治131000 206131081霸州市131000 207131082三河市131000 208131101市辖区131100 209131102桃城区131100 210131121枣强县131100 211131122武邑县131100 212131123武强县131100 213131124饶阳县131100 214131125安平县131100 215131126故城县131100 216131127景　县131100 217131128阜城县131100 218131181冀州市131100 219131182深州市131100 220140101市辖区140100 221140105小店区140100 222140106迎泽区140100 223140107杏花岭区140100 224140108尖草坪区140100 225140109万柏林区140100 226140110晋源区140100 227140121清徐县140100 228140122阳曲县140100 229140123娄烦县140100 230140181古交市140100 231140201市辖区140200 232140202城　区140200 233140203矿　区140200 234140211南郊区140200 235140212新荣区140200 236140221阳高县140200 237140222天镇县140200 238140223广灵县140200 239140224灵丘县140200 240140225浑源县140200 241140226左云县140200 242140227大同县140200 243140301市辖区140300 244140302城　区140300 245140303矿　区140300 246140311郊　区140300 247140321平定县140300 248140322盂　县140300 249140401市辖区140400 250140402城　区140400 251140411郊　区140400 252140421长治县140400 253140423襄垣县140400 254140424屯留县140400 255140425平顺县140400 256140426黎城县140400 257140427壶关县140400 258140428长子县140400 259140429武乡县140400262140481潞城市140400 263140501市辖区140500 264140502城　区140500 265140521沁水县140500 266140522阳城县140500 267140524陵川县140500 268140525泽州县140500 269140581高平市140500 270140601市辖区140600 271140602朔城区140600 272140603平鲁区140600 273140621山阴县140600 274140622应　县140600 275140623右玉县140600 276140624怀仁县140600 277140701市辖区140700 278140702榆次区140700 279140721榆社县140700 280140722左权县140700 281140723和顺县140700 282140724昔阳县140700 283140725寿阳县140700 284140726太谷县140700 285140727祁　县140700 286140728平遥县140700 287140729灵石县140700 288140781介休市140700 289140801市辖区140800 290140802盐湖区140800 291140821临猗县140800 292140822万荣县140800 293140823闻喜县140800 294140824稷山县140800 295140825新绛县140800 296140826绛　县140800 297140827垣曲县140800 298140828夏　县140800 299140829平陆县140800 300140830芮城县140800 301140881永济市140800 302140882河津市140800 303140901市辖区140900 304140902忻府区140900 305140921定襄县140900 306140922五台县140900 307140923代　县140900 308140924繁峙县140900 309140925宁武县140900 310140926静乐县140900 311140927神池县140900 312140928五寨县140900 313140929岢岚县140900 314140930河曲县140900 315140931保德县140900 316140932偏关县140900 317140981原平市140900 318141001市辖区141000321141022翼城县141000 322141023襄汾县141000 323141024洪洞县141000 324141025古　县141000 325141026安泽县141000 326141027浮山县141000 327141028吉　县141000 328141029乡宁县141000 329141030大宁县141000 330141031隰　县141000 331141032永和县141000 332141033蒲　县141000 333141034汾西县141000 334141081侯马市141000 335141082霍州市141000 336141101市辖区141100 337141102离石区141100 338141121文水县141100 339141122交城县141100 340141123兴　县141100 341141124临　县141100 342141125柳林县141100 343141126石楼县141100 344141127岚　县141100 345141128方山县141100 346141129中阳县141100 347141130交口县141100 348141181孝义市141100 349141182汾阳市141100 350150101市辖区150100 351150102新城区150100 352150103回民区150100 353150104玉泉区150100 354150105赛罕区150100 355150121土默特左旗150100 356150122托克托县150100 357150123和林格尔县150100 358150124清水河县150100 359150125武川县150100 360150201市辖区150200 361150202东河区150200 362150203昆都仑区150200 363150204青山区150200 364150205石拐区150200 365150206白云矿区150200 366150207九原区150200 367150221土默特右旗150200 368150222固阳县150200150200 369150223达尔罕茂明安370150301市辖区150300 371150302海勃湾区150300 372150303海南区150300 373150304乌达区150300 374150401市辖区150400 375150402红山区150400 376150403元宝山区150400 377150404松山区150400379150422巴林左旗150400 380150423巴林右旗150400 381150424林西县150400 382150425克什克腾旗150400 383150426翁牛特旗150400 384150428喀喇沁旗150400 385150429宁城县150400 386150430敖汉旗150400 387150501市辖区150500 388150502科尔沁区150500150500 389150521科尔沁左翼中150500 390150522科尔沁左翼后391150523开鲁县150500 392150524库伦旗150500 393150525奈曼旗150500 394150526扎鲁特旗150500 395150581霍林郭勒市150500 396150602东胜区150600 397150621达拉特旗150600 398150622准格尔旗150600 399150623鄂托克前旗150600 400150624鄂托克旗150600 401150625杭锦旗150600 402150626乌审旗150600 403150627伊金霍洛旗150600 404150701市辖区150700 405150702海拉尔区150700 406150721阿荣旗150700150700 407150722莫力达瓦达斡150700 408150723鄂伦春自治旗150700 409150724鄂温克族自治410150725陈巴尔虎旗150700 411150726新巴尔虎左旗150700150700 412150727新巴尔虎右旗413150781满洲里市150700 414150782牙克石市150700 415150783扎兰屯市150700 416150784额尔古纳市150700 417150785根河市150700 418150801市辖区150800 419150802临河区150800 420150821五原县150800 421150822磴口县150800 422150823乌拉特前旗150800 423150824乌拉特中旗150800 424150825乌拉特后旗150800 425150826杭锦后旗150800 426150901市辖区150900 427150902集宁区150900 428150921卓资县150900 429150922化德县150900 430150923商都县150900 431150924兴和县150900 432150925凉城县150900150900 433150926察哈尔右翼前150900 434150927察哈尔右翼中435150928察哈尔右翼后150900 436150929四子王旗150900438152201乌兰浩特市152200 439152202阿尔山市152200152200 440152221科尔沁右翼前152200 441152222科尔沁右翼中442152223扎赉特旗152200 443152224突泉县152200 444152501二连浩特市152500 445152502锡林浩特市152500 446152522阿巴嘎旗152500 447152523苏尼特左旗152500 448152524苏尼特右旗152500152500 449152525东乌珠穆沁旗152500 450152526西乌珠穆沁旗451152527太仆寺旗152500 452152528镶黄旗152500 453152529正镶白旗152500 454152530正蓝旗152500 455152531多伦县152500 456152921阿拉善左旗152900 457152922阿拉善右旗152900 458152923额济纳旗152900 459210101市辖区210100 460210102和平区210100 461210103沈河区210100 462210104大东区210100 463210105皇姑区210100 464210106铁西区210100 465210111苏家屯区210100 466210112东陵区210100 467210113新城子区210100 468210114于洪区210100 469210122辽中县210100 470210123康平县210100 471210124法库县210100 472210181新民市210100 473210201市辖区210200 474210202中山区210200 475210203西岗区210200 476210204沙河口区210200 477210211甘井子区210200 478210212旅顺口区210200 479210213金州区210200 480210224长海县210200 481210281瓦房店市210200 482210282普兰店市210200 483210283庄河市210200 484210301市辖区210300 485210302铁东区210300 486210303铁西区210300 487210304立山区210300 488210311千山区210300 489210321台安县210300 490210323岫岩满族自治210300 491210381海城市210300 492210401市辖区210400 493210402新抚区210400 494210403东洲区210400 495210404望花区210400497210421抚顺县210400210400 498210422新宾满族自治210400 499210423清原满族自治500210501市辖区210500 501210502平山区210500 502210503溪湖区210500 503210504明山区210500 504210505南芬区210500210500 505210521本溪满族自治210500 506210522桓仁满族自治507210601市辖区210600 508210602元宝区210600 509210603振兴区210600 510210604振安区210600210600 511210624宽甸满族自治512210681东港市210600 513210682凤城市210600 514210701市辖区210700 515210702古塔区210700 516210703凌河区210700 517210711太和区210700 518210726黑山县210700 519210727义　县210700 520210781凌海市210700 521210782北宁市210700 522210801市辖区210800 523210802站前区210800 524210803西市区210800 525210804鲅鱼圈区210800 526210811老边区210800 527210881盖州市210800 528210882大石桥市210800 529210901市辖区210900 530210902海州区210900 531210903新邱区210900 532210904太平区210900 533210905清河门区210900 534210911细河区210900210900 535210921阜新蒙古族自536210922彰武县210900 537211001市辖区211000 538211002白塔区211000 539211003文圣区211000 540211004宏伟区211000 541211005弓长岭区211000 542211011太子河区211000 543211021辽阳县211000 544211081灯塔市211000 545211101市辖区211100 546211102双台子区211100 547211103兴隆台区211100 548211121大洼县211100 549211122盘山县211100 550211201市辖区211200 551211202银州区211200 552211204清河区211200 553211221铁岭县211200 554211223西丰县211200556211281调兵山市211200 557211282开原市211200 558211301市辖区211300 559211302双塔区211300 560211303龙城区211300 561211321朝阳县211300 562211322建平县211300 563211324喀喇沁左翼蒙211300 564211381北票市211300 565211382凌源市211300 566211401市辖区211400 567211402连山区211400 568211403龙港区211400 569211404南票区211400 570211421绥中县211400 571211422建昌县211400 572211481兴城市211400 573220101市辖区220100 574220102南关区220100 575220103宽城区220100 576220104朝阳区220100 577220105二道区220100 578220106绿园区220100 579220112双阳区220100 580220122农安县220100 581220181九台市220100 582220182榆树市220100 583220183德惠市220100 584220201市辖区220200 585220202昌邑区220200 586220203龙潭区220200 587220204船营区220200 588220211丰满区220200 589220221永吉县220200 590220281蛟河市220200 591220282桦甸市220200 592220283舒兰市220200 593220284磐石市220200 594220301市辖区220300 595220302铁西区220300 596220303铁东区220300 597220322梨树县220300220300 598220323伊通满族自治599220381公主岭市220300 600220382双辽市220300 601220401市辖区220400 602220402龙山区220400 603220403西安区220400 604220421东丰县220400 605220422东辽县220400 606220501市辖区220500 607220502东昌区220500 608220503二道江区220500 609220521通化县220500 610220523辉南县220500 611220524柳河县220500 612220581梅河口市220500 613220582集安市220500615220602八道江区220600 616220621抚松县220600 617220622靖宇县220600 618220623长白朝鲜族自220600 619220625江源县220600 620220681临江市220600 621220701市辖区220700 622220702宁江区220700220700 623220721前郭尔罗斯蒙624220722长岭县220700 625220723乾安县220700 626220724扶余县220700 627220801市辖区220800 628220802洮北区220800 629220821镇赉县220800 630220822通榆县220800 631220881洮南市220800 632220882大安市220800 633222401延吉市222400 634222402图们市222400 635222403敦化市222400 636222404珲春市222400 637222405龙井市222400 638222406和龙市222400 639222424汪清县222400 640222426安图县222400 641230101市辖区230100 642230102道里区230100 643230103南岗区230100 644230104道外区230100 645230106香坊区230100 646230107动力区230100 647230108平房区230100 648230109松北区230100 649230111呼兰区230100 650230123依兰县230100 651230124方正县230100 652230125宾　县230100 653230126巴彦县230100 654230127木兰县230100 655230128通河县230100 656230129延寿县230100 657230181阿城市230100 658230182双城市230100 659230183尚志市230100 660230184五常市230100 661230201市辖区230200 662230202龙沙区230200 663230203建华区230200 664230204铁锋区230200 665230205昂昂溪区230200 666230206富拉尔基区230200 667230207碾子山区230200230200 668230208梅里斯达斡尔669230221龙江县230200 670230223依安县230200 671230224泰来县230200 672230225甘南县230200674230229克山县230200 675230230克东县230200 676230231拜泉县230200 677230281讷河市230200 678230301市辖区230300 679230302鸡冠区230300 680230303恒山区230300 681230304滴道区230300 682230305梨树区230300 683230306城子河区230300 684230307麻山区230300 685230321鸡东县230300 686230381虎林市230300 687230382密山市230300 688230401市辖区230400 689230402向阳区230400 690230403工农区230400 691230404南山区230400 692230405兴安区230400 693230406东山区230400 694230407兴山区230400 695230421萝北县230400 696230422绥滨县230400 697230501市辖区230500 698230502尖山区230500 699230503岭东区230500 700230505四方台区230500 701230506宝山区230500 702230521集贤县230500 703230522友谊县230500 704230523宝清县230500 705230524饶河县230500 706230601市辖区230600 707230602萨尔图区230600 708230603龙凤区230600 709230604让胡路区230600 710230605红岗区230600 711230606大同区230600 712230621肇州县230600 713230622肇源县230600 714230623林甸县230600 715230624杜尔伯特蒙古230600 716230701市辖区230700 717230702伊春区230700 718230703南岔区230700 719230704友好区230700 720230705西林区230700 721230706翠峦区230700 722230707新青区230700 723230708美溪区230700 724230709金山屯区230700 725230710五营区230700 726230711乌马河区230700 727230712汤旺河区230700 728230713带岭区230700 729230714乌伊岭区230700 730230715红星区230700 731230716上甘岭区230700733230781铁力市230700 734230801市辖区230800 735230802永红区230800 736230803向阳区230800 737230804前进区230800 738230805东风区230800 739230811郊　区230800 740230822桦南县230800 741230826桦川县230800 742230828汤原县230800 743230833抚远县230800 744230881同江市230800 745230882富锦市230800 746230901市辖区230900 747230902新兴区230900 748230903桃山区230900 749230904茄子河区230900 750230921勃利县230900 751231001市辖区231000 752231002东安区231000 753231003阳明区231000 754231004爱民区231000 755231005西安区231000 756231024东宁县231000 757231025林口县231000 758231081绥芬河市231000 759231083海林市231000 760231084宁安市231000 761231085穆棱市231000 762231101市辖区231100 763231102爱辉区231100 764231121嫩江县231100 765231123逊克县231100 766231124孙吴县231100 767231181北安市231100 768231182五大连池市231100 769231201市辖区231200 770231202北林区231200 771231221望奎县231200 772231222兰西县231200 773231223青冈县231200 774231224庆安县231200 775231225明水县231200 776231226绥棱县231200 777231281安达市231200 778231282肇东市231200 779231283海伦市231200 780232721呼玛县232700 781232722塔河县232700 782232723漠河县232700 783310101黄浦区310100 784310103卢湾区310100 785310104徐汇区310100 786310105长宁区310100 787310106静安区310100 788310107普陀区310100 789310108闸北区310100 790310109虹口区310100792310112闵行区310100 793310113宝山区310100 794310114嘉定区310100 795310115浦东新区310100 796310116金山区310100 797310117松江区310100 798310118青浦区310100 799310119南汇区310100 800310120奉贤区310100 801310230崇明县310200 802320101市辖区320100 803320102玄武区320100 804320103白下区320100 805320104秦淮区320100 806320105建邺区320100 807320106鼓楼区320100 808320107下关区320100 809320111浦口区320100 810320113栖霞区320100 811320114雨花台区320100 812320115江宁区320100 813320116六合区320100 814320124溧水县320100 815320125高淳县320100 816320201市辖区320200 817320202崇安区320200 818320203南长区320200 819320204北塘区320200 820320205锡山区320200 821320206惠山区320200 822320211滨湖区320200 823320281江阴市320200 824320282宜兴市320200 825320301市辖区320300 826320302鼓楼区320300 827320303云龙区320300 828320304九里区320300 829320305贾汪区320300 830320311泉山区320300 831320321丰　县320300 832320322沛　县320300 833320323铜山县320300 834320324睢宁县320300 835320381新沂市320300 836320382邳州市320300 837320401市辖区320400 838320402天宁区320400 839320404钟楼区320400 840320405戚墅堰区320400 841320411新北区320400 842320412武进区320400 843320481溧阳市320400 844320482金坛市320400 845320501市辖区320500 846320502沧浪区320500 847320503平江区320500 848320504金阊区320500 849320505虎丘区320500 850320506吴中区320500851320507相城区320500 852320581常熟市320500 853320582张家港市320500 854320583昆山市320500 855320584吴江市320500 856320585太仓市320500 857320601市辖区320600 858320602崇川区320600 859320611港闸区320600 860320621海安县320600 861320623如东县320600 862320681启东市320600 863320682如皋市320600 864320683通州市320600 865320684海门市320600 866320701市辖区320700 867320703连云区320700 868320705新浦区320700 869320706海州区320700 870320721赣榆县320700 871320722东海县320700 872320723灌云县320700 873320724灌南县320700 874320801市辖区320800 875320802清河区320800 876320803楚州区320800 877320804淮阴区320800 878320811清浦区320800 879320826涟水县320800 880320829洪泽县320800 881320830盱眙县320800 882320831金湖县320800 883320901市辖区320900 884320902亭湖区320900 885320903盐都区320900 886320921响水县320900 887320922滨海县320900 888320923阜宁县320900 889320924射阳县320900 890320925建湖县320900 891320981东台市320900 892320982大丰市320900 893321001市辖区321000 894321002广陵区321000 895321003邗江区321000 896321011郊　区321000 897321023宝应县321000 898321081仪征市321000 899321084高邮市321000 900321088江都市321000 901321101市辖区321100 902321102京口区321100 903321111润州区321100 904321112丹徒区321100 905321181丹阳市321100 906321182扬中市321100 907321183句容市321100 908321201市辖区321200 909321202海陵区321200910321203高港区321200 911321281兴化市321200 912321282靖江市321200 913321283泰兴市321200 914321284姜堰市321200 915321301市辖区321300 916321302宿城区321300 917321311宿豫区321300 918321322沭阳县321300 919321323泗阳县321300 920321324泗洪县321300 921330101市辖区330100 922330102上城区330100 923330103下城区330100 924330104江干区330100 925330105拱墅区330100 926330106西湖区330100 927330108滨江区330100 928330109萧山区330100 929330110余杭区330100 930330122桐庐县330100 931330127淳安县330100 932330182建德市330100 933330183富阳市330100 934330185临安市330100 935330201市辖区330200 936330203海曙区330200 937330204江东区330200 938330205江北区330200 939330206北仑区330200 940330211镇海区330200 941330212鄞州区330200 942330225象山县330200 943330226宁海县330200 944330281余姚市330200 945330282慈溪市330200 946330283奉化市330200 947330301市辖区330300 948330302鹿城区330300 949330303龙湾区330300 950330304瓯海区330300 951330322洞头县330300 952330324永嘉县330300 953330326平阳县330300 954330327苍南县330300 955330328文成县330300 956330329泰顺县330300 957330381瑞安市330300 958330382乐清市330300 959330401市辖区330400 960330402秀城区330400 961330411秀洲区330400 962330421嘉善县330400 963330424海盐县330400 964330481海宁市330400 965330482平湖市330400 966330483桐乡市330400 967330501市辖区330500 968330502吴兴区330500969330503南浔区330500 970330521德清县330500 971330522长兴县330500 972330523安吉县330500 973330601市辖区330600 974330602越城区330600 975330621绍兴县330600 976330624新昌县330600 977330681诸暨市330600 978330682上虞市330600 979330683嵊州市330600 980330701市辖区330700 981330702婺城区330700 982330703金东区330700 983330723武义县330700 984330726浦江县330700 985330727磐安县330700 986330781兰溪市330700 987330782义乌市330700 988330783东阳市330700 989330784永康市330700 990330801市辖区330800 991330802柯城区330800 992330803衢江区330800 993330822常山县330800 994330824开化县330800 995330825龙游县330800 996330881江山市330800 997330901市辖区330900 998330902定海区330900 999330903普陀区330900 1000330921岱山县330900 1001330922嵊泗县330900 1002331001市辖区331000 1003331002椒江区331000 1004331003黄岩区331000 1005331004路桥区331000 1006331021玉环县331000 1007331022三门县331000 1008331023天台县331000 1009331024仙居县331000 1010331081温岭市331000 1011331082临海市331000 1012331101市辖区331100 1013331102莲都区331100 1014331121青田县331100 1015331122缙云县331100 1016331123遂昌县331100 1017331124松阳县331100 1018331125云和县331100 1019331126庆元县331100331100 1020331127景宁畲族自治1021331181龙泉市331100 1022340101市辖区340100 1023340102瑶海区340100 1024340103庐阳区340100 1025340104蜀山区340100 1026340111包河区340100 1027340121长丰县3401001028340122肥东县340100 1029340123肥西县340100 1030340201市辖区340200 1031340202镜湖区340200 1032340203马塘区340200 1033340204新芜区340200 1034340207鸠江区340200 1035340221芜湖县340200 1036340222繁昌县340200 1037340223南陵县340200 1038340301市辖区340300 1039340302龙子湖区340300 1040340303蚌山区340300 1041340304禹会区340300 1042340311淮上区340300 1043340321怀远县340300 1044340322五河县340300 1045340323固镇县340300 1046340401市辖区340400 1047340402大通区340400 1048340403田家庵区340400 1049340404谢家集区340400 1050340405八公山区340400 1051340406潘集区340400 1052340421凤台县340400 1053340501市辖区340500 1054340502金家庄区340500 1055340503花山区340500 1056340504雨山区340500 1057340521当涂县340500 1058340601市辖区340600 1059340602杜集区340600 1060340603相山区340600 1061340604烈山区340600 1062340621濉溪县340600 1063340701市辖区340700 1064340702铜官山区340700 1065340703狮子山区340700 1066340711郊　区340700 1067340721铜陵县340700 1068340801市辖区340800 1069340802迎江区340800 1070340803大观区340800 1071340811郊　区340800 1072340822怀宁县340800 1073340823枞阳县340800 1074340824潜山县340800 1075340825太湖县340800 1076340826宿松县340800 1077340827望江县340800 1078340828岳西县340800 1079340881桐城市340800 1080341001市辖区341000 1081341002屯溪区341000 1082341003黄山区341000 1083341004徽州区341000 1084341021歙　县341000 1085341022休宁县341000 1086341023黟　县3410001087341024祁门县341000 1088341101市辖区341100 1089341102琅琊区341100 1090341103南谯区341100 1091341122来安县341100 1092341124全椒县341100 1093341125定远县341100 1094341126凤阳县341100 1095341181天长市341100 1096341182明光市341100 1097341201市辖区341200 1098341202颍州区341200 1099341203颍东区341200 1100341204颍泉区341200 1101341221临泉县341200 1102341222太和县341200 1103341225阜南县341200 1104341226颍上县341200 1105341282界首市341200 1106341301市辖区341300 1107341302墉桥区341300 1108341321砀山县341300 1109341322萧　县341300 1110341323灵璧县341300 1111341324泗　县341300 1112341401市辖区341400 1113341402居巢区341400 1114341421庐江县341400 1115341422无为县341400 1116341423含山县341400 1117341424和　县341400 1118341501市辖区341500 1119341502金安区341500 1120341503裕安区341500 1121341521寿　县341500 1122341522霍邱县341500 1123341523舒城县341500 1124341524金寨县341500 1125341525霍山县341500 1126341601市辖区341600 1127341602谯城区341600 1128341621涡阳县341600 1129341622蒙城县341600 1130341623利辛县341600 1131341701市辖区341700 1132341702贵池区341700 1133341721东至县341700 1134341722石台县341700 1135341723青阳县341700 1136341801市辖区341800 1137341802宣州区341800 1138341821郎溪县341800 1139341822广德县341800 1140341823泾　县341800 1141341824绩溪县341800 1142341825旌德县341800 1143341881宁国市341800 1144350101市辖区350100 1145350102鼓楼区350100。

如何制作云表省市区三级联动

如何制作云表省市区三级联动我们在表单的填报过程中，经常需要填写省市区信息，如何实现快捷方便的联动填写呢？已有《省市区》模板，“省市区”数据批量导入；有以下3种实现方式：①下列列表联动②列表选择联动③树形列表联动一、下拉列表在“省份”上单击【﹀】从“省份下拉列表”中选择省份“江苏省”，在“城市”上单击【﹀】，弹出的下拉列表中只显示“江苏省下所有的城市列表”，选择“南京市”后，在“地区”上单击【﹀】，弹出的下拉列表中只显示“南京市下所有的地区列表”，实现联动实现分析：上图中以下拉列表的方式呈现数据，使用下拉列表的数据接口；省市区基础数据存放在《省市区》模板中，需要设计3个数据接口。

第1个数据接口“所有省份下拉列表”，没有参数，将所有的省份去重筛选出来，以便选择；第2个数据接口“根据省查询所有城市下拉列表”，有1个参数“省份”；第3个数据接口“根据省和城市查询所有地区下拉列表”，有2个参数“省份”和“城市”；在《客户档案》模板中调用已设计好的数据接口并给参数赋值；①在《省市区》模板中设计数据接口“省份下拉列表”。

该数据接口的类型为“下拉列表”，“取值”来自“数据表”“本模板”的“省份”数据项；②在《省市区》模板中设计数据接口“查询城市下拉列表（省份）”。

该数据接口的类型为“下拉列表”，“取值”来自“数据表”“本模板”的“城市”数据项；需要筛选指定“省份”的城市列表，设置“过滤设置”，选择“表达式过滤”，添加参数“省份”，并填写“过滤条件”；③在《省市区》模板中设计数据接口“查询地区下拉列表（省份，城市）”。

该数据接口的类型为“下拉列表”，“取值”来自“数据表”“本模板”的“地区”数据项；需要筛选指定“省份”和“城市”的城市列表，设置“过滤设置”，选择“表达式过滤”，添加参数“省份”和“城市”，并填写“过滤条件”；④在《客户档案》的填写规范中调用已设置的数据接口。

进入《客户档案》的模板设计界面，打开“数据定义管理”，在“省份”的填写规范上调用《省市区》的“省下拉列表”；⑤在“城市”的填写规范上调用《省市区》的“查询城市下拉列表（省份）”，该数据接口带有1个参数，将“本表单.省份”赋值给参数，并勾选“必填”，则只有当“本表单的省份”填写后，再单击城市的【﹀】才会运行该数据接口进行查询；⑥在“地区”的填写规范上调用《省市区》的“查询地区下拉列表（省份，城市）”，该数据接口带有2个参数，将“本表单.省份”和“本表单.城市”赋值给参数，并勾选“必填”，则只有当“本表单的省份和城市”都填写后，再单击地区的【﹀】才会运行该数据接口进行查询；这种实现方式用户需要单击进行选择，选项过多时，比较浪费时间，是否可以根据用户知道某几个字模糊查询并选择填写提高效率呢？二、列表选择联动在“省份”上填写内容后，下方根据填写的内容弹出模糊查询符合条件的省份列表，选择省份“广东省”，在“城市”上填写内容时，下方根据填写的内容在“广东省”内模查询符合条件的城市列表，在“地区”上填写内容后，下方根据填写的内容，在“广东省广州市”内模糊查询符合条件的地区列表；实现分析：省市区基础数据存放在《省市区》模板中，需要设计3个数据列表选择的数据接口，勾选“支持模糊查询”。

中国行政单位三级联动清单，基本操作技巧足以完成！

中国行政单位三级联动清单，基本操作技巧足以完成！送人玫瑰，手有余香，请将文章分享给更多朋友动手操作是熟练掌握EXCEL的最快捷途径！【置顶公众号】或者【设为星标】及时接收更新不迷路小伙伴们好，今天和大家分享一道题目。

如何制作多级下拉清单。

本篇2700字左右，阅读时间在20分钟左右。

我从网上下载了一份全国行政区域的清单，今天就用这个作为例子向大家演示制作的过程，其中包含了基本操作技巧、函数高级技巧等知识点，向大家展示在低版本下，如何运用我们学到的技巧来完成题目。

原始数据如下，大家可以看到，数据比较混乱，既有半角标点，也有全角标点，还有多余的空格。

因此我们还要将进行数据整理。

01上面的结构对于我们是没有用处的。

我们需要将省市分列。

这里不写什么复杂的公式了，以下基本的操作就可以完成。

A列中选择非空白，然后删除B列中从第二行开始以下的数据选中B2:B823，F5键定位空值。

编辑栏中输入“=B1”后CTRL+ENTER回车。

复制粘贴成数值。

接下来A列选中空值。

删除所有行。

单元格C1中输入公式“=B1=A1”，下拉。

删除所有TRUE，再删除C列。

将B列调整到最左侧。

插入一列新列。

输入公式“=IFERROR(LEFT(A1,FIND("(",SUBSTITUTE(A1,"（","("))-1),A1)”。

完成后粘贴成数值。

用同样的方法，将C列中的数据做同样的整理。

这部分主要用到的工具除了上述部分用到的之外，还有TRIM函数和CLEAN函数。

由于都比较简单，这里就不在详细介绍了。

同时我们又看到，同一个市的很多区分了很多行，这个要将他们合并到一个单元格中。

由于C列中文本字符间的空格是来自于外部文件的，因此我们先要把它处理一下。

打开查找替换对话框，将字符间的空格复制，粘贴到“查找内容”出；在“替换为”中输入一个空格，点击全部替换后即可。

我们首先给C列中的数据最后面都加个空格，为后面的数据合并做准备。

excel省市区三级分类级联

excel省市区三级分类级联前⾔：同事正好需要⼀个这样的地址类型给⽤户使⽤下载模板，改好地址再导⼊，这样就不会出现地址不匹配问题。

所以就⾃⼰也整理了⼀套，以备不时之需。

效果展⽰：图⼀：省级图⼆：市级图三：区级图四：各乡镇当更换⼀级菜单时⼆、三、四级会提⽰更新级联选项，否则提⽰错误。

依次类推，⼆级改变时，三、四级提⽰错误⾸先，要实现上⾯效果，需要⼆⼤部：第⼀部：准备做级联的数据源；(主要就是看你的数据来源，是通过数据库还是其它)第⼆部：excel函数及规则应⽤；(主要使⽤OFFSET, MATCH, CONTIF),即可实现上⾯效果。

在使⽤上⾯excel函数之前，⾸先要熟悉⼀下⼏个函数的作⽤，如果已经知道可忽律OFFSET(reference,rows,cols,height,width)Reference 作为偏移量参照系的引⽤区域。

Reference 必须为对单元格或相连单元格区域的引⽤；否则，函数 OFFSET 返回错误值#VALUE!。

Rows相对于偏移量参照系的左上⾓单元格，上（下）偏移的⾏数。

如果使⽤ 5 作为参数 Rows，则说明⽬标引⽤区域的左上⾓单元格⽐ reference 低 5 ⾏。

⾏数可为正数（代表在起始引⽤的下⽅）或负数（代表在起始引⽤的上⽅）。

Cols 相对于偏移量参照系的左上⾓单元格，左（右）偏移的列数。

如果使⽤ 5 作为参数 Cols，则说明⽬标引⽤区域的左上⾓的单元格⽐ reference 靠右 5 列。

列数可为正数（代表在起始引⽤的右边）或负数（代表在起始引⽤的左边）。

Height⾼度，即所要返回的引⽤区域的⾏数。

Height 必须为正数。

不可为负Width宽度，即所要返回的引⽤区域的列数。

Width 必须为正数。

不可为负offset 在汇编中可以获得操作数的偏移地址。

⽤法：MATCH(lookup_value, lookup_array, match_type)lookup_value：需要在数据表（lookup_array）中查找的值。

解析高德地图api获取省市区，生成最新三级联动sql表

解析⾼德地图api获取省市区，⽣成最新三级联动sql表前⾔：最近项⽬中⽤到了全国省市区三级信息，但是⽹上找到的信息都是⽐较旧的信息。

与现在最新的地区信息匹配不上。

后来想到⾼德地图上可能有这些信息。

所以解析了⼀下api接⼝，⽣成了相关省市区的sql信息。

（注意：这⾥⾯没有港台地区）具体的请参看⾼德地图⽂档。

alibaba.fastjson解析+mysql表　具体数据接⼝：　申请的key 注意：如果想调⽤此接⼝需要申请⼀个key,免费的，注册就可以获取3、java代码如下：@RequestMapping("/getAll")public Object getMasterList() throws Exception {HttpClientResult result = HttpClientUtils.doGet("https:///v3/config/district?subdistrict=4&key=⾃⼰申请的key");String jsonString = result.getContent();//数据结构如下/* String jsonString = "{\n" +" \"status\": \"1\",\n" +" \"info\": \"OK\",\n" +" \"infocode\": \"10000\",\n" +" \"count\": \"1\",\n" +" \"suggestion\": {\n" +" \"keywords\": [],\n" +" \"cities\": []\n" +" },\n" +" \"districts\": [{\n" +" \"citycode\": [],\n" +" \"adcode\": \"100000\",\n" +" \"name\": \"中华⼈民共和国\",\n" +" \"center\": \"116.3683244,39.915085\",\n" +" \"level\": \"country\",\n" +" \"districts\": [{\n" +" \"citycode\": [],\n" +" \"adcode\": \"410000\",\n" +" \"name\": \"河南省\",\n" +" \"center\": \"113.665412,34.757975\",\n" +" \"level\": \"province\",\n" +" \"districts\": [{\n" +" \"citycode\": \"0393\",\n" +" \"adcode\": \"410900\",\n" +" \"name\": \"濮阳市\",\n" +" \"center\": \"115.041299,35.768234\",\n" +" \"level\": \"city\",\n" +" \"districts\": [{\n" +" \"citycode\": \"0393\",\n" +" \"adcode\": \"410923\",\n" +" \"name\": \"南乐县\",\n" +" \"center\": \"115.204336,36.075204\",\n" +" \"level\": \"district\",\n" +" \"districts\": [{\n" +" \"citycode\": \"0393\",\n" +" \"adcode\": \"410923\",\n" +" \"name\": \"福坎镇\",\n" +" \"center\": \"115.398,36.0869\",\n" +" \"level\": \"street\",\n" +" \"districts\": []\n" +" }]\n" +" }]\n" +" }]\n" +" }]\n" +" }]\n" +"}";//result.getContent();*/JSONObject jsonObject = JSONObject.parseObject(jsonString);//获取到国家及下⾯所有的信息开始循环插⼊，这⾥可以写成递归调⽤，但是不如这样⽅便查看、理解JSONArray countryAll = jsonObject.getJSONArray("districts");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 = 0;if (country.equals("country")) {level = 0;}//插⼊国家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 = 0;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 = 0;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 = 0;if (street.equals("street")) {level3 = 2;}//插⼊区县insert(id3, adcode3, citycode3, name3, center3, level3, name0, name1, name2, name3);// JSONArray street = street3.getJSONArray("districts");//有需要可以继续向下遍历}}}}return getSuccessResult();}/*** 公共的插⼊⽅法** @param parentId ⽗id* @param citycode 城市编码* @param adcode 区域编码街道没有独有的adcode，均继承⽗类（区县）的adcode* @param name 城市名称（⾏政区名称）* @param center 地理坐标* @param level 等级 0 国家，1省，...依次排* @param mergeName 把名称拼接成全名* @return*/public Integer insert(Integer parentId, String citycode, String adcode, String name, String center, int level, String... mergeName) {// \"citycode\": [],\n" +// " \"adcode\": \"100000\",\n" +// " \"name\": \"中华⼈民共和国\",\n" +// " \"center\": \"116.3683244,39.915085\",\n" +// " \"level\": \"country\",\n" +RegionAmap record = new RegionAmap();if (!adcode.equals("[]")) {record.setAdcode(adcode);}record.setCitycode(Integer.parseInt(citycode));record.setCenter(center);record.setLevel(level);record.setName(name);record.setParentId(parentId);String megName = "";for (int i = 0; i < mergeName.length; i++) {megName = megName + mergeName[i];if (i < mergeName.length - 1) {megName = megName + ",";}}record.setMergerName(megName);regionAmapMapperCustom.insertSelective(record);return record.getCitycode();}/*** ⽣成的sql顺序重新排序** @return*/@RequestMapping("/order")public Object order() {RegionAmapExample example = new RegionAmapExample();example.setOrderByClause("citycode, adcode");List<RegionAmap> selectByExample = regionAmapMapperCustom.selectByExample(example);for (RegionAmap regionAmap : selectByExample) {RegionOrder record = new RegionOrder();record.setAdcode(regionAmap.getAdcode());record.setCitycode(regionAmap.getCitycode());record.setCenter(regionAmap.getCenter());record.setLevel(regionAmap.getLevel());record.setMergerName(regionAmap.getMergerName());record.setName(regionAmap.getName());record.setParentId(regionAmap.getParentId());regionOrderMapper.insertSelective(record);}return getSuccessResult();}注意：第⼀次调⽤接⼝解析的省市区不是按顺序解析，需要调⽤排序接⼝重新⽣成。

微信小程序实现三级联动-省市区

微信⼩程序实现三级联动-省市区github项⽬地址序：项⽬中需要⽤到三级联动，⾃⼰试着写了下，也查了⼀些资料，现在把这个记录⼀下，⾥⾯地区数据，可根据个⼈需要做⼀些更改，我⽐较懒就不改了。

wxml<view class="infoText">{{province}} {{city}} {{county}}</view><view class="aaaa" ><button class="animation-button" bindtap="translate">选择城市</button></view><view class="animation-element-wrapper" animation="{{animation}}" style="visibility:{{show ? 'visible':'hidden'}}" bindtap="hiddenFloatView" data-id="444"><view class="animation-element" catchtap="nono"><text class="left-bt" catchtap="hiddenFloatView" data-id="555">取消</text><text class="right-bt" catchtap="hiddenFloatView" data-id="666">确定</text><view class="line"></view><picker-view indicator-style = "height: 50rpx;" value="{{value}}" bindchange="bindChange" catchtap="nono"><picker-view-column><view wx:for="{{provinces}}" wx:for-item="sheng" wx:key="">{{}}</view></picker-view-column><picker-view-column><view wx:for="{{citys}}" wx:key="">{{}}</view></picker-view-column><picker-view-column><view wx:for="{{countys}}" wx:key="">{{}}</view></picker-view-column></picker-view></view></view>　js//index.js//获取应⽤实例// var app = getApp()// var util = require('../../utils/util.js')var area = require('../../utils/area.js')var areaInfo = [];//所有省市区县数据var provinces = [];//省var citys = [];//城市var countys = [];//区县var index = [0, 0, 0];var cellId;var t = 0;var show = false;var moveY = 200;Page({data: {show: show,provinces: provinces,citys: citys,countys: countys,value: [0, 0, 0]},//滑动事件bindChange: function (e) {var val = e.detail.value//判断滑动的是第⼏个column//若省份column做了滑动则定位到地级市和区县第⼀位if (index[0] != val[0]) {val[1] = 0;val[2] = 0;getCityArr(val[0], this);//获取地级市数据getCountyInfo(val[0], val[1], this);//获取区县数据} else { //若省份column未做滑动，地级市做了滑动则定位区县第⼀位if (index[1] != val[1]) {val[2] = 0;getCountyInfo(val[0], val[1], this);//获取区县数据}}index = val;console.log(index + " => " + val);//更新数据this.setData({value: [val[0], val[1], val[2]],province: provinces[val[0]].name,city: citys[val[1]].name,county: countys[val[2]].name})},onLoad: function (options) {cellId = options.cellId;var that = this;var date = new Date()console.log(date.getFullYear() + "年" + (date.getMonth() + 1) + "⽉" + date.getDate() + "⽇"); //获取省市区县数据area.getAreaInfo(function (arr) {areaInfo = arr;//获取省份数据getProvinceData(that);});},// ------------------- 分割线 --------------------onReady: function () {this.animation = wx.createAnimation({transformOrigin: "50% 50%",duration: 0,timingFunction: "ease",delay: 0})this.animation.translateY(200 + 'vh').step();this.setData({animation: this.animation.export(),show: show})},//移动按钮点击事件translate: function (e) {if (t == 0) {moveY = 0;show = false;t = 1;} else {moveY = 200;show = true;t = 0;}// this.animation.translate(arr[0], arr[1]).step();animationEvents(this,moveY, show);},//隐藏弹窗浮层hiddenFloatView(e){console.log(e);moveY = 200;show = true;t = 0;animationEvents(this,moveY, show);},//页⾯滑⾄底部事件onReachBottom: function () {// Do something when page reach bottom.},wx.navigateTo({url: '../../pages/modelTest/modelTest',})}})//动画事件function animationEvents(that,moveY,show){console.log("moveY:" + moveY + "\nshow:" + show);that.animation = wx.createAnimation({transformOrigin: "50% 50%",duration: 400,timingFunction: "ease",delay: 0})that.animation.translateY(moveY + 'vh').step()that.setData({animation: that.animation.export(),show: show})}// ---------------- 分割线 ----------------//获取省份数据function getProvinceData(that) {var s;provinces = [];var num = 0;for (var i = 0; i < areaInfo.length; i++) {s = areaInfo[i];if (s.di == "00" && s.xian == "00") {provinces[num] = s;num++;}}that.setData({provinces: provinces})//初始化调⼀次可更改getCityArr(0, that);getCountyInfo(0, 0, that);that.setData({province: "北京市",city: "市辖区",county: "东城区",})}// 获取地级市数据function getCityArr(count, that) {var c;citys = [];var num = 0;for (var i = 0; i < areaInfo.length; i++) {c = areaInfo[i];if (c.xian == "00" && c.sheng == provinces[count].sheng && c.di != "00") { citys[num] = c;num++;}}if (citys.length == 0) {citys[0] = { name: '' };}that.setData({city: "",citys: citys,value: [count, 0, 0]})}// 获取区县数据function getCountyInfo(column0, column1, that) {var c;countys = [];var num = 0;for (var i = 0; i < areaInfo.length; i++) {if (c.xian != "00" && c.sheng == provinces[column0].sheng && c.di == citys[column1].di) { countys[num] = c;num++;}}if(countys.length == 0){countys[0] = {name:''};}that.setData({county: "",countys: countys,value: [column0, column1, 0]})}　wxss/**index.wxss**/page{background-color: rgba(255, 255, 255, 1);}.infoText{margin-top: 20rpx;text-align: center;width: 100%;justify-content: center;}picker-view{background-color: white;padding: 0;width: 100%;height: 380rpx;bottom: 0;position: fixed;}picker-view-column view{vertical-align:middle;font-size: 28rpx;line-height: 28rpx;height: 100%;display: flex;align-items: center;justify-content: center;}/* ----------------------------------------- */.animation-element-wrapper {display: flex;position: fixed;left: 0;top:0;height: 100%;width: 100%;background-color: rgba(0, 0, 0, 0.6);}.animation-element {display: flex;position: fixed;width: 100%;height: 470rpx;bottom: 0;background-color: rgba(255, 255, 255, 1);}.animation-button {margin-top: 20rpx;top:20rpx;width: 400rpx;height: 100rpx;line-height: 100rpx;align-items:center;}text{color: #999999;display: inline-flex;position: fixed;margin-top: 20rpx;text-align: center;line-height: 50rpx;font-size: 34rpx;font-family: Arial, Helvetica, sans-serif;}.left-bt{left: 30rpx;}.right-bt {right: 30rpx;}.line{display: block;position: fixed;height: 1rpx;width: 100%;margin-top: 89rpx;background-color: #eeeeee;} 这个是没有进⾏封装的处理项⽬⾥已经封装好，可直接通过模板调⽤使⽤。

Axure教程：省市县三级联动选择(全国省市区数据)

Axure教程：省市县三级联动选择（全国省市区数据）省市县三级联动选择功能在互联网平台应用非常广泛，很多人在做产品设计时，不知道怎么实现三级联动效果，或者只能简单实现一两个固定城市的三级联动效果。

如果要实现全国城市的三级联动选择呢？作者将通过这篇案列分享，教大家使用Axure制作实现“全国城市省市县三级联动选择效果”。

可以任意选择全国所有省份、选择该省份对应的城市、选择该城市对应的县区；未选择省份时，点击“城市下拉选择”，提示“请先选择省份”；未选择城市时，点击“县区下拉选择”，提示“请先选择城市”；切换选中省份时，重置城市及县区选项；切换选中城市时，重置县区选项当前选项处于下拉框选项状态时，点击其他选择框，隐藏当前选项下拉框；下拉选项框展示时，下拉箭头向上，下拉选项框隐藏时，下拉箭头向上；动态显示三级行政区移入状态、选中状态、取消选中状态。

（1）利用中继器的数据存储功能，用三个中继器分别存放省份、城市、区域数据；省份中继器只需1列，用来存放全国所有省份数据；城市中继器需要2列，用来存放省份数据及城市数据（注意省份名称要和省份中继器的省份名称一致）；县区中继器需要2列，用来存放城市数据及县区数据（注意城市名称要和城市中继器里城市名称一致）；（2）利用“省份下拉”元件的单击事件触发省份下拉选项的展示与隐藏；（3）利用临时变量将选中的省份名称赋值给省份输入框，从而显示当前已选省份；（4）利用“省份输入框”元件的文本改变事件，触发城市文本输入框的显示及城市下拉选项框的内容；（5）利用“城市下拉”元件的选中状态事件，判断省份是否选中，未选中城市则给出“请先选择省份！”的错误提示；（6）城市、区域涉及的各元件设置方式同“2、3、4、5”步骤。

省份输入框背景（省份背景），放在输入框底部省份输入框（省份显示），用于显示已选择的省份名称省份下拉指示图标（省份选择），用于点击触发展示下拉选项，隐藏下拉选项省份下拉组合选项（包括一个中继器sf,动态面板sfn,动态面板sfw），用于显示所有省份名字城市输入框背景(城市背景)，放在输入框底部城市输入框(城市显示)，用于显示已选择的城市名称城市下拉指示图标（城市选择），用于点击触发展示下拉选项，隐藏下拉选项城市下拉组合选项（包括一个中继器cs,动态面板csn,动态面板csw），用于显示所有城市名字县区输入框背景（县区背景），放在输入框底部县区输入框（县区文字），用于显示已选择的城市名称县区下拉指示图标（县区选择），用于点击触发展示下拉选项，隐藏下拉选项县区下拉组合选项（包括一个中继器xq,动态面板xqn,动态面板xqw），用于显示所有县区名字操作提示组合元件(提示框)，用于显示校验出错时的提示背景，整个案例的演示背景，可要可不要隐藏提示文件，重新布局元件后效果如下：1. 准备省份数据及操作显示元件拖入一个中继器sf，给中继器的默认Column0列添加全国所有省份数据，要加上“请选择”数据将中继器的数据通过每项加载时赋值给矩形，矩形显示的数据就是省份待选项数据将中继器sf转换为动态面板sfn，动态面板的大小为220px*240px。

全国省市县三级联动(数据完整版)

全国省市县三级联动（数据完整版）网页前台代码：<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Defaul t" EnableEventValidation="false"%><%@ Register assembly="AjaxControlToolkit"namespace="AjaxControlToolkit" tagprefix="cc1" %><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN""/TR/xhtml 1/DTD/xhtml1-transitional.dtd"><html xmlns="/1999/xhtml"><head runat="server"><title>无标题页</title></head><body><form id="form1" runat="server"><div align="center"><asp:ScriptManager ID="ScriptManager1" runat="server"></asp:ScriptManager><fieldset ><legend>全国省市县</legend><fieldset style="width: 265px"><legend>省</legend><asp:DropDownList ID="DropDownList1" runat="server"AutoPostBack="True"></asp:DropDownList><cc1:CascadingDropDown ID="DropDownList1_CascadingDropDown" runat="server"Category="provice" Enabled="True" LoadingText="读取数据中.." PromptText="请选择省"TargetControlID="DropDownList1" ServicePath="WebService.asmx" ServiceMethod ="GetproviceNames"></cc1:CascadingDropDown></fieldset><fieldset style="width: 266px"><legend>市</legend><asp:DropDownList ID="DropDownList2" runat="server" AutoPostBack="True"></asp:DropDownList><cc1:CascadingDropDown ID="DropDownList2_CascadingDropDown" runat="server"Category="city" Enabled="True" TargetControlID="DropDownList2" LoadingText="读取数据中.." PromptText="请选择市" ParentControlID="DropDownList1"ServicePath="WebService.asmx" ServiceMethod="GetCityNames"></cc1:CascadingDropDown></fieldset><fieldset style="width: 266px"><legend>县</legend><asp:DropDownList ID="DropDownList3" runat="server"></asp:DropDownList><cc1:CascadingDropDown ID="DropDownList3_CascadingDropDown" runat="server" Ca tegory="District" TargetControlID="DropDownList3"Enabled="True" LoadingText="读取数据中.." ParentControlID="DropDownList2"ServicePath="WebService.asmx" ServiceMethod="GetDistrictNames"></cc1:CascadingDropDown></fieldset></fieldset></div></form></body></html>WebService代码using System;using System.Collections;using System.Linq;using System.Web;using System.Web.Services;using System.Web.Services.Protocols;using System.Xml.Linq;//访问数据库命名空间using System.Data;using System.Data.SqlClient;//访问web.config命名空间using System.Web.Configuration;//导入ScriptServiceAttribute类的命名空间using System.Web.Script.Services;//返回CascadingDropDownNameValue数组所需的命名空间using AjaxControlToolkit;using System.Collections.Generic;using System.Collections.Specialized;///<summary>///WebService 的摘要说明///</summary>[WebService(Namespace = "/")][WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]//若要允许使用 AJAX 从脚本中调用此 Web 服务，请取消对下行的注释。

省市区三级联动

} //获取市的时候需要把省的ID传过来加载市 if (type.Equals("GetCity")) {
string sheng = context.Request.Form["Province"] == null ? "" : context.Request.Form["Province"]; string str = "select * from cities where provinceid='" + sheng + "'"; using (SqlDataAdapter ada = new SqlDataAdapter(str, conn)) {
$("#sheng").val("赋值"); GetShi();
$("#Shi").val("赋值"); GetQu(); $("@Qu").val("赋值"); }
})
function GetSheng() { $("#Sheng").empty(); $("#Sheng").append("<option value='0'>请选择</option>"); $.ajax({ type: "post", url: "GetJsonData.ashx", datatype: "josn", //数据类型 data: "type=GetProvince", async: false, //把异步改为同步 success: function (data) { var GetData = eval(data); //转一下型，GetData相当于一张表的模型了，打点就可以调用字段 $.each(GetData, function (i, item) { $("#Sheng").append("<option value='" + item.provinceid + "'>" + item.province + "</option>"); }) } }) GetShi();

记录地区三级联动查询

记录地区三级联动查询先是前台展⽰效果:点击省份时,城市和区域也变化点击城市时,区域发⽣变化代码:以新增地址作为例⼦1 @RequestMapping("/addAddress")2public String addAddress(HttpServletRequest request, ModelMap modelMap, HttpServletResponse response) {3//查出所有省份4 List<Map<String, Object>> provinceList = addressService.getAllRegion();5 modelMap.put("provinceList", provinceList);6return "wx/me/my_details_address_editor";7 }sql语句和数据库数据:<select id="getAllRegion" resultType="java.util.Map">select id as id, area_name as name from eb_area where level=1</select>查询出所有省份在前台页⾯展⽰,此时页⾯中只有省份可以选择前台代码:12 <form action="<%=basePath%>wx/me/saveAddress" method="POST" id="addAddressForm">3 <div class="myDtl_cnt_list">4 <div class="g-line g-clear">5 <h5 class="fl">姓名</h5>67 <div class="fr">8 <input class="myDtlIdy_input" style="" type="text" placeholder="请输⼊您的姓名" name="aName">9 </div>10 </div>11 <div class="g-line g-clear">12 <h5 class="fl">⼿机号码</h5>1314 <div class="fr">15 <input class="myDtlIdy_input" style="" type="text" placeholder="请输⼊您的⼿机号码" name="aPhone">16 </div>17 </div>18 <div class="g-line g-clear">19 <h5 class="fl">所在地区</h5>2021 <div class="fr">22 <label>23 <select style="line-height:1rem;height:2rem;width:5rem;border:none;" id="province2"24 name="provinceId">25 <option>选择省份</option>26 <c:forEach items="${provinceList}" var="province">27 <option value="${province.id}">${}</option>28 </c:forEach>29 <option>选择省份</option>30 </select>313233 <select style="line-height:1rem;height:2rem;width:5rem;border:none;" id="city2"34 name="cityId">35 <option value="">选择城市</option>36 </select>373839 <select style="line-height:1rem;height:2rem;width:5rem;border:none;" id="area2"40 name="areaId">41 <option value="">选择区域</option>42 </select>4344 </label>45 </div>46 </div>47 <label class="ml-row19 g-mt1">48 <textarea style="width:19rem;" name="aAddress" id="aAddress"></textarea>49 </label>50 </div>51 <div class="myDtlALL_ok"><a class="lgi_btn g-btn-crimson" href="javascript:void(0);"52 id="addAddress">保存</a></div>53 </form>54<script type="text/javascript">$("#addAddress").click(function () {$("#addAddressForm").submit();})//所在区域联动列表setup("province2", "city2", "area2");//下⾯有加载的js代码,定义⼀个通⽤⽅法,⽤于联动查询function setup(p, c, a) {$("#" + p + "").click(function () {province(p, c, a) //点击省份时联动查询省份,城市,区域⽅法});$("#" + c + "").click(function () {city(c, a); //点击城市的时候联动查询城市,区域的⽅法});}function province(p, c, a) {$.ajax({url: "<%=basePath%>wx/me/getCityByProvinceId?id=" + $("#" + p + "").val(),type: "POST",dataType: 'json',success: function (data) {$("#" + c + "").empty(); //清空下拉列表$.each($.parseJSON(data), function (i, json) { //$.parseJSON⽤于格式化json数据$("#" + c + "").append(" <option value='" + json.id + "'>" + + "</option>");//增加城市的数据 });city(c, a); }});}function city(c, a) {$.ajax({url: "<%=basePath%>wx/me/getAreaByCityId?id=" + $("#" + c + "").val(),type: "POST",dataType: 'json',success: function (data) {$("#" + a + "").empty(); //清空下拉列表$.each($.parseJSON(data), function (i, item) {$("#" + a + "").append(" <option value='" + item.id + "'>" + + "</option>");//增加区域的数据 });}});}</script>联动查询的后台代码:@RequestMapping("/getCityByProvinceId")@ResponseBodypublic String getCityByProvinceId(Integer id, HttpServletResponse response) {//根据省份id查询城市List<Map<String, Object>> cityList = addressService.getAllCitys(id);String json = JSON.toJSONString(cityList);return json;}@RequestMapping("/getAreaByCityId")@ResponseBodypublic String getAreaByCityId(Integer id, HttpServletResponse response) {//根据城市id查询地区List<Map<String, Object>> areaList = addressService.getAreaByCityId(id);String json = JSON.toJSONString(areaList);return json;}联动查询的sql语句:<select id="getAllCitys" resultType="java.util.Map" parameterType="ng.Integer">select id as id,area_name as name from eb_area where level=2 and parent_id =#{id} </select><select id="getAreaByCityId" resultType="java.util.Map" parameterType="ng.Integer"> select id as id,area_name as name from eb_area where level=3 and parent_id =#{id} </select>。

三级联动——最新版行政区划代码

三级联动——最新版⾏政区划代码---恢复内容开始---2018年4⽉中华⼈民共和国县以上⾏政区划代码⽂章末尾有整理好的Excel110000北京市110101东城区110102西城区110105朝阳区110106丰台区110107⽯景⼭区110108海淀区110109门头沟区110111房⼭区110112通州区110113顺义区110114昌平区110115⼤兴区110116怀柔区110117平⾕区110118密云区110119延庆区120000天津市120101和平区120102河东区120103河西区120104南开区120105河北区120106红桥区120110东丽区120111西青区120112津南区120113北⾠区120114武清区120115宝坻区120116滨海新区120117宁河区120118静海区120119蓟州区130000河北省130100⽯家庄市130102长安区130104桥西区130105新华区130107井陉矿区130108裕华区130109藁城区130110⿅泉区130111栾城区130121井陉县130123正定县130125⾏唐县130126灵寿县130127⾼⾢县130128深泽县130129赞皇县130130⽆极县130131平⼭县130132元⽒县130133赵县130181⾟集市130183晋州市130184新乐市130200唐⼭市130202路南区130203路北区130204古冶区130205开平区130207丰南区130208丰润区130209曹妃甸区130223滦县130224滦南县130225乐亭县130227迁西县130304北戴河区130306抚宁区130321青龙满族⾃治县130322昌黎县130324卢龙县130400邯郸市130402邯⼭区130403丛台区130404复兴区130406峰峰矿区130407肥乡区130408永年区130423临漳县130424成安县130425⼤名县130426涉县130427磁县130430邱县130431鸡泽县130432⼴平县130433馆陶县130434魏县130435曲周县130481武安市130500邢台市130502桥东区130503桥西区130521邢台县130522临城县130523内丘县130524柏乡县130525隆尧县130526任县130527南和县130528宁晋县130529巨⿅县130530新河县130531⼴宗县130532平乡县130533威县130534清河县130535临西县130581南宫市130582沙河市130600保定市130602竞秀区130606莲池区130607满城区130608清苑区130609徐⽔区130623涞⽔县130624⾩平县130626定兴县130627唐县130628⾼阳县130629容城县130630涞源县130631望都县130632安新县130633易县130634曲阳县130635蠡县130636顺平县130637博野县130638雄县130681涿州市130682定州市130683安国市130684⾼碑店市130700张家⼝市130702桥东区130703桥西区130705宣化区130706下花园区130708万全区130709崇礼区130722张北县130723康保县130800承德市130802双桥区130803双滦区130804鹰⼿营⼦矿区130821承德县130822兴隆县130824滦平县130825隆化县130826丰宁满族⾃治县130827宽城满族⾃治县130828围场满族蒙古族⾃治县130881平泉市130900沧州市130902新华区130903运河区130921沧县130922青县130923东光县130924海兴县130925盐⼭县130926肃宁县130927南⽪县130928吴桥县130929献县130930孟村回族⾃治县130981泊头市130982任丘市130983黄骅市130984河间市131000廊坊市131002安次区131003⼴阳区131022固安县131023永清县131024⾹河县131025⼤城县131026⽂安县131028⼤⼚回族⾃治县131081霸州市131082三河市131100衡⽔市131102桃城区131103冀州区131121枣强县131122武⾢县131123武强县131124饶阳县131125安平县131126故城县131127景县131128⾩城县131182深州市140000⼭西省140100太原市140105⼩店区140106迎泽区140107杏花岭区140108尖草坪区140109万柏林区140110晋源区140121清徐县140122阳曲县140123娄烦县140181古交市140200⼤同市140202城区140203矿区140211南郊区140212新荣区140221阳⾼县140222天镇县140223⼴灵县140224灵丘县140225浑源县140226左云县140227⼤同县140411郊区140421长治县140423襄垣县140424屯留县140425平顺县140426黎城县140427壶关县140428长⼦县140429武乡县140430沁县140431沁源县140481潞城市140500晋城市140502城区140521沁⽔县140522阳城县140524陵川县140525泽州县140581⾼平市140600朔州市140602朔城区140603平鲁区140621⼭阴县140622应县140623右⽟县140624怀仁县140700晋中市140702榆次区140721榆社县140722左权县140723和顺县140724昔阳县140725寿阳县140726太⾕县140727祁县140728平遥县140729灵⽯县140781介休市140800运城市140802盐湖区140821临猗县140822万荣县140823闻喜县140824稷⼭县140825新绛县140826绛县140827垣曲县140828夏县140829平陆县140830芮城县140881永济市140882河津市140900忻州市140902忻府区140921定襄县140922五台县140923代县140924繁峙县140925宁武县140926静乐县140927神池县140928五寨县140929岢岚县140930河曲县140931保德县140932偏关县140981原平市141000临汾市141002尧都区141021曲沃县141022翼城县141023襄汾县141024洪洞县141025古县141026安泽县141027浮⼭县141082霍州市141100吕梁市141102离⽯区141121⽂⽔县141122交城县141123兴县141124临县141125柳林县141126⽯楼县141127岚县141128⽅⼭县141129中阳县141130交⼝县141181孝义市141182汾阳市150000内蒙古⾃治区150100呼和浩特市150102新城区150103回民区150104⽟泉区150105赛罕区150121⼟默特左旗150122托克托县150123和林格尔县150124清⽔河县150125武川县150200包头市150202东河区150203昆都仑区150204青⼭区150205⽯拐区150206⽩云鄂博矿区150207九原区150221⼟默特右旗150222固阳县150223达尔罕茂明安联合旗150300乌海市150302海勃湾区150303海南区150304乌达区150400⾚峰市150402红⼭区150403元宝⼭区150404松⼭区150421阿鲁科尔沁旗150422巴林左旗150423巴林右旗150424林西县150425克什克腾旗150426翁⽜特旗150428喀喇沁旗150429宁城县150430敖汉旗150500通辽市150502科尔沁区150521科尔沁左翼中旗150522科尔沁左翼后旗150523开鲁县150524库伦旗150525奈曼旗150526扎鲁特旗150581霍林郭勒市150600鄂尔多斯市150602东胜区150603康巴什区150621达拉特旗150622准格尔旗150623鄂托克前旗150624鄂托克旗150625杭锦旗150626乌审旗150627伊⾦霍洛旗150700呼伦贝尔市150702海拉尔区150703扎赉诺尔区150721阿荣旗150726新巴尔虎左旗150727新巴尔虎右旗150781满洲⾥市150782⽛克⽯市150783扎兰屯市150784额尔古纳市150785根河市150800巴彦淖尔市150802临河区150821五原县150822磴⼝县150823乌拉特前旗150824乌拉特中旗150825乌拉特后旗150826杭锦后旗150900乌兰察布市150902集宁区150921卓资县150922化德县150923商都县150924兴和县150925凉城县150926察哈尔右翼前旗150927察哈尔右翼中旗150928察哈尔右翼后旗150929四⼦王旗150981丰镇市152200兴安盟152201乌兰浩特市152202阿尔⼭市152221科尔沁右翼前旗152222科尔沁右翼中旗152223扎赉特旗152224突泉县152500锡林郭勒盟152501⼆连浩特市152502锡林浩特市152522阿巴嘎旗152523苏尼特左旗152524苏尼特右旗152525东乌珠穆沁旗152526西乌珠穆沁旗152527太仆寺旗152528镶黄旗152529正镶⽩旗152530正蓝旗152531多伦县152900阿拉善盟152921阿拉善左旗152922阿拉善右旗152923额济纳旗210000辽宁省210100沈阳市210102和平区210103沈河区210104⼤东区210105皇姑区210106铁西区210111苏家屯区210112浑南区210113沈北新区210114于洪区210115辽中区210123康平县210124法库县210181新民市210200⼤连市210202中⼭区210203西岗区210204沙河⼝区210211⽢井⼦区210212旅顺⼝区210213⾦州区210214普兰店区210224长海县210281⽡房店市210283庄河市210300鞍⼭市210302铁东区210303铁西区210404望花区210411顺城区210421抚顺县210422新宾满族⾃治县210423清原满族⾃治县210500本溪市210502平⼭区210503溪湖区210504明⼭区210505南芬区210521本溪满族⾃治县210522桓仁满族⾃治县210600丹东市210602元宝区210603振兴区210604振安区210624宽甸满族⾃治县210681东港市210682凤城市210700锦州市210702古塔区210703凌河区210711太和区210726⿊⼭县210727义县210781凌海市210782北镇市210800营⼝市210802站前区210803西市区210804鲅鱼圈区210811⽼边区210881盖州市210882⼤⽯桥市210900⾩新市210902海州区210903新邱区210904太平区210905清河门区210911细河区210921⾩新蒙古族⾃治县210922彰武县211000辽阳市211002⽩塔区211003⽂圣区211004宏伟区211005⼸长岭区211011太⼦河区211021辽阳县211081灯塔市211100盘锦市211102双台⼦区211103兴隆台区211104⼤洼区211122盘⼭县211200铁岭市211202银州区211204清河区211221铁岭县211223西丰县211224昌图县211281调兵⼭市211282开原市211300朝阳市211302双塔区211303龙城区211321朝阳县211322建平县211324喀喇沁左翼蒙古族⾃治县211381北票市211382凌源市211400葫芦岛市211402连⼭区211403龙港区211404南票区211421绥中县220106绿园区220112双阳区220113九台区220122农安县220182榆树市220183德惠市220200吉林市220202昌⾢区220203龙潭区220204船营区220211丰满区220221永吉县220281蛟河市220282桦甸市220283舒兰市220284磐⽯市220300四平市220302铁西区220303铁东区220322梨树县220323伊通满族⾃治县220381公主岭市220382双辽市220400辽源市220402龙⼭区220403西安区220421东丰县220422东辽县220500通化市220502东昌区220503⼆道江区220521通化县220523辉南县220524柳河县220581梅河⼝市220582集安市220600⽩⼭市220602浑江区220605江源区220621抚松县220622靖宇县220623长⽩朝鲜族⾃治县220681临江市220700松原市220702宁江区220721前郭尔罗斯蒙古族⾃治县220722长岭县220723乾安县220781扶余市220800⽩城市220802洮北区220821镇赉县220822通榆县220881洮南市220882⼤安市222400延边朝鲜族⾃治州222401延吉市222402图们市222403敦化市222404珲春市222405龙井市222406和龙市222424汪清县222426安图县230000⿊龙江省230100哈尔滨市230102道⾥区230103南岗区230104道外区230108平房区230109松北区230110⾹坊区230111呼兰区230112阿城区230113双城区230123依兰县230200齐齐哈尔市230202龙沙区230203建华区230204铁锋区230205昂昂溪区230206富拉尔基区230207碾⼦⼭区230208梅⾥斯达斡尔族区230221龙江县230223依安县230224泰来县230225⽢南县230227富裕县230229克⼭县230230克东县230231拜泉县230281讷河市230300鸡西市230302鸡冠区230303恒⼭区230304滴道区230305梨树区230306城⼦河区230307⿇⼭区230321鸡东县230381虎林市230382密⼭市230400鹤岗市230402向阳区230403⼯农区230404南⼭区230405兴安区230406东⼭区230407兴⼭区230421萝北县230422绥滨县230500双鸭⼭市230502尖⼭区230503岭东区230505四⽅台区230506宝⼭区230521集贤县230522友谊县230523宝清县230524饶河县230600⼤庆市230602萨尔图区230603龙凤区230604让胡路区230605红岗区230606⼤同区230621肇州县230622肇源县230623林甸县230624杜尔伯特蒙古族⾃治县230700伊春市230702伊春区230703南岔区230704友好区230705西林区230706翠峦区230707新青区230708美溪区230709⾦⼭屯区230710五营区230711乌马河区230712汤旺河区230713带岭区230714乌伊岭区230715红星区230716上⽢岭区230722嘉荫县230781铁⼒市230800佳⽊斯市230803向阳区230804前进区230900七台河市230902新兴区230903桃⼭区230904茄⼦河区230921勃利县231000牡丹江市231002东安区231003阳明区231004爱民区231005西安区231025林⼝县231081绥芬河市231083海林市231084宁安市231085穆棱市231086东宁市231100⿊河市231102爱辉区231121嫩江县231123逊克县231124孙吴县231181北安市231182五⼤连池市231200绥化市231202北林区231221望奎县231222兰西县231223青冈县231224庆安县231225明⽔县231226绥棱县231281安达市231282肇东市231283海伦市232700⼤兴安岭地区232721呼玛县232722塔河县232723漠河县310000上海市310101黄浦区310104徐汇区310105长宁区310106静安区310107普陀区310109虹⼝区310110杨浦区310112闵⾏区310113宝⼭区310114嘉定区310115浦东新区310116⾦⼭区310117松江区310118青浦区310120奉贤区310151崇明区320000江苏省320100南京市320102⽞武区320104秦淮区320105建邺区320106⿎楼区320111浦⼝区320113栖霞区320114⾬花台区320115江宁区320116六合区320117溧⽔区320118⾼淳区320200⽆锡市320205锡⼭区320206惠⼭区320211滨湖区320213梁溪区320214新吴区320281江阴市320282宜兴市320324睢宁县320381新沂市320382邳州市320400常州市320402天宁区320404钟楼区320411新北区320412武进区320413⾦坛区320481溧阳市320500苏州市320505虎丘区320506吴中区320507相城区320508姑苏区320509吴江区320581常熟市320582张家港市320583昆⼭市320585太仓市320600南通市320602崇川区320611港闸区320612通州区320621海安县320623如东县320681启东市320682如皋市320684海门市320700连云港市320703连云区320706海州区320707赣榆区320722东海县320723灌云县320724灌南县320800淮安市320803淮安区320804淮阴区320812清江浦区320813洪泽区320826涟⽔县320830盱眙县320831⾦湖县320900盐城市320902亭湖区320903盐都区320904⼤丰区320921响⽔县320922滨海县320923⾩宁县320924射阳县320925建湖县320981东台市321000扬州市321002⼴陵区321003邗江区321012江都区321023宝应县321081仪征市321084⾼邮市321100镇江市321102京⼝区321111润州区321112丹徒区321181丹阳市321182扬中市321183句容市321200泰州市321202海陵区321203⾼港区321204姜堰区321281兴化市321282靖江市321283泰兴市321300宿迁市330103下城区330104江⼲区330105拱墅区330106西湖区330108滨江区330109萧⼭区330110余杭区330111富阳区330112临安区330122桐庐县330127淳安县330182建德市330200宁波市330203海曙区330205江北区330206北仑区330211镇海区330212鄞州区330213奉化区330225象⼭县330226宁海县330281余姚市330282慈溪市330300温州市330302⿅城区330303龙湾区330304瓯海区330305洞头区330324永嘉县330326平阳县330327苍南县330328⽂成县330329泰顺县330381瑞安市330382乐清市330400嘉兴市330402南湖区330411秀洲区330421嘉善县330424海盐县330481海宁市330482平湖市330483桐乡市330500湖州市330502吴兴区330503南浔区330521德清县330522长兴县330523安吉县330600绍兴市330602越城区330603柯桥区330604上虞区330624新昌县330681诸暨市330683嵊州市330700⾦华市330702婺城区330703⾦东区330723武义县330726浦江县330727磐安县330781兰溪市330782义乌市330783东阳市330784永康市330800衢州市330802柯城区330803衢江区330822常⼭县330824开化县330825龙游县330881江⼭市330900⾈⼭市330902定海区330903普陀区331024仙居县331081温岭市331082临海市331083⽟环市331100丽⽔市331102莲都区331121青⽥县331122缙云县331123遂昌县331124松阳县331125云和县331126庆元县331127景宁畲族⾃治县331181龙泉市340000安徽省340100合肥市340102瑶海区340103庐阳区340104蜀⼭区340111包河区340121长丰县340122肥东县340123肥西县340124庐江县340181巢湖市340200芜湖市340202镜湖区340203⼷江区340207鸠江区340208三⼭区340221芜湖县340222繁昌县340223南陵县340225⽆为县340300蚌埠市340302龙⼦湖区340303蚌⼭区340304禹会区340311淮上区340321怀远县340322五河县340323固镇县340400淮南市340402⼤通区340403⽥家庵区340404谢家集区340405⼋公⼭区340406潘集区340421凤台县340422寿县340500马鞍⼭市340503花⼭区340504⾬⼭区340506博望区340521当涂县340522含⼭县340523和县340600淮北市340602杜集区340603相⼭区340604烈⼭区340621濉溪县340700铜陵市340705铜官区340706义安区340711郊区340722枞阳县340800安庆市340802迎江区340803⼤观区340811宜秀区340822怀宁县340824潜⼭县340825太湖县340826宿松县340827望江县341023黟县341024祁门县341100滁州市341102琅琊区341103南谯区341122来安县341124全椒县341125定远县341126凤阳县341181天长市341182明光市341200⾩阳市341202颍州区341203颍东区341204颍泉区341221临泉县341222太和县341225⾩南县341226颍上县341282界⾸市341300宿州市341302埇桥区341321砀⼭县341322萧县341323灵璧县341324泗县341500六安市341502⾦安区341503裕安区341504叶集区341522霍邱县341523舒城县341524⾦寨县341525霍⼭县341600亳州市341602谯城区341621涡阳县341622蒙城县341623利⾟县341700池州市341702贵池区341721东⾄县341722⽯台县341723青阳县341800宣城市341802宣州区341821郎溪县341822⼴德县341823泾县341824绩溪县341825旌德县341881宁国市350000福建省350100福州市350102⿎楼区350103台江区350104仓⼭区350105马尾区350111晋安区350112长乐区350121闽侯县350122连江县350123罗源县350124闽清县350125永泰县350128平潭县350181福清市350200厦门市350203思明区350205海沧区350206湖⾥区350211集美区350212同安区350213翔安区350300莆⽥市350302城厢区350423清流县350424宁化县350425⼤⽥县350426尤溪县350427沙县350428将乐县350429泰宁县350430建宁县350481永安市350500泉州市350502鲤城区350503丰泽区350504洛江区350505泉港区350521惠安县350524安溪县350525永春县350526德化县350527⾦门县350581⽯狮市350582晋江市350583南安市350600漳州市350602芗城区350603龙⽂区350622云霄县350623漳浦县350624诏安县350625长泰县350626东⼭县350627南靖县350628平和县350629华安县350681龙海市350700南平市350702延平区350703建阳区350721顺昌县350722浦城县350723光泽县350724松溪县350725政和县350781邵武市350782武夷⼭市350783建瓯市350800龙岩市350802新罗区350803永定区350821长汀县350823上杭县350824武平县350825连城县350881漳平市350900宁德市350902蕉城区350921霞浦县350922古⽥县350923屏南县350924寿宁县350925周宁县350926柘荣县350981福安市350982福⿍市360000江西省360100南昌市360102东湖区360103西湖区360104青云谱区360105湾⾥区360111青⼭湖区360112新建区360121南昌县360123安义县360124进贤县360200景德镇市360202昌江区360323芦溪县360400九江市360402濂溪区360403浔阳区360404柴桑区360423武宁县360424修⽔县360425永修县360426德安县360428都昌县360429湖⼝县360430彭泽县360481瑞昌市360482共青城市360483庐⼭市360500新余市360502渝⽔区360521分宜县360600鹰潭市360602⽉湖区360622余江县360681贵溪市360700赣州市360702章贡区360703南康区360704赣县区360722信丰县360723⼤余县360724上犹县360725崇义县360726安远县360727龙南县360728定南县360729全南县360730宁都县360731于都县360732兴国县360733会昌县360734寻乌县360735⽯城县360781瑞⾦市360800吉安市360802吉州区360803青原区360821吉安县360822吉⽔县360823峡江县360824新⼲县360825永丰县360826泰和县360827遂川县360828万安县360829安福县360830永新县360881井冈⼭市360900宜春市360902袁州区360921奉新县360922万载县360923上⾼县360924宜丰县360925靖安县360926铜⿎县360981丰城市360982樟树市360983⾼安市361000抚州市361002临川区361003东乡区361021南城县361022黎川县361023南丰县361024崇仁县361025乐安县361026宜黄县361027⾦溪县361125横峰县361126⼷阳县361127余⼲县361128鄱阳县361129万年县361130婺源县361181德兴市370000⼭东省370100济南市370102历下区370103市中区370104槐荫区370105天桥区370112历城区370113长清区370114章丘区370124平阴县370125济阳县370126商河县370200青岛市370202市南区370203市北区370211黄岛区370212崂⼭区370213李沧区370214城阳区370215即墨区370281胶州市370283平度市370285莱西市370300淄博市370302淄川区370303张店区370304博⼭区370305临淄区370306周村区370321桓台县370322⾼青县370323沂源县370400枣庄市370402市中区370403薛城区370404峄城区370405台⼉庄区370406⼭亭区370481滕州市370500东营市370502东营区370503河⼝区370505垦利区370522利津县370523⼴饶县370600烟台市370602芝罘区370611福⼭区370612牟平区370613莱⼭区370634长岛县370681龙⼝市370682莱阳市370683莱州市370684蓬莱市370685招远市370686栖霞市370687海阳市370700潍坊市370702潍城区370703寒亭区370704坊⼦区370705奎⽂区370724临朐县370725昌乐县370781青州市370782诸城市370783寿光市370784安丘市370829嘉祥县370830汶上县370831泗⽔县370832梁⼭县370881曲⾩市370883邹城市370900泰安市370902泰⼭区370911岱岳区370921宁阳县370923东平县370982新泰市370983肥城市371000威海市371002环翠区371003⽂登区371082荣成市371083乳⼭市371100⽇照市371102东港区371103岚⼭区371121五莲县371122莒县371200莱芜市371202莱城区371203钢城区371300临沂市371302兰⼭区371311罗庄区371312河东区371321沂南县371322郯城县371323沂⽔县371324兰陵县371325费县371326平⾢县371327莒南县371328蒙阴县371329临沭县371400德州市371402德城区371403陵城区371422宁津县371423庆云县371424临⾢县371425齐河县371426平原县371427夏津县371428武城县371481乐陵市371482禹城市371500聊城市371502东昌府区371521阳⾕县371522莘县371523茌平县371524东阿县371525冠县371526⾼唐县371581临清市371600滨州市371602滨城区371603沾化区371621惠民县371622阳信县371623⽆棣县371625博兴县371626邹平县371700菏泽市371702牡丹区371703定陶区371721曹县371722单县371723成武县371724巨野县371725郓城县410106上街区410108惠济区410122中牟县410181巩义市410182荥阳市410183新密市410184新郑市410185登封市410200开封市410202龙亭区410203顺河回族区410204⿎楼区410205禹王台区410212祥符区410221杞县410222通许县410223尉⽒县410225兰考县410300洛阳市410302⽼城区410303西⼯区410304瀍河回族区410305涧西区410306吉利区410311洛龙区410322孟津县410323新安县410324栾川县410325嵩县410326汝阳县410327宜阳县410328洛宁县410329伊川县410381偃师市410400平顶⼭市410402新华区410403卫东区410404⽯龙区410411湛河区410421宝丰县410422叶县410423鲁⼭县410425郏县410481舞钢市410482汝州市410500安阳市410502⽂峰区410503北关区410505殷都区410506龙安区410522安阳县410523汤阴县410526滑县410527内黄县410581林州市410600鹤壁市410602鹤⼭区410603⼭城区410611淇滨区410621浚县410622淇县410700新乡市410702红旗区410703卫滨区410704凤泉区410711牧野区410721新乡县410724获嘉县410725原阳县410726延津县410727封丘县410728长垣县410781卫辉市410782辉县市410800焦作市410802解放区410825温县410882沁阳市410883孟州市410900濮阳市410902华龙区410922清丰县410923南乐县410926范县410927台前县410928濮阳县411000许昌市411002魏都区411003建安区411024鄢陵县411025襄城县411081禹州市411082长葛市411100漯河市411102源汇区411103郾城区411104召陵区411121舞阳县411122临颍县411200三门峡市411202湖滨区411203陕州区411221渑池县411224卢⽒县411281义马市411282灵宝市411300南阳市411302宛城区411303卧龙区411321南召县411322⽅城县411323西峡县411324镇平县411325内乡县411326淅川县411327社旗县411328唐河县411329新野县411330桐柏县411381邓州市411400商丘市411402梁园区411403睢阳区411421民权县411422睢县411423宁陵县411424柘城县411425虞城县411426夏⾢县411481永城市411500信阳市411502浉河区411503平桥区411521罗⼭县411522光⼭县411523新县411524商城县411525固始县411526潢川县411527淮滨县411528息县411600周⼝市411602川汇区411621扶沟县411622西华县411623商⽔县411624沈丘县411625郸城县411626淮阳县411627太康县411628⿅⾢县411681项城市411700驻马店市411702驿城区411729新蔡县419001济源市420000湖北省420100武汉市420102江岸区420103江汉区420104硚⼝区420105汉阳区420106武昌区420107青⼭区420111洪⼭区420112东西湖区420113汉南区420114蔡甸区420115江夏区420116黄陂区420117新洲区420200黄⽯市420202黄⽯港区420203西塞⼭区420204下陆区420205铁⼭区420222阳新县420281⼤冶市420300⼗堰市420302茅箭区420303张湾区420304郧阳区420322郧西县420323⽵⼭县420324⽵溪县420325房县420381丹江⼝市420500宜昌市420502西陵区420503伍家岗区420504点军区420505猇亭区420506夷陵区420525远安县420526兴⼭县420527秭归县420528长阳⼟家族⾃治县420529五峰⼟家族⾃治县420581宜都市420582当阳市420583枝江市420600襄阳市420602襄城区420606樊城区420607襄州区420624南漳县420625⾕城县420626保康县420682⽼河⼝市420683枣阳市420684宜城市420700鄂州市420702梁⼦湖区420703华容区420704鄂城区420800荆门市420802东宝区420804掇⼑区420821京⼭县420822沙洋县420881钟祥市420900孝感市420902孝南区420921孝昌县420922⼤悟县420923云梦县420981应城市420982安陆市420984汉川市421000荆州市421100黄冈市421102黄州区421121团风县421122红安县421123罗⽥县421124英⼭县421125浠⽔县421126蕲春县421127黄梅县421181⿇城市421182武⽳市421200咸宁市421202咸安区421221嘉鱼县421222通城县421223崇阳县421224通⼭县421281⾚壁市421300随州市421303曾都区421321随县421381⼴⽔市422800恩施⼟家族苗族⾃治州422801恩施市422802利川市422822建始县422823巴东县422825宣恩县422826咸丰县422827来凤县422828鹤峰县429004仙桃市429005潜江市429006天门市429021神农架林区430000湖南省430100长沙市430102芙蓉区430103天⼼区430104岳麓区430105开福区430111⾬花区430112望城区430121长沙县430181浏阳市430182宁乡市430200株洲市430202荷塘区430203芦淞区430204⽯峰区430211天元区430221株洲县430223攸县430224茶陵县430225炎陵县430281醴陵市430300湘潭市430302⾬湖区430304岳塘区430321湘潭县430381湘乡市430382韶⼭市430400衡阳市430405珠晖区430406雁峰区430407⽯⿎区430408蒸湘区430412南岳区430421衡阳县430422衡南县430423衡⼭县430424衡东县430426祁东县430481⽾阳市430482常宁市430500邵阳市430527绥宁县430528新宁县430529城步苗族⾃治县430581武冈市430600岳阳市430602岳阳楼区430603云溪区430611君⼭区430621岳阳县430623华容县430624湘阴县430626平江县430681汨罗市430682临湘市430700常德市430702武陵区430703⿍城区430721安乡县430722汉寿县430723澧县430724临澧县430725桃源县430726⽯门县430781津市市430800张家界市430802永定区430811武陵源区430821慈利县430822桑植县430900益阳市430902资阳区430903赫⼭区430921南县430922桃江县430923安化县430981沅江市431000郴州市431002北湖区431003苏仙区431021桂阳县431022宜章县431023永兴县431024嘉⽲县431025临武县431026汝城县431027桂东县431028安仁县431081资兴市431100永州市431102零陵区431103冷⽔滩区431121祁阳县431122东安县431123双牌县431124道县431125江永县431126宁远县431127蓝⼭县431128新⽥县431129江华瑶族⾃治县431200怀化市431202鹤城区431221中⽅县431222沅陵县431223⾠溪县431224溆浦县431225会同县431226⿇阳苗族⾃治县431227新晃侗族⾃治县431228芷江侗族⾃治县431229靖州苗族侗族⾃治县431230通道侗族⾃治县431281洪江市431300娄底市431302娄星区431321双峰县433125保靖县433126古丈县433127永顺县433130龙⼭县440000⼴东省440100⼴州市440103荔湾区440104越秀区440105海珠区440106天河区440111⽩云区440112黄埔区440113番禺区440114花都区440115南沙区440117从化区440118增城区440200韶关市440203武江区440204浈江区440205曲江区440222始兴县440224仁化县440229翁源县440232乳源瑶族⾃治县440233新丰县440281乐昌市440282南雄市440300深圳市440303罗湖区440304福⽥区440305南⼭区440306宝安区440307龙岗区440308盐⽥区440309龙华区440310坪⼭区440400珠海市440402⾹洲区440403⽃门区440404⾦湾区440500汕头市440507龙湖区440511⾦平区440512濠江区440513潮阳区440514潮南区440515澄海区440523南澳县440600佛⼭市440604禅城区440605南海区440606顺德区440607三⽔区440608⾼明区440700江门市440703蓬江区440704江海区440705新会区440781台⼭市440783开平市440784鹤⼭市440785恩平市440800湛江市440802⾚坎区440803霞⼭区440804坡头区440811⿇章区440823遂溪县440825徐闻县440881廉江市440882雷州市440883吴川市440900茂名市440902茂南区440904电⽩区441224怀集县441225封开县441226德庆县441284四会市441300惠州市441302惠城区441303惠阳区441322博罗县441323惠东县441324龙门县441400梅州市441402梅江区441403梅县区441422⼤埔县441423丰顺县441424五华县441426平远县441427蕉岭县441481兴宁市441500汕尾市441502城区441521海丰县441523陆河县441581陆丰市441600河源市441602源城区441621紫⾦县441622龙川县441623连平县441624和平县441625东源县441700阳江市441702江城区441704阳东区441721阳西县441781阳春市441800清远市441802清城区441803清新区441821佛冈县441823阳⼭县441825连⼭壮族瑶族⾃治县441826连南瑶族⾃治县441881英德市441882连州市441900东莞市442000中⼭市445100潮州市445102湘桥区445103潮安区445122饶平县445200揭阳市445202榕城区445203揭东区445222揭西县445224惠来县445281普宁市445300云浮市445302云城区445303云安区445321新兴县445322郁南县445381罗定市450000⼴西壮族⾃治区450100南宁市450102兴宁区450103青秀区450105江南区450107西乡塘区450108良庆区450109邕宁区450110武鸣区450123隆安县450124马⼭县450125上林县450126宾阳县450223⿅寨县450224融安县450225融⽔苗族⾃治县450226三江侗族⾃治县450300桂林市450302秀峰区450303叠彩区450304象⼭区450305七星区450311雁⼭区450312临桂区450321阳朔县450323灵川县450324全州县450325兴安县450326永福县450327灌阳县450328龙胜各族⾃治县450329资源县450330平乐县450331荔浦县450332恭城瑶族⾃治县450400梧州市450403万秀区450405长洲区450406龙圩区450421苍梧县450422藤县450423蒙⼭县450481岑溪市450500北海市450502海城区450503银海区450512铁⼭港区450521合浦县450600防城港市450602港⼝区450603防城区450621上思县450681东兴市450700钦州市450702钦南区450703钦北区450721灵⼭县450722浦北县450800贵港市450802港北区450803港南区450804覃塘区450821平南县450881桂平市450900⽟林市450902⽟州区450903福绵区450921容县450922陆川县450923博⽩县450924兴业县450981北流市451000百⾊市451002右江区451021⽥阳县451022⽥东县451023平果县451024德保县451026那坡县451027凌云县451028乐业县451029⽥林县451030西林县451031隆林各族⾃治县451081靖西市451100贺州市451102⼋步区451103平桂区451121昭平县451224东兰县451225罗城仫佬族⾃治县451226环江⽑南族⾃治县451227巴马瑶族⾃治县451228都安瑶族⾃治县451229⼤化瑶族⾃治县451300来宾市451302兴宾区451321忻城县451322象州县451323武宣县451324⾦秀瑶族⾃治县451381合⼭市451400崇左市451402江州区451421扶绥县451422宁明县451423龙州县451424⼤新县451425天等县451481凭祥市460000海南省460100海⼝市460105秀英区460106龙华区460107琼⼭区460108美兰区460200三亚市460202海棠区460203吉阳区460204天涯区460205崖州区460300三沙市460400儋州市469001五指⼭市469002琼海市469005⽂昌市469006万宁市469007东⽅市469021定安县469022屯昌县469023澄迈县469024临⾼县469025⽩沙黎族⾃治县469026昌江黎族⾃治县469027乐东黎族⾃治县469028陵⽔黎族⾃治县469029保亭黎族苗族⾃治县469030琼中黎族苗族⾃治县500000重庆市500101万州区500102涪陵区500103渝中区500104⼤渡⼝区500105江北区500106沙坪坝区500107九龙坡区500108南岸区500109北碚区500110綦江区500111⼤⾜区500112渝北区500113巴南区500114黔江区500115长寿区500116江津区500117合川区500118永川区500119南川区500120璧⼭区500151铜梁区500152潼南区500153荣昌区500154开州区500155梁平区500156武隆区500240⽯柱⼟家族⾃治县500241秀⼭⼟家族苗族⾃治县500242⾣阳⼟家族苗族⾃治县500243彭⽔苗族⼟家族⾃治县510000四川省510100成都市510104锦江区510105青⽺区510106⾦⽜区510107武侯区510108成华区510112龙泉驿区510113青⽩江区510114新都区510115温江区510116双流区510117郫都区510121⾦堂县510129⼤⾢县510131蒲江县510132新津县510181都江堰市510182彭州市510183邛崃市510184崇州市510185简阳市510300⾃贡市510302⾃流井区510303贡井区510304⼤安区510311沿滩区510321荣县510322富顺县510400攀枝花市510402东区510403西区510411仁和区510421⽶易县510422盐边县510500泸州市510502江阳区510503纳溪区510504龙马潭区510521泸县510522合江县510524叙永县510525古蔺县510600德阳市510603旌阳区510604罗江区510623中江县510681⼴汉市510682什邡市510683绵⽵市510700绵阳市510703涪城区510704游仙区510705安州区510722三台县510723盐亭县510725梓潼县510726北川羌族⾃治县510727平武县510781江油市510800⼴元市510802利州区510811昭化区510812朝天区510821旺苍县510822青川县510823剑阁县510824苍溪县510900遂宁市510903船⼭区510904安居区510921蓬溪县511100乐⼭市511102市中区511111沙湾区511112五通桥区511113⾦⼝河区511123犍为县511124井研县511126夹江县511129沐川县511132峨边彝族⾃治县511133马边彝族⾃治县511181峨眉⼭市511300南充市511302顺庆区511303⾼坪区511304嘉陵区511321南部县511322营⼭县511323蓬安县511324仪陇县511325西充县511381阆中市511400眉⼭市511402东坡区511403彭⼭区511421仁寿县511423洪雅县511424丹棱县511425青神县511500宜宾市511502翠屏区511503南溪区511521宜宾县511523江安县511524长宁县511525⾼县511526珙县511527筠连县511528兴⽂县511529屏⼭县511600⼴安市511602⼴安区511603前锋区511621岳池县511622武胜县511623邻⽔县511681华蓥市511700达州市511702通川区511703达川区511722宣汉县511723开江县511724⼤⽵县511725渠县511781万源市511800雅安市511802⾬城区511803名⼭区511822荥经县511823汉源县511824⽯棉县511825天全县511826芦⼭县511827宝兴县511900巴中市511902巴州区511903恩阳区511921通江县511922南江县511923平昌县512000资阳市512002雁江区512021安岳县512022乐⾄县513200阿坝藏族羌族⾃治州513201马尔康市513230壤塘县513231阿坝县513232若尔盖县513233红原县513300⽢孜藏族⾃治州513301康定市513322泸定县513323丹巴县513324九龙县513325雅江县513326道孚县513327炉霍县513328⽢孜县513329新龙县513330德格县513331⽩⽟县513332⽯渠县513333⾊达县513334理塘县513335巴塘县513336乡城县513337稻城县513338得荣县513400凉⼭彝族⾃治州513401西昌市513422⽊⾥藏族⾃治县513423盐源县513424德昌县513425会理县513426会东县513427宁南县513428普格县513429布拖县513430⾦阳县513431昭觉县513432喜德县513433冕宁县513434越西县513435⽢洛县513436美姑县513437雷波县520000贵州省520100贵阳市520102南明区520103云岩区520111花溪区520112乌当区520113⽩云区520115观⼭湖区520121开阳县520122息烽县520123修⽂县520181清镇市520200六盘⽔市520201钟⼭区520203六枝特区520221⽔城县520281盘州市520300遵义市520302红花岗区520303汇川区520304播州区520322桐梓县520323绥阳县520324正安县520325道真仡佬族苗族⾃治县520326务川仡佬族苗族⾃治县520327凤冈县520328湄潭县520329余庆县520330习⽔县520381⾚⽔市520382仁怀市520400安顺市520402西秀区520403平坝区520502七星关区520521⼤⽅县520522黔西县520523⾦沙县520524织⾦县520525纳雍县520526威宁彝族回族苗族⾃治县520527赫章县520600铜仁市520602碧江区520603万⼭区520621江⼝县520622⽟屏侗族⾃治县520623⽯阡县520624思南县520625印江⼟家族苗族⾃治县520626德江县520627沿河⼟家族⾃治县520628松桃苗族⾃治县522300黔西南布依族苗族⾃治州522301兴义市522322兴仁县522323普安县522324晴隆县522325贞丰县522326望谟县522327册亨县522328安龙县522600黔东南苗族侗族⾃治州522601凯⾥市522622黄平县522623施秉县522624三穗县522625镇远县522626岑巩县522627天柱县522628锦屏县522629剑河县522630台江县522631黎平县522632榕江县522633从江县522634雷⼭县522635⿇江县522636丹寨县522700黔南布依族苗族⾃治州522701都匀市522702福泉市522722荔波县522723贵定县522725瓮安县522726独⼭县522727平塘县522728罗甸县522729长顺县522730龙⾥县522731惠⽔县522732三都⽔族⾃治县530000云南省530100昆明市530102五华区530103盘龙区530111官渡区530112西⼭区530113东川区530114呈贡区530115晋宁区530124富民县530125宜良县530126⽯林彝族⾃治县530127嵩明县530128禄劝彝族苗族⾃治县530129寻甸回族彝族⾃治县530181安宁市530300曲靖市530302麒麟区530303沾益区530321马龙县530322陆良县。

全国地区选择（三级联动）

全国地区选择（三级联动）1、新建HTML⽂件，引⼊必须的js⽂件。

1、下载文档前请自行甄别文档内容的完整性，平台不提供额外的编辑、内容补充、找答案等附加服务。
2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
3、如文档侵犯您的权益，请联系客服反馈,我们会尽快为您处理(人工客服工作时间：9:00-18:30)。

中国省市区三级联动表

合集下载