From cde7f6460a563a4e9b2624b395d9bdfe6f90e14c Mon Sep 17 00:00:00 2001 From: 648540858 <648540858@qq.com> Date: 星期五, 01 九月 2023 09:21:05 +0800 Subject: [PATCH] Merge pull request #999 from a24211317/wvp-28181-2.0 --- src/main/java/com/genersoft/iot/vmp/storager/dao/RoleMapper.java | 13 ++++++------- 1 files changed, 6 insertions(+), 7 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 old mode 100644 new mode 100755 index 425f5e4..3df7469 --- a/src/main/java/com/genersoft/iot/vmp/storager/dao/RoleMapper.java +++ b/src/main/java/com/genersoft/iot/vmp/storager/dao/RoleMapper.java @@ -1,7 +1,6 @@ package com.genersoft.iot.vmp.storager.dao; import com.genersoft.iot.vmp.storager.dao.dto.Role; -import com.genersoft.iot.vmp.storager.dao.dto.User; import org.apache.ibatis.annotations.*; import org.springframework.stereotype.Repository; @@ -11,25 +10,25 @@ @Repository public interface RoleMapper { - @Insert("INSERT INTO user_role (name, authority, createTime, updateTime) VALUES" + + @Insert("INSERT INTO wvp_user_role (name, authority, create_time, update_time) VALUES" + "(#{name}, #{authority}, #{createTime}, #{updateTime})") int add(Role role); @Update(value = {" <script>" + - "UPDATE user_role " + - "SET updateTime=#{updateTime} " + + "UPDATE wvp_user_role " + + "SET update_time=#{updateTime} " + "<if test=\"name != null\">, name=#{name}</if>" + "<if test=\"authority != null\">, authority=#{authority}</if>" + "WHERE id != 1 and id=#{id}" + " </script>"}) int update(Role role); - @Delete("DELETE FROM user_role WHERE id != 1 and id=#{id}") + @Delete("DELETE from wvp_user_role WHERE id != 1 and id=#{id}") int delete(int id); - @Select("select * FROM user_role WHERE id=#{id}") + @Select("select * from wvp_user_role WHERE id=#{id}") Role selectById(int id); - @Select("select * FROM user_role") + @Select("select * from wvp_user_role") List<Role> selectAll(); } -- Gitblit v1.8.0