如何用Dreamweaver实现2级关联下拉菜单! 最好给出代码解释,感谢!
前一个下拉显示大类
后一下随大类的改变显示针对大类的小类。
请高手赐教。
我搞了好多时间了,还是搞不明白。我这里有别人现成的,但是分析不出具体的实现原理! <!--#include file="conn.asp"-->
<html>
<meta http-equiv="Content-Type" content="text/html;charset=gb2312">
<link rel="stylesheet" type="text/css" href="inc/style.css">
<%dim rs,sql,count
set rs=server.createobject("adodb.recordset")
sql="select * from ANclass order by Nclassid 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("<%=(rs("Nclass"))%>","<%=(rs("classid"))%>","<%=(rs("Nclassid"))%>");
<%count=count+1
rs.movenext
loop
rs.close%>
onecount=<%=count%>;
function changelocation(locationid)
{myform.Nclassid.length=0;
var locationid=locationid;
var i;
for(i=0;i<onecount;i++)
{if(subcat[1]==locationid)
{myform.Nclassid.options[myform.Nclassid.length]=new Option(subcat[0],subcat[2]);}}}
</script>
<title>2级连动</title><body onLoad="myform.classid.focus()">
<form method="POST" name="myform" action="">
<center>
<tr>
<td width="100%" class="title" height="30" align=center> </td>
</tr>
<tr align="center">
<td class="tdbg1" width="100%">
<table border="0" cellspacing="1" width="100%">
<tr>
<td width="15%" align="right" valign="top" height="20"> </td>
<td width="85%">
<p>
<%sql="select * from Aclass"
rs.open sql,conn,1,1
if rs.eof and rs.bof then
response.write "请先添加栏目。"
response.end
else%>
<select name="classid" id="classid" onChange="changelocation(myform.classid.options[myform.classid.selectedIndex].value)" size="1">
<option selected value="<%=(rs("classid"))%>"><%=(rs("class"))%></option>
<%dim selclass
selclass=rs("classid")
rs.movenext
do while not rs.eof%>
<option value="<%=(rs("classid"))%>"><%=(rs("class"))%></option>
<%rs.movenext
loop
end if
rs.close%>
</select>
<select name="Nclassid">
<%sql="select * from ANclass where classid="&selclass
rs.open sql,conn,1,1
if not(rs.eof and rs.bof) then%>
<option selected value="<%=rs("NclassID")%>"><%=rs("Nclass")%></option>
<%rs.movenext
do while not rs.eof%>
<option value="<%=rs("NclassID")%>"><%=rs("Nclass")%></option>
<%rs.movenext
loop
end if
rs.close
set rs=nothing
conn.Close
set conn=nothing%>
</select></p>
</td>
</tr>
</table> </td>
</tr>
</center>
</form>
<p> </p>
<p></p>
</body>
</html>
数据库数据设置:
大类:
"classID" "class" "hidden"
1 "Net专区" 0
2 "ASP技术" 0
3 "PHP技术" 0
4 "JSP技术" 0
5 "数据库" 0
6 "图像设计" 1
7 "闪客帝国" 1
8 "网站建设" 0
10 "安全相关" 0
11 "数码时尚" 1
12 "软件网络" 0
14 "电脑硬件" 0
15 "Delphi技术" 0
16 "VB专区" 0
18 "游戏部落" 1
19 "服务器技术" 0
小类: "Nclassid" "Nclass" "classID" 5 "安全加密" 2
6 "Asp.Net开发" 1
7 "C#语言" 1
8 "VB.net语言" 1
9 "E-mail专题" 1
10 "WebService" 1
11 "XML应用" 1
12 "面向对象程序基础" 1
13 "算法/线程" 1
14 "综合应用" 1
15 "软件工程" 1
16 "ASP基础" 2
17 "ASP应用" 2
18 "ASP技巧" 2
19 "性能优化" 2
21 "XML相关" 2
22 "全文检索" 2
23 "客户端相关" 2
24 "打印相关" 2
25 "数据库相关" 2
26 "邮件处理" 3
27 "入门教程" 3
29 "XML应用" 3
30 "图像处理" 3
31 "数据库操作" 3
32 "文件处理" 3
33 "FTP/HTTP/Debug" 3
34 "开发工具" 4
35 "调试手记" 4
36 "面向对象/设计" 4
37 "企业级应用" 4
38 "嵌入式开发" 4
39 "Java与XML" 4
40 "资料/其它" 4
41 "Application/Applet" 4
42 "J2EE/EJB/服务器" 4
43 "J2ME开发" 4
44 "Java基础" 4
45 "Java技巧及代码" 4
46 "Jsp/Servlet" 4
47 "MS Access" 5
48 "MS SQL" 5
49 "DB2" 5
50 "Oracle" 5
51 "MySQL" 5
52 "Sybase" 5
53 "DataWarehouse" 5
54 "Replication" 5
55 "Performance Turning" 5
56 "FAQ" 5
57 "Winform应用" 1
58 "WindowsApp开发" 1
59 "WinSock应用" 1
60 "数据库应用" 1
61 "OO相关" 1
62 "文件操作" 1
63 "SOAP/UDDI/WSDL" 1
64 "控件开发和使用" 1
65 ".NET概论及软件使用" 1
66 "正则表达式" 2
68 "代码荟萃" 8
69 "黑客新闻" 10
71 "Windows基础" 12
73 "nLite应用" 12
74 "拇指一族" 11
75 "数码相机" 11
76 "注册表" 12
77 "硬件诊断" 14
78 "使用技巧" 14
79 "硬件知识" 14
80 "编程实例" 15
81 "编程技巧" 16
82 "Delphi技巧" 15
83 "建站技巧" 8
84 "PHP技巧" 3
85 "IE专区" 12
94 "黑客文化" 10
95 "网站教程" 10
96 "系统补丁" 12
98 "系统安全" 12
100 "网络诊断" 12
101 "Windows入侵" 10
102 "黑客例程" 10
110 "网络设置" 12
111 "网络管理" 12
113 "Windows技巧" 12
114 "攻略秘籍" 18
115 "软件破解" 12
117 "硬件优化" 14
119 "病毒与木马" 12
120 "系统诊断" 12
121 "网络安全" 12
122 "组网玩网" 12
123 "Flash技巧" 7
124 "域名服务" 19
125 "操作系统相关" 12
126 "远程脚本" 2
127 "脚本编码" 2
128 "组件开发" 2
129 "系统相关" 2
130 "FSO专题" 2
131 "PHP函数" 3
132 "PHP基础" 3
133 "PHP安装" 3
134 "PHP应用" 3
135 "PHP其它文章" 3
136 "系统相关" 3
137 "网络相关" 3
138 "数据库相关" 4
139 "邮件相关" 4
140 ".NET Framework" 1
141 "安全和优化" 1
142 "安装和部署" 1
143 "报表/图形/Office" 1
144 "评论及其它" 1
145 "远程及网络应用" 1
146 "邮件服务" 19
147 "文件服务" 19
148 "网络技术" 19
149 "数据库服务" 19
150 "评论观点说法" 19
151 "解决方案" 19
152 "建站经验杂谈" 19
153 "防火墙和路由" 19
154 "代理服务" 19
155 "操作系统" 19
156 "安全与管理" 19
157 "WEB服务" 19
158 "FTP服务" 19
159 "DHCP服务" 19
163 "网页制作" 8
164 "多媒体相关" 12
165 "密码破解" 10
166 "上传下载" 12
168 "CGI 相关" 19
请高手帮忙分析,提供源码!感谢!
我的email:aidybnt@gmail.com[ 此贴被aidybnt在2007-05-14 17:15重新编辑 ]