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>

<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close">
    <property name="driverClass" value="com.mysql.cj.jdbc.Driver"/>
    <property name="jdbcUrl" value="jdbc:mysql://localhost:3306/mydatabase?useSSL=false&amp;serverTimezone=UTC"/>
    <property name="user" value="username"/>
    <property name="password" value="password"/>
    <property name="minPoolSize" value="5"/>
    <property name="maxPoolSize" value="20"/>
    <property name="initialPoolSize" value="10"/>
    <property name="maxIdleTime" value="300"/>
</bean>

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import javax.sql.DataSource;
import java.sql.Connection;
import java.sql.SQLException;

@Service
public class MyService {

    @Autowired
    private DataSource dataSource;

    public void doSomething() {
        try (Connection connection = dataSource.getConnection()) {
            // 使用连接进行数据库操作
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}

<property name="maxIdleTime" value="600"/>

try (Connection connection = dataSource.getConnection()) {
    // 使用连接进行数据库操作
} catch (SQLException e) {
    e.printStackTrace();
}

<property name="driverClass" value="com.mysql.cj.jdbc.Driver"/>