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啦