pool.java

用Java语言实现学生信息管理系统 对此感兴趣的同学去浏览

package com.yourcompany.struts.common;
import org.apache.tomcat.dbcp.dbcp.BasicDataSource;
import java.sql.*;

public class Pool {
	static BasicDataSource DBS= null;
	public Pool(){
		init();
	}
	
	public void init(){
		DBS = new BasicDataSource();
		DBS.setDriverClassName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
		DBS.setUrl("jdbc:microsoft:sqlserver://127.0.0.2:1433;databaseName=Test");
		DBS.setUsername("sa");
		DBS.setPassword("8912737");
	}
	
	public Connection getPoolConnection(){
		Connection con = null;
		try {
			con = DBS.getConnection();
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
		}
		return con;
	}
	
}