JavaWeb——DBUtils

DBUtils可以帮助开发者完成数据的封装（结果集到Java对象的映射）

ResultHandler接口是用来处理结果集，可以将查询到的结果集转成Java对象，提供了4种实现类。

• BeanHandler：将结果集映射成Java对象Student
• BeanListHandler：将结果集映射成List集合List <Student>
• MapHandler：将结果集映射成Map对象
• MapListHandler：将结果集映射成MapList集合

public static Student findByDBUtils(Integer id) {
		Connection conn = null;
		Student student = null;
		try {
			conn = dataSource.getConnection();
			String sql = "select * from student";
			QueryRunner queryRunner = new QueryRunner();
			List<Map<String,Object>> list = queryRunner.query(conn,sql,new MapListHandler());
			for(Map<String,Object> map:list) {
				System.out.println(map);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} finally {
			try {
				conn.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		return student;
	}