mybatis @SelectProvider 查询 in条件动态拼接id录标题
不想写mxl,sql不好调试,习惯用mybatis对应的Provider来处理。这里主要解决in条件中动态拼接id和避免sql注入的问题,废话不多说,直接show code(只是部分代码片段)
@Service
@Slf4j
public class StoreServiceImpl implements StoreService {
@Autowired
private StoreMapper storeMapper;
@Override
public APIResponseBody getStoreList() {
StoreVo storeVo = new StoreVo();
storeVo.setStoreName("步行街");
String storeIdStr = "d7b82fdcf5f8444eaf66af2bddbba5ac,34d325c8596e4c528073a5699ddefeae,6fbfbff9b77046a7b316eef35c721ff9";
String[]