2018最新版省市区三级联动下拉框+所有源代码以及数据库

最新推荐文章于 2024-07-26 09:40:31 发布

木兰无长兄

最新推荐文章于 2024-07-26 09:40:31 发布

阅读量5.7k

点赞数 4

文章标签：三级联动数据库 java jsp servlet

本文链接：https://blog.csdn.net/liulan93/article/details/84984513

版权

2018年国家统计局最新数据，JSP+Servlet+Dao实现省市区三级联动下拉框的效果

DropdownDAO.java —–Dao层

package com;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.Map;

import com.DBHelp;

public class DropdownDAO {

	// 获得省
	@SuppressWarnings("rawtypes")
	public static ArrayList<Map> getprovince() throws SQLException {
		Map<String, String> map = new HashMap<String, String>();
		ArrayList<Map> rsList = new ArrayList<Map>();
		Connection conn = null;
		Statement stmt = null;
		ResultSet rs = null;
		String sql = "select * from province;";
		try {
			conn = DBHelp.getConnection();
			stmt = conn.createStatement();
			rs = stmt.executeQuery(sql);
			while (rs.next()) {
				map = new HashMap<String, String>();
				map.put("code", rs.getString("code_p"));
				map.put("name", rs.getString("name"));
				rsList.add(map);
			}
			return rsList;
		} catch (Exception e) {
			System.out.println("----获得省的方法出现异常:" + e);
			e.printStackTrace();
			return null;
		} finally {
		}
	}

	// 根据省编号获得市
	@SuppressWarnings("rawtypes")
	public static ArrayList<Map> getcity(String code_p) throws SQLException {
		Map<String, String> map = new HashMap<String, String>();
		ArrayList<Map> rsList = new ArrayList<Map>();
		Connection conn = null;
		Statement stmt = null;
		ResultSet rs = null;
		String sql = "select * from city where code_p=" + code_p + ";";
		try {
			conn = DBHelp.getConnection();
			stmt = conn.createStatement();
			rs = stmt.executeQuery(sql);
			while (rs.next()) {
				map = new HashMap<String, String>();
				map.put("code", rs.getString("code_c"));
				map.put("name", rs.getString("name"));
				rsList.add(map);
			}
			return rsList;
		} catch (Exception e) {
			System.out.println("----获得市的方法出现异常:" + e);
			e.printStackTrace();
			return null;
		} finally {
		}
	}

	//根据市编号获得区
	@SuppressWarnings("rawtypes")
	public static ArrayList<Map> getarea(String code_c) throws SQLException {   
		Map<String, String> map = new HashMap<String, String>();   
		ArrayList<Map> rsList = new ArrayList<Map>();
		Connection conn = null;   
		Statement stmt = null;   
		ResultSet rs = null;
		String sql = "select * from area where code_c="+code_c+";" ;   
		try {   
			conn = DBHelp.getConnection();   
			stmt = conn.createStatement();   
			rs = stmt.executeQuery(sql);   
			while (rs.next()) {   
				map = new HashMap<String, String>();  
				map.put("code", rs.getString("code_a"));
				map.put("name",rs.getString("name"));
				rsList.add(map);
			}   
			return rsList;   
		} catch (Exception e) {   
			System.out.println("----获得区的方法出现异常:" + e);   
			e.printStackTrace();   
			return null;   
		} finally {   
		}   
	}
}

DBHelp.java—-数据库连接层

package com;

import java.sql.Connection;
import java.sql.DriverManager;

public class DBHelp {

	private static Connection conn = null;

	public static Connection getConnection() {
		try {
			Class.forName("com.mysql.jdbc.Driver"); // 加载MySQL数据库驱动
			System.out.println("数据库驱动加载成功！！");
			String url = "jdbc:mysql://localhost:3306/region"; // 定义与连接数据库的url
			String user = "root"; // 定义连接数据库的用户名
			String passWord = "root"; // 定义连接数据库的密码
			conn = DriverManager.getConnection(url, user, passWord); // 连接连接
			System.out.println("已成功的与MySQL数据库建立连接！！");
		} catch (Exception e) {
			e.printStackTrace();
		}
		return conn;
	}
}

Dropdown.java——-Servlet层

package com;

import java.io.IOException;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.google.gson.Gson;

public class Dropdown extends HttpServlet{

	/**
	 * 
	 */
	private static final long serialVersionUID = 1L;

	public void doGet(HttpServletRequest request, HttpServletResponse response)throws IOException,ServletException{
		doPost(request,response);
	}

	public void doPost(HttpServletRequest request, HttpServletResponse response) throws IOException,ServletException{
		String code = request.getParameter("code");
		String grade = request.getParameter("grade");
		System.out.println("grade="+grade);
		System.out.println("code="+code);
		String json = "";
		List<?> rsList = new ArrayList<Object>();
		Gson gson = new Gson();
		try {
			if(grade.equals("province")){
				rsList=DropdownDAO.getprovince();
			}else if(grade.equals("city")){
				rsList=DropdownDAO.getcity(code);
			}else if(grade.equals("area")){
				rsList=DropdownDAO.getarea(code);}
			json = gson.toJson(rsList);
			System.out.println("json="+json);
		} catch (SQLException e) { 
			e.printStackTrace();
		}
		response.setCharacterEncoding("UTF-8");//防止出现中文乱码现象
		response.getWriter().print(json);
	}
}

为Servlet配置web.xml

<?xml version="1.0" encoding="UTF-8"?>
<web-app version="2.5" xmlns="http://java.sun.com/xml/ns/javaee"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="http://java.sun.com/xml/ns/javaee 
    http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd">

	<servlet>
		<servlet-name>Dropdown</servlet-name>
		<servlet-class>com.Dropdown</servlet-class>
	</servlet>

	<servlet-mapping>
		<servlet-name>Dropdown</servlet-name>
		<url-pattern>/com/Dropdown</url-pattern>
	</servlet-mapping>

	<welcome-file-list>
		<welcome-file>index.jsp</welcome-file>
	</welcome-file-list>
</web-app>

index.jsp —–JSP页面、视图层

<%@ page language="java" import="java.util.*" contentType="text/html; charset=utf-8" pageEncoding="utf-8"%>
<%
	String path = request.getContextPath();
	String basePath = request.getScheme() + "://" + request.getServerName() + ":" + request.getServerPort()
			+ path + "/";
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">
<title>省市区三级联动下拉框 |Three - Three Linkage Drop-Down Box</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">

<script type="text/javascript" src="<%=path%>/js/jquery-1.7.1.min.js"></script>
<script type="text/javascript" src="<%=path%>/js/json.js"></script>

<style>
body {
	text-align: center;
}
</style>

</head>

<body>
	<select name="province" id="province" onchange="onSelectChange(this,'city');" style="width: 100px"></select>
	<select name="city" id="city" onchange="onSelectChange(this,'area');" style="width: 100px"></select>
	<select name="area" id="area" style="width: 100px"></select>
</body>

<script type="text/javascript">
  	 
  	function onSelectChange(obj,toSelId){
  	    setSelect(obj.value,toSelId);
  	}
 
  	function setSelect(fromSelVal,toSelId){
  	    jQuery.ajax({
  	      url: "<%=path%>/com/Dropdown",
			cache : false,
			data : {
				"code" : fromSelVal,
				"grade" : toSelId
			},
			success : function(data) {
				createSelectObj(data, toSelId);
			}
		});
	}

	function createSelectObj(data, toSelId) {
		var arr = JSON.parse(data);
		if (arr != null && arr.length > 0) {
			var obj = document.getElementById(toSelId);
			obj.innerHTML = "";
			var nullOp = document.createElement("option");
			nullOp.setAttribute("value", "");
			obj.appendChild(nullOp);
			for ( var o in arr) {
				var op = document.createElement("option");
				op.setAttribute("value", arr[o].code);
				op.appendChild(document.createTextNode(arr[o].name));
				obj.appendChild(op);
			}
		}
	}

	setSelect('110000', 'province');
</script>
</html>

想要项目正常运行需要导入两个jar包：

1、gson-2.0.jar
2、mysql-connector-java-3.0.16-ga-bin.jar
此外需要将数据库导入自己的MYSQL，并在DBHelp.java里将数据库连接端口、用户名、密码改为自己数据库的

