void insertBatchRecord(@Param("list") List<MeterReadingRecord> list, @Param("taskYear") Integer taskYear);
    <insert id="insertBatchRecord" parameterType="com.goldcard.iot.planCollection.domain.MeterReadingRecord" useGeneratedKeys="true" keyProperty="list.meterReadingRecordId">
        INSERT INTO d_meter_reading_record${taskYear}
        (
        meter_reading_task_id,
        busi_type,
        book_id,
        archives_id,
        record_seq,
        meter_id,
        reading_status,
        data_type,
        record_state,
        split_flag,
        water_flag,
        meter_reading_staff_id,
        tenant_id,
        org_code,
        last_record_date,
        last_meter_reading,
        this_record_date,
        cur_meter_reading,
        use_amount,
        create_time,
        task_year,
        task_month,
        check_status,
        image_url,
        latitude,
        longitude,
        parent_record_id
        )
        VALUES
        <foreach collection="list" item="item" separator=",">
            (
            #{item.meterReadingTaskId},
            #{item.busiType},
            #{item.bookId},
            #{item.archivesId},
            #{item.recordSeq},
            #{item.meterId},
            #{item.readingStatus},
            #{item.dataType},
            #{item.recordState},
            #{item.splitFlag},
            #{item.waterFlag},
            #{item.meterReadingStaffId},
            #{item.tenantId},
            #{item.orgCode},
            #{item.lastRecordDate},
            #{item.lastMeterReading},
            #{item.thisRecordDate},
            #{item.curMeterReading},
            #{item.useAmount},
            now(),
            #{item.taskYear},
            #{item.taskMonth},
            #{item.checkStatus},
            #{item.imageUrl},
            #{item.latitude},
            #{item.longitude},
            #{item.parentRecordId}
            )
        </foreach>
    </insert>

keyProperty=“list.meterReadingRecordId” 中meterReadingRecordId为主键id,list为参数名称@Param(“list”)

Logo

魔乐社区(Modelers.cn) 是一个中立、公益的人工智能社区,提供人工智能工具、模型、数据的托管、展示与应用协同服务,为人工智能开发及爱好者搭建开放的学习交流平台。社区通过理事会方式运作,由全产业链共同建设、共同运营、共同享有,推动国产AI生态繁荣发展。

更多推荐