Mapper.xml
<insert id="insertForeach" parameterType="list">
insert into student(student_name,student_age) values
<foreach collection="list" index="index" item="student" separator=",">
(#{student.studentName},#{student.studentAge})
</foreach>
</insert>
serviceImpl
@Override
public Integer insertForeach(List<Student> list) {
return studentMapper.insertForeach(list);
}
controller
@ResponseBody
@PostMapping("/insertForeach")
public Integer insertForeach(Student student){
List<Student> list = new ArrayList<>();
for (int i = 0;i<5;i++){
Student student1 = new Student();
student1.setStudentName(""+i);
student1.setStudentAge(i+5);
list.add(student1);
}
Integer integer = studentService.insertForeach(list);
return integer;
}