Druid数据库连接池

1、 Druid是阿里提供的一个数据库连接池，可以从这里下载它的jar包；
2、配置文件：
druid.properties:

driverClassName=com.mysql.cj.jdbc.Driver
url=jdbc:mysql://localhost:3306/mydb?serverTimezone=GMT%2b8&characterEncoding=utf8
username=root
password=123456
#初始化连接数
initialSize=10
#最大连接数量
maxActive=50
#最大空闲连接
maxIdle=20
#最小空闲连接数
minIdle=5
#最长等待时间
maxWaitmillis=5000

测试代码：

package cn.melo.demo;

import java.io.FileInputStream;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.util.Properties;

import javax.sql.DataSource;

import org.junit.Test;

import com.alibaba.druid.pool.DruidDataSourceFactory;

public class DruidDemo {
	//测试Druid连接池
	@Test
	public void testDruid() throws Exception{
		InputStream in = new FileInputStream("src/druid.properties");
		Properties prop = new Properties();
		prop.load(in);
		DataSource ds= DruidDataSourceFactory.createDataSource(prop);
		Connection conn = ds.getConnection();
		
		String sql = "SELECT * FROM student";
		PreparedStatement preStmt = conn.prepareStatement(sql);
		ResultSet rs = preStmt.executeQuery();
		while(rs.next()) {
			ResultSetMetaData metaData = rs.getMetaData();
			int cols = metaData.getColumnCount();
			for(int i = 1; i < cols; i++) {
				System.out.print(rs.getString(i)+"\t");
			}
			System.out.println();
		}
		conn.close();
	}
}