Java Code Examples for com.baomidou.mybatisplus.extension.plugins.pagination.Page#getRecords()

The following examples show how to use com.baomidou.mybatisplus.extension.plugins.pagination.Page#getRecords() . You can vote up the ones you like or vote down the ones you don't like, and go to the original project or source file by following the links above each example. You may check out the related API usage on the sidebar.
Example 1
Source File: PostController.java    From SENS with GNU General Public License v3.0 6 votes vote down vote up 
/**
 * 待审核文章列表
 *
 * @param model model
 * @return 模板路径admin/admin_post
 */
@GetMapping("/check")
public String postCheckList(Model model,
                            @RequestParam(value = "page", defaultValue = "1") Integer pageNumber,
                            @RequestParam(value = "size", defaultValue = "15") Integer pageSize,
                            @RequestParam(value = "sort", defaultValue = "createTime") String sort,
                            @RequestParam(value = "order", defaultValue = "desc") String order,
                            @ModelAttribute SearchVo searchVo) {
    Post condition = new Post();
    condition.setPostType(PostTypeEnum.POST_TYPE_POST.getValue());
    condition.setPostStatus(PostStatusEnum.CHECKING.getCode());
    Page page = PageUtil.initMpPage(pageNumber, pageSize, sort, order);
    Page<Post> posts = postService.findAll(
            page,
            new QueryCondition<>(condition, searchVo));
    List<Post> postList = posts.getRecords();
    postList.forEach(post -> userService.get(post.getUserId()));
    model.addAttribute("posts", postList);
    model.addAttribute("pageInfo", PageUtil.convertPageVo(page));
    model.addAttribute("order", order);
    model.addAttribute("sort", sort);
    return "admin/admin_post_check";
}
Example 2
Source File: BlogInfoServiceImpl.java    From My-Blog-layui with Apache License 2.0 6 votes vote down vote up 
@Override
public List<SimpleBlogListVO> getHotBlog() {
    List<SimpleBlogListVO> simpleBlogListVOS = new ArrayList<>();
    Page<BlogInfo> page = new Page<>(1,5);
    blogInfoMapper.selectPage(page,new QueryWrapper<BlogInfo>()
            .lambda()
            .eq(BlogInfo::getBlogStatus, BlogStatusConstants.ONE)
            .eq(BlogInfo::getIsDeleted,BlogStatusConstants.ZERO)
            .orderByDesc(BlogInfo::getBlogViews));
    for (BlogInfo blogInfo : page.getRecords()){
        SimpleBlogListVO simpleBlogListVO = new SimpleBlogListVO();
        BeanUtils.copyProperties(blogInfo, simpleBlogListVO);
        simpleBlogListVOS.add(simpleBlogListVO);
    }
    return simpleBlogListVOS;
}
Example 3
Source File: MyBlogController.java    From My-Blog-layui with Apache License 2.0 6 votes vote down vote up 
@GetMapping({"/search/{keyword}/{pageNum}"})
public String search(HttpServletRequest request, @PathVariable("keyword") String keyword, @PathVariable("pageNum") Integer pageNum) {

    Page<BlogInfo> page = new Page<BlogInfo>(pageNum, 8);
    blogInfoService.page(page, new QueryWrapper<BlogInfo>()
            .lambda().like(BlogInfo::getBlogTitle, keyword)
            .eq(BlogInfo::getBlogStatus,BlogStatusConstants.ONE)
            .eq(BlogInfo::getIsDeleted,BlogStatusConstants.ZERO)
            .orderByDesc(BlogInfo::getCreateTime));
    PageResult blogPageResult = new PageResult
            (page.getRecords(), page.getTotal(), 8, pageNum);

    request.setAttribute("blogPageResult", blogPageResult);
    request.setAttribute("pageName", "搜索");
    request.setAttribute("pageUrl", "search");
    request.setAttribute("keyword", keyword);
    request.setAttribute("newBlogs", blogInfoService.getNewBlog());
    request.setAttribute("hotBlogs", blogInfoService.getHotBlog());
    request.setAttribute("hotTags", blogTagService.getBlogTagCountForIndex());
    request.setAttribute("configurations", blogConfigService.getAllConfigs());
    return "blog/" + theme + "/list";
}
Example 4
Source File: BlogInfoServiceImpl.java    From My-Blog-layui with Apache License 2.0 6 votes vote down vote up 
@Override
public List<SimpleBlogListVO> getNewBlog() {
    List<SimpleBlogListVO> simpleBlogListVOS = new ArrayList<>();
    Page<BlogInfo> page = new Page<>(1,5);
    blogInfoMapper.selectPage(page,new QueryWrapper<BlogInfo>()
            .lambda()
            .eq(BlogInfo::getBlogStatus, BlogStatusConstants.ONE)
            .eq(BlogInfo::getIsDeleted,BlogStatusConstants.ZERO)
            .orderByDesc(BlogInfo::getCreateTime));
    for (BlogInfo blogInfo : page.getRecords()){
        SimpleBlogListVO simpleBlogListVO = new SimpleBlogListVO();
        BeanUtils.copyProperties(blogInfo, simpleBlogListVO);
        simpleBlogListVOS.add(simpleBlogListVO);
    }
    return simpleBlogListVOS;
}
Example 5
Source File: MyBlogController.java    From My-Blog-layui with Apache License 2.0 6 votes vote down vote up 
/**
 * 分类列表
 *
 * @param request
 * @param categoryName
 * @param pageNum
 * @return java.lang.String
 * @date 2019/9/6 13:04
 */
