ASP二级分类联动菜单

来源：互联网发布：计算机2级c语言题库编辑：程序博客网时间：2024/05/01 06:19

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="style.css" rel="stylesheet" type="text/css">
</head>
<%
A = request.Form("anclassid")
B = request.Form("Nclassid")
if request.Form("Submit")="提交" then
   response.Write "a="&A
   response.Write "<br>b="&B
   response.End()
end if

dim count

set rs=server.createobject("adodb.recordset")
'--------取出小类里的数据,Nclassidorder：小类在大类里的ID号
rs.open "select * from class order by id ",conn,1,1%>

<script language = "JavaScript">
var onecount;
onecount=0;
subcat = new Array();
<%
   count = 0
   do while not rs.eof
%>

subcat[<%=count%>] = new Array("<%= trim(rs("class_name"))%>","<%= rs("v_school")%>","<%= rs("id")%>");
<%
        count = count + 1
        rs.movenext
        loop
        rs.close
%>

onecount=<%=count%>;

function changelocation(locationid)
    {
    document.myform.Nclassid.length = 0;

    var locationid=locationid;
    var i;
    for (i=0;i < onecount; i++)
        {
            if (subcat[i][1] == locationid)
            { //这句不是很理解
             document.myform.Nclassid.options[document.myform.Nclassid.length] = new Option(subcat[i][0], subcat[i][2]);
            }
        }

    }
</script>
<body>
<table cellpadding="3" cellspacing="1" border="0" width="100%" class="tableBorder" align=center>
<tr height=25>
   <th class="tableHeaderText" colspan=6 height=25>添加新商品</th>
</tr>
<tr>
   <td class="forumRowHighlight" >
    <table align=center>
        <form name="myform" method="post" action="test.asp" OnSubmit="return checkkk()" >
          <tr>
            <td width="8%"> </td>

            <td colspan="2">
              <p>
                <%
   rs.open "select * from school order by school_id",conn,1,1
   '-----------列出大类数据
   if rs.eof and rs.bof then
   response.write "请先添加栏目。"
   response.end
   else
%>
              大类：
              <select name="anclassid" size="1" id="anclassid" onChange="changelocation(document.myform.anclassid.options[document.myform.anclassid.selectedIndex].value)">
              
                <option selected value="<%=rs("school_id")%>"><%=trim(rs("name"))%></option>
                <%      dim selclass
       '--------selclass是临时赋值器,小类展开时会用到
         selclass=rs("school_id")
        rs.movenext
        do while not rs.eof
%>
                <option value="<%=rs("school_id")%>"><%=trim(rs("name"))%></option>
                <%
        rs.movenext
        loop
       end if
        rs.close
%>
              </select>
              　小类：
              <select name="Nclassid">
              
                <%rs.open "select * from class where v_school="&selclass ,conn,1,1
if not(rs.eof and rs.bof) then
%>              
                <option selected value="<%=rs("id")%>"><%=rs("class_name")%></option>
                <% rs.movenext
do while not rs.eof%>
                <option value="<%=rs("id")%>"><%=rs("class_name")%></option>
                <% rs.movenext
loop
end if
        rs.close
        set rs = nothing
%>
              </select>
              </p>
              <input type="submit" name="Submit" value="提交"></td>
          </tr>

          </form>
</table>
</body>
</html>