1、pom引入:
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.20</version>
</dependency>
<dependency>
<groupId>c3p0</groupId>
<artifactId>c3p0</artifactId>
<version>0.9.1.2</version>
</dependency>
2、bean.xml配置:
(1)配置QueryRunner的bean
(2)配置出c3p0数据源
(3)配置component-scan去主动加载注解方式的类进入bean容器
3、配置代码示例(增删盖查)
package com.fang.dao.Impl;
import com.fang.dao.AccountDao;
import com.fang.pojo.Account;
import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.BeanHandler;
import org.apache.commons.dbutils.handler