From d03e8b042851d6d8ef6b113977d961a1f5814f57 Mon Sep 17 00:00:00 2001
From: 648540858 <648540858@qq.com>
Date: 星期四, 05 一月 2023 17:49:50 +0800
Subject: [PATCH] Merge remote-tracking branch 'origin/wvp-28181-2.0' into wvp-28181-2.0
---
src/main/java/com/genersoft/iot/vmp/storager/dao/DeviceMapper.java | 62 +++++++++++++++---------------
1 files changed, 31 insertions(+), 31 deletions(-)
diff --git a/src/main/java/com/genersoft/iot/vmp/storager/dao/DeviceMapper.java b/src/main/java/com/genersoft/iot/vmp/storager/dao/DeviceMapper.java
index 048206a..8143d35 100644
--- a/src/main/java/com/genersoft/iot/vmp/storager/dao/DeviceMapper.java
+++ b/src/main/java/com/genersoft/iot/vmp/storager/dao/DeviceMapper.java
@@ -106,22 +106,22 @@
@Update(value = {" <script>" +
"UPDATE device " +
- "SET updateTime='${updateTime}'" +
- "<if test=\"name != null\">, name='${name}'</if>" +
- "<if test=\"manufacturer != null\">, manufacturer='${manufacturer}'</if>" +
- "<if test=\"model != null\">, model='${model}'</if>" +
- "<if test=\"firmware != null\">, firmware='${firmware}'</if>" +
- "<if test=\"transport != null\">, transport='${transport}'</if>" +
- "<if test=\"ip != null\">, ip='${ip}'</if>" +
- "<if test=\"localIp != null\">, localIp='${localIp}'</if>" +
- "<if test=\"port != null\">, port=${port}</if>" +
- "<if test=\"hostAddress != null\">, hostAddress='${hostAddress}'</if>" +
- "<if test=\"online != null\">, online=${online}</if>" +
- "<if test=\"registerTime != null\">, registerTime='${registerTime}'</if>" +
- "<if test=\"keepaliveTime != null\">, keepaliveTime='${keepaliveTime}'</if>" +
- "<if test=\"keepaliveIntervalTime != null\">, keepaliveIntervalTime='${keepaliveIntervalTime}'</if>" +
- "<if test=\"expires != null\">, expires=${expires}</if>" +
- "WHERE deviceId='${deviceId}'"+
+ "SET updateTime=#{updateTime}" +
+ "<if test=\"name != null\">, name=#{name}</if>" +
+ "<if test=\"manufacturer != null\">, manufacturer=#{manufacturer}</if>" +
+ "<if test=\"model != null\">, model=#{model}</if>" +
+ "<if test=\"firmware != null\">, firmware=#{firmware}</if>" +
+ "<if test=\"transport != null\">, transport=#{transport}</if>" +
+ "<if test=\"ip != null\">, ip=#{ip}</if>" +
+ "<if test=\"localIp != null\">, localIp=#{localIp}</if>" +
+ "<if test=\"port != null\">, port=#{port}</if>" +
+ "<if test=\"hostAddress != null\">, hostAddress=#{hostAddress}</if>" +
+ "<if test=\"online != null\">, online=#{online}</if>" +
+ "<if test=\"registerTime != null\">, registerTime=#{registerTime}</if>" +
+ "<if test=\"keepaliveTime != null\">, keepaliveTime=#{keepaliveTime}</if>" +
+ "<if test=\"keepaliveIntervalTime != null\">, keepaliveIntervalTime=#{keepaliveIntervalTime}</if>" +
+ "<if test=\"expires != null\">, expires=#{expires}</if>" +
+ "WHERE deviceId=#{deviceId}"+
" </script>"})
int update(Device device);
@@ -225,28 +225,28 @@
"geoCoordSys," +
"treeType," +
"online" +
- " FROM device WHERE ip = #{host} AND port=${port}")
+ " FROM device WHERE ip = #{host} AND port=#{port}")
Device getDeviceByHostAndPort(String host, int port);
@Update(value = {" <script>" +
"UPDATE device " +
- "SET updateTime='${updateTime}'" +
- "<if test=\"name != null\">, custom_name='${name}'</if>" +
- "<if test=\"password != null\">, password='${password}'</if>" +
- "<if test=\"streamMode != null\">, streamMode='${streamMode}'</if>" +
- "<if test=\"ip != null\">, ip='${ip}'</if>" +
- "<if test=\"sdpIp != null\">, sdpIp='${sdpIp}'</if>" +
- "<if test=\"port != null\">, port=${port}</if>" +
- "<if test=\"charset != null\">, charset='${charset}'</if>" +
- "<if test=\"subscribeCycleForCatalog != null\">, subscribeCycleForCatalog=${subscribeCycleForCatalog}</if>" +
- "<if test=\"subscribeCycleForMobilePosition != null\">, subscribeCycleForMobilePosition=${subscribeCycleForMobilePosition}</if>" +
- "<if test=\"mobilePositionSubmissionInterval != null\">, mobilePositionSubmissionInterval=${mobilePositionSubmissionInterval}</if>" +
- "<if test=\"subscribeCycleForAlarm != null\">, subscribeCycleForAlarm=${subscribeCycleForAlarm}</if>" +
- "<if test=\"ssrcCheck != null\">, ssrcCheck=${ssrcCheck}</if>" +
+ "SET updateTime=#{updateTime}" +
+ "<if test=\"name != null\">, custom_name=#{name}</if>" +
+ "<if test=\"password != null\">, password=#{password}</if>" +
+ "<if test=\"streamMode != null\">, streamMode=#{streamMode}</if>" +
+ "<if test=\"ip != null\">, ip=#{ip}</if>" +
+ "<if test=\"sdpIp != null\">, sdpIp=#{sdpIp}</if>" +
+ "<if test=\"port != null\">, port=#{port}</if>" +
+ "<if test=\"charset != null\">, charset=#{charset}</if>" +
+ "<if test=\"subscribeCycleForCatalog != null\">, subscribeCycleForCatalog=#{subscribeCycleForCatalog}</if>" +
+ "<if test=\"subscribeCycleForMobilePosition != null\">, subscribeCycleForMobilePosition=#{subscribeCycleForMobilePosition}</if>" +
+ "<if test=\"mobilePositionSubmissionInterval != null\">, mobilePositionSubmissionInterval=#{mobilePositionSubmissionInterval}</if>" +
+ "<if test=\"subscribeCycleForAlarm != null\">, subscribeCycleForAlarm=#{subscribeCycleForAlarm}</if>" +
+ "<if test=\"ssrcCheck != null\">, ssrcCheck=#{ssrcCheck}</if>" +
"<if test=\"geoCoordSys != null\">, geoCoordSys=#{geoCoordSys}</if>" +
"<if test=\"treeType != null\">, treeType=#{treeType}</if>" +
"<if test=\"mediaServerId != null\">, mediaServerId=#{mediaServerId}</if>" +
- "WHERE deviceId='${deviceId}'"+
+ "WHERE deviceId=#{deviceId}"+
" </script>"})
int updateCustom(Device device);
--
Gitblit v1.8.0