dbinitservlet.java

来自「用JAVA开发的数据库底层核心」· Java 代码 · 共 44 行

package emptyprj.jdbc.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.setUser(getInitParameter("user"));
      ds.setPassword(getInitParameter("password"));
      
      ds.open();

      ConnectionPool.init(ds);

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

  }

}