数据库表设置如下:
js部分代码如下:
<script>
$(function(){
var _data = {
"regionType" : "province"
};
$.ajax({
url : $ctx + '/admin/system/acceptance/myAccept!getRegions',
type : 'post',
data : _data,
success : function(data){
var provinces = eval(data);
var dataList,value,name;
dataList = [];
dataList.push({"value":"","text":"省份"});
$.each(provinces, function(index,row){
value=row.id;
name=row.name;
dataList.push({"value": value,"text":name});
});
$("#province").combobox("loadData",dataList);
$("#province").combobox({
onSelect:function(record){
$("#city").combobox("setValue",''); //清空市
$("#county").combobox("setValue",''); //清空县
var province=$('#province').combobox('getValue');
var _data = {
"regionType" : "city",
"province" : province
};
$.ajax({
url:$ctx + '/admin/system/acceptance/myAccept!getRegions',
data:_data,
type:"POST",
success:function(data){
var cities = eval(data);
var dataList,value,name;
dataList = [];
dataList.push({"value":"","text":"市"});
$.each(cities, function(index,row){
value=row.id;
name=row.name;
dataList.push({"value": value,"text":name});
});
$("#city").combobox("loadData",dataList);
$("#city").combobox({
onSelect:function(record){
$("#county").combobox("setValue",'');
var city=$('#city').combobox('getValue');
var _data = {
"regionType" : "county",
"city" : city
};
$.ajax({
url:$ctx + '/admin/system/acceptance/myAccept!getRegions',
data:_data,
type:"POST",
success:function(data){
var counties = eval(data);
var dataList,value,name;
dataList = [];
dataList.push({"value":"","text":"区(县)"});
$.each(counties, function(index,row){
value=row.id;
name=row.name;
dataList.push({"value": value,"text":name});
});
$("#county").combobox("loadData",dataList);
}
});
}
});
}
});
}
});
}
});
});
</script>