mybatis mapper.xml

萧姐

于 2021-08-28 16:10:30 发布

阅读量109

点赞数

文章标签： xml mybatis

本文链接：https://blog.youkuaiyun.com/qq_27414831/article/details/119969378

版权

这段代码展示了如何使用SQL批量更新和插入数据。updateCustMoney更新pc_cust_money表中storage_amount和already_pc_make_twoafter字段，而insertCustMoney则用于向table_name表中插入实际交易客户代码和已结算金额数据。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

<!--批量更新-->
<update id="updateCustMoney" parameterType="java.util.List">
    <foreach collection="list" item="item" index="index" open="" close="" separator=";">
        update pc_cust_money
        <set>
            <if test="item.storageAmount!=null and item.storageAmount!=''">storage_amount=${item.storageAmount},</if>
            <if test="item.alreadyPcMakeTwoafter!=null and item.alreadyPcMakeTwoafter!=''">already_pc_make_twoafter=${item.alreadyPcMakeTwoafter}</if>
        </set>
        where table_name= ${item.actualTradingCustomerCode}
    </foreach>
</update>
<!--批量新增-->
<insert id="insertCustMoney" parameterType="java.util.List">
    insert into
    table_name
    (actual_trading_customer_code,
    already_pc_make_twoafter)
    values
    <foreach collection="list" item="item" index="index"
             separator=",">
        ( #{item.actualTradingCustomerCode},
        #{item.alreadyPcMakeTwoafter}
        )
    </foreach>
</insert>