mybatis 批量删除

 String[] ids = activityIds.split("\\,");
 res = activitiesService.deleteActivity(ids);

 

int deleteActivity(String[] ids);

 

 

 public int deleteActivity(String[] ids) {
  return activitiesMapper.deleteActivity(ids);
 }

 

 <update id="deleteActivity" parameterType="java.util.HashMap">
  update t_base_activity
  set isDelete = 1
  where id in
  <foreach item="id" index="index" collection="array" open="(" separator="," close=")">
  #{id}
  </foreach>
 </update>

 

    <delete id="batchDeleteIllegalWithListOnlyId"  parameterType="java.util.List">  
        DELETE FROM t_base_order_illegal where id in  
        <foreach collection="list" item="id" open="("    
            separator="," close=")">    
            #{id,jdbcType=INTEGER}    
        </foreach>    
    </delete> 

 

//批量查询 //注释 传过来是个map ids Map里面Key

  <if test="id != null">
   and veh.id in    
    <foreach collection="ids" item="value" open="(" separator="," close=")">
    #{value}
      </foreach>
  </if>