MyBatis 批处理

 

<insert id="insertList" parameterType="java.util.List">
  insert into user (username,password,email) values
  <foreach collection="list" item="user" separator=",">
    (#{user.username},#{user.password},#{user.email})
  </foreach>
</insert>

 

<update id="updateBatchById">
    <foreach collection="list" item="item" separator=";">
        update
            `t_student`
        set
            `name` = #{item.name},
            `age` = #{item.age}
        where
            id = #{item.id}
    </foreach>
</update>