1.定义集合
DAO接口:void insert(List list);
2.xml写法
INSERT IGNORE,是id相同时忽略插入此条数据
INSERT IGNORE d_user_course (
id,
user_id,
name
) VALUES
<foreach collection="list" separator="," item="i">
( #{i.id}, #{i.userId}, #{i.name} )
</foreach>