curitycode

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

新多张数据表

⽰例sql:

update

curity_code_infoinfo

LEFTJOIN

curity_code_relationre

ON

ty_code=ty_code

t

_stock_state=${@tyCodeInfo@STOCK_STATE_IN_STOCK},

_state=${@tyCodeInfo@CODE_STATE_ACTIVATION_EN},

t_date=#{receiptAndActDate},

_id=#{depotUid}

where

ty_code

in

#{item}