怎么样：
<select><% Connection con=null;ResultSet rs=null;try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); con=DriverManager.getConnection("jdbc:odbc:db","root","root"); HttpSession ss=request.getSession(); String uid=(String)ss.getAttribute("id"); PreparedStatement pst=con.prepareStatement("select name from emp where uid=?"); pst.setString(1,uid); rs=pst.executeQuery(); while(rs.next()) { String name = rs.getString("name");%> <option value="<%=name%>"><%=name%></option><% }}catch(Exception e){ out.print(e);}%></select>
