1.批量插入
insert into test(create_by,
create_time,name) values
<foreach item="item" index="index" collection="list" separator=",">
(#{item.createBy},#{item.createTime},#{item.name})
</foreach>
2.批量更新
insert into test(id,update_time,update_by,name) values
<foreach item="item" index="index" collection="list" separator=",">
(#{item.id},#{item.updateTime},#{item.updateBy},#{item.name})
</foreach>
on duplicate key update update_time=VALUES(update_time),update_by = VALUES(update_by),name=
VALUES(name)