需要,基于RBAC的权限访问,采用SpringSecurity安全管理框架+SpringBoot+Mybatis数据库持久框架。
数据库设计:
user用户名:ennabled,accountNonExpired,accountNonLocked,CredentialsNonExpired默认为1
role角色表:
permisson权限表:
user_role 用户-角色中间表:
role_permission色色-权限中间表:
permission表中初始数据,权限名为permTag
编码实现:
1.pom.xml,引入了jdbc,thymeleaf,security,web,mybatis,devtools,lombox,mysql
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-jdbc</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-thymeleaf</artifactId>
</dependency>
<!-- https://mvnrepository.com/artifact/org.springframework.boot/spring-boot-starter-security -->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-security</artifactId>
<version>2.3.1.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<dependency>
<groupId>org.mybatis.spri