DbUtil的使用方法

package com.itheima.util;import java.sql.SQLException;import java.util.List;import org.apache.commons.dbutils.QueryRunner;import org.apache.commons.dbutils.handlers.ArrayHandler;import org.apache.commons.dbutils.handlers.ArrayListHandler;import org.apache.commons.dbutils.handlers.BeanHandler;import org.apache.commons.dbutils.handlers.BeanListHandler;import org.junit.Test;public class DbUtilDemo{private QueryRunner qu = new QueryRunner(C3P0Util.getDatasource());@Testpublic void add() throws Exception{String sql = "insert into account values(?,?,?)";qu.update(sql, 9,"lll",1222);}@Testpublic void addBatch() throws Exception{String sql = "insert into account values(?,?,?)";Object[][] param = new Object[10][];for(int i=0;i<param.length;i++){param[i] = new Object[]{i+20,"ccc"+i,999};}qu.batch(sql, param);}@Testpublic void query() throws Exception{String sql = "select * from account where id=?";Account ac = qu.query(sql, new BeanHandler<Account>(Account.class),1);System.out.println(ac);}@Testpublic void queryAll() throws Exception{String sql = "select * from account";List<Account> list = qu.query(sql, new BeanListHandler<Account>(Account.class));System.out.println(list);}@Testpublic void test1() throws Exception{String sql = "select * from account";Object[] obj = qu.query(sql, new ArrayHandler());for(Object ac : obj)System.out.println(ac);}@Testpublic void test2() throws Exception{String sql = "select * from account";List<Object[]> list = (List<Object[]>)qu.query(sql, new ArrayListHandler());for(Object[] ac : list)for(Object o:ac){System.out.println(o);}}}

写上面代码的前提是导入apache.common.dbutil的包