mybatis foreach嵌套 批量insert map list数据

以Teacher和Students为例 ，

两者为一对多关系：

Teacher 实体类

@Data
public class Teacher {
    private String teacherId;
    private String teacherName;
    private List<Student> studentList;
}

 Student实体类

@Data
public class Student {
    private String studentId;
    private String studentName;
    private String teacher;
}

 应用场景 ：在老师的service层批量插入老师数据  

        int rows = 1000;
        int cells = 10;
        //定义teacher list
        List<Teacher> teachers = new ArrayList<>();
        //数据是通过excel读取的 此处模拟循环读取excel row数据
        for (int rowi = 0; rowi < rows; rowi++) {
            Teacher teacher = new Teacher();
            teacher.setTeacherName("老师" + rowi);
            List<Student> students = new ArrayList<>();
            for (int cellj = 1; cellj < cells; cellj++) {
                Student student = new Student();
                student.setStudentName("学生" + cellj);
                students.add(student);
            }
            //把student集合和teacher绑定
            teacher.setStudentList(students);
            //把teacher放入list
            teachers.add(teacher);
        }
        //批量插入老师数据
        teacherMapper.batchInsertTeacher(teachers);
        //此时每个teacher对象都有返回的主键id值
        //老师主键 对应一个list(学生信息) map
        Map<String, List<Student>> studentMap = new HashMap<>();
        //填入数据  老师主键一对多学生信息
        for (Teacher teacher : teachers) {
            //非空判断 避免老师没有对应学生的情况（此处只进行逻辑处理 不考虑现实中老师没有学生）
            if (!CollectionUtils.isEmpty(teacher.getStudentList())) {
                studentMap.put(teacher.getTeacherId(), teacher.getStudentList());
            }
        }
        //批量保存学生
        studentMapper.batchInsertStudent(studentMap);

student  Mapper文件

int batchInsertStudent(@Param("studentMap") Map<String,List<Student>> studentMap);

student    mapper.xml文件

 <insert id="batchInsertStudent" parameterType="java.util.Map">
    INSERT INTO student (studentId,studentName,teacher) 
      values
    <foreach collection="studentMap.keys" index="key" item="itemKey" separator=",">

     <foreach collection="studentMap[itemKey]" index="index_list" item="list" separator="," >
          ((select REPLACE(UUID(),'-','') AS studentId) ,#{list.studentName},#{itemKey} )
     </foreach>
    </foreach>
 </insert>

至此 成功插入student数据。