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 list = runner.query(select *from table1 where id