@GetMapping({"/category/{categoryName}/{pageNum}"})
public String category(HttpServletRequest request, @PathVariable("categoryName") String categoryName, @PathVariable("pageNum") Integer pageNum) {
    Page<BlogInfo> page = new Page<BlogInfo>(pageNum, 8);
    blogInfoService.page(page, new QueryWrapper<BlogInfo>()
            .lambda()
            .eq(BlogInfo::getBlogStatus,BlogStatusConstants.ONE)
            .eq(BlogInfo::getIsDeleted,BlogStatusConstants.ZERO)
            .eq(BlogInfo::getBlogCategoryName, categoryName)
            .orderByDesc(BlogInfo::getCreateTime));
    PageResult blogPageResult = new PageResult
            (page.getRecords(), page.getTotal(), 8, pageNum);

    request.setAttribute("blogPageResult", blogPageResult);
    request.setAttribute("pageName", "分类");
    request.setAttribute("pageUrl", "category");
    request.setAttribute("keyword", categoryName);
    request.setAttribute("newBlogs", blogInfoService.getNewBlog());
    request.setAttribute("hotBlogs", blogInfoService.getHotBlog());
    request.setAttribute("hotTags", blogTagService.getBlogTagCountForIndex());
    request.setAttribute("configurations", blogConfigService.getAllConfigs());
    return "blog/" + theme + "/list";
}
Example 6
Source File: DemoController.java    From spring-boot-starter-samples with Apache License 2.0 5 votes vote down vote up 
@ApiOperation(value = "获取xxx列表", notes = "分页查询xxx信息")
@ApiImplicitParams({ 
	@ApiImplicitParam(name = "pageNo", value = "当前页码", required = true, dataType = "Integer"),
	@ApiImplicitParam(name = "limit", value = "每页记录数", required = true, dataType = "Integer"),
	@ApiImplicitParam(name = "sortName", value = "排序字段名称", required = true, dataType = "String"),
	@ApiImplicitParam(name = "sortOrder", value = "排序类型 asc \\ desc", required = true, dataType = "String"),
	@ApiImplicitParam(name = "demoVo", value = "用户详细实体user", required = true, dataType = "UserVo") 
})
   @ApiResponses({ 
	@ApiResponse(code = HttpStatus.SC_OK, message = "操作成功"),
	@ApiResponse(code = HttpStatus.SC_UNAUTHORIZED, message = "请求要求身份验证"),
	@ApiResponse(code = HttpStatus.SC_NOT_FOUND, message = "请求资源不存在"),
	@ApiResponse(code = HttpStatus.SC_INTERNAL_SERVER_ERROR, message = "服务器内部异常"),
	@ApiResponse(code = HttpStatus.SC_FORBIDDEN, message = "权限不足") 
})
   @BusinessLog(module = LogConstant.Module.N01, business = LogConstant.BUSINESS.N010001, opt = BusinessType.SELECT)
