省市联动数据库

合集下载

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

省市区三级联动菜单（附数据库）<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'),。

省市二级联动数据库生成代码(JAVA)

省市二级联动数据库生成代码（JAVA）来源：开发界数据来源于谷歌地图省市列表（无省、市、区字样）省市列表（带省、市、区）源代码注意：由于我不想把省、市、区这样的字也转换成拼音，如河北省转换为HBS，北京市转换为BJS，我把省、市、区相关字样已删除，但我也保留了原文件，有需要的可以下载。

表结构：[sql] view plaincopyprint?CREATE TABLE IF NOT EXISTS `city` (`id` varchar(50) NOT NULL,`type` varchar(50) NOT NULL,`parent_id` varchar(50) NOT NULL,`name` varchar(50) NOT NULL,`short` varchar(50) NOT NULL,PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;CREATE TABLE IF NOT EXISTS `city` (`id` varchar(50) NOT NULL,`type` varchar(50) NOT NULL,`parent_id` varchar(50) NOT NULL,`name` varchar(50) NOT NULL,`short` varchar(50) NOT NULL,PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;具体实现请看以下代码：[java] view plaincopyprint?package com.zxq.pinyin;import java.io.BufferedReader;import java.io.File;import java.io.FileInputStream;import java.io.FileNotFoundException;import java.io.IOException;import java.io.InputStreamReader;import java.util.ArrayList;import java.util.Iterator;import java.util.LinkedHashMap;import java.util.List;import java.util.Map;import java.util.Map.Entry;import java.util.Set;import net.sourceforge.pinyin4j.PinyinHelper;import net.sourceforge.pinyin4j.format.HanyuPinyinCaseType;import net.sourceforge.pinyin4j.format.HanyuPinyinOutputFormat;import net.sourceforge.pinyin4j.format.HanyuPinyinToneType;import net.sourceforge.pinyin4j.format.HanyuPinyinVCharType;import net.sourceforge.pinyin4j.format.exception.BadHanyuPinyinOutputFormatCombination;public class Covert {/*** 汉字转拼音，并将结果保存到省或市的map中* @param words 需要转换的字符串* @param provinceOrCity 省或市的Map*/public static void wordToPinYinSZM(String words, Map<String, String> provinceOrCity) { //调用Pinyin4J的方法//定义拼音输出格式HanyuPinyinOutputFormat hof = new HanyuPinyinOutputFormat();//大写hof.setCaseType(HanyuPinyinCaseType.UPPERCASE);//不包含声调hof.setToneType(HanyuPinyinToneType.WITHOUT_TONE);//u用V表示hof.setVCharType(HanyuPinyinVCharType.WITH_V);//由于只能对单字转换，所以需要把字符串转换为字符数组char[] characters = words.toCharArray();try {//StringBuilder存放结果StringBuilder sb = new StringBuilder();for(int i = 0; i < characters.length; i++) {//调用汉字转拼音核心方法，大家可以看到返回的是一个数组，因为有的汉字有多音字，所以可能返回多个//拼音结果，对此，我只取第一个,pinyinArray[0]，这样做不好的地方就是可能有的简拼不准确，例如//“重庆”我得到的是ZQ，zhong qing，这一点有待完善String[] pinyinArray = PinyinHelper.toHanyuPinyinStringArray(characters[i], hof);//substring(0, 1)则表示只取首字母sb.append(pinyinArray[0].substring(0, 1));}//放入省或市的Map中provinceOrCity.put(words, sb.toString());} catch (BadHanyuPinyinOutputFormatCombination e) {e.printStackTrace();}}/*** @param args*/public static void main(String[] args) {//读取事先定义好的省市文本文件，第一行为省/直辖市，第二行为各地级市File provinceFile = new File("F:\\province_city\\province.txt");//定义保存省、市数据的数据结构。

省市区三级联动数据库代码（国家统计局最新代码、包含整理步骤）

省市区三级联动数据库代码（国家统计局最新代码、包含整理步骤）最终整理后的成果图。

最近项⽬要⽤到省市区地址三级联动。

原有的数据是⽼版本的。

在⽹上找了找，发现很多，也很杂。

最终决定⾃⼰整理⼀份，就当练⼿了。

看到的数据只有代码和名称两列数据如：110000 北京市110100 市辖区110101 东城区去空格整理后复制到excel 表中供导⼊数据库1、⾸先要把地址分出 1 、2 、3 级代表省、市、区。

那么问题来了。

原先想依据名称列的缩进来进⾏区分，但是想想有点复杂，⽽且容易出错。

后来⽤地区的编码规律来区分编码为 6 个字符组成例如：110101⾸先把表结构建起来吧。

从Excel表导⼊数据吧,这个就不说咯现在开始了！如果后4位为"0000" ---------------------是省级 1UPDATE[region]SET level=1WHERE SUBSTRING(code,3,6) ='0000'GO如果后2位为"00" 和等级level 不等于1----------是市级 2UPDATE[Test].[dbo].[region]SET[level]=2WHERE SUBSTRING(code,5,6) ='00'and ([level]<>1 ro [level] is null)GO备注：什么？执⾏了没效果？先把 level 字段赋值为 0 吧。

UPDATE [region]SET level = 0WHERE level is nullGO其他的 -----------------------------------是区级 3UPDATE[region]SET level=3WHERE level = 0GO2、现在我们来把⽗ID 整理出来也是依靠地址编码看代码就懂了啦省级UPDATE[region]SET parent_id =0WHERE level=1GO市级UPDATE aSET a.[parent_id]= b.[id]from[region] a,[region] bWHERE SUBSTRING(a.[code],1,2) =SUBSTRING(b.[code],1,2) and a.[level]=2and b.[level]=1GO区级UPDATE aSET a.[parent_id]= b.[id]from[region] a,[region] bWHERE SUBSTRING(a.[code],1,4) =SUBSTRING(b.[code],1,4) and a.[level]=3and b.[level]=2GO3、整理地区全称（这个字段有必要整理出来，原因嘛，选择联动地区获得省市区地址名称的时候会有意外的惊喜！例如：北京市市辖区XXX区，北京市县XXX县虽然没错但是影响美观）直接上代码：UPDATE[region]SET text_full =textWHERE id = id and level=1GOUPDATE aSET a.text_full = b.text_full + a.text from[region] a,[region] bWHERE a.parent_id = b.id and a.[level]=2and b.[level]=1GOUPDATE aSET a.text_full = b.text_full + a.text_full from[region] a,[region] bWHERE a.parent_id = b.id and a.[level]=3and b.[level]=2GO现在好了，看下检查下数据。

省市县三级联动的SQL语句

这篇文章主要介绍了省市县三级联动的SQL语句，包括建表及插入数据,需要的朋友可以参考下首先是建表语句代码如下:CREATE TABLE `t_address_province` (`id` INT AUTO_INCREMENT PRIMARY KEY COMMENT '主键',`code` CHAR(6) NOT NULL COMMENT '省份编码',`name` VARCHAR(40) NOT NULL COMMENT '省份名称') ENGINE=InnoDB DEFAULT CHARSET=UTF8 COMMENT='省份信息表';CREATE TABLE `t_address_city` (`id` INT AUTO_INCREMENT PRIMARY KEY COMMENT '主键',`code` CHAR(6) NOT NULL COMMENT '城市编码',`name` VARCHAR(40) NOT NULL COMMENT '城市名称',`provinceCode` CHAR(6) NOT NULL COMMENT '所属省份编码') ENGINE=InnoDB DEFAULT CHARSET=UTF8 COMMENT='城市信息表';CREATE TABLE `t_address_town` (`id` INT AUTO_INCREMENT PRIMARY KEY COMMENT '主键',`code` CHAR(6) NOT NULL COMMENT '区县编码',`name` VARCHAR(40) NOT NULL COMMENT '区县名称',`cityCode` CHAR(6) NOT NULL COMMENT '所属城市编码') ENGINE=InnoDB DEFAULT CHARSET=UTF8 COMMENT='区县信息表';然后是省份信息表数据代码如下:INSERT INTO `t_address_province` V ALUES ('1', '110000', '北京市');INSERT INTO `t_address_province` V ALUES ('2', '120000', '天津市');INSERT INTO `t_address_province` V ALUES ('3', '130000', '河北省');INSERT INTO `t_address_province` V ALUES ('4', '140000', '山西省');INSERT INTO `t_address_province` V ALUES ('5', '150000', '内蒙古自治区');INSERT INTO `t_address_province` V ALUES ('6', '210000', '辽宁省');INSERT INTO `t_address_province` V ALUES ('7', '220000', '吉林省');INSERT INTO `t_address_province` V ALUES ('8', '230000', '黑龙江省');INSERT INTO `t_address_province` V ALUES ('9', '310000', '上海市');INSERT INTO `t_address_province` V ALUES ('10', '320000', '江苏省');INSERT INTO `t_address_province` V ALUES ('11', '330000', '浙江省');INSERT INTO `t_address_province` V ALUES ('12', '340000', '安徽省');INSERT INTO `t_address_province` V ALUES ('13', '350000', '福建省');INSERT INTO `t_address_province` V ALUES ('14', '360000', '江西省');INSERT INTO `t_address_province` V ALUES ('15', '370000', '山东省');INSERT INTO `t_address_province` V ALUES ('16', '410000', '河南省');INSERT INTO `t_address_province` V ALUES ('17', '420000', '湖北省');INSERT INTO `t_address_province` V ALUES ('18', '430000', '湖南省');INSERT INTO `t_address_province` V ALUES ('19', '440000', '广东省');INSERT INTO `t_address_province` V ALUES ('20', '450000', '广西壮族自治区'); INSERT INTO `t_address_province` V ALUES ('21', '460000', '海南省');INSERT INTO `t_address_province` V ALUES ('22', '500000', '重庆市');INSERT INTO `t_address_province` V ALUES ('23', '510000', '四川省');INSERT INTO `t_address_province` V ALUES ('24', '520000', '贵州省');INSERT INTO `t_address_province` V ALUES ('25', '530000', '云南省');INSERT INTO `t_address_province` V ALUES ('26', '540000', '西藏自治区'); INSERT INTO `t_address_province` V ALUES ('27', '610000', '陕西省');INSERT INTO `t_address_province` V ALUES ('28', '620000', '甘肃省');INSERT INTO `t_address_province` V ALUES ('29', '630000', '青海省');INSERT INTO `t_address_province` V ALUES ('30', '640000', '宁夏回族自治区'); INSERT INTO `t_address_province` V ALUES ('31', '650000', '新疆维吾尔自治区'); INSERT INTO `t_address_province` V ALUES ('32', '710000', '台湾省');INSERT INTO `t_address_province` V ALUES ('33', '810000', '香港特别行政区'); INSERT INTO `t_address_province` V ALUES ('34', '820000', '澳门特别行政区'); 下面是城市信息表数据代码如下:INSERT INTO `t_address_city` V ALUES ('1', '110100', '北京市', '110000'); INSERT INTO `t_address_city` V ALUES ('2', '1102xx', '北京下属县', '1100xx'); INSERT INTO `t_address_city` V ALUES ('3', '120100', '天津市', '120000'); INSERT INTO `t_address_city` V ALUES ('4', '1202xx', '天津下属县', '1200xx'); INSERT INTO `t_address_city` V ALUES ('5', '130100', '石家庄市', '130000'); INSERT INTO `t_address_city` V ALUES ('6', '130200', '唐山市', '130000'); INSERT INTO `t_address_city` V ALUES ('7', '130300', '秦皇岛市', '130000'); INSERT INTO `t_address_city` V ALUES ('8', '130400', '邯郸市', '130000'); INSERT INTO `t_address_city` V ALUES ('9', '130500', '邢台市', '130000'); INSERT INTO `t_address_city` V ALUES ('10', '130600', '保定市', '130000'); INSERT INTO `t_address_city` V ALUES ('11', '130700', '张家口市', '130000'); INSERT INTO `t_address_city` V ALUES ('12', '130800', '承德市', '130000'); INSERT INTO `t_address_city` V ALUES ('13', '130900', '沧州市', '130000'); INSERT INTO `t_address_city` V ALUES ('14', '131000', '廊坊市', '130000'); INSERT INTO `t_address_city` V ALUES ('15', '131100', '衡水市', '130000'); INSERT INTO `t_address_city` V ALUES ('16', '140100', '太原市', '140000'); INSERT INTO `t_address_city` V ALUES ('17', '140200', '大同市', '140000'); INSERT INTO `t_address_city` V ALUES ('18', '140300', '阳泉市', '140000'); INSERT INTO `t_address_city` VALUES ('19', '140400', '长治市', '140000'); INSERT INTO `t_address_city` V ALUES ('20', '140500', '晋城市', '140000'); INSERT INTO `t_address_city` V ALUES ('21', '140600', '朔州市', '140000'); INSERT INTO `t_address_city` V ALUES ('22', '140700', '晋中市', '140000'); INSERT INTO `t_address_city` V ALUES ('23', '140800', '运城市', '140000'); INSERT INTO `t_address_city` V ALUES ('24', '140900', '忻州市', '140000'); INSERT INTO `t_address_city` V ALUES ('25', '141000', '临汾市', '140000'); INSERT INTO `t_address_city` V ALUES ('26', '141100', '吕梁市', '140000'); INSERT INTO `t_address_city` V ALUES ('27', '150100', '呼和浩特市', '150000');INSERT INTO `t_address_city` V ALUES ('29', '150300', '乌海市', '150000');INSERT INTO `t_address_city` V ALUES ('30', '150400', '赤峰市', '150000');INSERT INTO `t_address_city` V ALUES ('31', '150500', '通辽市', '150000');INSERT INTO `t_address_city` V ALUES ('32', '150600', '鄂尔多斯市', '150000'); INSERT INTO `t_address_city` V ALUES ('33', '150700', '呼伦贝尔市', '150000'); INSERT INTO `t_address_city` V ALUES ('34', '150800', '巴彦淖尔市', '150000'); INSERT INTO `t_address_city` V ALUES ('35', '150900', '乌兰察布市', '150000'); INSERT INTO `t_address_city` V ALUES ('36', '152200', '兴安盟', '150000');INSERT INTO `t_address_city` V ALUES ('37', '152500', '锡林郭勒盟', '150000'); INSERT INTO `t_address_city` V ALUES ('38', '152900', '阿拉善盟', '150000'); INSERT INTO `t_address_city` V ALUES ('39', '210100', '沈阳市', '210000');INSERT INTO `t_address_city` V ALUES ('40', '210200', '大连市', '210000');INSERT INTO `t_address_city` V ALUES ('41', '210300', '鞍山市', '210000');INSERT INTO `t_address_city` V ALUES ('42', '210400', '抚顺市', '210000');INSERT INTO `t_address_city` VALUES ('43', '210500', '本溪市', '210000');INSERT INTO `t_address_city` V ALUES ('44', '210600', '丹东市', '210000');INSERT INTO `t_address_city` V ALUES ('45', '210700', '锦州市', '210000');INSERT INTO `t_address_city` V ALUES ('46', '210800', '营口市', '210000');INSERT INTO `t_address_city` V ALUES ('47', '210900', '阜新市', '210000');INSERT INTO `t_address_city` V ALUES ('48', '211000', '辽阳市', '210000');INSERT INTO `t_address_city` V ALUES ('49', '211100', '盘锦市', '210000');INSERT INTO `t_address_city` V ALUES ('50', '211200', '铁岭市', '210000');INSERT INTO `t_address_city` V ALUES ('51', '211300', '朝阳市', '210000');INSERT INTO `t_address_city` V ALUES ('52', '211400', '葫芦岛市', '210000'); INSERT INTO `t_address_city` V ALUES ('53', '220100', '长春市', '220000');INSERT INTO `t_address_city` V ALUES ('54', '220200', '吉林市', '220000');INSERT INTO `t_address_city` V ALUES ('55', '220300', '四平市', '220000');INSERT INTO `t_address_city` V ALUES ('56', '220400', '辽源市', '220000');INSERT INTO `t_address_city` V ALUES ('57', '220500', '通化市', '220000');INSERT INTO `t_address_city` V ALUES ('58', '220600', '白山市', '220000');INSERT INTO `t_address_city` V ALUES ('59', '220700', '松原市', '220000');INSERT INTO `t_address_city` V ALUES ('60', '220800', '白城市', '220000');INSERT INTO `t_address_city` V ALUES ('61', '222400', '延边朝鲜族自治州', '220000'); INSERT INTO `t_address_city` V ALUES ('62', '230100', '哈尔滨市', '230000'); INSERT INTO `t_address_city` V ALUES ('63', '230200', '齐齐哈尔市', '230000'); INSERT INTO `t_address_city` V ALUES ('64', '230300', '鸡西市', '230000');INSERT INTO `t_address_city` V ALUES ('65', '230400', '鹤岗市', '230000');INSERT INTO `t_address_city` V ALUES ('66', '230500', '双鸭山市', '230000'); INSERT INTO `t_address_city` V ALUES ('67', '230600', '大庆市', '230000');INSERT INTO `t_address_city` V ALUES ('68', '230700', '伊春市', '230000');INSERT INTO `t_address_city` V ALUES ('69', '230800', '佳木斯市', '230000'); INSERT INTO `t_address_city` V ALUES ('70', '230900', '七台河市', '230000'); INSERT INTO `t_address_city` V ALUES ('71', '231000', '牡丹江市', '230000');INSERT INTO `t_address_city` V ALUES ('73', '231200', '绥化市', '230000'); INSERT INTO `t_address_city` VALUES ('74', '232700', '大兴安岭地区', '230000'); INSERT INTO `t_address_city` V ALUES ('75', '310100', '上海市', '310000'); INSERT INTO `t_address_city` V ALUES ('76', '3102xx', '上海下属县', '3100xx'); INSERT INTO `t_address_city` V ALUES ('77', '320100', '南京市', '320000'); INSERT INTO `t_address_city` V ALUES ('78', '320200', '无锡市', '320000'); INSERT INTO `t_address_city` V ALUES ('79', '320300', '徐州市', '320000'); INSERT INTO `t_address_city` V ALUES ('80', '320400', '常州市', '320000'); INSERT INTO `t_address_city` VALUES ('81', '320500', '苏州市', '320000'); INSERT INTO `t_address_city` V ALUES ('82', '320600', '南通市', '320000'); INSERT INTO `t_address_city` V ALUES ('83', '320700', '连云港市', '320000'); INSERT INTO `t_address_city` V ALUES ('84', '320800', '淮安市', '320000'); INSERT INTO `t_address_city` V ALUES ('85', '320900', '盐城市', '320000'); INSERT INTO `t_address_city` V ALUES ('86', '321000', '扬州市', '320000'); INSERT INTO `t_address_city` V ALUES ('87', '321100', '镇江市', '320000'); INSERT INTO `t_address_city` V ALUES ('88', '321200', '泰州市', '320000'); INSERT INTO `t_address_city` V ALUES ('89', '321300', '宿迁市', '320000'); INSERT INTO `t_address_city` V ALUES ('90', '330100', '杭州市', '330000'); INSERT INTO `t_address_city` V ALUES ('91', '330200', '宁波市', '330000'); INSERT INTO `t_address_city` V ALUES ('92', '330300', '温州市', '330000'); INSERT INTO `t_address_city` V ALUES ('93', '330400', '嘉兴市', '330000'); INSERT INTO `t_address_city` V ALUES ('94', '330500', '湖州市', '330000'); INSERT INTO `t_address_city` V ALUES ('95', '330600', '绍兴市', '330000'); INSERT INTO `t_address_city` V ALUES ('96', '330700', '金华市', '330000'); INSERT INTO `t_address_city` V ALUES ('97', '330800', '衢州市', '330000'); INSERT INTO `t_address_city` V ALUES ('98', '330900', '舟山市', '330000'); INSERT INTO `t_address_city` V ALUES ('99', '331000', '台州市', '330000'); INSERT INTO `t_address_city` V ALUES ('100', '331100', '丽水市', '330000'); INSERT INTO `t_address_city` V ALUES ('101', '340100', '合肥市', '340000'); INSERT INTO `t_address_city` V ALUES ('102', '340200', '芜湖市', '340000'); INSERT INTO `t_address_city` V ALUES ('103', '340300', '蚌埠市', '340000'); INSERT INTO `t_address_city` V ALUES ('104', '340400', '淮南市', '340000'); INSERT INTO `t_address_city` V ALUES ('105', '340500', '马鞍山市', '340000'); INSERT INTO `t_address_city` V ALUES ('106', '340600', '淮北市', '340000'); INSERT INTO `t_address_city` V ALUES ('107', '340700', '铜陵市', '340000'); INSERT INTO `t_address_city` V ALUES ('108', '340800', '安庆市', '340000'); INSERT INTO `t_address_city` V ALUES ('109', '341000', '黄山市', '340000'); INSERT INTO `t_address_city` V ALUES ('110', '341100', '滁州市', '340000'); INSERT INTO `t_address_city` V ALUES ('111', '341200', '阜阳市', '340000'); INSERT INTO `t_address_city` V ALUES ('112', '341300', '宿州市', '340000'); INSERT INTO `t_address_city` V ALUES ('113', '341400', '巢湖市', '340000'); INSERT INTO `t_address_city` V ALUES ('114', '341500', '六安市', '340000'); INSERT INTO `t_address_city` V ALUES ('115', '341600', '亳州市', '340000');INSERT INTO `t_address_city` V ALUES ('117', '341800', '宣城市', '340000'); INSERT INTO `t_address_city` V ALUES ('118', '350100', '福州市', '350000'); INSERT INTO `t_address_city` V ALUES ('119', '350200', '厦门市', '350000'); INSERT INTO `t_address_city` V ALUES ('120', '350300', '莆田市', '350000'); INSERT INTO `t_address_city` V ALUES ('121', '350400', '三明市', '350000'); INSERT INTO `t_address_city` VALUES ('122', '350500', '泉州市', '350000'); INSERT INTO `t_address_city` V ALUES ('123', '350600', '漳州市', '350000'); INSERT INTO `t_address_city` V ALUES ('124', '350700', '南平市', '350000'); INSERT INTO `t_address_city` V ALUES ('125', '350800', '龙岩市', '350000'); INSERT INTO `t_address_city` V ALUES ('126', '350900', '宁德市', '350000'); INSERT INTO `t_address_city` V ALUES ('127', '360100', '南昌市', '360000'); INSERT INTO `t_address_city` V ALUES ('128', '360200', '景德镇市', '360000'); INSERT INTO `t_address_city` VALUES ('129', '360300', '萍乡市', '360000'); INSERT INTO `t_address_city` V ALUES ('130', '360400', '九江市', '360000'); INSERT INTO `t_address_city` V ALUES ('131', '360500', '新余市', '360000'); INSERT INTO `t_address_city` V ALUES ('132', '360600', '鹰潭市', '360000'); INSERT INTO `t_address_city` V ALUES ('133', '360700', '赣州市', '360000'); INSERT INTO `t_address_city` V ALUES ('134', '360800', '吉安市', '360000'); INSERT INTO `t_address_city` V ALUES ('135', '360900', '宜春市', '360000'); INSERT INTO `t_address_city` V ALUES ('136', '361000', '抚州市', '360000'); INSERT INTO `t_address_city` V ALUES ('137', '361100', '上饶市', '360000'); INSERT INTO `t_address_city` V ALUES ('138', '370100', '济南市', '370000'); INSERT INTO `t_address_city` V ALUES ('139', '370200', '青岛市', '370000'); INSERT INTO `t_address_city` V ALUES ('140', '370300', '淄博市', '370000'); INSERT INTO `t_address_city` V ALUES ('141', '370400', '枣庄市', '370000'); INSERT INTO `t_address_city` V ALUES ('142', '370500', '东营市', '370000'); INSERT INTO `t_address_city` V ALUES ('143', '370600', '烟台市', '370000'); INSERT INTO `t_address_city` V ALUES ('144', '370700', '潍坊市', '370000'); INSERT INTO `t_address_city` V ALUES ('145', '370800', '济宁市', '370000'); INSERT INTO `t_address_city` V ALUES ('146', '370900', '泰安市', '370000'); INSERT INTO `t_address_city` V ALUES ('147', '371000', '威海市', '370000'); INSERT INTO `t_address_city` V ALUES ('148', '371100', '日照市', '370000'); INSERT INTO `t_address_city` V ALUES ('149', '371200', '莱芜市', '370000'); INSERT INTO `t_address_city` V ALUES ('150', '371300', '临沂市', '370000'); INSERT INTO `t_address_city` V ALUES ('151', '371400', '德州市', '370000'); INSERT INTO `t_address_city` V ALUES ('152', '371500', '聊城市', '370000'); INSERT INTO `t_address_city` V ALUES ('153', '371600', '滨州市', '370000'); INSERT INTO `t_address_city` V ALUES ('154', '371700', '荷泽市', '370000'); INSERT INTO `t_address_city` V ALUES ('155', '410100', '郑州市', '410000'); INSERT INTO `t_address_city` V ALUES ('156', '410200', '开封市', '410000'); INSERT INTO `t_address_city` V ALUES ('157', '410300', '洛阳市', '410000'); INSERT INTO `t_address_city` V ALUES ('158', '410400', '平顶山市', '410000'); INSERT INTO `t_address_city` V ALUES ('159', '410500', '安阳市', '410000');INSERT INTO `t_address_city` V ALUES ('161', '410700', '新乡市', '410000');INSERT INTO `t_address_city` V ALUES ('162', '410800', '焦作市', '410000');INSERT INTO `t_address_city` V ALUES ('163', '410900', '濮阳市', '410000');INSERT INTO `t_address_city` V ALUES ('164', '411000', '许昌市', '410000');INSERT INTO `t_address_city` V ALUES ('165', '411100', '漯河市', '410000');INSERT INTO `t_address_city` V ALUES ('166', '411200', '三门峡市', '410000');INSERT INTO `t_address_city` V ALUES ('167', '411300', '南阳市', '410000');INSERT INTO `t_address_city` V ALUES ('168', '411400', '商丘市', '410000');INSERT INTO `t_address_city` V ALUES ('169', '411500', '信阳市', '410000');INSERT INTO `t_address_city` V ALUES ('170', '411600', '周口市', '410000');INSERT INTO `t_address_city` V ALUES ('171', '411700', '驻马店市', '410000');INSERT INTO `t_address_city` V ALUES ('172', '420100', '武汉市', '420000');INSERT INTO `t_address_city` V ALUES ('173', '420200', '黄石市', '420000');INSERT INTO `t_address_city` V ALUES ('174', '420300', '十堰市', '420000');INSERT INTO `t_address_city` V ALUES ('175', '420500', '宜昌市', '420000');INSERT INTO `t_address_city` V ALUES ('176', '420600', '襄樊市', '420000');INSERT INTO `t_address_city` V ALUES ('177', '420700', '鄂州市', '420000');INSERT INTO `t_address_city` V ALUES ('178', '420800', '荆门市', '420000');INSERT INTO `t_address_city` V ALUES ('179', '420900', '孝感市', '420000');INSERT INTO `t_address_city` VALUES ('180', '421000', '荆州市', '420000');INSERT INTO `t_address_city` V ALUES ('181', '421100', '黄冈市', '420000');INSERT INTO `t_address_city` V ALUES ('182', '421200', '咸宁市', '420000');INSERT INTO `t_address_city` V ALUES ('183', '421300', '随州市', '420000');INSERT INTO `t_address_city` VALUES ('184', '422800', '恩施土家族苗族自治州', '420000');INSERT INTO `t_address_city` V ALUES ('185', '429000', '省直辖行政单位', '420000');INSERT INTO `t_address_city` V ALUES ('186', '430100', '长沙市', '430000');INSERT INTO `t_address_city` V ALUES ('187', '430200', '株洲市', '430000');INSERT INTO `t_address_city` V ALUES ('188', '430300', '湘潭市', '430000');INSERT INTO `t_address_city` V ALUES ('189', '430400', '衡阳市', '430000');INSERT INTO `t_address_city` V ALUES ('190', '430500', '邵阳市', '430000');INSERT INTO `t_address_city` V ALUES ('191', '430600', '岳阳市', '430000');INSERT INTO `t_address_city` V ALUES ('192', '430700', '常德市', '430000');INSERT INTO `t_address_city` V ALUES ('193', '430800', '张家界市', '430000');INSERT INTO `t_address_city` V ALUES ('194', '430900', '益阳市', '430000');INSERT INTO `t_address_city` V ALUES ('195', '431000', '郴州市', '430000');INSERT INTO `t_address_city` V ALUES ('196', '431100', '永州市', '430000');INSERT INTO `t_address_city` V ALUES ('197', '431200', '怀化市', '430000');INSERT INTO `t_address_city` V ALUES ('198', '431300', '娄底市', '430000');INSERT INTO `t_address_city` VALUES ('199', '433100', '湘西土家族苗族自治州', '430000');INSERT INTO `t_address_city` V ALUES ('200', '440100', '广州市', '440000');INSERT INTO `t_address_city` V ALUES ('202', '440300', '深圳市', '440000');INSERT INTO `t_address_city` V ALUES ('203', '440400', '珠海市', '440000');INSERT INTO `t_address_city` V ALUES ('204', '440500', '汕头市', '440000');INSERT INTO `t_address_city` V ALUES ('205', '440600', '佛山市', '440000');INSERT INTO `t_address_city` V ALUES ('206', '440700', '江门市', '440000');INSERT INTO `t_address_city` V ALUES ('207', '440800', '湛江市', '440000');INSERT INTO `t_address_city` V ALUES ('208', '440900', '茂名市', '440000');INSERT INTO `t_address_city` V ALUES ('209', '441200', '肇庆市', '440000');INSERT INTO `t_address_city` V ALUES ('210', '441300', '惠州市', '440000');INSERT INTO `t_address_city` V ALUES ('211', '441400', '梅州市', '440000');INSERT INTO `t_address_city` V ALUES ('212', '441500', '汕尾市', '440000');INSERT INTO `t_address_city` V ALUES ('213', '441600', '河源市', '440000');INSERT INTO `t_address_city` VALUES ('214', '441700', '阳江市', '440000');INSERT INTO `t_address_city` V ALUES ('215', '441800', '清远市', '440000');INSERT INTO `t_address_city` V ALUES ('216', '441900', '东莞市', '440000');INSERT INTO `t_address_city` V ALUES ('217', '442000', '中山市', '440000');INSERT INTO `t_address_city` V ALUES ('218', '445100', '潮州市', '440000');INSERT INTO `t_address_city` V ALUES ('219', '445200', '揭阳市', '440000');INSERT INTO `t_address_city` V ALUES ('220', '445300', '云浮市', '440000');INSERT INTO `t_address_city` V ALUES ('221', '450100', '南宁市', '450000');INSERT INTO `t_address_city` V ALUES ('222', '450200', '柳州市', '450000');INSERT INTO `t_address_city` V ALUES ('223', '450300', '桂林市', '450000');INSERT INTO `t_address_city` V ALUES ('224', '450400', '梧州市', '450000');INSERT INTO `t_address_city` V ALUES ('225', '450500', '北海市', '450000');INSERT INTO `t_address_city` V ALUES ('226', '450600', '防城港市', '450000');INSERT INTO `t_address_city` V ALUES ('227', '450700', '钦州市', '450000');INSERT INTO `t_address_city` V ALUES ('228', '450800', '贵港市', '450000');INSERT INTO `t_address_city` V ALUES ('229', '450900', '玉林市', '450000');INSERT INTO `t_address_city` V ALUES ('230', '451000', '百色市', '450000');INSERT INTO `t_address_city` V ALUES ('231', '451100', '贺州市', '450000');INSERT INTO `t_address_city` V ALUES ('232', '451200', '河池市', '450000');INSERT INTO `t_address_city` V ALUES ('233', '451300', '来宾市', '450000');INSERT INTO `t_address_city` V ALUES ('234', '451400', '崇左市', '450000');INSERT INTO `t_address_city` V ALUES ('235', '460100', '海口市', '460000');INSERT INTO `t_address_city` V ALUES ('236', '460200', '三亚市', '460000');INSERT INTO `t_address_city` V ALUES ('237', '469000', '省直辖县级行政单位', '460000'); INSERT INTO `t_address_city` V ALUES ('238', '500100', '重庆市', '500000');INSERT INTO `t_address_city` V ALUES ('239', '5002xx', '重庆下属县', '5000xx'); INSERT INTO `t_address_city` V ALUES ('240', '5003xx', '重庆下属市', '5000xx'); INSERT INTO `t_address_city` VALUES ('241', '510100', '成都市', '510000');INSERT INTO `t_address_city` V ALUES ('242', '510300', '自贡市', '510000');INSERT INTO `t_address_city` V ALUES ('243', '510400', '攀枝花市', '510000');INSERT INTO `t_address_city` V ALUES ('244', '510500', '泸州市', '510000');。

C#comboBox实现省市两级联动（winform）

C#comboBox实现省市两级联动（winform）新建⼀个win form应⽤程序，拖两comboBox控件。

数据库见前⼀篇⽂章。

using System;using System.Collections.Generic;using ponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Windows.Forms;using System.Data.SqlClient;namespace省市{publicpartialclass Form1 : Form{public Form1(){InitializeComponent();}private void Form1_Load(object sender, EventArgs e){using (SqlConnection conn = new SqlConnection("server=.;database=DBPromary;user id=sa;password=123456")) {conn.Open();using (SqlCommand cmd = conn.CreateCommand()){mandText = "select proName from promary";using (SqlDataReader reader = cmd.ExecuteReader()){while (reader.Read()){string name = reader.GetString(reader.GetOrdinal("proName"));cb1.Items.Add(name);}}}}}privatevoid comboBox1_SelectedIndexChanged(object sender, EventArgs e){cb2.Items.Clear();using (SqlConnection conn =new SqlConnection("server=.;database=DBPromary;user id=sa;password=123456")){conn.Open();using (SqlCommand cmd = conn.CreateCommand()){mandText ="select cityName from city,promary where city.proID=promary.proID and promary.proName=@pname";cmd.Parameters.Add(new SqlParameter("pname",cb1.SelectedItem));using (SqlDataReader reader = cmd.ExecuteReader()){while (reader.Read()){string name = reader.GetString(reader.GetOrdinal("cityName"));cb2.Items.Add(name);}}}} } } }。

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

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

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

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

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

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

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

小程序省市区联动三种方法

小程序省市区联动三种方法一、通过接口获取省市区数据1.获取省份数据：从接口获取所有省份列表，返回一个包含所有省份信息的数组。

2.根据选中的省份获取城市数据：通过接口传递选中的省份ID，获取该省份下所有城市的列表，返回一个包含所有城市信息的数组。

3.根据选中的城市获取区域数据：通过接口传递选中的城市ID，获取该城市下所有区域的列表，返回一个包含所有区域信息的数组。

二、通过JSON数据获取省市区数据1.创建一个包含所有省份、城市和区域的JSON数据文件，格式如下："province":"name": "省份1","city":"name": "城市1","area": ["区域1", "区域2", ...]},"name": "城市2","area": ["区域1", "区域2", ...]},...},"name": "省份2","city":"name": "城市1","area": ["区域1", "区域2", ...]},"name": "城市2","area": ["区域1", "区域2", ...]},...},...2. 通过AJAX请求获取JSON数据文件，并解析为一个包含所有省份、城市和区域信息的JavaScript对象。

