From fcd79b9864b2dc2478bf3f660fae257af0844937 Mon Sep 17 00:00:00 2001 From: 648540858 <648540858@qq.com> Date: 星期五, 08 七月 2022 11:20:29 +0800 Subject: [PATCH] 用户表增加推流鉴权KEY --- src/main/java/com/genersoft/iot/vmp/storager/dao/dto/User.java | 9 +++++++++ sql/mysql.sql | 1 + src/main/java/com/genersoft/iot/vmp/storager/dao/UserMapper.java | 5 +++-- sql/update.sql | 4 ++++ 4 files changed, 17 insertions(+), 2 deletions(-) diff --git a/sql/mysql.sql b/sql/mysql.sql index ffe39c3..8a7c1bf 100644 --- a/sql/mysql.sql +++ b/sql/mysql.sql @@ -513,6 +513,7 @@ `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `roleId` int NOT NULL, + `pushKey` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci default null, `createTime` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `updateTime` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, PRIMARY KEY (`id`) USING BTREE, diff --git a/sql/update.sql b/sql/update.sql index 4341355..b575f0f 100644 --- a/sql/update.sql +++ b/sql/update.sql @@ -57,4 +57,8 @@ change createStamp createTime varchar(50) default null; +alter table user + add pushKey varchar(50) default null; + + 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 addb27d..cc35789 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 @@ -10,13 +10,14 @@ @Repository public interface UserMapper { - @Insert("INSERT INTO user (username, password, roleId, createTime, updateTime) VALUES" + - "('${username}', '${password}', '${role.id}', '${createTime}', '${updateTime}')") + @Insert("INSERT INTO user (username, password, roleId, pushKey, createTime, updateTime) VALUES" + + "('${username}', '${password}', '${role.id}', '${pushKey}', '${createTime}', '${updateTime}')") int add(User user); @Update(value = {" <script>" + "UPDATE user " + "SET updateTime='${updateTime}' " + + "<if test=\"pushKey != null\">, pushKey='${pushKey}'</if>" + "<if test=\"role != null\">, roleId='${role.id}'</if>" + "<if test=\"password != null\">, password='${password}'</if>" + "<if test=\"username != null\">, username='${username}'</if>" + diff --git a/src/main/java/com/genersoft/iot/vmp/storager/dao/dto/User.java b/src/main/java/com/genersoft/iot/vmp/storager/dao/dto/User.java index 950a8ca..c9b4002 100644 --- a/src/main/java/com/genersoft/iot/vmp/storager/dao/dto/User.java +++ b/src/main/java/com/genersoft/iot/vmp/storager/dao/dto/User.java @@ -7,6 +7,7 @@ private String password; private String createTime; private String updateTime; + private String pushKey; private Role role; public int getId() { @@ -56,4 +57,12 @@ public void setRole(Role role) { this.role = role; } + + public String getPushKey() { + return pushKey; + } + + public void setPushKey(String pushKey) { + this.pushKey = pushKey; + } } -- Gitblit v1.8.0