SSM框架使用PageHelper插件

使用PageHelper插件

导入依赖 <dependency> <groupId>com.github.pagehelper</groupId> <artifactId>pagehelper</artifactId> </dependency> 在mybatis配置文件下的SqlSessionFactoryBean配置插件 <!-- 配置SqlSessionFactoryBean整合MyBatis --> <bean id="sqlSessionFactoryBean" class="org.mybatis.spring.SqlSessionFactoryBean"> <!-- 指定MyBatis全局配置文件位置 --> <property name="configLocation" value="classpath:mybatis-config.xml"/> <!-- 指定Mapper.xml配置文件位置 --> <property name="mapperLocations" value="classpath:mybatis/mapper/*Mapper.xml"/> <!-- 装配数据源 --> <property name="dataSource" ref="dataSource"/> <!--配置插件--> <property name="plugins"> <array> <!-- 配置PageHelper插件 --> <bean class="com.github.pagehelper.PageHelper"> <property name="properties"> <props> <!--配置数据库方言,告诉PageHelper当前使用的数据库--> <prop key="dialect">mysql</prop> <!-- 配置页码的合理化修正,在1~总页数间修正页码 --> <prop key="reasonable">true</prop> </props> </property> </bean> </array> </property> </bean>

使用PageInfo进行数据封装

public PageInfo<Admin> getPageInfo(String keyword, Integer pageNum, Integer pageSize) { // 1.调用PageHelper的静态方法开启分页 PageHelper.startPage(pageNum,pageSize); // 2.执行查询 List<Admin> adminList = adminMapper.selectAdminByKeyword(keyword); // 3.封装到PageInfo对象 return new PageInfo<>(adminList); }

测试

public class AdminServiceImplTest { @Autowired AdminService adminService; private Gson gson = new GsonBuilder().setPrettyPrinting().create(); @Test public void getPageInfo() { PageInfo<Admin> pageInfo = this.adminService.getPageInfo("tom", 1, 5); Logger logger = LoggerFactory.getLogger(AdminServiceImplTest.class); //以json格式输出方便查看 logger.info("result = {}", this.gson.toJson(pageInfo)); } }

输出结果

[result = { "pageNum": 1, "pageSize": 5, "size": 5, "startRow": 1, "endRow": 5, "total": 16, "pages": 4, "list": [ { "id": 9, "loginAcct": "marry", "userPswd": "4297f44b13955235245b2497399d7a93", "userName": "迈瑞", "email": "marry@qq.com", "createTime": "2020-10-03 16:05:13.0" }, { "id": 10, "loginAcct": "marry1", "userPswd": "4297f44b13955235245b2497399d7a93", "userName": "迈瑞", "email": "marry1@qq.com", "createTime": "2020-10-03 16:05:13.0" }, { "id": 11, "loginAcct": "marry2", "userPswd": "4297f44b13955235245b2497399d7a93", "userName": "迈瑞", "email": "marry2@qq.com", "createTime": "2020-10-03 16:05:37.0" }, { "id": 12, "loginAcct": "marry3", "userPswd": "4297f44b13955235245b2497399d7a93", "userName": "迈瑞", "email": "marry3@qq.com", "createTime": "2020-10-03 16:05:37.0" }, { "id": 13, "loginAcct": "marry4", "userPswd": "4297f44b13955235245b2497399d7a93", "userName": "迈瑞", "email": "marry4@qq.com", "createTime": "2020-10-03 16:05:37.0" } ], "firstPage": 1, "prePage": 0, "nextPage": 2, "lastPage": 4, "isFirstPage": true, "isLastPage": false, "hasPreviousPage": false, "hasNextPage": true, "navigatePages": 8, "navigatepageNums": [ 1, 2, 3, 4 ] }]