Shulou(Shulou.com)06/02 Report--

In this issue, the editor will bring you about how to integrate pageHelper in springboot. The article is rich in content and analyzes and narrates it from a professional point of view. I hope you can get something after reading this article.

1 pom file add dependency

Com.github.pagehelper

Pagehelper-spring-boot-starter

1.2.5

2 application.yml configuration paging plug-in

# pagehelper paging plug-in can implement paging without adding the following attributes pagehelper: helperDialect: mysql reasonable: true supportMethodsArguments: true params: count=countSql

3 start writing paging

Principle: users query the data from the database, which is generally encapsulated in a list collection. At this time, paging plug-ins can be used for paging, and the paging data is stored in the cache.

Call PageHelp.startPage (pageNo,pageSize); / / pageNo the current page number, the number of records displayed on the pageSize page

PageHelper encapsulates the data into PageInfo. As long as the queried list collection is forcibly transferred to PageInfo, paging can be realized.

@ Override public PageInfo selectPermissionByPage (int pageNo, int pageSize) {PageHelper.startPage (pageNo,pageSize); / / start paging List permissionInfos=permissionMapper.selectPermission (); / / put the queried data into the paging cache PageInfo pageInfo = new PageInfo (permissionInfos); return pageInfo } the above is how to integrate pageHelper in the springboot shared by the editor. If you happen to have similar doubts, please refer to the above analysis to understand. If you want to know more about it, you are welcome to follow the industry information channel.

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.