mybatis中做update操作,并想得到更新后的值
接口,这里注意入参必须是实体类
int updateStock(GoodsInfoDO obj);
sql为
<update id="updateStock"> <selectKey resultType="java.lang.Integer" keyProperty="stock" order="AFTER"> select A.stock FROM goods_info A WHERE A.ID = #{id} </selectKey> update goods_info A set A.stock = A.stock+1 where A.ID = #{id} </update>
sql执行后,GoodsInfoDO实体中stock属性的值就变为新的值。