Ajax学习和JSON

最新推荐文章于 2022-05-08 11:31:41 发布

juezhanangle

最新推荐文章于 2022-05-08 11:31:41 发布

阅读量2k

点赞数 2

本文链接：https://blog.csdn.net/juezhanangle/article/details/69855716

版权

AJAX使用的是老的技术,新的思想.完成了RIA的应用:Rich Internet Application.

* 传统方式的开发：所有的数据提交到服务器端进行处理.(胖服务器)

* AJAX的方式开发：有一部分的代码写在客户端.

Ø AJAX的作用：

完成页面局部刷新而不影响用户的体验.

* 用户名是否已经存在的校验

* 百度信息输入的提示

AJAX分为：原始AJAX和基于jQuery的AJAX

1.原始AJAX的：

	//1.创建核心对象
	var xmlhttp;
	if (window.XMLHttpRequest)
	  {// code for IE7+, Firefox, Chrome, Opera, Safari
	  xmlhttp=new XMLHttpRequest();
	  }
	else
	  {// code for IE6, IE5
	  xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
	  }
	//2.编写回调函数
	xmlhttp.onreadystatechange=function()
	  {
	  if (xmlhttp.readyState==4 && xmlhttp.status==200)
	    {
	    	//alert("123");
	    	alert((xmlhttp.responseText));
	    }
	  }
	//3.open 设置请求的方式和请求路径
	xmlhttp.open("post","${pageContext.request.contextPath}/ajax2.action?username=张三",true);

	//4.send发送
	xmlhttp.send();
}

这是前台完成的代码

@RequestMapping("/ajax2")
	public void ajax2(HttpServletResponse response,HttpServletRequest request) throws IOException{
		//接参数
		String username = request.getParameter("username");
		//username = new String(username.getBytes("iso8859-1"),"utf-8");
		request.setCharacterEncoding("utf-8");
		//乱码
		response.setContentType("text/html;charset=utf-8");
		response.getWriter().println("姓名："+username);
	
	}

这是后台完成的代码

2.基于jQuery的AJAX:

分为4种：

* $(“”).load(url,data,function(){},type);(了解)

* $.get(url,data,function(){},dataType);

* $.post(url,data,function(){},dataType);

* $.ajax(

url:请求路径,

type:请求方法,

data:发送到服务器的数据,

success:fn 成功以后的回调,

error: fn 异常之后的回调,

dataType: 返回的数据类型,

async:设置为异步

);

其中：

url：请求的路径

data：请求的参数，参数为key-value的形式 key=value {"":"","":""}

function:回调函数，参数就是服务器发送回来的数据

dataType:返回内容形式，xml,html,script,json,text

get方式：

<script type="text/javascript">
	$(function(){
		$("#btn").click(function(){
			var url = "${pageContext.request.contextPath}/ajax4.action";
			var params={"username":"赃款的健康"};
			
			$.get(url,params,function(d){
				alert(d);
			})
		})
	})
</script>

后台代码：

@RequestMapping("/ajax4")
	public void ajax4(HttpServletResponse response,HttpServletRequest request) throws IOException{
		//接参数
		String username = request.getParameter("username");
		//username = new String(username.getBytes("iso8859-1"),"utf-8");
		request.setCharacterEncoding("utf-8");
		//乱码
		response.setContentType("text/html;charset=utf-8");
		//response.getWriter().println("姓名："+username);
		response.getWriter().println("success~~~");
	
	}

post方式：

<script type="text/javascript">
	$(function(){
		$("#btn").click(function(){
			var url = "${pageContext.request.contextPath}/ajax4.action";
			var params={"username":"赃款的健康"};
			
			/* $.get(url,params,function(d){
				alert(d);
			}) */
			$.post(url,params,function(d){
				alert(d.name);
			},"json");
		});
	})
</script>

后台代码：

