简单的用c3p0和dbutils实现的数据库增删查改

简单的用c3p0和dbutils实现的数据库增删查改

JdbcUtils.java

import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.BeanHandler;
import org.apache.commons.dbutils.handlers.BeanListHandler;

import com.mchange.v2.c3p0.ComboPooledDataSource;

public class JdbcUtils {
	public QueryRunner runner = new QueryRunner(new ComboPooledDataSource());
	

	// 查询所有数据
	public ArrayList<Student> queryAll() {

		ArrayList<Student> list = null;
		
		String sql = "select * from student";
		try {
			
			//查询所有数据,并将数据存入集合中
			list = (ArrayList<Student>) runner.query(sql, new BeanListHandler<Student>(Student.class));

		} catch (SQLExce