# RBAC-SYSTEM

**Repository Path**: create-clover/rbac-system

## Basic Information

- **Project Name**: RBAC-SYSTEM
- **Description**: RBAC的学习和使用,实习课题
- **Primary Language**: Java
- **License**: AGPL-3.0
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2022-02-21
- **Last Updated**: 2022-03-02

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

2021.12.26：

...
使用的网址：
vue组建：https://element.eleme.cn/#/zh-CN/component/carousel
https://www.jianshu.com/p/63792e787333
https://zhuanlan.zhihu.com/p/114229835
https://www.shangmayuan.com/a/9ab474fb9dcd4c26b0939b40.html

```sql
# 实习项目
DROP database IF EXISTS clover_db_1;
create database clover_db_1;
use clover_db_1;
# user_info.sql(用户表)
DROP TABLE IF EXISTS `user_info`;
CREATE TABLE `user_info` (
  `uid` int NOT NULL AUTO_INCREMENT,
  `username` varchar(50) DEFAULT '' COMMENT '用户名',
  `user_password` varchar(256) DEFAULT NULL COMMENT '登陆密码',
  `real_name` varchar(256) DEFAULT NULL COMMENT '用户真实姓名',
  `id_card_num` varchar(288) DEFAULT NULL COMMENT '用户身份证号',
  `email` varchar(256) unique COMMENT '邮箱',
  `user_status` tinyint DEFAULT '0' COMMENT '用户状态：0-正常状态1-用户被锁定',
  `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  `update_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '修改时间',
  PRIMARY KEY (`uid`),
  UNIQUE KEY `username` (`username`) USING BTREE,
  UNIQUE KEY `id_card_num` (`id_card_num`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

# role.sql(角色表）
DROP TABLE IF EXISTS `role_info`;
CREATE TABLE `role_info` (
  `role_id` int NOT NULL AUTO_INCREMENT COMMENT '主键',
  `role_status` tinyint DEFAULT '0' COMMENT '是否可用0可用  1不可用',
  `role_name` varchar(20) DEFAULT NULL COMMENT '角色标识程序中判断使用,如"admin"',
  `description` varchar(100) DEFAULT NULL COMMENT '角色描述,UI界面显示使用',
  `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  `update_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '修改时间',
  PRIMARY KEY (`role_id`),
  UNIQUE KEY `role_name` (`role_name`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

# user_role.sql(用户-角色表)
DROP TABLE IF EXISTS `user_role`;
CREATE TABLE `user_role` (
  `uid` int COMMENT '用户id',
  `role_id` int COMMENT '角色id',
  KEY `uid` (`uid`) USING BTREE,
  KEY `role_id` (`role_id`) USING BTREE,
  FOREIGN KEY(uid) REFERENCES user_info(uid),
  FOREIGN KEY(role_id) REFERENCES role_info(role_id),
  primary key (uid,role_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

# permission.sql(权限表)
DROP TABLE IF EXISTS `permission`;
CREATE TABLE `permission` (
  `permission_id` int NOT NULL AUTO_INCREMENT COMMENT '主键',
  `permission_name` varchar(50) DEFAULT NULL COMMENT '权限名称',
  `parent_id` int DEFAULT NULL COMMENT '父编号,本权限多是该父编号权限的子权限',
  `perm` varchar(100) DEFAULT NULL COMMENT '权限字符串,menu例子：role:*，button例子：role:create,role:update,role:delete,role:view',
  `resource_type` varchar(20) DEFAULT NULL COMMENT '资源类型，[menu|button]',
  `url` varchar(200) DEFAULT NULL COMMENT '资源路径 如：/userinfo/list',
  `perm_status` tinyint DEFAULT '0' COMMENT '是否可用0可用  1不可用',
  `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  `update_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '修改时间',
  PRIMARY KEY (`permission_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