@RequestMapping("/ajax4")
	public void ajax4(HttpServletResponse response,HttpServletRequest request) throws IOException{
		//接参数
		String username = request.getParameter("username");
		//username = new String(username.getBytes("iso8859-1"),"utf-8");
		request.setCharacterEncoding("utf-8");
		//乱码
		Map<String,String> map = new HashMap<>();
		map.put("name",	 "wuhao");
		map.put("password", "123");
		String str = JSONObject.fromObject(map).toString();
		
		//response.getWriter().println("姓名："+username);
		response.getWriter().println(str);
	
	}

AJAX类型的：

<script type="text/javascript">
	$(function(){
		$("#btn").click(function(){
			var url = "${pageContext.request.contextPath}/ajax4.action";
			var params={"username":"赃款的健康"};
			
			$.ajax({
				url:url,
				type:"post",
				data:params,
				success:function(d){alert(d.password)},
				error:function(){},
				dataType:"json"
			});
		});
	})

后台代码如上。

应用项目---------模仿百度搜索：

前度页面代码：

<center>
	<div>
		<h1>百度搜索</h1>
		<div>
			<input id="ted" name="kw"><input type="submit" value="百度一下">
		</div>
		<div id="idi" style="border: 1px solid red;width: 151px;position: relative;left: -33px;">
		</div>
	</div>
	
</center>
	$(function(){
		//文本框keyup的时候发送ajax
		$("#ted").keyup(function(){
			//获取文本框的值
			var $value = $(this).val();
			//当内容为空的时候不发送
			if($value!=null && $value!=""){
				$("#idi").html("");
				$.post("${pageContext.request.contextPath}/ajax5.action","kw="+$value,function(d){
					if(d!=''){
						for(var x in d)
						//alert(d[x]);
						//将每一个值放大id为idi  可以将每一个值放到一个div中
						$("#idi").append($("<div>"+d[x]+"<div>"));
						
					}
				},"json");
				$("#idi").show();
			}else{
				$("#idi").hide();
			}
			
		});
	})

后台代码：

controller
	@RequestMapping("/ajax5")
	public void ajax5(HttpServletResponse response,HttpServletRequest request) throws IOException{
		//接参数
		String kw = request.getParameter("kw");
		//username = new String(username.getBytes("iso8859-1"),"utf-8");
		request.setCharacterEncoding("utf-8");
		//乱码
		List<String> word = kwService.findKwByWord(kw);
		String string = JSONArray.fromObject(word).toString();
		System.out.println(string);
		response.getWriter().println(string);
		
	}

service:

@Service
public class KwService {
	@Autowired
	private KwMapper kwMapper;
	public List<String> findKwByWord(String kw){
		List<String> list = kwMapper.findKwByWord(kw);
		return list;
	}}

DAO:

<mapper namespace="cn.tju.mapper.KwMapper">
	<select id="findKwByWord" parameterType="java.lang.String" resultType="java.lang.String">
		SELECT kw FROM keyword WHERE kw LIKE '%${_parameter}%'
	</select>
</mapper>
public interface KwMapper {

	public List<String> findKwByWord(String kw);
}

其中数据库：

省市联动项目：

CREATE TABLE Province(ProvinceID INT Primary Key ,Name varchar(50) CHARACTER SET utf8 DEFAULT NULL);
  CREATE TABLE City(CityID INT Primary Key ,ProvinceID INT ,Name varchar(50) CHARACTER SET utf8 DEFAULT NULL);
