<%
String sql="select * from A";
Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
ResultSet rs=stmt.executeQuery(sql);
%>
<script language="javascript">
function isam(n)
{
var ss = new Array();
<%
while(rs.next())
{
out.println("ss[ss.length] = \"" + rs.getString(3)+"\";");
}
%>
department.value = s[n];
}
</script>
<table><tr><td>姓名:</td><td>
<select name="workname" onchange="isam(options.selectedIndex);">
<option value="">----请选择----</option>
<%
rs.top();
while(rs.next()){
String worknameoption=rs.getString(2);
out.println("<option value="+worknameoption+">"+worknameoption+"</option>");
}
%>
</select>
</td></tr>
<tr><td>部门:</td><td><input type="text" name="department"/></td></tr></table>
String sql="select * from A";
Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
ResultSet rs=stmt.executeQuery(sql);
%>
<script language="javascript">
function isam(n)
{
var ss = new Array();
<%
while(rs.next())
{
out.println("ss[ss.length] = \"" + rs.getString(3)+"\";");
}
%>
department.value = s[n];
}
</script>
<table><tr><td>姓名:</td><td>
<select name="workname" onchange="isam(options.selectedIndex);">
<option value="">----请选择----</option>
<%
rs.top();
while(rs.next()){
String worknameoption=rs.getString(2);
out.println("<option value="+worknameoption+">"+worknameoption+"</option>");
}
%>
</select>
</td></tr>
<tr><td>部门:</td><td><input type="text" name="department"/></td></tr></table>
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货