尚硅谷的通用权限管理系统笔记

陈慢慢啊哦哦哦
665 阅读55分钟

一、数据库搭建

项目主要分为三部分

  1. 用户
  2. 角色
  3. 菜单

他们具有多对多关系

1.用户与角色的关系

用户可以是多个角色

角色也可以是多个用户

多对多关系拥有中间表

2.角色和菜单的关系

一个角色可以操作多个菜单

一个菜单可以被多个角色操作

3. sql初始化

# Host: localhost  (Version 5.7.19-log)
# Date: 2022-06-13 10:04:40
# Generator: MySQL-Front 6.1  (Build 1.26)

CREATE DATABASE `guigu-auth` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
use `guigu-auth`;

#
# Structure for table "sys_dept"
#

CREATE TABLE `sys_dept` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL DEFAULT '' COMMENT '部门名称',
  `parent_id` bigint(20) DEFAULT '0' COMMENT '上级部门id',
  `tree_path` varchar(255) DEFAULT ',' COMMENT '树结构',
  `sort_value` int(11) DEFAULT '1' COMMENT '排序',
  `leader` varchar(20) DEFAULT NULL COMMENT '负责人',
  `phone` varchar(11) DEFAULT NULL COMMENT '电话',
  `status` tinyint(1) DEFAULT '1' COMMENT '状态（1正常 0停用）',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  `is_deleted` tinyint(3) NOT NULL DEFAULT '0' COMMENT '删除标记（0:可用 1:已删除）',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2018 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='组织机构';

#
# Data for table "sys_dept"
#

INSERT INTO `sys_dept` VALUES (1,'硅谷集团有限公司',0,',1,',1,'张老师','15659090912',1,'2022-05-24 16:13:13','2022-05-24 16:13:13',0),(10,'北京校区',1,',1,10,',1,'李老师','18790007789',1,'2022-05-24 16:13:15','2022-05-24 16:13:15',0),(20,'上海校区',1,',1,20,',1,'王老师','15090987678',1,'2022-05-25 14:02:25','2022-05-25 14:02:25',0),(30,'深圳校区',1,',1,30,',1,'李老师','15090987678',1,'2022-05-25 14:02:24','2022-05-25 14:02:24',0),(1010,'教学部分',10,',1,10,1010,',1,'李老师','15090987678',1,'2022-05-25 14:02:24','2022-05-25 14:02:24',0),(1020,'运营部门',10,',1,10,1020,',1,'王老师','15090987678',1,'2022-05-25 14:02:29','2022-05-25 14:02:29',0),(1021,'Java学科',1010,',1,10,1010,1021,',1,'王老师','15090987678',1,'2022-05-24 16:13:31','2022-05-24 16:13:31',0),(1022,'大数据学科',1010,',1,10,1010,1022,',1,'王老师','15090987678',1,'2022-05-25 14:02:22','2022-05-25 14:02:22',0),(1024,'前端学科',1010,',1,10,1010,1024,',1,'李老师','15090987678',1,'2022-05-25 14:02:22','2022-05-25 14:02:22',0),(1025,'客服',1020,',1,10,1020,1025,',1,'李老师','15090987678',1,'2022-05-25 14:02:23','2022-05-25 14:02:23',0),(1026,'网站推广',1020,',1,10,1020,1026,',1,'30.607366','15090987678',1,'2022-05-25 14:02:26','2022-05-25 14:02:26',0),(1027,'线下运营',1020,',1,10,1020,1027,',1,'李老师','15090987678',1,'2022-05-25 14:02:26','2022-05-25 14:02:26',0),(1028,'设计',1020,',1,10,1020,1028,',1,'李老师','15090987678',1,'2022-05-25 14:02:27','2022-05-25 14:02:27',0),(2012,'教学部门',20,',1,20,2012,',1,'王老师','18909890765',1,'2022-05-24 16:13:51','2022-05-24 16:13:51',0),(2013,'教学部门',30,',1,30,2013,',1,'李老师','18567867895',1,'2022-05-24 16:13:50','2022-05-24 16:13:50',0),(2016,'Java学科',2012,',1,20,2012,2012,',1,'张老师','15090909909',1,'2022-05-25 10:51:12','2022-05-25 10:51:12',0),(2017,'大数据学科',2012,',1,20,2012,2012,',1,'李老师','15090980989',1,'2022-05-27 09:11:54',NULL,0);

#
# Structure for table "sys_login_log"
#

CREATE TABLE `sys_login_log` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '访问ID',
  `username` varchar(50) DEFAULT '' COMMENT '用户账号',
  `ipaddr` varchar(128) DEFAULT '' COMMENT '登录IP地址',
  `status` tinyint(1) DEFAULT '0' COMMENT '登录状态（0成功 1失败）',
  `msg` varchar(255) DEFAULT '' COMMENT '提示信息',
  `access_time` datetime DEFAULT NULL COMMENT '访问时间',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  `is_deleted` tinyint(3) NOT NULL DEFAULT '0' COMMENT '删除标记（0:可用 1:已删除）',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='系统访问记录';

#
# Data for table "sys_login_log"
#

INSERT INTO `sys_login_log` VALUES (1,'admin','0:0:0:0:0:0:0:1',1,'登录成功',NULL,'2022-06-10 11:24:14',NULL,0),(2,'admin','127.0.0.1',1,'登录成功',NULL,'2022-06-10 11:53:43',NULL,0);

#
# Structure for table "sys_menu"
#

