From a0ccfe5dd2b4e952443caecc3177833e0cebc727 Mon Sep 17 00:00:00 2001
From: whycxzp <glperry@163.com>
Date: 星期三, 13 十一月 2024 15:55:38 +0800
Subject: [PATCH] 调整语法不兼容
---
src/main/resources/mapper/Fbs9100sFodParamMapper.xml | 11 +++++++++--
1 files changed, 9 insertions(+), 2 deletions(-)
diff --git a/src/main/resources/mapper/Fbs9100sFodParamMapper.xml b/src/main/resources/mapper/Fbs9100sFodParamMapper.xml
index fcac351..bb682d6 100644
--- a/src/main/resources/mapper/Fbs9100sFodParamMapper.xml
+++ b/src/main/resources/mapper/Fbs9100sFodParamMapper.xml
@@ -4,8 +4,15 @@
<update id="startOrStopTest" parameterType="fbs9100sFodParam">
- replace into db_ram_db.tb_fbs9100s_fod_param(dev_id,GroupNum,BattGroupNum)
- values(#{devId},#{GroupNum},#{BattGroupNum})
+ <!-- replace into db_ram_db.tb_fbs9100s_fod_param(dev_id,GroupNum,BattGroupNum)
+ values(#{devId},#{GroupNum},#{BattGroupNum})-->
+ merge into db_ram_db.tb_fbs9100s_fod_param tgt
+ using (select #{devId} as dev_id) as src
+ on tgt.dev_id = src.dev_id
+ when matched then
+ update set tgt.GroupNum = #{GroupNum},tgt.BattGroupNum = #{BattGroupNum}
+ when not matched then
+ insert(dev_id,GroupNum,BattGroupNum) values(#{devId},#{GroupNum},#{BattGroupNum})
</update>
<update id="replace" parameterType="fbs9100sFodParam">
replace into db_ram_db.tb_fbs9100s_fod_param(dev_id,GroupNum,BattGroupNum,STDCap_one,FloatVol_one,Strength_one,YHStrength_one,TimeLong_one,STDCap_two,FloatVol_two,Strength_two,YHStrength_two,TimeLong_two
--
Gitblit v1.9.1