1、创建工程
使用idea创建maven工程c3p0-mysql8,在pom.xml中引入c3p0和mysql8的依赖。
<dependency>
<groupId>com.mchange</groupId>
<artifactId>c3p0</artifactId>
<version>0.9.5.5</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.28</version>
</dependency>
2、在resources目录下添加c3p0-config.xml配置文件,并编写连接池相关的配置信息。
<?xml version="1.0" encoding="UTF-8" ?>
<c3p0-config>
<default-config>
<property name="driverClass">com.mysql.cj.jdbc.Driver</property>
<property name="jdbcUrl">jdbc:mysql://localhost:3306/test?serverTimezone=Asia/Shanghai</property>
<property name="user">root</property>
<property name="password">123456</property>
</default-config>
</c3p0-config>
3、添加一个Java测试类文件
创建ComboPooledDataSource数据源,并通过该数据源获取Connection数据库连接。然后使用PreparedStatement执行一条查询语句。
package com.qyzs;
import com.mchange.v2.c3p0.ComboPooledDataSource;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class Main {
public static void main(String[] args) throws SQLException {
ComboPooledDataSource dataSource = new ComboPooledDataSource();
Connection connection = dataSource.getConnection();
PreparedStatement ps = connection.prepareStatement("select id,username,password from sys_user where username=?;");
ps.setString(1, "admin");
ResultSet rs = ps.executeQuery();
while (rs.next()) {
System.out.print("id: " + rs.getInt("id"));
System.out.print(", username: " + rs.getString("username"));
System.out.print(", password: " + rs.getString("password"));
System.out.println();
}
rs.close();
ps.close();
connection.close();
}
}
4、运行测试类,控制台中输出了查询结果。