CREATE TABLE `sys_menu` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
  `parent_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '所属上级',
  `name` varchar(20) NOT NULL DEFAULT '' COMMENT '名称',
  `type` tinyint(3) NOT NULL DEFAULT '0' COMMENT '类型(0:目录,1:菜单,2:按钮)',
  `path` varchar(100) DEFAULT NULL COMMENT '路由地址',
  `component` varchar(100) DEFAULT NULL COMMENT '组件路径',
  `perms` varchar(100) DEFAULT NULL COMMENT '权限标识',
  `icon` varchar(100) DEFAULT NULL COMMENT '图标',
  `sort_value` int(11) DEFAULT NULL COMMENT '排序',
  `status` tinyint(4) DEFAULT NULL COMMENT '状态(0:禁止,1:正常)',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `is_deleted` tinyint(3) NOT NULL DEFAULT '0' COMMENT '删除标记（0:可用 1:已删除）',
  PRIMARY KEY (`id`),
  KEY `idx_parent_id` (`parent_id`)
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8mb4 COMMENT='菜单表';


#
# Data for table "sys_menu"
#

INSERT INTO `sys_menu` (`id`,`parent_id`,`name`,`type`,`path`,`component`,`perms`,`icon`,`sort_value`,`status`,`create_time`,`update_time`,`is_deleted`) VALUES (2,0,'系统管理',0,'system','Layout',NULL,'el-icon-s-tools',1,1,'2021-05-31 18:05:37','2022-06-09 09:23:24',0),(3,2,'用户管理',1,'sysUser','system/sysUser/list','','el-icon-s-custom',1,1,'2021-05-31 18:05:37','2022-06-09 09:22:47',0),(4,2,'角色管理',1,'sysRole','system/sysRole/list','','el-icon-user-solid',2,1,'2021-05-31 18:05:37','2022-06-09 09:37:18',0),(5,2,'菜单管理',1,'sysMenu','system/sysMenu/list','','el-icon-s-unfold',3,1,'2021-05-31 18:05:37','2022-06-09 09:37:21',0),(6,3,'查看',2,NULL,NULL,'bnt.sysUser.list',NULL,1,1,'2021-05-31 18:05:37','2022-06-09 09:22:38',0),(7,3,'添加',2,NULL,NULL,'bnt.sysUser.add',NULL,1,1,'2021-05-31 18:05:37','2022-06-09 09:22:38',0),(8,3,'修改',2,NULL,NULL,'bnt.sysUser.update',NULL,1,1,'2021-05-31 18:05:37','2022-06-09 09:22:38',0),(9,3,'删除',2,NULL,NULL,'bnt.sysUser.remove',NULL,1,1,'2021-05-31 18:05:37','2022-06-09 09:22:38',0),(10,4,'查看',2,NULL,NULL,'bnt.sysRole.list',NULL,1,1,'2021-05-31 18:05:37','2022-06-09 09:22:38',0),(11,4,'添加',2,NULL,NULL,'bnt.sysRole.add',NULL,1,1,'2021-05-31 18:05:37','2022-06-09 09:22:38',0),(12,4,'修改',2,NULL,NULL,'bnt.sysRole.update',NULL,1,1,'2021-05-31 18:05:37','2022-06-09 09:22:38',0),(13,4,'删除',2,NULL,NULL,'bnt.sysRole.remove',NULL,1,1,'2021-05-31 18:05:37','2022-06-09 09:22:38',0),(14,5,'查看',2,NULL,NULL,'bnt.sysMenu.list',NULL,1,1,'2021-05-31 18:05:37','2022-06-09 09:22:38',0),(15,5,'添加',2,NULL,NULL,'bnt.sysMenu.add',NULL,1,1,'2021-05-31 18:05:37','2022-06-09 09:22:38',0),(16,5,'修改',2,NULL,NULL,'bnt.sysMenu.update',NULL,1,1,'2021-05-31 18:05:37','2022-06-09 09:22:38',0),(17,5,'删除',2,NULL,NULL,'bnt.sysMenu.remove',NULL,1,1,'2021-05-31 18:05:37','2022-06-09 09:22:38',0),(18,3,'分配角色',2,NULL,NULL,'bnt.sysUser.assignRole',NULL,1,1,'2022-05-23 17:14:32','2022-06-09 09:22:38',0),(19,4,'分配权限',2,'assignAuth','system/sysRole/assignAuth','bnt.sysRole.assignAuth',NULL,1,1,'2022-05-23 17:18:14','2022-06-09 09:22:38',0),(20,2,'部门管理',1,'sysDept','system/sysDept/list','','el-icon-s-operation',4,1,'2022-05-24 10:07:05','2022-06-09 09:38:12',0),(21,20,'查看',2,NULL,NULL,'bnt.sysDept.list',NULL,1,1,'2022-05-24 10:07:44','2022-06-09 09:22:38',0),(22,2,'岗位管理',1,'sysPost','system/sysPost/list','','el-icon-more-outline',5,1,'2022-05-24 10:25:30','2022-06-09 09:38:13',0),(23,22,'查看',2,NULL,NULL,'bnt.sysPost.list',NULL,1,1,'2022-05-24 10:25:45','2022-06-09 09:22:38',0),(24,20,'添加',2,NULL,NULL,'bnt.sysDept.add',NULL,1,1,'2022-05-25 15:31:27','2022-06-09 09:22:38',0),(25,20,'修改',2,NULL,NULL,'bnt.sysDept.update',NULL,1,1,'2022-05-25 15:31:41','2022-06-09 09:22:38',0),(26,20,'删除',2,NULL,NULL,'bnt.sysDept.remove',NULL,1,1,'2022-05-25 15:31:59','2022-06-09 09:22:38',0),(27,22,'添加',2,NULL,NULL,'bnt.sysPost.add',NULL,1,1,'2022-05-25 15:32:44','2022-06-09 09:22:38',0),(28,22,'修改',2,NULL,NULL,'bnt.sysPost.update',NULL,1,1,'2022-05-25 15:32:58','2022-06-09 09:22:38',0),(29,22,'删除',2,NULL,NULL,'bnt.sysPost.remove',NULL,1,1,'2022-05-25 15:33:11','2022-06-09 09:22:38',0),(30,34,'操作日志',1,'sysOperLog','system/sysOperLog/list','','el-icon-document-remove',7,1,'2022-05-26 16:09:59','2022-06-09 09:39:23',0),(31,30,'查看',2,NULL,NULL,'bnt.sysOperLog.list',NULL,1,1,'2022-05-26 16:10:17','2022-06-09 09:22:38',0),(32,34,'登录日志',1,'sysLoginLog','system/sysLoginLog/list','','el-icon-s-goods',8,1,'2022-05-26 16:36:13','2022-06-09 09:39:24',0),(33,32,'查看',2,NULL,NULL,'bnt.sysLoginLog.list',NULL,1,1,'2022-05-26 16:36:31','2022-06-09 09:36:36',0),(34,2,'日志管理',0,'log','ParentView','','el-icon-tickets',6,1,'2022-05-31 13:23:07','2022-06-09 09:39:22',0);

#
# Structure for table "sys_oper_log"
#

CREATE TABLE `sys_oper_log` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志主键',
  `title` varchar(50) DEFAULT '' COMMENT '模块标题',
  `business_type` varchar(20) DEFAULT '0' COMMENT '业务类型（0其它 1新增 2修改 3删除）',
  `method` varchar(100) DEFAULT '' COMMENT '方法名称',
  `request_method` varchar(10) DEFAULT '' COMMENT '请求方式',
  `operator_type` varchar(20) DEFAULT '0' COMMENT '操作类别（0其它 1后台用户 2手机端用户）',
  `oper_name` varchar(50) DEFAULT '' COMMENT '操作人员',
  `dept_name` varchar(50) DEFAULT '' COMMENT '部门名称',
  `oper_url` varchar(255) DEFAULT '' COMMENT '请求URL',
  `oper_ip` varchar(128) DEFAULT '' COMMENT '主机地址',
  `oper_param` varchar(2000) DEFAULT '' COMMENT '请求参数',
  `json_result` varchar(2000) DEFAULT '' COMMENT '返回参数',
  `status` int(1) DEFAULT '0' COMMENT '操作状态（0正常 1异常）',
  `error_msg` varchar(2000) DEFAULT '' COMMENT '错误消息',
  `oper_time` datetime DEFAULT NULL COMMENT '操作时间',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  `is_deleted` tinyint(3) NOT NULL DEFAULT '0' COMMENT '删除标记（0:可用 1:已删除）',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=64 DEFAULT CHARSET=utf8 COMMENT='操作日志记录';

#
# Data for table "sys_oper_log"
#

INSERT INTO `sys_oper_log` VALUES (1,'角色管理','1','com.atguigu.auth.controller.SysRoleController.save()','POST','1','admin','','/admin/auth/sysRole/save','','{"param":{},"roleCode":"","roleName":"test","id":5}','{"code":200,"message":"成功"}',0,'',NULL,'2022-05-26 15:59:44',NULL,0),(2,'角色管理','DELETE','com.atguigu.auth.controller.SysRoleController.remove()','DELETE','MANAGE','admin','','/admin/auth/sysRole/remove/5','','','{"code":200,"message":"成功"}',0,'',NULL,'2022-05-26 16:05:27',NULL,0),(3,'角色管理','DELETE','com.atguigu.auth.controller.SysRoleController.remove()','DELETE','MANAGE','admin','','/admin/auth/sysRole/remove/4','127.0.0.1','','{"code":200,"message":"成功"}',1,'',NULL,'2022-05-26 16:52:40',NULL,0),(4,'角色管理','UPDATE','com.atguigu.auth.controller.SysRoleController.updateById()','PUT','MANAGE','admin','','/admin/auth/sysRole/update','127.0.0.1','{"isDeleted":0,"createTime":1622507920000,"param":{},"roleCode":"","roleName":"普通管理员","description":"普通管理员","updateTime":1645670566000,"id":2}','{"code":200,"message":"成功"}',1,'',NULL,'2022-05-27 08:47:54',NULL,0),(5,'菜单管理','UPDATE','com.atguigu.auth.controller.SysMenuController.updateById()','PUT','MANAGE','admin','','/admin/auth/sysMenu/update','127.0.0.1','{"code":"SysRole","select":false,"level":3,"updateTime":1653287810000,"type":1,"parentId":2,"isDeleted":0,"children":[{"code":"btn.SysRole.list","select":false,"level":4,"updateTime":1622460772000,"type":2,"parentId":4,"isDeleted":0,"children":[],"createTime":1622455537000,"param":{},"name":"查看","id":10},{"code":"btn.SysRole.add","select":false,"level":4,"updateTime":1653547976000,"type":2,"parentId":4,"isDeleted":0,"children":[],"createTime":1622455537000,"param":{},"name":"添加","id":11},{"code":"btn.SysRole.update","select":false,"level":4,"updateTime":1653547981000,"type":2,"parentId":4,"isDeleted":0,"children":[],"createTime":1622455537000,"param":{},"name":"修改","id":12},{"code":"btn.SysRole.remove","select":false,"level":4,"updateTime":1622507874000,"type":2,"parentId":4,"isDeleted":0,"children":[],"createTime":1622455537000,"param":{},"name":"删除","id":13},{"code":"btn.SysRole.assignAuth","select":false,"level":4,"toCode":"AssignAuth","updateTime":1653376735000,"type":2,"parentId":4,"isDeleted":0,"children":[],"createTime":1653297494000,"param":{},"name":"分配权限","id":19}],"createTime":1622455537000,"param":{},"name":"角色管理","id":4}','{"code":200,"message":"成功"}',1,'',NULL,'2022-05-27 08:48:08',NULL,0),(6,'岗位管理','UPDATE','com.atguigu.auth.controller.SysPostController.updateById()','PUT','MANAGE','admin','','/admin/auth/sysPost/update','127.0.0.1','{"isDeleted":0,"createTime":1653359648000,"param":{},"name":"总经理","description":"2","postCode":"zjl","id":6,"status":1}','{"code":200,"message":"成功"}',1,'',NULL,'2022-05-27 08:56:29',NULL,0),(7,'岗位管理','INSERT','com.atguigu.auth.controller.SysPostController.save()','POST','MANAGE','admin','','/admin/auth/sysPost/save','127.0.0.1','{"param":{},"name":"网咨","description":"","postCode":"wz","id":7,"status":1}','{"code":200,"message":"成功"}',1,'',NULL,'2022-05-27 08:56:37',NULL,0),(8,'岗位管理','DELETE','com.atguigu.auth.controller.SysPostController.remove()','DELETE','MANAGE','admin','','/admin/auth/sysPost/remove/7','127.0.0.1','','{"code":200,"message":"成功"}',1,'',NULL,'2022-05-27 08:56:41',NULL,0),(9,'菜单管理','UPDATE','com.atguigu.auth.controller.SysMenuController.updateById()','PUT','MANAGE','admin','','/admin/auth/sysMenu/update','127.0.0.1','{"code":"btn.sysDept.list","select":false,"level":4,"toCode":"","updateTime":1653358064000,"type":2,"parentId":20,"isDeleted":0,"children":[],"createTime":1653358064000,"param":{},"name":"查看","id":21}','{"code":200,"message":"成功"}',1,'',NULL,'2022-05-27 09:02:49',NULL,0),(10,'菜单管理','UPDATE','com.atguigu.auth.controller.SysMenuController.updateById()','PUT','MANAGE','admin','','/admin/auth/sysMenu/update','127.0.0.1','{"code":"btn.sysDept.add","select":false,"level":4,"toCode":"","updateTime":1653463887000,"type":2,"parentId":20,"isDeleted":0,"children":[],"createTime":1653463887000,"param":{},"name":"添加","id":24}','{"code":200,"message":"成功"}',1,'',NULL,'2022-05-27 09:02:55',NULL,0),(11,'菜单管理','UPDATE','com.atguigu.auth.controller.SysMenuController.updateById()','PUT','MANAGE','admin','','/admin/auth/sysMenu/update','127.0.0.1','{"code":"btn.sysDept.update","select":false,"level":4,"toCode":"","updateTime":1653463901000,"type":2,"parentId":20,"isDeleted":0,"children":[],"createTime":1653463901000,"param":{},"name":"修改","id":25}','{"code":200,"message":"成功"}',1,'',NULL,'2022-05-27 09:03:01',NULL,0),(12,'菜单管理','UPDATE','com.atguigu.auth.controller.SysMenuController.updateById()','PUT','MANAGE','admin','','/admin/auth/sysMenu/update','127.0.0.1','{"code":"btn.sysDept.remove","select":false,"level":4,"toCode":"","updateTime":1653463919000,"type":2,"parentId":20,"isDeleted":0,"children":[],"createTime":1653463919000,"param":{},"name":"删除","id":26}','{"code":200,"message":"成功"}',1,'',NULL,'2022-05-27 09:03:07',NULL,0),(13,'部门管理','UPDATE','com.atguigu.auth.controller.SysDeptController.updateById()','PUT','MANAGE','admin','','/admin/auth/sysDept/update','127.0.0.1','{"leader":"张老师","updateTime":1653447072000,"parentId":2012,"sortValue":1,"isDeleted":0,"createTime":1653447072000,"param":{},"phone":"15090909909","name":"Java学科","id":2016,"treePath":",1,20,2012,2012,","status":1}','{"code":200,"message":"成功"}',1,'',NULL,'2022-05-27 09:11:28',NULL,0),(14,'部门管理','INSERT','com.atguigu.auth.controller.SysDeptController.save()','POST','MANAGE','admin','','/admin/auth/sysDept/save','127.0.0.1','{"leader":"李老师","parentId":2012,"param":{},"phone":"15090980989","name":"大数据学科","id":2017,"treePath":",1,20,2012,2012,"}','{"code":200,"message":"成功"}',1,'',NULL,'2022-05-27 09:11:54',NULL,0),(15,'部门管理','UPDATE','com.atguigu.auth.controller.SysDeptController.updateById()','PUT','MANAGE','admin','','/admin/auth/sysDept/update','127.0.0.1','{"leader":"李老师","parentId":2012,"sortValue":1,"isDeleted":0,"createTime":1653613914000,"param":{},"phone":"15090980989","name":"大数据学科","id":2017,"treePath":",1,20,2012,2012,","status":1}','{"code":200,"message":"成功"}',1,'',NULL,'2022-05-27 09:16:38',NULL,0),(16,'角色管理','UPDATE','com.atguigu.auth.controller.SysRoleController.updateById()','PUT','MANAGE','admin','','/admin/auth/sysRole/update','127.0.0.1','{"isDeleted":0,"createTime":1622507920000,"param":{},"roleCode":"COMMON","roleName":"普通管理员","description":"普通管理员","updateTime":1645670566000,"id":2}','{"code":200,"message":"成功"}',1,'',NULL,'2022-05-27 09:28:15',NULL,0),(17,'角色管理','INSERT','com.atguigu.auth.controller.SysRoleController.save()','POST','MANAGE','admin','','/admin/auth/sysRole/save','127.0.0.1','{"param":{},"roleCode":"","roleName":"用户管理员","id":6}','{"code":200,"message":"成功"}',1,'',NULL,'2022-05-27 10:42:18',NULL,0),(18,'角色管理','UPDATE','com.atguigu.auth.controller.SysRoleController.updateById()','PUT','MANAGE','admin','','/admin/auth/sysRole/update','127.0.0.1','{"isDeleted":0,"createTime":1653619337000,"param":{},"roleCode":"","roleName":"用户管理员","updateTime":1653619337000,"id":6}','{"code":200,"message":"成功"}',1,'',NULL,'2022-05-27 10:43:59',NULL,0),(19,'菜单管理','UPDATE','com.atguigu.auth.controller.SysMenuController.updateById()','PUT','MANAGE','admin','','/admin/auth/sysMenu/update','127.0.0.1','{"code":"sysUser","select":false,"level":3,"updateTime":1653957062000,"type":1,"parentId":2,"path":"sysUser/list","sortValue":1,"component":"auth/sysUser/list","isDeleted":0,"children":[{"code":"bnt.sysUser.list","select":false,"level":4,"updateTime":1653957062000,"type":2,"parentId":3,"isDeleted":0,"children":[],"createTime":1622455537000,"param":{},"name":"查看","id":6,"status":1},{"code":"bnt.sysUser.add","select":false,"level":4,"updateTime":1653957062000,"type":2,"parentId":3,"isDeleted":0,"children":[],"createTime":1622455537000,"param":{},"name":"添加","id":7,"status":1},{"code":"bnt.sysUser.update","select":false,"level":4,"updateTime":1653957062000,"type":2,"parentId":3,"isDeleted":0,"children":[],"createTime":1622455537000,"param":{},"name":"修改","id":8,"status":1},{"code":"bnt.sysUser.remove","select":false,"level":4,"updateTime":1653957062000,"type":2,"parentId":3,"isDeleted":0,"children":[],"createTime":1622455537000,"param":{},"name":"删除","id":9,"status":1},{"code":"bnt.sysUser.assignRole","select":false,"level":4,"toCode":"","updateTime":1653957062000,"type":2,"parentId":3,"isDeleted":0,"children":[],"createTime":1653297272000,"param":{},"name":"分配角色","id":18,"status":1}],"createTime":1622455537000,"param":{},"name":"用户管理","perms":"bnt.sysUser.list","id":3,"status":1}','{"code":200,"message":"成功"}',1,'',NULL,'2022-05-31 09:14:26',NULL,0),(20,'菜单管理','UPDATE','com.atguigu.auth.controller.SysMenuController.updateById()','PUT','MANAGE','admin','','/admin/auth/sysMenu/update','127.0.0.1','{"code":"sysRole","select":false,"level":3,"updateTime":1653957062000,"type":1,"parentId":2,"path":"sysRole/list","sortValue":0,"component":"auth/sysRole/list","isDeleted":0,"children":[{"code":"bnt.sysRole.list","select":false,"level":4,"updateTime":1653959708000,"type":2,"parentId":4,"isDeleted":0,"children":[],"createTime":1622455537000,"param":{},"name":"查看","perms":"bnt.sysRole.list","id":10,"status":1},{"code":"bnt.sysRole.add","select":false,"level":4,"updateTime":1653959708000,"type":2,"parentId":4,"isDeleted":0,"children":[],"createTime":1622455537000,"param":{},"name":"添加","perms":"bnt.sysRole.add","id":11,"status":1},{"code":"bnt.sysRole.update","select":false,"level":4,"updateTime":1653959708000,"type":2,"parentId":4,"isDeleted":0,"children":[],"createTime":1622455537000,"param":{},"name":"修改","perms":"bnt.sysRole.update","id":12,"status":1},{"code":"bnt.sysRole.remove","select":false,"level":4,"updateTime":1653959708000,"type":2,"parentId":4,"isDeleted":0,"children":[],"createTime":1622455537000,"param":{},"name":"删除","perms":"bnt.sysRole.remove","id":13,"status":1},{"code":"bnt.sysRole.assignAuth","select":false,"level":4,"toCode":"assignAuth","updateTime":1653959708000,"type":2,"parentId":4,"isDeleted":0,"children":[],"createTime":1653297494000,"param":{},"name":"分配权限","perms":"bnt.sysRole.assignAuth","id":19,"status":1}],"createTime":1622455537000,"param":{},"name":"角色管理","perms":" bnt.sysRole.list","id":4,"status":1}','{"code":200,"message":"成功"}',1,'',NULL,'2022-05-31 09:18:12',NULL,0),(21,'菜单管理','UPDATE','com.atguigu.auth.controller.SysMenuController.updateById()','PUT','MANAGE','admin','','/admin/auth/sysMenu/update','127.0.0.1','{"code":"sysMenu","select":false,"level":3,"updateTime":1653957062000,"type":1,"parentId":2,"path":"sysMenu/list","sortValue":0,"component":"auth/sysMenu/list","isDeleted":0,"children":[{"code":"bnt.sysMenu.list","select":false,"level":4,"updateTime":1653959708000,"type":2,"parentId":5,"isDeleted":0,"children":[],"createTime":1622455537000,"param":{},"name":"查看","perms":"bnt.sysMenu.list","id":14,"status":1},{"code":"bnt.sysMenu.add","select":false,"level":4,"updateTime":1653959708000,"type":2,"parentId":5,"isDeleted":0,"children":[],"createTime":1622455537000,"param":{},"name":"添加","perms":"bnt.sysMenu.add","id":15,"status":1},{"code":"bnt.sysMenu.update","select":false,"level":4,"updateTime":1653959708000,"type":2,"parentId":5,"isDeleted":0,"children":[],"createTime":1622455537000,"param":{},"name":"修改","perms":"bnt.sysMenu.update","id":16,"status":1},{"code":"bnt.sysMenu.remove","select":false,"level":4,"updateTime":1653959708000,"type":2,"parentId":5,"isDeleted":0,"children":[],"createTime":1622455537000,"param":{},"name":"删除","perms":"bnt.sysMenu.remove","id":17,"status":1}],"createTime":1622455537000,"param":{},"name":"菜单管理","perms":"bnt.sysMenu.list","id":5,"status":1}','{"code":200,"message":"成功"}',1,'',NULL,'2022-05-31 09:18:37',NULL,0),(22,'菜单管理','UPDATE','com.atguigu.auth.controller.SysMenuController.updateById()','PUT','MANAGE','admin','','/admin/auth/sysMenu/update','127.0.0.1','{"code":"sysDept","select":false,"level":3,"toCode":"","updateTime":1653957062000,"type":1,"parentId":2,"path":"sysDept/list","sortValue":0,"component":"auth/sysDept/list","isDeleted":0,"children":[{"code":"bnt.sysDept.list","select":false,"level":4,"toCode":"","updateTime":1653959708000,"type":2,"parentId":20,"isDeleted":0,"children":[],"createTime":1653358064000,"param":{},"name":"查看","perms":"bnt.sysDept.list","id":21,"status":1},{"code":"bnt.sysDept.add","select":false,"level":4,"toCode":"","updateTime":1653959708000,"type":2,"parentId":20,"isDeleted":0,"children":[],"createTime":1653463887000,"param":{},"name":"添加","perms":"bnt.sysDept.add","id":24,"status":1},{"code":"bnt.sysDept.update","select":false,"level":4,"toCode":"","updateTime":1653959708000,"type":2,"parentId":20,"isDeleted":0,"children":[],"createTime":1653463901000,"param":{},"name":"修改","perms":"bnt.sysDept.update","id":25,"status":1},{"code":"bnt.sysDept.remove","select":false,"level":4,"toCode":"","updateTime":1653959708000,"type":2,"parentId":20,"isDeleted":0,"children":[],"createTime":1653463919000,"param":{},"name":"删除","perms":"bnt.sysDept.remove","id":26,"status":1}],"createTime":1653358025000,"param":{},"name":"部门管理","perms":"bnt.sysDept.list","id":20,"status":1}','{"code":200,"message":"成功"}',1,'',NULL,'2022-05-31 09:19:04',NULL,0),(23,'菜单管理','UPDATE','com.atguigu.auth.controller.SysMenuController.updateById()','PUT','MANAGE','admin','','/admin/auth/sysMenu/update','127.0.0.1','{"code":"sysPost","select":false,"level":3,"toCode":"","updateTime":1653957062000,"type":1,"parentId":2,"path":"sysPost/list","sortValue":0,"component":"auth/sysPost/list","isDeleted":0,"children":[{"code":"bnt.sysPost.list","select":false,"level":4,"toCode":"","updateTime":1653959708000,"type":2,"parentId":22,"isDeleted":0,"children":[],"createTime":1653359145000,"param":{},"name":"查看","perms":"bnt.sysPost.list","id":23,"status":1},{"code":"bnt.sysPost.add","select":false,"level":4,"toCode":"","updateTime":1653959708000,"type":2,"parentId":22,"isDeleted":0,"children":[],"createTime":1653463964000,"param":{},"name":"添加","perms":"bnt.sysPost.add","id":27,"status":1},{"code":"bnt.sysPost.update","select":false,"level":4,"toCode":"","updateTime":1653959708000,"type":2,"parentId":22,"isDeleted":0,"children":[],"createTime":1653463978000,"param":{},"name":"修改","perms":"bnt.sysPost.update","id":28,"status":1},{"code":"bnt.sysPost.remove","select":false,"level":4,"toCode":"","updateTime":1653959708000,"type":2,"parentId":22,"isDeleted":0,"children":[],"createTime":1653463991000,"param":{},"name":"删除","perms":"bnt.sysPost.remove","id":29,"status":1}],"createTime":1653359130000,"param":{},"name":"岗位管理","perms":"bnt.sysPost.list","id":22,"status":1}','{"code":200,"message":"成功"}',1,'',NULL,'2022-05-31 09:19:23',NULL,0),(24,'菜单管理','UPDATE','com.atguigu.auth.controller.SysMenuController.updateById()','PUT','MANAGE','admin','','/admin/auth/sysMenu/update','127.0.0.1','{"code":"sysOperLog","select":false,"level":3,"toCode":"","updateTime":1653957062000,"type":1,"parentId":2,"path":"sysOperLog/list","sortValue":0,"component":"auth/sysOperLog/list","isDeleted":0,"children":[{"code":"bnt.sysOperLog.list","select":false,"level":4,"toCode":"","updateTime":1653959708000,"type":2,"parentId":30,"isDeleted":0,"children":[],"createTime":1653552617000,"param":{},"name":"查看","perms":"bnt.sysOperLog.list","id":31,"status":1}],"createTime":1653552599000,"param":{},"name":"操作日志","perms":"bnt.sysOperLog.list","id":30,"status":1}','{"code":200,"message":"成功"}',1,'',NULL,'2022-05-31 09:19:40',NULL,0),(25,'菜单管理','UPDATE','com.atguigu.auth.controller.SysMenuController.updateById()','PUT','MANAGE','admin','','/admin/auth/sysMenu/update','127.0.0.1','{"code":"sysLoginLog","select":false,"level":3,"toCode":"","updateTime":1653957062000,"type":1,"parentId":2,"path":"sysLoginLog/list","sortValue":0,"component":"auth/sysLoginLog/list","isDeleted":0,"children":[{"code":"bnt.sysLoginLog.list","select":false,"level":4,"toCode":"","updateTime":1653957062000,"type":1,"parentId":32,"isDeleted":0,"children":[],"createTime":1653554191000,"param":{},"name":"查看","id":33,"status":1}],"createTime":1653554173000,"param":{},"name":"登录日志","perms":" bnt.sysLoginLog.list","id":32,"status":1}','{"code":200,"message":"成功"}',1,'',NULL,'2022-05-31 09:20:09',NULL,0),(26,'菜单管理','UPDATE','com.atguigu.auth.controller.SysMenuController.updateById()','PUT','MANAGE','admin','','/admin/auth/sysMenu/update','127.0.0.1','{"code":"sysUser","select":false,"level":2,"updateTime":1653957062000,"type":1,"parentId":2,"path":"sysUser","sortValue":1,"component":"auth/sysUser/list","isDeleted":0,"children":[{"code":"bnt.sysUser.list","select":false,"level":3,"updateTime":1653959708000,"type":2,"parentId":3,"isDeleted":0,"children":[],"createTime":1622455537000,"param":{},"name":"查看","perms":"bnt.sysUser.list","id":6,"status":1},{"code":"bnt.sysUser.add","select":false,"level":3,"updateTime":1653959708000,"type":2,"parentId":3,"isDeleted":0,"children":[],"createTime":1622455537000,"param":{},"name":"添加","perms":"bnt.sysUser.add","id":7,"status":1},{"code":"bnt.sysUser.update","select":false,"level":3,"updateTime":1653959708000,"type":2,"parentId":3,"isDeleted":0,"children":[],"createTime":1622455537000,"param":{},"name":"修改","perms":"bnt.sysUser.update","id":8,"status":1},{"code":"bnt.sysUser.remove","select":false,"level":3,"updateTime":1653959708000,"type":2,"parentId":3,"isDeleted":0,"children":[],"createTime":1622455537000,"param":{},"name":"删除","perms":"bnt.sysUser.remove","id":9,"status":1},{"code":"bnt.sysUser.assignRole","select":false,"level":3,"toCode":"","updateTime":1653959708000,"type":2,"parentId":3,"isDeleted":0,"children":[],"createTime":1653297272000,"param":{},"name":"分配角色","perms":"bnt.sysUser.assignRole","id":18,"status":1}],"createTime":1622455537000,"param":{},"name":"用户管理","perms":"bnt.sysUser.list","id":3,"status":1}','{"code":200,"message":"成功"}',1,'',NULL,'2022-05-31 09:41:35',NULL,0),(27,'菜单管理','UPDATE','com.atguigu.auth.controller.SysMenuController.updateById()','PUT','MANAGE','admin','','/admin/auth/sysMenu/update','127.0.0.1','{"code":"sysRole","select":false,"level":2,"updateTime":1653957062000,"type":1,"parentId":2,"path":"sysRole","sortValue":0,"component":"auth/sysRole/list","isDeleted":0,"children":[{"code":"bnt.sysRole.list","select":false,"level":3,"updateTime":1653959708000,"type":2,"parentId":4,"isDeleted":0,"children":[],"createTime":1622455537000,"param":{},"name":"查看","perms":"bnt.sysRole.list","id":10,"status":1},{"code":"bnt.sysRole.add","select":false,"level":3,"updateTime":1653959708000,"type":2,"parentId":4,"isDeleted":0,"children":[],"createTime":1622455537000,"param":{},"name":"添加","perms":"bnt.sysRole.add","id":11,"status":1},{"code":"bnt.sysRole.update","select":false,"level":3,"updateTime":1653959708000,"type":2,"parentId":4,"isDeleted":0,"children":[],"createTime":1622455537000,"param":{},"name":"修改","perms":"bnt.sysRole.update","id":12,"status":1},{"code":"bnt.sysRole.remove","select":false,"level":3,"updateTime":1653959708000,"type":2,"parentId":4,"isDeleted":0,"children":[],"createTime":1622455537000,"param":{},"name":"删除","perms":"bnt.sysRole.remove","id":13,"status":1},{"code":"bnt.sysRole.assignAuth","select":false,"level":3,"toCode":"assignAuth","updateTime":1653959708000,"type":2,"parentId":4,"isDeleted":0,"children":[],"createTime":1653297494000,"param":{},"name":"分配权限","perms":"bnt.sysRole.assignAuth","id":19,"status":1}],"createTime":1622455537000,"param":{},"name":"角色管理","perms":" bnt.sysRole.list","id":4,"status":1}','{"code":200,"message":"成功"}',1,'',NULL,'2022-05-31 09:41:42',NULL,0),(28,'菜单管理','UPDATE','com.atguigu.auth.controller.SysMenuController.updateById()','PUT','MANAGE','admin','','/admin/auth/sysMenu/update','127.0.0.1','{"code":"sysMenu","select":false,"level":2,"updateTime":1653957062000,"type":1,"parentId":2,"path":"sysMenu","sortValue":0,"component":"auth/sysMenu/list","isDeleted":0,"children":[{"code":"bnt.sysMenu.list","select":false,"level":3,"updateTime":1653959708000,"type":2,"parentId":5,"isDeleted":0,"children":[],"createTime":1622455537000,"param":{},"name":"查看","perms":"bnt.sysMenu.list","id":14,"status":1},{"code":"bnt.sysMenu.add","select":false,"level":3,"updateTime":1653959708000,"type":2,"parentId":5,"isDeleted":0,"children":[],"createTime":1622455537000,"param":{},"name":"添加","perms":"bnt.sysMenu.add","id":15,"status":1},{"code":"bnt.sysMenu.update","select":false,"level":3,"updateTime":1653959708000,"type":2,"parentId":5,"isDeleted":0,"children":[],"createTime":1622455537000,"param":{},"name":"修改","perms":"bnt.sysMenu.update","id":16,"status":1},{"code":"bnt.sysMenu.remove","select":false,"level":3,"updateTime":1653959708000,"type":2,"parentId":5,"isDeleted":0,"children":[],"createTime":1622455537000,"param":{},"name":"删除","perms":"bnt.sysMenu.remove","id":17,"status":1}],"createTime":1622455537000,"param":{},"name":"菜单管理","perms":"bnt.sysMenu.list","id":5,"status":1}','{"code":200,"message":"成功"}',1,'',NULL,'2022-05-31 09:41:51',NULL,0),(29,'菜单管理','UPDATE','com.atguigu.auth.controller.SysMenuController.updateById()','PUT','MANAGE','admin','','/admin/auth/sysMenu/update','127.0.0.1','{"code":"sysDept","select":false,"level":2,"toCode":"","updateTime":1653957062000,"type":1,"parentId":2,"path":"sysDept","sortValue":0,"component":"auth/sysDept/list","isDeleted":0,"children":[{"code":"bnt.sysDept.list","select":false,"level":3,"toCode":"","updateTime":1653959708000,"type":2,"parentId":20,"isDeleted":0,"children":[],"createTime":1653358064000,"param":{},"name":"查看","perms":"bnt.sysDept.list","id":21,"status":1},{"code":"bnt.sysDept.add","select":false,"level":3,"toCode":"","updateTime":1653959708000,"type":2,"parentId":20,"isDeleted":0,"children":[],"createTime":1653463887000,"param":{},"name":"添加","perms":"bnt.sysDept.add","id":24,"status":1},{"code":"bnt.sysDept.update","select":false,"level":3,"toCode":"","updateTime":1653959708000,"type":2,"parentId":20,"isDeleted":0,"children":[],"createTime":1653463901000,"param":{},"name":"修改","perms":"bnt.sysDept.update","id":25,"status":1},{"code":"bnt.sysDept.remove","select":false,"level":3,"toCode":"","updateTime":1653959708000,"type":2,"parentId":20,"isDeleted":0,"children":[],"createTime":1653463919000,"param":{},"name":"删除","perms":"bnt.sysDept.remove","id":26,"status":1}],"createTime":1653358025000,"param":{},"name":"部门管理","perms":"bnt.sysDept.list","id":20,"status":1}','{"code":200,"message":"成功"}',1,'',NULL,'2022-05-31 09:41:58',NULL,0),(30,'菜单管理','UPDATE','com.atguigu.auth.controller.SysMenuController.updateById()','PUT','MANAGE','admin','','/admin/auth/sysMenu/update','127.0.0.1','{"code":"sysPost","select":false,"level":2,"toCode":"","updateTime":1653957062000,"type":1,"parentId":2,"path":"sysPost","sortValue":0,"component":"auth/sysPost/list","isDeleted":0,"children":[{"code":"bnt.sysPost.list","select":false,"level":3,"toCode":"","updateTime":1653959708000,"type":2,"parentId":22,"isDeleted":0,"children":[],"createTime":1653359145000,"param":{},"name":"查看","perms":"bnt.sysPost.list","id":23,"status":1},{"code":"bnt.sysPost.add","select":false,"level":3,"toCode":"","updateTime":1653959708000,"type":2,"parentId":22,"isDeleted":0,"children":[],"createTime":1653463964000,"param":{},"name":"添加","perms":"bnt.sysPost.add","id":27,"status":1},{"code":"bnt.sysPost.update","select":false,"level":3,"toCode":"","updateTime":1653959708000,"type":2,"parentId":22,"isDeleted":0,"children":[],"createTime":1653463978000,"param":{},"name":"修改","perms":"bnt.sysPost.update","id":28,"status":1},{"code":"bnt.sysPost.remove","select":false,"level":3,"toCode":"","updateTime":1653959708000,"type":2,"parentId":22,"isDeleted":0,"children":[],"createTime":1653463991000,"param":{},"name":"删除","perms":"bnt.sysPost.remove","id":29,"status":1}],"createTime":1653359130000,"param":{},"name":"岗位管理","perms":"bnt.sysPost.list","id":22,"status":1}','{"code":200,"message":"成功"}',1,'',NULL,'2022-05-31 09:42:04',NULL,0),(31,'菜单管理','UPDATE','com.atguigu.auth.controller.SysMenuController.updateById()','PUT','MANAGE','admin','','/admin/auth/sysMenu/update','127.0.0.1','{"code":"sysOperLog","select":false,"level":2,"toCode":"","updateTime":1653957062000,"type":1,"parentId":2,"path":"sysOperLog","sortValue":0,"component":"auth/sysOperLog/list","isDeleted":0,"children":[{"code":"bnt.sysOperLog.list","select":false,"level":3,"toCode":"","updateTime":1653959708000,"type":2,"parentId":30,"isDeleted":0,"children":[],"createTime":1653552617000,"param":{},"name":"查看","perms":"bnt.sysOperLog.list","id":31,"status":1}],"createTime":1653552599000,"param":{},"name":"操作日志","perms":"bnt.sysOperLog.list","id":30,"status":1}','{"code":200,"message":"成功"}',1,'',NULL,'2022-05-31 09:42:09',NULL,0),(32,'菜单管理','UPDATE','com.atguigu.auth.controller.SysMenuController.updateById()','PUT','MANAGE','admin','','/admin/auth/sysMenu/update','127.0.0.1','{"code":"sysLoginLog","select":false,"level":2,"toCode":"","updateTime":1653957062000,"type":1,"parentId":2,"path":"sysLoginLog","sortValue":0,"component":"auth/sysLoginLog/list","isDeleted":0,"children":[{"code":"bnt.sysLoginLog.list","select":false,"level":3,"toCode":"","updateTime":1653957062000,"type":1,"parentId":32,"isDeleted":0,"children":[],"createTime":1653554191000,"param":{},"name":"查看","id":33,"status":1}],"createTime":1653554173000,"param":{},"name":"登录日志","perms":" bnt.sysLoginLog.list","id":32,"status":1}','{"code":200,"message":"成功"}',1,'',NULL,'2022-05-31 09:42:15',NULL,0),(33,'菜单管理','INSERT','com.atguigu.system.controller.SysMenuController.save()','POST','MANAGE','admin','','/admin/system/sysMenu/save','127.0.0.1','{"select":false,"icon":"","type":0,"parentId":2,"path":"log","sortValue":1,"component":"","param":{},"name":"日志管理","perms":"","id":34,"status":1}','{"code":200,"message":"成功"}',1,'',NULL,'2022-05-31 13:23:07',NULL,0),(34,'菜单管理','INSERT','com.atguigu.system.controller.SysMenuController.save()','POST','MANAGE','admin','','/admin/system/sysMenu/save','127.0.0.1','{"select":false,"visible":1,"icon":"","type":0,"parentId":0,"path":"order","sortValue":1,"component":"Layout","param":{},"name":"订单管理","perms":"","id":35,"status":1}','{"code":200,"message":"成功"}',1,'',NULL,'2022-05-31 13:57:50',NULL,0),(35,'菜单管理','INSERT','com.atguigu.system.controller.SysMenuController.save()','POST','MANAGE','admin','','/admin/system/sysMenu/save','127.0.0.1','{"select":false,"visible":1,"icon":"","type":1,"parentId":35,"path":"orderInfo","sortValue":1,"component":"order/orderInfo/list","param":{},"name":"订单列表","perms":"bnt.orderInfo.list","id":36,"status":1}','{"code":200,"message":"成功"}',1,'',NULL,'2022-05-31 13:58:37',NULL,0),(36,'岗位管理','INSERT','com.atguigu.system.controller.SysPostController.save()','POST','MANAGE','admin','','/admin/system/sysPost/save','127.0.0.1','{"param":{},"name":"运营总监","description":"","postCode":"yyzj","id":8,"status":1}','{"code":200,"message":"成功"}',1,'',NULL,'2022-06-08 17:14:21',NULL,0),(37,'角色管理','INSERT','com.atguigu.system.controller.SysRoleController.save()','POST','MANAGE','admin','','/admin/system/sysRole/save','127.0.0.1','{"param":{},"roleCode":"","roleName":"","id":8}','{"code":200,"message":"成功"}',1,'',NULL,'2022-06-08 17:39:04',NULL,0),(38,'角色管理','UPDATE','com.atguigu.system.controller.SysRoleController.updateById()','PUT','MANAGE','admin','','/admin/system/sysRole/update','127.0.0.1','{"isDeleted":0,"createTime":1654681144000,"param":{},"roleCode":"","roleName":"","updateTime":1654681144000,"id":8}','{"code":200,"message":"成功"}',1,'',NULL,'2022-06-08 17:39:08',NULL,0),(39,'角色管理','UPDATE','com.atguigu.system.controller.SysRoleController.updateById()','PUT','MANAGE','admin','','/admin/system/sysRole/update','127.0.0.1','{"isDeleted":0,"createTime":1654681144000,"param":{},"roleCode":"","roleName":"","updateTime":1654681144000,"id":8}','{"code":200,"message":"成功"}',1,'',NULL,'2022-06-08 17:39:41',NULL,0),(40,'角色管理','UPDATE','com.atguigu.system.controller.SysRoleController.updateById()','PUT','MANAGE','admin','','/admin/system/sysRole/update','127.0.0.1','{"isDeleted":0,"createTime":1654681144000,"param":{},"roleCode":"yhgly","roleName":"用户管理员","updateTime":1654681144000,"id":8}','{"code":200,"message":"成功"}',1,'',NULL,'2022-06-08 17:42:46',NULL,0),(41,'菜单管理','INSERT','com.atguigu.system.controller.SysMenuController.save()','POST','MANAGE','admin','','/admin/system/sysMenu/save','127.0.0.1','{"select":false,"icon":"el-icon-phone","type":0,"parentId":0,"path":"order","sortValue":1,"component":"Layout","param":{},"name":"订单管理","perms":"","id":35,"status":1}','{"code":200,"message":"成功"}',1,'',NULL,'2022-06-09 08:50:13',NULL,0),(42,'菜单管理','UPDATE','com.atguigu.system.controller.SysMenuController.updateById()','PUT','MANAGE','admin','','/admin/system/sysMenu/update','127.0.0.1','{"select":false,"icon":"el-icon-phone","updateTime":1654735813000,"type":0,"parentId":0,"path":"order","sortValue":1,"component":"Layout","isDeleted":0,"children":[],"createTime":1654735813000,"param":{},"name":"订单管理","perms":"","id":35,"status":1}','{"code":200,"message":"成功"}',1,'',NULL,'2022-06-09 08:50:22',NULL,0),(43,'菜单管理','INSERT','com.atguigu.system.controller.SysMenuController.save()','POST','MANAGE','admin','','/admin/system/sysMenu/save','127.0.0.1','{"select":false,"icon":"el-icon-s-help","type":1,"parentId":35,"path":"orderInfo","sortValue":1,"component":"order/orderInfo/list","param":{},"name":"订单列表","perms":"bnt.orderInfo.list","id":36,"status":1}','{"code":200,"message":"成功"}',1,'',NULL,'2022-06-09 08:51:22',NULL,0),(44,'菜单管理','INSERT','com.atguigu.system.controller.SysMenuController.save()','POST','MANAGE','admin','','/admin/system/sysMenu/save','127.0.0.1','{"select":false,"icon":"","type":2,"parentId":36,"path":"","sortValue":1,"component":"","param":{},"name":"添加","perms":"bnt.add","id":37,"status":1}','{"code":200,"message":"成功"}',1,'',NULL,'2022-06-09 08:52:37',NULL,0),(45,'菜单管理','DELETE','com.atguigu.system.controller.SysMenuController.remove()','DELETE','MANAGE','admin','','/admin/system/sysMenu/remove/37','127.0.0.1','','{"code":200,"message":"成功"}',1,'',NULL,'2022-06-09 08:53:01',NULL,0),(46,'菜单管理','DELETE','com.atguigu.system.controller.SysMenuController.remove()','DELETE','MANAGE','admin','','/admin/system/sysMenu/remove/36','127.0.0.1','','{"code":200,"message":"成功"}',1,'',NULL,'2022-06-09 08:53:04',NULL,0),(47,'菜单管理','DELETE','com.atguigu.system.controller.SysMenuController.remove()','DELETE','MANAGE','admin','','/admin/system/sysMenu/remove/35','127.0.0.1','','{"code":200,"message":"成功"}',1,'',NULL,'2022-06-09 08:53:06',NULL,0),(48,'菜单管理','UPDATE','com.atguigu.system.controller.SysMenuController.updateById()','PUT','MANAGE','admin','','/admin/system/sysMenu/update','127.0.0.1','{"select":false,"icon":"el-icon-s-custom","updateTime":1654737767000,"type":1,"parentId":2,"path":"sysUser","sortValue":1,"component":"system/sysUser/list","isDeleted":0,"children":[{"select":false,"updateTime":1654737758000,"type":2,"parentId":3,"sortValue":1,"isDeleted":0,"children":[],"createTime":1622455537000,"param":{},"name":"查看","perms":"bnt.sysUser.list","id":6,"status":1},{"select":false,"updateTime":1654737758000,"type":2,"parentId":3,"sortValue":1,"isDeleted":0,"children":[],"createTime":1622455537000,"param":{},"name":"添加","perms":"bnt.sysUser.add","id":7,"status":1},{"select":false,"updateTime":1654737758000,"type":2,"parentId":3,"sortValue":1,"isDeleted":0,"children":[],"createTime":1622455537000,"param":{},"name":"修改","perms":"bnt.sysUser.update","id":8,"status":1},{"select":false,"updateTime":1654737758000,"type":2,"parentId":3,"sortValue":1,"isDeleted":0,"children":[],"createTime":1622455537000,"param":{},"name":"删除","perms":"bnt.sysUser.remove","id":9,"status":1},{"select":false,"updateTime":1654737758000,"type":2,"parentId":3,"sortValue":1,"isDeleted":0,"children":[],"createTime":1653297272000,"param":{},"name":"分配角色","perms":"bnt.sysUser.assignRole","id":18,"status":1}],"createTime":1622455537000,"param":{},"name":"用户管理","perms":"","id":3,"status":1}','{"code":200,"message":"成功"}',1,'',NULL,'2022-06-09 09:24:01',NULL,0),(49,'菜单管理','UPDATE','com.atguigu.system.controller.SysMenuController.updateById()','PUT','MANAGE','admin','','/admin/system/sysMenu/update','127.0.0.1','{"select":false,"icon":"el-icon-user-solid","updateTime":1654737768000,"type":1,"parentId":2,"path":"sysRole","sortValue":1,"component":"system/sysRole/list","isDeleted":0,"children":[{"select":false,"updateTime":1654737758000,"type":2,"parentId":4,"sortValue":1,"isDeleted":0,"children":[],"createTime":1622455537000,"param":{},"name":"查看","perms":"bnt.sysRole.list","id":10,"status":1},{"select":false,"updateTime":1654737758000,"type":2,"parentId":4,"sortValue":1,"isDeleted":0,"children":[],"createTime":1622455537000,"param":{},"name":"添加","perms":"bnt.sysRole.add","id":11,"status":1},{"select":false,"updateTime":1654737758000,"type":2,"parentId":4,"sortValue":1,"isDeleted":0,"children":[],"createTime":1622455537000,"param":{},"name":"修改","perms":"bnt.sysRole.update","id":12,"status":1},{"select":false,"updateTime":1654737758000,"type":2,"parentId":4,"sortValue":1,"isDeleted":0,"children":[],"createTime":1622455537000,"param":{},"name":"删除","perms":"bnt.sysRole.remove","id":13,"status":1},{"select":false,"updateTime":1654737758000,"type":2,"parentId":4,"path":"","sortValue":1,"component":"","isDeleted":0,"children":[],"createTime":1653297494000,"param":{},"name":"分配权限","perms":"bnt.sysRole.assignAuth","id":19,"status":1}],"createTime":1622455537000,"param":{},"name":"角色管理","perms":"","id":4,"status":1}','{"code":200,"message":"成功"}',1,'',NULL,'2022-06-09 09:24:10',NULL,0),(50,'菜单管理','UPDATE','com.atguigu.system.controller.SysMenuController.updateById()','PUT','MANAGE','admin','','/admin/system/sysMenu/update','127.0.0.1','{"select":false,"icon":"el-icon-s-unfold","updateTime":1654737769000,"type":1,"parentId":2,"path":"sysMenu","sortValue":1,"component":"system/sysMenu/list","isDeleted":0,"children":[{"select":false,"updateTime":1654737758000,"type":2,"parentId":5,"sortValue":1,"isDeleted":0,"children":[],"createTime":1622455537000,"param":{},"name":"查看","perms":"bnt.sysMenu.list","id":14,"status":1},{"select":false,"updateTime":1654737758000,"type":2,"parentId":5,"sortValue":1,"isDeleted":0,"children":[],"createTime":1622455537000,"param":{},"name":"添加","perms":"bnt.sysMenu.add","id":15,"status":1},{"select":false,"updateTime":1654737758000,"type":2,"parentId":5,"sortValue":1,"isDeleted":0,"children":[],"createTime":1622455537000,"param":{},"name":"修改","perms":"bnt.sysMenu.update","id":16,"status":1},{"select":false,"updateTime":1654737758000,"type":2,"parentId":5,"sortValue":1,"isDeleted":0,"children":[],"createTime":1622455537000,"param":{},"name":"删除","perms":"bnt.sysMenu.remove","id":17,"status":1}],"createTime":1622455537000,"param":{},"name":"菜单管理","perms":"","id":5,"status":1}','{"code":200,"message":"成功"}',1,'',NULL,'2022-06-09 09:24:21',NULL,0),(51,'菜单管理','UPDATE','com.atguigu.system.controller.SysMenuController.updateById()','PUT','MANAGE','admin','','/admin/system/sysMenu/update','127.0.0.1','{"select":false,"icon":"el-icon-s-operation","updateTime":1654737776000,"type":1,"parentId":2,"path":"sysDept","sortValue":1,"component":"system/sysDept/list","isDeleted":0,"children":[{"select":false,"updateTime":1654737758000,"type":2,"parentId":20,"sortValue":1,"isDeleted":0,"children":[],"createTime":1653358064000,"param":{},"name":"查看","perms":"bnt.sysDept.list","id":21,"status":1},{"select":false,"updateTime":1654737758000,"type":2,"parentId":20,"sortValue":1,"isDeleted":0,"children":[],"createTime":1653463887000,"param":{},"name":"添加","perms":"bnt.sysDept.add","id":24,"status":1},{"select":false,"updateTime":1654737758000,"type":2,"parentId":20,"sortValue":1,"isDeleted":0,"children":[],"createTime":1653463901000,"param":{},"name":"修改","perms":"bnt.sysDept.update","id":25,"status":1},{"select":false,"updateTime":1654737758000,"type":2,"parentId":20,"sortValue":1,"isDeleted":0,"children":[],"createTime":1653463919000,"param":{},"name":"删除","perms":"bnt.sysDept.remove","id":26,"status":1}],"createTime":1653358025000,"param":{},"name":"部门管理","perms":"","id":20,"status":1}','{"code":200,"message":"成功"}',1,'',NULL,'2022-06-09 09:24:28',NULL,0),(52,'菜单管理','UPDATE','com.atguigu.system.controller.SysMenuController.updateById()','PUT','MANAGE','admin','','/admin/system/sysMenu/update','127.0.0.1','{"select":false,"icon":"el-icon-more-outline","updateTime":1654737777000,"type":1,"parentId":2,"path":"sysPost","sortValue":1,"component":"system/sysPost/list","isDeleted":0,"children":[{"select":false,"updateTime":1654737758000,"type":2,"parentId":22,"sortValue":1,"isDeleted":0,"children":[],"createTime":1653359145000,"param":{},"name":"查看","perms":"bnt.sysPost.list","id":23,"status":1},{"select":false,"updateTime":1654737758000,"type":2,"parentId":22,"sortValue":1,"isDeleted":0,"children":[],"createTime":1653463964000,"param":{},"name":"添加","perms":"bnt.sysPost.add","id":27,"status":1},{"select":false,"updateTime":1654737758000,"type":2,"parentId":22,"sortValue":1,"isDeleted":0,"children":[],"createTime":1653463978000,"param":{},"name":"修改","perms":"bnt.sysPost.update","id":28,"status":1},{"select":false,"updateTime":1654737758000,"type":2,"parentId":22,"sortValue":1,"isDeleted":0,"children":[],"createTime":1653463991000,"param":{},"name":"删除","perms":"bnt.sysPost.remove","id":29,"status":1}],"createTime":1653359130000,"param":{},"name":"岗位管理","perms":"","id":22,"status":1}','{"code":200,"message":"成功"}',1,'',NULL,'2022-06-09 09:24:35',NULL,0),(53,'菜单管理','UPDATE','com.atguigu.system.controller.SysMenuController.updateById()','PUT','MANAGE','admin','','/admin/system/sysMenu/update','127.0.0.1','{"select":false,"icon":"el-icon-tickets","updateTime":1653974966000,"type":0,"parentId":2,"path":"log","sortValue":1,"component":"ParentView","isDeleted":0,"children":[{"select":false,"updateTime":1654737785000,"type":1,"parentId":34,"path":"sysOperLog","sortValue":1,"component":"system/sysOperLog/list","isDeleted":0,"children":[{"select":false,"updateTime":1654737758000,"type":2,"parentId":30,"sortValue":1,"isDeleted":0,"children":[],"createTime":1653552617000,"param":{},"name":"查看","perms":"bnt.sysOperLog.list","id":31,"status":1}],"createTime":1653552599000,"param":{},"name":"操作日志","perms":"","id":30,"status":1},{"select":false,"updateTime":1654737787000,"type":1,"parentId":34,"path":"sysLoginLog","sortValue":1,"component":"system/sysLoginLog/list","isDeleted":0,"children":[{"select":false,"updateTime":1654737758000,"type":2,"parentId":32,"sortValue":1,"isDeleted":0,"children":[],"createTime":1653554191000,"param":{},"name":"查看","id":33,"status":1}],"createTime":1653554173000,"param":{},"name":"登录日志","perms":"","id":32,"status":1}],"createTime":1653974587000,"param":{},"name":"日志管理","perms":"","id":34,"status":1}','{"code":200,"message":"成功"}',1,'',NULL,'2022-06-09 09:24:46',NULL,0),(54,'菜单管理','UPDATE','com.atguigu.system.controller.SysMenuController.updateById()','PUT','MANAGE','admin','','/admin/system/sysMenu/update','127.0.0.1','{"select":false,"icon":"el-icon-document-remove","updateTime":1654737785000,"type":1,"parentId":34,"path":"sysOperLog","sortValue":1,"component":"system/sysOperLog/list","isDeleted":0,"children":[{"select":false,"updateTime":1654737758000,"type":2,"parentId":30,"sortValue":1,"isDeleted":0,"children":[],"createTime":1653552617000,"param":{},"name":"查看","perms":"bnt.sysOperLog.list","id":31,"status":1}],"createTime":1653552599000,"param":{},"name":"操作日志","perms":"","id":30,"status":1}','{"code":200,"message":"成功"}',1,'',NULL,'2022-06-09 09:24:55',NULL,0),(55,'菜单管理','UPDATE','com.atguigu.system.controller.SysMenuController.updateById()','PUT','MANAGE','admin','','/admin/system/sysMenu/update','127.0.0.1','{"select":false,"icon":"el-icon-s-goods","updateTime":1654737787000,"type":1,"parentId":34,"path":"sysLoginLog","sortValue":1,"component":"system/sysLoginLog/list","isDeleted":0,"children":[{"select":false,"updateTime":1654737758000,"type":2,"parentId":32,"sortValue":1,"isDeleted":0,"children":[],"createTime":1653554191000,"param":{},"name":"查看","id":33,"status":1}],"createTime":1653554173000,"param":{},"name":"登录日志","perms":"","id":32,"status":1}','{"code":200,"message":"成功"}',1,'',NULL,'2022-06-09 09:25:07',NULL,0),(56,'用户管理','DELETE','com.atguigu.system.controller.SysUserController.remove()','DELETE','MANAGE','admin','','/admin/system/sysUser/remove/4','127.0.0.1','','{"code":200,"message":"成功"}',1,'',NULL,'2022-06-09 09:25:21',NULL,0),(57,'菜单管理','UPDATE','com.atguigu.system.controller.SysMenuController.updateById()','PUT','MANAGE','admin','','/admin/system/sysMenu/update','127.0.0.1','{"select":false,"updateTime":1654737758000,"type":2,"parentId":4,"path":"assignAuth","sortValue":1,"component":"system/sysRole/assignAuth","isDeleted":0,"children":[],"createTime":1653297494000,"param":{},"name":"分配权限","perms":"bnt.sysRole.assignAuth","id":19,"status":1}','{"code":200,"message":"成功"}',1,'',NULL,'2022-06-09 09:26:07',NULL,0),(58,'角色管理','ASSGIN','com.atguigu.system.controller.SysMenuController.doAssign()','POST','MANAGE','admin','','/admin/system/sysMenu/doAssign','127.0.0.1','{"roleId":2,"menuIdList":[2,3,6,7,8,5,14,20,21]}','{"code":200,"message":"成功"}',1,'',NULL,'2022-06-09 09:26:34',NULL,0),(59,'菜单管理','INSERT','com.atguigu.system.controller.SysMenuController.save()','POST','MANAGE','admin','','/admin/system/sysMenu/save','127.0.0.1','{"select":false,"icon":"el-icon-s-help","type":0,"parentId":0,"path":"vod","sortValue":1,"component":"Layout","param":{},"name":"点播管理","perms":"","id":35,"status":1}','{"code":200,"message":"成功"}',1,'',NULL,'2022-06-10 15:26:53',NULL,0),(60,'菜单管理','INSERT','com.atguigu.system.controller.SysMenuController.save()','POST','MANAGE','admin','','/admin/system/sysMenu/save','127.0.0.1','{"select":false,"icon":"el-icon-phone","type":1,"parentId":35,"path":"teacher/list","sortValue":1,"component":"vod/teacher/list","param":{},"name":"讲师列表","perms":"","id":36,"status":1}','{"code":200,"message":"成功"}',1,'',NULL,'2022-06-10 15:27:38',NULL,0),(61,'菜单管理','INSERT','com.atguigu.system.controller.SysMenuController.save()','POST','MANAGE','admin','','/admin/system/sysMenu/save','127.0.0.1','{"select":false,"icon":"","type":2,"parentId":36,"path":"teacher/create","sortValue":1,"component":"vod/teacher/form","param":{},"name":"添加","perms":"bnt.teacher.add","id":37,"status":1}','{"code":200,"message":"成功"}',1,'',NULL,'2022-06-10 15:28:27',NULL,0),(62,'菜单管理','INSERT','com.atguigu.system.controller.SysMenuController.save()','POST','MANAGE','admin','','/admin/system/sysMenu/save','127.0.0.1','{"select":false,"icon":"","type":2,"parentId":36,"path":"teacher/edit/:id","sortValue":1,"component":"vod/teacher/form","param":{},"name":"修改","perms":"bnt.teacher.update","id":38,"status":1}','{"code":200,"message":"成功"}',1,'',NULL,'2022-06-10 15:29:13',NULL,0),(63,'菜单管理','INSERT','com.atguigu.system.controller.SysMenuController.save()','POST','MANAGE','admin','','/admin/system/sysMenu/save','127.0.0.1','{"select":false,"icon":"","type":2,"parentId":36,"path":"","sortValue":1,"component":"","param":{},"name":"查看","perms":"bnt.teacher.list","id":39,"status":1}','{"code":200,"message":"成功"}',1,'',NULL,'2022-06-10 15:35:30',NULL,0);

#
# Structure for table "sys_post"
#

CREATE TABLE `sys_post` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '岗位ID',
`post_code` varchar(64) NOT NULL COMMENT '岗位编码',
`name` varchar(50) NOT NULL DEFAULT '' COMMENT '岗位名称',
`description` varchar(255) NOT NULL DEFAULT '' COMMENT '描述',
`status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态（1正常 0停用）',
`create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`update_time` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
`is_deleted` tinyint(3) NOT NULL DEFAULT '0' COMMENT '删除标记（0:可用 1:已删除）',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COMMENT='岗位信息表';

#
# Data for table "sys_post"
#

INSERT INTO `sys_post` VALUES (5,'dsz','董事长','1',1,'2022-05-24 10:33:53',NULL,0),(6,'zjl','总经理','2',1,'2022-05-24 10:34:08',NULL,0),(7,'wz','网咨','',1,'2022-05-27 08:56:41','2022-05-27 08:56:41',1),(8,'yyzj','运营总监','',1,'2022-06-08 17:14:21',NULL,0);

#
# Structure for table "sys_role"
#

CREATE TABLE `sys_role` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '角色id',
`role_name` varchar(20) NOT NULL DEFAULT '' COMMENT '角色名称',
`role_code` varchar(20) DEFAULT NULL COMMENT '角色编码',
`description` varchar(255) DEFAULT NULL COMMENT '描述',
`create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
`is_deleted` tinyint(3) NOT NULL DEFAULT '0' COMMENT '删除标记（0:可用 1:已删除）',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COMMENT='角色';

