mybatis批量新增，批量更新

最新推荐文章于 2025-11-08 08:15:00 发布

原创最新推荐文章于 2025-11-08 08:15:00 发布 · 367 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#mysql #java

mysql 同时被 3 个专栏收录

3 篇文章

订阅专栏

数据库

2 篇文章

订阅专栏

mybatis

1 篇文章

订阅专栏

本文详细介绍使用MyBatis进行批量插入和更新操作的方法，包括具体的XML映射文件配置和SQL语句，适用于大量数据处理场景，提高数据库操作效率。

批量新增

int batchInsertEntity(List<CardProductOrderRelation> list);

	<insert id="batchInsertEntity" useGeneratedKeys="true" keyProperty="id">
       insert into card_product_order_relation(order_id,order_code,
       card_number,card_password,amount,discount,status,create_time,create_by) values
       <foreach item="item" index="index" collection="list" separator=",">
           (#{item.orderId},#{item.orderCode},#{item.cardNumber},#{item.cardPassword},#{item.amount},#{item.discount},#{item.status},sysdate(),#{item.createBy})
       </foreach>
   </insert>

批量更新

 <update id="batchUpdateEntity">
        update card_product_order u
        <trim prefix="set" suffixOverrides=",">
            <trim prefix="success_amount =case" suffix="end,">
                <foreach collection="list" item="i" index="index">
                    <if test="i.successAmount!=null">
                        when id=#{i.id} then #{i.successAmount}
                    </if>
                </foreach>
            </trim>
            <trim prefix=" actual_amount =case" suffix="end,">
                <foreach collection="list" item="i" index="index">
                    <if test="i.actualAmount!=null">
                        when id=#{i.id} then #{i.actualAmount}
                    </if>
                </foreach>
            </trim>
            <trim prefix=" actual_balance =case" suffix="end,">
                <foreach collection="list" item="i" index="index">
                    <if test="i.actualBalance!=null">
                        when id=#{i.id} then #{i.actualBalance}
                    </if>
                </foreach>
            </trim>
            <trim prefix=" success_count =case" suffix="end,">
                <foreach collection="list" item="i" index="index">
                    <if test="i.successCount!=null">
                        when id=#{i.id} then #{i.successCount}
                    </if>
                </foreach>
            </trim>
            <trim prefix=" fail_count =case" suffix="end,">
                <foreach collection="list" item="i" index="index">
                    <if test="i.failCount!=null">
                        when id=#{i.id} then #{i.failCount}
                    </if>
                </foreach>
            </trim>
        </trim>
        where id in
        <foreach collection="list" index="index" item="i" separator="," open="(" close=")">
            #{i.id}
        </foreach>
    </update>