asp菜单联动
<script language="javascript">
function one_change()
{
var oid;
var string=new Array();
oid=forma.oneid.value;
outstring="<select name='twoid' id='twoid' onChange='two_change()'><option value='no'>请选择</option>"
<%
Set trs=server.CreateObject("adodb.recordset")
trs.open "select * from two order by orderid",conn,1,1
i=0
do while trs.eof=False
%>
string[<%=i%>]=new Array('<%=trs("oneid")%>','<%=trs("id")%>','<%=trs("twoname")%>')
<%
i=i+1
trs.movenext
loop
trs.close
Set trs=Nothing
%>
for (i=0 ;i<string.length;i++)
{
if (string[i][0]==oid)
{
outstring=outstring+"<option value='"+string[i][1]+"'>"+string[i][2]+"</option>";
}
}
outstring=outstring+"</select>";
document.all.twid.innerHTML=outstring;
document.all.thid.innerHTML="<select name='threeid' id='threeid'><option value='no'>请选择</option></select>";
}
function two_change()
{
var tid;
var strings=new Array();
tid=document.all.forma.twoid.value;
outstrings="<select name='threeid' id='threeid'><option value='no'>请选择</option>"
<%
Set trs=server.CreateObject("adodb.recordset")
trs.open "select * from three order by orderid",conn,1,1
i=0
do while trs.eof=False
%>
strings[<%=i%>]=new Array('<%=trs("twoid")%>','<%=trs("id")%>','<%=trs("threename")%>')
<%
i=i+1
trs.movenext
loop
trs.close
Set trs=Nothing
%>
for (i=0 ;i<strings.length;i++)
{
if (strings[i][0]==tid)
{
outstrings=outstrings+"<option value='"+strings[i][1]+"'>"+strings[i][2]+"</option>";
}
}
outstrings=outstrings+"</select>";
document.all.thid.innerHTML=outstrings;
//add
var tid;
var strings=new Array();
tid=document.all.forma.twoid.value;
outstrings="<select name='xiao' id='xiao'><option value='no'>请选择</option>"
<%
Set trs=server.CreateObject("adodb.recordset")
trs.open "select * from xiaoguo order by twoid",conn,1,1
i=0
do while trs.eof=False
%>
strings[<%=i%>]=new Array('<%=trs("twoid")%>','<%=trs("id")%>','<%=trs("name")%>')
<%
i=i+1
trs.movenext
loop
trs.close
Set trs=Nothing
%>
for (i=0 ;i<strings.length;i++)
{
if (strings[i][0]==tid)
{
outstrings=outstrings+"<option value='"+strings[i][1]+"'>"+strings[i][2]+"</option>";
}
}
outstrings=outstrings+"</select>";
}
</script>
<table><tr><td>这里放oneid select</td><td name="twid" id="twid">这里放twoid select</td><td name="thid" id="thid">这里放three select</td></tr></table>
一定要注意，在数据库里应该有三个表one ,two ,three
+++++++++++++++++++++++++++++++++++++++
<%
dim rs
dim sql
dim count
set rs=server.createobject("adodb.recordset")
sql = "select * from SmallClass order by SmallClassID asc"
rs.open sql,conn,1,1
%>
<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.myform.SmallClassName.length = 1;
var locationid=locationid;
var i;
for (i=0;i < onecount; i++)
{
if (subcat[i][1] == locationid)
{
document.myform.SmallClassName.options[document.myform.SmallClassName.length] = new Option(subcat[i][0], subcat[i][2]);
}
}
}
／／以上代码是读取数据库中的分类信息．这里有大类和小类．这样处理的目的是为了实现二级联动菜单（无刷新更新菜单）
++++++++++++++++++++++++++++++++++
<!--#include file="conn.asp"--><html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>New Page 1</title>
</head>
<body>
<%
dim rs
dim sql
dim count
set rs=server.createobject("adodb.recordset")
sql = "select * from shiinfo order by id asc"
rs.open sql,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("shiname"))%>","<%= trim(rs("shengcode"))%>","<%= trim(rs("id"))%>");
<%
count = count + 1
rs.movenext
loop
rs.close
%>
onecount=<%=count%>;
function changelocation(locationid)
{
document.form1.cid.length = 0;
var locationid=locationid;
var i;
for (i=0;i < onecount; i++)
{
if (subcat[i][1] == locationid)
{
document.form1.cid.options[document.form1.cid.length] = new Option(subcat[i][0], subcat[i][2]);
}
}
}
</SCRIPT>
<SCRIPT language="javascript">
<!--
function CheckForm()
{
document.form1.txtcontent.value=document.form1.doc_html.value;
return true
}
//-->
</SCRIPT>
<form name=form1 onsubmit="check()">
省份 <%
sql = "select * from shenginfo"
rs.open sql,conn,1,1
if rs.eof and rs.bof then
response.write "请先添加省份。"
response.end
else
%>
<SELECT name="sid" onChange="changelocation(document.form1.sid.options[document.form1.sid.selectedIndex].value)" ><%
do while not rs.eof
%><OPTION selected value="<%=trim(rs("id"))%>"><%=trim(rs("shengname"))%></OPTION>
<%
rs.movenext
loop
end if
rs.close
%>
</SELECT>
城市：<SELECT name="cid">
<OPTION selected value="">==请选城市==</OPTION>
</SELECT>
</form>
</body>
</html>
浙公网安备 33010602011771号