@PostMapping(value = "list")
@ResponseBody
public Object list( Integer pageNo, Integer limit,
		String sortName, String sortOrder, DemoVo demoVo, 
		HttpServletRequest request) throws Exception {
	try {
		
		Page<DemoModel> pageResult = getDemoService().getPagedList(null);
		List<DemoVo> retList = new ArrayList<DemoVo>();
		for (DemoModel model : pageResult.getRecords()) {
			retList.add(getBeanMapper().map(model, DemoVo.class));
		}
		return new Result<DemoVo>(pageResult, retList);
	} catch (Exception e) {
		logException(this, e);
		return error("");
	}
}
Example 7
Source File: DemoController.java    From spring-boot-starter-samples with Apache License 2.0 5 votes vote down vote up 
@ApiOperation(value = "获取xxx列表", notes = "分页查询xxx信息")
@ApiImplicitParams({ 
	@ApiImplicitParam(name = "pageNo", value = "当前页码", required = true, dataType = "Integer"),
	@ApiImplicitParam(name = "limit", value = "每页记录数", required = true, dataType = "Integer"),
	@ApiImplicitParam(name = "sortName", value = "排序字段名称", required = true, dataType = "String"),
	@ApiImplicitParam(name = "sortOrder", value = "排序类型 asc \\ desc", required = true, dataType = "String"),
	@ApiImplicitParam(name = "demoVo", value = "用户详细实体user", required = true, dataType = "UserVo") 
})
   @ApiResponses({ 
	@ApiResponse(code = HttpStatus.SC_OK, message = "操作成功"),
	@ApiResponse(code = HttpStatus.SC_UNAUTHORIZED, message = "请求要求身份验证"),
	@ApiResponse(code = HttpStatus.SC_NOT_FOUND, message = "请求资源不存在"),
	@ApiResponse(code = HttpStatus.SC_INTERNAL_SERVER_ERROR, message = "服务器内部异常"),
	@ApiResponse(code = HttpStatus.SC_FORBIDDEN, message = "权限不足") 
})
   @BusinessLog(module = LogConstant.Module.N01, business = LogConstant.BUSINESS.N010001, opt = BusinessType.SELECT)
@PostMapping(value = "list")
@ResponseBody
public Object list( Integer pageNo, Integer limit,
		String sortName, String sortOrder, DemoVo demoVo, 
		HttpServletRequest request) throws Exception {
	try {
		
		Page<DemoModel> pageResult = getDemoService().getPagedList(null);
		List<DemoVo> retList = new ArrayList<DemoVo>();
		for (DemoModel model : pageResult.getRecords()) {
			retList.add(getBeanMapper().map(model, DemoVo.class));
		}
		return new Result<DemoVo>(pageResult, retList);
	} catch (Exception e) {
		logException(this, e);
		return error("");
	}
}
Example 8
Source File: R.java    From kvf-admin with MIT License 5 votes vote down vote up 
private R(int code, String msg, Object data) {
    this.code = code;
    this.msg = msg;
    if (data instanceof Page<?>) {
        Page<?> page = (Page<?>) data;
        this.total = page.getTotal();
        this.data = page.getRecords();
    } else {
        this.data = data;
    }
}
Example 9
Source File: BeanMapper.java    From ruoyiplus with MIT License 5 votes vote down vote up 
public static <S, T> Page<T> mapPage(Page<S> sourcePage, Class<T> destinationClass,
                                     BeanMappingHandler<S, T> handler) {
    List<T> destinationList = Lists.newArrayList();
    for (S sourceObject : sourcePage.getRecords()) {
        T destinationObject = handler.map(sourceObject, destinationClass);
        destinationList.add(destinationObject);
    }
    Page<T> pageData = new Page<>();
    BeanUtils.copyProperties(sourcePage, pageData, "records");
    pageData.setRecords(destinationList);

    return pageData;
}
Example 10
Source File: BeanMapper.java    From ruoyiplus with MIT License 5 votes vote down vote up 
public static <T> Page<T> mapPage(Page sourcePage, Class<T> destinationClass) {
    List<T> destinationList = Lists.newArrayList();
    for (Object sourceObject : sourcePage.getRecords()) {
        T destinationObject = dozer.map(sourceObject, destinationClass);
        destinationList.add(destinationObject);
    }

    Page<T> pageData = new Page<>();
    BeanUtils.copyProperties(sourcePage, pageData, "records");
    pageData.setRecords(destinationList);
    return pageData;
}
Example 11
Source File: MyBlogController.java    From My-Blog-layui with Apache License 2.0 5 votes vote down vote up 
/**
 * 标签分类
 *
 * @param request
 * @param tagId
 * @param pageNum
 * @return java.lang.String
 * @date 2019/9/6 7:04
 */
