mybaits批处理

    <insert id="addUsers" parameterType="java.util.List">
        INSERT INTO
        user
        (name,account,password,nickname,phone,createDate,createUser,identity)
        VALUES
        <foreach collection="list" item="item" index="index" separator=",">
            (#{item.name},#{item.account},#{item.password},#{item.nickname},#{item.phone},
            #{item.createDate},#{item.createUser},#{item.identity})
        </foreach>
    </insert>

 

posted @ 2016-07-25 09:54  孙孙孙孙孙小M  阅读(98)  评论(0编辑  收藏  举报