Ajax学习和JSON
来源:互联网 发布:2016淘宝直通车 编辑:程序博客网 时间:2024/05/17 07:12
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:
@Servicepublic class KwService {@Autowiredprivate 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(){//获取省份idvar $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;@Servicepublic class ProvinceCityService {@Autowiredprivate 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;}}
0 0
- Ajax学习和JSON
- JavaScript学习笔记一AJAX和JSON
- ajax post 异步 和 Json ashx学习
- ZendFramework2学习笔记 json和ajax
- Ajax、json学习笔记
- ajax&&json学习笔记
- ajax(json)学习笔记
- ajax,json学习笔记(三)JSON和jquery实现ajax
- Ajax和JSON笔记
- Ajax和JSON
- Ajax和JSON
- ajax 和 json
- Ajax和JSON
- Ajax和JSON
- JSON和AJAX
- AJAX和JSON
- ajax、json和jsonp
- ajax和JSON基础知识
- 543. Diameter of Binary Tree
- Linux格式化U盘
- javaSE_08Java中static、继承、重写
- Ubuntu 14.10 apt-get update 404错误
- 使用浏览器
- Ajax学习和JSON
- nginx源码解析-ngx_show_version_info()
- 【Java面试必备】最近5年133个Java面试问题列表
- 交叉编译工具arm-linux-gcc&arm-elf-gcc下载地址全集
- Android开源数据库框架——LitePal
- 交叉编译zlib库
- Python代码风格
- 1047. Student List for Course (25)
- MySQL存储引擎之Myisam和Innodb总结