DButils之ResultSetHandler

1. ResultSetHandler的几个实现类

public class TestResultSetHandler {

	/*
	 * ArrayHandler:适合取一条记录.把该条记录的每列值封装到一个数组中Object[] 
	 * 				如果不传参数,只需要取第一条记录
	 */
	@Test
	public void test1() throws SQLException {
		QueryRunner qr = new QueryRunner(C3P0Util.getDataSource());

		String sql = "select * from user where id=?";
		Object[] arr = qr.query(sql, new ArrayHandler(), 1);

		for (Object o : arr) {
			System.out.println(o);
		}
	}

	/*
	 * ArrayListHandler:适合取多条记录.把每条记录的每列值封装到一个数组中Object[],把数封装到一个List中
	 */
	@Test
	public void test2() throws SQLException {
		QueryRunner qr = new QueryRunner(C3P0Util.getDataSource());
		String sql = "select * from user";
		List<Object[]> query = qr.query(sql, new ArrayListHandler());

		for (Object[] objects : query) {
			for (Object object : objects) {
				System.out.print(object + "  ");
			}
			System.out.println();
		}
	}
	
	
	/*
	 * ColumnListHandler:取某一列的数据.封装到List中
	 * 参数表示取的是sql语句里的第几列
	 */
	@Test
	public void test3() throws SQLException {
		QueryRunner qr = new QueryRunner(C3P0Util.getDataSource());
		String sql="select username,password from user";
		List<Object> list = qr.query(sql, new ColumnListHandler<Object>(2));
		
		for(Object object:list){
			System.out.println(object);
		}
	}
	
	
	/*
	 * KeyedHandler:取多条记录,每一条记录封装到一个Map中,再把这个Map封装到另外一个Map中,key为指定的字段值
	 */
	@Test
	public void test4() throws SQLException {
		QueryRunner qr = new QueryRunner(C3P0Util.getDataSource());
		
		//大Map的key是表中的某列数据,小Map的key是表的列名,所以大Map的Key是Object类型,小Map的Key是String类型
		String sql="select * from user";
		Map<Object, Map<String, Object>> query = qr.query(sql, new KeyedHandler<>(1),1);
		
		Set<Object> set = query.keySet();
		for(Object key:set){
			System.out.println(key);
			Map<String, Object> value = query.get(key);
			Set<String> keySet = value.keySet();
			for(String keyset:keySet){
				System.out.println(keyset+"---"+value.get(keyset));
			}
			
			System.out.println();
		}
	}
	
	
	/*
	 * MapHandler:适合取1条记录,把当前记录的列名和列值放到一个Map中
	 * 不加where默认取第一条记录
	 */
	@Test
	public void test5() throws SQLException {
		QueryRunner qr = new QueryRunner(C3P0Util.getDataSource());
		String sql="select * from user where id=?";
		Map<String, Object> query = qr.query(sql, new MapHandler(),2);
		for(Map.Entry<String, Object> m:query.entrySet()){
			System.out.println(m.getKey()+"------"+m.getValue());
		}
	}
	
	
	/*
	 * MapListHandler:适合取多条记录,把每条记录封装到一个Map中,再把Map封装到List中
	 * 不加where默认取第一条记录
	 */
	@Test
	public void test6() throws SQLException {
		QueryRunner qr = new QueryRunner(C3P0Util.getDataSource());
		String sql="select * from user";
		List<Map<String, Object>> query = qr.query(sql, new MapListHandler());
		
		for(Map<String, Object> list:query){
			for(Map.Entry<String, Object> map:list.entrySet()){
				System.out.println(map.getKey()+"----"+map.getValue());
			}
			System.out.println();
		}
	}
	
	
	/*
	 * ScalarHandler:适合取单行单列数据
	 */
	@Test
	public void test7() throws SQLException {
		QueryRunner qr = new QueryRunner(C3P0Util.getDataSource());
		String sql="select username from user";
		Object query = qr.query(sql, new ScalarHandler<Object>());
		System.out.println(query);
	}
	
	
	/*
	 * BeanHandler:表示把结果集中的一行数据，封装成一个对象，专门针对结果集中只有一行数据的情况
	 */
	@Test
	public void test8() throws SQLException {
		QueryRunner qr = new QueryRunner(C3P0Util.getDataSource());
		String sql="select * from user where id=?";
		User query = qr.query(sql, new BeanHandler<User>(User.class),2);
		System.out.println(query);
	}
	
	/*
	 * 
	 */
	@Test
	public void test9() throws SQLException {
		QueryRunner qr = new QueryRunner(C3P0Util.getDataSource());
		String sql="select * from user where id=?";
		List<User> query = qr.query(sql, new BeanListHandler<User>(User.class),2);
		for(User user:query){
			System.out.println(user);
		}
		
	}
}