最后，数据库脚本region.sql如下：共包含三个表，一个province，一个city，一个area，分别保存省市区的数据

/*
Navicat MySQL Data Transfer

Source Server         : localhost_3306
Source Server Version : 50637
Source Host           : localhost:3306
Source Database       : region

Target Server Type    : MYSQL
Target Server Version : 50637
File Encoding         : 65001

Date: 2018-12-15 15:45:47
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for area
-- ----------------------------
DROP TABLE IF EXISTS `area`;
CREATE TABLE `area` (
  `id` varchar(15) NOT NULL,
  `code_a` varchar(15) NOT NULL,
  `name` varchar(20) NOT NULL,
  `code_c` varchar(15) DEFAULT NULL,
  PRIMARY KEY (`code_a`),
  KEY `FK_Reference_9` (`code_c`),
  CONSTRAINT `FK_Reference_9` FOREIGN KEY (`code_c`) REFERENCES `city` (`code_c`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='该实体为行政区域划分等级';

-- ----------------------------
-- Records of area
-- ----------------------------
INSERT INTO `area` VALUES ('1', '110101', '东城区', '110100');
INSERT INTO `area` VALUES ('2', '110102', '西城区', '110100');
INSERT INTO `area` VALUES ('3', '110105', '朝阳区', '110100');
INSERT INTO `area` VALUES ('4', '110106', '丰台区', '110100');
INSERT INTO `area` VALUES ('5', '110107', '石景山区', '110100');
INSERT INTO `area` VALUES ('6', '110108', '海淀区', '110100');
INSERT INTO `area` VALUES ('7', '110109', '门头沟区', '110100');
INSERT INTO `area` VALUES ('8', '110111', '房山区', '110100');
INSERT INTO `area` VALUES ('9', '110112', '通州区', '110100');
INSERT INTO `area` VALUES ('10', '110113', '顺义区', '110100');
INSERT INTO `area` VALUES ('11', '110114', '昌平区', '110100');
INSERT INTO `area` VALUES ('12', '110115', '大兴区', '110100');
INSERT INTO `area` VALUES ('13', '110116', '怀柔区', '110100');
INSERT INTO `area` VALUES ('14', '110117', '平谷区', '110100');
INSERT INTO `area` VALUES ('15', '110228', '密云县', '110100');
INSERT INTO `area` VALUES ('16', '110229', '延庆县', '110100');
INSERT INTO `area` VALUES ('17', '120101', '和平区', '120100');
INSERT INTO `area` VALUES ('18', '120102', '河东区', '120100');
INSERT INTO `area` VALUES ('19', '120103', '河西区', '120100');
INSERT INTO `area` VALUES ('20', '120104', '南开区', '120100');
INSERT INTO `area` VALUES ('21', '120105', '河北区', '120100');
INSERT INTO `area` VALUES ('22', '120106', '红桥区', '120100');
INSERT INTO `area` VALUES ('23', '120110', '东丽区', '120100');
INSERT INTO `area` VALUES ('24', '120111', '西青区', '120100');
INSERT INTO `area` VALUES ('25', '120112', '津南区', '120100');
INSERT INTO `area` VALUES ('26', '120113', '北辰区', '120100');
INSERT INTO `area` VALUES ('27', '120114', '武清区', '120100');
INSERT INTO `area` VALUES ('28', '120115', '宝坻区', '120100');
INSERT INTO `area` VALUES ('29', '120116', '滨海新区', '120100');
INSERT INTO `area` VALUES ('30', '120221', '宁河县', '120100');
INSERT INTO `area` VALUES ('31', '120223', '静海县', '120100');
INSERT INTO `area` VALUES ('32', '120225', '蓟县', '120100');
INSERT INTO `area` VALUES ('33', '130102', '长安区', '130100');
INSERT INTO `area` VALUES ('34', '130104', '桥西区', '130100');
INSERT INTO `area` VALUES ('35', '130105', '新华区', '130100');
INSERT INTO `area` VALUES ('36', '130107', '井陉矿区', '130100');
INSERT INTO `area` VALUES ('37', '130108', '裕华区', '130100');
INSERT INTO `area` VALUES ('38', '130109', '藁城区', '130100');
INSERT INTO `area` VALUES ('39', '130110', '鹿泉区', '130100');
INSERT INTO `area` VALUES ('40', '130111', '栾城区', '130100');
INSERT INTO `area` VALUES ('41', '130121', '井陉县', '130100');
INSERT INTO `area` VALUES ('42', '130123', '正定县', '130100');
INSERT INTO `area` VALUES ('43', '130125', '行唐县', '130100');
INSERT INTO `area` VALUES ('44', '130126', '灵寿县', '130100');
INSERT INTO `area` VALUES ('45', '130127', '高邑县', '130100');
INSERT INTO `area` VALUES ('46', '130128', '深泽县', '130100');
INSERT INTO `area` VALUES ('47', '130129', '赞皇县', '130100');
INSERT INTO `area` VALUES ('48', '130130', '无极县', '130100');
INSERT INTO `area` VALUES ('49', '130131', '平山县', '130100');
INSERT INTO `area` VALUES ('50', '130132', '元氏县', '130100');
INSERT INTO `area` VALUES ('51', '130133', '赵县', '130100');
INSERT INTO `area` VALUES ('52', '130181', '辛集市', '130100');
INSERT INTO `area` VALUES ('53', '130183', '晋州市', '130100');
INSERT INTO `area` VALUES ('54', '130184', '新乐市', '130100');
INSERT INTO `area` VALUES ('55', '130202', '路南区', '130200');
INSERT INTO `area` VALUES ('56', '130203', '路北区', '130200');
INSERT INTO `area` VALUES ('57', '130204', '古冶区', '130200');
INSERT INTO `area` VALUES ('58', '130205', '开平区', '130200');
INSERT INTO `area` VALUES ('59', '130207', '丰南区', '130200');
INSERT INTO `area` VALUES ('60', '130208', '丰润区', '130200');
INSERT INTO `area` VALUES ('61', '130209', '曹妃甸区', '130200');
INSERT INTO `area` VALUES ('62', '130223', '滦县', '130200');
INSERT INTO `area` VALUES ('63', '130224', '滦南县', '130200');
INSERT INTO `area` VALUES ('64', '130225', '乐亭县', '130200');
INSERT INTO `area` VALUES ('65', '130227', '迁西县', '130200');
INSERT INTO `area` VALUES ('66', '130229', '玉田县', '130200');
INSERT INTO `area` VALUES ('67', '130281', '遵化市', '130200');
INSERT INTO `area` VALUES ('68', '130283', '迁安市', '130200');
INSERT INTO `area` VALUES ('69', '130302', '海港区', '130300');
INSERT INTO `area` VALUES ('70', '130303', '山海关区', '130300');
INSERT INTO `area` VALUES ('71', '130304', '北戴河区', '130300');
INSERT INTO `area` VALUES ('72', '130321', '青龙满族自治县', '130300');
INSERT INTO `area` VALUES ('73', '130322', '昌黎县', '130300');
INSERT INTO `area` VALUES ('74', '130323', '抚宁县', '130300');
INSERT INTO `area` VALUES ('75', '130324', '卢龙县', '130300');
INSERT INTO `area` VALUES ('76', '130402', '邯山区', '130400');
INSERT INTO `area` VALUES ('77', '130403', '丛台区', '130400');
INSERT INTO `area` VALUES ('78', '130404', '复兴区', '130400');
INSERT INTO `area` VALUES ('79', '130406', '峰峰矿区', '130400');
INSERT INTO `area` VALUES ('80', '130421', '邯郸县', '130400');
INSERT INTO `area` VALUES ('81', '130423', '临漳县', '130400');
INSERT INTO `area` VALUES ('82', '130424', '成安县', '130400');
INSERT INTO `area` VALUES ('83', '130425', '大名县', '130400');
INSERT INTO `area` VALUES ('84', '130426', '涉县', '130400');
INSERT INTO `area` VALUES ('85', '130427', '磁县', '130400');
INSERT INTO `area` VALUES ('86', '130428', '肥乡县', '130400');
INSERT INTO `area` VALUES ('87', '130429', '永年县', '130400');
INSERT INTO `area` VALUES ('88', '130430', '邱县', '130400');
INSERT INTO `area` VALUES ('89', '130431', '鸡泽县', '130400');
INSERT INTO `area` VALUES ('90', '130432', '广平县', '130400');
INSERT INTO `area` VALUES ('91', '130433', '馆陶县', '130400');
INSERT INTO `area` VALUES ('92', '130434', '魏县', '130400');
INSERT INTO `area` VALUES ('93', '130435', '曲周县', '130400');
INSERT INTO `area` VALUES ('94', '130481', '武安市', '130400');
INSERT INTO `area` VALUES ('95', '130502', '桥东区', '130500');
INSERT INTO `area` VALUES ('96', '130503', '桥西区', '130500');
INSERT INTO `area` VALUES ('97', '130521', '邢台县', '130500');
INSERT INTO `area` VALUES ('98', '130522', '临城县', '130500');
INSERT INTO `area` VALUES ('99', '130523', '内丘县', '130500');
INSERT INTO `area` VALUES ('100', '130524', '柏乡县', '130500');
INSERT INTO `area` VALUES ('101', '130525', '隆尧县', '130500');
INSERT INTO `area` VALUES ('102', '130526', '任县', '130500');
INSERT INTO `area` VALUES ('103', '130527', '南和县', '130500');
INSERT INTO `area` VALUES ('104', '130528', '宁晋县', '130500');
INSERT INTO `area` VALUES ('105', '130529', '巨鹿县', '130500');
INSERT INTO `area` VALUES ('106', '130530', '新河县', '130500');
INSERT INTO `area` VALUES ('107', '130531', '广宗县', '130500');
INSERT INTO `area` VALUES ('108', '130532', '平乡县', '130500');
INSERT INTO `area` VALUES ('109', '130533', '威县', '130500');
INSERT INTO `area` VALUES ('110', '130534', '清河县', '130500');
INSERT INTO `area` VALUES ('111', '130535', '临西县', '130500');
INSERT INTO `area` VALUES ('112', '130581', '南宫市', '130500');
INSERT INTO `area` VALUES ('113', '130582', '沙河市', '130500');
INSERT INTO `area` VALUES ('114', '130602', '新市区', '130600');
INSERT INTO `area` VALUES ('115', '130603', '北市区', '130600');
INSERT INTO `area` VALUES ('116', '130604', '南市区', '130600');
INSERT INTO `area` VALUES ('117', '130621', '满城县', '130600');
INSERT INTO `area` VALUES ('118', '130622', '清苑县', '130600');
INSERT INTO `area` VALUES ('119', '130623', '涞水县', '130600');
INSERT INTO `area` VALUES ('120', '130624', '阜平县', '130600');
INSERT INTO `area` VALUES ('121', '130625', '徐水县', '130600');
INSERT INTO `area` VALUES ('122', '130626', '定兴县', '130600');
INSERT INTO `area` VALUES ('123', '130627', '唐县', '130600');
INSERT INTO `area` VALUES ('124', '130628', '高阳县', '130600');
INSERT INTO `area` VALUES ('125', '130629', '容城县', '130600');
INSERT INTO `area` VALUES ('126', '130630', '涞源县', '130600');
INSERT INTO `area` VALUES ('127', '130631', '望都县', '130600');
INSERT INTO `area` VALUES ('128', '130632', '安新县', '130600');
INSERT INTO `area` VALUES ('129', '130633', '易县', '130600');
INSERT INTO `area` VALUES ('130', '130634', '曲阳县', '130600');
INSERT INTO `area` VALUES ('131', '130635', '蠡县', '130600');
INSERT INTO `area` VALUES ('132', '130636', '顺平县', '130600');
INSERT INTO `area` VALUES ('133', '130637', '博野县', '130600');
INSERT INTO `area` VALUES ('134', '130638', '雄县', '130600');
INSERT INTO `area` VALUES ('135', '130681', '涿州市', '130600');
INSERT INTO `area` VALUES ('136', '130682', '定州市', '130600');
INSERT INTO `area` VALUES ('137', '130683', '安国市', '130600');
INSERT INTO `area` VALUES ('138', '130684', '高碑店市', '130600');
INSERT INTO `area` VALUES ('139', '130702', '桥东区', '130700');
INSERT INTO `area` VALUES ('140', '130703', '桥西区', '130700');
INSERT INTO `area` VALUES ('141', '130705', '宣化区', '130700');
INSERT INTO `area` VALUES ('142', '130706', '下花园区', '130700');
INSERT INTO `area` VALUES ('143', '130721', '宣化县', '130700');
INSERT INTO `area` VALUES ('144', '130722', '张北县', '130700');
INSERT INTO `area` VALUES ('145', '130723', '康保县', '130700');
INSERT INTO `area` VALUES ('146', '130724', '沽源县', '130700');
INSERT INTO `area` VALUES ('147', '130725', '尚义县', '130700');
INSERT INTO `area` VALUES ('148', '130726', '蔚县', '130700');
INSERT INTO `area` VALUES ('149', '130727', '阳原县', '130700');
INSERT INTO `area` VALUES ('150', '130728', '怀安县', '130700');
INSERT INTO `area` VALUES ('151', '130729', '万全县', '130700');
INSERT INTO `area` VALUES ('152', '130730', '怀来县', '130700');
INSERT INTO `area` VALUES ('153', '130731', '涿鹿县', '130700');
INSERT INTO `area` VALUES ('154', '130732', '赤城县', '130700');
INSERT INTO `area` VALUES ('155', '130733', '崇礼县', '130700');
INSERT INTO `area` VALUES ('156', '130802', '双桥区', '130800');
INSERT INTO `area` VALUES ('157', '130803', '双滦区', '130800');
INSERT INTO `area` VALUES ('158', '130804', '鹰手营子矿区', '130800');
INSERT INTO `area` VALUES ('159', '130821', '承德县', '130800');
INSERT INTO `area` VALUES ('160', '130822', '兴隆县', '130800');
INSERT INTO `area` VALUES ('161', '130823', '平泉县', '130800');
INSERT INTO `area` VALUES ('162', '130824', '滦平县', '130800');
INSERT INTO `area` VALUES ('163', '130825', '隆化县', '130800');
INSERT INTO `area` VALUES ('164', '130826', '丰宁满族自治县', '130800');
INSERT INTO `area` VALUES ('165', '130827', '宽城满族自治县', '130800');
INSERT INTO `area` VALUES ('166', '130828', '围场满族蒙古族自治县', '130800');
INSERT INTO `area` VALUES ('167', '130902', '新华区', '130900');
INSERT INTO `area` VALUES ('168', '130903', '运河区', '130900');
INSERT INTO `area` VALUES ('169', '130921', '沧县', '130900');
INSERT INTO `area` VALUES ('170', '130922', '青县', '130900');
INSERT INTO `area` VALUES ('171', '130923', '东光县', '130900');
INSERT INTO `area` VALUES ('172', '130924', '海兴县', '130900');
INSERT INTO `area` VALUES ('173', '130925', '盐山县', '130900');
INSERT INTO `area` VALUES ('174', '130926', '肃宁县', '130900');
INSERT INTO `area` VALUES ('175', '130927', '南皮县', '130900');
INSERT INTO `area` VALUES ('176', '130928', '吴桥县', '130900');
INSERT INTO `area` VALUES ('177', '130929', '献县', '130900');
INSERT INTO `area` VALUES ('178', '130930', '孟村回族自治县', '130900');
INSERT INTO `area` VALUES ('179', '130981', '泊头市', '130900');
INSERT INTO `area` VALUES ('180', '130982', '任丘市', '130900');
INSERT INTO `area` VALUES ('181', '130983', '黄骅市', '130900');
INSERT INTO `area` VALUES ('182', '130984', '河间市', '130900');
INSERT INTO `area` VALUES ('183', '131002', '安次区', '131000');
INSERT INTO `area` VALUES ('184', '131003', '广阳区', '131000');
INSERT INTO `area` VALUES ('185', '131022', '固安县', '131000');
INSERT INTO `area` VALUES ('186', '131023', '永清县', '131000');
INSERT INTO `area` VALUES ('187', '131024', '香河县', '131000');
INSERT INTO `area` VALUES ('188', '131025', '大城县', '131000');
INSERT INTO `area` VALUES ('189', '131026', '文安县', '131000');
INSERT INTO `area` VALUES ('190', '131028', '大厂回族自治县', '131000');
INSERT INTO `area` VALUES ('191', '131081', '霸州市', '131000');
INSERT INTO `area` VALUES ('192', '131082', '三河市', '131000');
INSERT INTO `area` VALUES ('193', '131102', '桃城区', '131100');
INSERT INTO `area` VALUES ('194', '131121', '枣强县', '131100');
INSERT INTO `area` VALUES ('195', '131122', '武邑县', '131100');
INSERT INTO `area` VALUES ('196', '131123', '武强县', '131100');
INSERT INTO `area` VALUES ('197', '131124', '饶阳县', '131100');
INSERT INTO `area` VALUES ('198', '131125', '安平县', '131100');
INSERT INTO `area` VALUES ('199', '131126', '故城县', '131100');
INSERT INTO `area` VALUES ('200', '131127', '景县', '131100');
INSERT INTO `area` VALUES ('201', '131128', '阜城县', '131100');
INSERT INTO `area` VALUES ('202', '131181', '冀州市', '131100');
INSERT INTO `area` VALUES ('203', '131182', '深州市', '131100');
INSERT INTO `area` VALUES ('204', '140105', '小店区', '140100');
INSERT INTO `area` VALUES ('205', '140106', '迎泽区', '140100');
INSERT INTO `area` VALUES ('206', '140107', '杏花岭区', '140100');
INSERT INTO `area` VALUES ('207', '140108', '尖草坪区', '140100');
INSERT INTO `area` VALUES ('208', '140109', '万柏林区', '140100');
INSERT INTO `area` VALUES ('209', '140110', '晋源区', '140100');
INSERT INTO `area` VALUES ('210', '140121', '清徐县', '140100');
INSERT INTO `area` VALUES ('211', '140122', '阳曲县', '140100');
INSERT INTO `area` VALUES ('212', '140123', '娄烦县', '140100');
INSERT INTO `area` VALUES ('213', '140181', '古交市', '140100');
INSERT INTO `area` VALUES ('214', '140202', '城区', '140200');
INSERT INTO `area` VALUES ('215', '140203', '矿区', '140200');
INSERT INTO `area` VALUES ('216', '140211', '南郊区', '140200');
INSERT INTO `area` VALUES ('217', '140212', '新荣区', '140200');
INSERT INTO `area` VALUES ('218', '140221', '阳高县', '140200');
INSERT INTO `area` VALUES ('219', '140222', '天镇县', '140200');
INSERT INTO `area` VALUES ('220', '140223', '广灵县', '140200');
INSERT INTO `area` VALUES ('221', '140224', '灵丘县', '140200');
INSERT INTO `area` VALUES ('222', '140225', '浑源县', '140200');
INSERT INTO `area` VALUES ('223', '140226', '左云县', '140200');
INSERT INTO `area` VALUES ('224', '140227', '大同县', '140200');
INSERT INTO `area` VALUES ('225', '140302', '城区', '140300');
INSERT INTO `area` VALUES ('226', '140303', '矿区', '140300');
INSERT INTO `area` VALUES ('227', '140311', '郊区', '140300');
INSERT INTO `area` VALUES ('228', '140321', '平定县', '140300');
INSERT INTO `area` VALUES ('229', '140322', '盂县', '140300');
INSERT INTO `area` VALUES ('230', '140402', '城区', '140400');
INSERT INTO `area` VALUES ('231', '140411', '郊区', '140400');
INSERT INTO `area` VALUES ('232', '140421', '长治县', '140400');
INSERT INTO `area` VALUES ('233', '140423', '襄垣县', '140400');
INSERT INTO `area` VALUES ('234', '140424', '屯留县', '140400');
INSERT INTO `area` VALUES ('235', '140425', '平顺县', '140400');
INSERT INTO `area` VALUES ('236', '140426', '黎城县', '140400');
INSERT INTO `area` VALUES ('237', '140427', '壶关县', '140400');
INSERT INTO `area` VALUES ('238', '140428', '长子县', '140400');
INSERT INTO `area` VALUES ('239', '140429', '武乡县', '140400');
INSERT INTO `area` VALUES ('240', '140430', '沁县', '140400');
INSERT INTO `area` VALUES ('241', '140431', '沁源县', '140400');
INSERT INTO `area` VALUES ('242', '140481', '潞城市', '140400');
INSERT INTO `area` VALUES ('243', '140502', '城区', '140500');
INSERT INTO `area` VALUES ('244', '140521', '沁水县', '140500');
INSERT INTO `area` VALUES ('245', '140522', '阳城县', '140500');
INSERT INTO `area` VALUES ('246', '140524', '陵川县', '140500');
INSERT INTO `area` VALUES ('247', '140525', '泽州县', '140500');
INSERT INTO `area` VALUES ('248', '140581', '高平市', '140500');
INSERT INTO `area` VALUES ('249', '140602', '朔城区', '140600');
INSERT INTO `area` VALUES ('250', '140603', '平鲁区', '140600');
INSERT INTO `area` VALUES ('251', '140621', '山阴县', '140600');
INSERT INTO `area` VALUES ('252', '140622', '应县', '140600');
INSERT INTO `area` VALUES ('253', '140623', '右玉县', '140600');
INSERT INTO `area` VALUES ('254', '140624', '怀仁县', '140600');
INSERT INTO `area` VALUES ('255', '140702', '榆次区', '140700');
INSERT INTO `area` VALUES ('256', '140721', '榆社县', '140700');
INSERT INTO `area` VALUES ('257', '140722', '左权县', '140700');
INSERT INTO `area` VALUES ('258', '140723', '和顺县', '140700');
INSERT INTO `area` VALUES ('259', '140724', '昔阳县', '140700');
INSERT INTO `area` VALUES ('260', '140725', '寿阳县', '140700');
INSERT INTO `area` VALUES ('261', '140726', '太谷县', '140700');
INSERT INTO `area` VALUES ('262', '140727', '祁县', '140700');
INSERT INTO `area` VALUES ('263', '140728', '平遥县', '140700');
INSERT INTO `area` VALUES ('264', '140729', '灵石县', '140700');
INSERT INTO `area` VALUES ('265', '140781', '介休市', '140700');
INSERT INTO `area` VALUES ('266', '140802', '盐湖区', '140800');
INSERT INTO `area` VALUES ('267', '140821', '临猗县', '140800');
INSERT INTO `area` VALUES ('268', '140822', '万荣县', '140800');
INSERT INTO `area` VALUES ('269', '140823', '闻喜县', '140800');
INSERT INTO `area` VALUES ('270', '140824', '稷山县', '140800');
INSERT INTO `area` VALUES ('271', '140825', '新绛县', '140800');
INSERT INTO `area` VALUES ('272', '140826', '绛县', '140800');
INSERT INTO `area` VALUES ('273', '140827', '垣曲县', '140800');
INSERT INTO `area` VALUES ('274', '140828', '夏县', '140800');
INSERT INTO `area` VALUES ('275', '140829', '平陆县', '140800');
INSERT INTO `area` VALUES ('276', '140830', '芮城县', '140800');
INSERT INTO `area` VALUES ('277', '140881', '永济市', '140800');
INSERT INTO `area` VALUES ('278', '140882', '河津市', '140800');
INSERT INTO `area` VALUES ('279', '140902', '忻府区', '140900');
INSERT INTO `area` VALUES ('280', '140921', '定襄县', '140900');
INSERT INTO `area` VALUES ('281', '140922', '五台县', '140900');
INSERT INTO `area` VALUES ('282', '140923', '代县', '140900');
INSERT INTO `area` VALUES ('283', '140924', '繁峙县', '140900');
INSERT INTO `area` VALUES ('284', '140925', '宁武县', '140900');
INSERT INTO `area` VALUES ('285', '140926', '静乐县', '140900');
INSERT INTO `area` VALUES ('286', '140927', '神池县', '140900');
INSERT INTO `area` VALUES ('287', '140928', '五寨县', '140900');
INSERT INTO `area` VALUES ('288', '140929', '岢岚县', '140900');
INSERT INTO `area` VALUES ('289', '140930', '河曲县', '140900');
INSERT INTO `area` VALUES ('290', '140931', '保德县', '140900');
INSERT INTO `area` VALUES ('291', '140932', '偏关县', '140900');
INSERT INTO `area` VALUES ('292', '140981', '原平市', '140900');
INSERT INTO `area` VALUES ('293', '141002', '尧都区', '141000');
INSERT INTO `area` VALUES ('294', '141021', '曲沃县', '141000');
INSERT INTO `area` VALUES ('295', '141022', '翼城县', '141000');
INSERT INTO `area` VALUES ('296', '141023', '襄汾县', '141000');
INSERT INTO `area` VALUES ('297', '141024', '洪洞县', '141000');
INSERT INTO `area` VALUES ('298', '141025', '古县', '141000');
INSERT INTO `area` VALUES ('299', '141026', '安泽县', '141000');
INSERT INTO `area` VALUES ('300', '141027', '浮山县', '141000');
INSERT INTO `area` VALUES ('301', '141028', '吉县', '141000');
INSERT INTO `area` VALUES ('302', '141029', '乡宁县', '141000');
INSERT INTO `area` VALUES ('303', '141030', '大宁县', '141000');
INSERT INTO `area` VALUES ('304', '141031', '隰县', '141000');
INSERT INTO `area` VALUES ('305', '141032', '永和县', '141000');
INSERT INTO `area` VALUES ('306', '141033', '蒲县', '141000');
INSERT INTO `area` VALUES ('307', '141034', '汾西县', '141000');
INSERT INTO `area` VALUES ('308', '141081', '侯马市', '141000');
INSERT INTO `area` VALUES ('309', '141082', '霍州市', '141000');
INSERT INTO `area` VALUES ('310', '141102', '离石区', '141100');
INSERT INTO `area` VALUES ('311', '141121', '文水县', '141100');
INSERT INTO `area` VALUES ('312', '141122', '交城县', '141100');
INSERT INTO `area` VALUES ('313', '141123', '兴县', '141100');
INSERT INTO `area` VALUES ('314', '141124', '临县', '141100');
INSERT INTO `area` VALUES ('315', '141125', '柳林县', '141100');
INSERT INTO `area` VALUES ('316', '141126', '石楼县', '141100');
INSERT INTO `area` VALUES ('317', '141127', '岚县', '141100');
INSERT INTO `area` VALUES ('318', '141128', '方山县', '141100');
INSERT INTO `area` VALUES ('319', '141129', '中阳县', '141100');
INSERT INTO `area` VALUES ('320', '141130', '交口县', '141100');
INSERT INTO `area` VALUES ('321', '141181', '孝义市', '141100');
INSERT INTO `area` VALUES ('322', '141182', '汾阳市', '141100');
INSERT INTO `area` VALUES ('323', '150102', '新城区', '150100');
INSERT INTO `area` VALUES ('324', '150103', '回民区', '150100');
INSERT INTO `area` VALUES ('325', '150104', '玉泉区', '150100');
INSERT INTO `area` VALUES ('326', '150105', '赛罕区', '150100');
INSERT INTO `area` VALUES ('327', '150121', '土默特左旗', '150100');
INSERT INTO `area` VALUES ('328', '150122', '托克托县', '150100');
INSERT INTO `area` VALUES ('329', '150123', '和林格尔县', '150100');
INSERT INTO `area` VALUES ('330', '150124', '清水河县', '150100');
INSERT INTO `area` VALUES ('331', '150125', '武川县', '150100');
INSERT INTO `area` VALUES ('332', '150202', '东河区', '150200');
INSERT INTO `area` VALUES ('333', '150203', '昆都仑区', '150200');
INSERT INTO `area` VALUES ('334', '150204', '青山区', '150200');
INSERT INTO `area` VALUES ('335', '150205', '石拐区', '150200');
INSERT INTO `area` VALUES ('336', '150206', '白云鄂博矿区', '150200');
INSERT INTO `area` VALUES ('337', '150207', '九原区', '150200');
INSERT INTO `area` VALUES ('338', '150221', '土默特右旗', '150200');
INSERT INTO `area` VALUES ('339', '150222', '固阳县', '150200');
INSERT INTO `area` VALUES ('340', '150223', '达尔罕茂明安联合旗', '150200');
INSERT INTO `area` VALUES ('341', '150302', '海勃湾区', '150300');
INSERT INTO `area` VALUES ('342', '150303', '海南区', '150300');
INSERT INTO `area` VALUES ('343', '150304', '乌达区', '150300');
INSERT INTO `area` VALUES ('344', '150402', '红山区', '150400');
INSERT INTO `area` VALUES ('345', '150403', '元宝山区', '150400');
INSERT INTO `area` VALUES ('346', '150404', '松山区', '150400');
INSERT INTO `area` VALUES ('347', '150421', '阿鲁科尔沁旗', '150400');
INSERT INTO `area` VALUES ('348', '150422', '巴林左旗', '150400');
INSERT INTO `area` VALUES ('349', '150423', '巴林右旗', '150400');
INSERT INTO `area` VALUES ('350', '150424', '林西县', '150400');
INSERT INTO `area` VALUES ('351', '150425', '克什克腾旗', '150400');
INSERT INTO `area` VALUES ('352', '150426', '翁牛特旗', '150400');
INSERT INTO `area` VALUES ('353', '150428', '喀喇沁旗', '150400');
INSERT INTO `area` VALUES ('354', '150429', '宁城县', '150400');
INSERT INTO `area` VALUES ('355', '150430', '敖汉旗', '150400');
INSERT INTO `area` VALUES ('356', '150502', '科尔沁区', '150500');
INSERT INTO `area` VALUES ('357', '150521', '科尔沁左翼中旗', '150500');
INSERT INTO `area` VALUES ('358', '150522', '科尔沁左翼后旗', '150500');
INSERT INTO `area` VALUES ('359', '150523', '开鲁县', '150500');
INSERT INTO `area` VALUES ('360', '150524', '库伦旗', '150500');
INSERT INTO `area` VALUES ('361', '150525', '奈曼旗', '150500');
INSERT INTO `area` VALUES ('362', '150526', '扎鲁特旗', '150500');
INSERT INTO `area` VALUES ('363', '150581', '霍林郭勒市', '150500');
INSERT INTO `area` VALUES ('364', '150602', '东胜区', '150600');
INSERT INTO `area` VALUES ('365', '150621', '达拉特旗', '150600');
INSERT INTO `area` VALUES ('366', '150622', '准格尔旗', '150600');
INSERT INTO `area` VALUES ('367', '150623', '鄂托克前旗', '150600');
INSERT INTO `area` VALUES ('368', '150624', '鄂托克旗', '150600');
INSERT INTO `area` VALUES ('369', '150625', '杭锦旗', '150600');
INSERT INTO `area` VALUES ('370', '150626', '乌审旗', '150600');
INSERT INTO `area` VALUES ('371', '150627', '伊金霍洛旗', '150600');
INSERT INTO `area` VALUES ('372', '150702', '海拉尔区', '150700');
INSERT INTO `area` VALUES ('373', '150703', '扎赉诺尔区', '150700');
INSERT INTO `area` VALUES ('374', '150721', '阿荣旗', '150700');
INSERT INTO `area` VALUES ('375', '150722', '莫力达瓦达斡尔族自治旗', '150700');
INSERT INTO `area` VALUES ('376', '150723', '鄂伦春自治旗', '150700');
INSERT INTO `area` VALUES ('377', '150724', '鄂温克族自治旗', '150700');
INSERT INTO `area` VALUES ('378', '150725', '陈巴尔虎旗', '150700');
INSERT INTO `area` VALUES ('379', '150726', '新巴尔虎左旗', '150700');
INSERT INTO `area` VALUES ('380', '150727', '新巴尔虎右旗', '150700');
INSERT INTO `area` VALUES ('381', '150781', '满洲里市', '150700');
INSERT INTO `area` VALUES ('382', '150782', '牙克石市', '150700');
INSERT INTO `area` VALUES ('383', '150783', '扎兰屯市', '150700');
INSERT INTO `area` VALUES ('384', '150784', '额尔古纳市', '150700');
INSERT INTO `area` VALUES ('385', '150785', '根河市', '150700');
INSERT INTO `area` VALUES ('386', '150802', '临河区', '150800');
INSERT INTO `area` VALUES ('387', '150821', '五原县', '150800');
INSERT INTO `area` VALUES ('388', '150822', '磴口县', '150800');
INSERT INTO `area` VALUES ('389', '150823', '乌拉特前旗', '150800');
INSERT INTO `area` VALUES ('390', '150824', '乌拉特中旗', '150800');
INSERT INTO `area` VALUES ('391', '150825', '乌拉特后旗', '150800');
INSERT INTO `area` VALUES ('392', '150826', '杭锦后旗', '150800');
INSERT INTO `area` VALUES ('393', '150902', '集宁区', '150900');
INSERT INTO `area` VALUES ('394', '150921', '卓资县', '150900');
INSERT INTO `area` VALUES ('395', '150922', '化德县', '150900');
INSERT INTO `area` VALUES ('396', '150923', '商都县', '150900');
INSERT INTO `area` VALUES ('397', '150924', '兴和县', '150900');
INSERT INTO `area` VALUES ('398', '150925', '凉城县', '150900');
INSERT INTO `area` VALUES ('399', '150926', '察哈尔右翼前旗', '150900');
INSERT INTO `area` VALUES ('400', '150927', '察哈尔右翼中旗', '150900');
INSERT INTO `area` VALUES ('401', '150928', '察哈尔右翼后旗', '150900');
INSERT INTO `area` VALUES ('402', '150929', '四子王旗', '150900');
INSERT INTO `area` VALUES ('403', '150981', '丰镇市', '150900');
INSERT INTO `area` VALUES ('404', '152201', '乌兰浩特市', '152200');
INSERT INTO `area` VALUES ('405', '152202', '阿尔山市', '152200');
INSERT INTO `area` VALUES ('406', '152221', '科尔沁右翼前旗', '152200');
INSERT INTO `area` VALUES ('407', '152222', '科尔沁右翼中旗', '152200');
INSERT INTO `area` VALUES ('408', '152223', '扎赉特旗', '152200');
INSERT INTO `area` VALUES ('409', '152224', '突泉县', '152200');
INSERT INTO `area` VALUES ('410', '152501', '二连浩特市', '152500');
INSERT INTO `area` VALUES ('411', '152502', '锡林浩特市', '152500');
INSERT INTO `area` VALUES ('412', '152522', '阿巴嘎旗', '152500');
INSERT INTO `area` VALUES ('413', '152523', '苏尼特左旗', '152500');
INSERT INTO `area` VALUES ('414', '152524', '苏尼特右旗', '152500');
INSERT INTO `area` VALUES ('415', '152525', '东乌珠穆沁旗', '152500');
INSERT INTO `area` VALUES ('416', '152526', '西乌珠穆沁旗', '152500');
INSERT INTO `area` VALUES ('417', '152527', '太仆寺旗', '152500');
INSERT INTO `area` VALUES ('418', '152528', '镶黄旗', '152500');
INSERT INTO `area` VALUES ('419', '152529', '正镶白旗', '152500');
INSERT INTO `area` VALUES ('420', '152530', '正蓝旗', '152500');
INSERT INTO `area` VALUES ('421', '152531', '多伦县', '152500');
INSERT INTO `area` VALUES ('422', '152921', '阿拉善左旗', '152900');
INSERT INTO `area` VALUES ('423', '152922', '阿拉善右旗', '152900');
INSERT INTO `area` VALUES ('424', '152923', '额济纳旗', '152900');
INSERT INTO `area` VALUES ('425', '210102', '和平区', '210100');
INSERT INTO `area` VALUES ('426', '210103', '沈河区', '210100');
INSERT INTO `area` VALUES ('427', '210104', '大东区', '210100');
INSERT INTO `area` VALUES ('428', '210105', '皇姑区', '210100');
INSERT INTO `area` VALUES ('429', '210106', '铁西区', '210100');
INSERT INTO `area` VALUES ('430', '210111', '苏家屯区', '210100');
INSERT INTO `area` VALUES ('431', '210112', '浑南区', '210100');
INSERT INTO `area` VALUES ('432', '210113', '沈北新区', '210100');
INSERT INTO `area` VALUES ('433', '210114', '于洪区', '210100');
INSERT INTO `area` VALUES ('434', '210122', '辽中县', '210100');
INSERT INTO `area` VALUES ('435', '210123', '康平县', '210100');
INSERT INTO `area` VALUES ('436', '210124', '法库县', '210100');
INSERT INTO `area` VALUES ('437', '210181', '新民市', '210100');
INSERT INTO `area` VALUES ('438', '210202', '中山区', '210200');
INSERT INTO `area` VALUES ('439', '210203', '西岗区', '210200');
INSERT INTO `area` VALUES ('440', '210204', '沙河口区', '210200');
INSERT INTO `area` VALUES ('441', '210211', '甘井子区', '210200');
INSERT INTO `area` VALUES ('442', '210212', '旅顺口区', '210200');
INSERT INTO `area` VALUES ('443', '210213', '金州区', '210200');
INSERT INTO `area` VALUES ('444', '210224', '长海县', '210200');
INSERT INTO `area` VALUES ('445', '210281', '瓦房店市', '210200');
INSERT INTO `area` VALUES ('446', '210282', '普兰店市', '210200');
INSERT INTO `area` VALUES ('447', '210283', '庄河市', '210200');
INSERT INTO `area` VALUES ('448', '210302', '铁东区', '210300');
INSERT INTO `area` VALUES ('449', '210303', '铁西区', '210300');
INSERT INTO `area` VALUES ('450', '210304', '立山区', '210300');
INSERT INTO `area` VALUES ('451', '210311', '千山区', '210300');
INSERT INTO `area` VALUES ('452', '210321', '台安县', '210300');
INSERT INTO `area` VALUES ('453', '210323', '岫岩满族自治县', '210300');
INSERT INTO `area` VALUES ('454', '210381', '海城市', '210300');
INSERT INTO `area` VALUES ('455', '210402', '新抚区', '210400');
INSERT INTO `area` VALUES ('456', '210403', '东洲区', '210400');
INSERT INTO `area` VALUES ('457', '210404', '望花区', '210400');
INSERT INTO `area` VALUES ('458', '210411', '顺城区', '210400');
INSERT INTO `area` VALUES ('459', '210421', '抚顺县', '210400');
INSERT INTO `area` VALUES ('460', '210422', '新宾满族自治县', '210400');
INSERT INTO `area` VALUES ('461', '210423', '清原满族自治县', '210400');
INSERT INTO `area` VALUES ('462', '210502', '平山区', '210500');
INSERT INTO `area` VALUES ('463', '210503', '溪湖区', '210500');
INSERT INTO `area` VALUES ('464', '210504', '明山区', '210500');
INSERT INTO `area` VALUES ('465', '210505', '南芬区', '210500');
INSERT INTO `area` VALUES ('466', '210521', '本溪满族自治县', '210500');
INSERT INTO `area` VALUES ('467', '210522', '桓仁满族自治县', '210500');
INSERT INTO `area` VALUES ('468', '210602', '元宝区', '210600');
INSERT INTO `area` VALUES ('469', '210603', '振兴区', '210600');
INSERT INTO `area` VALUES ('470', '210604', '振安区', '210600');
INSERT INTO `area` VALUES ('471', '210624', '宽甸满族自治县', '210600');
INSERT INTO `area` VALUES ('472', '210681', '东港市', '210600');
INSERT INTO `area` VALUES ('473', '210682', '凤城市', '210600');
INSERT INTO `area` VALUES ('474', '210702', '古塔区', '210700');
INSERT INTO `area` VALUES ('475', '210703', '凌河区', '210700');
INSERT INTO `area` VALUES ('476', '210711', '太和区', '210700');
INSERT INTO `area` VALUES ('477', '210726', '黑山县', '210700');
INSERT INTO `area` VALUES ('478', '210727', '义县', '210700');
INSERT INTO `area` VALUES ('479', '210781', '凌海市', '210700');
INSERT INTO `area` VALUES ('480', '210782', '北镇市', '210700');
INSERT INTO `area` VALUES ('481', '210802', '站前区', '210800');
INSERT INTO `area` VALUES ('482', '210803', '西市区', '210800');
INSERT INTO `area` VALUES ('483', '210804', '鲅鱼圈区', '210800');
INSERT INTO `area` VALUES ('484', '210811', '老边区', '210800');
INSERT INTO `area` VALUES ('485', '210881', '盖州市', '210800');
INSERT INTO `area` VALUES ('486', '210882', '大石桥市', '210800');
INSERT INTO `area` VALUES ('487', '210902', '海州区', '210900');
INSERT INTO `area` VALUES ('488', '210903', '新邱区', '210900');
INSERT INTO `area` VALUES ('489', '210904', '太平区', '210900');
INSERT INTO `area` VALUES ('490', '210905', '清河门区', '210900');
INSERT INTO `area` VALUES ('491', '210911', '细河区', '210900');
INSERT INTO `area` VALUES ('492', '210921', '阜新蒙古族自治县', '210900');
INSERT INTO `area` VALUES ('493', '210922', '彰武县', '210900');
INSERT INTO `area` VALUES ('494', '211002', '白塔区', '211000');
INSERT INTO `area` VALUES ('495', '211003', '文圣区', '211000');
INSERT INTO `area` VALUES ('496', '211004', '宏伟区', '211000');
INSERT INTO `area` VALUES ('497', '211005', '弓长岭区', '211000');
INSERT INTO `area` VALUES ('498', '211011', '太子河区', '211000');
INSERT INTO `area` VALUES ('499', '211021', '辽阳县', '211000');
INSERT INTO `area` VALUES ('500', '211081', '灯塔市', '211000');
INSERT INTO `area` VALUES ('501', '211102', '双台子区', '211100');
INSERT INTO `area` VALUES ('502', '211103', '兴隆台区', '211100');
INSERT INTO `area` VALUES ('503', '211121', '大洼县', '211100');
INSERT INTO `area` VALUES ('504', '211122', '盘山县', '211100');
INSERT INTO `area` VALUES ('505', '211202', '银州区', '211200');
INSERT INTO `area` VALUES ('506', '211204', '清河区', '211200');
INSERT INTO `area` VALUES ('507', '211221', '铁岭县', '211200');
INSERT INTO `area` VALUES ('508', '211223', '西丰县', '211200');
INSERT INTO `area` VALUES ('509', '211224', '昌图县', '211200');
INSERT INTO `area` VALUES ('510', '211281', '调兵山市', '211200');
INSERT INTO `area` VALUES ('511', '211282', '开原市', '211200');
INSERT INTO `area` VALUES ('512', '211302', '双塔区', '211300');
INSERT INTO `area` VALUES ('513', '211303', '龙城区', '211300');
INSERT INTO `area` VALUES ('514', '211321', '朝阳县', '211300');
INSERT INTO `area` VALUES ('515', '211322', '建平县', '211300');
INSERT INTO `area` VALUES ('516', '211324', '喀喇沁左翼蒙古族自治县', '211300');
INSERT INTO `area` VALUES ('517', '211381', '北票市', '211300');
INSERT INTO `area` VALUES ('518', '211382', '凌源市', '211300');
INSERT INTO `area` VALUES ('519', '211402', '连山区', '211400');
INSERT INTO `area` VALUES ('520', '211403', '龙港区', '211400');
INSERT INTO `area` VALUES ('521', '211404', '南票区', '211400');
INSERT INTO `area` VALUES ('522', '211421', '绥中县', '211400');
INSERT INTO `area` VALUES ('523', '211422', '建昌县', '211400');
INSERT INTO `area` VALUES ('524', '211481', '兴城市', '211400');
INSERT INTO `area` VALUES ('525', '211501', '金州新区', '211500');
INSERT INTO `area` VALUES ('526', '211502', '普湾新区', '211500');
INSERT INTO `area` VALUES ('527', '211503', '保税区', '211500');
INSERT INTO `area` VALUES ('528', '220102', '南关区', '220100');
INSERT INTO `area` VALUES ('529', '220103', '宽城区', '220100');
INSERT INTO `area` VALUES ('530', '220104', '朝阳区', '220100');
INSERT INTO `area` VALUES ('531', '220105', '二道区', '220100');
INSERT INTO `area` VALUES ('532', '220106', '绿园区', '220100');
INSERT INTO `area` VALUES ('533', '220112', '双阳区', '220100');
INSERT INTO `area` VALUES ('534', '220113', '九台区', '220100');
INSERT INTO `area` VALUES ('535', '220122', '农安县', '220100');
INSERT INTO `area` VALUES ('536', '220182', '榆树市', '220100');
INSERT INTO `area` VALUES ('537', '220183', '德惠市', '220100');
INSERT INTO `area` VALUES ('538', '220202', '昌邑区', '220200');
INSERT INTO `area` VALUES ('539', '220203', '龙潭区', '220200');
INSERT INTO `area` VALUES ('540', '220204', '船营区', '220200');
INSERT INTO `area` VALUES ('541', '220211', '丰满区', '220200');
INSERT INTO `area` VALUES ('542', '220221', '永吉县', '220200');
INSERT INTO `area` VALUES ('543', '220281', '蛟河市', '220200');
INSERT INTO `area` VALUES ('544', '220282', '桦甸市', '220200');
INSERT INTO `area` VALUES ('545', '220283', '舒兰市', '220200');
INSERT INTO `area` VALUES ('546', '220284', '磐石市', '220200');
INSERT INTO `area` VALUES ('547', '220302', '铁西区', '220300');
INSERT INTO `area` VALUES ('548', '220303', '铁东区', '220300');
INSERT INTO `area` VALUES ('549', '220322', '梨树县', '220300');
INSERT INTO `area` VALUES ('550', '220323', '伊通满族自治县', '220300');
INSERT INTO `area` VALUES ('551', '220381', '公主岭市', '220300');
INSERT INTO `area` VALUES ('552', '220382', '双辽市', '220300');
INSERT INTO `area` VALUES ('553', '220402', '龙山区', '220400');
INSERT INTO `area` VALUES ('554', '220403', '西安区', '220400');
INSERT INTO `area` VALUES ('555', '220421', '东丰县', '220400');
INSERT INTO `area` VALUES ('556', '220422', '东辽县', '220400');
INSERT INTO `area` VALUES ('557', '220502', '东昌区', '220500');
INSERT INTO `area` VALUES ('558', '220503', '二道江区', '220500');
INSERT INTO `area` VALUES ('559', '220521', '通化县', '220500');
INSERT INTO `area` VALUES ('560', '220523', '辉南县', '220500');
INSERT INTO `area` VALUES ('561', '220524', '柳河县', '220500');
INSERT INTO `area` VALUES ('562', '220581', '梅河口市', '220500');
INSERT INTO `area` VALUES ('563', '220582', '集安市', '220500');
INSERT INTO `area` VALUES ('564', '220602', '浑江区', '220600');
INSERT INTO `area` VALUES ('565', '220605', '江源区', '220600');
INSERT INTO `area` VALUES ('566', '220621', '抚松县', '220600');
INSERT INTO `area` VALUES ('567', '220622', '靖宇县', '220600');
INSERT INTO `area` VALUES ('568', '220623', '长白朝鲜族自治县', '220600');
INSERT INTO `area` VALUES ('569', '220681', '临江市', '220600');
INSERT INTO `area` VALUES ('570', '220702', '宁江区', '220700');
INSERT INTO `area` VALUES ('571', '220721', '前郭尔罗斯蒙古族自治县', '220700');
INSERT INTO `area` VALUES ('572', '220722', '长岭县', '220700');
INSERT INTO `area` VALUES ('573', '220723', '乾安县', '220700');
INSERT INTO `area` VALUES ('574', '220781', '扶余市', '220700');
INSERT INTO `area` VALUES ('575', '220802', '洮北区', '220800');
INSERT INTO `area` VALUES ('576', '220821', '镇赉县', '220800');
INSERT INTO `area` VALUES ('577', '220822', '通榆县', '220800');
INSERT INTO `area` VALUES ('578', '220881', '洮南市', '220800');
INSERT INTO `area` VALUES ('579', '220882', '大安市', '220800');
INSERT INTO `area` VALUES ('580', '222401', '延吉市', '222400');
INSERT INTO `area` VALUES ('581', '222402', '图们市', '222400');
INSERT INTO `area` VALUES ('582', '222403', '敦化市', '222400');
INSERT INTO `area` VALUES ('583', '222404', '珲春市', '222400');
INSERT INTO `area` VALUES ('584', '222405', '龙井市', '222400');
INSERT INTO `area` VALUES ('585', '222406', '和龙市', '222400');
INSERT INTO `area` VALUES ('586', '222424', '汪清县', '222400');
INSERT INTO `area` VALUES ('587', '222426', '安图县', '222400');
INSERT INTO `area` VALUES ('588', '230102', '道里区', '230100');
INSERT INTO `area` VALUES ('589', '230103', '南岗区', '230100');
INSERT INTO `area` VALUES ('590', '230104', '道外区', '230100');
INSERT INTO `area` VALUES ('591', '230108', '平房区', '230100');
INSERT INTO `area` VALUES ('592', '230109', '松北区', '230100');
INSERT INTO `area` VALUES ('593', '230110', '香坊区', '230100');
INSERT INTO `area` VALUES ('594', '230111', '呼兰区', '230100');
INSERT INTO `area` VALUES ('595', '230112', '阿城区', '230100');
INSERT INTO `area` VALUES ('596', '230113', '双城区', '230100');
INSERT INTO `area` VALUES ('597', '230123', '依兰县', '230100');
INSERT INTO `area` VALUES ('598', '230124', '方正县', '230100');
INSERT INTO `area` VALUES ('599', '230125', '宾县', '230100');
INSERT INTO `area` VALUES ('600', '230126', '巴彦县', '230100');
INSERT INTO `area` VALUES ('601', '230127', '木兰县', '230100');
INSERT INTO `area` VALUES ('602', '230128', '通河县', '230100');
INSERT INTO `area` VALUES ('603', '230129', '延寿县', '230100');
INSERT INTO `area` VALUES ('604', '230183', '尚志市', '230100');
INSERT INTO `area` VALUES ('605', '230184', '五常市', '230100');
INSERT INTO `area` VALUES ('606', '230202', '龙沙区', '230200');
INSERT INTO `area` VALUES ('607', '230203', '建华区', '230200');
INSERT INTO `area` VALUES ('608', '230204', '铁锋区', '230200');
INSERT INTO `area` VALUES ('609', '230205', '昂昂溪区', '230200');
INSERT INTO `area` VALUES ('610', '230206', '富拉尔基区', '230200');
INSERT INTO `area` VALUES ('611', '230207', '碾子山区', '230200');
INSERT INTO `area` VALUES ('612', '230208', '梅里斯达斡尔族区', '230200');
INSERT INTO `area` VALUES ('613', '230221', '龙江县', '230200');
INSERT INTO `area` VALUES ('614', '230223', '依安县', '230200');
INSERT INTO `area` VALUES ('615', '230224', '泰来县', '230200');
INSERT INTO `area` VALUES ('616', '230225', '甘南县', '230200');
INSERT INTO `area` VALUES ('617', '230227', '富裕县', '230200');
INSERT INTO `area` VALUES ('618', '230229', '克山县', '230200');
INSERT INTO `area` VALUES ('619', '230230', '克东县', '230200');
INSERT INTO `area` VALUES ('620', '230231', '拜泉县', '230200');
INSERT INTO `area` VALUES ('621', '230281', '讷河市', '230200');
INSERT INTO `area` VALUES ('622', '230302', '鸡冠区', '230300');
INSERT INTO `area` VALUES ('623', '230303', '恒山区', '230300');
INSERT INTO `area` VALUES ('624', '230304', '滴道区', '230300');
INSERT INTO `area` VALUES ('625', '230305', '梨树区', '230300');
INSERT INTO `area` VALUES ('626', '230306', '城子河区', '230300');
INSERT INTO `area` VALUES ('627', '230307', '麻山区', '230300');
INSERT INTO `area` VALUES ('628', '230321', '鸡东县', '230300');
INSERT INTO `area` VALUES ('629', '230381', '虎林市', '230300');
INSERT INTO `area` VALUES ('630', '230382', '密山市', '230300');
INSERT INTO `area` VALUES ('631', '230402', '向阳区', '230400');
INSERT INTO `area` VALUES ('632', '230403', '工农区', '230400');
INSERT INTO `area` VALUES ('633', '230404', '南山区', '230400');
INSERT INTO `area` VALUES ('634', '230405', '兴安区', '230400');
INSERT INTO `area` VALUES ('635', '230406', '东山区', '230400');
INSERT INTO `area` VALUES ('636', '230407', '兴山区', '230400');
INSERT INTO `area` VALUES ('637', '230421', '萝北县', '230400');
INSERT INTO `area` VALUES ('638', '230422', '绥滨县', '230400');
INSERT INTO `area` VALUES ('639', '230502', '尖山区', '230500');
INSERT INTO `area` VALUES ('640', '230503', '岭东区', '230500');
INSERT INTO `area` VALUES ('641', '230505', '四方台区', '230500');
INSERT INTO `area` VALUES ('642', '230506', '宝山区', '230500');
INSERT INTO `area` VALUES ('643', '230521', '集贤县', '230500');
INSERT INTO `area` VALUES ('644', '230522', '友谊县', '230500');
INSERT INTO `area` VALUES ('645', '230523', '宝清县', '230500');
INSERT INTO `area` VALUES ('646', '230524', '饶河县', '230500');
INSERT INTO `area` VALUES ('647', '230602', '萨尔图区', '230600');
INSERT INTO `area` VALUES ('648', '230603', '龙凤区', '230600');
INSERT INTO `area` VALUES ('649', '230604', '让胡路区', '230600');
INSERT INTO `area` VALUES ('650', '230605', '红岗区', '230600');
INSERT INTO `area` VALUES ('651', '230606', '大同区', '230600');
INSERT INTO `area` VALUES ('652', '230621', '肇州县', '230600');
INSERT INTO `area` VALUES ('653', '230622', '肇源县', '230600');
INSERT INTO `area` VALUES ('654', '230623', '林甸县', '230600');
INSERT INTO `area` VALUES ('655', '230624', '杜尔伯特蒙古族自治县', '230600');
INSERT INTO `area` VALUES ('656', '230702', '伊春区', '230700');
INSERT INTO `area` VALUES ('657', '230703', '南岔区', '230700');
INSERT INTO `area` VALUES ('658', '230704', '友好区', '230700');
INSERT INTO `area` VALUES ('659', '230705', '西林区', '230700');
INSERT INTO `area` VALUES ('660', '230706', '翠峦区', '230700');
INSERT INTO `area` VALUES ('661', '230707', '新青区', '230700');
INSERT INTO `area` VALUES ('662', '230708', '美溪区', '230700');
INSERT INTO `area` VALUES ('663', '230709', '金山屯区', '230700');
INSERT INTO `area` VALUES ('664', '230710', '五营区', '230700');
INSERT INTO `area` VALUES ('665', '230711', '乌马河区', '230700');
INSERT INTO `area` VALUES ('666', '230712', '汤旺河区', '230700');
INSERT INTO `area` VALUES ('667', '230713', '带岭区', '230700');
INSERT INTO `area` VALUES ('668', '230714', '乌伊岭区', '230700');
INSERT INTO `area` VALUES ('669', '230715', '红星区', '230700');
INSERT INTO `area` VALUES ('670', '230716', '上甘岭区',

最低0.47元/天解锁文章

木兰无长兄

关注

4
点赞
踩
11

收藏

觉得还不错? 一键收藏
5
评论
2018最新版省市区三级联动下拉框+所有源代码以及数据库

2018年国家统计局最新数据，JSP+Servlet+Dao实现省市区三级联动下拉框的效果DropdownDAO.java —–Dao层 package com;import java.sql.Connection;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;i...
复制链接

扫一扫