PageHelper的使用 java 分页

PageHelper在SpringBoot中的使用

一：导入插件

1：pom.xml中导入依赖

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

2：在springboot配置文件（applicable.yml）中声明插件

# PageHelper分页插件
# 分页配置
pagehelper:
  helper-dialect: mysql
  reasonable: false
  support-methods-arguments: true
  params: count=countSql

3 应用

    @GetMapping("booksList")
    public Result booksList(@RequestParam(value = "bookTitle",required = false)String bookTitle,
                            @RequestParam(value = "bookAuthor",required = false)String bookAuthor,
                            @RequestParam(value = "pageSize",defaultValue = "1")Integer pageSize,
                            @RequestParam(value = "pageNum",defaultValue = "2")Integer pageNum){
        PageHelper.startPage(pageSize,pageNum);
        List<Books> books = booksService.booksList(bookTitle,bookAuthor);
        PageInfo<Books> booksPageInfo = new PageInfo<>(books);
        return Result.success(booksPageInfo);
    }

    <select id="booksList" resultType="com.book.book.pojo.Books">
        SELECT
        book_id AS bookId,
        book_title AS bookTitle,
        photo AS photo,
        book_author AS bookAuthor,
        book_publisher AS bookPublisher,
        book_price AS bookPrice,
        book_stock AS bookStock,
        book_time AS booktime
        FROM
        t_book
        <where>
            <if test="bookTitle!=null">
                AND book_title LIKE CONCAT('%', #{bookTitle}, '%')
            </if>
            <if test="bookAuthor!=null">
                AND book_author LIKE CONCAT('%', #{bookAuthor}, '%')
            </if>
        </where>
    </select>

不需要写limit啦