orcale测试实例

/*
   OracleTestServlet -  This is a sample servlet which
connects to an Oracle instance.  It includes some code to
log various points of invocation and execution into
the WebSphere Application Server's log.  It also sets a log
file (in the current directory where the servlet is
invoked) for the JDBC driver.  This JDBC driver log can be
examined along with the servlet's log output in order to
determine configuration problems.  Create the
corresponding class file from this source and move it to the
appropriate servlets directory.
Marc Connolly
Oracle Corporation
Email: mdconnol@us.oracle.com
*/
import   java.io.File;
import   java.io.IOException;
import   java.lang.IllegalStateException;
import   java.io.PrintWriter;
import   java.io.PrintStream;
import   java.io.FileWriter;
import   java.io.FileOutputStream;
import   java.sql.DriverManager;
import   java.sql.Connection;
import   java.sql.SQLException;
import   java.sql.Statement;
import   java.sql.ResultSet;
import   java.util.Date;
import   javax.servlet.Servlet;
import   javax.servlet.ServletConfig;
import   javax.servlet.ServletException;
import   javax.servlet.http.HttpServlet;
import   javax.servlet.http.HttpServletRequest;
import   javax.servlet.http.HttpServletResponse;
import   javax.servlet.http.HttpUtils;
public class OracleServlet extends HttpServlet
{
   private String                thisServletName =