二级联动 无法使用!大家帮我看看啊~
<%@ page contentType= "text/html; charset=gb2312 " language= "java " import= "java.util.*,java.sql.*,com.yourcompany.struts.database.NewsBean,com.yourcompany.struts.form.* " %>
<%
NewsBean Conn=new NewsBean();
ResultSet rs;
%>
<html>
<head>
<title> 后台产品添加 </title>
<script language = "JavaScript ">
var onecount;
onecount=0;
subcat = new Array();
<%
int count = 0;
rs = Conn.executeQuery( "select * from category order by categoryno ");//读取数据
while(rs.next())
{
String sname=new String(rs.getString( "categoryname ").getBytes( "GBK "), "ISO8859_1 ");//转换字符类型
%>
subcat[ <%=count%> ] = new Array( " <%=sname%> ", " <%=rs.getInt( "belong ")%> ", " <%=rs.getInt( "categoryno ")%> ");//产生数组
<%
count = count + 1;
}
%>
onecount= <%=count%> ;
function changelocation(id)
{
document.form1.smallsortselect.length = 0;
var id=id;
var i;
document.form1.smallsortselect.options[0] = new Option( ' ' ' '选择二级分类 ' ' ' ', ' ' ' ' ' ' ' ');
for (i=0;i < onecount; i++)
{
if (subcat[i][1] == id)
{
document.form1.smallsortselect.options[document.form1.smallsortselect.length] = new Option(subcat[i][0], subcat[i][2]);
}
}
}
</script>
</head>
<body bgcolor= "#FFFFFF ">
<form name= "form1 " method= "post " action= " ">
<table width= "500 " border= "0 " cellspacing= "0 " cellpadding= "0 " align= "center ">
<tr>
<td width= "180 " height= "20 " align= "right "> 选择一级分类: </td>
<td width= "320 ">
<select name= "bigsortselect " onChange= "changelocation(document.form1.bigsortselect.options[document.form1.bigsortselect.selectedIndex].value) " size= "1 ">
<option value= "2 "> 请选择一级分类 </option>
<%
rs = Conn.executeQuery( "select * from layout order by layoutno ");
while(rs.next())
{
String Bname = new String(rs.getString( "layoutname ").getBytes( "GBK "), "ISO8859_1 ");
System.out.println(Bname);
%>
<option value= " <%=rs.getInt( "layoutno ")%> "> <%=Bname%> </option>
<%
}
%>
</select> <br>
</td>
</tr>
<br>
<tr>
<td height= "20 " align= "right "> 选择二级分类: </td>
<td>
<select name= "smallsortselect ">
<option value= " " selected> 请选择二级分类 </option>
</select>
</td>
</tr>
<tr>
<td height= "20 " colspan= "2 " align= "center "> <input type= "submit " name= "Submit " value= "提交 "> </td>
</tr>
<script LANGUAGE= "JavaScript ">
changelocation(document.form1.bigsortselect.options[document.form1.bigsortselect.selectedIndex].value); //将一级分类的value传给changelocation()函数,生成二级分类的列表
</script>
</table>
</form>
</body>
</html>
改动不大,只是sql语句 executeQuery()返回一个ResultSet,我是照这个地址的文章改的:
http://www.5inet.net/WebPrograming/JSP/068749,jspZhong,ShiYongjsShengChengDongTaiDeShuJuKuXiangGuanDeErJiLianDongXiaLaKuang.aspx
编译和运行都没错误,一级菜单正常显示,但点了之后二级出不来,我的几个字段分别表示的意思:
layout表-------
layoutname 版面名
layoutno 版面号
category表-------
categoryname 分类名
categoryno 分类号
belong 隶属的版面号
[解决办法]
出售以下资料、代码
1.JSP编程技巧百问集锦(100个问题;一个问题一段代码) 报价:30 RMB
2.ASP编程技巧百问集锦(100个问题;一个问题一段代码) 报价:30 RMB
3.JavaScript编程技巧百问集锦(100个问题;一个问题一段代码) 报价:20 RMB
4. <在线书店系统> 大解密(jsp+javabean+servlet Web版 全套源码 安装即用) 报价:150 RMB
5. <OA办公自动化系统> 大解密(jsp+javabean+servlet Web版 全套源码 安装即用) 报价:300 RMB
需要者请联系:e_mail:fzlotuscn@yahoo.com.cn QQ:595563946