#
# Data for table "sys_role"
#

INSERT INTO `sys_role` VALUES (1,'系统管理员','SYSTEM','系统管理员','2021-05-31 18:09:18','2022-06-08 09:21:10',0),(2,'普通管理员','COMMON','普通管理员','2021-06-01 08:38:40','2022-02-24 10:42:46',0),(8,'用户管理员','yhgly',NULL,'2022-06-08 17:39:04','2022-06-08 17:39:04',0);

#
# Structure for table "sys_role_menu"
#

CREATE TABLE `sys_role_menu` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`role_id` bigint(20) NOT NULL DEFAULT '0',
`menu_id` bigint(11) NOT NULL DEFAULT '0',
`create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
`is_deleted` tinyint(3) NOT NULL DEFAULT '0' COMMENT '删除标记（0:可用 1:已删除）',
PRIMARY KEY (`id`),
KEY `idx_role_id` (`role_id`),
KEY `idx_menu_id` (`menu_id`)
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8 COMMENT='角色菜单';

#
# Data for table "sys_role_menu"
#

INSERT INTO `sys_role_menu` VALUES (1,2,2,'2022-06-02 16:11:27','2022-06-02 16:16:10',1),(2,2,3,'2022-06-02 16:11:27','2022-06-02 16:16:10',1),(3,2,6,'2022-06-02 16:11:27','2022-06-02 16:16:10',1),(4,2,7,'2022-06-02 16:11:27','2022-06-02 16:16:10',1),(5,2,8,'2022-06-02 16:11:27','2022-06-02 16:16:10',1),(6,2,9,'2022-06-02 16:11:27','2022-06-02 16:16:10',1),(7,2,18,'2022-06-02 16:11:27','2022-06-02 16:16:10',1),(8,2,4,'2022-06-02 16:11:27','2022-06-02 16:16:10',1),(9,2,10,'2022-06-02 16:11:27','2022-06-02 16:16:10',1),(10,2,11,'2022-06-02 16:11:27','2022-06-02 16:16:10',1),(11,2,12,'2022-06-02 16:11:27','2022-06-02 16:16:10',1),(12,2,13,'2022-06-02 16:11:27','2022-06-02 16:16:10',1),(13,2,19,'2022-06-02 16:11:27','2022-06-02 16:16:10',1),(14,2,5,'2022-06-02 16:11:27','2022-06-02 16:16:10',1),(15,2,14,'2022-06-02 16:11:27','2022-06-02 16:16:10',1),(16,2,15,'2022-06-02 16:11:27','2022-06-02 16:16:10',1),(17,2,16,'2022-06-02 16:11:27','2022-06-02 16:16:10',1),(18,2,17,'2022-06-02 16:11:27','2022-06-02 16:16:10',1),(19,2,2,'2022-06-02 16:16:10','2022-06-09 09:26:34',1),(20,2,3,'2022-06-02 16:16:10','2022-06-09 09:26:34',1),(21,2,6,'2022-06-02 16:16:10','2022-06-09 09:26:34',1),(22,2,7,'2022-06-02 16:16:10','2022-06-09 09:26:34',1),(23,2,8,'2022-06-02 16:16:10','2022-06-09 09:26:34',1),(24,2,2,'2022-06-09 09:26:34','2022-06-09 09:26:34',0),(25,2,3,'2022-06-09 09:26:34','2022-06-09 09:26:34',0),(26,2,6,'2022-06-09 09:26:34','2022-06-09 09:26:34',0),(27,2,7,'2022-06-09 09:26:34','2022-06-09 09:26:34',0),(28,2,8,'2022-06-09 09:26:34','2022-06-09 09:26:34',0),(29,2,5,'2022-06-09 09:26:34','2022-06-09 09:26:34',0),(30,2,14,'2022-06-09 09:26:34','2022-06-09 09:26:34',0),(31,2,20,'2022-06-09 09:26:34','2022-06-09 09:26:34',0),(32,2,21,'2022-06-09 09:26:34','2022-06-09 09:26:34',0);

#
# Structure for table "sys_user"
#

CREATE TABLE `sys_user` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '会员id',
`username` varchar(20) NOT NULL DEFAULT '' COMMENT '用户名',
`password` varchar(32) NOT NULL DEFAULT '' COMMENT '密码',
`name` varchar(50) DEFAULT NULL COMMENT '姓名',
`phone` varchar(11) DEFAULT NULL COMMENT '手机',
`head_url` varchar(200) DEFAULT NULL COMMENT '头像地址',
`dept_id` bigint(20) DEFAULT NULL COMMENT '部门id',
`post_id` bigint(20) DEFAULT NULL COMMENT '岗位id',
`description` varchar(255) DEFAULT NULL COMMENT '描述',
`status` tinyint(3) DEFAULT NULL COMMENT '状态（1：正常 0：停用）',
`create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
`is_deleted` tinyint(3) NOT NULL DEFAULT '0' COMMENT '删除标记（0:可用 1:已删除）',
PRIMARY KEY (`id`),
UNIQUE KEY `idx_username` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COMMENT='用户表';

