asp数据库联动菜单
数据库名:class表名:class字段:code(类码)、b_class(大类)、m_class(中类)、m_class(小类)请高手帮忙做一个从数据库里读的联动菜单，...
数据库名:class
表名:class
字段:code(类码)、b_class(大类)、m_class(中类)、m_class(小类)
请高手帮忙做一个从数据库里读的联动菜单，请不要给代码让我自己修改，最好是直接能用的。
回答满意的话，我要加分 展开
表名:class
字段:code(类码)、b_class(大类)、m_class(中类)、m_class(小类)
请高手帮忙做一个从数据库里读的联动菜单，请不要给代码让我自己修改，最好是直接能用的。
回答满意的话，我要加分 展开
1个回答
展开全部
补充一下:你的数据库结构好像有问题
以前我在经典发过一个
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<script language="JavaScript" src="selectarea.js"></script>
<title>蓝木设计——省市县三级地名数据库自动联动系统</title>
</head>
<body>
<select name="city1" id="city1" onChange="changepro('city2','city1');">
<option value="" selected>省/直辖市</option>
<%
Set Rs = GetRs("select code,b_class from class")
while not Rs.eof
Response.Write "<option value='" & Rs(0) & "'>" & Rs(1) & "</option>"
Rs.movenext
wend
Rs.Close
Set Rs = nothing
%>
</select>
<select name="city2" id="city2" onChange="changecity('city3','city2');">
<option value="">请选择</option>
</select>
<select name="city3" id="city3">
<option value="">请选择</option>
</select>
</body>
</html>
<script>
var lmcount;
var lmcount2;
lm=new Array();
lm2=new Array();
<%
i=0
Set Rs = GetRs("select m_class from class")
while not Rs.eof
Set Rs1 = GetRs("select s_class from class where 属于上面中类的小类"
while not Rs1.eof
Response.Write "lm[" & i & "] = new Array('" & Rs1(0) & "','" & Rs(0) & "')"
Rs1.movenext
wend
count1 = Rs1.Recordcount
Rs1.Close
Set Rs1 = nothing
wend
count2 = Rs2.Recordcount
Rs.Close
Set Rs = nothing
%>
lmcount=<%=count1%>;
lmcount2=<%=count2%>;
function changepro(city,pro)
{
var city=city;
var pro=document.getElementById(pro).value;
var i;
document.getElementById(city).length=1;
for (i=0;i<lmcount;i++){
if (lm[i][1]==pro){
document.getElementById(city).options[document.getElementById(city).length]=new Option(lm[i][0], lm[i][0]);
}
}
}
function changecity(county,city)
{
var county=county;
var city=document.getElementById(city).value;
var j;
document.getElementById(county).length=1;
for (j=0;j<lmcount2;j++){
if (lm2[j][1]==city){
document.getElementById(county).options[document.getElementById(county).length]=new Option(lm2[j][0], lm2[j][0]);
}
}
}
</script>
以前我在经典发过一个
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<script language="JavaScript" src="selectarea.js"></script>
<title>蓝木设计——省市县三级地名数据库自动联动系统</title>
</head>
<body>
<select name="city1" id="city1" onChange="changepro('city2','city1');">
<option value="" selected>省/直辖市</option>
<%
Set Rs = GetRs("select code,b_class from class")
while not Rs.eof
Response.Write "<option value='" & Rs(0) & "'>" & Rs(1) & "</option>"
Rs.movenext
wend
Rs.Close
Set Rs = nothing
%>
</select>
<select name="city2" id="city2" onChange="changecity('city3','city2');">
<option value="">请选择</option>
</select>
<select name="city3" id="city3">
<option value="">请选择</option>
</select>
</body>
</html>
<script>
var lmcount;
var lmcount2;
lm=new Array();
lm2=new Array();
<%
i=0
Set Rs = GetRs("select m_class from class")
while not Rs.eof
Set Rs1 = GetRs("select s_class from class where 属于上面中类的小类"
while not Rs1.eof
Response.Write "lm[" & i & "] = new Array('" & Rs1(0) & "','" & Rs(0) & "')"
Rs1.movenext
wend
count1 = Rs1.Recordcount
Rs1.Close
Set Rs1 = nothing
wend
count2 = Rs2.Recordcount
Rs.Close
Set Rs = nothing
%>
lmcount=<%=count1%>;
lmcount2=<%=count2%>;
function changepro(city,pro)
{
var city=city;
var pro=document.getElementById(pro).value;
var i;
document.getElementById(city).length=1;
for (i=0;i<lmcount;i++){
if (lm[i][1]==pro){
document.getElementById(city).options[document.getElementById(city).length]=new Option(lm[i][0], lm[i][0]);
}
}
}
function changecity(county,city)
{
var county=county;
var city=document.getElementById(city).value;
var j;
document.getElementById(county).length=1;
for (j=0;j<lmcount2;j++){
if (lm2[j][1]==city){
document.getElementById(county).options[document.getElementById(county).length]=new Option(lm2[j][0], lm2[j][0]);
}
}
}
</script>
本回答由提问者推荐
已赞过
已踩过<
评论
收起
你对这个回答的评价是？
推荐律师服务：
若未解决您的问题，请您详细描述您的问题，通过百度律临进行免费专业咨询
