<!-- 批量插入用户, foreach 循环操作, 同样不能使用text/byte/clob/blob字段 -->
<insert id="foreachaddStudent" useGeneratedKeys="true">
<foreach collection="list" item="item">
insert into student(username,usertext,userphoto) values
(#{item.userName},#{item.userText},#{item.userPhoto});
</foreach>
</insert>