dbinitservlet.java

来自「这个程序是花了好几十万请人开发的」· Java 代码 · 共 41 行

package javabean;
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("oracle.jdbc.driver.OracleDriver");
			ds.setUrl("jdbc:oracle:thin:@211.67.54.20:1521:dbora04");
			ds.setUser("hbfz");
			ds.setPassword("j2eeoracle");
			ds.setMinCount(1);
			ds.setMaxCount(1000);
			ds.setAutoCommit(false);
			
			ds.open();
			
			ConnectionPool.init(ds);
			
		}catch (SQLException e){
			e.printStackTrace();
			throw new ServletException("Unable to open datasource.");
		}
	}


}