编程论坛 → ASP技术论坛

[求助]请问二级下拉菜单导航如何读取数据库中分类啊?

xiaozhou2008 发布于 2008-02-09 14:55， 997 次点击

普通的导航菜单都只能读取固定的链接,我有2个表,bigclass和smallclass,请问如何制作二级下拉菜单,让菜单中读取数据库中的大类和小类啊?哪位大虾给段代码,谢谢了!!!!

1 回复

#2

214112008-02-10 22:15

<script language = "JavaScript">
var onecount;
subcat = new Array();
        <%
        count = 0
        do while not rs.eof
        %>
subcat[<%=count%>] = new Array("<%= trim(rs("SmallClassName"))%>","<%= trim(rs("BigClassName"))%>","<%= trim(rs("SmallClassName"))%>");
        <%
        count = count + 1
        rs.movenext
        loop
        rs.close
        %>
onecount=<%=count%>;

function changelocation(locationid)
    {
    document.addNEWS.SmallClassName.length = 1;
    var locationid=locationid;
    var i;
    for (i=0;i < onecount; i++)
        {
            if (subcat[i][1] == locationid)
            {
                document.addNEWS.SmallClassName.options[document.addNEWS.SmallClassName.length] = new Option(subcat[i][0], subcat[i][2]);
            }
        }
    }

function CheckForm()
{
     document. = document.(true);
     document.addNEWS.imageNum.value = document.("editImageNum").value;
     document.addNEWS.editFirstImageName.value = document.("editFirstImageName").value;

    if (document.addNEWS.title.value.length == 0) {
        alert("文章标题没有填写.");
        document.addNEWS.title.focus();
        return false;
    }
        if (document.addNEWS.user.value.length == 0) {
        alert("文章发布人没有填写");
        document.addNEWS.user.focus();
        return false;
    }
    return true;
}
</script>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="../css.css" type="text/css">
<title>添加文章</title>
<style type="text/css">

</style></head>

<body leftmargin="0" topmargin="0" bgcolor="#ECE9D8">
<br>
<table width="65%" border="0" align="center" cellpadding="1" cellspacing="1" bgcolor="#245DDB">
  <form name="addNEWS" method="post" action="addinfo_ok.asp" onSubmit="return CheckForm();">
    <tr bgcolor="#FFFFFF">
      <td height="25" bgcolor="#245DDB"><div align="center" class="style1">文章添加</div></td>
    </tr>
    <tr bgcolor="#FFFFFF">
      <td height="25">
        <font color="#245DDB">*</font>文章标题：<input name="title" type="text" class="input" size="30"></td>
    </tr>
    <tr bgcolor="#FFFFFF">
      <td height="25">
        <font color="#245DDB">*</font>文章类别：<%
        sql = "select * from BigClass"
        rs.open sql,conn,1,1
        if rs.eof and rs.bof then
            response.write "请先添加栏目。"
        else
        %>
        <select name="BigClassName" onChange="changelocation(document.addNEWS.BigClassName.options[document.addNEWS.BigClassName.selectedIndex].value)" size="1">
          <option selected value="<%=trim(rs("BigClassName"))%>"><%=trim(rs("BigClassName"))%></option>
          <%
            dim selclass
            selclass=rs("BigClassName")
            rs.movenext
            do while not rs.eof
            %>
          <option value="<%=trim(rs("BigClassName"))%>"><%=trim(rs("BigClassName"))%></option>
          <%
                rs.movenext
            loop
        end if
        rs.close
            %>
        </select>        <select name="SmallClassName">
          <option value="" selected>不指定小类</option>
          <%
            sql="select * from SmallClass where BigClassName='" & selclass & "'"
            rs.open sql,conn,1,1
            if not(rs.eof and rs.bof) then
            %>
          <option value="<%=rs("SmallClassName")%>"><%=rs("SmallClassName")%></option>
          <% rs.movenext
                do while not rs.eof%>
          <option value="<%=rs("SmallClassName")%>"><%=rs("SmallClassName")%></option>
          <%
                    rs.movenext
                loop
            end if
            rs.close
            %>
          <%
            ranNum=int(9*rnd)+10
            iddata=month(now)&day(now)&hour(now)&minute(now)&second(now)&ranNum
            %>
      </select></td>
    </tr>

1