# role_permission(角色-权限表)
DROP TABLE IF EXISTS `role_permission`;
CREATE TABLE `role_permission` (
  `role_id` int COMMENT '角色id',
  `permission_id` int COMMENT '权限id',
  KEY `role_id` (`role_id`) USING BTREE,
  KEY `permission_id` (`permission_id`) USING BTREE,
  FOREIGN KEY(role_id) REFERENCES role_info(role_id),
  FOREIGN KEY(permission_id)  REFERENCES permission(permission_id),
  primary key (role_id,permission_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

#  ====数据====
#插入用户信息表
insert into user_info(username,user_password,real_name,id_card_num,email,user_status) VALUES('admin120','123456','超哥','350623184201115411','chaoge@qq.com',0);
insert into user_info(username,user_password,real_name,id_card_num,email,user_status) VALUES('admin121','123456','孙悟空','350623194401051110','sunwukong@126.com',0);
insert into user_info(username,user_password,real_name,id_card_num,email,user_status) VALUES('user123','123456','许仙','350624200011015411','xuxian@qq.com',0);
insert into user_info(username,user_password,real_name,id_card_num,email,user_status) VALUES('user124','123456','白素贞','350625100001018512','baisuzhen@126.com',0);

#插入用户角色表
INSERT INTO `role_info` (`role_status`,`role_name`,`description`) VALUES (0,'管理员','admin');
INSERT INTO `role_info` (`role_status`,`role_name`,`description`) VALUES (0,'VIP会员','vip');
INSERT INTO `role_info` (`role_status`,`role_name`,`description`) VALUES (1,'测试','test');
INSERT INTO `role_info` (`role_status`,`role_name`,`description`) VALUES (0,'发货员','personal');

#插入用户_角色关联表
INSERT INTO `user_role` (`role_id`,`uid`) VALUES (1,1);
INSERT INTO `user_role` (`role_id`,`uid`) VALUES (2,2);
INSERT INTO `user_role` (`role_id`,`uid`) VALUES (3,2);
INSERT INTO `user_role` (`role_id`,`uid`) VALUES (4,1);

#插入权限表
INSERT INTO `permission` (`perm_status`,`permission_name`,`parent_id`,`perm`,`resource_type`,`url`) VALUES (0,'用户管理',0,'userInfo:view','menu','userInfo/view');
INSERT INTO `permission` (`perm_status`,`permission_name`,`parent_id`,`perm`,`resource_type`,`url`) VALUES (0,'用户添加',1,'userInfo:add','button','userInfo/add');
INSERT INTO `permission` (`perm_status`,`permission_name`,`parent_id`,`perm`,`resource_type`,`url`) VALUES (0,'用户删除',1,'userInfo:del','button','userInfo/del');

#插入角色_权限表
INSERT INTO `role_permission` (`permission_id`,`role_id`) VALUES (1,1);
INSERT INTO `role_permission` (`permission_id`,`role_id`) VALUES (2,1);
INSERT INTO `role_permission` (`permission_id`,`role_id`) VALUES (3,2);


============================================
```text
参考文档：
https://www.jianshu.com/p/63792e787333

vue get和post接口请求的使用和操作：

https://blog.csdn.net/qq_40604313/article/details/103241079?spm=1001.2101.3001.6650.1&utm_medium=distribute.pc_relevant.none-task-blog-2%7Edefault%7ECTRLIST%7Edefault-1.opensearchhbase&depth_1-utm_source=distribute.pc_relevant.none-task-blog-2%7Edefault%7ECTRLIST%7Edefault-1.opensearchhbase


https://blog.csdn.net/Mybabyying/article/details/103234318
https://www.cnblogs.com/tyheng/p/13124978.html
重要的：https://blog.csdn.net/Ian_IMIL/article/details/118579418
https://www.cnblogs.com/tyheng/p/13124978.html
https://blog.csdn.net/Mybabyying/article/details/103234318

关于：ResponseEntity
https://geek-docs.com/spring-boot/spring-boot-tutorials/responseentity.html

```
安装axio、qs、element-ui：
cnpm install qs


linux 压缩文件夹排除指定文件夹：https://blog.csdn.net/catoop/article/details/40651947
eg： tar -zcvf tomcat.tar.gz --exclude=tomcat/logs --exclude=tomcat/libs tomcat





```text
window 转移 ubuntu：
记得vue ==？ npm install
2021.12.28 ==？ 注册中心添加数据
```

gradle 多模块学习例子：https://zhuanlan.zhihu.com/p/354119928





element-ui： [动态加载router，用Vue+Element UI搭建后台管理系统界面 - 云+社区 - 腾讯云 (tencent.com)](https://cloud.tencent.com/developer/article/1522137)

https://blog.csdn.net/u010559460/article/details/105340123



[一步步使用SpringBoot结合Vue实现登录和用户管理功能 - 三分恶 - 博客园 (cnblogs.com)](https://www.cnblogs.com/three-fighter/p/14332288.html)


跨域问题：已拦截跨源请求：同源策略禁止读取位于 http://localhost:8001/api/login/ 的远程资源。（原因：CORS 头缺少 'Access-Control-Allow-Origin'
后端记得加上@CrossOrigin注解，切忌。不要家在controller的接口类，不然很多时候都是不幸的，直接加在ControllerImpl实现类


一个很不错的springbot项目集合：https://github.com/2010yhh/springBoot-demos
https://www.cnblogs.com/kuotian/p/13040682.html

shiro + jwt ： https://blog.csdn.net/qq_38366063/article/details/103993117
vue前端存储token：https://blog.csdn.net/kevinfan2011/article/details/95166073