shiro环境搭建

1 pom文件中引入依赖

<dependency>
            <groupId>org.apache.shiro</groupId>
            <artifactId>shiro-core</artifactId>
            <version>1.4.1</version>
</dependency>

2 JdbcRealm数据库表结构(固定)

CREATE TABLE users(
    id INT PRIMARY KEY AUTO_INCREMENT,
    username VARCHAR(60) NOT NULL UNIQUE,
    PASSWORD VARCHAR(20) NOT NULL,
    password_salt VARCHAR(20)
    );
    
    
    
CREATE TABLE user_roles(
    id INT PRIMARY KEY AUTO_INCREMENT,
    username VARCHAR(60) NOT NULL,
    role_name VARCHAR(100) NOT NULL
    );
    
    
CREATE TABLE roles_permissions(
    id INT PRIMARY KEY AUTO_INCREMENT,
    role_name VARCHAR(100) NOT NULL,
    permission VARCHAR(100) NOT NULL
    )