String 字符串
!注意:数据之间要带上单引号
String province1 = "'四川省','陕西省','宁夏回族自治区'";
List<Integer> shopIdList = tempMapper.queryProvince1TOneTtwo(province1);
sql
这里注入使用$ 不然参数会有问题
@Select({"SELECT s.id FROM shop s LEFT JOIN f_shop_members m ON m.shop_id = s.id WHERE s.province " +
"in(${provice1}) AND m.use_status = 2 AND s.isrelease IN ( 1) and m.member_level in(31,32)"})
List<Integer> queryProvince1TOneTtwo(@Param("provice1") String provice1);