INSERT INTO Province(ProvinceID,Name)VALUES('1','北京');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('1','东城区','1');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('2','西城区','1');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('3','宣武区','1');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('4','崇文区','1');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('5','朝阳区','1');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('6','海淀区','1');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('7','丰台区','1');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('8','石景山区','1');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('9','门头沟区','1');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('10','昌平区','1');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('11','大兴区','1');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('12','怀柔区','1');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('13','密云县','1');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('14','平谷区','1');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('15','顺义区','1');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('16','通州区','1');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('17','延庆县','1');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('103','房山区','1');
INSERT INTO Province(ProvinceID,Name)VALUES('2','上海');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('18','黄浦区','2');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('19','南市区','2');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('20','卢湾区','2');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('21','徐汇区','2');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('22','长宁区','2');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('23','静安区','2');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('24','普陀区','2');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('25','金山区','2');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('26','闸北区','2');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('27','虹口区','2');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('28','杨浦区','2');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('29','宝山区','2');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('30','闵行区','2');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('31','嘉定区','2');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('32','松江区','2');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('33','浦东新区','2');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('34','青浦县','2');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('35','奉贤县','2');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('36','南汇县','2');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('37','崇明县','2');
INSERT INTO Province(ProvinceID,Name)VALUES('3','天津');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('38','和平区','3');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('39','河东区','3');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('40','河西区','3');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('41','河北区','3');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('42','南开区','3');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('43','红桥区','3');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('44','塘沽区','3');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('45','汉沽区','3');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('105','大港区','3');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('106','东丽区','3');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('107','西青区','3');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('108','津南区','3');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('109','北辰区','3');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('110','武清区','3');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('111','宝坻区','3');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('112','蓟 县','3');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('113','宁河县','3');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('114','静海县','3');
INSERT INTO Province(ProvinceID,Name)VALUES('4','重庆');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('46','永川市','4');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('47','黔江区','4');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('48','涪陵区','4');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('49','万洲区','4');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('115','渝中区','4');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('116','大渡口区','4');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('117','江北区','4');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('118','沙坪坝区','4');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('119','九龙坡区','4');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('120','南岸区','4');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('121','北碚区','4');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('122','万盛区','4');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('123','双桥区','4');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('124','渝北区','4');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('125','巴南区','4');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('126','长寿区','4');
INSERT INTO Province(ProvinceID,Name)VALUES('5','黑龙江');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('50','哈尔滨','5');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('51','齐齐哈尔','5');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('52','牡丹江','5');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('127','鹤岗','5');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('128','双鸭山','5');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('129','鸡西','5');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('130','大庆','5');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('131','伊春','5');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('132','佳木斯','5');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('133','七台河','5');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('134','黑河','5');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('135','绥化','5');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('136','大兴安岭地区','5');
INSERT INTO Province(ProvinceID,Name)VALUES('6','吉林');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('53','长春','6');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('54','吉林','6');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('137','四平','6');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('138','辽源','6');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('139','通化','6');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('140','白山','6');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('141','松原','6');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('142','白城','6');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('143','延边朝鲜族自治州','6');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('449','高新','6');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('450','延吉','6');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('451','梅河口','6');
INSERT INTO Province(ProvinceID,Name)VALUES('7','辽宁');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('55','沈阳','7');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('56','大连','7');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('57','锦州','7');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('144','鞍山','7');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('145','抚顺','7');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('146','本溪','7');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('147','丹东','7');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('148','葫芦岛','7');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('149','营口','7');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('150','盘锦','7');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('151','阜新','7');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('152','辽阳','7');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('153','铁岭','7');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('154','朝阳','7');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('467','瓦房店','7');
 

