initconnetionpoolservlet.java~1~

是一个学生开发信息管理系统

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();
    }
  }
}