JDBC数据库连接池配置

数据库连接池(需要导入jar包)

Druid数据库连接池(1个jar包)

德鲁伊是阿里巴巴开源平台的一款数据库连接池的实现，加入了日志监测。

//使用 Druid 数据库连接池的配置文件方式，获取数据库的连接
​
Properties pro = new Properties();
pro.load(new FileInputStream("E:\\cut\\Druid.txt"));
DataSource dataSource = DruidDataSourceFactory.createDataSource(pro);
Connection connection = dataSource.getConnection();
PreparedStatement preparedStatement = connection.prepareStatement("select * from books");
ResultSet resultSet = preparedStatement.executeQuery();
while (resultSet.next()) {
    System.out.print(resultSet.getObject(2));
}
System.out.println(connection);

将注册驱动，连接指定数据库放入文件中，使用Properties接口实现读取，

//将以下写入txt文件，加载导入即可
driverClassName = com.mysql.cj.jdbc.Driver
url = jdbc:mysql://localhost:3306/数据库名
username = 账户
password = 密码
​
initialSize = 5
maxActive = 10
maxWait = 5000

C3P0数据库连接池(两个jar包)

两种方式建立：

//使用 c3p0 数据库连接池的方式，获取数据库的连接，直接设置即可
​
ComboPooledDataSource pool = new ComboPooledDataSource();
pool.setDriverClass("com.mysql.cj.jdbc.Driver");
pool.setJdbcUrl("jdbc:mysql://localhost:3306/manange");
pool.setUser("账户");
pool.setPassword("密码");
pool.setInitialPoolSize(10);
Connection connection = pool.getConnection();
PreparedStatement preparedStatement = connection.prepareStatement("select * from books");
ResultSet resultSet = preparedStatement.executeQuery();
while (resultSet.next()) {
    System.out.println(resultSet.getObject(2));
}

//使用 c3p0 数据库连接池的配置文件方式，获取数据库的连接(c3p0-config.xml)
ComboPooledDataSource pooledDataSource = new ComboPooledDataSource();
Connection connection = pooledDataSource.getConnection();
PreparedStatement preparedStatement = connection.prepareStatement("select * from books");
ResultSet resultSet = preparedStatement.executeQuery();
while (resultSet.next()) {
    System.out.println(resultSet.getObject(2));
}
System.out.println(connection);

<?xml version="1.0" encoding="UTF-8" ?>
<c3p0-config>
    <named-config name = "s">
        <property name = "driverClass" >com.mysql.cj.jdbc.Driver</property>
        <property name = "jdbcUrl" >jdbc:mysql://localhost:3306/数据库名</property>
        <property name = "user" >账户</property>
        <property name = "password" >密码</property>
        <property name="initialPoolSize">5</property>
    </named-config>
    <default-config>
        <property name="driverClass">com.mysql.cj.jdbc.Driver</property>
        <property name="jdbcUrl">jdbc:mysql://localhost:3306/数据库名</property>
        <property name="user">账户</property>
        <property name="password">密码</property>
        <property name="initialPoolSize">5</property>
    </default-config>
</c3p0-config>

将xml文件放置在与连接池文件同级下，文件夹设置为

DBCP数据库连接池(3个jar包)

两种方式建立：

//使用 DBCP 数据库连接池的方式，获取数据库的连接
BasicDataSource bd = new BasicDataSource();
bd.setDriverClassName("com.mysql.cj.jdbc.Driver");
bd.setUrl("jdbc:mysql://localhost:3306/数据库名");
bd.setUsername("账户");
bd.setPassword("密码");
Connection connection = bd.getConnection();
System.out.println(connection);
PreparedStatement preparedStatement = connection.prepareStatement("select * from books");
ResultSet resultSet = preparedStatement.executeQuery();
while (resultSet.next()) {
    System.out.println(resultSet.getObject(2));
}

//使用 DBCP 数据库连接池的配置文件方式，获取数据库的连接
Properties pro = new Properties();
pro.load(new FileInputStream("E:\\cut\\dbcp.txt"));
BasicDataSource dataSource = BasicDataSourceFactory.createDataSource(pro);
Connection connection = dataSource.getConnection();
System.out.println(connection);
PreparedStatement preparedStatement = connection.prepareStatement("select * from books");
ResultSet resultSet = preparedStatement.executeQuery();
while (resultSet.next()) {
    System.out.println(resultSet.getObject(2));
}

配置文件：

driverClassName = com.mysql.cj.jdbc.Driver url = jdbc:mysql://localhost:3306/数据库名 username = 账户名 password = 密码

initialSize = 5