Druid阿里巴巴属性文件
driverClass=com.mysql.cj.jdbc.Driver
url=jdbc:mysql://localhost:3306/ab_wzy?serverTimezone=UTC&character=utf8
user=root
password=root
#配置Druid连接池参数
initialSize=5
minIdle=3
maxActive=10
maxWait=60000
timeBetweenEvictionRunsMillis=2000
//阿里 Druid 连接池
import com.alibaba.druid.pool.DruidDataSource;
import java.io.IOException;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Properties;
public class JdbcUtils3 {
//创建阿里巴巴连接池对象
private static DruidDataSource ds;
private static Properties P;
static {
ds=new DruidDataSource();
P=new Properties();
//读取属性文件
InputStream input=Thread.currentThread().getContextClassLoader().getResourceAsStream("druid.properties");
//加载P对象
try{
P.load(input);
}catch(IOException ce){
ce.printStackTrace();
}
//根据键获取值
ds.setDriverClassName(P.getProperty("driverClass"));
ds.setUrl(P.getProperty("url"));
ds.setUsername(P.getProperty("user"));
ds.setPassword(P.getProperty("password"));
//配连接池的参数
ds.setInitialSize(Integer.parseInt(P.getProperty("initialSize")));
ds.setMinIdle(Integer.parseInt(P.getProperty("minIdle")));
ds.setMaxActive(Integer.parseInt(P.getProperty("maxActive")));
ds.setMaxWait(Integer.parseInt(P.getProperty("maxWait")));
ds.setTimeBetweenEvictionRunsMillis(Integer.parseInt(P.getProperty("timeBetweenEvictionRunsMillis")));
}
//获取数据库连接对象
public static Connection getConnection()throws SQLException{
return ds.getConnection();
}
//关闭数据库连接对象之insert delete update的操作
public static void close(Connection con, Statement state)throws SQLException{
con.close();;
state.close();
}
//关闭数据库连接的对象之 select 查找查询的操作
public static void close(Connection con, Statement state, ResultSet set)throws SQLException{
set.close();
state.close();
con.close();
}
//关闭获取数据库连接对象
public static void close(Connection con)throws SQLException{
con.close();
}
// 关闭执行Statement执行SQL 语句的对象
public static void close(Statement state)throws SQLException{
state.close();
}
//关闭结果集对象ResultSet对象
public static void close(ResultSet set)throws SQLException{
set.close();
}
}