JDBC - 学习7 -连接池C3P0、DBCP -- 获取Connection连接

1. 连接池的简介

连接池： 为数据库建立一个缓冲池，预先在缓冲池中放入一定数量的Connection对象连接，使用时，直接从缓冲池中取就行，不用时放回到缓冲池中

 

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;
}

 

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;

}

 

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;
}