// my_table 是表,MyTable是实体 查询字段为name,comment
public interface TabelDao extends PagingAndSortingRepository<MyTabel,Long>,
JpaSpecificationExecutor {
@Query(value = "select * from my_table t where 1=1 " +
"AND if(''!=:#{#myTabel.name}, name like %:#{#myTabel.name}%,1=1) " +
"AND if(''!=:#{#myTabel.comment}, comment=:#{#myTabel.comment},1=1) "
,nativeQuery = true)
List<MyTabel> findByStrategyTypeAndStatess(MyTabel myTabel );
}