根据多条件删除还能这样写

 

 

  <delete id="deleteStaffPosition" parameterType="java.util.List">
        delete from staff_position where (POSITION_ID,STAFF_ID)  in
        <foreach item="item" index="index" collection="list" open="(" separator="," close=")">
            (#{item.POSITION_ID,jdbcType=VARCHAR},#{item.STAFF_ID,jdbcType=VARCHAR})
        </foreach>
    </delete>