开发者

create a dynamic combo box using values from database in JSP

开发者 https://www.devze.com 2023-03-25 10:40 出处:网络
I want to create a combo box in jsp that contains values fetched from my database. Here\'s the code that I\'ve written,but it returns a blank combo box,even though there are values in the database.

I want to create a combo box in jsp that contains values fetched from my database. Here's the code that I've written,but it returns a blank combo box,even though there are values in the database.

<select>
<% 
Connection con=null;
ResultSet rs=null;

try
{
     Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
     con=DriverManager.getConnection("jdbc:odbc:db","roo开发者_JAVA百科t","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);
}
%>


How about:

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

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号