MyBatis学习7之分页查询

（紧接着mybatsi学习6）分页查询使我们在做web开发中最常见的查询（本示例是在sqlite数据库中测试）

1、修改sql映射文件

<select id="pageQuery" resultMap="pageQuery">
	select u.id,u.user_name,u.password,u.pid,u.state 
	from t_user  u
	limit #{pageNum},#{pageSize}
</select>
<resultMap type="com.zlt.mybatis.vo.PersonInfoVo" id="pageQuery" extends="personResultMap">
</resultMap>

 2、编写单元测试

public void testQuery3(){
		SqlSession session = null;
		try{
				session = sqlSessionFactory.openSession();
				String statement = "com.zlt.mybatis.vo.PersonInfoVo.pageQuery";
				//List<PersonInfoVo> persons = session.selectList(statement);
				Map<String, String> map = new HashMap<String, String>();
				map.put("pageNum", "1");
				map.put("pageSize", "2");
				List<PersonInfoVo> persons = session.selectList(statement,map);
				for(PersonInfoVo person : persons){
					if(null != person) {
						System.out.println("id:" + person.getId() + "\tuserName:" + person.getUserName() + "\tpassword:" + person.getPassword() + "\tpid:" + person.getPid() +"\tstate:" + person.getState());
					}
				}
			}finally{
			if(null != session) session.close();
		}
	}