Hi All,
I have written a small program to access database from my servlet,Here
I am using Apache is my web server,The servlet is working proper ,but it
showing all the print statment but it is not showing the output
generated from database query.it not any showing error message in the
browser also.Will any one help to solve this problem ??,I have attached
below my program for your reference.
waiting for your response.
Thanks
Krishna
import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
/**
* This is a simple example of an HTTP Servlet. It responds to the GET
* and HEAD methods of the HTTP protocol.
*/
public class Hello extends HttpServlet
{
/**
* Handle the GET and HEAD methods by building a simple web page.
* HEAD is just like GET, except that the server returns only the
* headers (including content length) not the body we write.
*/
public void doGet (HttpServletRequest request,
HttpServletResponse response)
throws ServletException, IOException
{
PrintWriter out;
String title = "Example Apache JServ Servlet";
// set content type and other response header fields first
response.setContentType("text/html");
try{
// then write the data of the response
out = response.getWriter();
out.println("<HTML><HEAD><TITLE>");
out.println(title);
out.println("</TITLE></HEAD><BODY bgcolor=\"#FFFFFF\">");
out.println("<H1>" + title + "</H1>");
out.println("<H2> Congratulations! ApacheJServ 1.1 is
working!<br>");
// Load the Oracle JDBC driver
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}catch(java.lang.ClassNotFoundException e) {
System.err.print("ClassNotFoundException: ");
System.err.println(e.getMessage());
}
//Connect to the Database
Connection con =
DriverManager.getConnection("jdbc:odbc:local123","scott","tiger");
//Create a Statement
Statement stmt = con.createStatement();
//Query
ResultSet rset = stmt.executeQuery("select EMPNAME from EMP1");
// Iterate through the result and print the employee names
while(rset.next())
out.println(rset.getString(1));
out.println("</BODY></HTML>");
out.close();
}
catch( SQLException exc){
System.out.println(exc);
}
catch(IOException exe){
System.out.println(exe);
}
}
}
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
