$(function(){
//页面加载成功 查询所有的省
$.get("/day15/selectPro",function(d){
//alert(d)
var $pro=$("#proId");
$(d).each(function(){
$pro.append($("<option value="+this.provinceid+">"+this.name+"</option>"));
});
},"json");
//给省份下拉选派发change事件
$("#proId").change(function(){
//获取省份id
var $pid=$(this).val();
//alert($pid);
//发送ajax请求 查询所有的市
$.get("/day15/selectCity",{"pid":$pid},function(obj){
//alert(obj);
var $city=$("#cityId");
$city.html("<option>-请选择-</option>");
if(obj!=null){
$(obj).each(function(){
$city.append($("<option value='"+this.cityid+"'>"+this.name+"</option>"));
});
}
},"json");
});
})
@Test
//数组
public void f1(){
String[] arr={"aaa","bb","cc"};
JSONArray json = JSONArray.fromObject(arr);
System.out.println(json);
}
@Test
//list
public void f2(){
List<String> list=new ArrayList<>();
list.add("11");
list.add("22");
list.add("33");
JSONArray json = JSONArray.fromObject(list);
System.out.println(json);
}
@Test
//bean
public void f3(){
Province pro = new Province();
pro.setName("北京");
pro.setProvinceid(1);
JSONObject json = JSONObject.fromObject(pro);
System.out.println(json);
}
@Test
//map
public void f4(){
Map<String, Object> map=new HashMap<>();
map.put("username", "tom");
map.put("age", 18);
JSONObject json = JSONObject.fromObject(map);
System.out.println(json);
}
@Test
//bean
public void f5(){
List<Province> list=new ArrayList<>();
list.add(new Province(1,"bj"));
list.add(new Province(2,"tj"));
list.add(new Province(3,"nj"));
list.add(new Province(4,"dj"));
JSONArray json = JSONArray.fromObject(list);
System.out.println(json);
}
//0.设置编码
request.setCharacterEncoding("utf-8");
response.setContentType("text/html;charset=utf-8");
//1.获取省份id
String pid=request.getParameter("pid");
//2.调用service 查询所有的市 返回 list
List<City> list=null;
try {
list = new CityService().findCitiesByPid(pid);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
//3.将list转换成json 返回页面
if(list!=null && list.size()>0){
response.getWriter().println(JSONArray.fromObject(list));
}