MyBatis实现简单的分页

　　//Mapper接口
	// #　标准的替代　　$等量替代　${sort} ${order} 
	@Select("select * from t_user where (username like #{name} or password like #{name}) order by ${sort} ${order} limit #{pageOffset},#{pageSize} ")
	public List<User> findAll(Map<String, Object> map);
	@Select("select count(*) from t_user where (username like #{name} or password like #{name})")
	public int findCount(Map<String, Object> map);
    
     //Dao
	　　 int pageSize = SystemContext.getPageSize();
		int pageOffset = SystemContext.getPageOffset();
		String order = SystemContext.getOrder();
		String sort = SystemContext.getSort();
		SqlSession sqlSession = null;
		Pager<User> pages = new Pager<User>();
		try {
			sqlSession = MyBatisUtil.createSession();
			Map<String, Object> params = new HashMap<String, Object>();
			params.put("name", "%" + name + "%");
			params.put("pageSize", pageSize);
			params.put("pageOffset", pageOffset);
			params.put("order", order);
			params.put("sort", sort);
			List<User> datas = sqlSession.getMapper(UserMapper.class).findAll(
					params);

			pages.setDatas(datas);
			pages.setPageOffset(pageOffset);
			pages.setPageSize(pageSize);
			int count = sqlSession.getMapper(UserMapper.class)
					.findCount(params);
			pages.setTotalRecord(count);
		} catch (Exception e) {
			// TODO: handle exception
			e.printStackTrace();
		} finally {
			MyBatisUtil.closeSession(sqlSession);
		}