如何在mybatis SQL查询中使用IN

<!-- 刪除應用市場信息 -->
 <delete id="delApplyMarker">
  delete from bi_applymarker where apply_id in <foreach item="item" index="index" collection="ids"
           open="(" separator="," close=")">
          #{item}
        </foreach>
 </delete>

 

/**
  * @content 刪除所選中的應用市場
  * @time 2014/10/21
  * */
 public void delApplyMarker(@Param(value="ids")List<Integer> applyMarkerId);

 

 

/**
  * @content 刪除應用市場詳情
  * @time 2014/10/21
  * */
 @RequestMapping(value="/delApplyMarker",method=RequestMethod.GET)
 @ResponseBody
 public String delApplyMarker(HttpServletRequest request){
  ResultToJackson result = new ResultToJackson();
  Map<String, Object> applyMarker_map = new HashMap<String, Object>();//返回給前臺的數據
  try {
   String applyMarkerId = request.getParameter("applyMarkerId");
   BIapplyMarkerMapper bIapplyMarkerMapper = (BIapplyMarkerMapper) factory.getBusinessProduct("applyMarker");
   String[] applyMarkerIds = applyMarkerId.split(",");
   List<Integer> ids = new ArrayList<Integer>();
   for(int i=0;i<applyMarkerIds.length;i++){
    ids.add(Integer.parseInt(applyMarkerIds[i]));
   }
   bIapplyMarkerMapper.delApplyMarker(ids);
   applyMarker_map.put("status", "true");
  } catch (Exception e) {
   e.printStackTrace();
   applyMarker_map.put("status", "false");
  }
  return result.getResultFromMap(applyMarker_map);
 }
}