INSERT INTO Province(ProvinceID,Name)VALUES('8','内蒙古');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('58','呼和浩特','8');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('59','包头','8');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('155','乌海','8');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('156','赤峰','8');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('157','通辽','8');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('158','鄂尔多斯','8');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('160','乌兰察布盟','8');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('161','锡林郭勒盟','8');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('162','巴彦淖尔盟','8');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('163','阿拉善盟','8');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('164','兴安盟','8');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('468','巴彦淖尔','8');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('469','呼伦贝尔','8');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('470','集宁','8');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('471','乌兰浩特','8');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('472','锡林浩特','8');
INSERT INTO Province(ProvinceID,Name)VALUES('9','宁夏');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('60','银川','9');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('165','石嘴山','9');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('166','吴忠','9');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('167','固原','9');
INSERT INTO Province(ProvinceID,Name)VALUES('10','新疆');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('61','乌鲁木齐','10');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('168','克拉玛依','10');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('169','吐鲁番地区','10');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('170','哈密地区','10');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('171','和田地区','10');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('172','阿克苏地区','10');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('173','喀什地区','10');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('174','克孜勒苏柯尔克孜自治州','10');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('175','巴音郭楞蒙古自治州','10');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('176','昌吉回族自治州','10');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('177','博尔塔拉蒙古自治州','10');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('178','伊犁哈萨克自治州','10');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('500','阿克苏','10');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('501','昌吉','10');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('502','哈密','10');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('503','和田','10');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('504','喀什','10');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('505','克拉马依','10');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('506','库尔勒','10');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('507','石河子','10');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('508','吐鲁番','10');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('509','乌市','10');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('510','奎屯','10');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('511','伊犁','10');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('512','伊宁','10');
INSERT INTO Province(ProvinceID,Name)VALUES('11','青海');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('62','西宁','11');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('179','海东地区','11');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('180','海北藏族自治州','11');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('181','黄南藏族自治州','11');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('182','海南藏族自治州','11');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('183','果洛藏族自治州','11');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('184','玉树藏族自治州','11');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('185','海西蒙古族藏族自治州','11');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('473','格尔木','11');
INSERT INTO Province(ProvinceID,Name)VALUES('12','甘肃');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('63','兰州','12');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('64','天水','12');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('186','金昌','12');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('187','白银','12');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('188','嘉峪关','12');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('189','武 威 ','12');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('190','张掖','12');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('191','平凉','12');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('192','酒泉','12');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('193','庆阳','12');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('194','定西地区','12');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('195','陇南地区','12');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('196','甘南藏族自治州','12');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('197','临夏回族自治州','12');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('422','嘉峪','12');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('423','武威','12');
INSERT INTO Province(ProvinceID,Name)VALUES('13','陕西');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('65','西安','13');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('66','宝鸡','13');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('67','延安','13');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('198','铜川','13');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('199','咸阳','13');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('200','渭南','13');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('201','汉中','13');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('202','榆林','13');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('203','安康','13');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('204','商洛','13');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('496','韩城','13');
INSERT INTO Province(ProvinceID,Name)VALUES('14','河北');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('68','石家庄','14');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('69','保定','14');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('205','唐山','14');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('206','秦皇岛','14');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('207','邯郸','14');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('208','邢台','14');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('209','张家口','14');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('210','承德','14');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('211','沧州','14');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('212','廊坊','14');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('213','衡水','14');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('436','霸州','14');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('437','青县','14');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('438','任丘','14');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('439','涿州','14');
INSERT INTO Province(ProvinceID,Name)VALUES('15','河南');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('70','郑州','15');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('71','洛阳','15');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('214','开封','15');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('215','平顶山','15');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('216','焦作','15');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('217','鹤壁','15');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('218','新乡','15');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('219','安阳','15');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('220','濮阳','15');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('221','许昌','15');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('222','漯河','15');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('223','三门峡','15');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('224','南阳','15');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('225','商丘','15');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('226','信阳','15');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('227','周口','15');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('228','驻马店','15');

