1.声明静态加载元素
public class DButils {
private static final String DRIVER_CLASS = "com.mysql.jdbc.Driver";
private static final String URL = "jdbc:mysql://localhost:3306/test";
private static final String USER = "root";
private static final String PASSWORD = "123456";
private static final int INIT_SIZE = 1;
private static final int MAX_ACTIVE = 5;
private static final long MAX_WAIT = 5000;
private static final int MIN_IDLE = 1;
private static DruidDataSource dataSource;
static {
dataSource = createDataSource();
}
2.创建连接池并返回
private static DruidDataSource createDataSource() {
dataSource = new DruidDataSource();
dataSource.setUrl(URL);
dataSource.setUsername(USER);
dataSource.setPassword(PASSWORD);
dataSource.setInitialSize(INIT_SIZE);
dataSource.setMaxActive(MAX_ACTIVE);
dataSource.setMaxWait(MAX_WAIT);
dataSource.setMinIdle(MIN_IDLE);
return dataSource;
}
3.返回数据库连接对象
public static Connection getConn() {
try {
if (dataSource == null || dataSource.isClosed()) {
dataSource = createDataSource();
}
return dataSource.getConnection();
} catch (SQLException e) {
e.printStackTrace();