会员登陆
登录加载中...
超级搜索
栏  目  
类  别  
关键词  
 站内搜索   网络搜索
  
 当前位置:文章首页>>网页编程>>ASP实例>>三级联动下拉列表[数据库版]
推荐给你的朋友阅读:

三级联动下拉列表[数据库版]

来源:互联网 发表日期: 2005-12-15 12:19:25

    <%
    set rs=server.createobject("adodb.recordset")
    rs.open"select * from class_two",conn,1,1
    %>
    ‘---------以上是查询出第一级下拉列表的内容-----
     ’---------以下是用JS来控制程序--------------
    <script language = "JavaScript">
    var onecount; //定义onecount对像
    onecount=0;//初始值为0
    subcat = new Array(); //SUBCAT对像是一个新的数组
    <%
    count = 0 '定义count对像初始值为0
    do while not rs.eof '循环表头到表尾
    %>
    subcat[<%=count%>] = new Array("<%=rs("class_two_text")%>","<%=trim(rs("class_one"))%>","<%=trim(rs("class_two"))%>");
    //以上为重点内容,对像数组(subcat[count对像值])= 新数组内容('字段名0','字段名1','字段名2')记住要对应
    <%
    count = count + 1 '循环count一次,COUNT的值加1
    rs.movenext
    loop
    rs.close
    %>
    onecount=<%=count%>;
    function changelocation(locationid)
     {
     document.form.class_two.length = 0;
     var locationid=locationid;
     var i;
     for (i=0;i < onecount; i++)
    {
     if (subcat[1] == locationid)
     {
    document.form.class_two.options[document.form.class_two.length] = new Option(subcat[0], subcat[2]);
     }
    }
     }
    </script>
    <%
    set rs=server.CreateObject("adodb.recordset")
    rs.open "select * from Class_one" ,conn,1,1
    if rs.eof then
    response.Write"暂无产品一类名称"
    else%>
    产品一类
    <select name="class_one" id="class_one"
    onChange="changelocation(document.form.class_one.options[document.form.class_one.selectedIndex].value)">
     <%do while not rs.eof%>
     <option value="<%=rs("class_one")%>"><%=rs("class_one_text")%></option>
     <%rs.movenext
     loop
     end if
     %>
    </select>
    产品二类
    <select name="class_two"
    onChange="three(document.form.class_one.value,document.form.class_two.options[document.form.class_two.selectedIndex].value)">
    <option value="请选择条件" selected>请选择条件</option>
    </select> <%
    set rs=server.createobject("adodb.recordset")
    rs.open"select * from class_three",conn,1,1
    %> <script language = "JavaScript">
    var twocount;
    twocount=0;
    subthree = new Array();
    <%
    countb = 0
    do while not rs.eof
    %>
    subthree[<%=countb%>] = new
    Array("<%=rs("class_three_text")%>","<%=trim(rs("class_one"))%>","<%=trim(rs("class_two"))%>","<%=trim(rs("class_three"))%>");
    <%
    countb = countb + 1
    rs.movenext
    loop
    rs.close
    %>
    twocount=<%=countb%>;
    function three(threeid,threeid2)
     {
     document.form.class_three.length = 0;
     var threeid=threeid;
     var threeid2=threeid2;
     var i;
     for (i=0;i < twocount; i++)
    {
     if ((subthree[1] == threeid) & (subthree[2] == threeid2))
     {
    document.form.class_three.options[document.form.class_three.length] = new Option(subthree[0],
    subthree[3]);
     }
    }
     }
    </script>
    产品三类
    <select name="class_three" id="class_three">
    <option value="0" selected>请选择条件</option>
    </select>

3
0
[作者:不详 关键词:下拉列表 录入:CEO 责编:CEO 阅读次数:13369]
上一记录:前进后退按钮
下一记录:拆分字符进行sql查询

相关文章 相关新闻 相关软件 相关教程 公共评论 发表评论

  • ·暂无相关内容
  • ·暂无相关内容
  • ·暂无相关内容
    评论载入中...
    您的称呼  验 证 码   
    您的评论 [ 最多字数:  已用字数:剩余字数:]

     
COPYRIGHT 2003-2010 创意飞腾科技有限公司(The Feitec LTD.) ALL RIGHTS RESERVED .
官方咨询官方咨询4376161 官方咨询526743959 技术支持:FeitecCMS5366464
页面加载时间:281.25ms Powered By:FeitecCMS V4.0(Build1101)
[蜀ICP备05000881]