From a82b831b8b2b96dfa5791808f1207500e16697cf Mon Sep 17 00:00:00 2001
From: 648540858 <648540858@qq.com>
Date: 星期三, 04 一月 2023 10:39:40 +0800
Subject: [PATCH] 优化设备状态保持，自动记录心跳间隔，三次心跳失败则设备离线，不在使用设备有效期字段作为唯一判断标准，提高容错能力和稳定性。
---
src/main/java/com/genersoft/iot/vmp/storager/dao/RoleMapper.java | 10 +++++-----
1 files changed, 5 insertions(+), 5 deletions(-)
diff --git a/src/main/java/com/genersoft/iot/vmp/storager/dao/RoleMapper.java b/src/main/java/com/genersoft/iot/vmp/storager/dao/RoleMapper.java
index be20a69..66a60b9 100644
--- a/src/main/java/com/genersoft/iot/vmp/storager/dao/RoleMapper.java
+++ b/src/main/java/com/genersoft/iot/vmp/storager/dao/RoleMapper.java
@@ -11,12 +11,12 @@
@Repository
public interface RoleMapper {
- @Insert("INSERT INTO role (name, authority, createTime, updateTime) VALUES" +
+ @Insert("INSERT INTO user_role (name, authority, createTime, updateTime) VALUES" +
"('${name}', '${authority}', '${createTime}', '${updateTime}')")
int add(Role role);
@Update(value = {" <script>" +
- "UPDATE role " +
+ "UPDATE user_role " +
"SET updateTime='${updateTime}' " +
"<if test=\"name != null\">, name='${name}'</if>" +
"<if test=\"authority != null\">, authority='${authority}'</if>" +
@@ -24,12 +24,12 @@
" </script>"})
int update(Role role);
- @Delete("DELETE FROM role WHERE id != 1 and id=#{id}")
+ @Delete("DELETE FROM user_role WHERE id != 1 and id=#{id}")
int delete(int id);
- @Select("select * FROM role WHERE id=#{id}")
+ @Select("select * FROM user_role WHERE id=#{id}")
Role selectById(int id);
- @Select("select * FROM role")
+ @Select("select * FROM user_role")
List<Role> selectAll();
}
--
Gitblit v1.8.0