jpa @query 判断参数

Repository 中
SQL where后
" and (" +
"coalesce(?1, null) is null or a.name in (?1)" +
" ) " +

传参 List<String> name
posted @ 2022-07-20 01:25  人间春风意  阅读(115)  评论(0编辑  收藏  举报