servlet program doubt

sudha javvadi

Ranch Hand

Posts: 97

posted 9 years ago

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 ]

Bear Bibeault

Author and ninkuma
Marshal

Posts: 66188

151

I like...

posted 9 years ago

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 ]

[Asking smart questions] [About Bear] [Books by Bear]

Ben Souther

Sheriff

Posts: 13411

I like...