課程
/后端開發(fā)
/Java
/MyBatis-Plus + SpringBoot實(shí)現(xiàn)簡(jiǎn)單權(quán)限管理
MYSQL 導(dǎo)不進(jìn)去
2021-07-23
源自：MyBatis-Plus + SpringBoot實(shí)現(xiàn)簡(jiǎn)單權(quán)限管理 2-2
正在回答
你使用的是mysql8.0嗎，我使用的是mysql8.0？如果不行你參考留言的這位同學(xué)的語(yǔ)句試試。
低版本 用這個(gè)文件? 自動(dòng)創(chuàng)建用戶 用戶名project 密碼 project
CREATE DATABASE IF NOT EXISTS project;
use project;
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
CREATE USER 'project'@'%' IDENTIFIED BY 'project';
grant all privileges on project.* to 'project'@'%' identified by 'project';
flush privileges;
DROP TABLE IF EXISTS `account`;
CREATE TABLE `account`? (
? `account_id` bigint(0) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主鍵',
? `role_id` bigint(0) UNSIGNED NULL DEFAULT NULL COMMENT '角色id',
? `username` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用戶名',
? `password` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '密碼',
? `salt` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '加密鹽',
? `real_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '真實(shí)姓名',
? `sex` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '性別',
? `email` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '郵箱',
? `create_time` datetime(0) NULL DEFAULT NULL COMMENT '創(chuàng)建時(shí)間',
? `modified_time` datetime(0) NULL DEFAULT NULL COMMENT '修改時(shí)間',
? `create_account_id` bigint(0) UNSIGNED NULL DEFAULT NULL COMMENT '創(chuàng)建人',
? `modified_account_id` bigint(0) UNSIGNED NULL DEFAULT NULL COMMENT '修改人',
? `deleted` tinyint(0) UNSIGNED NULL DEFAULT 0 COMMENT '邏輯刪除標(biāo)識(shí)(0、否 1、是)',
? PRIMARY KEY (`account_id`) USING BTREE
) COMMENT = '賬號(hào)表';
INSERT INTO `account` VALUES (1, 1, 'mp', '17a1640916cfa8356adc4336a72ac75d', 'ecbe5fac60d1499595fbb98dfa854501', '程序牛人', '男', 'mp@126.com', '2020-11-10 13:46:32', '2020-11-15 17:09:28', NULL, 1, 0);
DROP TABLE IF EXISTS `customer`;
CREATE TABLE `customer`? (
? `customer_id` bigint(0) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主鍵',
? `age` tinyint(0) UNSIGNED NULL DEFAULT NULL COMMENT '年齡',
? `phone` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '手機(jī)號(hào)碼',
? `address` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '地址',
? PRIMARY KEY (`customer_id`) USING BTREE
) COMMENT = '客戶表';
DROP TABLE IF EXISTS `resource`;
CREATE TABLE `resource`? (
? `resource_id` bigint(0) UNSIGNED NOT NULL COMMENT '主鍵',
? `parent_id` bigint(0) UNSIGNED NULL DEFAULT NULL COMMENT '父id',
? `resource_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '資源名稱',
? `resource_type` tinyint(0) NULL DEFAULT NULL COMMENT '資源類型(0、目錄 1、菜單 2、按鈕)',
? `url` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '請(qǐng)求地址',
? `code` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '權(quán)限標(biāo)識(shí)碼',
? `sort` int(0) UNSIGNED NULL DEFAULT NULL COMMENT '排序',
? PRIMARY KEY (`resource_id`) USING BTREE
) COMMENT = '資源表';
INSERT INTO `resource` VALUES (1, NULL, '系統(tǒng)管理', 0, NULL, NULL, 1);
INSERT INTO `resource` VALUES (2, NULL, '客戶管理', 0, NULL, NULL, 2);
INSERT INTO `resource` VALUES (11, 1, '角色管理', 1, 'role/toList', NULL, 1);
INSERT INTO `resource` VALUES (12, 1, '賬號(hào)管理', 1, 'account/toList', NULL, 2);
INSERT INTO `resource` VALUES (21, 2, '客戶管理', 1, 'customer/toList', 'customer', 1);
DROP TABLE IF EXISTS `role`;
CREATE TABLE `role`? (
? `role_id` bigint(0) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主鍵',
? `role_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '角色名稱',
? `remark` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '備注',
? PRIMARY KEY (`role_id`) USING BTREE
) COMMENT = '角色表';
INSERT INTO `role` VALUES (1, '練習(xí)角色', '練習(xí)角色', NULL, NULL, NULL, NULL, 0);
DROP TABLE IF EXISTS `role_resource`;
CREATE TABLE `role_resource`? (
? `role_resource_id` bigint(0) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主鍵',
? `resource_id` bigint(0) UNSIGNED NULL DEFAULT NULL COMMENT '資源id',
? PRIMARY KEY (`role_resource_id`) USING BTREE
) COMMENT = '角色資源表';
INSERT INTO `role_resource` VALUES (1, 1, 1);
INSERT INTO `role_resource` VALUES (2, 1, 2);
INSERT INTO `role_resource` VALUES (3, 1, 11);
INSERT INTO `role_resource` VALUES (4, 1, 12);
INSERT INTO `role_resource` VALUES (5, 1, 21);
alter? table account add constraint FK_account_role_id foreign key (role_id) references `role`(role_id);
alter? table role_resource add constraint FK_role_resource_role_id foreign key (role_id) references `role`(role_id);
alter? table role_resource add constraint FK_role_rerce_resourc_idD2D9 foreign key (resource_id) references `resource`(resource_id);
SET FOREIGN_KEY_CHECKS = 1;
weixin_慕田峪5524995
qq_31畫_0
舉報(bào)
通過實(shí)戰(zhàn)項(xiàng)目掌握MyBatis-Plus應(yīng)用！
2 回答把依賴pom.xml粘貼進(jìn)去，<dependency>里面會(huì)標(biāo)紅
1 回答是我導(dǎo)錯(cuò)包了嗎？
2 回答R不推薦使用了，請(qǐng)問新版本和實(shí)際開發(fā)如何去做這部分
1 回答layui.table不渲染無數(shù)據(jù)
1 回答視頻看不了了8-5
Copyright ? 2025 imooc.com All Rights Reserved | 京ICP備12003892號(hào)-11 京公網(wǎng)安備11010802030151號(hào)
購(gòu)課補(bǔ)貼聯(lián)系客服咨詢優(yōu)惠詳情
慕課網(wǎng)APP您的移動(dòng)學(xué)習(xí)伙伴
掃描二維碼關(guān)注慕課網(wǎng)微信公眾號(hào)
2021-08-06
你使用的是mysql8.0嗎，我使用的是mysql8.0？如果不行你參考留言的這位同學(xué)的語(yǔ)句試試。
2021-07-23
低版本 用這個(gè)文件? 自動(dòng)創(chuàng)建用戶 用戶名project 密碼 project
CREATE DATABASE IF NOT EXISTS project;
use project;
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
CREATE USER 'project'@'%' IDENTIFIED BY 'project';
grant all privileges on project.* to 'project'@'%' identified by 'project';
flush privileges;
DROP TABLE IF EXISTS `account`;
CREATE TABLE `account`? (
? `account_id` bigint(0) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主鍵',
? `role_id` bigint(0) UNSIGNED NULL DEFAULT NULL COMMENT '角色id',
? `username` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用戶名',
? `password` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '密碼',
? `salt` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '加密鹽',
? `real_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '真實(shí)姓名',
? `sex` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '性別',
? `email` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '郵箱',
? `create_time` datetime(0) NULL DEFAULT NULL COMMENT '創(chuàng)建時(shí)間',
? `modified_time` datetime(0) NULL DEFAULT NULL COMMENT '修改時(shí)間',
? `create_account_id` bigint(0) UNSIGNED NULL DEFAULT NULL COMMENT '創(chuàng)建人',
? `modified_account_id` bigint(0) UNSIGNED NULL DEFAULT NULL COMMENT '修改人',
? `deleted` tinyint(0) UNSIGNED NULL DEFAULT 0 COMMENT '邏輯刪除標(biāo)識(shí)(0、否 1、是)',
? PRIMARY KEY (`account_id`) USING BTREE
) COMMENT = '賬號(hào)表';
INSERT INTO `account` VALUES (1, 1, 'mp', '17a1640916cfa8356adc4336a72ac75d', 'ecbe5fac60d1499595fbb98dfa854501', '程序牛人', '男', 'mp@126.com', '2020-11-10 13:46:32', '2020-11-15 17:09:28', NULL, 1, 0);
DROP TABLE IF EXISTS `customer`;
CREATE TABLE `customer`? (
? `customer_id` bigint(0) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主鍵',
? `real_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '真實(shí)姓名',
? `sex` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '性別',
? `age` tinyint(0) UNSIGNED NULL DEFAULT NULL COMMENT '年齡',
? `email` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '郵箱',
? `phone` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '手機(jī)號(hào)碼',
? `address` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '地址',
? `create_time` datetime(0) NULL DEFAULT NULL COMMENT '創(chuàng)建時(shí)間',
? `modified_time` datetime(0) NULL DEFAULT NULL COMMENT '修改時(shí)間',
? `create_account_id` bigint(0) UNSIGNED NULL DEFAULT NULL COMMENT '創(chuàng)建人',
? `modified_account_id` bigint(0) UNSIGNED NULL DEFAULT NULL COMMENT '修改人',
? `deleted` tinyint(0) UNSIGNED NULL DEFAULT 0 COMMENT '邏輯刪除標(biāo)識(shí)(0、否 1、是)',
? PRIMARY KEY (`customer_id`) USING BTREE
) COMMENT = '客戶表';
DROP TABLE IF EXISTS `resource`;
CREATE TABLE `resource`? (
? `resource_id` bigint(0) UNSIGNED NOT NULL COMMENT '主鍵',
? `parent_id` bigint(0) UNSIGNED NULL DEFAULT NULL COMMENT '父id',
? `resource_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '資源名稱',
? `resource_type` tinyint(0) NULL DEFAULT NULL COMMENT '資源類型(0、目錄 1、菜單 2、按鈕)',
? `url` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '請(qǐng)求地址',
? `code` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '權(quán)限標(biāo)識(shí)碼',
? `sort` int(0) UNSIGNED NULL DEFAULT NULL COMMENT '排序',
? PRIMARY KEY (`resource_id`) USING BTREE
) COMMENT = '資源表';
INSERT INTO `resource` VALUES (1, NULL, '系統(tǒng)管理', 0, NULL, NULL, 1);
INSERT INTO `resource` VALUES (2, NULL, '客戶管理', 0, NULL, NULL, 2);
INSERT INTO `resource` VALUES (11, 1, '角色管理', 1, 'role/toList', NULL, 1);
INSERT INTO `resource` VALUES (12, 1, '賬號(hào)管理', 1, 'account/toList', NULL, 2);
INSERT INTO `resource` VALUES (21, 2, '客戶管理', 1, 'customer/toList', 'customer', 1);
DROP TABLE IF EXISTS `role`;
CREATE TABLE `role`? (
? `role_id` bigint(0) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主鍵',
? `role_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '角色名稱',
? `remark` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '備注',
? `create_time` datetime(0) NULL DEFAULT NULL COMMENT '創(chuàng)建時(shí)間',
? `modified_time` datetime(0) NULL DEFAULT NULL COMMENT '修改時(shí)間',
? `create_account_id` bigint(0) UNSIGNED NULL DEFAULT NULL COMMENT '創(chuàng)建人',
? `modified_account_id` bigint(0) UNSIGNED NULL DEFAULT NULL COMMENT '修改人',
? `deleted` tinyint(0) UNSIGNED NULL DEFAULT 0 COMMENT '邏輯刪除標(biāo)識(shí)(0、否 1、是)',
? PRIMARY KEY (`role_id`) USING BTREE
) COMMENT = '角色表';
INSERT INTO `role` VALUES (1, '練習(xí)角色', '練習(xí)角色', NULL, NULL, NULL, NULL, 0);
DROP TABLE IF EXISTS `role_resource`;
CREATE TABLE `role_resource`? (
? `role_resource_id` bigint(0) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主鍵',
? `role_id` bigint(0) UNSIGNED NULL DEFAULT NULL COMMENT '角色id',
? `resource_id` bigint(0) UNSIGNED NULL DEFAULT NULL COMMENT '資源id',
? PRIMARY KEY (`role_resource_id`) USING BTREE
) COMMENT = '角色資源表';
INSERT INTO `role_resource` VALUES (1, 1, 1);
INSERT INTO `role_resource` VALUES (2, 1, 2);
INSERT INTO `role_resource` VALUES (3, 1, 11);
INSERT INTO `role_resource` VALUES (4, 1, 12);
INSERT INTO `role_resource` VALUES (5, 1, 21);
alter? table account add constraint FK_account_role_id foreign key (role_id) references `role`(role_id);
alter? table role_resource add constraint FK_role_resource_role_id foreign key (role_id) references `role`(role_id);
alter? table role_resource add constraint FK_role_rerce_resourc_idD2D9 foreign key (resource_id) references `resource`(resource_id);
SET FOREIGN_KEY_CHECKS = 1;