MyBatis+Oracle带自定义(随机数)主键的批量添加、删除

1.dao 层接口

@Repository
public interface ExamInterruptDao extends BaseMapper<ExamInterrupt> {
   //添加
   void   insertTestName(@Param("list") List <ExamInterrupt> examInterruptList);
   //删除
   void  deleteByUserId(@Param("list") List <ExamInterrupt> examInterruptList);
}

2.xml文件

 <insert id="insertTestName" parameterType="java.util.List" useGeneratedKeys="false" flushCache="false">
        insert into answer_interrupt_demo
        (
        uuid,
        pid,
        answer_id,
        user_id,
        answer_value,
        sort_id
        )
        <foreach collection="list" item="item" index="index" separator="union all">
            (
            select
            #{item.uuid,jdbcType=VARCHAR},
            #{item.pid,jdbcType=VARCHAR},
            #{item.answer_id,jdbcTyp