druid连接池的基本使用
配置文件
- 配置文件:druid.properties(文件名随便,必须是properties文件)
- 属性名固定,DruidDataSourceFactory规定
username=root
password=root
url=jdbc:mysql://localhost:3306/test
driverClassName=com.mysql.cj.jdbc.Driver
# 初始连接数
initialSize=5
# 最小连接数
minIdle=5
# 最大连接数
maxActive=20
# 等待时间
maxWait=5000
创建连接
DruidUtils.java
public class DruidUtils {
public static DataSource dataSource;
static {
Properties properties = new Properties();
try {
// 从classpath 加载配置文件解决配置文件位置问题
InputStream resourceAsStream = DruidUtils.class.getResourceAsStream("/druid.properties");
if (resourceAsStream != null) {
properties.load(resourceAsStream);
}
dataSource = DruidDataSourceFactory.createDataSource(properties);
} catch (Exception e) {
e.printStackTrace();
}
}
public static Connection getConnection() {
Connection conn=null;
try {
conn = dataSource.getConnection();
} catch (SQLException throwables) {
throwables.printStackTrace();
}
return conn;
}
public static void close(Connection conn, PreparedStatement ps, ResultSet rs) {
if (rs != null) {
try {
rs.close();
} catch (SQLException throwables) {
throwables.printStackTrace();
}
}
if (ps != null) {
try {
ps.close();
} catch (SQLException throwables) {
throwables.printStackTrace();
}
}
if (conn != null) {
try {
conn.close();
} catch (SQLException throwables) {
throwables.printStackTrace();
}
}
}
}