retrieve data from database show in a combobox in jsp

Question

I have multiple combo box in my jsp page.I want that i retrieve the data for data base table and show this data in this combo box..

Like in my database i have 2 table ------ like table1 and table 2

and in my jsp page suppose i have two combo box lets say cobobox1 and combobox2

i want to display table1 data in combo box1 and table2 data in combox2

I have odbc dsn connection

Muralidharan Deenathayalan · Answer

For the first combo box 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( query for first combo box ); pst.setString(1uid); rs=pst.executeQuery(); while(rs.next()) { String name = rs.getString(name); %> > } }catch(Exception e) { out.print(e); } %> You can repeat the samething and just the change for the second combo box. 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( query for second combo box ); pst.setString(1uid); rs=pst.executeQuery(); while(rs.next()) { String name = rs.getString(name); %> > } }catch(Exception e) { out.print(e); } %>