下拉列表框三级连动三

最新推荐文章于 2015-09-09 18:22:00 发布

布丁88

最新推荐文章于 2015-09-09 18:22:00 发布

阅读量518

点赞数

文章标签： sql javascript function class action 数据库

本文链接：https://blog.csdn.net/qyweiyy88/article/details/2033495

版权

<html>
<head>

<%
'连接数据库表
sql1= "select * from shop_anclass"
sql2= "Select * from shop_nclass"
sql3= "select * from sssort"
set rs=server.CreateObject("adodb.recordset") '创建 rs 数据查询
%>
<% rs.open sql2,conn,1,1 %>
<script LANGUAGE="JAVASCRIPT">
var onecount; //定义子类计数
onecount=0; //设置子类计数默认值为0
subcat = new Array(); //定义显示子类数组
<% count = 0
i=0
do while not rs.eof %>
subcat[<%=count%>] = new Array("<%=rs("nclass")%>","<%=rs("anclassid")%>","<%=rs("nclassidorder")%>");
<% count = count + 1
i=i+1
rs.movenext
loop
rs.close
%>
onecount=<%=count%>; //子类条目总数
<% rs.open sql3,conn,1 %>
var osubnecount; //定义子类计数
subonecount=0; //设置子类计数默认值为0
subsubcat = new Array(); //定义显示子类数组
<% subcount = 0
do while not rs.eof %>
subsubcat[<%=subcount%>] = new Array("<%=rs("class")%>","<%=rs("nclassidorder")%>","<%=rs("classid")%>");
<% subcount = subcount + 1
rs.movenext
loop
rs.close
%>
subonecount=<%=subcount%>;
function changelocation(locationid)
{
document.reg.two_cate.length = 0;
document.reg.three_cate.length = 0;
var locationid=locationid;
var i;
for (i=0;i < onecount; i++)
{
if (subcat[i][1] == locationid)
{
document.reg.two_cate.options[document.reg.two_cate.length] = new Option(subcat[i][0], subcat[i][2]);
}
}
for (i=0;i < onecount; i++)
{
if (subsubcat[i][1] ==document.reg.two_cate.options.value)
{
document.reg.three_cate.options[document.reg.three_cate.length] = new Option(subsubcat[i][0], subsubcat[i][2]);
}
}
}
</script>
<% rs.open sql3,conn,1 %>
<script LANGUAGE="JAVASCRIPT">
var osubnecount; //定义子类计数
subonecount=0; //设置子类计数默认值为0
subsubcat = new Array(); //定义显示子类数组
<% subcount = 0
do while not rs.eof %>
subsubcat[<%=subcount%>] = new Array("<%=rs("class")%>","<%=rs("nclassidorder")%>","<%=rs("classid")%>");
<% subcount = subcount + 1
rs.movenext
loop
rs.close
%>
subonecount=<%=subcount%>; //子类条目总数
function subchangelocation(sublocationid)
{
document.reg.three_cate.length = 0;

var sublocationid=sublocationid;
var i;
for (i=0;i < subonecount; i++)
{
if (subsubcat[i][1] == sublocationid)
{
document.reg.three_cate.options[document.reg.three_cate.length] = new Option(subsubcat[i][0], subsubcat[i][2]);
}
}

}

</script>

</head>
<body>

<div>
<%rs.open sql1,conn,1,1

if rs.eof and rs.bof then
response.write "errorNothing_"
response.end
else
%>
总分类:<select name="main_cate" id="se" onChange="changelocation(document.reg.main_cate.options[document.reg.main_cate.selectedIndex].value)" size="1">
<option selected value="">请您选择总分类</option>
<% do while not rs.eof %>
<option value="<%=trim(rs("anclassid"))%>">
<%=trim(rs("anclass"))%>
</option>
<% rs.movenext
loop
rs.close
end if %>
</select>  大类
<select name="two_cate" id="se" onChange="subchangelocation(document.reg.two_cate.options[document.reg.two_cate.selectedIndex].value)">
<option selected value="">请您选择大类</option>
</select>
 小类
<select name="three_cate" id="se">
<option selected value="">请您选择小类</option>
</select>
<% set rs = nothing%>

</div>

布丁88

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
下拉列表框三级连动三

连接数据库表sql1= "select * from shop_anclass"sql2= "Select * from shop_nclass"sql3= "select * from sssort"set rs=server.CreateObject("adodb.recordset") 创建 rs 数据查询%>var onecount; //定义子类计数onecount=0; //设置子
复制链接

扫一扫