From ea32cd2673b83b9481e8cc45705d2d3a84e884bb Mon Sep 17 00:00:00 2001
From: 64850858 <648540858@qq.com>
Date: 星期一, 26 七月 2021 13:21:03 +0800
Subject: [PATCH] 重启后对心跳超时的设备设置为离线。
---
src/main/java/com/genersoft/iot/vmp/storager/dao/UserMapper.java | 14 ++++++++------
1 files changed, 8 insertions(+), 6 deletions(-)
diff --git a/src/main/java/com/genersoft/iot/vmp/storager/dao/UserMapper.java b/src/main/java/com/genersoft/iot/vmp/storager/dao/UserMapper.java
index 4608a29..6ecc828 100644
--- a/src/main/java/com/genersoft/iot/vmp/storager/dao/UserMapper.java
+++ b/src/main/java/com/genersoft/iot/vmp/storager/dao/UserMapper.java
@@ -1,6 +1,5 @@
package com.genersoft.iot.vmp.storager.dao;
-import com.genersoft.iot.vmp.gb28181.bean.GbStream;
import com.genersoft.iot.vmp.storager.dao.dto.User;
import org.apache.ibatis.annotations.*;
import org.springframework.stereotype.Repository;
@@ -14,18 +13,21 @@
int add(User user);
@Update("UPDATE user " +
- "SET username=#{username}," +
- "password=#{password}," +
- "roleId=#{roleId}" +
+ "SET username=#{username}, " +
+ "password=#{password}, " +
+ "roleId=#{roleId} " +
"WHERE id=#{id}")
int update(User user);
@Delete("DELETE FROM user WHERE app=#{app} AND id=#{id}")
int delete(User user);
- @Select("select * FROM user WHERE username= #{username} AND password=#{password}")
+ @Select("select * FROM user WHERE username=#{username} AND password=#{password}")
User select(String username, String password);
- @Select("select * FROM user WHERE id= #{id}")
+ @Select("select * FROM user WHERE id=#{id}")
User selectById(int id);
+
+ @Select("select * FROM user WHERE username=#{username}")
+ User getUserByUsername(String username);
}
--
Gitblit v1.8.0