mybatis 批量插入且多个参数并返回主键
keyProperty=“list.meterReadingRecordId” 中meterReadingRecordId为主键id,list为参数名称@Param(“list”)
·
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”)
魔乐社区(Modelers.cn) 是一个中立、公益的人工智能社区,提供人工智能工具、模型、数据的托管、展示与应用协同服务,为人工智能开发及爱好者搭建开放的学习交流平台。社区通过理事会方式运作,由全产业链共同建设、共同运营、共同享有,推动国产AI生态繁荣发展。
更多推荐



所有评论(0)