mybatis接收List＜Object＞实现批量更新mysql

记录一下今天遇到的业务场景，以便以后直接copy

配置批量处理这个开关方法：在mysql的jdbc链接上直接配置，如

jdbc:mysql://127.0.0.1:3306/database?useUnicode=true&characterEncoding=utf8&allowMultiQueries=true

	void updateByCode(@Param(value = "list") List equipmentInfoList);

	

		
			
				update equipment_info
				
					
						contract_start=#{equipmentInfo.contractStart},
					
					
						contract_end=#{equipmentInfo.contractEnd},
					
					
						contract_code=#{equipmentInfo.contractCode},
					
					
						contract_state=#{equipmentInfo.contractState},
					
					
						contract_type=#{equipmentInfo.contractType},
					
					
						contract_line=#{equipmentInfo.contractLine},
					
					
						visits_yearly=#{equipmentInfo.visitsYearly},
					
					
						spacing=#{equipmentInfo.spacing},
					
					
						partner_number=#{equipmentInfo.partnerNumber},
					
					
						partner_name=#{equipmentInfo.partnerName}
					
				
				
					equipment_code=#{equipmentInfo.equipmentCode}