commons-dbutils 这是 Apache 提供了一个开源组织 JDBC工具库，它是JDBC简包，学习成本低，和使用dbutils可以大大简化jdbc的工作量，同一时候也不会影响程序的性能。因此dbutils成为非常多不喜欢hibernate的公司的首选。

/**

 * DbUtils的使用方法:利用DbUtils实现增删改查操作

 * @project_name Day12

 * @class_name DbUtilsDemo1

 * @author Dovinya

 * @data 2014-8-27 下午11:07:09

 * @version 1

 * @notes

 */

/*

 create database day12;

 use day12;

 create table table1 (

 	id int primary key auto_increment,

 	name varchar(20),

 	salary double

 );

 insert into table1 values(null,'zhang',234.5);

 insert into table1 values(null,'li',234.5);

 insert into table1 values(null,'wang',3242);

 insert into table1 values(null,'zhao',32543);

 insert into table1 values(null,'pan',4654);

 insert into table1 values(null,'he',4235);

 *

 */

public class DbUtilsDemo1 {

	/*

	 * 利用DbUtils实现更改操作

	 */

	public void update() throws SQLException {

			//获取数据源对象

			QueryRunner runner = new QueryRunner(new ComboPooledDataSource());

			runner.update("update table1 set salary =100");

	}

	@Test

	public void add() throws SQLException{

		//获取数据源对象

		QueryRunner runner = new QueryRunner(new ComboPooledDataSource());

		runner.update("insert into table1 values(1,?

,?)","lisi",1000);

	}

	@Test

	public void delete() throws SQLException{

		//获取数据源对象

		QueryRunner runner = new QueryRunner(new ComboPooledDataSource());

		runner.update("delete from table1 where name = 'lisi'");

	}

	@Test

	public void query() throws SQLException{

		//获取数据源对象

		QueryRunner runner = new QueryRunner(new ComboPooledDataSource());

		List<User> list = runner.query("select *from table1 where id<?

", new ResultSetHandler<List<User>>(){

			@Override

			public List<User> handle(ResultSet rs) throws SQLException {

				List<User> list = new ArrayList<User>();

				while(rs.next()){

					User user = new User();

					user.setId(rs.getInt("id"));

					user.setName(rs.getString("name"));

					user.setSalary(rs.getDouble("salary"));

					list.add(user);

				}

				return list;

			}

		}, 5);

		System.out.println(list); //这里能够加断点调试观察

	}

}