文章目录
1. 连接池的简介
连接池: 为数据库建立一个缓冲池,预先在缓冲池中放入一定数量的Connection对象连接,使用时,直接从缓冲池中取就行,不用时放回到缓冲池中
C3P0___23">2. C3P0 - 连接池
2.1 硬编码获取连接
public static Connection getConnection1() throws Exception{
// 1. 获取数据库连接池
ComboPooledDataSource cpds = new ComboPooledDataSource();
// 2. 连接数据库
cpds.setDriverClass("oracle.jdbc.driver.OracleDriver");
cpds.setJdbcUrl("jdbc:oracle:thin:@localhost:1521:orcl");
cpds.setUser("scott");
cpds.setPassword("123456");
// 3. 设置数据库初始的连接数
cpds.setInitialPoolSize(10);
// 4. 获取Conenction连接对象
Connection conn1 = cpds.getConnection();
System.out.println(conn1);
return conn1;
}
2.2 配置文件进行获取连接对象
public static Connection getConnection2() throws Exception{
// 1. 获取数据库连接池
ComboPooledDataSource cpds = new ComboPooledDataSource();
// 2. 读取配置文件信息
Properties p = new Properties();
InputStream is = new FileInputStream("E:\\eclipse\\workspace\\学习\\src\\top\\linruchang\\connectionPool\\c3p0.properties");
p.load(is);
String driverClass = p.getProperty("driverClasss");
String url = p.getProperty("url");
String user = p.getProperty("user");
String password = p.getProperty("password");
String initialPoolSize = p.getProperty("initialPoolSize");
// 3. 利用配置文件的信息进行连接数据库
cpds.setDriverClass(driverClass);
cpds.setJdbcUrl(url);
cpds.setUser(user);
cpds.setPassword(password);
cpds.setIdentityToken(initialPoolSize);
// 4. 获取Connection连接对象
Connection conn = cpds.getConnection();
System.out.println(conn);
return conn;
}
DBCP___101">3. DBCP - 连接池
3.1 硬编码获取连接
public static Connection getConnection1() throws SQLException {
// 1. 创建数据库连接池
BasicDataSource source = new BasicDataSource();
// 2. 设置基本信息
source.setDriverClassName("oracle.jdbc.driver.OracleDriver");
source.setUrl("jdbc:oracle:thin:@localhost:1521:orcl");
source.setUsername("scott");
source.setPassword("123456");
source.setInitialSize(10);
// 3. 获取数据库连接池的Connection对象
Connection conn = source.getConnection();
System.out.println(conn);
return conn;
}
3.2 配置文件获取连接
public static Connection getConnection2() throws Exception{
// 1. 获取配置文件
Properties pro = new Properties();
FileInputStream fis = new FileInputStream("E:\\eclipse\\workspace\\学习\\src\\top\\linruchang\\connectionPool\\dbcp.properties");
pro.load(fis);;
// 2. 加载配置文件到 数据源总
BasicDataSource source = BasicDataSourceFactory.createDataSource(pro);
// 3. 获取连接
Connection conn = source.getConnection();
System.out.println(conn);
return conn;
}
Druid___163">4. Druid - 连接池
4.1 硬编码获取连接
public static Connection getConnection1() throws SQLException {
// 1. 获取数据源
DruidDataSource source = new DruidDataSource();
// 2. 设置数据源连接数据库的信息
source.setDriverClassName("oracle.jdbc.driver.OracleDriver");
source.setUrl("jdbc:oracle:thin:@localhost:1521:orcl");
source.setUsername("scott");
source.setPassword("123456");
// 3. 获取连接
Connection conn = source.getConnection();
System.out.println(conn);
return conn;
}
4.2 配置文件获取连接
public static Connection getConnection2() throws Exception {
// 1. 获取配置文件
Properties pro = new Properties();
FileInputStream fis = new FileInputStream("E:\\eclipse\\workspace\\东软\\src\\top\\linruchang\\connectionPool\\druid.properties");
pro.load(fis);
// 2. 将配置文件加载到数据源中
DataSource source = DruidDataSourceFactory.createDataSource(pro);
// 3. 获取连接
Connection conn = source.getConnection();
System.out.println(conn);
return conn;
}