我想在jsp中创建一个包含从我的数据库中获取的值的组合框. 这是我编写的代码,但它返回一个空白的组合框,即使数据库中有值. select% Connection con=null;ResultSet rs=null;try{ Class.forName("sun.jd
这是我编写的代码,但它返回一个空白的组合框,即使数据库中有值.
<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()) { out.print(rs.getString("name")); %> </select> <% } }catch(Exception e) { out.print(e); } %>怎么样:
<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>