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());
@Test
public void add() throws Exception
{
String sql = "insert into account values(?,?,?)";
qu.update(sql, 9,"lll",1222);
}
@Test
public 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);
}
@Test
public 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);
}
@Test
public void queryAll() throws Exception
{
String sql = "select * from account";
List<Account> list = qu.query(sql, new BeanListHandler<Account>(Account.class));
System.out.println(list);
}
@Test
public void test1() throws Exception
{
String sql = "select * from account";
Object[] obj = qu.query(sql, new ArrayHandler());
for(Object ac : obj)
System.out.println(ac);
}
@Test
public 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的包