@GetMapping({"/tag/{tagId}/{pageNum}"})
public String tag(HttpServletRequest request, @PathVariable("tagId") String tagId, @PathVariable("pageNum") Integer pageNum) {
    List<BlogTagRelation> list = blogTagRelationService.list(new QueryWrapper<BlogTagRelation>()
            .lambda().eq(BlogTagRelation::getTagId, tagId));
    PageResult blogPageResult = null;
    if (!list.isEmpty()){
        Page<BlogInfo> page = new Page<BlogInfo>(pageNum, 8);
        blogInfoService.page(page, new QueryWrapper<BlogInfo>()
                .lambda()
                .eq(BlogInfo::getBlogStatus,BlogStatusConstants.ONE)
                .eq(BlogInfo::getIsDeleted,BlogStatusConstants.ZERO)
                .in(BlogInfo::getBlogId, list.stream().map(BlogTagRelation::getBlogId).toArray())
                .orderByDesc(BlogInfo::getCreateTime));
        blogPageResult = new PageResult
                (page.getRecords(), page.getTotal(), 8, pageNum);
    }
    request.setAttribute("blogPageResult", blogPageResult);
    request.setAttribute("pageName", "标签");
    request.setAttribute("pageUrl", "tag");
    request.setAttribute("keyword", tagId);
    request.setAttribute("newBlogs", blogInfoService.getNewBlog());
    request.setAttribute("hotBlogs", blogInfoService.getHotBlog());
    request.setAttribute("hotTags", blogTagService.getBlogTagCountForIndex());
    request.setAttribute("configurations", blogConfigService.getAllConfigs());
    return "blog/" + theme + "/list";
}
Example 12
Source File: FrontIndexController.java    From SENS with GNU General Public License v3.0 5 votes vote down vote up 
/**
 * 搜索
 *
 * @param model model
 * @return 模板路径/themes/{theme}/index
 */
@GetMapping(value = "/search/page/{pageNumber}")
public String searchPage(Model model,
                         @PathVariable(value = "pageNumber") Integer pageNumber,
                         @RequestParam(value = "size", defaultValue = "15") Integer pageSize,
                         @RequestParam(value = "sort", defaultValue = "createTime") String sort,
                         @RequestParam(value = "order", defaultValue = "desc") String order,
                         @RequestParam("keyword") String keyword) {
    Page page = PageUtil.initMpPage(pageNumber, pageSize, sort, order);
    Page<Post> posts = null;
    Long startTime = System.currentTimeMillis();
    //如果开启了ES
    if (StringUtils.equals(SensConst.OPTIONS.get(BlogPropertiesEnum.OPEN_ELASTICSEARCH.getProp()), TrueFalseEnum.TRUE.getValue())) {
        Map<String, Object> map = new HashMap<>(2);
        map.put("postStatus", PostStatusEnum.PUBLISHED.getCode());
        map.put("postTitle", keyword);
        posts = postService.findPostsByEs(map, page);
    } else {
        Post condition = new Post();
        condition.setPostTitle(keyword);
        condition.setPostContent(keyword);
        condition.setPostStatus(PostStatusEnum.PUBLISHED.getCode());
        posts = postService.findAll(page, new QueryCondition(condition));
    }
    model.addAttribute("time", (System.currentTimeMillis() - startTime) + "ms");
    List<Post> postList = posts.getRecords();
    model.addAttribute("prefix", "/search");
    model.addAttribute("suffix", "?keyword=" + keyword);
    model.addAttribute("pageInfo", PageUtil.convertPageVo(page));
    model.addAttribute("posts", postList);
    return this.render("search");
}
Example 13
Source File: FrontOthersController.java    From SENS with GNU General Public License v3.0 5 votes vote down vote up 
/**
 * 获取文章rss
 *
 * @return rss
 */
