使用@Query注解的in查询,并且判断参数是否为空(参数必须为list)
@Query(value = "select * from table where if(?1 !='',a=?1,1=1) and (coalesce (?2 , null) is null or b IN ( ?2 ))",nativeQuery = true)
Page<TableBean> findByaAndb(String str, List<String> list, Pageable pageable);