How to insert list data into a database by MyBatis the operation method __ Database

During web development, using the Spring+springmvc+mybatis development framework, it is sometimes necessary to insert a list loop into the database.

You might consider using the following methods:

<insert id= "insertsomething" parametertype= "Java.util.List" usegeneratedkeys= "false" >
		begin
		< foreach collection= "list" item= "item" index= "index" separator= "; >
			INSERT INTO Table_operation
			(field1,field2,field3,field4,field5,field6)
			values
				(
					#{ Item.field1},
					#{item.field2},
					#{item.field3},
					#{item.field4},
					#{item.field5},
					#{ ITEM.FIELD6}
				)

		</foreach> end
		;
</insert>

Description: Table_operation is the database table to be operated; Field1,field2. is the field corresponding to the database table;

By doing this, you can pass a list as an argument to XML at once and then loop it into the database.