67,514
社区成员
发帖
与我相关
我的任务
分享
public class Person implements Serializable{
/**
*
*/
private static final long serialVersionUID = -8882286452255354656L;
//主键
private Long id;
private String firstname;
private String lastname;
private String school;
... ...
}
void batchInsert( @Param("list") List<Person> persons);
<insert id="batchInsert" keyProperty="id" useGeneratedKeys="true" parameterType="java.util.List">
insert into person (firstName, lastName,school) values
<foreach collection="list" item="person" index="index" separator="," >
(#{person.firstName},#{person.lastName},#{person.school})
</foreach>
</insert>
org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.binding.BindingException: Parameter '__frch_person_0' not found. Available parameters are [list, param1]
org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.binding.BindingException: Parameter '__frch_person_0' not found. Available parameters are [collection, list]