c3p0配置mysql

<dependencies>
    <!-- MySQL JDBC Driver -->
    <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>8.0.26</version>
    </dependency>
    <!-- C3P0 -->
    <dependency>
        <groupId>com.mchange</groupId>
        <artifactId>c3p0</artifactId>
        <version>0.9.5.5</version>
    </dependency>
</dependencies>

# 数据库连接配置
jdbc.driverClass=com.mysql.cj.jdbc.Driver
jdbc.jdbcUrl=jdbc:mysql://localhost:3306/mydatabase?useSSL=false&serverTimezone=UTC
jdbc.user=root
jdbc.password=root

# C3P0 连接池配置
c3p0.minPoolSize=5
c3p0.maxPoolSize=20
c3p0.initialPoolSize=10
c3p0.acquireIncrement=5
c3p0.maxIdleTime=1800
c3p0.maxStatements=0
c3p0.idleConnectionTestPeriod=60

import com.mchange.v2.c3p0.ComboPooledDataSource;

import java.beans.PropertyVetoException;
import java.sql.Connection;
import java.sql.SQLException;

public class DataSource {
    private static ComboPooledDataSource cpds = new ComboPooledDataSource();

    static {
        try {
            cpds.setDriverClass("com.mysql.cj.jdbc.Driver");
            cpds.setJdbcUrl("jdbc:mysql://localhost:3306/mydatabase?useSSL=false&serverTimezone=UTC");
            cpds.setUser("root");
            cpds.setPassword("root");

            cpds.setMinPoolSize(5);
            cpds.setMaxPoolSize(20);
            cpds.setInitialPoolSize(10);
            cpds.setAcquireIncrement(5);
            cpds.setMaxIdleTime(1800);
            cpds.setMaxStatements(0);
            cpds.setIdleConnectionTestPeriod(60);
        } catch (PropertyVetoException e) {
            e.printStackTrace();
        }
    }

    public static Connection getConnection() throws SQLException {
        return cpds.getConnection();
    }
}