【spring-boot】分页类使用

阅读目录

• 官方文档
• 引入分页类
• 公共层 - 分页DTO 
• 服务层 - 用户服务类
• 用户层 - controller
• 启动文件
• 项目demo地址

回到顶部

官方文档

• https://github.com/pagehelper/Mybatis-PageHelper/blob/master/wikis/zh/HowToUse.md

回到顶部

引入分页类

pom.xml中

?

1 2 3 4 5

<dependency>     <groupId>com.github.pagehelper</groupId>     <artifactId>pagehelper-spring-boot-starter</artifactId>     <version>1.2.13</version> </dependency>

回到顶部

公共层 - 分页DTO 

pageDTO.java

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22

package com.example.pagehelperdemo.common;   import java.util.List; import lombok.AllArgsConstructor; import lombok.Data;   /**  * @author komiles@163.com  * @date 2020-04-30 18:54  */ @Data @AllArgsConstructor public class PageDTO<T> {       private Long Total;       private Integer pageSize;       private Integer pageNum;       private List<T> list; }

 

回到顶部

服务层 - 用户服务类

UserService.java

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15

package com.example.pagehelperdemo.service;   import com.example.pagehelperdemo.common.PageDTO; import com.example.pagehelperdemo.dao.User;   /**  * @author komiles@163.com  * @date 2020-04-30 18:49  */ public interface UserService {       User getOne(Integer id);       PageDTO<User> getList(Integer pageNum, Integer pageSize); }

　　UserServiceImpl.java 实现类 

package com.example.pagehelperdemo.service.impl;

import com.example.pagehelperdemo.common.PageDTO;
import com.example.pagehelperdemo.dao.User;
import com.example.pagehelperdemo.dao.UserExample;
import com.example.pagehelperdemo.mapper.UserMapper;
import com.example.pagehelperdemo.service.UserService;
import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;
import java.util.List;
import javax.annotation.Resource;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

/**
 * @author komiles@163.com
 * @date 2020-04-30 18:50
 */
@Service
public class UserServiceImpl implements UserService {

    @Resource
    private UserMapper userMapper;

    @Override
    public User getOne(Integer id) {
        return userMapper.selectByPrimaryKey(id);
    }

    @Override
    public PageDTO<User> getList(Integer pageNum, Integer pageSize) {
        PageHelper.startPage(pageNum,pageSize);

        UserExample userExample = new UserExample();
        userExample.createCriteria();

        List<User> userList = userMapper.selectByExample(userExample);

        PageInfo pageInfo = new PageInfo(userList);

        PageDTO result = new PageDTO(
                pageInfo.getTotal(),
                pageInfo.getPageNum(),
                pageInfo.getPageSize(),
                pageInfo.getList());

        return result;
    }
}

回到顶部

用户层 - controller

UserController.java

package com.example.pagehelperdemo.controller;

import com.example.pagehelperdemo.common.PageDTO;
import com.example.pagehelperdemo.dao.User;
import com.example.pagehelperdemo.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.RestController;

/**
 * @author komiles@163.com
 * @date 2020-04-30 18:47
 */
@RequestMapping("/user")
@RestController
public class UserController {

    @Autowired
    private UserService userService;

    @GetMapping("/one")
    public User getOne(@RequestParam("id") Integer id){
        return userService.getOne(id);
    }

    @GetMapping("/list")
    public PageDTO<User> getList(@RequestParam(value = "page",defaultValue = "1") Integer page, 
            @RequestParam(value = "limit",defaultValue = "10") Integer limit){
        return userService.getList(page,limit);
    }

}

 

回到顶部

启动文件

访问地址：http://127.0.0.1:6066/user/list?page=1&limit=10

 

回到顶部

项目demo地址

https://github.com/KoMiles/spring-example/tree/master/page-helper-demo