/*
Navicat MySQL Data Transfer
Source Server : MyOld
Source Server Version : 50728
Source Host : xxxx:3306
Source Database : oldbai
Target Server Type : MYSQL
Target Server Version : 50728
File Encoding : 65001
Date: 2020-08-06 13:12:03
*/SET FOREIGN_KEY_CHECKS=0;-- ------------------------------ Table structure for shiro_account-- ----------------------------DROPTABLEIFEXISTS`shiro_account`;CREATETABLE`shiro_account`(`id`int(11)NOTNULLAUTO_INCREMENT,`username`varchar(255)NOTNULL,`password`varchar(255)NOTNULL,`perms`varchar(255)DEFAULTNULL,`role`varchar(255)DEFAULTNULL,PRIMARYKEY(`id`))ENGINE=InnoDBAUTO_INCREMENT=4DEFAULTCHARSET=utf8;-- ------------------------------ Records of shiro_account-- ----------------------------INSERTINTO`shiro_account`VALUES('1','zs','123123',null,null);INSERTINTO`shiro_account`VALUES('2','ls','123123','manage',null);INSERTINTO`shiro_account`VALUES('3','ww','123123','manage','administrator');
(2)配制文件
pom.xml(Springboot没有把shiro放入快速创建项目中,需要手动导入)
<?xml version="1.0" encoding="UTF-8"?><projectxmlns="http://maven.apache.org/POM/4.0.0"xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd"><modelVersion>4.0.0</modelVersion><parent><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-parent</artifactId><version>2.3.2.RELEASE</version><relativePath/><!-- lookup parent from repository --></parent><groupId>com.example</groupId><artifactId>myshiro</artifactId><version>0.0.1-SNAPSHOT</version><name>myshiro</name><description>Demo project for Spring Boot</description><properties><java.version>1.8</java.version></properties><dependencies><dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-thymeleaf</artifactId></dependency><dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-web</artifactId></dependency><dependency><groupId>org.projectlombok</groupId><artifactId>lombok</artifactId><optional>true</optional></dependency><dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-test</artifactId><scope>test</scope><exclusions><exclusion><groupId>org.junit.vintage</groupId><artifactId>junit-vintage-engine</artifactId></exclusion></exclusions></dependency><!-- 导入shiro--><!-- https://mvnrepository.com/artifact/org.apache.shiro/shiro-spring --><!-- mvn clean install 命令行输入这个构建工程检查是否导入 --><dependency><groupId>org.apache.shiro</groupId><artifactId>shiro-spring</artifactId><version>1.5.3</version></dependency><dependency><groupId>mysql</groupId><artifactId>mysql-connector-java</artifactId><version>8.0.20</version></dependency><!-- 导入mybatis-plus--><dependency><groupId>com.baomidou</groupId><artifactId>mybatis-plus-boot-starter</artifactId><version>3.3.2</version></dependency><!-- 逆向工程--><dependency><groupId>com.baomidou</groupId><artifactId>mybatis-plus-generator</artifactId><version>3.3.1.tmp</version></dependency><!-- 逆向工程的模板 默认的velocity--><dependency><groupId>org.apache.velocity</groupId><artifactId>velocity-engine-core</artifactId><version>2.0</version></dependency></dependencies><build><plugins><plugin><groupId>org.springframework.boot</groupId><artifactId>spring-boot-maven-plugin</artifactId></plugin></plugins></build></project>