最近在项目中开始使用Kotlin,采用springboot jpa +hibernate
spring jpa自带的简单查询很好理解,昨天在做分页查询的时候感觉无从下手
调试半天,似乎是成功了,代码如下
interface CarRepository : CrudRepository<CarEntity, Int>, JpaSpecificationExecutor<CarEntity> ,PagingAndSortingRepository<CarEntity,Int>{
}
override fun searchAllByPage(index:Int,limit:Int): Page<CarEntity> {
var pageRequest = PageRequest(index,limit, Sort(Sort.Direction.DESC,"id"))
var cars = carRepository.findAll(pageRequest)
return cars
}
对于多条件
var pageRequest = PageRequest(index, limit, Sort(Sort.Order(Sort.Direction.DESC,"id"),Sort.Order(Sort.Direction.ASC,"no")))
简单记录一下
