怎样在mapper.xml里批量添加
dao层
void addBatch(@Param("list")List<ZcChatGroupHis> zGroupHis);
mapper.xml
<insert id="addBatch" parameterType="list">
INSERT into zc_chat_group_his
(id, class_code, create_time, leader_name, new_leader_name, update_time, group_code, group_type)
VALUES
<foreach collection="list" item="test" separator=",">
(#{test.id},
#{test.classCode},
#{test.createTime},
#{test.leaderName},
#{test.newLeaderName},
#{test.updateTime},
#{test.groupCode},
#{test.groupType})
</foreach>
</insert>
在VALUES 后面增加值,且每条记录用逗号隔开