记动态sql 删除操作的两种方法

dao接口

int  deleteObjects(@Param("ids")Integer...  ids);

 

创作中心

方法一,

<mapper namespace="dao的包路径">

<delete id="deleteObjects">

delete from table_name

<where>

<foreach  collection="ids" item="id">

     or id=#{id}

</foreach>

</where>

</delete>

</mapper>

 

方法二，

<mapper namespace="dao包路径">

<delete id="deleteObjects">

delete from table_name

where id in

<foreach collection="ids" open="(" close=")" separactor="," item="id">

#{id}

</foreach>

</delete>

</mapper>