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>