权限菜单动态管理-自用备份-白红宇的个人博客

发布日期：2021-08-13 18:30:12 浏览次数：1 分类：技术文章

本文共 13014 字，大约阅读时间需要 43 分钟。

菜单分级管理


          
               
        信息管理            
                         
                              
           ${menu1.menuName} 
             
              
               
               ${menu2.menuName} 
                 
                  
                   
                   ${menu3.menuName}

View Code

sql

DROP TABLE IF EXISTS `menu_info`;CREATE TABLE `menu_info` (  `id` int(11) NOT NULL AUTO_INCREMENT,  `menuname` varchar(20) DEFAULT NULL COMMENT '菜单名',  `trcode` varchar(6) DEFAULT NULL COMMENT '菜单编号',  `submenu` varchar(2) DEFAULT NULL COMMENT '是否有子菜单',  `level` int(1) DEFAULT NULL COMMENT '等级',  `action` varchar(50) DEFAULT NULL,  `age1` varchar(2) DEFAULT NULL,  `age2` varchar(2) DEFAULT NULL,  `age3` varchar(2) DEFAULT NULL,  `other` varchar(20) DEFAULT NULL,  PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8;-- ------------------------------ Records of menu_info-- ----------------------------INSERT INTO `menu_info` VALUES ('1', '书籍信息列表', '010000', 'Y', '1', 'ShowServlet?method=ulist', '01', '00', '00', '12');INSERT INTO `menu_info` VALUES ('2', '书籍信息管理', '010100', 'Y', '2', 'ShowServlet?method=ulist', '01', '01', '00', '');INSERT INTO `menu_info` VALUES ('3', '书籍信息添加', '010101', 'N', '3', 'ShowServlet?method=ulist', '01', '01', '01', null);INSERT INTO `menu_info` VALUES ('4', '书籍信息删除', '010102', 'N', '3', 'ShowServlet?method=ulist', '01', '01', '02', null);INSERT INTO `menu_info` VALUES ('5', '书籍信息编辑', '010103', 'N', '3', 'ShowServlet?method=ulist', '01', '01', '03', null);INSERT INTO `menu_info` VALUES ('6', '用户信息列表', '020000', 'Y', '1', 'LoginServlet?method=admin_manage', '02', '00', '00', null);INSERT INTO `menu_info` VALUES ('7', '用户信息管理', '020100', 'Y', '2', 'LoginServlet?method=admin_manage', '02', '01', '00', null);INSERT INTO `menu_info` VALUES ('8', '用户信息添加', '020101', 'N', '3', 'LoginServlet?method=admin_manage', '02', '01', '01', '');INSERT INTO `menu_info` VALUES ('9', '用户信息删除', '020102', 'N', '3', 'LoginServlet?method=admin_manage', '02', '01', '02', null);INSERT INTO `menu_info` VALUES ('10', '用户信息编辑', '020103', 'N', '3', 'LoginServlet?method=admin_manage', '02', '01', '03', null);INSERT INTO `menu_info` VALUES ('11', '备注1', '020200', 'Y', '2', 'LoginServlet?method=admin_manage', '02', '02', '00', '12');INSERT INTO `menu_info` VALUES ('12', '菜单信息列表', '030000', 'Y', '1', 'LoginServlet?method=munu_manage', '03', '00', '00', null);INSERT INTO `menu_info` VALUES ('17', '菜单信息管理', '030100', 'Y', '2', 'LoginServlet?method=munu_manage', '03', '01', '00', null);INSERT INTO `menu_info` VALUES ('18', '菜单信息添加', '030101', 'N', '3', 'LoginServlet?method=munu_manage', '03', '01', '01', null);INSERT INTO `menu_info` VALUES ('19', '菜单信息删除', '030102', 'N', '3', 'LoginServlet?method=munu_manage', '03', '01', '02', null);INSERT INTO `menu_info` VALUES ('20', '菜单信息编辑', '030103', 'N', '3', 'LoginServlet?method=munu_manage', '03', '01', '03', null);

View Code

DROP TABLE IF EXISTS `person_info`;CREATE TABLE `person_info` (  `user_id` int(11) NOT NULL AUTO_INCREMENT,  `login_name` varchar(20) NOT NULL COMMENT '登录名',  `password` varchar(50) NOT NULL,  `post_id` int(20) NOT NULL,  `other` varchar(20) DEFAULT NULL,  PRIMARY KEY (`user_id`),  UNIQUE KEY `login_name` (`login_name`)) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;-- ------------------------------ Records of person_info-- ----------------------------INSERT INTO `person_info` VALUES ('1', 'user', '511B0D5F341BDDBD9A5348923B48D14C', '2', '普通管理员1');INSERT INTO `person_info` VALUES ('2', 'admin', '21232F297A57A5A743894A0E4A801FC3', '1', '超级管理员');INSERT INTO `person_info` VALUES ('3', 'admin01', '18C6D818AE35A3E8279B5330EDA01498', '1', '1');

View Code

DROP TABLE IF EXISTS `work_menu`;CREATE TABLE `work_menu` (  `id` int(11) NOT NULL AUTO_INCREMENT,  `work_id` varchar(255) DEFAULT NULL,  `trcode` varchar(255) DEFAULT NULL,  PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8;-- ------------------------------ Records of work_menu-- ----------------------------INSERT INTO `work_menu` VALUES ('1', '1', '010000');INSERT INTO `work_menu` VALUES ('2', '1', '010100');INSERT INTO `work_menu` VALUES ('3', '1', '010101');INSERT INTO `work_menu` VALUES ('4', '1', '010102');INSERT INTO `work_menu` VALUES ('5', '1', '010103');INSERT INTO `work_menu` VALUES ('6', '1', '020000');INSERT INTO `work_menu` VALUES ('7', '1', '020100');INSERT INTO `work_menu` VALUES ('8', '1', '020101');INSERT INTO `work_menu` VALUES ('9', '1', '020102');INSERT INTO `work_menu` VALUES ('10', '1', '020103');INSERT INTO `work_menu` VALUES ('11', '1', '020200');INSERT INTO `work_menu` VALUES ('12', '1', '030000');INSERT INTO `work_menu` VALUES ('13', '1', '030100');INSERT INTO `work_menu` VALUES ('14', '1', '030101');INSERT INTO `work_menu` VALUES ('15', '1', '030102');INSERT INTO `work_menu` VALUES ('16', '1', '030103');INSERT INTO `work_menu` VALUES ('17', '2', '010000');INSERT INTO `work_menu` VALUES ('18', '2', '010100');INSERT INTO `work_menu` VALUES ('19', '2', '010101');INSERT INTO `work_menu` VALUES ('20', '2', '010102');INSERT INTO `work_menu` VALUES ('21', '2', '010103');INSERT INTO `work_menu` VALUES ('22', null, null);

View Code

menu方法

package com.dao.impl;import java.sql.Connection;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;import java.util.ArrayList;import java.util.List;import com.dao.MenuDao;import com.db.DBConn;import com.db.impl.DBConnJdbcProp;import com.entity.Menu_info;public class MenuDaoImpl extends BaseDaoImpl
      
        implements MenuDao{    @Override    public List
       
         getTop(String login_name) {        DBConn db = new DBConnJdbcProp();        Connection con=db.getConn();        String sql = "SELECT mi.* FROM work_menu wm, menu_info mi, person_info pi "                    + "WHERE wm.trcode = mi.trcode "                    + "AND wm.work_id = pi.post_id "                    + "AND mi. LEVEL = 1 "                    + "AND pi.login_name= '"+login_name+"'";        PreparedStatement pstmt=null;        ResultSet rs=null;        List
        
          top =null;        try {            pstmt = con.prepareStatement(sql);            rs = pstmt.executeQuery();            top = new ArrayList
         
          ();            while(rs.next()){                Menu_info menu = new Menu_info();                menu.setId(rs.getInt("id"));                menu.setMenuName(rs.getString("menuName"));                menu.setTrcode(rs.getString("trcode"));                menu.setSubmenu(rs.getString("submenu"));                menu.setLevel(rs.getInt("level"));                menu.setAction(rs.getString("action"));                menu.setAge1(rs.getString("age1"));                menu.setAge2(rs.getString("age2"));                menu.setAge2(rs.getString("age2"));                menu.setOther(rs.getString("other"));                top.add(menu);            }        } catch (SQLException e) {            e.printStackTrace();        }        return top;    }            public List
          
            getSec(String login_name) {        DBConn db = new DBConnJdbcProp();        Connection con=db.getConn();        String sql = "SELECT mi.* FROM work_menu wm, menu_info mi, person_info pi "                + "WHERE wm.trcode = mi.trcode "                + "AND wm.work_id = pi.post_id "                + "AND mi. LEVEL = 2 "                + "AND pi.login_name= '"+login_name+"'";        PreparedStatement pstmt=null;        ResultSet rs=null;        List
           
             sec =null; try { pstmt = con.prepareStatement(sql); rs = pstmt.executeQuery(); sec = new ArrayList
            
             (); while(rs.next()){ Menu_info menu = new Menu_info(); menu.setId(rs.getInt("id")); menu.setMenuName(rs.getString("menuName")); menu.setTrcode(rs.getString("trcode")); menu.setSubmenu(rs.getString("submenu")); menu.setLevel(rs.getInt("level")); menu.setAction(rs.getString("action")); menu.setAge1(rs.getString("age1")); menu.setAge2(rs.getString("age2")); menu.setAge2(rs.getString("age2")); menu.setOther(rs.getString("other")); sec.add(menu); } } catch (SQLException e) { e.printStackTrace(); } return sec; } public List
             
               getThird(String login_name) { DBConn db = new DBConnJdbcProp(); Connection con=db.getConn(); String sql = "SELECT mi.* FROM work_menu wm, menu_info mi, person_info pi " + "WHERE wm.trcode = mi.trcode " + "AND wm.work_id = pi.post_id " + "AND mi. LEVEL =3 " + "AND pi.login_name= '"+login_name+"'"; PreparedStatement pstmt=null; ResultSet rs=null; List
              
                third =null; try { pstmt = con.prepareStatement(sql); rs = pstmt.executeQuery(); third = new ArrayList
               
                (); while(rs.next()){ Menu_info menu = new Menu_info(); menu.setId(rs.getInt("id")); menu.setMenuName(rs.getString("menuName")); menu.setTrcode(rs.getString("trcode")); menu.setSubmenu(rs.getString("submenu")); menu.setLevel(rs.getInt("level")); menu.setAction(rs.getString("action")); menu.setAge1(rs.getString("age1")); menu.setAge2(rs.getString("age2")); menu.setAge2(rs.getString("age2")); menu.setOther(rs.getString("other")); third.add(menu); } } catch (SQLException e) { e.printStackTrace(); } return third; } }

View Code

MenuDao dao = new MenuDaoImpl();            List
      
        menu1 = dao.getTop(login_name);            session.setAttribute("menu1", menu1);            List
       
         menu2 = dao.getSec(login_name);            session.setAttribute("menu2", menu2);            List
        
          menu3 = dao.getThird(login_name);            session.setAttribute("menu3", menu3);

View Code

修改

返回    
              
      
      
                                            ID                      菜单名                      trcode                      submenu                      菜单等级                      链接                      分类1                      分类2                      分类3                      备注                      操作                 
                                     ${menulist.id}                      ${menulist.menuName}                      ${menulist.trcode}                      ${menulist.submenu}                      ${menulist.level}                      ${menulist.action}                      ${menulist.age1}                      ${menulist.age2}                      ${menulist.age3}                      ${menulist.other}                                      修改                删除

ID	菜单名	trcode	submenu	菜单等级	链接	分类1	分类2	分类3	备注	操作
${menulist.id}	${menulist.menuName}	${menulist.trcode}	${menulist.submenu}	${menulist.level}	${menulist.action}	${menulist.age1}	${menulist.age2}	${menulist.age3}	${menulist.other}	修改删除

View Code

View Code

else if("menu_form".equals(method)){                        menu = mbiz.get(Integer.parseInt(id));            session.setAttribute("menu_update", menu);            response.sendRedirect("menu_update.jsp");                    }else if("menu_update".equals(method)){                        String menuname = request.getParameter("menuName");            String trcode = request.getParameter("trcode");            String submenu = request.getParameter("submenu");            String level = request.getParameter("level");            String action = request.getParameter("action");            String age1 = request.getParameter("age1");            String age2 = request.getParameter("age2");            String age3 = request.getParameter("age3");            String other = request.getParameter("other");                        menu.setId(Integer.parseInt(id));            menu.setMenuName(menuname);            menu.setTrcode(trcode);            menu.setSubmenu(submenu);            menu.setLevel(Integer.parseInt(level));            menu.setAction(action);            menu.setAge1(age1);            menu.setAge2(age2);            menu.setAge3(age3);            menu.setOther(other);            int rs = mbiz.update(menu);            if(rs>0){                request.getRequestDispatcher("LoginServlet?method=munu_manage").forward(request, response);                return;            }else{                request.getRequestDispatcher("LoginServlet?method=munu_manage").forward(request, response);                return;            }        }

View Code

转载于:https://www.cnblogs.com/carinen616/p/7903574.html

转载地址：https://blog.csdn.net/weixin_30697239/article/details/98237767 如侵犯您的版权，请留言回复原文章的地址，我们会给您删除此文章，给您带来不便请您谅解！

上一篇：tomcat arp

下一篇：[javascript基础]constructor与prototype

发表评论

关于作者

喝酒易醉，品茶养心，人生如梦，品茶悟道，何以解忧？唯有杜康！

-- 愿君每日到此一游！

发表评论

最新留言

关于作者

推荐文章