mybatis-plus pagehelper 使用小结

1.https://gitee.com/baomidou/mybatis-plus-samples/tree/master/mybatis-plus-sample-pagination

使用方法还是看官方代码示例

springboot使用方式如下

1.导包

<dependency>
	<groupId>com.github.pagehelper</groupId>
	<artifactId>pagehelper</artifactId>
	<version>5.1.11</version>
</dependency>

2.配置

//Spring boot方式
@EnableTransactionManagement // 开启事务
@Configuration
@MapperScan("com.xxx.mapper")
public class MybatisPlusConfig {

    @Bean
    public PageInterceptor pageInterceptor() {
        return new PageInterceptor();
    }

3.测试

public class PagesTest {
    @Autowired
    UserService userService;

    @Test
    public void test1(){
        PageInfo<Object> info = PageHelper.startPage(1, 2).doSelectPageInfo(() -> userService.list());
        String string = JSON.toJSONString(info);
        System.out.println(string);

PageInfo返回

{"endRow":2,
  "hasNextPage":true,
  "hasPreviousPage":false,
  "isFirstPage":true,
  "isLastPage":false,
  "list":[{"organization":"teacher",
		    "userId":20200008,
		    "username":"王八"},
		    {"organization":"teacher",
		      "userId":20200007,
		      "username":"郑七"}],
  "navigateFirstPage":1,
  "navigateLastPage":4,
  "navigatePages":8,
  "navigatepageNums":[1,2,3,4],
  "nextPage":2,
  "pageNum":1,
  "pageSize":2,
  "pages":4,
  "prePage":0,
  "size":2,
  "startRow":1,
  "total":8}

动手试一试吧!


版权声明:本文为weixin_51084602原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接和本声明。