pom.xml
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.21</version>
</dependency>
<dependency>
<groupId>com.mchange</groupId>
<artifactId>c3p0</artifactId>
<version>0.9.5.2</version>
</dependency>
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid</artifactId>
<version>1.1.10</version>
</dependency>
使用
/**
* @Description: 手动创建c3p0数据源
*/
@Test
public void test1() throws Exception {
//1. 创建数据源对象
ComboPooledDataSource dataSource = new ComboPooledDataSource();
//2. 设置连接参数才能使用
dataSource.setDriverClass("com.mysql.cj.jdbc.Driver");
dataSource.setJdbcUrl("jdbc:mysql:///travel?serverTimezone=UTC");
dataSource.setUser("root");
dataSource.setPassword("root");
//3.获取资源
Connection connection = dataSource.getConnection();
//4. 测试连接
System.out.println(connection);
//5. 归还数据源
connection.close();
}
/**
* @Description: 手动创建druid数据源
*/
@Test
public void test2() throws Exception {
//1. 创建数据源对象
DruidDataSource dataSource = new DruidDataSource();
//2. 设置连接参数才能使用
dataSource.setDriverClassName("com.mysql.cj.jdbc.Driver");
dataSource.setUrl("jdbc:mysql:///travel?serverTimezone=UTC");
dataSource.setUsername("root");
dataSource.setPassword("root");
//3.获取资源
DruidPooledConnection connection = dataSource.getConnection();
//4. 测试连接
System.out.println(connection);
//5. 归还数据源
connection.close();
}
jdbcproperties
jdbc.driver=com.mysql.cj.jdbc.Driver
jdbc.url=jdbc:mysql:///travel?serverTimezone=UTC
jdbc.username=root
jdbc.password=root
jdbc:mysql:///user?serverTimezone=UTC&userSSL=true&userUnicode=true&characterEncoding=UTF-8