JS级联问题
下面为一产品管理后台的添加项
添加大小类
请选择大类 请选择小类
a aa aaa
b bb bbb
c cc ccc
如果是这样
第一次的时候选a 小类会自动显示aa,aaa,再选b的时候小类也会显示bb bbb,C也一样,然后我再"选回"
"请选择大类"的时候,那么小类显示的刚才选择的那个小类(也就是会选择最后一次选择的那个小类)
麻烦帮忙改一下谢谢
代码很长,其实就是JS那一块和SELECT那一块这二部分
<%@ page contentType="text/html; charset=GBK" import="java.sql.*,website1.common.*,website1.db.*,website1.bean.*,java.util.*"%>
<% /*此为产品分类数据库部分*/
Connection conn=DBConnection.getConnection();
ResultSet rs=null;
ArrayList PcAl=null;
productclassBean pcb=null;
PreparedStatement pst=null;
try{
pst=conn.prepareStatement("select * from productclass ");
rs=pst.executeQuery();
PcAl=new ArrayList();
while(rs.next()){
pcb=new productclassBean();
pcb.setId(rs.getString("id"));
pcb.setClassname(rs.getString("classname"));
pcb.setPid(rs.getString("pid"));
pcb.setContext(rs.getString("context"));
pcb.setCreatetime(rs.getString("createtime"));
PcAl.add(pcb);
}
}catch(Exception ex){
ex.printStackTrace();
}finally{
rs.close();
pst.close();
conn.close();
}
%>
<script language = "JavaScript">
var onecount;
subcat = new Array();
<%
int count = 0;
for(;count<PcAl.size();count++){
pcb=(productclassBean)PcAl.get(count);
%>
subcat[<%=count%>] = new Array("<%=pcb.getId()%>","<%=pcb.getClassname().trim()%>","<%=pcb.getPid()%>");
<%
}
%>
onecount=<%=count%>;
function changelocation(locationid)
{
document.searchform.smallclass.length = 1;
var locationid=locationid;
var i;
for (i=0;i < onecount; i++)
{
if (subcat[i][2] == locationid)
{
document.searchform.smallclass.options[document.searchform.smallclass.length] = new Option(subcat[i][1], subcat[i][0]);
}
}
}
</script>
<html>
<link href="image/southidc.css" rel="stylesheet" type="text/css">
<body>
<table width="100%" height="100%" border="0" align="center" cellpadding="0" cellspacing="0">
</table>
<table width="80%" height="0%" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
<tr>
<td valign="middle"><table width="100%" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#97B5D2">
<tr>
<td><table width="100%" height="28" border="0" cellpadding="0" cellspacing="0" background="Image/titlebg.gif" bgcolor="#FFFFFF">
<tr>
<td align="center">添加产品</td>
</tr>
</table></td>
</tr>
<tr>
<td><table width="100%" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#D6E7F8">
<tr>
<td width="100%"><table width="100%" height="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="100%" align="center" valign="top">
<form action="product_madd_p.jsp" method="POST" name="searchform" target="_self" id="searchform" onSubmit="return CheckForm();">
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0" class="border">
<tr>
<td height="20" align="center" class="title"></td>
</tr>
<tr align="center">
<td class="tdbg"><table width="100%" border="0" cellpadding="0" cellspacing="2">
<tr>
<td width="155" height="22" align="right"><font color="#FF0000">*</font>所属类别:</td>
<td width="124" height=28><p>
<select name="bigclass" onChange="changelocation(document.searchform.bigclass.options[document.searchform.bigclass.selectedIndex].value)">
<option value="0">所有大类</option>
<%for(int i=0;i<PcAl.size();i++){
pcb=(productclassBean)PcAl.get(i);
if(pcb.getPid().equals("0")){
%>
<option value="<%=pcb.getId()%>"><%=pcb.getClassname()%></option>
<%}}%>
</select>
</p>
<td width="328"><select name="smallclass" id="smallclass">
<option value="0" selected>所有小类</option>
</select>
</tr>
<tr>
<td width="155" height="22" align="right"><font color="#FF0000">*</font>产品名称:</td>
<td colspan="2"><input name="title" type="text" id="Title2" size="50" maxlength="80"> </td>
</tr>
<tr>
<td align="right" valign="middle"><div align="right">
<textarea name="Content" style="display:none" rows="1" cols="20"></textarea>
录入时间: </div></td>
<%java.util.Date date=new java.util.Date();%>
<td colspan="2" align="right" valign="middle"><div align="left"><%=date.toLocaleString().substring(0,10)%></div></td>
</tr>
<tr>
<td align="right"><font color="#FF0000">*</font>产品说明:</td>
<td height="96" colspan="2"><textarea name="context" cols="65" rows="10" id="context" height="96"></textarea></td>
</tr>
<tr>
<td width="155" height="22" align="right" valign="bottom"><br>
<font color="#FF0000">*</font>产品图片:<br></td>
<td colspan="2"><iframe id="upload" src="upload.jsp?data=product&id=3&style=add" frameborder="0" height="40" scrolling="no" ></iframe></td>
</tr>
</table></td>
</tr>
</table>
<div align="center">
<p><input name="Add" type="submit" id="Add" value="添加" onClick="">
<input type="reset" name="Submit" value="重置">
</p>
</div>
</form></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table>
</html>