<SCRIPT LANGUAGE=javascript> <!-- var prv=new Array(); var cty=new Array();function init(){ <% dim prv,cty,i,j //定义变量 i=0 set prv=cn.execute("select distinct ProvinceName from ProData") //查询省份 if not prv.eof then do while not prv.eof j=0 %> prv[<%=i%>]="<%=trim(prv("ProvinceName"))%>"; //prv[0]='安徽' <% set cty=cn.execute("select CityName from ProData where ProvinceName='"&trim(prv("ProvinceName"))&"'") //查询该省份的城市 if not cty.eof then %> cty[<%=i%>]=new Array() <% do while not cty.eof %> cty[<%=i%>][<%=j%>]="<%=trim(cty("CityName"))%>" //cty[0][0]='合肥' <% j=j+1 cty.movenext loop end if cty.close :set cty=nothing i=i+1 prv.movenext loop end if prv.close :set prv=nothing %> // 结束查询,建立城市信息数组
http://china.alibaba.com/member/turbine/template/member%2CJoin
<!--
var prv=new Array();
var cty=new Array();function init(){
<%
dim prv,cty,i,j //定义变量
i=0
set prv=cn.execute("select distinct ProvinceName from ProData") //查询省份
if not prv.eof then
do while not prv.eof
j=0
%>
prv[<%=i%>]="<%=trim(prv("ProvinceName"))%>"; //prv[0]='安徽'
<%
set cty=cn.execute("select CityName from ProData where ProvinceName='"&trim(prv("ProvinceName"))&"'") //查询该省份的城市
if not cty.eof then
%>
cty[<%=i%>]=new Array()
<%
do while not cty.eof
%>
cty[<%=i%>][<%=j%>]="<%=trim(cty("CityName"))%>" //cty[0][0]='合肥'
<%
j=j+1
cty.movenext
loop
end if
cty.close :set cty=nothing
i=i+1
prv.movenext
loop
end if
prv.close :set prv=nothing
%>
// 结束查询,建立城市信息数组
if(prv.length >0)
{
for(i=0;i<prv.length;i++)
with(document.FrmCity.SProvinceName)
{
options[length]=new Option(prv[i],prv[i])
document.FrmCity.SProvinceName.onchange=new Function("go(this.selectedIndex)")
}
}
}function go(sIndex)
{
with(document.FrmCity.SCityName)
{
length=0;
if(sIndex==0)
{
options[0]=new Option("选择城市");
return (false);
}
for(i=0;i<cty[sIndex-1].length;i++)
options[length]=new Option(cty[sIndex-1][i],cty[sIndex-1][i])
}
}
window.onload=init
-->
</SCRIPT>
<form name="FrmCity">
<select name="SProvinceName" class="background">
<option value="" selected>选择省份</option>
</select>
<select name="SCityName" class="background">
<option value="" selected>选择城市</option>
</select>
</form>
修改其中的数据库名称和sql语句
<script language=javascript>
province=new Array("=请选择=","北京市","上海市","天津市","重庆市","河北省","山西省","辽宁省","吉林省","黑龙江省","江苏省","浙江省","安徽省","福建省","江西省","山东省","河南省","湖北省","湖南省","广东省","海南省","四川省","贵州省","云南省","陕西省","甘肃省","青海省","内蒙古自治区","广西壮族自治区","西藏自治区","宁夏回族自治区","新疆维吾尔自治区","台湾","香港","澳门","国外")
type =new Object()type["香港"]=new Array('香港')
type["澳门"]=new Array('澳门')
type['台湾']=new Array('台北','高雄','基隆','桃园','新竹','苗栗','花莲','宜兰','台中','彰化','南投','嘉义','台南','屏东','台东')type["=请选择="]=new Array('=请选择=')type["北京市"]=new Array("北京市区","北京市辖区")
type["上海市"]=new Array("上海市区","上海市辖区")
type["天津市"]=new Array("天津市区","天津市辖区")
type["重庆市"]=new Array("重庆市区","重庆市辖区")
type["河北省"]=new Array("石家庄","张家口市","承德市","秦皇岛市","唐山市","廊坊市","保定市","沧州市","衡水市","邢台市","邯郸市")
type["山西省"]=new Array("太原市","大同市","朔州市","阳泉市","长治市","晋城市","忻州地区","吕梁地区","晋中市","临汾地区","运城地区")
type["辽宁省"]=new Array("沈阳市","朝阳市","阜新市","铁岭市","抚顺市","本溪市","辽阳市","鞍山市","丹东市","大连市","营口市","盘锦市","锦州市","葫芦岛市")
type["吉林省"]=new Array("长春市","白城市","松原市","吉林市","四平市","辽源市","通化市","白山市","延边朝鲜族自治州")
type["黑龙江省"]=new Array("哈尔滨市","齐齐哈尔市","黑河市","大庆市","伊春市","鹤岗市","佳木斯市","双鸭山市","七台河市","鸡西市","牡丹江市","绥化市","大兴安")
type["江苏省"]=new Array("南京市","徐州市","连云港","宿迁市","淮阴市","盐城市","扬州市","泰州市","南通市","镇江市","常州市","无锡市","苏州市")
type["浙江省"]=new Array("杭州市","湖州市","嘉兴市","舟山市","宁波市","绍兴市","金华市","台州市","温州市","丽水地区")
type["安徽省"]=new Array("合肥市","宿州市","淮北市","阜阳市","蚌埠市","淮南市","滁州市","马鞍山市","芜湖市","铜陵市","安庆市","黄山市","六安市","巢湖市","池州地区","宣城地区")
type["福建省"]=new Array("福州市","南平市","三明市","莆田市","泉州市","厦门市","漳州市","龙岩市","宁德市")
type["江西省"]=new Array("南昌市","九江市","景德镇市","鹰潭市","新余市","萍乡市","赣州市","上饶地区","抚州地区","宜春地区","吉安地区")
type["山东省"]=new Array("济南市","聊城市","德州市","东营市","淄博市","潍坊市","烟台市","威海市","青岛市","日照市","临沂市","枣庄市","济宁市","泰安市","莱芜市","滨州地区","菏泽地区")
type["河南省"]=new Array("郑州市","三门峡市","洛阳市","焦作市","新乡市","鹤壁市","安阳市","濮阳市","开封市","商丘市","许昌市","漯河市","平顶山市","南阳市","信阳市","省直辖行政单位","周口地区","驻马店地区")
type["湖北省"]=new Array("武汉市","十堰市","襄攀市","荆门市","孝感市","黄冈市","鄂州市","黄石市","咸宁市","荆州市","宜昌市","省直辖行政单位","恩施土家族苗族自治州","襄樊市")
type["湖南省"]=new Array("长沙市","张家界市","常德市","益阳市","岳阳市","株洲市","湘潭市","衡阳市","郴州市","永州市","邵市","怀化市","娄底市","湘西土家族苗族自治州")
type["广东省"]=new Array("广州市","清远市","韶关市","河源市","梅州市","潮州市","汕头市","揭阳市","汕尾市","惠州市","东莞市","深圳市","珠海市","中山市","江门市","佛山市","肇庆市","云浮市","阳江市","茂名市","湛江市")
type["海南省"]=new Array("海口市","三亚市","省直辖行")
type["四川省"]=new Array("成都市","广元市","绵阳市","德阳市","南充市","广安市","遂宁市","内江市","乐山市","自贡市","泸州市","宜宾市","攀枝花市","巴中地区","达川市","资阳地区","眉山地区","雅安地区","阿坝藏族羌族自治州","甘孜藏族自治州","凉山族自治州")
type["贵州省"]=new Array("贵阳市","六盘水市","遵义市","毕节地区","铜仁地区","安顺地区","黔东南苗族侗族自治地区","黔南布依族苗族自治区","黔西南布依族苗族自治州")
type["云南省"]=new Array("昆明市","曲靖市","玉溪市","丽江地区","昭通地区","思茅地区","临沧地区","保山地区","德宏傣族景颇族自治州","怒江僳僳族自治州","迪庆藏族自治州","大理白族自治州","楚雄彝族自治州","红河哈尼族自治州","文山壮族自治州","西双版纳傣族自治州")
type["陕西省"]=new Array("西安市","延安市","铜川市","渭南市","咸阳市","宝鸡市","汉中市","榆林市","商洛地区","安康地区")
type["甘肃省"]=new Array("兰州市","嘉峪关市","金昌市","白银市","天水市","酒泉地区","张掖地区","武威地区","庆阳地区","平凉地区","定西地区","陇南地区","临夏回族自治州","甘南藏族自治州")
type["青海省"]=new Array("西宁市","海东地区","西宁市","海北藏族","海南藏族","黄南藏族","果洛藏族","玉树藏族","海西蒙古")
type["内蒙古自治区"]=new Array("呼和浩特","包头市","乌海市","赤峰市","呼伦贝尔盟","兴安盟","哲里木盟","锡林郭勒盟","乌兰察布盟","伊克昭盟","巴彦淖尔盟","阿拉善盟")
type["广西壮族自治区"]=new Array("南宁市","桂林市","柳州市","梧州市","贵港市","玉林市","钦州市","北海市","防城港市","南宁地区","百色地区","河池地区","柳州地区","贺州地区")
type["西藏自治区"]=new Array("拉萨市","那曲地区","昌都地区","林芝地区","山南地区","日喀则","阿里地区")
type["宁夏回族自治区"]=new Array("银川市","石嘴山市","吴忠市","固原地区")
type["新疆维吾尔自治区"]=new Array("乌鲁木齐市","克拉玛依市","自治区直辖行政单位","喀什地区","阿克苏地区","和田地区","吐鲁番地区","哈密地区","克孜勒苏柯尔克孜","博尔塔拉蒙古自治州","昌吉回族自治州","巴音郭楞蒙古自治州","伊犁哈萨克自治州","伊犁地区","塔城地区","阿勒泰地区")
type["国外"]=new Array("美国","英国","加拿大","澳大利亚","德国","法国","俄罗斯","意大利","阿富汗","日本","朝鲜","印度","韩国","爱尔兰","越南","马来西亚","墨西哥","蒙古","巴基斯坦","秘鲁","西班牙","其它")var v_yp_province_form;function YP_province_changeprovince()
{
var v_childsel = v_yp_province_form.city;
v_childsel.length = 0;
for (var i=0; i<type[v_yp_province_form.province.value].length; i++)
{
v_childsel.options[i] = new Option();
v_childsel.options[i].value = type[v_yp_province_form.province.value][i];
v_childsel.options[i].text = type[v_yp_province_form.province.value][i];
}
}function YP_Province_PrintSelect(v_province, v_city, v_form)
{
v_yp_province_form = v_form;document.writeln("<select name=province class=form3 onchange=\"javascript:YP_province_changeprovince()\">");
for (var i=0; i<province.length; i++)
{
if (province[i] == v_province)
{
document.writeln("<option value=" + province[i] + " selected>" + province[i] + "</option>");
}
else
{
document.writeln("<option value=" + province[i] + ">" + province[i] + "</option>");
}
}
document.writeln("</select>");document.writeln("<select name=city class=form3>");
for (var i=0; i<type[v_form.province.value].length; i++)
{
if (type[v_form.province.value][i] == v_city)
{
document.writeln("<option value=" + type[v_form.province.value][i] + " selected>" + type[v_form.province.value][i] + "</option>");
}
else
{
document.writeln("<option value=" + type[v_form.province.value][i] + ">" + type[v_form.province.value][i]+ "</option>");
}
}
document.writeln("</select>");
}</script>
<tr><form name="myform" action="post.asp" method="post" onSubmit="return checkForm(this)"> <tr><td height=35 width=120 align="right" class=form3 bgcolor=#EEEEEE><font color=#0D258E>选择地区</font>
<td>
<td> <script language=javascript>YP_Province_PrintSelect("0", "0", document.myform);</script>
<font color=red>*</font>
</form>
MVC不仅是J2ee的事情。比如用一个XML文件存放这些数据。