sql语句在上一篇文章中,需要的童鞋可以自行领取。
首先是jsp页面:
省:<select name="provinceid" onchange="findCity(this.value)">
<option>---请选择---</option>
</select>
<span id="but1"></span><span id="but2"></span>
上面是jsp,剩下的是jquery,这个可以自己放到js中,建一个类似工具类的js,需要直接调用就Ok
$(function(){
$.post(
"findProvince",{},function(obj){
for(var i in obj){
$("[name='provinceid']").append("<option value="+obj[i].provinceid+">"+obj[i].province+"</option>");
}
},"json"
);
})
function findCity(provinceid){
$.post(
"findCity",{father:provinceid},function(obj){
$("#but1").empty();
$("#but1").append("市:<select name='cityid' onchange='findArea(this.value)'></select>");
for ( var i in obj) {
$("[name='cityid']").append("<option value="+obj[i].cityid+">"+obj[i].city+"</option>");
}
},"json"
);
}
function findArea(father){
$.post(
"findArea",{father:father},function(obj){
$("#but2").empty();
$("#but2").append("区:<select name='areaid'></select>");
for ( var i in obj) {
$("[name='areaid']").append("<option value="+obj[i].areaid+">"+obj[i].area+"</option>");
}
},"json"
);
}