<%@ 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” 得到数据呢这个该怎么更改 。谢谢大家了
<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” 得到数据呢这个该怎么更改 。谢谢大家了
最后加入
form1.submit();你没有提交,当然取不到
怎么写呢 能组合下不