INSERT INTO Province(ProvinceID,Name)VALUES('16','山东');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('72','济南','16');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('73','青岛','16');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('74','烟台','16');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('229','淄博','16');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('230','枣庄','16');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('231','东营','16');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('232','潍坊','16');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('233','威海','16');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('234','济宁','16');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('235','泰安','16');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('236','日照','16');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('237','莱芜','16');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('238','德州','16');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('239','临沂','16');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('240','聊城','16');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('241','滨州','16');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('242','菏泽','16');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('474','高密','16');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('475','荷泽','16');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('476','淮坊','16');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('477','即墨','16');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('478','胶南','16');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('479','莱州','16');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('480','林沂','16');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('481','临忻','16');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('482','龙口','16');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('483','蓬莱','16');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('484','青州','16');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('485','乳山','16');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('486','寿光','16');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('487','滕州','16');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('488','文登','16');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('489','招远','16');
INSERT INTO Province(ProvinceID,Name)VALUES('17','山西');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('75','太原','17');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('76','大同','17');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('243','朔州','17');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('244','阳泉','17');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('245','长治','17');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('246','晋城','17');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('247','忻州','17');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('248','晋中','17');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('249','临汾','17');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('250','运城','17');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('251','吕梁地区','17');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('491','河津','17');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('492','侯马','17');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('494','孝义','17');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('495','榆次','17');
INSERT INTO Province(ProvinceID,Name)VALUES('18','湖北');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('77','武汉','18');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('252','黄石','18');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('253','襄樊','18');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('254','十堰','18');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('255','荆州','18');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('256','宜昌','18');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('257','荆门','18');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('258','鄂州','18');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('259','孝感','18');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('260','黄冈','18');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('261','咸宁','18');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('262','随州','18');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('263','恩施土家族苗族自治州','18');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('440','安陆','18');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('441','恩施','18');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('442','汉口','18');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('443','汉阳','18');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('444','潜江','18');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('445','仙桃','18');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('446','株州','18');
INSERT INTO Province(ProvinceID,Name)VALUES('19','湖南');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('78','长沙','19');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('264','株洲','19');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('265','湘潭','19');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('266','衡阳','19');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('267','邵阳','19');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('268','岳阳','19');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('269','常德','19');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('270','张家界','19');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('271','益阳','19');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('272','郴州','19');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('273','永州','19');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('274','怀化','19');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('275','娄底','19');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('276','湘西土家族苗族自治州','19');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('447','株州','19');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('448','邵东','19');
INSERT INTO Province(ProvinceID,Name)VALUES('20','安徽');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('79','合肥','20');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('80','芜湖','20');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('277','蚌埠','20');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('278','淮南','20');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('279','马鞍山','20');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('280','淮北','20');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('281','铜陵','20');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('282','安庆','20');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('283','黄山','20');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('284','滁州','20');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('285','阜阳','20');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('286','宿州','20');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('287','巢湖','20');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('288','六安','20');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('289','亳州','20');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('290','池州','20');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('291','宣城','20');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('412','蒙城','20');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('413','宁国','20');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('414','桐城','20');
INSERT INTO Province(ProvinceID,Name)VALUES('21','江苏');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('81','南京','21');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('292','徐州','21');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('293','连云港','21');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('294','淮安','21');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('295','宿迁','21');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('296','盐城','21');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('297','扬州','21');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('298','泰州','21');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('299','南通','21');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('300','镇江','21');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('301','常州','21');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('302','无锡','21');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('303','苏州','21');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('452','常熟','21');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('453','丹阳','21');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('454','海门','21');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('455','江都','21');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('456','江阴','21');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('457','靖江','21');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('458','昆山','21');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('459','溧阳','21');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('460','太仓','21');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('461','泰州华','21');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('462','吴江','21');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('463','吴县','21');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('464','宜兴','21');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('465','张家港','21');

