jsp页面如何实现二级联动菜单

[beibei_820]

我有一段代码是asp中实现二级联动菜单的，但是我想在jsp页面实现二级联动的效果，是不是可以更该如下的代码来实现，应该如何改？请高手帮忙！
<script language="JavaScript">
sall=new Array();
<%
dim i
i=0
set rs=server.CreateObject("adodb.recordset")
sql="select * from newsfl where ssdl<>0"
rs.open sql,link,1,1
if not rs.eof then
do until rs.eof
%>
sall[<%=i%>]=new Array("<%=rs("ssdl")%>","<%=rs("id")%>","<%=rs("newsfl")%>");
<%
i=i+1
rs.movenext
loop
end if
rs.close
set rs=nothing
%>
function changeselect(selvalue)
{
document.all.xl.length=0;
var selvalue=selvalue;
var i;
for(i=0;i<sall.length;i++)
{
if(sall[i][0]==selvalue)
{
var newOption1=new Option(sall[i][2],sall[i][0]);
document.all.xl.add(newOption1);
}
}
}
</script>

<select name="dl" ID="dl" onChange="changeselect(document.all.dl.options[document.all.dl.selectedIndex].value)">
<option>请选择</option>
<%
set rs=server.CreateObject("adodb.recordset")
sql="select * from newsfl where ssdl=0"
rs.open sql,link,1,1
do while not rs.eof
%>
<option value="<%=rs("id")%>"><%=rs("newsfl")%></option>
<%
rs.movenext
loop
rs.close
set rs=nothing
link.close
set link=nothing
%>
</select>
   <select name="xl" ID="xl">
<option>请选择</option>
</select>

[beibei_820]

有谁能帮我改改啊?

[beibei_820]

帮帮忙啊

[liaohaiying]

搜索一下，这版块里相当的二级关联多得去了，有代码给你还不会改吗，多研究研究

[大师]

把rs的部分改了,就应该好使了,类似于下面的代码:
/////////////////////////////////////////////////////////
script language="JavaScript">
sall=new Array();
<%

sql="select * from newsfl where ssdl<>0"
rs = dBBean.executeQuery(sql);
while(rs.next()){
%>
sall[<%=i%>]=new Array("<%=rs("ssdl")%>","<%=rs("id")%>","<%=rs("newsfl")%>");
<%
}
rs.close();
%>
function changeselect(selvalue)
{
document.all.xl.length=0;
var selvalue=selvalue;
var i;
for(i=0;i<sall.length;i++)
{
if(sall[i][0]==selvalue)
{
var newOption1=new Option(sall[i][2],sall[i][0]);
document.all.xl.add(newOption1);
}
}
}
</script>

<select name="dl" ID="dl" onChange="changeselect(document.all.dl.options[document.all.dl.selectedIndex].value)">
<option>请选择</option>
<%
sql="select * from newsfl where ssdl=0"
rs = dBBean.executeQuery(sql);
while(rs.next()){
%>
<option value="<%=rs("id")%>"><%=rs("newsfl")%></option>
<%
}
rs.close();
%>
</select>
   <select name="xl" ID="xl">
<option>请选择</option>
</select>

[to_beyond]

级联太麻烦，用ajax多简单

[GavinFj]

怎么没人帮忙改下```我也碰到这个问题，找到多是asp的二级菜单联动，都没jsp的...郁闷中ing