ajax的省级联动 下拉框
查找省:
$.ajax({ type: "post", url: "${base}/admin/area/findProvince.json", // data : "pid=" + $("#province").val(), dataType: "json", success: function (area) { var str = "<option>请选择</option>"; $("#sheng").html(""); for (var i = 0; i < area.length; i++) { str += "<option value='" + area[i].name + "'>" + area[i].name + "</option>"; } $("#sheng").append(str); $("#shi").html(""); $("#shi").append("<option>请选择</option>"); } });
查找市
function provincechange() { var params = $("#sheng").val(); $.ajax({ type: "post", url: "${base}/admin/area/findCity.json", data: { "name": params }, dataType: "json", success: function (areass) { var str = "<option>请选择</option>"; $("#shi").html(""); for (var i = 0; i < areass.length; i++) { str += "<option value='" + areass[i].name + "'>" + areass[i].name + "</option>"; } $("#shi").append(str); } }); }
/** * 查找省市 */ @RequestMapping(value = {"/findProvince"}, method = { RequestMethod.POST }) @ResponseBody public List<Area> findProvince(HttpServletResponse response){ List<Area> area=areaService.findRoots(); return area; } /** * 查找市区 */ @RequestMapping(value = {"/findCity"}, method = { RequestMethod.POST }) @ResponseBody public List<Area> findCity(String name){ Map param=new HashMap(); param.put("name",name); List<Area> areas=areaDao.findByParams(param); Area area=areas.get(0); List<Area> areass=areaService.findList("parentId",area.getId()); return areass; }
数据库表就是一个id对应一个parentId