mybatis(7) : 批量插入与批量删除

批量插入

mapper.xml

    <insert id="addBatch" keyProperty="id" parameterType="java.util.List">
        INSERT into tm_task_file (
        gmt_create, gmt_modify,
        task_id, file_url, user_code,file_name
        ) VALUES
        <foreach collection="list" item="item" index="index" separator=",">
            (
            #{item.gmtCreate},
            #{item.gmtModify},
            #{item.taskId},
            #{item.fileUrl},
            #{item.userCode},
            #{item.fileName}
            )
        </foreach>
    </insert>

mapper.java

    int addBatch(List<TmTaskFileDO> fileDOS);

 

批量删除

mapper.xml

    <delete id="deleteBatch" parameterType="java.util.Map">
        delete from tm_task_file
        where `task_id` = #{taskId} and `file_name` in (
        <foreach collection="files" item="item" index="index" separator=",">
            #{item}
        </foreach>
        )
    </delete>

注 : parameterType="java.util.Map" 好像可以省略

mapper.java

    int deleteBatch(Map<String, Object> paramMap);

serviceImpl.java

            Map<String, Object> paramMap = new HashMap<String, Object>();
            paramMap.put("projectId", request.getId());
            paramMap.put("files", tmProjectFiles);//tmProjectFiles是一个对象list
            fileMapper.deleteBatch(paramMap);

 

 

END。