mybatis批量插入

<insert id="insertBatch" parameterType="java.util.List">
insert into xg_t_ss_rc_wj(
wid,
fsrq,
insert_time,
last_changed,
status
)
values
<foreach collection="list" item="item" index="index" separator=",">
(
#{item.wid},
#{item.fsrq},
now(),
now(),
1
)
</foreach>

</insert>

service中

 void insertBatch(ArrayList<XgTSsRcWjInfo> list);
原文地址:https://www.cnblogs.com/yxj808/p/13304977.html