From 8bd2f47c9a92ffcf5ae43fae965eaefd4748e263 Mon Sep 17 00:00:00 2001 From: lishuyuan <lishuyuan@inspur.com> Date: 星期四, 02 十一月 2023 10:17:47 +0800 Subject: [PATCH] bugfix:目录订阅收到更新事件时,sql字段update_time为空导致的报错 --- src/main/java/com/genersoft/iot/vmp/storager/dao/DeviceMapper.java | 3 ++- 1 files changed, 2 insertions(+), 1 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 96773fe..30ffd2b 100755 --- a/src/main/java/com/genersoft/iot/vmp/storager/dao/DeviceMapper.java +++ b/src/main/java/com/genersoft/iot/vmp/storager/dao/DeviceMapper.java @@ -2,6 +2,7 @@ import com.genersoft.iot.vmp.gb28181.bean.Device; import org.apache.ibatis.annotations.*; +import org.apache.ibatis.annotations.Param; import org.springframework.stereotype.Repository; import java.util.List; @@ -229,7 +230,7 @@ "geo_coord_sys,"+ "on_line"+ " FROM wvp_device WHERE ip = #{host} AND port=#{port}") - Device getDeviceByHostAndPort(String host, int port); + Device getDeviceByHostAndPort(@Param("host") String host, @Param("port") int port); @Update(value = {" <script>" + "UPDATE wvp_device " + -- Gitblit v1.8.0