java 连接池DBCP 方法二及改进（读配置文件（2种方法））

package day19;

import java.sql.Connection;
import java.sql.SQLException;
import java.util.Properties;

import javax.sql.DataSource;


import org.apache.commons.dbcp.BasicDataSource;
import org.apache.commons.dbcp.BasicDataSourceFactory;


public class TestDBCP02 {

	/**
	 * BasicDataSource implements javax.sql.DataSource
	 * 数据源   连接池
	 * @throws SQLException 
	 */
	public static void main(String[] args) throws SQLException {
		
		Properties properties=new Properties();
		properties.setProperty("username", "root");
		properties.setProperty("password", "123456");
		properties.setProperty("url", "jdbc:mysql://localhost:3306/test");
		properties.setProperty("driverClassName", "com.mysql.jdbc.Driver");
		properties.setProperty("initialSize", "4");
		properties.setProperty("maxActive", "10");
		properties.setProperty("maxIdle", "5");
		properties.setProperty("minIdle", "3");
		properties.setProperty("maxWait", "5000");
		
		Connection conn=null;
		try {
			//使用BasicDataSourceFactory 创建数据源
			DataSource dataSource=BasicDataSourceFactory.createDataSource(properties);
			 conn=dataSource.getConnection();
			System.out.println(conn);
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			if(conn!=null){
				conn.close();
			}
		}
	
	}

}

改进：

jdbc.properties:

#设置用户名密码
	username=root
	password=123456
		
#设置url
		url=jdbc:mysql://localhost:3306/test
#设置驱动
		driverClassName=com.mysql.jdbc.Driver
		
		
#设置初始化连接数
		initialSize=4
#设置最大连接数
		maxActive=10
#设置最大空闲数
		maxIdle=5
#设置最小空闲数
		minIdle=3
#设置最大等待时间，以毫秒为单位
		maxWait=5000




package day19.conf;

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

import javax.sql.DataSource;


import org.apache.commons.dbcp.BasicDataSource;
import org.apache.commons.dbcp.BasicDataSourceFactory;


public class TestDBCP03 {

	/**
	 * BasicDataSource implements javax.sql.DataSource
	 * 数据源   连接池
	 * @throws SQLException 
	 * @throws IOException 
	 */
	public static void main(String[] args) throws SQLException, IOException {
		
		Properties properties=new Properties();
		//获取jdbc.properties文件信息
		
		//getClassLoader() 获取文件，要指明路径
		//InputStream inputStream=TestDBCP03.class.getClassLoader().getResourceAsStream("day19/conf/jdbc.properties");
		
		//TestDBCP03.class 当前类所在的路径，查找文件
		InputStream inputStream=TestDBCP03.class.getResourceAsStream("jdbc.properties");
		properties.load(inputStream);
		System.out.println(properties.getProperty("username"));
		
		
		Connection conn=null;
		try {
			//使用BasicDataSourceFactory 创建数据源
			DataSource dataSource=BasicDataSourceFactory.createDataSource(properties);
			 conn=dataSource.getConnection();
			System.out.println(conn);
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			if(conn!=null){
				conn.close();
			}
		}
	
	}

}