下拉菜单的连动问题
我的第二个下拉菜单中的内容想根据第一个下拉菜单的选项的不同,从数据库中提取不同的数据,我该怎么作,我已经用呢很多的办法,都不能实现,望解答!!!!!!,我现在的最大问题是我从”数据库“中提出的rs,怎么加入到<script language="JavaScript">中的函数onchange()中去,下面是我的代码
<html>
<head>
<form name="denyu" METHOD=POST action="denyu1.jsp">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>灯语</title>
</head>
<body>
<%@page contentType="text/html; charset=gb2312"%>
<%String aaaa="dwqdeer";%>
<%@page language="java" import="java.sql.*"%>
<%!
Connection conn1=null;
ResultSet rs=null;
Statement stmt1;%>
<%
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn1=DriverManager.getConnection("jdbc:odbc:dddd","","");
stmt1=conn1.createStatement();
%>
<script Language="JavaScript" import="java.sql.*">
Connection conn2=null;
ResultSet rs2=null;
Statement stmt2;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn2=DriverManager.getConnection("jdbc:odbc:dddd","","");
stmt2=conn2.createStatement();
rs2=stmt2.executeQuery("select * from table1");
var my;
while(rs2.next()){
my="String(rs2.getString(1))";
}
///我就是没法的到"my"."my"本来应该是数组的,我为呢查错写成现在这样
function change(char)
{var i;
var ss=char.value;
for (i=0;i<9; i++)
{
if (ss ==my) ///我就是没法的到"my"
{
document.denyu.village.options[0]=new Option("fda","");
}
}
}
</script>
<div align="center">
<p><strong><font size="6">JAVA</font></strong></p>
<hr>
<table width="75%" border="1">
<tr>
<td width="35%">
<%
rs=stmt1.executeQuery("select * from table1");
%>
<%!String aa,aa1;%>
<select name="select1" id="select1" onChange="change(this)">
<%while(rs.next())
{aa=rs.getString(1);
aa1=rs.getString(3);
%>
<option value=<%=aa%>><%=aa%></option>
<% } %>
</select>
<%rs.close();%>
</td>
<td></select><select name="village" size="1">
<option selected>==dsdfdfs==</option></td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
</tr>
</table>
<p><strong><font size="6"></font></strong></p>
<p> </p>
</div>
<p>
<input type="submit" value="确定">
<input type="submit" value="取消">
</p>
<a href="dy.jsp">去</a>
</body>
</html>