接口如下:
//你的repository继承JpaRepository,利用Containing关键字
Page<User> findByUsernameContainingOrderByCreateTimeDesc(String username,Pageable pageable);
调用:
//查询第1页2条名字含有“丽”的用户,并按创建时间倒序排列,模糊查询Containing关键字将丽拼接成:%丽%
Pageable page = PageRequest.of(0 , 2);
Page<User> list = userRepository.findByUsernameContainingOrderByCreateTimeDesc("丽",page);
更多关键字规则:Spring Data JPA关键字规则