数据库连接池—druid

数据库连接池Druid

1 导入jar包

2 定义配置文件：druid.properties

driverClassName=com.mysql.jdbc.Driver
url=jdbc:mysql://127.0.0.1:3306/db1
username=root
password=123456
initialSize=5
maxActive=10
maxWait=3000

3 创建连接池工具类

package com.gyq.esm.util;

import java.io.IOException;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Properties;

import javax.sql.DataSource;

import com.alibaba.druid.pool.DruidDataSourceFactory;


public class DruidUtils {

	//创建数据库连接池对象
	private static DataSource ds;
	
	static {

		try {
			Properties pro=new Properties();
			//加载配置文件
	 pro.load(DruidUtils.class.getClassLoader().getResourceAsStream("druid.properties"));
			//获取连接池对象
			ds = DruidDataSourceFactory.createDataSource(pro);
		} catch (IOException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	
	//从连接池获取数据库连接
	public static Connection getConnection() throws SQLException {
		return ds.getConnection();
	}
	
	
	//	释放资源
	public static void close(Statement st,Connection conn) {
		close(null, st, conn);
	}
	
	public static void close(ResultSet rs,Statement st,Connection conn) {
		if(null!=rs) {
			try {
				rs.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
			
		}
		
		if(null!=st) {
			try {
				st.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		
		if(null!=conn) {
			try {
				conn.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
	}
	
	/**
	  * 获取连接池方法
	  */
	public static   DataSource getDataSource() {
		return ds;
	}
	
}

4 测试

package Demo;

import java.sql.Connection;
import java.sql.PreparedStatement;

public class Test {

	public static void main(String[] args) {
		Connection conn=null;
		PreparedStatement ps=null;
		try {
			
			//从连接池获取连接
			conn=DruidUtils.getConnection();
			String sql="delete from student where id= ?";
			ps=conn.prepareStatement(sql);
			ps.setInt(1, 12);
			int count=ps.executeUpdate();
			System.out.println(count);
		} catch (Exception e) {
			
			e.printStackTrace();
		}finally {
			//归还连接
			DBUtils.close(ps, conn);
		}
		
	}
}