数据库连接池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);
}
}
}