kotlin使用spring data jpa（二）

2019独角兽企业重金招聘Python工程师标准>>>

简单分页查询

1.直接使用findAll中的方法传入PageRequest

orderRepository.findAll(PageRequest.of(page,10))

2.自定义方法，使用jpql进行分页

@Repository
interface OrderRepository:JpaRepository<OrderMasterEntity,String> {
    @Query(value = "select o from OrderEntity o where o.orderStatus=?1",
            countQuery = "select count(o) from OrderEntity o where o.orderStatus=?1")
    fun getOrderEntitiesByOrderStatus(orderStatus: Byte,pageable: Pageable): Page<OrderEntity>
}

调用方式为

orderRepository.getOrderMasterEntitiesByOrderStatus(11,PageRequest.of(page,10))

转载于:https://my.oschina.net/weidedong/blog/2396138