update (mybatis)语句加判断:
update LC.tb_lc_productkind_list
set
STATUS = #{status},
NEXTINT_DATE = null,
RETURN_AMOUNT = #{plan_balance},
RETURN_INTAMT = #{plan_interest} + (CASE WHEN RETURN_INTAMT IS NULL THEN 0 ELSE RETURN_INTAMT END)
where CUSTOMERID = #{cust_id} and PRODUCT_KIND = #{product_kind}
update LC.tb_lc_productkind_list
set
STATUS = #{status},
NEXTINT_DATE = null,
RETURN_AMOUNT = #{plan_balance},
RETURN_INTAMT = #{plan_interest} + nvl(RETURN_INTAMT,0)
where CUSTOMERID = #{cust_id} and PRODUCT_KIND = #{product_kind}