servlet program doubt

Hi All,

I created html file which accepts an emp number and forwards it to the servlet program which sends emp details to the web browser.When i run the program, i can see the url with the number appended but not the emp record with that number.what may went wrong??Any problem with database connectivity?or servlet program or html program.... I dont know. Pls help

Below is the code.

//FindEmp.html

//FindEmpServlet.java

package com.test;
 
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
 
 public class FindEmpServlet extends javax.servlet.http.HttpServlet implements javax.servlet.Servlet {
   static final long serialVersionUID = 1L;
   
    public FindEmpServlet() {
super();
}

protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
}

protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  response.setContentType("text/html");
  PrintWriter out=response.getWriter();
  out.println("<html><body><h2> Emp details </h2>");
  try
  {
   int empno=Integer.parseInt(request.getParameter("EMPNO"));
   // OPEN THE RECORD FOR EMPNO
   Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
   Connection con= DriverManager.getConnection("jdbc  :-o	  dbc:javaoracle","scott","tiger");
   PreparedStatement ps=con.prepareStatement("select empno,ename,job,sal,deptno from emp where empno=?");
   ps.setInt(1,empno);
   ResultSet rs=ps.executeQuery();
   if(rs.next())
   {
    out.println("<h3> Record found </h3>");
    out.println("<br> Emp no:"+ rs.getString(1));
    out.println("<br> Emp name:"+ rs.getString(2));
        out.println("<br> Emp Job:"+ rs.getString(3));
        out.println("<br> Emp sal:"+ rs.getString(4));
        out.println("<br> dept no:"+ rs.getString(5));
   
   }     
   else
   {
   out.println("<h3> Record not found</h3>");
   
   }
rs.close();
ps.close();
con.close();

}
  catch(Exception ex)
  
  {
out.println("<br> Error:"+ ex);
  }
  out.println("<hr size=5 color=red>");
  out.println("<a href='/FindEmp.html'> Find another </a>");
  out.println("</body></html>");
   
   
   
  }
}

[BSouther: Added UBB CODE tags]
[ February 19, 2008: Message edited by: Ben Souther ]

Please be sure to use UBB code tags when posting code to the forums. Unformatted code is extermely hard to read and many people that might be able to help you will just move along. Please read this for more information.

You can go back and change your post to add code tags by clicking the .

Pls help

Also, please use real words when posting to the forums. Abbreviations such as "pls" in place of "please" only serve to make your posts more difficult to read and less likely to generate useful responses.

Please read this for more information.

thanks,
bear
JavaRanch sheriff
[ February 19, 2008: Message edited by: Bear Bibeault ]

A lot of things could be wrong.
What are you seeing?

Have you checked your server's logs to see if anything is blowing up?

hi sudha,

is your servlet-mapping in the web.xml OK?

Herman

Hi,

Could you tell me how to check server's log. web.xml is fine.

Thanks,
sudha.

If you are using tomcat then you can find your log files under the folder
Tomcat5.0/logs/

Note: the tomcat version may change