mysql+mybatis where in带多个参数

来源:互联网 发布:乒乓球 胶皮 知乎 编辑:程序博客网 时间:2024/09/21 06:33
//代码:
List<String> list=new ArrayList<String>();if(order.getOrderstatus().contains("&")){String[] str=order.getOrderstatus().split("&");for (int i = 0; i < str.length; i++) {list.add(str[i]);}}else{list.add(order.getOrderstatus());}map.put("status",list);



//数据库:
select * from table where status in<foreach collection="status" index="index" item="item" open="(" separator="," close=")">             #{item}    </foreach> 


0 0