MyBatis查询多个,用逗号分隔的模糊查询

stockapplycode查询多个,用逗号分隔

1.前台传入要查询数据的字符串

<input id="stockapplycodeList" name="stockapplycodeList" type="text"/>

2.实体类添加stockapplycodeList

private List<String> stockapplycodeList;//get和set方法省略

private List<String> stockapplycode;//get和set方法省略

3.后台接受字符串,并分隔字符串

 String stockapplycodeListStr = request.getParameter("stockapplycodeList");

 List<String> stockapplycodeList = Arrays.asList(stockapplycodeListStr.split("，")); 

query.setStockapplycodeList(stockapplycodeList);

3.在mybatis文件中添加配置

<if test="stockapplycodeList != null and stockapplycodeList.size > 0">
         <foreach collection="stockapplycodeList" item="item" index="index" open="" separator="or" close="">
               tt.stockapplycode like '%${item}%'
         </foreach>
 </if>