c3p0配置

c3p0-config.xml（放置在src文件下）

<c3p0-config>
    <default-config>
        <property name="jdbcUrl">jdbc:mysql://localhost:3306/lsc
        </property>
        <property name="driverClass">com.mysql.jdbc.Driver</property>
        <property name="user">root</property>
        <property name="password">123</property>
        <property name="initialPoolSize">10</property>
        <property name="maxPoolSize">15</property>
        <property name="maxIdleTime">1000</property>
    </default-config>
    <named-config name="oracle_config">
        <property name="jdbcUrl">jdbc:mysql://localhost:3306/jdbc_demo</property>
        <property name="driverClass">com.mysql.jdbc.Driver</property>
        <property name="user">scot</property>
        <property name="password">tiger</property>
        <property name="initialPoolSize">3</property>
        <property name="maxPoolSize">6</property>
        <property name="maxIdleTime">1000</property>
    </named-config>
</c3p0-config>

//创建连接池
ComboPooledDataSource dataSource = new ComboPooledDataSource();