initconnetionpoolservlet.java

来自「java模式设计的经典练习和说明,包括常用的23种模式,如工厂模式」· Java 代码 · 共 43 行

package com.accp.controll;

import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.util.*;
import com.accp.DB.*;

public class InitConnetionPoolServlet extends HttpServlet {
  private ConnectionPool pcon=null;
  private ServletContext context=null;
  public void init() throws ServletException {
    try{
      pcon = new ConnectionPool();
      pcon.setDriver("sun.jdbc.odbc.JdbcOdbcDriver");
      pcon.setUrl("jdbc:odbc:student");
      pcon.setUesrname("");
      pcon.setPassword("");
      pcon.setSize(10);
      pcon.initialPools();
      //pcon.getConnection();
      context=this.getServletContext();
      context.setAttribute("Pcon",pcon);
    }
    catch(Exception e){

    }

  }


  public void destroy() {
    try{
      pcon.close();
      context.removeAttribute("Pcon");
      pcon=null;
    }
    catch(Exception e){
      e.printStackTrace();
    }
  }
}