com.baomidou.mybatisplus.extension.plugins.pagination.Page#getRecords

Source File: PostController.java From SENS with GNU General Public License v3.0

6 votes

/**
 * 待审核文章列表
 *
 * @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";
}

Source File: BlogInfoServiceImpl.java From My-Blog-layui with Apache License 2.0

6 votes

@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;
}

Source File: MyBlogController.java From My-Blog-layui with Apache License 2.0

6 votes

@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";
}

Source File: BlogInfoServiceImpl.java From My-Blog-layui with Apache License 2.0

6 votes

@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;
}

Source File: MyBlogController.java From My-Blog-layui with Apache License 2.0

6 votes

/**
 * 分类列表
 *
 * @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";
}

Source File: DemoController.java From spring-boot-starter-samples with Apache License 2.0

5 votes

@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("");
	}
}

Source File: DemoController.java From spring-boot-starter-samples with Apache License 2.0

5 votes

@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("");
	}
}

Source File: R.java From kvf-admin with MIT License

5 votes

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;
    }
}

Source File: BeanMapper.java From ruoyiplus with MIT License

5 votes

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;
}

Source File: BeanMapper.java From ruoyiplus with MIT License

5 votes

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;
}

Source File: MyBlogController.java From My-Blog-layui with Apache License 2.0

5 votes

/**
 * 标签分类
 *
 * @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";
}

Source File: FrontIndexController.java From SENS with GNU General Public License v3.0

5 votes

/**
 * 搜索
 *
 * @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");
}

Source File: FrontOthersController.java From SENS with GNU General Public License v3.0

5 votes

/**
 * 获取文章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);
}

Source File: FrontCommentController.java From SENS with GNU General Public License v3.0

5 votes

/**
 * 加载评论
 *
 * @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();
}

Source File: FrontTagController.java From SENS with GNU General Public License v3.0

4 votes

/**
 * 根据标签路径查询所有文章 分页
 *
 * @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");
}

Source File: FrontIndexController.java From SENS with GNU General Public License v3.0

4 votes

/**
 * 首页分页
 *
 * @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");
}

Source File: SysDictServiceImpl.java From jeecg-cloud with Apache License 2.0

4 votes

@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();
}

Source File: FrontIndexController.java From SENS with GNU General Public License v3.0

4 votes

/**
 * 首页分页
 *
 * @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");
}

Source File: SysDictServiceImpl.java From jeecg-boot with Apache License 2.0

4 votes

@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();
}

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