如何实现不同用户登录显示不同的菜单模块的权限?
前提需要准备: 开发工具 java环境 tomcat服务器配置 maven的配置 还有Mysql数据库的安装 这些就不给大家一一去说怎么配置以及安装了都非常简单的.
那下面我就用Eclipse开发工具来去怎么实现这么一个根据不同用户显示不同菜单模块的权限
首先在Mysql数据库里面创建好表
menu表
/*
Navicat MySQL Data Transfer
Source Server : MySQL2
Source Server Version : 50720
Source Host : localhost:3306
Source Database : test
Target Server Type : MYSQL
Target Server Version : 50720
File Encoding : 65001
Date: 2019-07-26 16:01:35
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `menu`
-- ----------------------------
DROP TABLE IF EXISTS `menu`;
CREATE TABLE `menu` (
`mid` int(11) NOT NULL AUTO_INCREMENT,
`text` varchar(200) NOT NULL,
`iconCls` varchar(200) NOT NULL,
`mparent` int(11) NOT NULL DEFAULT '0',
`murl` varchar(200) DEFAULT NULL,
PRIMARY KEY (`mid`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of menu
-- ----------------------------
INSERT INTO `menu` VALUES ('1', '产品管理', 'icon-print', '0', null);
INSERT INTO `menu` VALUES ('3', '产品域管理', 'icon-tip', '1', '');
INSERT INTO `menu` VALUES ('4', '产品型谱', 'icon-tip', '1', '/ssmxm/tree.jsp');
INSERT INTO `menu` VALUES ('6', '文件查询', 'icon-tip', '7', '/ssmxm/papers.jsp');
INSERT INTO `menu` VALUES ('7', '文件管理', 'icon-print', '0', null);
INSERT INTO `menu` VALUES ('8', '零件管理', 'icon-print', '0', null);
INSERT INTO `menu` VALUES ('9', '编码管理', 'icon-print', '0', null);
INSERT INTO `menu` VALUES ('10', '流程管理', 'icon-print', '0', null);
INSERT INTO `menu` VALUES ('11', '零件查询', 'icon-tip', '8', null);
INSERT INTO `menu` VALUES ('12', 'BOM比较', 'icon-tip', '8', null);
INSERT INTO `menu` VALUES ('13', '编码规则', 'icon-tip', '9', null);
INSERT INTO `menu` VALUES ('14', '编码型谱', 'icon-tip', '9', '/ssmxm/index.jsp');
INSERT INTO `menu` VALUES ('15', '我的任务', 'icon-tip', '10', null);
INSERT INTO `menu` VALUES ('16', '我参与的流程', 'icon-tip', '10', null);
INSERT INTO `menu` VALUES ('17', '我的消息', 'icon-tip', '10', null);
INSERT INTO `menu` VALUES ('18', '存储库管理', 'icon-print', '0', null);
INSERT INTO `menu` VALUES ('19', '存储管理', 'icon-tip', '18', null);
INSERT INTO `menu` VALUES ('20', '用户管理', 'icon-print', '0', '');
INSERT INTO `menu` VALUES ('21', '用户信息', 'icon-tip', '20', '/ssmxm/users.jsp');
users表
/*
Navicat MySQL Data Transfer
Source Server : MySQL2
Source Server Version : 50720
Source Host : localhost:3306
Source Database : test
Target Server Type : MYSQL
Target Server Version : 50720
File Encoding : 65001
Date: 2019-07-26 16:01:53
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `users`
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(200) NOT NULL,
`password` varchar(200) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=52 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of users
-- ----------------------------
INSERT INTO `users` VALUES ('1', 'admin', '123456');
INSERT INTO `users` VALUES ('2', 'users', '123456');
INSERT INTO `users` VALUES ('3', '小敏', '123456');
INSERT INTO `users` VALUES ('5', '小哥', '123456');
INSERT INTO `users` VALUES ('6', '小强', '123456');
INSERT INTO `users` VALUES ('8', '小花', '123456');
INSERT INTO `users` VALUES ('10', '潇潇', '123456');
INSERT INTO `users` VALUES ('37', 'Q仔', '123456');
INSERT INTO `users` VALUES ('38', '小张', '123456');
INSERT INTO `users` VALUES ('44', '香茗', '123456');
INSERT INTO `users` VALUES ('45', '顾森西', '123456');
INSERT INTO `users` VALUES ('46', '齐铭', '123456');
INSERT INTO `users` VALUES ('47', '易遥', '123456');
role表
/*
Navicat MySQL Data Transfe