java list批量删除和批量添加的数据库语句

? <delete id="deleteU5bfqd" parameterType="java.util.List">
???? delete from?表名 where?列名 in
???? <foreach collection="list" item="item" index="index" open="(" separator="," close=")">?
??????? #{item}
??? </foreach>
??? </delete>
????
??? <insert id="importU5bfqd" parameterType="java.util.List">
??insert into?表名 (列名) values?
??? <foreach collection="list" item="item" index="index" separator=",">?
??????? (#{item})
??? </foreach>?
??? </insert>