xml中拼sql

<update id="selfBatchUpdateBill">
    update HSAC_BILL_DETAIL
    <trim prefix="set" suffixOverrides=",">
        LAST_UPDATE_DATE = CURRENT_TIMESTAMP,
        OBJECT_VERSION_NUMBER =OBJECT_VERSION_NUMBER+1,
        <bind name="userId" value="@io.choerodon.core.oauth.DetailsHelper@getUserDetails().getUserId()"/>
        LAST_UPDATED_BY = ${userId},
        <trim prefix="CHECK_NUMBER =case" suffix="end,">
            <foreach collection="list" item="item">
                when BILL_DETAIL_ID=#{item.billDetailId} then #{item.checkNumber}
            </foreach>
        </trim>
        <trim prefix="CHECK_METHODS =case" suffix="end,">
            <foreach collection="list" item="item">
                when BILL_DETAIL_ID=#{item.billDetailId} then #{item.checkMethods}
            </foreach>
        </trim>
        <trim prefix="CHECK_STATUS_CODE =case" suffix="end,">
            <foreach collection="list" item="item">
                when BILL_DETAIL_ID=#{item.billDetailId} then #{item.checkStatusCode}
            </foreach>
        </trim>
        <trim prefix="CHECK_DATE =case" suffix="end,">
            <foreach collection="list" item="item">
                when BILL_DETAIL_ID=#{item.billDetailId} then #{item.checkDate}
            </foreach>
        </trim>
    </trim>
    <where>
        <foreach collection="list" separator="or" item="item">
            BILL_DETAIL_ID = #{item.billDetailId}
        </foreach>
    </where>
</update>

 

XML中拼sql