<insert id="insertAuthor" useGeneratedKeys="true"
keyProperty="id">
insert into Author (username, password, email, bio) values
<foreach item="item" collection="list" separator=",">
(#{item.username}, #{item.password}, #{item.email}, #{item.bio})
</foreach>
</insert>
mybatis的动态sql语句。
最终的sql语句是(如果集合的个数只有2个)
insert into Author (username,password,email,bio) values (?,?,?,?),(?,?,?,?);