@Query(value = "select * from emp where fid in (:paramList) or coalesce(:paramList, null) is null ", nativeQuery = true)
List<Emp> testSelect(@Param("paramList")List<String> paramList);
@Query()判断所传为空不执行
最新推荐文章于 2023-05-13 12:06:13 发布
@Query(value = "select * from emp where fid in (:paramList) or coalesce(:paramList, null) is null ", nativeQuery = true)
List<Emp> testSelect(@Param("paramList")List<String> paramList);