DbUtils操作数据库(二)
import cn.wwh.www.web.jdbc.domain.User;
import cn.wwh.www.web.jdbc.util.JdbcUtils;
/**
*类的作用： ResultSetHandler接口的各种实现类的简单用法
*
*@author 一叶扁舟
*@version 1.0
*@创建时间： 2014-9-6 下午04:16:43
*/
public class Demo4 {
@Test
public void testBeanHandler() throws SQLException {
QueryRunner run = new QueryRunner(JdbcUtils.getDataSource());
String sql = "select * from UserInfo";
User user = run.query(sql, new BeanHandler(User.class));
System.out.println("beanHandler" + user.toString());
}
@Test
public void testBeanListHandler() throws SQLException {
QueryRunner run = new QueryRunner(JdbcUtils.getDataSource());
String sql = "select * from UserInfo";
List users = run.query(sql, new BeanListHandler(User.class));
for (User user : users) {
System.out.println(user.toString());
System.out.println();
}
}
@Test
public void testArrayHandler() throws SQLException {
QueryRunner runner = new QueryRunner(JdbcUtils.getDataSource());
String sql = "select * from userInfo";
Object[] array = (Object[]) runner.query(sql, new ArrayHandler());
System.out.println("编号 : " + array[0]);
System.out.println("用户名 : " + array[1]);
}
@Test
public void testArrayListHandler() throws SQLException {
QueryRunner runner = new QueryRunner(JdbcUtils.getDataSource());
String sql = "select * from userInfo";
List
list = (List) runner.query(sql,
new ArrayListHandler());
for (Object[] array : list) {
System.out.print("编号 : " + array[0] + "\t");
System.out.println("用户名 : " + array[1]);
}
}
@Test
public void testMapHandler() throws SQLException {
QueryRunner runner = new QueryRunner(JdbcUtils.getDataSource());
String sql = "select * from userInfo";
Map map = runner.query(sql, new MapHandler());
System.out.println("用户名：" + map.get("username"));
}
@Test
public void testMapListHandler() throws SQLException {
QueryRunner runner = new QueryRunner(JdbcUtils.getDataSource());
String sql = "select * from userInfo";
List> list = runner
.query(sql, new MapListHandler());
for (Map map : list) {
System.out.println("用户名：" + map.get("username"));
System.out.println("薪水：" + map.get("salary"));
}
}
@Test
public void testScalarHandler() throws SQLException {
QueryRunner runner = new QueryRunner(JdbcUtils.getDataSource());
String sql = "select count(*) from userInfo";
Long sum = (Long) runner.query(sql, new ScalarHandler());
System.out.println("共有" + sum + "人");
}
}