Java优学网MySQL分页查询教程：轻松掌握高效数据分页技巧，提升开发效率

SELECT * FROM user_info LIMIT 10, 10;

SELECT * FROM user_info LIMIT 0, 20;

SELECT * FROM large_table LIMIT 199980, 20;

@Repository public interface UserRepository extends JpaRepository<User, Long> {

Page<User> findByStatusOrderByCreateTimeDesc(
    String status, Pageable pageable
);

}

@Service public class UserService {

public Page<User> getActiveUsers(int page, int size) {
    Pageable pageable = PageRequest.of(page, size, 
        Sort.by("createTime").descending());
    return userRepository.findByStatusOrderByCreateTimeDesc(
        "ACTIVE", pageable);
}

}