update（mybatis）sql加判断

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}