标签：INSERT Vue Springboot Admin INTO ---------------------------- -- VALUES NULL

一、系统介绍

系统主要功能：系统实现了用户管理、权限管理、菜单管理。

二、功能展示

1.用户登陆

在这里插入图片描述

2.用户管理

在这里插入图片描述

3.权限管理、权限设置

在这里插入图片描述

4.菜单管理

在这里插入图片描述

三、数据库展示

/*
Navicat MySQL Data Transfer

Source Server         : localhost
Source Server Version : 80021
Source Host           : localhost:3306
Source Database       : visual

Target Server Type    : MYSQL
Target Server Version : 80021
File Encoding         : 65001

Date: 2021-12-22 16:52:37
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `menu`
-- ----------------------------
DROP TABLE IF EXISTS `menu`;
CREATE TABLE `menu` (
  `menuid` int NOT NULL AUTO_INCREMENT,
  `menuname` varchar(100) DEFAULT NULL,
  `menupid` varchar(60) DEFAULT NULL,
  `href` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`menuid`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of menu
-- ----------------------------
INSERT INTO `menu` VALUES ('1', '系统管理', '0', 'system');
INSERT INTO `menu` VALUES ('2', '用户管理', '1', 'user');
INSERT INTO `menu` VALUES ('3', '角色管理', '1', 'role');
INSERT INTO `menu` VALUES ('4', '菜单管理', '1', 'menu');
INSERT INTO `menu` VALUES ('16', '数据可以视化', '0', 'data');
INSERT INTO `menu` VALUES ('17', '数据分析模型1', '16', 'data1');
INSERT INTO `menu` VALUES ('18', ' 数据分析模型2', '16', 'data2');
INSERT INTO `menu` VALUES ('19', '大屏可视化', '0', 'screen');
INSERT INTO `menu` VALUES ('20', '数据模型1', '19', 'screen1');

-- ----------------------------
-- Table structure for `role`
-- ----------------------------
DROP TABLE IF EXISTS `role`;
CREATE TABLE `role` (
  `roleid` int NOT NULL AUTO_INCREMENT,
  `rolename` varchar(50) NOT NULL,
  `roledesc` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  PRIMARY KEY (`roleid`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of role
-- ----------------------------
INSERT INTO `role` VALUES ('1', '管理员', '管理员');
INSERT INTO `role` VALUES ('2', '普通用户', '普通用户');

-- ----------------------------
-- Table structure for `rolemenu`
-- ----------------------------
DROP TABLE IF EXISTS `rolemenu`;
CREATE TABLE `rolemenu` (
  `id` int NOT NULL AUTO_INCREMENT,
  `menuid` varchar(50) DEFAULT NULL,
  `roleid` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of rolemenu
-- ----------------------------
INSERT INTO `rolemenu` VALUES ('7', '1', '1');
INSERT INTO `rolemenu` VALUES ('8', '2', '1');
INSERT INTO `rolemenu` VALUES ('9', '3', '1');
INSERT INTO `rolemenu` VALUES ('10', '4', '1');

-- ----------------------------
-- Table structure for `roleuser`
-- ----------------------------
DROP TABLE IF EXISTS `roleuser`;
CREATE TABLE `roleuser` (
  `id` int NOT NULL AUTO_INCREMENT,
  `userid` varchar(50) NOT NULL,
  `roleid` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of roleuser
-- ----------------------------
INSERT INTO `roleuser` VALUES ('1', '1', '1');
INSERT INTO `roleuser` VALUES ('3', '2', '2');
INSERT INTO `roleuser` VALUES ('4', '3', '2');

-- ----------------------------
-- Table structure for `user`
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `userid` int NOT NULL AUTO_INCREMENT,
  `username` varchar(50) NOT NULL,
  `password` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `fullname` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`userid`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES ('1', 'admin', 'a665a45920422f9d417e4867efdc4fb8a04a1f3fff1fa07e998e86f7f7a27ae3', '管理员');
INSERT INTO `user` VALUES ('2', 'zs', 'a665a45920422f9d417e4867efdc4fb8a04a1f3fff1fa07e998e86f7f7a27ae3', '张三');
INSERT INTO `user` VALUES ('3', 'ls', 'a665a45920422f9d417e4867efdc4fb8a04a1f3fff1fa07e998e86f7f7a27ae3', '李四');