【转载】MyBatis批量插入数据（insert）

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.sblueice.mapper.UploadMapper">
    <resultMap id="TestUserResult" type="com.sblueice.entity.TestUser">
        <id column="id" property="id"/>
        <result column="name" property="name"/>
        <result column="sex" property="sex"/>
        <result column="age" property="age"/>
    </resultMap>

    <insert id="insertUser" parameterType="com.sblueice.entity.TestUser">
        INSERT INTO testuser (name, sex, age)
        VALUES
        <foreach collection="list" item="it" separator=",">
            (#{it.name},
            #{it.sex},
            #{it.age})
        </foreach>
    </insert>

</mapper>