近期在项目中用到批量删除的方法,在此做一次记录
Mapper接口中的方法:
int deletePageNotContainsDetail(@Param("dmDsId")String dmDsId,
@Param("pageNotContainsList") List<String> pageNotContainsList,
@Param("invalidFlag") String invalidFlag);
Mapper映射文件中的sql语句:
<delete id="deletePageNotContainsDetail">
delete from
HJ_MDM_DM_DS_DETAIL d
where
d.dm_ds_id =#{dmDsId} and d.invalid_flag = #{invalidFlag} and d.data_ele_id IN
<foreach collection="pageNotContainsList" item="dataEleId" separator="," open="(" close=")">
#{dataEleId}
</foreach>
</delete>