package com.boying.dao;
|
|
import com.boying.common.BaseDao;
|
import com.boying.entity.WhiteList;
|
import org.springframework.data.domain.Page;
|
import org.springframework.data.domain.Pageable;
|
import org.springframework.data.jpa.repository.Query;
|
import org.springframework.stereotype.Repository;
|
|
@Repository("whiteListDao")
|
public interface WhiteListDao extends BaseDao<WhiteList, Long>{
|
|
@Query(value = "select new com.boying.entity.WhiteList(a,b.name) from WhiteList a left join Park b on a.parkId=b.id where :carNo is null or a.carNo like %:carNo%")
|
Page<WhiteList> findPage2(Pageable pageable,String carNo);
|
}
|
