mybatis batch操作

• 批量插入

<insert id="insertBatch" parameterType="java.util.List">
    insert into tablename
	    (
			column_01,
			column_02,
			column_03
	    )
    values
    <foreach collection="list" item="item" separator="," index="index">
        (
            #{item.column01},
            #{item.column02},
            #{item.column03}
        )
    </foreach>
</insert>

• 批量更新

<update id="updateBatch" parameterType="java.util.List">
	<foreach collection="list" item="item" index="index" open="" close="" separator=";">
    	update tablename
	    <set>
	    	<if test="item.column01 != null">
	        	column01 = #{item.column01},
		    </if>
		    <if test="item.column02!= null">
		        column_02= #{item.column02},
		    </if>
	    </set>
   		where id = #{item.id}
	</foreach>
</update>