c3p0连接数据库

首先配置pom.xml文件

<dependencies>
    <!-- spring -->
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-core</artifactId>
      <version>${spring.version}</version>
    </dependency>

    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-beans</artifactId>
      <version>${spring.version}</version>
    </dependency>

    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-context</artifactId>
      <version>${spring.version}</version>
    </dependency>

    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-expression</artifactId>
      <version>${spring.version}</version>
    </dependency>

    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-tx</artifactId>
      <version>${spring.version}</version>
    </dependency>

    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-web</artifactId>
      <version>${spring.version}</version>
    </dependency>

    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-test</artifactId>
      <version>${spring.version}</version>
    </dependency>

    <dependency>
      <groupId>junit</groupId>
      <artifactId>junit</artifactId>
      <version>4.13</version>
      <scope>test</scope>
    </dependency>

    <!--切入点表达式的支持-->
    <dependency>
      <groupId> org.aspectj</groupId>
      <artifactId> aspectjweaver</artifactId>
      <version> 1.6.11</version>
    </dependency>
    <dependency>
      <groupId>junit</groupId>
      <artifactId>junit</artifactId>
      <version>4.12</version>
      <scope>compile</scope>
    </dependency>

    <!-- Spring-jdbc 用于配置JdbcTemplate -->
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-jdbc</artifactId>
      <version>${spring.version}</version>
    </dependency>

    <!--c3p0-->
    <dependency>
      <groupId>com.mchange</groupId>
      <artifactId>c3p0</artifactId>
      <version>0.9.5.2</version>
    </dependency>

    <dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
      <version>5.1.17</version>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-jdbc</artifactId>
      <version>${spring.version}</version>
    </dependency>
  </dependencies>

配置applicationContext.xml文件

<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
        <property name="driverClass" value="${jdbc.driverClassName}"/>
        <property name="jdbcUrl" value="${jdbc.url}"/>
        <property name="user" value="${jdbc.username}"/>
        <property name="password" value="${jdbc.password}"/>
    </bean>
    <!--2.加载jdbc配置文件-->
    <context:property-placeholder location="classpath:jdbc.properties"/>
    <!-- 将JDBC交给模板管理 -->
    <bean id="JdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
        <property name="dataSource" ref="dataSource"/>
    </bean>

配置jdbc.properties文件

jdbc.url=jdbc:mysql:///mydb
jdbc.driverClassName=com.mysql.jdbc.Driver
jdbc.username=root
jdbc.password=123456

添加测试方法

@RunWith(SpringRunner.class)
@ContextConfiguration("classpath:applicationContext.xml")
public class C3p0Test {
    @Autowired
    private JdbcTemplate jdbcTemplate;

    @Test
    public  void test1(){
        System.out.println("===========");
        List<Map<String,Object>> list= jdbcTemplate.queryForList("select * from user ");

        list.forEach((m->{m.keySet().
           forEach(k ->System.out.println("key="+k+" "+m.get(k)));}));
    }
    @Test
    public  void test2(){
        System.out.println("===========");
        int num=1;
        int i = jdbcTemplate.update("delete from user where uid = ?", num);
        System.out.println("i="+i);
        if (i>0){
            System.out.println("删除成功");
            test1();
        }else {
            System.out.println("删除失败");
        }

    }
}

测试结果