Retrieve data from database and show in combo box

Question

I want to retrieve data for different table of data base and show this data in different combobox in my jsp page Project : online movie ticket Booking

Muralidharan Deenathayalan · Answer

Are you using hibernate or JDBC to fetch the data? If you're using JDBC you try the following code. Connection con=null; ResultSet rs=null; try { Class.forName(sun.jdbc.odbc.JdbcOdbcDriver); con=DriverManager.getConnection(jdbc:odbc:dbrootroot); HttpSession ss=request.getSession(); String uid=(String)ss.getAttribute(id); PreparedStatement pst=con.prepareStatement(select name from emp where uid=?); pst.setString(1uid); rs=pst.executeQuery(); while(rs.next()) { String name = rs.getString(name); %> > } }catch(Exception e) { out.print(e); } %>