MyBatis 批量插入List<T> 和批量更新List<T>

分手后的思念是犯贱 2023-10-10 10:30 13阅读 0赞

Mapper 接口定义:

// 批量新增
    	void batchInsert(List<T> list);

Mapper.xml 文件

<insert id="batchInsert" parameterType="java.util.List">
        			insert into SYS_ROLE_PRIVILEGE
        			(SID, ROLE_SID, PRIVILEGE_SID)
        			values
        			<foreach collection="list" item="item" index="index" separator=",">
        				(
        					#{item.sid},
        					#{item.roleSid},
        					#{item.privilegeSid}
        				)
        		     </foreach>		
        </insert>

Mapper 接口定义

// 方法梳理
        void batchUpdate(List<FileInfo> list);

Mapper.xml 文件

<update id="batchUpdate" parameterType="java.util.List">
    		 <foreach collection="list" item="item" index="index" open="" close="" separator=";">
    			 	update ucas_file_info
    			<set>
    				<if test="item.archSid != null">
    					arch_sid = #{item.archSid,jdbcType=VARCHAR},
    				</if>
    				<if test="item.unitProjSid != null">
    					unit_proj_sid = #{item.unitProjSid,jdbcType=VARCHAR},
    				</if>
    				<if test="item.individualProjSid != null">
    					individual_proj_sid =
    					#{item.individualProjSid,jdbcType=VARCHAR},
    				</if>
    				<if test="item.engProjSid != null">
    					eng_proj_sid = #{item.engProjSid,jdbcType=VARCHAR},
    				</if>
    				<if test="item.fileNo != null">
    					file_no = #{item.fileNo,jdbcType=VARCHAR},
    				</if>
    				<if test="item.archFileNo != null">
    					arch_file_no = #{item.archFileNo,jdbcType=VARCHAR},
    				</if>
    				<if test="item.fileId != null">
    					file_id = #{item.fileId,jdbcType=VARCHAR},
    				</if>
    				<if test="item.oldFileId != null">
    					old_file_id = #{item.oldFileId,jdbcType=VARCHAR},
    				</if>
    				<if test="item.fileTitle != null">
    					file_title = #{item.fileTitle,jdbcType=VARCHAR},
    				</if>
    				<if test="item.responsibility != null">
    					responsibility = #{item.responsibility,jdbcType=VARCHAR},
    				</if>
    				<if test="item.fileImageNo != null">
    					file_image_no = #{item.fileImageNo,jdbcType=VARCHAR},
    				</if>
    				<if test="item.manuscriptCode != null">
    					manuscript_code = #{item.manuscriptCode,jdbcType=VARCHAR},
    				</if>
    				<if test="item.storageTypeCode != null">
    					storage_type_code = #{item.storageTypeCode,jdbcType=VARCHAR},
    				</if>
    				<if test="item.securityLevelCode != null">
    					security_level_code =
    					#{item.securityLevelCode,jdbcType=VARCHAR},
    				</if>
    				<if test="item.openStatus != null">
    					open_status = #{item.openStatus,jdbcType=VARCHAR},
    				</if>
    				<if test="item.fileTypeCode != null">
    					file_type_code = #{item.fileTypeCode,jdbcType=VARCHAR},
    				</if>
    				<if test="item.startDate != null">
    					start_date = #{item.startDate,jdbcType=TIMESTAMP},
    				</if>
    				<if test="item.endDate != null">
    					end_date = #{item.endDate,jdbcType=TIMESTAMP},
    				</if>
    				<if test="item.pageNo != null">
    					page_no = #{item.pageNo,jdbcType=VARCHAR},
    				</if>
    				<if test="item.textNums != null">
    					text_nums = #{item.textNums,jdbcType=INTEGER},
    				</if>
    				<if test="item.drawNums != null">
    					draw_nums = #{item.drawNums,jdbcType=INTEGER},
    				</if>
    				<if test="item.baseNums != null">
    					base_nums = #{item.baseNums,jdbcType=INTEGER},
    				</if>
    				<if test="item.photoNums != null">
    					photo_nums = #{item.photoNums,jdbcType=INTEGER},
    				</if>
    				<if test="item.negativeNums != null">
    					negative_nums = #{item.negativeNums,jdbcType=INTEGER},
    				</if>
    				<if test="item.mediaTypeCode != null">
    					media_type_code = #{item.mediaTypeCode,jdbcType=VARCHAR},
    				</if>
    				<if test="item.specCode != null">
    					spec_code = #{item.specCode,jdbcType=VARCHAR},
    				</if>
    				<if test="item.efileInfo != null">
    					efile_info = #{item.efileInfo,jdbcType=VARCHAR},
    				</if>
    				<if test="item.fileHierarchy != null">
    					file_hierarchy = #{item.fileHierarchy,jdbcType=VARCHAR},
    				</if>
    				<if test="item.recordType != null">
    					record_type = #{item.recordType,jdbcType=VARCHAR},
    				</if>
    				<if test="item.note != null">
    					note = #{item.note,jdbcType=VARCHAR},
    				</if>
    				<if test="item.createdBy != null">
    					created_by = #{item.createdBy,jdbcType=VARCHAR},
    				</if>
    				<if test="item.createdDt != null">
    					created_dt = #{item.createdDt,jdbcType=TIMESTAMP},
    				</if>
    				<if test="item.updatedBy != null">
    					updated_by = #{item.updatedBy,jdbcType=VARCHAR},
    				</if>
    				<if test="item.updatedDt != null">
    					updated_dt = #{item.updatedDt,jdbcType=TIMESTAMP},
    				</if>
    				<if test="item.pdfCreatedFlag != null">
    					pdf_created_flag = #{item.pdfCreatedFlag,jdbcType=INTEGER},
    				</if>
    				<if test="item.pdfPath != null">
    					pdf_path = #{item.pdfPath,jdbcType=VARCHAR},
    				</if>
    				<if test="item.pdfFilename != null">
    					pdf_filename = #{item.pdfFilename,jdbcType=VARCHAR},
    				</if>
    				<if test="item.pdfCreatedDt != null">
    					pdf_created_dt = #{item.pdfCreatedDt,jdbcType=TIMESTAMP},
    				</if>
    				<if test="item.deleteFlag != null">
    					delete_flag = #{item.deleteFlag,jdbcType=VARCHAR},
    				</if>
    			</set>
    			where sid = #{item.sid,jdbcType=VARCHAR}
    		 </foreach>
    	</update>