Spring Boot 集成mybatis的分页拦截器:PageHelper

2022-06-21 09:45:53

导入pom依赖包:

<!-- mybatis 的分页拦截器 : PageHelper -->
<dependency>
   <groupId>com.github.pagehelper</groupId>
   <artifactId>pagehelper</artifactId>
   <version>4.1.0</version>
</dependency>

写一个配置类:

@Configuration
public class MybatisConfiguration{

    @Bean
    public PageHelper pageHelper(){
        System.out.print("pageHelper");
        PageHelper pageHelper = new PageHelper();
        Properties properties = new Properties();

        properties.setProperty("offsetAsPageNum","true");
        properties.setProperty("rowBoundsWithCount","true");
       properties.setProperty("reasonable","true");

       pageHelper.setProperties(properties);

       return pageHelper;
    }
}

写一个Controller 测试一下:

@RestController
public class GirlController {

    @Autowired
    DemoService demoService;

    @RequestMapping("/getList")
    public List<Girl> getList(){
        /**
         * 第一个参数:第几页
         * 第二个参数:每页获取的条数
         */
        PageHelper.startPage(1,2);
        return demoService.getList();
    }
}
  • 作者:往事随风非
  • 原文链接:https://blog.csdn.net/lxh18682851338/article/details/78662246
    更新时间:2022-06-21 09:45:53