c3p0连接池配置以及使用

<?xml version="1.0" encoding="UTF-8"?>
<c3p0-config>
    <!--  默认配置  -->
    <default-config>
        <!--   连接参数  -->
        <property name="driverClass">com.mysql.jdbc.Driver</property>
        <property name="jdbcUrl">jdbc:mysql://localhost:3306/Manager</property>
        <property name="user">root</property>
        <property name="password">root</property>
        <!--  连接池参数  -->
        <!-- 初始化申请的连接数量 -->
        <property name="initialPoolSize">5</property>
        <!-- 最大的连接数量 -->
        <property name="maxPoolSize">10</property>
        <!-- 超时时间 -->
        <property name="checkoutTimeout">3000</property>
    </default-config>
    <!--c3p0配置1-->
    <named-config name="c3p0">
        <!--   连接参数  -->
        <property name="driverClass">com.mysql.jdbc.Driver</property>
        <property name="jdbcUrl">jdbc:mysql://localhost:3306/manager</property>
        <property name="user">root</property>
        <property name="password">root</property>
        <!--  连接池参数  -->
        <property name="initialPoolSize">5</property>
        <property name="maxPoolSize">8</property>
        <property name="checkoutTimeout">1000</property>
    </named-config>
</c3p0-config>

public class ComboPooledDataSourceUtil {
    //无参构造硬编码
    public static DataSource getDataSource() throws PropertyVetoException {
        ComboPooledDataSource dataSource=new ComboPooledDataSource();
        dataSource.setDriverClass("com.mysql.jdbc.Driver");
        dataSource.setJdbcUrl("jdbc:mysql://localhost:3306/manager");
        dataSource.setUser("root");
        dataSource.setPassword("root");
        return dataSource;
    }
    //xml编码
    public static DataSource getDataSourceByxml(){
        ComboPooledDataSource cpds=new ComboPooledDataSource("c3p0");
        return cpds;
    }
}

  @Test
    //测试c3p0
    public void test_c3p0() throws PropertyVetoException, SQLException {
        Connection connection = ComboPooledDataSourceUtil.getDataSourceByxml().getConnection();
        //Connection connection = ComboPooledDataSourceUtil.getDataSource().getConnection();
        System.out.println(connection);
    }