MyBatis的批量更新和新增

批量更新

    <!--批量更新-->
    <update id="updateBatch" parameterType="java.util.List">
        <foreach collection="list" item="item" separator=";">
            update pr_tabletwo
            set DXGCID = #{item.dxgcid,jdbcType=INTEGER},
            XH = #{item.xh,jdbcType=VARCHAR},
            FYMC = #{item.fymc,jdbcType=VARCHAR},
            FYID = #{item.fyid,jdbcType=INTEGER},
            KZLX = #{item.kzlx,jdbcType=INTEGER},
            GS = #{item.gs,jdbcType=VARCHAR},
            YJHJSFF = #{item.yjhjsff,jdbcType=VARCHAR},
            HJ = #{item.hj,jdbcType=DOUBLE},
            XGFL = #{item.xgfl,jdbcType=DOUBLE},
            JSSX = #{item.jssx,jdbcType=INTEGER}
            where id = #{item.id,jdbcType=INTEGER}
        </foreach>
    </update>

 

批量新增

 <!--批量插入-->
    <insert id="insertBatch" parameterType="java.util.List">
        <foreach collection="list" item="item" separator=";">
            insert into pr_tabletwo (id, DXGCID, XH,
                FYMC, FYID, KZLX, GS,
                YJHJSFF, HJ, XGFL, JSSX
            )
            values (#{item.id,jdbcType=INTEGER}, #{item.dxgcid,jdbcType=INTEGER},
                 #{item.xh,jdbcType=VARCHAR},#{item.fymc,jdbcType=VARCHAR}, 
                 #{item.fyid,jdbcType=INTEGER}, #{item.kzlx,jdbcType=INTEGER}, 
                 #{item.gs,jdbcType=VARCHAR},#{item.yjhjsff,jdbcType=VARCHAR}, 
                 #{item.hj,jdbcType=DOUBLE}, #{item.xgfl,jdbcType=DOUBLE}, 
                 #{item.jssx,jdbcType=INTEGER}
            )
        </foreach>
    </insert>