Shulou(Shulou.com)05/31 Report--

This article mainly introduces Spring Boot how to integrate PageHelper using related knowledge, the content is detailed and easy to understand, the operation is simple and fast, has a certain reference value, I believe you will get something after reading this Spring Boot how to integrate PageHelper use article, let's take a look at it.

Basic Integration introduction jar package com.github.pagehelper pagehelper-spring-boot-starter ${pagehelper.version} Yml configuration file add relevant configuration pagehelper: helperDialect: mysql reasonable: true supportMethodsArguments: true params: count=countSql encapsulation related paging method paging parameter class public class PageParam implements Serializable {private static final long serialVersionUID =-7916211163897873899L; private int pageNum=1; private int pageSize=10 / / conditional parameter private T param; / / sort field private String orderBy; public int getPageSize () {return pageSize;} public void setPageSize (int pageSize) {this.pageSize = pageSize;} public int getPageNum () {return pageNum;} public void setPageNum (int pageNum) {this.pageNum = pageNum } public T getParam () {return param;} public void setParam (T param) {this.param = param;} public String getOrderBy () {return orderBy;} public void setOrderBy (String orderBy) {/ / need to note that sql injection this.orderBy = orderBy;}} paging result class public class PagedList implements Serializable {private static final long serialVersionUID =-1253790062865437768L Private int pageNum = 1; private List data = null; private int pageCount = 0; private int recordCount =-1; private int pagingType = 0; private int pageSize; private String orderBy; / * * @ return the pageSize * / public int getPageSize () {return pageSize } / * * @ param pageSize * the pageSize to set * / public void setPageSize (int pageSize) {if (pageSize Preparing: SELECT * FROM t_user u LEFT JOIN t_user_role ur ON ur.userOid = u.oid WHERE name =? Order by age desc LIMIT?

2022-04-15 22 613920d89eb54bfd8601c93ec8572dcf 26 c.s.f.m.UserMapper.queryPageList 39.919 [http-nio-9090-exec-9] DEBUG [613920d89eb54bfd8601c93ec8572dcf] c.s.f.m.UserMapper.queryPageList-= > Parameters: Zhang San 210001 (String), 10 (Integer)

2022-04-15 22 613920d89eb54bfd8601c93ec8572dcf 26 c.s.f.m.UserMapper.queryPageList 40.267 [http-nio-9090-exec-9] c.s.f.m.UserMapper.queryPageList-

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.