<%@ page import="java.sql.*" contentType="text/html;charset=GBK"%>
<jsp:useBean id="query" scope="session" class="weblistbean.QueryBean" />
<jsp:setProperty name="DBCaoZuo" property="*"/>
<html>
<head>
<title>后台产品添加</title>
<meta http-equiv="Content-Type" content="text/HTML; charset=gb2312">
<link href="../INC/Style.Css" rel="stylesheet" type="text/css"><script language = "JavaScript">
var onecount;
onecount=0;
subcat = new Array();
 <%
 int count = 0;
  String snyr;   snyr=request.getParameter("bigsortselect");
  // 主要是这里怎么样能让 “snyr” 得到数据呢
  String checkstring="SELECT T_DIC_CHANNELSET.SITE_ID, T_DIC_CHANNELSET.INFECTANT_ID, T_DIC_INFECTANT.INFECTANT_NAME  FROM T_DIC_CHANNELSET INNER JOIN T_DIC_INFECTANT ON  T_DIC_CHANNELSET.INFECTANT_ID = T_DIC_INFECTANT.INFECTANT_ID WHERE (T_DIC_CHANNELSET.SITE_ID ='"+snyr+"')";   ResultSet rs=query.getResult(checkstring);
   
while(rs.next())
{
String sname=new String(rs.getString("SITE_ID").getBytes("GBK"),"ISO8859_1");//转换字符类型
out.println(sname);
%>subcat[<%=count%>] = new Array("<%=sname%>","<%=rs.getString("SITE_ID")%>","<%=rs.getString("INFECTANT_NAME")%>","<%=rs.getString("INFECTANT_NAME")%>");//产生数组
<%
        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++)
        {
     // alert(subcat[i][1]);
  //alert(id);
            if (subcat[i][1] == id)
            {
                document.form1.smallsortselect.options[document.form1.smallsortselect.length] = new Option(subcat[i][2], subcat[i][3]);
            }
        }    }
  </script>
</head>
<body bgcolor="#eeeeee"><form name="form1" method="post" action="123ld.jsp">
<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" id="bigsortselect"  onChange="form1.bigsortselect.value=changelocation(document.form1.bigsortselect.options[document.form1.bigsortselect.selectedIndex].value)" size="1"> <option value="2">请选择站点</option>
  <%
      String stringSqlString="select SITE_ID,SITE_NAME from T_DIC_SUBSITE";
     ResultSet rs1=query.getResult(stringSqlString);
    while (rs1.next()) {
  %>
    <option value="<%=rs1.getString("SITE_ID")%>"><%=rs1.getString("SITE_NAME")%>    </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"> </td>
  </tr>
<script LANGUAGE="JavaScript">
    changelocation(document.form1.bigsortselect.options[document.form1.bigsortselect.selectedIndex].value); //将一级分类的value传给changelocation()函数,生成二级分类的列表   
</script>
</table>
</form></body>
</html>
主要是这里 。比的地方能正常运行。
<script language = "JavaScript">
var onecount;
onecount=0;
subcat = new Array();
 <%
 int count = 0;
  String snyr;   snyr=request.getParameter("bigsortselect");
  // 主要是这里怎么样能让 “snyr” 得到数据呢这个该怎么更改 。谢谢大家了