mybatis批量增加和批量修改

批量插入的语句

<insert id="largeSave">
		INSERT INTO bus_project_maintenance_detail(
			id,
			create_by,
			create_date,
			update_by,
			update_date,
			remarks,
			del_flag,
			projectname,
			year,
			username,
			userid,
			coercion_type,
			compulsory_own_funds,
			compulsory_company_borrowing,
			compulsory_mammon_loan,
			isforceorright,
			people_type,
			mainid
		) VALUES
		 	<foreach collection="list" item="busProjectMaintenanceDetail" separator=",">
		 (
				#{busProjectMaintenanceDetail.id},
				#{busProjectMaintenanceDetail.createBy.id},
				#{busProjectMaintenanceDetail.createDate},
				#{busProjectMaintenanceDetail.updateBy.id},
				#{busProjectMaintenanceDetail.updateDate},
				#{busProjectMaintenanceDetail.remarks},
				#{busProjectMaintenanceDetail.delFlag},
				#{busProjectMaintenanceDetail.projectname},
				#{busProjectMaintenanceDetail.year},
				#{busProjectMaintenanceDetail.username},
				#{busProjectMaintenanceDetail.userid},
				#{busProjectMaintenanceDetail.coercionType},
				#{busProjectMaintenanceDetail.compulsoryOwnFunds},
				#{busProjectMaintenanceDetail.compulsoryCompanyBorrowing},
				#{busProjectMaintenanceDetail.compulsoryMammonLoan},
				#{busProjectMaintenanceDetail.isforceorright},
				#{busProjectMaintenanceDetail.peopleType},
				#{busProjectMaintenanceDetail.mainid}
		)
			</foreach>
	</insert>

批量修改

<update id="largeUpdate">
		UPDATE bus_project_maintenance_detail SET
		compulsory_own_funds =
		<foreach collection="list" item="busProjectMaintenanceDetail" index="index"
				 separator=" " open="case id" close="end">
			when #{busProjectMaintenanceDetail.id} then
			#{busProjectMaintenanceDetail.compulsoryOwnFunds}
		</foreach>
		,compulsory_company_borrowing =
		<foreach collection="list" item="busProjectMaintenanceDetail" index="index"
				 separator=" " open="case id" close="end">
			when #{busProjectMaintenanceDetail.id} then
			#{busProjectMaintenanceDetail.compulsoryCompanyBorrowing}
		</foreach>
		,compulsory_mammon_loan =
		<foreach collection="list" item="busProjectMaintenanceDetail" index="index"
				 separator=" " open="case id" close="end">
			when #{busProjectMaintenanceDetail.id} then
			#{busProjectMaintenanceDetail.compulsoryMammonLoan}
		</foreach>
		where id in
		<foreach collection="list" item="busProjectMaintenanceDetail" index="index"
				 separator="," open="(" close=")">
			#{busProjectMaintenanceDetail.id}
		</foreach>
	</update>