快精灵印艺坊 您身边的文印专家
广州名片 深圳名片 会员卡 贵宾卡 印刷 设计教程
产品展示 在线订购 会员中心 产品模板 设计指南 在线编辑
 首页 名片设计   CorelDRAW   Illustrator   AuotoCAD   Painter   其他软件   Photoshop   Fireworks   Flash  

 » 彩色名片
 » PVC卡
 » 彩色磁性卡
 » 彩页/画册
 » 个性印务
 » 彩色不干胶
 » 明信片
   » 明信片
   » 彩色书签
   » 门挂
 » 其他产品与服务
   » 创业锦囊
   » 办公用品
     » 信封、信纸
     » 便签纸、斜面纸砖
     » 无碳复印纸
   » 海报
   » 大篇幅印刷
     » KT板
     » 海报
     » 横幅

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 =
"OracleTestServlet";
   private String                thisServletNameDesc = "
Oracle JDBC Test Servlet";

   private boolean               servletInitialized = false;

   private long                  servletStartTimeStamp;

   public void init(ServletConfig config) throws
ServletException
   {
      super.init(config);
      /*
      Record the servlet\\\'s initialization time
      */
      servletStartTimeStamp = System.currentTimeMillis();

      log(thisServletName + ":Init Completed");

      /*
      Mark servlet init complete
      */
      servletInitialized = true;
   }


   protected void doGet(HttpServletRequest request,
HttpServletResponse response) throws IOException,
ServletException
   {

      log("Start Menu Visual List()");
      log(thisServletName + "doGet (Start)");

      long startTimeStamp = System.currentTimeMillis();

      response.setContentType("text/html");
      PrintWriter out = response.getWriter();


      out.println("<HTML><TITLE>OracleTestServlet: Using
Oracle JDBC Driver</TITLE><BODY>");
      out.println("<BR><BR<BR<HR><CENTER>Begin Employee
List</CENTER><BR><BR>");
      out.println("<PRE>");

      /*
      Enable JDBC Driver logging
      */
      String jdbcDriverlogFileName =
"./OracleServletJDBC.log";

      log(thisServletName + "JDBC Log: " +
jdbcDriverlogFileName);

      /*
      Make the log file
      */
      File file = new File(jdbcDriverlogFileName);
      if (file.exists())
      {
         if (!file.canWrite())
         {
            log(thisServletName + "JDBC Driver Log file (" +
file.getAbsolutePath() + ") is not writable");
         }
      }
      else
      {
         try
         {
            File parent = new File(file.getParent());
            if (!parent.canWrite())
            {
               log(thisServletName + "JDBC Driver Log file
directory (" + parent.getAbsolutePath() + ") is not
writable");
            }
         }
         catch (NullPointerException e)
         {
              // no parent.
         }
      }
      try
      {
            DriverManager.setLogStream(new PrintStream(new
FileOutputStream(file.getAbsolutePath(), true)));
      }
      catch (IOException ioE)
      {
         log(thisServletName + "JDBC Driver Log - exception
thrown during setLogStream:" + ioE);
      }

      try
      {
         log(thisServletName + "Registering
Driver(before)");

         DriverManager.registerDriver(new
oracle.jdbc.driver.OracleDriver());

         log(thisServletName + "Registering Driver(after)");

         /*
         Note regarding connection url: the ip address is
the address of the host upon which the Oracle instance is
running followed by
         the port which the Oracle instance\\\'s listener (the
TNS address space) is using as specified in the
.PARMLIB(MPMTNS) member
         of the Oracle\\\'s MPM started task.
         */

         Connection conn =  DriverManager.getConnection
("jdbc:oracle:thin:@9.12.2.10:1621:MPM5","system",
"manager");


         log(thisServletName + "Get Connection(After)");

         Statement stmt = conn.createStatement ();
         log(thisServletName + "Create Statement(After)");

         ResultSet rset = stmt.executeQuery ("select EMPNO,
ENAME from scott.EMP");
         log(thisServletName + "Execute Query(After)");

         while (rset.next ())
            out.println("<BR>EMPNO:" + rset.getString (1) +
",NAME:" + rset.getString (2));
        log(thisServletName + "Close Connection(Before)");
         conn.close();
         log(thisServletName + "Close Connection(Before)");

      }
      catch (Exception e)
      {
         log(thisServletName + "Exception:" + e);
      }


      out.println("</PRE><BR><HR><CENTER>End Employee
List</CENTER></   FORM></BODY></HTML>");
      out.close();
      log(thisServletName + "doGet (End)");
   }



   public void destroy()
   {
      log(thisServletName + ":Terminated");
      super.destroy();
   }

   public boolean isInitialized()
   {
      return servletInitialized;
   }

   public String getServletInfo()
   {
      return thisServletNameDesc;
   }

}








返回类别: 教程
上一教程: 一个体现Java接口及工厂模式长处的例子
下一教程: 学习Java的30个基本概念

您可以阅读与"orcale测试实例"相关的教程:
· Java程序性能测试
· 使用JMeter测试JSP应用程序性能
· 两种方式测试spring中的jdbc
· Java单体测试工具cactus使用指南
· Java用户界面本地化实例探索
    微笑服务 优质保证 索取样品