spring data jpa 查询

原生sql语句查询

1) 模糊查询

public interface DeviceRepository extends JpaRepository<Device, Long>, JpaSpecificationExecutor<Device> {

    @Query(value = "select * from biz_device where create_time like CONCAT('%',:time,'%') order by ?#{#pageable}", nativeQuery = true)
    Page<Device> findByCreateTimeLike(@Param("time")String time, Pageable pageable);
　　 
}