3.根据选中的省份、城市，动态生成相应的区域选项。

从数据库查询数据进行联动（类似城市联动）

从数据库查询数据进⾏联动（类似城市联动）数据库⾃⼰定义，我⽤了四个框联动，选择了⼀个才会出现下⼀个，每⼀个都会去数据库查询⼀次。

但是⼀开始第⼀次的⽅法是查询⼀次，然后每次联动都⽤的最开始⼀次的数据查询，后来发现查询⼀次不能让联动点来点去，只能⼀次顺序过去，所以才每次都查询。

第⼀次：前端:<select id="first" class="select"onchange="firstSel()"></select><select class="select" id="second"></select><select class="select"id="third"></select><select class="select"id="fourth"></select>js:function firstSel(){//如果第⼀个下拉列表的值改变则调⽤此⽅法var province = $("#first").val();//得到第⼀个下拉列表的值$("#second").hide(); //初始化的时候第⼆个下拉列表隐藏$("#third").hide();$("#fourth").hide();url = "ShopGet";param = "{\"province\":\"" + province+ "\"}";jsonObj = JSON.parse(param);if(province!=null && "" != province&& 1 != province){//传递数据$.post(url,jsonObj,function(data){var res = JSON.parse(data);var newcity = [];var newarea= [];var newshop= [];var option="<option value='0'>"+"-城市-"+"</option>";$.each(res,function(i,n){//循环，i为下标从0开始，n为集合中对应的第i个对象if(newcity.indexOf(n.city) == -1) {　//去掉重复值 newcity.push(n.city);option += "<option value='"+n.city+"'>"+n.city+"</option>" }});$("#second").html(option);//将循环拼接的字符串插⼊第⼆个下拉列表$("#second").show();//把第⼆个下拉列表展⽰$("#second").change(function () {//选择第⼆个框时$("#third").hide();$("#fourth").hide();//从前⾯重新选择时后⾯的选框要消失var city = $("#second").val();var option1="<option value='0'>"+"-市区-"+"</option>";/////for(i in newcity){//在城市数组中循环找到我选择的城市if(city==newcity[i]){//如果找到了就开始下⼀步$.each(res,function(i,n){//循环全部的数据库数据if(n.city==city) {　//如果数据库中某个城市是我选择的就添加地区到地区数组if(newarea.indexOf(n.area) == -1){ newarea.push(n.area);option1 += "<option value='"+n.area+"'>"+n.area+"</option>" }}});}}$("#third").html(option1);//将循环拼接的字符串插⼊第⼆个下拉列表$("#third").show();//把第⼆个下拉列表展⽰$("#third").change(function () {var area = $("#third").val();var option2="<option value='0'>"+"-站点-"+"</option>";for(i in newarea){if(area==newarea[i]){$.each(res,function(i,n){if(n.area==area){if(newshop.indexOf(n.shop) == -1){ newshop.push(n.shop);option2 += "<option value='"+n.shop+"'>"+n.shop+"</option>"　} } }); } }$("#fourth").html(option2);//将循环拼接的字符串插⼊第四个下拉列表$("#fourth").show();//把第四个下拉列表展⽰$("#fourth").change(function () {var shop=$("#fourth").val();alert(shop);});});});});}else {$("#second").hide();}}public ArrayList<Shop> ShopSelectD(Shop shop) throws SQLException {String sql = "select * from shop where 1=1 and province=?";pst = conn.prepareStatement(sql);pst.setString(1,shop.getProvince());mit();ResultSet rs = pst.executeQuery();ArrayList<Shop> ShopList = new ArrayList<Shop>();if(rs.next()){for(int i=0;i<=rs.getRow();i++){Shop shopTmp = new Shop();shopTmp.setId(rs.getInt("id"));shopTmp.setProvince(rs.getString("province"));shopTmp.setCity(rs.getString("city"));shopTmp.setArea(rs.getString("area"));shopTmp.setShop(rs.getString("shop"));ShopList.add(shopTmp);rs.next();}}return ShopList;}第⼆次：<select class="select"id="first2"name="first2" onchange="change(this)"></select><select class="select"id="second2"name="second2"onchange="change(this)"></select><select class="select"id="third2"name="third2"onchange="change(this)"></select><select class="select"id="fourth2"name="fourth2"onchange="change(this)"></select> function change(which){var type=null;var i=0;if(which.id=='first2'){$("#second2")[0].style.opacity = "0";$("#third2")[0].style.opacity = "0";$("#fourth2")[0].style.opacity = "0";var da =$('[name="first2"] option:selected').val();type="省会";id=2;}if(which.id=='second2'){$("#third2")[0].style.opacity = "0";$("#fourth2")[0].style.opacity = "0";var da = $("#second2").val();type="城市";id=3;}if(which.id=='third2'){var da = $("#third2").val();type="市区";id=4;}url = "ShopAllGet";param = "{\"date\":\"" +da+ "\",\"type\":\""+type+"\"}";jsonObj = JSON.parse(param);$.post(url,jsonObj,function(data){var res = JSON.parse(data);switch(id){case 2:option = "<option value='1'>"+"-城市-"+"</option>"$.each(res,function(i,n){//循环，i为下标从0开始，n为集合中对应的第i个对象option += "<option value='"+n.city+"'>"+n.city+"</option>" });$("#second2").html(option);//将循环拼接的字符串插⼊第⼆个下拉列表$("#second2")[0].style.opacity = "1"//把第⼆个下拉列表展⽰break;case 3:option = "<option value='1'>"+"-市区-"+"</option>"$.each(res,function(i,n){//循环，i为下标从0开始，n为集合中对应的第i个对象option += "<option value='"+n.area+"'>"+n.area+"</option>" });$("#third2").html(option);$("#third2")[0].style.opacity = "1"break;case 4:option="<option value='0'>"+"-站点-"+"</option>";$.each(res,function(i,n){option+= "<option value='"+n.shop+"'>"+n.shop+"</option>"　});$("#fourth2").html(option);$("#fourth2")[0].style.opacity = "1"break;break;}});}if("省会".equals(type)){shop.setProvince(date);System.out.print("action");ArrayList<Shop> ShopList = shopSi.ShopFindS(shop);if(ShopList.isEmpty()){out.print("查询错误");//传值，否则查不到数据会报错}else{JSONArray ShopListMsg = JSONArray.fromObject(ShopList);out.print(ShopListMsg);System.out.print(ShopListMsg);}}else if("城市".equals(type)){shop.setCity(date);ArrayList<Shop> ShopList2 = shopSi.CityFindS(shop);if(ShopList2.isEmpty()){out.print("查询错误");//传值，否则查不到数据会报错}else{JSONArray ShopListMsg = JSONArray.fromObject(ShopList2);out.print(ShopListMsg);System.out.print(ShopListMsg);}}else if("市区".equals(type)){shop.setArea(date);ArrayList<Shop> ShopList3 = shopSi.AreaFindS(shop);if(ShopList3.isEmpty()){out.print("查询错误");//传值，否则查不到数据会报错}else{JSONArray ShopListMsg = JSONArray.fromObject(ShopList3);out.print(ShopListMsg);System.out.print(ShopListMsg);}}//多的话可以继续联动public ArrayList<Shop> ProvinceSelectD(Shop shop) throws SQLException{String sql = "select distinct province from shop;";//⽤了 distinct去重复，所以js可以不⽤数组来去重 pst = conn.prepareStatement(sql);mit();ResultSet rs = pst.executeQuery();ArrayList<Shop> ShopList = new ArrayList<Shop>();if(rs.next()){for(int i=0;i<=rs.getRow();i++){Shop shopTmp = new Shop();shopTmp.setProvince(rs.getString("province"));ShopList.add(shopTmp);rs.next();}}return ShopList;}。

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

--创建DBTblArea数据库create database DBTblAreause DBTblAreago--创建TblArea表create table TblArea(AreaId int primary key,AreaName varchar(50) not null,AreaPId int not null)---------------------------------------------------------------------------------------------------------------------------------------- --中国34个省级行政单位 23个省 5个自治区 4个直辖市 2特别行政区insert into TblArea values(1,'北京市',0)insert into TblArea values(2,'天津市',0)insert into TblArea values(3,'上海市',0)insert into TblArea values(4,'重庆市',0)insert into TblArea values(5,'河北省',0)insert into TblArea values(6,'山西省',0)insert into TblArea values(7,'台湾省',0)insert into TblArea values(8,'辽宁省',0)insert into TblArea values(9,'吉林省',0)insert into TblArea values(10,'黑龙江省',0)insert into TblArea values(11,'江苏省',0)insert into TblArea values(12,'浙江省',0)insert into TblArea values(14,'福建省',0)insert into TblArea values(15,'江西省',0)insert into TblArea values(16,'山东省',0)insert into TblArea values(17,'河南省',0)insert into TblArea values(18,'湖北省',0)insert into TblArea values(19,'湖南省',0)insert into TblArea values(20,'广东省',0)insert into TblArea values(21,'甘肃省',0)insert into TblArea values(22,'四川省',0)insert into TblArea values(23,'贵州省',0)insert into TblArea values(24,'海南省',0)insert into TblArea values(25,'云南省',0)insert into TblArea values(26,'青海省',0)insert into TblArea values(27,'陕西省',0)insert into TblArea values(28,'广西壮族自治区',0)insert into TblArea values(29,'西藏自治区',0)insert into TblArea values(30,'宁夏回族自治区',0)insert into TblArea values(31,'新疆维吾尔自治区',0)insert into TblArea values(32,'内蒙古自治区',0)insert into TblArea values(33,'澳门特别行政区',0)insert into TblArea values(34,'香港特别行政区',0)------------------------------------------------------------------------------------------------------------------------------------------ --插入各个省的城市数据--4个直辖市insert into TblArea values(35,'北京市',1)insert into TblArea values(37,'上海市',3)insert into TblArea values(38,'重庆市',4)--5河北省(2005年辖：11个地级市，36个市辖区、22个县级市、108个县、6个自治县)insert into TblArea values(39,'石家庄市',5)insert into TblArea values(40,'唐山市',5)insert into TblArea values(41,'秦皇岛市',5)insert into TblArea values(42,'邯郸市',5)insert into TblArea values(43,'邢台市',5)insert into TblArea values(44,'保定市',5)insert into TblArea values(45,'张家口市',5)insert into TblArea values(46,'承德市',5)insert into TblArea values(47,'沧州市',5)insert into TblArea values(48,'廊坊市',5)insert into TblArea values(49,'衡水市',5)--6山西省11个城市insert into TblArea values(50,'太原市',6)insert into TblArea values(51,'大同市',6)insert into TblArea values(52,'阳泉市',6)insert into TblArea values(53,'长治市',6)insert into TblArea values(54,'晋城市',6)insert into TblArea values(55,'朔州市',6)insert into TblArea values(56,'晋中市',6)insert into TblArea values(57,'运城市',6)insert into TblArea values(58,'忻州市',6)insert into TblArea values(59,'临汾市',6)--7台湾省(台湾本岛和澎湖共设7市、16县，其中台北市和高雄市为“院辖市”，直属“行政院”，其余属台湾省；市下设区，县下设市（县辖市）、镇、乡，合称区市镇乡。

)insert into TblArea values(61,'台北市',7)insert into TblArea values(62,'高雄市',7)insert into TblArea values(63,'基隆市',7)insert into TblArea values(64,'台中市',7)insert into TblArea values(65,'台南市',7)insert into TblArea values(66,'新竹市',7)insert into TblArea values(67,'嘉义市',7)insert into TblArea values(68,'台北县',7)insert into TblArea values(69,'宜兰县',7)insert into TblArea values(70,'桃园县',7)insert into TblArea values(71,'新竹县',7)insert into TblArea values(72,'苗栗县',7)insert into TblArea values(73,'台中县',7)insert into TblArea values(74,'彰化县',7)insert into TblArea values(75,'南投县',7)insert into TblArea values(76,'云林县',7)insert into TblArea values(77,'嘉义县',7)insert into TblArea values(78,'台南县',7)insert into TblArea values(79,'高雄县',7)insert into TblArea values(80,'屏东县',7)insert into TblArea values(81,'澎湖县',7)insert into TblArea values(82,'台东县',7)insert into TblArea values(83,'花莲县',7)--8辽宁省(2006年，辖：14个地级市；56个市辖区、17个县级市、19个县、8个自治县。

)insert into TblArea values(84,'沈阳市',8)insert into TblArea values(85,'大连市',8)insert into TblArea values(86,'鞍山市',8)insert into TblArea values(87,'抚顺市',8)insert into TblArea values(88,'本溪市',8)insert into TblArea values(89,'丹东市',8)insert into TblArea values(90,'锦州市',8)insert into TblArea values(91,'营口市',8)insert into TblArea values(92,'阜新市',8)insert into TblArea values(93,'辽阳市',8)insert into TblArea values(94,'盘锦市',8)insert into TblArea values(95,'铁岭市',8)insert into TblArea values(96,'朝阳市',8)insert into TblArea values(97,'葫芦岛市',8)--9吉林省(2006年，辖：8个地级市、1个自治州；20个市辖区、20个县级市、17个县、3个自治县。