From 9e8cab609d32a5f2143a726a26437cc4d7b8c8da Mon Sep 17 00:00:00 2001 From: 648540858 <18010473990@163.com> Date: 星期二, 10 八月 2021 15:42:15 +0800 Subject: [PATCH] 添加角色相关的接口,用户信息添加角色信息 --- src/main/java/com/genersoft/iot/vmp/storager/dao/UserMapper.java | 28 +++++++++++++++++++--------- 1 files changed, 19 insertions(+), 9 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 e217632..7eb71e6 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,32 +10,42 @@ @Repository public interface UserMapper { - @Insert("INSERT INTO user (username, password, roleId, create_time, update_time) VALUES" + - "('${username}', '${password}', '${roleId}', '${createTime}', '${updateTime}')") + @Insert("INSERT INTO user (username, password, roleId, createTime, updateTime) VALUES" + + "('${username}', '${password}', '${role.id}', '${createTime}', '${updateTime}')") int add(User user); @Update(value = {" <script>" + "UPDATE user " + - "SET update_time='${updateTime}' " + - "<if test=\"roleId != null\">, roleId='${roleId}'</if>" + + "SET updateTime='${updateTime}' " + + "<if test=\"role != null\">, roleId='${role.id}'</if>" + "<if test=\"password != null\">, password='${password}'</if>" + "<if test=\"username != null\">, username='${username}'</if>" + "WHERE id=#{id}" + " </script>"}) int update(User user); - @Delete("DELETE FROM user WHERE id=#{id}") + @Delete("DELETE FROM user WHERE id != 1 and id=#{id}") int delete(int id); - @Select("select * FROM user WHERE username=#{username} AND password=#{password}") + @Select("select user.*, role.id roleID, role.name roleName, role.authority roleAuthority , role.createTime roleCreateTime , role.updateTime roleUpdateTime FROM user, role WHERE user.roleId=role.id and user.username=#{username} AND user.password=#{password}") + @Results(id = "roleMap", value = { + @Result(column = "roleID", property = "role.id"), + @Result(column = "roleName", property = "role.name"), + @Result(column = "roleAuthority", property = "role.authority"), + @Result(column = "roleCreateTime", property = "role.createTime"), + @Result(column = "roleUpdateTime", property = "role.updateTime") + }) User select(String username, String password); - @Select("select * FROM user WHERE id=#{id}") + @Select("select user.*, role.id roleID, role.name roleName, role.authority roleAuthority, role.createTime roleCreateTime , role.updateTime roleUpdateTime FROM user, role WHERE user.roleId=role.id and user.id=#{id}") + @ResultMap(value="roleMap") User selectById(int id); - @Select("select * FROM user WHERE username=#{username}") + @Select("select user.*, role.id roleID, role.name roleName, role.authority roleAuthority, role.createTime roleCreateTime , role.updateTime roleUpdateTime FROM user, role WHERE user.roleId=role.id and username=#{username}") + @ResultMap(value="roleMap") User getUserByUsername(String username); - @Select("select * FROM user") + @Select("select user.*, role.id roleID, role.name roleName, role.authority roleAuthority, role.createTime roleCreateTime , role.updateTime roleUpdateTime FROM user, role WHERE user.roleId=role.id") + @ResultMap(value="roleMap") List<User> selectAll(); } -- Gitblit v1.8.0