为了提高代码的执行效率,我们有时需要采用批量删除的删除方法
批量删除之传入参数–数组
mybatis配置如下:
<delete id="deleteByIds">
DELETE FROM `ldp_info_trade` WHERE id in
<foreach collection="array" item="item" open="(" separator="," close=")">
#{item}
</foreach>
</delete >
mapper配置如下:
public void deleteByIds(String[] ids);
批量查询之传入参数–集合
mybatis配置如下:
<delete id="deleteByIds" parameterType="java.util.List">
DELETE FROM `ldp_info_trade` WHERE id in
<foreach collection="list" item="item" open="(" separator="," close=")">
#{item}
</foreach>
</delete >
mapper配置如下:
public void deleteByIds(List<String> ids);