INSERT INTO Province(ProvinceID,Name)VALUES('22','浙江');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('82','杭州','22');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('304','宁波','22');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('305','温州','22');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('306','嘉兴','22');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('307','湖州','22');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('308','绍兴','22');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('309','金华','22');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('310','衢州','22');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('311','舟山','22');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('312','台州','22');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('313','丽水','22');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('514','慈溪','22');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('515','东阳','22');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('516','奉化','22');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('517','乐清','22');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('518','临安','22');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('519','临海','22');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('520','平湖','22');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('521','瑞安','22');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('522','上虞','22');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('523','嵊州','22');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('524','温岭','22');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('525','义乌','22');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('526','永康','22');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('527','余姚','22');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('528','诸暨','22');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('529','新昌','22');
INSERT INTO Province(ProvinceID,Name)VALUES('23','江西');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('83','南昌','23');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('314','景德镇','23');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('315','萍乡','23');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('316','新余','23');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('317','九江','23');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('318','鹰潭','23');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('319','赣州','23');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('320','吉安','23');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('321','宜春','23');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('322','抚州','23');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('323','上饶','23');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('466','高安','23');
INSERT INTO Province(ProvinceID,Name)VALUES('24','广东');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('84','广州','24');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('85','深圳','24');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('324','珠海','24');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('325','汕头','24');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('326','韶关','24');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('327','河源','24');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('328','梅州','24');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('329','惠州','24');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('330','汕尾','24');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('331','东莞','24');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('332','中山','24');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('333','江门','24');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('334','佛山','24');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('335','阳江','24');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('336','湛江','24');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('337','茂名','24');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('338','肇庆','24');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('339','清远','24');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('340','潮州','24');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('341','揭阳','24');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('342','云浮','24');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('424','花都','24');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('425','开平','24');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('426','南海','24');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('427','顺德','24');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('428','台山','24');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('429','增城','24');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('431','市梅','24');
INSERT INTO Province(ProvinceID,Name)VALUES('25','广西');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('86','南宁','25');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('343','柳州','25');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('344','桂林','25');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('345','梧州','25');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('346','北海','25');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('347','防城港','25');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('348','钦州','25');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('349','贵港','25');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('350','玉林','25');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('351','百色','25');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('352','贺州','25');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('353','河池','25');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('354','来宾','25');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('355','崇左','25');
INSERT INTO Province(ProvinceID,Name)VALUES('26','福建');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('87','福州','26');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('88','厦门','26');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('356','三明','26');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('357','莆田','26');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('358','泉州','26');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('359','漳州','26');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('360','南平','26');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('361','龙岩','26');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('362','宁德','26');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('415','福清','26');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('416','建瓯','26');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('417','晋江','26');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('418','南安','26');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('419','邵武','26');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('420','石狮','26');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('421','仙游','26');

INSERT INTO Province(ProvinceID,Name)VALUES('27','四川');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('89','成都','27');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('363','自贡','27');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('364','攀枝花','27');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('365','泸州','27');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('366','德阳','27');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('367','绵阳','27');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('368','广元','27');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('369','遂宁','27');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('370','内江','27');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('371','乐山','27');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('372','南充','27');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('373','宜宾','27');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('374','广安','27');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('375','达州','27');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('376','巴中','27');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('377','雅安','27');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('378','眉山','27');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('379','资阳','27');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('380','阿坝藏族羌族自治州','27');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('381','甘孜藏族自治州','27');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('382','凉山彝族自治州','27');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('497','广汉','27');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('498','锦阳','27');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('499','西昌','27');
INSERT INTO Province(ProvinceID,Name)VALUES('28','云南');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('90','昆明','28');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('383','曲靖','28');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('384','玉溪','28');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('385','保山','28');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('386','昭通','28');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('387','思茅地区','28');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('388','临沧地区','28');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('389','丽江','28');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('390','文山壮族苗族自治州','28');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('391','红河哈尼族彝族自治州','28');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('392','西双版纳傣族自治州','28');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('393','楚雄彝族自治州','28');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('394','大理白族自治州','28');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('395','德宏傣族景颇族自治州','28');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('396','怒江傈傈族自治州','28');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('397','迪庆藏族自治州','28');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('513','大理','28');
INSERT INTO Province(ProvinceID,Name)VALUES('29','贵州');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('91','贵阳','29');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('398','六盘水','29');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('399','遵义','29');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('400','安顺','29');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('401','铜仁地区','29');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('402','毕节地区','29');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('403','黔西南布依族苗族自治州','29');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('404','黔东南苗族侗族自治州','29');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('405','黔南布依族苗族自治州','29');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('432','都匀','29');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('433','贵恙','29');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('434','凯里','29');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('435','铜仁','29');
INSERT INTO Province(ProvinceID,Name)VALUES('30','西藏');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('92','拉萨','30');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('406','那曲地区','30');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('407','昌都地区','30');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('408','山南地区','30');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('409','日喀则地区','30');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('410','阿里地区','30');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('411','林芝地区','30');
INSERT INTO Province(ProvinceID,Name)VALUES('31','海南');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('93','海口','31');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('94','三亚','31');
INSERT INTO Province(ProvinceID,Name)VALUES('32','香港');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('95','香港','32');
INSERT INTO Province(ProvinceID,Name)VALUES('33','澳门');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('96','澳门','33');
INSERT INTO Province(ProvinceID,Name)VALUES('34','台湾');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('97','台北','34');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('98','高雄','34');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('99','台中','34');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('100','台南','34');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('101','基隆','34');
  INSERT INTO City(CityID,Name,ProvinceID)VALUES('102','新竹','34');

