1、MyBatis使用in语句,入参为字符串或集合时的写法
当levels = "1,2,3,4,5"时,使用in (${params}),当levels = [1,2,3,4,5]时,使用in foreach遍历
select username from user where status = 0
and level in
(${levels})

1、MyBatis使用in语句,入参为字符串或集合时的写法
当levels = "1,2,3,4,5"时,使用in (${params}),当levels = [1,2,3,4,5]时,使用in foreach遍历
select username from user where status = 0
and level in
(${levels})