调整语法不兼容

whycxzp

2024-11-13 a0ccfe5dd2b4e952443caecc3177833e0cebc727

调整语法不兼容

 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