@GetMapping(value = {"feed", "feed.xml", "atom", "atom.xml"}, produces = "application/xml;charset=UTF-8")
@ResponseBody
public String feed() {
    String rssPosts = SensConst.OPTIONS.get(BlogPropertiesEnum.RSS_POSTS.getProp());
    if (StringUtils.isBlank(rssPosts)) {
        rssPosts = "20";
    }
    //获取文章列表并根据时间排序
    Page pageable = new Page(0, Integer.parseInt(rssPosts));
    Page<Post> postsPage = postService.pagingByPostTypeAndStatus(PostTypeEnum.POST_TYPE_POST.getValue(), PostStatusEnum.PUBLISHED.getCode(), pageable);
    List<Post> posts = postsPage.getRecords();
    return postService.buildRss(posts);
}
Example 14
Source File: FrontCommentController.java    From SENS with GNU General Public License v3.0 5 votes vote down vote up 
/**
 * 加载评论
 *
 * @param page 页码
 * @param post 当前文章
 * @return List
 */
@GetMapping(value = "/loadComment")
@ResponseBody
public List<Comment> loadComment(@RequestParam(value = "page") Integer page,
                                 @RequestParam(value = "post") Post post) {
    Page pagination = new Page(page, 10);
    Page<Comment> comments = commentService.pagingCommentsByPostAndCommentStatus(post.getId(), CommentStatusEnum.PUBLISHED.getCode(), pagination);
    return comments.getRecords();
}
Example 15
Source File: FrontTagController.java    From SENS with GNU General Public License v3.0 4 votes vote down vote up 
/**
 * 根据标签路径查询所有文章 分页
 *
 * @param model      model
 * @param id         ID
 * @param pageNumber 页码
 * @return String
 */
@GetMapping(value = "/{id}/page/{pageNumber}")
public String tags(Model model,
                   @PathVariable("id") Long id,
                   @PathVariable(value = "pageNumber") Integer pageNumber,
                   @RequestParam(value = "size", defaultValue = "15") Integer pageSize,
                   @RequestParam(value = "sort", defaultValue = "createTime") String sort,
                   @RequestParam(value = "order", defaultValue = "desc") String order) {
    Tag tag = tagService.get(id);
    if (null == tag) {
        return this.renderNotFound();
    }
    if (!StringUtils.isBlank(SensConst.OPTIONS.get(BlogPropertiesEnum.INDEX_POSTS.getProp()))) {
        pageSize = Integer.parseInt(SensConst.OPTIONS.get(BlogPropertiesEnum.INDEX_POSTS.getProp()));
    }
    Page page = PageUtil.initMpPage(pageNumber, pageSize, sort, order);
    Page<Post> posts = postService.findPostsByTags(tag, page);
    List<Post> postList = posts.getRecords();
    User user = userService.get(tag.getUserId());
    postList.forEach(post -> {
        post.setCategories(categoryService.findByPostId(post.getId()));
        post.setUser(user);
    });
    model.addAttribute("posts", postList);
    model.addAttribute("pageInfo", PageUtil.convertPageVo(page));

    model.addAttribute("tag", tag);
    model.addAttribute("prefix", "/tag/" + id);


    //侧边栏
    model.addAttribute("sidebarType", SidebarTypeEnum.TAG.getValue());
    if (user != null) {
        //该用户的文章数
        Integer postCount = postService.countByUserId(user.getId());
        user.setPostCount(postCount);
        //该用户的评论数
        Integer commentCount = commentService.countByUserId(user.getId());
        user.setCommentCount(commentCount);
        //该用户上次登录时间
        model.addAttribute("lastLogin", SensUtils.getRelativeDate(user.getLoginLast()));
        model.addAttribute("author", user);
        model.addAttribute("tagRanking", tagService.getTagRankingByUserId(user.getId(), 100));
    }
    return this.render("tag");
}
Example 16
Source File: FrontIndexController.java    From SENS with GNU General Public License v3.0 4 votes vote down vote up 
/**
 * 首页分页
 *
 * @param model model
 * @return 模板路径/themes/{theme}/index
 */
