批量删除

1、Controller:

//批量删除区域树
@PostMapping("/deletBeatch")
public Result delete(@RequestBody IdsForm idsForm) {
    try {
        stationRegionTreeService.deleteBatch(idsForm);
        return Result.ok(idsForm.getIds());
    } catch (Exception e) {
        return Result.error(idsForm.getIds(), Constant.EXISTS_RELATION_NOT_DELETE_MSG);
    }
}

public class IdsForm {

    private List<String> ids;

    public List<String> getIds() {
       return ids;
    }

    public void setIds(List<String> ids) {
       this.ids = ids;
    }
}

2、Service:

void deleteBatch(IdsForm idsForm);

3、ServiceImpl:

@Transactional
@Override
public void deleteBatch(IdsForm idsForm) {
    List<String> ids = idsForm.getIds();
    if (ids == null || ids.size() == 0) {
        return;
    }
    stationRegionTreeDao.deleteBatch(ids);
}

4、dao:

@Modifying
@javax.transaction.Transactional
@Query("delete from StationRegionTree s where s.id in ( :ids )")
void deleteBatch(@Param("ids") List<String> ids);


5.

public class IdsForm {

   private List<String> ids;

   public List<String> getIds() {
      return ids;
   }

   public void setIds(List<String> ids) {
      this.ids = ids;
   }
}

======mybatis 批量删除：======

void deleteBatchRelation(@Param("entities") List<AttrAttrgroupRelationEntity> entities);

<delete id="deleteBatchRelation">
    delete from pms_attr_attrgroup_relation where
    <foreach collection="entities" item="item" separator=" or ">
        (attr_id = #{item.attrId} and attr_group_id = #{item.attrGroupId})
    </foreach>
</delete>

item是当前元素； separator是分隔符，代表每个元素用什么连接