阿里连接池

依赖

<dependency>
    <groupId>com.alibaba</groupId>
    <artifactId>druid</artifactId>
    <version>1.1.16</version>
</dependency>

配置文件

文件名：druid.properties

driver=com.mysql.jdbc.Driver
url=jdbc:mysql://127.0.0.1:3306/cctv
username=root
password=root
initialSize=5
minIdle=5
maxActive=10
maxWait=3000

连接池读取类

package com.jiuyun.util;

import java.io.IOException;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.SQLException;
import java.util.Properties;
import com.alibaba.druid.pool.DruidDataSource;

/**
 * 阿里连接池
 * @author sanzang
 *
 */
public class AliPool {
	
	static DruidDataSource ds;
	//只会运行一次
	static {
		String fname ="druid.properties";
		InputStream file= AliPool.class.getClassLoader().getResourceAsStream(fname);
		Properties prop = new Properties();
		try {
			prop.load(file);
		} catch (IOException e) {
			e.printStackTrace();
		}
		//读取文件
		String driver =prop.getProperty("driver");
		String url =prop.getProperty("url");
		String name =prop.getProperty("username");
		String pass =prop.getProperty("password");
		String init =prop.getProperty("initialSize");
		String min =prop.getProperty("minIdle");
		String max =prop.getProperty("maxActive");
		String wait =prop.getProperty("maxWait");
		// 配置连接池
	    ds = new DruidDataSource();
		ds.setDriverClassName(driver);
		ds.setUrl( url );
		ds.setUsername( name);
		ds.setPassword( pass);
		ds.setInitialSize( new Integer(init));
		ds.setMaxActive( new Integer(max)); 
		ds.setMinIdle(new Integer(min));
		ds.setMaxWait(new Long(wait));
	}
	
	// 池里取连接
	public static Connection getConn() {
		Connection conn = null;
		try {
			conn= ds.getConnection();
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return conn;		
	}

}