springboot集成pageHelper的使用

springboot集成pageHelper的使用

1 .添加依赖

<dependency>
      <groupId>com.github.pagehelper</groupId>
      <artifactId>pagehelper-spring-boot-starter</artifactId>
      <version>1.2.5</version>
</dependency>

2 .yml文件配置

pagehelper:
	helper-dialect: mysql

3 .使用
在调用dao层方法前使用：

PageHelper.startPage(pageNum,pageSize);

示例

1 .dao层

@Mapper
public interface AlarmRecordDao {

    @Select("select * from T_ALARM_RECORD")
    List<AlarmRecord> list();
    
}

2 .测试类

@SpringBootTest(webEnvironment = SpringBootTest.WebEnvironment.RANDOM_PORT)
class ApplicationTests {

    @Autowired
    private AlarmRecordDao dao;

    @Test
    void test() {
        List<AlarmRecord> list1 = dao.list();
        System.out.println("分页前："+list1.size());
        PageHelper.startPage(1, 10);
        List<AlarmRecord> list2 = dao.list();
        System.out.println("分页后："+list2.size());
        list2.stream().forEach(x -> System.out.println("id ---------- "+x.getId()));
    }
    
}

3 .测试结果

  .   ____          _            __ _ _
 /\\ / ___'_ __ _ _(_)_ __  __ _ \ \ \ \
( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \
 \\/  ___)| |_)| | | | | || (_| |  ) ) ) )
  '  |____| .__|_| |_|_| |_\__, | / / / /
 =========|_|==============|___/=/_/_/_/
 :: Spring Boot ::        (v2.3.3.RELEASE)

分页前：40069
分页后：10
id ---------- 302526
id ---------- 302527
id ---------- 302528
id ---------- 302529
id ---------- 302530
id ---------- 302531
id ---------- 302532
id ---------- 302533
id ---------- 302534
id ---------- 302535

Process finished with exit code 0