DBCPUtils

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
package cn.itcast.jdbc.utils;
import java.io.InputStream;
import java.sql.Connection;
import java.util.Properties;
import javax.sql.DataSource;
import org.apache.commons.dbcp.BasicDataSourceFactory;
public class {
private static DataSource dataSource;
static {
try {
InputStream is = DBCPUtils.class.getClassLoader().getResourceAsStream("db.properties");
// 2.创建一个Properties对象
Properties prop = new Properties();
prop.load(is);
// 3.创建数据源对象
dataSource = BasicDataSourceFactory.createDataSource(prop);
} catch (Exception e) {
throw new RuntimeException(e);
}
}
/**
* 获得连接
*/
public static Connection getConnection() {
Connection conn = null;
try {
conn = dataSource.getConnection();
} catch (Exception e) {
throw new RuntimeException(e);
}
return conn;
}
/**
* 获得数据源
*/
public static DataSource getDataSource(){
return dataSource;
}
}