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層方法前使用：

示例

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