c3p0_diuid连接

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