insertOrupdate 在mybatis中用ON DUPLICATE KEY UPDATE 写法

阿里巴巴盒马大量招聘 hc多多提供全程面试辅导简历砸过来 laixiaoxing.lxx@alibaba-inc.com 5年内的p6 7年以上的p7 机会多多

 <insert id="insertOrUpdateSelective">

  insert into  t_reconciliation_record

(id, rule_code, batch_no, reconcile_date, clear_date, reconcile_status, merchant_no,
  merchant_name, org_order_no, clear_type, clear_amount, clear_poundage, clear_time,
  trade_order_no, order_center_no, business_type, business_name, expense_type, expense_name,
  trade_type, trade_amount, trade_poundage, trade_time, trade_payee_id, trade_payee_name,
  business_remark, processed, valid)

  values (#{id}, #{ruleCode}, #{batchNo}, #{reconcileDate}, #{clearDate}, #{reconcileStatus},
  #{merchantNo},#{merchantName},#{orgOrderNo}, #{clearType},#{clearAmount}, #{clearPoundage}, #{clearTime},
  #{tradeOrderNo}, #{orderCenterNo}, #{businessType}, #{businessName}, #{expenseType}, #{expenseName},
  #{tradeType}, #{tradeAmount}, #{tradePoundage}, #{tradeTime}, #{tradePayeeId}, #{tradePayeeName},
  #{businessRemark}, #{processed},#{valid})

  ON DUPLICATE KEY UPDATE

  reconcile_status=#{reconcileStatus},clear_amount=#{clearAmount}, clear_poundage=#{clearPoundage}, clear_time=#{clearTime},
  trade_order_no=#{tradeOrderNo}, order_center_no=#{orderCenterNo}, business_type=#{businessType},business_name= #{businessName}, expense_type=#{expenseType}, expense_name=#{expenseName},
  trade_type= #{tradeType},trade_amount= #{tradeAmount}, trade_poundage=#{tradePoundage},trade_time= #{tradeTime},trade_payee_id= #{tradePayeeId},trade_payee_name= #{tradePayeeName},
  business_remark= #{businessRemark}, processed=#{processed}, valid=#{valid};
</insert>