Mybatis动态sql的foreach循环

两种情况:

1 当你的list是以map方式进行传递

List<String> ids = new ArrayList<String>();
Map<String,Object> params = new Hash
params.put("ids", ids);
exAppMapper.selectUserFavApp(params);

xml代码:

id not in 
    <foreach collection="ids" item="id" open="(" close=")" separator="," >
        #{id}
    </foreach>

2  当你直接以List作为参数进行传递时

List<String> gids = new ArrayList<String>();
orderImageMapper.getOrderImage(gids);

xml代码:

id in
    <foreach collection="list" item="gids" open="(" close=")" separator="," >
         #{gids}
   </foreach>