title: create a dynamic combo box using values from database in JSP
body: <p>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.</p>
  
  <pre><code>&lt;select&gt;
  &lt;% 
  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"));
  %&gt;
  &lt;/select&gt;
  &lt;%
       }
  }catch(Exception e)
  {    out.print(e);
  }
  %&gt;
  </code></pre>