mybatis 向表中插入集合

java中写法:

public int addAppraiseRecordStaffList(List<AppraiseRecordStaff> appraiseRecordStaffList);

xml中写法:

<insert id="addAppraiseRecordReportViewer">
    insert into appraise_record_report_viewer (id,staff_id,program_code,course_code,department,college,data_type,data_source_id,create_by,del_flag,create_date,update_date) values
    <foreach collection="list" item="b" index="index" separator="," >
        (#{b.id},#{b.staffId},#{b.programCode},#{b.courseCode},#{b.department},#{b.college},#{b.dataType},#{b.dataSourceId},'1',#{b.delFlag},sysdate(),sysdate())
    </foreach>
</insert>