mybatis 根据数组批量删除

来源:互联网 发布:开淘宝c店 编辑:程序博客网 时间:2024/05/01 08:12

1、代码调用者:

Map<String, Object> toUpdateParamMap = new HashMap<String, Object>();        toUpdateParamMap.put("requirementVendorIds", requirementVendorIds); requirementVendorDateMapper.deleteByRequirementVendorIds(toUpdateParamMap);

2、mapper.java

    /**     * 根据多个requirementVendorId删除     */    public void deleteByRequirementVendorIds(Map<String, Object> paramMap);

3、mapper.xml

<update id="deleteByRequirementVendorIds">  update cfm_requirement_vendor_date set del_flag=1     where cfm_requirement_vendor_id in   <foreach item="requirementVendorId" collection="requirementVendorIds" open="(" separator="," close=")">     #{requirementVendorId}  </foreach>    </update>


0 0
原创粉丝点击