前端页面：

<center>
	<select id="proId" name="province">
		<option>--省份--</option>
	</select>
	<select id="cityId" name="city">
		<option>--请选择--</option>
	</select>
</center>
$(function(){
		//页面加载成功查询所有的省
		$.get("${pageContext.request.contextPath}/ajax6.action",function(proce){
			var $pro = $("#proId");
			$(proce).each(function(){
				$pro.append($("<option value="+this.provinceid+">"+this.name+"</option>"));
			});
		},"json");
		
		//给省份派发change事件
		$("#proId").change(function(){
			//获取省份id
			var $pid = $(this).val();
			//alert($pid);
			var $cit = $("#cityId");
			$.get("${pageContext.request.contextPath}/ajax7.action",{"pid":$pid},function(d){
				$(d).each(function(){
					//alert(this.name);
					$cit.append($("<option value="+this.cityid+">"+this.name+"</option>"))
				});
			},"json")
		});
		
	})

后台代码：controller层

@RequestMapping("/ajax6")
	public void ajax6(HttpServletResponse response,HttpServletRequest request) throws IOException{
		
		List<Province> province = provinceCity.findProvince();
		String pro = JSONArray.fromObject(province).toString();
		System.out.println(pro);
		response.setCharacterEncoding("utf-8");
		response.getWriter().println(pro);
		
	}
	@RequestMapping("/ajax7")
	public void ajax7(HttpServletResponse response,HttpServletRequest request) throws IOException{
		//1.设置编码
		//request.setCharacterEncoding("utf-8");
		response.setContentType("text/html;charset=utf-8");
		String pid = request.getParameter("pid");
		List<City> cityList = provinceCity.findCityByPid(pid);
		String city = JSONArray.fromObject(cityList).toString();
		System.out.println(city);
		response.getWriter().println(city);
		
	}

dao层：

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
<mapper namespace="cn.tju.mapper.ProvinceCity">
	<select id="findProvince" resultType="cn.tju.pojo.Province">
		SELECT * FROM province
	</select>
	<select id="findCityByPid" parameterType="java.lang.String" resultType="cn.tju.pojo.City">
		SELECT * FROM city WHERE ProvinceID=#{provinceid}
	</select>
</mapper>

package cn.tju.mapper;

import java.util.List;

import cn.tju.pojo.City;
import cn.tju.pojo.Province;

public interface ProvinceCity {

	public List<Province> findProvince();
	public List<City> findCityByPid(String pid);
}

service层：

package cn.tju.service;

import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import cn.tju.mapper.ProvinceCity;
import cn.tju.pojo.City;
import cn.tju.pojo.Province;

@Service
public class ProvinceCityService {

	@Autowired
	private ProvinceCity province;
	
	public List<Province> findProvince(){
		List<Province> provinceList = province.findProvince();
		return provinceList;
	}
	public List<City> findCityByPid(String pid){
		List<City> cityList = province.findCityByPid(pid);
		return cityList;
	}
}

pojo对象：

package cn.tju.pojo;

public class Province {

	private int provinceid;
	private String name;
	public int getProvinceid() {
		return provinceid;
	}
	public void setProvinceid(int provinceid) {
		this.provinceid = provinceid;
	}
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
}

package cn.tju.pojo;

public class City {
	
	private int cityid;
	private int provinceid;
	private String name;
	public int getCityid() {
		return cityid;
	}
	public void setCityid(int cityid) {
		this.cityid = cityid;
	}
	public int getProvinceid() {
		return provinceid;
	}
	public void setProvinceid(int provinceid) {
		this.provinceid = provinceid;
	}
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	

}