ASP三级连动(firefox和IE下通过)！

最新推荐文章于 2024-09-23 18:50:41 发布

xingxingxiangrong

最新推荐文章于 2024-09-23 18:50:41 发布

阅读量669

点赞数 1

文章标签： firefox asp ie javascript function button

本文链接：https://blog.csdn.net/xingxingxiangrong/article/details/2098966

版权

<%
dim connstr,province,city,county
connstr="Provider=SQLOLEDB;data source=.;initial catalog=test;user   id=sa;password=p0o9i8u7;"
set conn=server.createobject("adodb.connection")
conn.open connstr
set rs=conn.execute("select * from area where depth=0")
do while not rs.eof
    province=province&rs("content")&","&rs("id")&"|"
    rs.movenext
loop
rs.close
set rs=nothing
' response.write province&"<br>"
set rs=conn.execute("select * from area where depth=1")
do while not rs.eof
    city=city&rs("content")&","&rs("id")&","&rs("parentID")&"|"
    rs.movenext
loop
rs.close
set rs=nothing
' response.write city&"<br>"
set rs=conn.execute("select * from area where depth=2")
do while not rs.eof
    county=county&rs("content")&","&rs("id")&","&rs("parentID")&"|"
    rs.movenext
loop
rs.close
set rs=nothing
' response.write county
%>
<html>
<head>
<script language=javascript>
var provincestr="<%=province%>";
var citystr="<%=city%>";
var countystr="<%=county%>";
//拆分字符串
function splitstr(str,biaoji){
var splitstr=new Array;
splitstr=str.split(biaoji);
return splitstr;
}
function loadshuju(){
//装载省区
var province=new Array;
province=splitstr(provincestr,"|");
for(var i=0;i<province.length && province[i]!="";i++)
{
   var province_tmp=new Array;
   province_tmp=splitstr(province[i],",");
   document.getElementById("province").options.add(new Option(province_tmp[0],province_tmp[1]));
}
//装载市区
var city=new Array;
city=splitstr(citystr,"|");
for(var i=0;i<city.length && city[i]!="";i++)
{
   var city_tmp=new Array;
   city_tmp=splitstr(city[i],",");
   document.getElementById("city").options.add(new Option(city_tmp[0],city_tmp[1]));
}
//装载县区
var city=new Array;
county=splitstr(countystr,"|");
for(var i=0;i<county.length && county[i]!="";i++)
{
   var county_tmp=new Array;
   county_tmp=splitstr(county[i],",");
   document.getElementById("county").options.add(new Option(county_tmp[0],county_tmp[1]));
}
}
function changeArea(parentobj,chilobj,type){
chilobj.options.length=0;
var selectedvalue=parentobj.options[parentobj.selectedIndex].value;
if(type=="province")
{
   chilobj.options.add(new Option("==请选择市==",""));
   var city=new Array;
   city=splitstr(citystr,"|");
   for(var i=0;i<city.length && city[i]!="";i++)
   {
     var city_tmp=new Array;
     city_tmp=splitstr(city[i],",");
     if(city_tmp[2]==selectedvalue)
     document.getElementById("city").options.add(new Option(city_tmp[0],city_tmp[1]));
   }
}
else
{
   chilobj.options.add(new Option("==请选择县==",""));
   var city=new Array;
   county=splitstr(countystr,"|");
   for(var i=0;i<county.length && county[i]!="";i++)
   {
    var county_tmp=new Array;
    county_tmp=splitstr(county[i],",");
    if(county_tmp[2]==selectedvalue)
    document.getElementById("county").options.add(new Option(county_tmp[0],county_tmp[1]));
   }
}
}
function test(){
var provincevalue=document.getElementById("province").options[document.getElementById("province").selectedIndex].value;
var cityvalue=document.getElementById("city").options[document.getElementById("city").selectedIndex].value;
var countyvalue=document.getElementById("county").options[document.getElementById("county").selectedIndex].value;
alert("省："+provincevalue+"<br/>市："+cityvalue+"<br/>县："+countyvalue+"<br/>")
}
</script>
</head>
<body οnlοad="javascript:loadshuju()">

<form name="area">
<select id="province" οnchange="changeArea(document.getElementById('province'),document.getElementById('city'),'province')">
<option>==请选择省==</option>
</select>
<select id="city" οnchange="changeArea(document.getElementById('city'),document.getElementById('county'),'city')">
<option>==请选择市==</option>
</select>
<select id="county"><option>==请选择县==</option></select>
<input type="button" value="提交" οnclick="test()">
</form>
</body>
</html>