【mybatis】mybatis一条sql更新两张数据表，mybatis关联更新多张数据表

示例sql:

update

security_code_info info

LEFT JOIN

security_code_relation re

ON

re.security_code = info.security_code

set

info.code_stock_state = ${@com.pisen.cloud.luna.ms.security.code.base.domain.SecurityCodeInfo@STOCK_STATE_IN_STOCK},

info.code_state = ${@com.pisen.cloud.luna.ms.security.code.base.domain.SecurityCodeInfo@CODE_STATE_ACTIVATION_EN},

info.receipt_date = #{receiptAndActDate},

re.depot_id = #{depotUid}

where

info.security_code

in

#{item}

查看原文