/* * To change this template, choose Tools | Templates * and open the template in the editor. */ package test; import java.io.IOException; import java.io.PrintWriter; import java.sql.ResultSet; // its mendatory for this program. import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; /** * * @author ANU_RAG */ public class DropDown1 extends HttpServlet { String a,b; /** * Processes requests for both HTTP <code>GET</code> and <code>POST</code> methods. * @param request servlet request * @param response servlet response * @throws ServletException if a servlet-specific error occurs * @throws IOException if an I/O error occurs */ protected void processRequest(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.setContentType("text/html;charset=UTF-8"); PrintWriter out = response.getWriter(); String q="select Roomno from shivalik"; String q1="select Bedno from shivalik"; try{ // try { ResultSet j=test.DBService.selectData(q); out.print("<b>Room No:</b><select name='rn'>"); out.print("<option value='select'>----select Room----</option><br>"); while(j.next()) { out.print("<tr><td>"+j.getString(1)+"</td></tr>"); a = j.getString(1); out.print("<option value="+a+">"+a+"</option>"); } out.print("<br>"); // }catch(Exception e){} // another try block try{ ResultSet k=test.DBService.selectData(q1); out.print("<b>Bed No.:</b><select name='month'>"); out.print("<option value='select'>----select Bed No.----</option>"); while(k.next()) { out.print("<tr><td>"+k.getString(1)+"</td></tr>"); b = k.getString(1); out.print("<option value="+b+">"+b+"</option>"); } }catch(Exception e){} // end of try block out.print("<center><a href='AdminMenu'><h3>Home</h3></a></center>"); }catch(Exception e){} finally { out.close(); } } // <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code."> /** * Handles the HTTP <code>GET</code> method. * @param request servlet request * @param response servlet response * @throws ServletException if a servlet-specific error occurs * @throws IOException if an I/O error occurs */ @Override protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { processRequest(request, response); } /** * Handles the HTTP <code>POST</code> method. * @param request servlet request * @param response servlet response * @throws ServletException if a servlet-specific error occurs * @throws IOException if an I/O error occurs */ @Override protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { processRequest(request, response); } /** * Returns a short description of the servlet. * @return a String containing servlet description */ @Override public String getServletInfo() { return "Short description"; }// </editor-fold> }
I got only one drop down box but another dropdown box is not appear on the output.
my database table has three fields
roomno , bedno, and status