SpringBoot分页插件使用

1.在pom.xml中导入下列依赖

<!-- https://mvnrepository.com/artifact/com.github.pagehelper/pagehelper-spring-boot-starter -->
        <dependency>
            <groupId>com.github.pagehelper</groupId>
            <artifactId>pagehelper-spring-boot-starter</artifactId>
            <version>1.2.12</version>
        </dependency>

2.application.properties

#数据源配置
spring.datasource.username=root
spring.datasource.password=root
spring.datasource.url=jdbc:mysql://localhost:3306/db6?characterEncoding=utf8&useSSL=false&serverTimezone=UTC
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver

#继承mybatis配置
#给起别名 自动扫描包下的类  自动生成别名
mybatis.type-aliases-package=com.xzy.xiangmu2.entity
#指定当前mybatis的所有的mapper文件的位置
mybatis.mapper-locations=classpath:mapper/*.xml
#mybatis.config-location=classpath:config/mybatis-config.xml

#分页插件的配置
pagehelper.helper-dialect=mysql
#边界值的问题，处理页码的边界，比如：查询100页，但是数据库中没有此内容，还是可以查出来，是最后一页的内容，而不是报错
pagehelper.reasonable=true

3.BookInfo.java

public class BookInfo {
    private Integer bookId;
    private String bookName;
    private String bookImg;
    private Integer authorId;
    private Integer pubId;
    private String bookContent;
    private Integer bookState;

    public BookInfo() {
    }

    public BookInfo(Integer bookId, String bookName, String bookImg, Integer authorId, Integer pubId, String bookContent, Integer bookState) {
        this.bookId = bookId;
        this.bookName = bookName;
        this.bookImg = bookImg;
        this.authorId = authorId;
        this.pubId = pubId;
        this.bookContent = bookContent;
        this.bookState = bookState;
    }

    public void setBookId(Integer bookId) {
        this.bookId = bookId;
    }

    public void setBookName(String bookName) {
        this.bookName = bookName;
    }

    public void setBookImg(String bookImg) {
        this.bookImg = bookImg;
    }

    public void setAuthorId(Integer authorId) {
        this.authorId = authorId;
    }

    public void setPubId(Integer pubId) {
        this.pubId = pubId;
    }

    public void setBookContent(String bookContent) {
        this.bookContent = bookContent;
    }

    public void setBookState(Integer bookState) {
        this.bookState = bookState;
    }

    public Integer getBookId() {
        return bookId;
    }

    public String getBookName() {
        return bookName;
    }

    public String getBookImg() {
        return bookImg;
    }

    public Integer getAuthorId() {
        return authorId;
    }

    public Integer getPubId() {
        return pubId;
    }

    public String getBookContent() {
        return bookContent;
    }

    public Integer getBookState() {
        return bookState;
    }

    @Override
    public String toString() {
        return "BookInfo{" +
                "bookId=" + bookId +
                ", bookName='" + bookName + '\'' +
                ", bookImg='" + bookImg + '\'' +
                ", authorId=" + authorId +
                ", pubId=" + pubId +
                ", bookContent='" + bookContent + '\'' +
                ", bookState=" + bookState +
                '}';
    }
}

4.BookMapper.java

@Mapper
public interface BookMapper {
    Page<BookInfo> findAllBook();
}

5.BookService.java

public interface BookService {
    Page<BookInfo> findAllBook(int pageNum,int pageSize);

    Page<BookInfo> findAllBooks();
}

6.BookServiceImpl.java

@Service
public class BookServiceImpl implements BookService {
    @Resource
    private BookMapper bookMapper;

    @Override
    public Page<BookInfo> findAllBook(int pageNum, int pageSize) {
        PageHelper.startPage(pageNum,pageSize);
        return bookMapper.findAllBook();
    }

    @Override
    public Page<BookInfo> findAllBooks() {
        return bookMapper.findAllBook();
    }
}

7.BookController.java

@RestController
public class BookController {
    @Autowired
    private BookService bookService;

    @GetMapping(value = {"/findbookbypage/{pageNum}/{pageSize}"})
    public Page<BookInfo> findBookByPage(@PathVariable("pageNum")int pageNum,
                                          @PathVariable("pageSize")int pageSize){
        return bookService.findAllBook(pageNum,pageSize);
    }

    @GetMapping(value = {"/findallbook"})
    public Page<BookInfo> findAllBook(){
        return bookService.findAllBooks();
    }
}