Dropwizard和c3p0集成

<dependency>
    <groupId>com.mchange</groupId>
    <artifactId>c3p0</artifactId>
    <version>0.9.5.5</version>
</dependency>

database:
  driverClass: com.mysql.jdbc.Driver
  user: root
  password: password
  url: jdbc:mysql://localhost:3306/mydatabase
  properties:
    # c3p0连接池配置
    c3p0:
      minPoolSize: 5
      maxPoolSize: 20
      acquireIncrement: 5
      maxStatements: 100

import com.mchange.v2.c3p0.ComboPooledDataSource;

public class MyResource {
    private ComboPooledDataSource dataSource;

    public MyResource() {
        // 初始化c3p0连接池
        dataSource = new ComboPooledDataSource();
        // 设置连接池参数
        dataSource.setDriverClass("com.mysql.jdbc.Driver");
        dataSource.setJdbcUrl("jdbc:mysql://localhost:3306/mydatabase");
        dataSource.setUser("root");
        dataSource.setPassword("password");
        dataSource.setMinPoolSize(5);
        dataSource.setMaxPoolSize(20);
        dataSource.setAcquireIncrement(5);
        dataSource.setMaxStatements(100);
    }

    public void doSomething() {
        try (Connection connection = dataSource.getConnection()) {
            // 使用数据库连接执行操作
            // ...
        } catch (SQLException e) {
            // 处理异常
        }
    }
}