目录
一、技术选型和环境要求
二、数据库表设计
/*
SQLyog Ultimate v11.27 (32 bit)
MySQL - 8.0.26 : Database - db_authority_system
--------------------------------------------------------------------------------
//!40101 SET NAMES utf8 /;/!40101 SET SQL_MODE=''/;/!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 /;/!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 /;/!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' /;/!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 /;CREATE DATABASE /!32312 IF NOT EXISTS*/db_authority_system /*!40100 DEFAULT CHARACTER SET utf8 / /!80016 DEFAULT ENCRYPTION='N' */;
USE db_authority_system;
/*Table structure for table sys_department */
DROP TABLE IF EXISTS sys_department;
CREATE TABLE sys_department (
id bigint NOT NULL AUTO_INCREMENT COMMENT '部门编号',
department_name varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '部门名称',
phone varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '部门电话',
address varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '部门地址',
pid bigint NOT NULL COMMENT '所属部门编号',
parent_name varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '所属部门名称',
order_num int DEFAULT NULL COMMENT '排序',
is_delete tinyint DEFAULT '0' COMMENT '是否删除(0-未删除 1-已删除)',
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb3;
/*Data for the table sys_department */
insert into sys_department(id,department_name,phone,address,pid,parent_name,order_num,is_delete) values (1,'广州码农信息技术有限公司','020-8888888','广州市天河区',0,'顶级部门',0,0),(2,'软件技术部','020-88881001','广州市天河区',1,'广州码农信息技术有限公司',1,0),(3,'人事管理部','020-88881002','广州市天河区',1,'广州码农信息技术有限公司',1,0),(4,'市场管理部','020-88881003','广州市天河区',1,'广州码农信息技术有限公司',1,0),(5,'软件研发部','020-88881234','广州市天河区',1,'广州码农信息技术有限公司',2,0),(6,'Java技术部','020-12345678','广州市天河区',2,'软件技术部',NULL,1);
/*Table structure for table sys_permission */
DROP TABLE IF EXISTS sys_permission;
CREATE TABLE sys_permission (
id bigint NOT NULL AUTO_INCREMENT COMMENT '权限编号',
label varchar(50) DEFAULT NULL COMMENT '权限名称',
parent_id bigint DEFAULT NULL COMMENT '父权限ID',
parent_name varchar(50) DEFAULT NULL COMMENT '父权限名称',
code varchar(50) DEFAULT NULL COMMENT '授权标识符',
path varchar(100) DEFAULT NULL COMMENT '路由地址',
name varchar(50) DEFAULT NULL COMMENT '路由名称',
url varchar(100) DEFAULT NULL COMMENT '授权路径',
type tinyint DEFAULT NULL COMMENT '权限类型(0-目录 1-菜单 2-按钮)',
icon varchar(50) DEFAULT NULL COMMENT '图标',
create_time datetime DEFAULT NULL COMMENT '创建时间',
update_time datetime DEFAULT NULL COMMENT '修改时间',
remark varchar(255) DEFAULT NULL COMMENT '备注',
order_num int DEFAULT NULL COMMENT '排序',
is_delete tinyint DEFAULT '0' COMMENT '是否删除(0-未删除，1-已删除)',
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8mb3;
/*Data for the table sys_permission */
insert into sys_permission(id,label,parent_id,parent_name,code,path,name,url,type,icon,create_time,update_time,remark,order_num,is_delete) values (1,'系统管理',0,'顶级菜单','sys:manager','/system','system','/system/system',0,'el-icon-menu','2022-04-25 14:40:32','2022-04-25 14:40:32',NULL,0,0),(2,'部门管理',1,'系统管理','sys:department','/department','department','/system/department/department',1,'el-icon-s-tools','2022-04-25 14:40:32','2022-04-25 14:40:32',NULL,NULL,0),(3,'新增',2,'部门管理','sys:department:add',NULL,NULL,NULL,2,'el-icon-plus','2022-04-25 14:40:32','2022-04-25 14:40:32',NULL,NULL,0),(4,'修改',2,'部门管理','sys:department:edit',NULL,NULL,NULL,2,'el-icon-edit','2022-04-25 14:40:32','2022-04-25 14:40:32',NULL,NULL,0),(5,'删除',2,'部门管理','sys:department:delete',NULL,NULL,NULL,2,'el-icon-delete','2022-04-25 14:40:32','2022-04-25 14:40:32',NULL,NULL,0),(6,'用户管理',1,'系统管理','sys:user','/userList','userList','/system/user/userList',1,'el-icon-s-custom','2022-04-25 14:40:32','2022-04-25 14:40:32',NULL,NULL,0),(7,'新增',6,'用户管理','sys:user:add',NULL,NULL,NULL,2,'el-icon-plus','2022-04-25 14:40:32','2022-04-25 14:40:32',NULL,NULL,0),(8,'修改',6,'用户管理','sys:user:edit',NULL,NULL,NULL,2,'el-icon-edit','2022-04-25 14:40:32','2022-04-25 14:40:32',NULL,NULL,0),(9,'删除',6,'用户管理','sys:user:delete',NULL,NULL,NULL,2,'el-icon-delete','2022-04-25 14:40:32','2022-04-25 14:40:32',NULL,NULL,0),(10,'角色管理',1,'系统管理','sys:role','/roleList','roleList','/system/role/roleList',1,'el-icon-s-tools','2022-04-25 14:40:32','2022-04-25 14:40:32',NULL,NULL,0),(11,'新增',10,'角色管理','sys:role:add',NULL,NULL,NULL,2,'el-icon-plus','2022-04-25 14:40:32','2022-04-25 14:40:32',NULL,NULL,0),(12,'修改',10,'角色管理','sys:role:edit',NULL,NULL,NULL,2,'el-icon-edit','2022-04-25 14:40:32','2022-04-25 14:40:32',NULL,NULL,0),(13,'删除',10,'角色管理','sys:role:delete',NULL,NULL,NULL,2,'el-icon-delete','2022-04-25 14:40:32','2022-04-25 14:40:32',NULL,NULL,0),(14,'菜单管理',1,'系统管理','sys:menu','/menuList','menuList','/system/menu/menuList',1,'el-icon-s-tools','2022-04-25 14:40:32','2022-04-25 14:40:32',NULL,NULL,0),(15,'新增',14,'权限管理','sys:menu:add',NULL,NULL,NULL,2,'el-icon-plus','2022-04-25 14:40:32','2022-04-25 14:40:32',NULL,NULL,0),(16,'修改',14,'权限管理','sys:menu:edit',NULL,NULL,NULL,2,'el-icon-edit','2022-04-25 14:40:32','2022-04-25 14:40:32',NULL,NULL,0),(17,'删除',14,'权限管理','sys:menu:delete',NULL,NULL,NULL,2,'el-icon-delete','2022-04-25 14:40:32','2022-04-25 14:40:32',NULL,NULL,0),(18,'资料管理',0,'顶级菜单','sys:resource','/resource','resource','/resource/index',0,'el-icon-menu','2022-04-25 14:40:32','2022-04-25 14:40:32',NULL,2,0),(19,'供应商管理',18,'资料管理','sys:provider','/providerList','providerList','/system/provider/providerList',1,'el-icon-s-tools','2022-04-25 14:40:32','2022-04-25 14:40:32',NULL,2,0),(20,'新增',19,'供应商管理','sys:provider:add',NULL,NULL,NULL,2,'el-icon-plus','2022-04-25 14:40:32','2022-04-25 14:40:32',NULL,NULL,0),(21,'修改',19,'供应商管理','sys:provider:edit',NULL,NULL,NULL,2,'el-icon-edit','2022-04-25 14:40:32','2022-04-25 14:40:32',NULL,NULL,0),(22,'删除',19,'供应商管理','sys:provider:delete',NULL,NULL,NULL,2,'el-icon-delete','2022-04-25 14:40:32','2022-04-25 14:40:32',NULL,NULL,0),(23,'分配角色',6,'用户管理','sys:user:assign','','','',2,'el-icon-setting',NULL,NULL,NULL,NULL,0),(24,'分配权限',10,'角色管理','sys:role:assign','','','',2,'el-icon-setting',NULL,NULL,NULL,NULL,0),(25,'查询',2,'部门管理','sys:department:select','','','',2,'el-icon-search',NULL,NULL,NULL,NULL,0),(26,'查询',6,'用户管理','sys:user:select','','','',2,'el-icon-search',NULL,NULL,NULL,NULL,0),(27,'查询',10,'角色管理','sys:role:select','','','',2,'el-icon-search',NULL,NULL,NULL,NULL,0),(28,'查询',14,'菜单管理','sys:menu:select','','','',2,'el-icon-search',NULL,NULL,NULL,NULL,0),(29,'订单管理',18,'资料管理','resource:order','/resource/order','OrderList','/resource/order/orderList',1,'el-icon-setting',NULL,NULL,NULL,2,0);
/*Table structure for table sys_role */
DROP TABLE IF EXISTS sys_role;
CREATE TABLE sys_role (
id bigint NOT NULL AUTO_INCREMENT COMMENT '角色编号',
role_code varchar(50) NOT NULL COMMENT '角色编码',
role_name varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '角色名称',
create_user bigint DEFAULT NULL COMMENT '创建人',
create_time datetime DEFAULT NULL COMMENT '创建时间',
update_time datetime DEFAULT NULL COMMENT '修改时间',
remark varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '备注',
is_delete tinyint DEFAULT '0' COMMENT '是否删除(0-未删除，1-已删除)',
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3;
/*Data for the table sys_role */
insert into sys_role(id,role_code,role_name,create_user,create_time,update_time,remark,is_delete) values (1,'ROLE_SYSTEM','超级管理员',1,'2022-04-25 14:44:23','2022-04-25 14:44:23',NULL,0),(2,'ROLE_SYSTEM','系统管理员',1,'2022-04-25 14:44:23','2022-04-25 14:44:23','拥有系统管理功能模块的权限',0),(3,'ROLE_RESOURCE','资料管理员',NULL,NULL,NULL,'拥有资料管理模块的功能权限',0);
/*Table structure for table sys_role_permission */
DROP TABLE IF EXISTS sys_role_permission;
CREATE TABLE sys_role_permission (
role_Id bigint NOT NULL COMMENT '角色ID',
permission_Id bigint NOT NULL COMMENT '权限ID'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*Data for the table sys_role_permission */
insert into sys_role_permission(role_Id,permission_Id) values (1,1),(1,2),(1,3),(1,4),(1,5),(1,25),(1,6),(1,7),(1,8),(1,9),(1,23),(1,26),(1,10),(1,11),(1,12),(1,13),(1,24),(1,27),(1,14),(1,15),(1,16),(1,17),(1,28),(1,18),(1,19),(1,20),(1,21),(1,22),(2,1),(2,2),(2,3),(2,4),(2,5),(2,25),(2,6),(2,7),(2,8),(2,9),(2,23),(2,26),(2,10),(2,11),(2,12),(2,13),(2,24),(2,27),(2,14),(2,15),(2,16),(2,17),(2,28),(3,18),(3,19),(3,20),(3,21),(3,22),(3,29);
/*Table structure for table sys_user */
DROP TABLE IF EXISTS sys_user;
CREATE TABLE sys_user (
id bigint NOT NULL AUTO_INCREMENT COMMENT '用户编号',
username varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '登录名称(用户名)',
password varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '登录密码',
is_account_non_expired tinyint NOT NULL COMMENT '帐户是否过期(1-未过期，0-已过期)',
is_account_non_locked tinyint NOT NULL COMMENT '帐户是否被锁定(1-未过期，0-已过期)',
is_credentials_non_expired tinyint NOT NULL COMMENT '密码是否过期(1-未过期，0-已过期)',
is_enabled tinyint NOT NULL COMMENT '帐户是否可用(1-可用，0-禁用)',
real_name varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '真实姓名',
nick_name varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '昵称',
department_id bigint DEFAULT NULL COMMENT '所属部门ID',
department_name varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '所属部门名称',
gender tinyint NOT NULL COMMENT '性别(0-男，1-女)',
phone varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '电话',
email varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '邮箱',
avatar varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT 'https://manong-authority.oss-cn-guangzhou.aliyuncs.com/avatar/default-avatar.gif' COMMENT '用户头像',
is_admin tinyint DEFAULT '0' COMMENT '是否是管理员(1-管理员)',
create_time datetime DEFAULT NULL COMMENT '创建时间',
update_time datetime DEFAULT NULL COMMENT '修改时间',
is_delete tinyint DEFAULT '0' COMMENT '是否删除(0-未删除，1-已删除)',
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb3;
/*Data for the table sys_user */
insert into sys_user(id,username,password,is_account_non_expired,is_account_non_locked,is_credentials_non_expired,is_enabled,real_name,nick_name,department_id,department_name,gender,phone,email,avatar,is_admin,create_time,update_time,is_delete) values (1,'admin','$2a$10$TdEVQtGCkpo8L.jKjFB3/uxV5xkkDfiy0zoCa.ZS2yAXHe7H95OIC',1,1,1,1,'李明','超级管理员',1,'广州码农信息技术有限公司',0,'13242587415','liming@163.com','https://wpimg.wallstcn.com/f778738c-e4f8-4870-b634-56703b4acafe.gif',1,NULL,NULL,0),(2,'liming','$2a$10$WwhJ8dBezfyMFIn19.ELru58K65k6N2tgewtv2sWdClKiRCjC55wG',1,1,1,1,'黎明','黎明',2,'软件技术部',0,'13262365412578','','https://manong-authority.oss-cn-guangzhou.aliyuncs.com/avatar/default-avatar.gif',0,NULL,NULL,0),(3,'zhangsan','$2a$10$iBQbmrAEBE5B84/U3RY7c.zhObI4aIpjl807FV4LzL/uay7arIcpu',1,1,1,1,'张三','张三',2,'软件技术部',0,'13245678965','zhangsan@163.com','https://manong-authority.oss-cn-guangzhou.aliyuncs.com/avatar/2022/05/16/bfa834a4c9424461a1ea0cbf8d4c9105-5acd2ed959790ec52b2825cbbc11b72d.jpeg',0,NULL,NULL,1),(4,'lisi','$2a$10$QywHvELdRoFGiU6LKpd/X.LYpfaXETtS0pD4Nem2K3c0iMQwaZuAm',1,1,1,1,'李四','李四',2,'软件技术部',0,'13754214568','','https://manong-authority.oss-cn-guangzhou.aliyuncs.com/avatar/2022/05/16/8868a2bfb4364e0697f7c3d28f3d889a-5acd2ed959790ec52b2825cbbc11b72d.jpeg',0,NULL,NULL,0),(5,'wangwu','$2a$10$O8uyPZFS9PLfR8JN.aMRi.l/YeykYYuKH.cg/HBAR.N4NJeNg8hQK',1,1,1,1,'王五','王五',2,'软件技术部',0,'13212345678','','https://manong-authority.oss-cn-guangzhou.aliyuncs.com/avatar/2022/05/16/fe664c1e45bb4e39a719cd3f6d95232a-male.jpg',0,NULL,NULL,0),(6,'zhaoliu','$2a$10$r45wkEYLHlteEr0KLI8y3.G506ylhQrEJkmGM.i2eHkcCnFvfbhCS',1,1,1,1,'赵六','赵六',2,'软件技术部',0,'13212345676','','https://manong-authority.oss-cn-guangzhou.aliyuncs.com/avatar/2022/05/16/8868a2bfb4364e0697f7c3d28f3d889a-5acd2ed959790ec52b2825cbbc11b72d.jpeg',0,NULL,NULL,0);
/*Table structure for table sys_user_role */
DROP TABLE IF EXISTS sys_user_role;
CREATE TABLE sys_user_role (
user_id bigint NOT NULL COMMENT '用户编号',
role_id bigint NOT NULL COMMENT '角色编号'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*Data for the table sys_user_role /insert into sys_user_role(user_id,role_id) values (1,1),(2,2),(4,2),(6,3),(5,3);/!40101 SET SQL_MODE=@OLD_SQL_MODE /;/!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS /;/!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS /;/!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;三、搭建后端项目环境
pom.xml
<?xml version="1.0" encoding="UTF-8"?><project xmlns="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 http://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.7.17</version>
</parent>
<groupId>org.example</groupId>
<artifactId>authority-system</artifactId>
<version>1.0-SNAPSHOT</version>
<properties>
<maven.compiler.source>8</maven.compiler.source>
<maven.compiler.target>8</maven.compiler.target>
<mybatis-plus.version>3.4.1</mybatis-plus.version>
<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
</properties>
<dependencies>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<dependency>
<groupId>com.mysql</groupId>
<artifactId>mysql-connector-j</artifactId>
<scope>runtime</scope>
</dependency>
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>mybatis-plus-boot-starter</artifactId>
<version>${mybatis-plus.version}</version>
</dependency>
<!-- Lombok --> <dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<optional>true</optional>
</dependency>
<!--热部署--> <dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-devtools</artifactId>
<scope>runtime</scope>
<optional>true</optional>
</dependency>
<!-- 单元测试 --> <dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-test</artifactId>
<scope>test</scope>
</dependency>
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>fastjson</artifactId>
<version>1.2.58</version>
</dependency>
<dependency>
<groupId>io.jsonwebtoken</groupId>
<artifactId>jjwt</artifactId>
<version>0.9.1</version>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-data-redis</artifactId>
</dependency>
</dependencies>
<build>
<plugins>
<plugin>
<groupId>org.apache.maven.plugins</groupId>
<artifactId>maven-resources-plugin</artifactId>
<version>3.1.0</version>
</plugin>
<plugin>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-maven-plugin</artifactId>
</plugin>
</plugins>
</build>
</project>application.properties
server.port=9999
spring.datasource.type=com.zaxxer.hikari.HikariDataSource
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
spring.datasource.url=jdbc:mysql://127.0.0.1:3306/db_authority_system?useUnicode=true&characterEncoding=UTF-8&serverTimezone=UTC
spring.datasource.username=root
spring.datasource.password=admin123
mybatis-plus.mapper-locations=classpath:/mapper/**/*.xml
mybatis-plus.type-aliases-package=com.cizhu.authority.entity
#关闭驼峰命名映射
#mybatis-plus.configuration.map-underscore-to-camel-case=false
logging.level.com.cizhu.authority.dao=debug
#JSON日志格式
spring.jackson.date-format= yyyy-MM-dd
#JSON日志格式化设置时区为上海
spring.jackson.time-zone=Asia/Shanghai
jwt.secret=com.cizhu
jwt.expiration=1800000
spring.mvc.format.date=yyyy-MM-dd
spring.mvc.format.date-time=yyyy-MM-dd HH:mm:ss
################################# Redis配置 #################################
spring.redis.host=127.0.0.1
spring.redis.port=6379
spring.redis.password=123456
spring.redis.database=0
spring.redis.timeout=10000
spring.redis.expire=60000
request.login.url=/api/user/login
mybatis-plus.global-config.db-config.logic-delete-field=isDelete
mybatis-plus.global-config.db-config.logic-delete-value=1
mybatis-plus.global-config.db-config.logic-not-delete-value=0
spring.cloud.alicloud.secret-key=cGwJuRlPsS9eRvCijuLjA3wfxZ58aQ
spring.cloud.alicloud.access-key=LTAI5tLmxqCDAEVL9pXaBde4
spring.cloud.alicloud.oss.endpoint=oss-cn-hangzhou.aliyuncs.com
spring.cloud.alicloud.oss.bucket=gulimall-station
aliyun.oss.file.bucketname=guli-school-online四、自动生成接口和类
package com.cizhu.run;
import com.baomidou.mybatisplus.generator.FastAutoGenerator;
import com.baomidou.mybatisplus.generator.config.OutputFile;
import java.util.Collections;
public class CodeGenerator {
public static void main(String[] args) {
generator();
}
private static void generator() {
FastAutoGenerator.create("jdbc:mysql://127.0.0.1:3306/db_authority_system?serverTimezone=UTC&characterEncoding=utf-8&useSSL=false&allowPublicKeyRetrieval=true", "root", "admin123")
.globalConfig(builder -> {
builder.author("cizhu") // 设置作者
.enableSwagger() // 开启 swagger 模式
.fileOverride() // 覆盖已生成文件
.outputDir("/Users/gejia/Desktop/demoPro/authority-system/src/main/java"); // 指定输出目录
})
// .dataSourceConfig(builder -> builder.typeConvertHandler((globalConfig, typeRegistry, metaInfo) -> {
// int typeCode = metaInfo.getJdbcType().TYPE_CODE;
// if (typeCode == Types.SMALLINT) {
// // 自定义类型转换
// return DbColumnType.INTEGER;
// }
// return typeRegistry.getColumnType(metaInfo);
//
// }))
.packageConfig(builder -> {
builder.parent("com.cizhu") // 设置父包名
.moduleName(null) // 设置父包模块名
.pathInfo(Collections.singletonMap(OutputFile.mapperXml, "/Users/gejia/Desktop/demoPro/authority-system/src/main/resources/mapper")); // 设置mapperXml生成路径
})
.strategyConfig(builder -> {
// builder.addInclude("t_simple") // 设置需要生成的表名
// .addTablePrefix("t_", "c_"); // 设置过滤表前
builder.addTablePrefix("sys_");
builder.entityBuilder().enableLombok(); // 启用lombok
builder.controllerBuilder().enableRestStyle(); // 启动RestFul
builder.addInclude("sys_department","sys_role","sys_permission","sys_role_permission","sys_user"); // 设置需要生成的表名
})
// .templateEngine(new FreemarkerTemplateEngine()) // 使用Freemarker引擎模板，默认的是Velocity引擎模板
.execute();
}
}
User.java代码代码
下列字段改成 boolean
@ApiModelProperty("帐户是否过期(1-未过期，0-已过期)")
private boolean isAccountNonExpired =true;
@ApiModelProperty("帐户是否被锁定(1-未过期，0-已过期)")
private boolean isAccountNonLocked=true;
@ApiModelProperty("密码是否过期(1-未过期，0-已过期)")
private boolean isCredentialsNonExpired=true;
@ApiModelProperty("帐户是否可用(1-可用，0-禁用)")
private boolean isEnabled =true;继承org.springframework.security.core.userdetails.UserDetails重写两个属性
/** * 权限列表 */
@TableField(exist = false)
Collection<? extends GrantedAuthority> authorities;
@TableField(exist = false)
private List<Permission> permissionList;
service.impl 接口实现服务层加事务注解@Transactional
安装插件lombok/MyBatisX
五、封装统一返回结果类型
在com.cizhu.utils包下编写统一返回类
ResultCode.java
package com.cizhu.utils;
public class ResultCode {
/**
* 成功状态码
*/
public static final Integer SUCCESS = 200;
/**
* 失败状态码
*/
public static final Integer ERROR = 500;
/**
* 未登录状态码
*/
public static final int NO_LOGIN = 600;
/**
* 没有权限状态码
*/
public static final int NO_AUTH = 700;
}
Result <T>.java范型类
package com.cizhu.utils;
import lombok.Data;
@Data
public class Result <T>{
private Boolean success;//是否成功
private Integer code;//状态码
private String message;//返回消息
private T data;//返回数据
/**
* 私有化构造方法，禁止在其它类创建对象
*/
private Result(){}
/**
* 成功执行，不返回数据
* @return
*/
public static<T> Result<T> ok(){
Result<T> result = new Result<T>();
result.setSuccess(true);
result.setCode(ResultCode.SUCCESS);
result.setMessage("执行成功");
return result;
}
/**
* 成功执行，并返回数据
* @param data
* @param <T>
* @return
*/
public static<T> Result<T> ok(T data){
Result<T> result = new Result<T>();
result.setSuccess(true);
result.setCode(ResultCode.SUCCESS);
result.setMessage("执行成功");
result.setData(data);
return result;
}
/**
* 失败
* @return
*/
public static<T> Result<T> error(){
Result<T> result = new Result<T>();
result.setSuccess(false);
result.setCode(ResultCode.ERROR);
result.setMessage("执行失败");
return result;
}
/**
* 设置是否成功
* @param success
* @return
*/
public Result<T> success(Boolean success){
this.setSuccess(success);
return this;
}
/**
* 设置状态码
* @param code
* @return
*/
public Result<T> code(Integer code){
this.setCode(code);
return this;
}
/**
* 设置返回消息
* @param message
* @return
*/
public Result<T> message(String message){
this.setMessage(message);
return this;
}
/**
* 是否存在
* @return
*/
public static<T> Result<T> exist(){
Result<T> result = new Result<T>();
result.setSuccess(false);//存在该数据
//由于vue-element-admin模板在响应时验证状态码是否是200，如果不是200，则报错
result.setCode(ResultCode.SUCCESS);//执行成功，但存在该数据
result.setMessage("该数据存在");
return result;
}
// public static<T> Result<T> exist(){
// Result<T> result = new Result<T>();
// result.setSuccess(true);
// result.setCode(ResultCode.SUCCESS);
// result.setMessage("执行成功");
// return result;
// }
}
测试
@Resource
private IUserService userService;
//查询所有的用户信息
@GetMapping("listAll")
public Result getAll() {
List<User> list = userService.list();
return Result.ok(list);
}六、mybatis-plus配置类
1、分页配置类
package com.cizhu.config.mybatis;
import com.baomidou.mybatisplus.annotation.DbType;
import com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor;
import com.baomidou.mybatisplus.extension.plugins.inner.PaginationInnerInterceptor;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
@Configuration
public class MybatisPlusConfig {
// 最新版分页插件
@Bean
public MybatisPlusInterceptor mybatisPlusInterceptor() {
MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor();
PaginationInnerInterceptor paginationInnerInterceptor =
new PaginationInnerInterceptor(DbType.MYSQL);
paginationInnerInterceptor.setOverflow(true);//溢出后从第页开始
//指定数据库类型
interceptor.addInnerInterceptor(paginationInnerInterceptor);
return interceptor;
}
}
2、自动填充配置类
package com.cizhu.config.mybatis;
import com.baomidou.mybatisplus.core.handlers.MetaObjectHandler;
import org.apache.ibatis.reflection.MetaObject;
import org.springframework.stereotype.Component;
import java.util.Date;
@Component
public class CommonMetaObjectHandler implements MetaObjectHandler {
/**
* 新增
*
* @param metaObject
*/
@Override
public void insertFill(MetaObject metaObject) {
//参数：元数据对象
//参数：属性名称
//参数：类对象
//参数：当前系统时间
this.strictInsertFill(metaObject, "createTime", Date.class, new Date());
this.strictUpdateFill(metaObject, "updateTime", Date.class, new Date());
}
/**
* 修改
*
* @param metaObject
*/
@Override
public void updateFill(MetaObject metaObject) {
this.strictUpdateFill(metaObject, "updateTime", Date.class, new Date());
}
}七、跨域请求配置
package com.cizhu.config.web;
import org.springframework.context.annotation.Configuration;
import org.springframework.web.servlet.config.annotation.CorsRegistry;
import org.springframework.web.servlet.config.annotation.WebMvcConfigurer;
@Configuration
public class CORSConfig implements WebMvcConfigurer {
@Override
public void addCorsMappings(CorsRegistry registry) {
registry.addMapping("/**").//允许所有的访问请求（访问路径）
allowedMethods("*").//允许所有的请求方法访问该跨域资源服务器
allowedOrigins("*").//允许所有的请求域名访问我们的跨域资源
allowedHeaders("*");//允许所有的请求header访问
}
}八、创建远程仓库并推送
先在gitee创建一个远程仓库，并复制仓库地址。
粘贴远程仓库地址
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