#
# Data for table "sys_user"
#

INSERT INTO `sys_user` VALUES (1,'admin','96e79218965eb72c92a549dd5a330112','admin','15099909888','http://r61cnlsfq.hn-bkt.clouddn.com/7daa4595-dfde-45da-8513-c5c2b81d20cc',1021,5,NULL,1,'2021-05-31 18:08:43','2022-05-25 11:34:25',0),(2,'wangqq','96e79218965eb72c92a549dd5a330112','王倩倩','15010546381','http://r61cnlsfq.hn-bkt.clouddn.com/b09b3467-3d99-437a-bd2e-dd8c9be92bb8',1022,6,NULL,1,'2022-02-08 10:35:38','2022-05-25 15:58:31',0),(3,'wanggang','96e79218965eb72c92a549dd5a330112','王刚','18909098909',NULL,1024,5,NULL,0,'2022-05-24 11:05:40','2022-06-02 10:19:25',0);

#
# Structure for table "sys_user_role"
#

CREATE TABLE `sys_user_role` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键id',
`role_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '角色id',
`user_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '用户id',
`create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
`is_deleted` tinyint(3) NOT NULL DEFAULT '0' COMMENT '删除标记（0:可用 1:已删除）',
PRIMARY KEY (`id`),
KEY `idx_role_id` (`role_id`),
KEY `idx_admin_id` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COMMENT='用户角色';

#
# Data for table "sys_user_role"
#

INSERT INTO `sys_user_role` VALUES (2,2,2,'2022-01-20 20:49:37','2022-02-24 10:43:07',0),(3,1,1,'2022-05-19 10:37:27','2022-05-24 16:55:53',1),(4,2,1,'2022-05-19 10:37:27','2022-05-24 16:55:53',1),(5,1,1,'2022-05-24 16:55:53','2022-05-24 16:55:53',0),(6,2,3,'2022-05-25 16:09:31','2022-05-25 16:09:31',0),(7,2,4,'2022-06-02 11:08:14','2022-06-02 11:15:36',1),(8,2,4,'2022-06-02 11:15:36','2022-06-02 16:10:53',1),(9,1,4,'2022-06-02 11:15:36','2022-06-02 16:10:53',1),(10,1,4,'2022-06-02 16:10:53','2022-06-02 16:10:53',0);

二、工程搭建

搭建聚合工程，聚合工程项目结构：

项目各模块依赖:

1、man-auth-parent模块依赖

<?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.3.6.RELEASE</version>
    </parent>

    <groupId>cn.chenmanman</groupId>
    <artifactId>man-auth-parent</artifactId>
    <packaging>pom</packaging>
    <version>1.0-SNAPSHOT</version>

    <modules>
        <module>common</module>
        <module>model</module>
        <module>service-system</module>
    </modules>

    <properties>
        <java.version>1.8</java.version>
        <alibaba.version>2.2.0.RELEASE</alibaba.version>
        <mybatis-plus.version>3.4.1</mybatis-plus.version>
        <mysql.version>8.0.23</mysql.version>
        <knife4j.version>2.0.8</knife4j.version>
        <jwt.version>0.7.0</jwt.version>
        <fastjson.version>1.2.29</fastjson.version>
    </properties>



    <!--配置dependencyManagement锁定依赖的版本-->
    <dependencyManagement>
        <dependencies>
            <!--mybatis-plus 持久层-->
            <dependency>
                <groupId>com.baomidou</groupId>
                <artifactId>mybatis-plus-boot-starter</artifactId>
                <version>${mybatis-plus.version}</version>
            </dependency>
            <!--mysql-->
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
                <version>${mysql.version}</version>
            </dependency>
            <!--knife4j-->
            <dependency>
                <groupId>com.github.xiaoymin</groupId>
                <artifactId>knife4j-spring-boot-starter</artifactId>
                <version>${knife4j.version}</version>
            </dependency>
            <!--jjwt-->
            <dependency>
                <groupId>io.jsonwebtoken</groupId>
                <artifactId>jjwt</artifactId>
                <version>${jwt.version}</version>
            </dependency>
            <!--fastjson-->
            <dependency>
                <groupId>com.alibaba</groupId>
                <artifactId>fastjson</artifactId>
                <version>${fastjson.version}</version>
            </dependency>
        </dependencies>
    </dependencyManagement>

    <build>
        <plugins>
            <plugin>
                <groupId>org.apache.maven.plugins</groupId>
                <artifactId>maven-compiler-plugin</artifactId>
                <version>3.1</version>
                <configuration>
                    <source>1.8</source>
                    <target>1.8</target>
                </configuration>
            </plugin>
        </plugins>
    </build>

</project>

2、common模块依赖

<?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">
    <parent>
        <artifactId>man-auth-parent</artifactId>
        <groupId>cn.chenmanman</groupId>
        <version>1.0-SNAPSHOT</version>
    </parent>
    <modelVersion>4.0.0</modelVersion>

    <artifactId>common</artifactId>
    <packaging>pom</packaging>
    <modules>
        <module>common-log</module>
        <module>common-util</module>
        <module>service-util</module>
        <module>spring-security</module>
    </modules>


</project>

3、common-utils模块依赖

<?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">
    <parent>
        <artifactId>common</artifactId>
        <groupId>cn.chenmanman</groupId>
        <version>1.0-SNAPSHOT</version>
    </parent>
    <modelVersion>4.0.0</modelVersion>

    <artifactId>common-util</artifactId>

    <dependencies>
        <dependency>
            <groupId>cn.chenmanman</groupId>
            <artifactId>model</artifactId>
            <version>1.0-SNAPSHOT</version>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
            <scope>provided</scope>
        </dependency>
        <dependency>
            <groupId>io.jsonwebtoken</groupId>
            <artifactId>jjwt</artifactId>
        </dependency>
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
        </dependency>
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>fastjson</artifactId>
        </dependency>
    </dependencies>
</project>

4、service-utils模块依赖

<?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">
    <parent>
        <artifactId>common</artifactId>
        <groupId>cn.chenmanman</groupId>
        <version>1.0-SNAPSHOT</version>
    </parent>
    <modelVersion>4.0.0</modelVersion>

    <artifactId>service-util</artifactId>

    <dependencies>
        <dependency>
            <groupId>cn.chenmanman</groupId>
            <artifactId>common-util</artifactId>
            <version>1.0-SNAPSHOT</version>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-boot-starter</artifactId>
        </dependency>
        <!--mysql-->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
        </dependency>
    </dependencies>
</project>

5、service-system模块依赖

<?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">
    <parent>
        <artifactId>man-auth-parent</artifactId>
        <groupId>cn.chenmanman</groupId>
        <version>1.0-SNAPSHOT</version>
    </parent>
    <modelVersion>4.0.0</modelVersion>

    <artifactId>service-system</artifactId>

    <packaging>jar</packaging>

    <dependencies>
        <dependency>
            <groupId>cn.chenmanman</groupId>
            <artifactId>service-util</artifactId>
            <version>1.0-SNAPSHOT</version>
        </dependency>

        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
        </dependency>
    </dependencies>

    <build>
        <finalName>${project.artifactId}</finalName>
        <plugins>
            <plugin>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-maven-plugin</artifactId>
            </plugin>
        </plugins>
    </build>
</project>

三、MybatisPlus起步

1、MybatisPlus准备工作

在service-system模块中的resources中创建两个yml配置文件，分别是：application.yml和application-dev.yml

spring:
  application:
    name: service-system
  profiles:
    active: dev

mybatis-plus:
  configuration:
    log-impl: org.apache.ibatis.logging.stdout.StdOutImpl
spring:
  datasource:
    url: jdbc:mysql://localhost:3306/guigu-auth?useSSL=false&serverTimezone=UTC
    driver-class-name: com.mysql.cj.jdbc.Driver
    password: root
    username: huanyuan

先在main中java下创建包：cn.chenmanman.system

然后在system包下创建启动类ServiceAuthApplicaiton

@SpringBootApplication
@MapperScan("cn.chenmanman.system.mapper")
public class ServiceAuthApplication {
    public static void main(String[] args) {
        SpringApplication.run(ServiceAuthApplication.class, args);
    }
}

然后在model模块中创建实体类(从尚硅谷的资料压缩包中复制过去)

2、测试mapper 准备

在service-system模块中的cn.chenmanman.system包下创建mapper包用于存放我们对数据库表的操作类，然后在mapper包下创建SysRoleMapper接口，并且需要继承BaseMapper接口，BaseMapper是MybatisPlus封装的接口，我们的Mapper继承他便可以继承到他所提供的所有crud操作。

@Repository
public interface SysRoleMapper extends BaseMapper<SysRole> {
}

2、准备测试类

接下来在test下创建包cn.chenmanman，并在其包下创建测试类文件SysRoleMapperTest

测试类中代码：

@SpringBootTest
public class SysRoleMapperTest {

    @Autowired
    private SysRoleMapper sysRoleMapper;


    @Test
    public void testAdd(){

    }

}

⭐ 这里需要注意@Test注解要引入org.junit.jupiter.api.Test 这个是junit5的注解，而不应该引入import org.junit.Test的junit4的Test注解。

关于BaseMapper

BaseMapper所支持的方法

3、MybatisPlus的CRUD方法测试

1、测试查询方法

MybatisPlus的查询方法是:selectList方法

    public void testSelectAll(){
        List<SysRole> sysRoles = sysRoleMapper.selectList(null);
        sysRoles.forEach(System.out::println);
    }

结果:

2、测试添加方法

MyabtisPlus的添加方法是insert方法

    /**
     * 添加的测试
     * */
    @Test
    public void testAdd(){
        SysRole role = new SysRole();
        role.setRoleName("测试角色1");
        role.setRoleCode("testManager1");
        role.setDescription("测试角色1");
        int rows = sysRoleMapper.insert(role);
        System.out.println(rows);
    }

结果:

这里会发现插入的id值是一个非常长的值，这里我们需要更改Sys_Role的id的主键策略，因为MybatisPlus对于主键的默认主键策略是一个名为IdType.ASSIGN_ID的常量，他代表的是一个雪花算法的策略，就是在添加的时候主键id的值会填充一个19位的数。

因此我们需要将他的主键策略修改为一个名为IdType.AUTO的主键策略，这个主键策略代表的是自动增长的策略。

注意就是这里Sys_Role所继承的BaseEntity的id类型不一致，修改为Long即可，并修改主键策略。

修改如下图：

之后再次执行一个测试

你可能会发现它的id值和之前一样长，这是因为自动增长的问题根据原来的值自动增长罢了

主键的5种策略除去了弃用的

3、测试修改方法

    /**
     *
     * 修改方法的测试
     * */
    @Test
    public void update(){
        // 根据id查询到对应角色
        SysRole sysRole = sysRoleMapper.selectById(1);
        // 设置修改值
        sysRole.setDescription("慢慢系统管理员");
        // 调用方法实现更新
        sysRoleMapper.updateById(sysRole);
    }

然后进行测试

4、测试删除方法

1、单条删除

逻辑删除（@TableLogic）和物理删除

  • 逻辑删除：数据还存在于表中，但是这个数据查询不出来。(添加了个逻辑删除的标志位，约定0没有删除，1已经删除)当需要删除的时候将标志位修改为1
    • 好处是当需要恢复时直接修改标志位即可。
  • 物理删除：真正的将这个数据从数据表中删除

在MybatisPlus中逻辑删除提过了一个注解：@TableLogic

@TableLogic 默认是0 没有删，1代表删除，如果要修改这个值的对应关系

需要在配置文件中加入如下配置

    @Test
    public void delete(){
        sysRoleMapper.deleteById(1);
    }

结果:

它的语句是一个update操作因为是逻辑删除，所以只需要修改标志位即可

现在在做查询的时候就无法查询到此条角色了

2、删除多条

@Test
public void deleteBatch(){
    sysRoleMapper.deleteBatchIds(Arrays.asList(1,2,3));
}

结果：

这里因为3不存在就只删除了两条

5、条件构造器

	@Test
    public void selectRole(){
        QueryWrapper<SysRole> wrapper = new QueryWrapper<>();
        wrapper.eq("role_name", "普通管理员");
        sysRoleMapper.selectList(wrapper).forEach(System.out::println);
    }

结果：

    @Test
    public void selectRole(){
        QueryWrapper<SysRole> wrapper = new QueryWrapper<>();
        wrapper.like("role_name", "管理员");
        sysRoleMapper.selectList(wrapper).forEach(System.out::println);
    }

6、MybatisPlus对于service层的封装

MybatisPlus对于dao层与service层封装的crud功能的方法名不大一样，两层封装的crud方法的名字：

  • mapper层的增删改查方法
    • 在mapper层中添加操作的方法仅有 insert()方法
    • 删除方法: 删除方法以delete开头
    • 更新方法以update开头
    • 查询方法以select开头
  • service层的增删改查方法
    • service层中 添加操作的方法是以save开头
    • 更新操作依然是 update开头
    • 删除操作的是以remove开头
    • 查询操作因为可能查到是集合可能查的是单个实体又分为两个
      • get开头的是单个实体
      • list开头的是List集合

1、创建service层接口以及实现类

service层接口需要继承IService接口，它的泛型是实体类，IService接口封装了大多增删改查方法，许多是以default修饰的，所以是有默认方法体的，但是也可以自己对他的接口方法进行实现。

package cn.chenmanman.system.service;

import cn.chenmanman.model.system.SysRole;
import com.baomidou.mybatisplus.extension.service.IService;

public interface SysRoleService extends IService<SysRole> {
}

service层实现类在实现service层接口的前提下，还要继承ServiceImpl<M extends BaseMapper, T>类，这个类对IService接口进行了实现。

它在内部，注入了类型为M的的mapper，也就是我们的mapper接口。因此在继承它之后，我们之后就可以不用去自己手动注入mapper进来。

package cn.chenmanman.system.service.impl;

import cn.chenmanman.model.system.SysRole;
import cn.chenmanman.system.mapper.SysRoleMapper;
import cn.chenmanman.system.service.SysRoleService;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import org.springframework.stereotype.Service;


@Service
public class SysRoleServiceImpl extends ServiceImpl<SysRoleMapper, SysRole> implements SysRoleService {

}

2、对service层的封装进行测试

1、添加操作
    /**
     * 测试service层的save方法增添方法
     * */
    @Test
    public void save(){
        SysRole sysRole = new SysRole();
        sysRole.setRoleName("超级无敌管理员");
        sysRole.setRoleCode("superManager");
        sysRole.setDescription("此为超级无敌管理员拥有一切权限!");
        sysRoleService.save(sysRole);
    }

结果:

2、修改方法
    @Test
    public void updateService(){
        SysRole role = sysRoleService.getById(1585593162208907268L);
        role.setDescription("此为超级无敌管理员是拥有一切权限的!");
        sysRoleService.updateById(role);
    }

3、查询操作
    @Test
    public void query(){
        // 查询单条
        SysRole role = sysRoleService.getById(1585593162208907268L);
        System.out.println(role);
        System.out.println();
        System.out.println();
        // 查询多条
        QueryWrapper<SysRole> wrapper = new QueryWrapper<>();
        wrapper.like("role_name", "管理员");
        sysRoleService.list(wrapper).forEach(System.out::println);
    }

结果：

4、删除操作
    @Test
    public void remove(){
        System.out.println(sysRoleService.removeById(1585593162208907268L));
        System.out.println(sysRoleService.removeByIds(Arrays.asList(1, 2, 3)));
    }

结果：

这篇mybatisplus写的比较多，也加了写自己对mybatisplus的认识
唉今天学校还阳了真难受，我的比赛也G了没搞好。沉下心来好好学习了
avatar
文章
阅读
粉丝