@GetMapping(value = "/author/{userName}/page/{pageNumber}")
public String postsByUserName(Model model,
                              @PathVariable(value = "userName") String userName,
                              @PathVariable(value = "pageNumber") Integer pageNumber,
                              @RequestParam(value = "size", defaultValue = "15") Integer pageSize,
                              @RequestParam(value = "sort", defaultValue = "createTime") String sort,
                              @RequestParam(value = "order", defaultValue = "desc") String order) {

    User user = userService.findByUserName(userName);
    if (user == null) {
        return renderNotFound();
    }
    Page page = PageUtil.initMpPage(pageNumber, pageSize, sort, order);

    Post condition = new Post();
    condition.setUserId(user.getId());
    Page<Post> posts = postService.findAll(page, new QueryCondition<>(condition));
    List<Post> postList = posts.getRecords();
    postList.forEach(post -> {
        post.setCategories(categoryService.findByPostId(post.getId()));
        post.setUser(user);
    });

    //该用户的文章数
    Integer postCount = postService.countByUserId(user.getId());
    user.setPostCount(postCount);
    //该用户的评论数
    Integer commentCount = commentService.countByUserId(user.getId());
    user.setCommentCount(commentCount);

    model.addAttribute("prefix", "/author/" + userName);
    model.addAttribute("pageInfo", PageUtil.convertPageVo(page));
    model.addAttribute("posts", postList);

    //侧边栏
    model.addAttribute("sidebarType", SidebarTypeEnum.AUTHOR.getValue());
    model.addAttribute("author", user);
    model.addAttribute("lastLogin", SensUtils.getRelativeDate(user.getLoginLast()));
    model.addAttribute("tagRanking", tagService.getTagRankingByUserId(user.getId(), 100));
    return this.render("author");
}
Example 17
Source File: SysDictServiceImpl.java    From jeecg-cloud with Apache License 2.0 4 votes vote down vote up 
@Override
public List<DictModel> queryDictTablePageList(DictQuery query, int pageSize, int pageNo) {
	Page page = new Page(pageNo,pageSize,false);
	Page<DictModel> pageList = baseMapper.queryDictTablePageList(page, query);
	return pageList.getRecords();
}
Example 18
Source File: FrontIndexController.java    From SENS with GNU General Public License v3.0 4 votes vote down vote up 
/**
 * 首页分页
 *
 * @param model model
 * @return 模板路径/themes/{theme}/index
 */
@GetMapping(value = "/page/{pageNumber}")
public String index(Model model,
                    @PathVariable(value = "pageNumber") Integer pageNumber,
                    @RequestParam(value = "size", defaultValue = "15") Integer pageSize,
                    @RequestParam(value = "sort", defaultValue = "createTime") String sort,
                    @RequestParam(value = "order", defaultValue = "desc") String order) {
    //文章分页排序
    Page page = PageUtil.initMpPage(pageNumber, pageSize, sort, order);
    //1.文章列表
    Post condition = new Post();
    condition.setPostType(PostTypeEnum.POST_TYPE_POST.getValue());
    condition.setPostStatus(PostStatusEnum.PUBLISHED.getCode());
    Page<Post> posts = postService.findAll(page, new QueryCondition<>(condition));
    List<Post> postList = posts.getRecords();
    postList.forEach(post -> {
        post.setCategories(categoryService.findByPostId(post.getId()));
        post.setUser(userService.get(post.getUserId()));
    });
    model.addAttribute("posts", postList);
    model.addAttribute("pageInfo", PageUtil.convertPageVo(page));

    model.addAttribute("prefix", "");

    //2.首页的公告列表
    List<Post> notices = postService.findByPostTypeAndStatus(PostTypeEnum.POST_TYPE_NOTICE.getValue(), PostStatusEnum.PUBLISHED.getCode());
    model.addAttribute("notices", notices);

    //3.幻灯片
    List<Slide> slides = slideService.findBySlideType(SlideTypeEnum.INDEX_SLIDE.getCode());
    model.addAttribute("slides", slides);


    //4.侧边栏
    model.addAttribute("sidebarType", SidebarTypeEnum.INDEX.getValue());
    //统计
    model.addAttribute("allCount", postService.getAllCount());
    //文章排名
    model.addAttribute("postRanking", postService.getPostRankingByPostView(10));
    return this.render("index");
}
Example 19
Source File: SysDictServiceImpl.java    From jeecg-boot with Apache License 2.0 4 votes vote down vote up 
@Override
public List<DictModel> queryDictTablePageList(DictQuery query, int pageSize, int pageNo) {
	Page page = new Page(pageNo,pageSize,false);
	Page<DictModel> pageList = baseMapper.queryDictTablePageList(page, query);
	return pageList.getRecords();
}