dbinitservlet.java

使用eclipse开发的web程序

package com.wrox.tourism.db.util;

import javax.servlet.http.HttpServlet;
import javax.servlet.ServletConfig;
import javax.servlet.ServletException;

import java.sql.SQLException;
import java.sql.Connection;
import javax.sql.DataSource;

import org.apache.struts.util.GenericDataSource;

public class DBInitServlet extends HttpServlet {

  public void init(ServletConfig config) throws ServletException {

    super.init(config);

    try {

      GenericDataSource ds = new GenericDataSource();

      ds.setDriverClass(getInitParameter("driverClass"));
      ds.setUrl(getInitParameter("jdbcURL"));
      ds.setMinCount(Integer.parseInt(getInitParameter("minCount")));
      ds.setMaxCount(Integer.parseInt(getInitParameter("maxCount")));
      ds.setAutoCommit(false);

      ds.open();

      ConnectionPool.init(ds);

    } catch (SQLException e) {
      e.printStackTrace();
      throw new ServletException("Unable to open datasource.");
    }

  }

}