mybatis update语句 返回值为null

解决方案:检查xml中对应的sql语句,标签不是select而是update
错误写法:

    <select id="lockSkuStock" resultType="java.lang.Long">
        update wms_ware_sku
        set stock_locked = stock_locked + #{num}
        where sku_id = #{skuId}
          and ware_id = #{wareId}
          and stock - stock_locked > 0
    </select>

控制台输出:null
image

修改为:

    <update id="lockSkuStock">
        update wms_ware_sku
        set stock_locked = stock_locked + #{num}
        where sku_id = #{skuId}
          and ware_id = #{wareId}
          and stock - stock_locked > 0
    </update>
posted @ 2023-08-04 00:44  伊万夫斯基  阅读(179)  评论(0编辑  收藏  举报