This is my servlet code Plese help me...
Code java:
/*
* 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
Re: This is my servlet code Plese help me...
For future reference, please use the code tags. I have edited your post and added them for you this time.
While I don't fully understand what the problem is, I will point you to the following link on how to create html forms using the option tag
HTML option tag
There are other pages there worth looking at, as your page doesn't even have html, body, or head tags