制作一个网站,word页面设计模板,wordpress高级版,宜昌网站建设制作公司数据库结构用的是若依的数据库基本结构,ruoyi.vip。 总体参考了文章#xff1a;https://blog.csdn.net/qq_45847507/article/details/126681110 本文章只包含不同的地方#xff0c;相同的不再赘述。 1、创建spring工程#xff0c;jdk1.8#xff0c;maven。 pom.xml中依赖部…数据库结构用的是若依的数据库基本结构,ruoyi.vip。 总体参考了文章https://blog.csdn.net/qq_45847507/article/details/126681110 本文章只包含不同的地方相同的不再赘述。 1、创建spring工程jdk1.8maven。 pom.xml中依赖部分的文件内容
dependenciesdependencygroupIdorg.springframework.boot/groupIdartifactIdspring-boot-starter/artifactId/dependencydependencygroupIdorg.springframework.boot/groupIdartifactIdspring-boot-starter-test/artifactIdscopetest/scope/dependencydependencygroupIdorg.springframework.boot/groupIdartifactIdspring-boot-starter-logging/artifactId/dependencydependencygroupIdorg.springframework.boot/groupIdartifactIdspring-boot-starter-web/artifactId/dependencydependencygroupIdorg.projectlombok/groupIdartifactIdlombok/artifactId/dependencydependencygroupIdorg.springframework.boot/groupIdartifactIdspring-boot-starter-security/artifactId/dependency!--redis依赖--dependencygroupIdorg.springframework.boot/groupIdartifactIdspring-boot-starter-data-redis/artifactId/dependency!--fastjson依赖--dependencygroupIdcom.alibaba/groupIdartifactIdfastjson/artifactIdversion1.2.33/version/dependency!--jwt依赖--dependencygroupIdio.jsonwebtoken/groupIdartifactIdjjwt/artifactIdversion0.9.0/version/dependencydependencygroupIdcom.baomidou/groupIdartifactIdmybatis-plus-boot-starter/artifactIdversion3.4.3/version/dependencydependencygroupIdmysql/groupIdartifactIdmysql-connector-java/artifactId/dependencydependencygroupIdjunit/groupIdartifactIdjunit/artifactIdscopetest/scope/dependency/dependencies2、application.yml的文件内容
spring:datasource:driver-class-name: com.mysql.cj.jdbc.Driverurl: jdbc:mysql://localhost:3306/mall?serverTimezoneGMT%2B8useUnicodetruecharacterEncodingUTF-8username: rootpassword: rootredis:# Redis服务器地址host: 127.0.0.1# Redis服务器连接端口port: 6379# Redis服务器连接密码password: 123456# Redis数据库索引database: 3# 连接超时时间毫秒timeout: 30000lettuce:pool:max-active: 50max-wait: -1max-idle: 50min-idle: 1logging:level:root: info3、实体类 LoginUser.java
package com.rainpet.springsecurity.entity;import com.alibaba.fastjson.annotation.JSONField;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
import org.springframework.security.core.GrantedAuthority;
import org.springframework.security.core.authority.SimpleGrantedAuthority;
import org.springframework.security.core.userdetails.UserDetails;import java.util.Collection;
import java.util.List;
import java.util.stream.Collectors;Data
NoArgsConstructor
public class LoginUser implements UserDetails {private SysUser user;//存储权限信息private ListString permissions;public LoginUser(SysUser user,ListString permissions) {this.user user;this.permissions permissions;}//存储SpringSecurity所需要的权限信息的集合JSONField(serialize false)private ListGrantedAuthority authorities;Overridepublic Collection? extends GrantedAuthority getAuthorities() {if(authorities!null){return authorities;}//把permissions中字符串类型的权限信息转换成GrantedAuthority对象存入authorities中authorities permissions.stream().map(SimpleGrantedAuthority::new).collect(Collectors.toList());return authorities;}Overridepublic String getPassword() {return user.getPassword();}Overridepublic String getUsername() {return user.getUserName();}Overridepublic boolean isAccountNonExpired() {return true;}Overridepublic boolean isAccountNonLocked() {return true;}Overridepublic boolean isCredentialsNonExpired() {return true;}Overridepublic boolean isEnabled() {return true;}
}
SysMenu.java
package com.rainpet.springsecurity.entity;import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;import java.io.Serializable;
import java.time.LocalDateTime;/*** 菜单权限表(SysMenu)实体类**/
Data
AllArgsConstructor
NoArgsConstructor
TableName(value sys_menu)
public class SysMenu implements Serializable {private static final long serialVersionUID -40356785423868312L;/*** 菜单ID*/TableIdprivate Long menuId;/*** 菜单名称*/private String menuName;/*** 父菜单ID*/private Long parentId;/*** 显示顺序*/private Integer orderNum;/*** 路由地址*/private String path;/*** 组件路径*/private String component;/*** 路由参数*/private String query;/*** 路由名称*/private String routeName;/*** 是否为外链0是 1否*/private Boolean isFrame;/*** 是否缓存0缓存 1不缓存*/private Boolean isCache;/*** 菜单类型M目录 C菜单 F按钮*/private String menuType;/*** 菜单状态0显示 1隐藏*/private String visible;/*** 菜单状态0正常 1停用*/private String status;/*** 权限标识*/private String perms;/*** 菜单图标*/private String icon;/*** 创建者*/private String createBy;/*** 创建时间*/private LocalDateTime createTime;/*** 更新者*/private String updateBy;/*** 更新时间*/private LocalDateTime updateTime;/*** 备注*/private String remark;
}
SysRole.java
package com.rainpet.springsecurity.entity;import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;import java.io.Serializable;
import java.time.LocalDateTime;/*** 角色信息表(SysRole)实体类**/
Data
AllArgsConstructor
NoArgsConstructor
TableName(value sys_role)
public class SysRole implements Serializable {private static final long serialVersionUID -40356785423868312L;/*** 角色ID*/TableIdprivate Long roleId;/*** 角色名称*/private String roleName;/*** 角色权限字符串*/private String roleKey;/*** 显示顺序*/private Integer roleSort;/*** 数据范围1全部数据权限 2自定数据权限 3本部门数据权限 4本部门及以下数据权限*/private String dataScope;/*** 菜单树选择项是否关联显示*/private Boolean menuCheckStrictly;/*** 部门树选择项是否关联显示*/private Boolean deptCheckStrictly;/*** 角色状态0正常 1停用*/private String status;/*** 删除标志0代表存在 2代表删除*/private String delFlag;/*** 创建者*/private String createBy;/*** 创建时间*/private LocalDateTime createTime;/*** 更新者*/private String updateBy;/*** 更新时间*/private LocalDateTime updateTime;/*** 备注*/private String remark;
}
SysUser.java
package com.rainpet.springsecurity.entity;import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;import java.io.Serializable;
import java.time.LocalDateTime;/*** 用户信息表(SysUser)实体类**/
Data
AllArgsConstructor
NoArgsConstructor
TableName(value sys_user)
public class SysUser implements Serializable {private static final long serialVersionUID -40356785423868312L;/*** 用户ID*/TableIdprivate Long userId;/*** 部门ID*/private Long deptId;/*** 用户账号*/private String userName;/*** 用户昵称*/private String nickName;/*** 用户类型00系统用户*/private String userType;/*** 用户邮箱*/private String email;/*** 手机号码*/private String phonenumber;/*** 用户性别0男 1女 2未知*/private String sex;/*** 头像地址*/private String avatar;/*** 密码*/private String password;/*** 帐号状态0正常 1停用*/private String status;/*** 删除标志0代表存在 2代表删除*/private String delFlag;/*** 最后登录IP*/private String loginIp;/*** 最后登录时间*/private LocalDateTime loginDate;/*** 创建者*/private String createBy;/*** 创建时间*/private LocalDateTime createTime;/*** 更新者*/private String updateBy;/*** 更新时间*/private LocalDateTime updateTime;/*** 备注*/private String remark;
}
4、mapper SysMenuMapper.java
package com.rainpet.springsecurity.mapper;import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.rainpet.springsecurity.entity.SysMenu;
import org.apache.ibatis.annotations.Mapper;import java.util.List;Mapper
public interface SysMenuMapper extends BaseMapperSysMenu {ListString selectPermsByUserId(Long id);
}
SysRoleMapper.java
package com.rainpet.springsecurity.mapper;import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.rainpet.springsecurity.entity.SysRole;
import org.apache.ibatis.annotations.Mapper;Mapper
public interface SysRoleMapper extends BaseMapperSysRole {}
SysUserMapper.java
package com.rainpet.springsecurity.mapper;import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.rainpet.springsecurity.entity.SysUser;
import org.apache.ibatis.annotations.Mapper;Mapper
public interface SysUserMapper extends BaseMapperSysUser {}
5、其他问题 SysMenuMapper.xml
?xml version1.0 encodingUTF-8 ?
!DOCTYPE mapper PUBLIC -//mybatis.org//DTD Mapper 3.0//EN http://mybatis.org/dtd/mybatis-3-mapper.dtd
mapper namespacecom.rainpet.springsecurity.mapper.SysMenuMapperselect idselectPermsByUserId resultTypejava.lang.StringSELECTDISTINCT (case when m.perms then path else m.perms end)FROMsys_user_role urLEFT JOIN sys_role r ON ur.role_id r.role_idLEFT JOIN sys_role_menu rm ON ur.role_id rm.role_idLEFT JOIN sys_menu m ON m.menu_id rm.menu_idWHEREuser_id #{userid}/select
/mapper
