DBUtils工具类

package cn.tedu.utils;

import java.io.IOException;
import java.io.InputStream;
import java.sql.Connection;
import java.util.Properties;

import org.apache.commons.dbcp.BasicDataSource;

public class DBUtils {
	private static BasicDataSource bds;
	static {
		//创建配置文件对象
		Properties p = new Properties();
		//获取文件流
		InputStream is = DBUtils.class.getClassLoader().getResourceAsStream("jdbc.properties");
		//把文件加载到属性对象中
		try {
			p.load(is);
		} catch (IOException e) {
			e.printStackTrace();
		}
		//读取数据
		String driver = p.getProperty("driver");
		String url=p.getProperty("url");
		String user = p.getProperty("username");
		String password = p.getProperty("password");
		//		//注册驱动
		//		Class.forName(driver);
		//		//获取连接对象
		//		Connection conn = DriverManager.getConnection(url, user, password);
		//创建数据库连接池对象
		bds = new BasicDataSource();
		//设置数据库连接信息
		bds.setDriverClassName(driver);
		bds.setUrl(url);
		bds.setUsername(user);
		bds.setPassword(password);
		//设置初始化连接数量
		bds.setInitialSize(3);
		//设置最大连接对象
		bds.setMaxActive(5);
	}
	public static Connection getConn() throws Exception {
		//从连接池中获取连接 抛异常
		Connection conn = bds.getConnection();
		return conn;
	}
}