package com.estate.expert.admin.domain.role; import com.estate.expert.admin.domain.common.EntityBaseRepository; import org.springframework.data.domain.Page; import org.springframework.data.domain.Pageable; import org.springframework.data.jpa.repository.Query; import org.springframework.data.repository.query.Param; public interface RoleRepository extends EntityBaseRepository { @Query("select r from Role r where (:keyword is null or :keyword = '' or r.name like %:keyword%) " + "and r.deleted = false order by r.updateTime desc") Page list(@Param("keyword") String keyword, Pageable page); }