<%
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>