探讨MyBatis框架结合Redis实现缓存优化的方法，分析登录过程中的数据库查询及Redis缓存命中情况，对比不同场景下登录速度，讨论权限更改后缓存的有效性。
rememberMe>>>>:null Creating a new SqlSession SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@7398fa2] was not registered for synchronization because synchronization is not active JDBC Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@5690c43b] will not be managed by Spring ==> Preparing: select id, name, password, salt from user where name = ? ==> Parameters: zhang3(String) <== Columns: id, name, password, salt <== Row: 5, zhang3, 7429017bd19cc345733399a2fb648cd7, +iaowhMUpqjV47c8Qma0Ng== <== Total: 1 Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@7398fa2] Creating a new SqlSession SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@44d70811] was not registered for synchronization because synchronization is not active JDBC Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@5690c43b] will not be managed by Spring ==> Preparing: select id, name, password, salt from user where name = ? ==> Parameters: zhang3(String) <== Columns: id, name, password, salt <== Row: 5, zhang3, 7429017bd19cc345733399a2fb648cd7, +iaowhMUpqjV47c8Qma0Ng== <== Total: 1 Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@44d70811] Creating a new SqlSession SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@6ae8998e] was not registered for synchronization because synchronization is not active JDBC Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@5690c43b] will not be managed by Spring ==> Preparing: select r.* from user u,role r,user_role ur where ur.uid=u.id AND ur.rid=r.id AND u.id=? ==> Parameters: 5(Integer) <== Columns: id, name, desc_ <== Row: 1, 总管理员, 总管理员 <== Total: 1 Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@6ae8998e] 2019-04-24 15:46:43,555 - Starting without optional epoll library 2019-04-24 15:46:43,557 - Starting without optional kqueue library Creating a new SqlSession SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4b42a314] was not registered for synchronization because synchronization is not active JDBC Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@5690c43b] will not be managed by Spring ==> Preparing: select m.* from role r,e_menu m,role_menu rm where rm.role_id = r.id and rm.menu_id =m.id and r.id = ? ==> Parameters: 1(Long) <== Columns: id, icon, name, state, url, p_id <== Row: 1, menu-plugin, 系统菜单, 1, null, -1 <== Row: 10, menu-1, 会员管理, 1, null, 1 <== Row: 1010, menu-11, 会员信息管理, 0, /admin/member/members, 10 <== Row: 1020, menu-12, 会员等级管理, 0, /admin/member/mrole, 10 <== Row: 20, menu-2, 货品管理, 1, null, 1 <== Row: 2010, menu-21, 石油焦信息, 0, /admin/goods/coke, 20 <== Row: 2020, menu-22, 煅后焦信息, 0, /admin/goods/calcined, 20 <== Row: 2030, menu-23, 改质沥青信息, 0, /admin/goods/asphalt, 20 <== Row: 2040, menu-24, 阳极信息, 0, /admin/goods/anode, 20 <== Row: 30, menu-3, 员工管理, 1, null, 1 <== Row: 3010, menu-31, 员工信息管理, 0, /admin/employees/employees, 30 <== Row: 40, menu-4, 管理员管理, 1, null, 1 <== Row: 4010, menu-41, 后台用户管理, 0, /admin/power/user, 40 <== Row: 4020, menu-42, 系统角色管理, 0, /admin/auth/roleconfig, 40 <== Row: 50, menu-5, 系统管理, 1, null, 1 <== Row: 5010, menu-51, 路径配置, 0, /admin/auth/menu, 50 <== Row: 5020, menu-52, 数据库备份, 0, /admin/auth/dbbackup, 50 <== Row: 5030, menu-53, 系统日志, 0, /admin/auth/syslog, 50 <== Row: 5040, menu-54, 会员日志, 0, /admin/auth/memberlog, 50 <== Row: 5050, menu-55, 系统配置, 0, /admin/auth/sysconfig, 50 <== Row: 5060, menu-56, 接口文档, 0, /admin/swagger, 50 <== Row: 5070, menu-57, 数据库监控, 0, /admin/druid, 50 <== Total: 22 Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4b42a314] menuIdStr:2040,40,5020,5010,5070,4010,4020,1010,5050,10,5030,2010,2020,50,2030,30,20,3010,1,1020,5040,5060, (String)allMenuObj:[{"children":[{"children":[{"attributes":{"url":"/admin/member/members"},"id":1010,"text":"会员信息管理","state":"open","iconCls":"menu-11"},{"attributes":{"url":"/admin/member/mrole"},"id":1020,"text":"会员等级管理","state":"open","iconCls":"menu-12"}],"attributes":{},"id":10,"text":"会员管理","state":"closed","iconCls":"menu-1"},{"children":[{"attributes":{"url":"/admin/goods/coke"},"id":2010,"text":"石油焦信息","state":"open","iconCls":"menu-21"},{"attributes":{"url":"/admin/goods/calcined"},"id":2020,"text":"煅后焦信息","state":"open","iconCls":"menu-22"},{"attributes":{"url":"/admin/goods/asphalt"},"id":2030,"text":"改质沥青信息","state":"open","iconCls":"menu-23"},{"attributes":{"url":"/admin/goods/anode"},"id":2040,"text":"阳极信息","state":"open","iconCls":"menu-24"}],"attributes":{},"id":20,"text":"货品管理","state":"closed","iconCls":"menu-2"},{"children":[{"attributes":{"url":"/admin/power/user"},"id":4010,"text":"后台用户管理","state":"open","iconCls":"menu-41"},{"attributes":{"url":"/admin/auth/roleconfig"},"id":4020,"text":"系统角色管理","state":"open","iconCls":"menu-42"}],"attributes":{},"id":40,"text":"管理员管理","state":"closed","iconCls":"menu-4"},{"children":[{"attributes":{"url":"/admin/auth/menu"},"id":5010,"text":"路径配置","state":"open","iconCls":"menu-51"},{"attributes":{"url":"/admin/auth/dbbackup"},"id":5020,"text":"数据库备份","state":"open","iconCls":"menu-52"},{"attributes":{"url":"/admin/auth/syslog"},"id":5030,"text":"系统日志","state":"open","iconCls":"menu-53"},{"attributes":{"url":"/admin/auth/memberlog"},"id":5040,"text":"会员日志","state":"open","iconCls":"menu-54"},{"attributes":{"url":"/admin/auth/sysconfig"},"id":5050,"text":"系统配置","state":"open","iconCls":"menu-55"},{"attributes":{"url":"/admin/swagger"},"id":5060,"text":"接口文档","state":"open","iconCls":"menu-56"},{"attributes":{"url":"/admin/druid"},"id":5070,"text":"数据库监控","state":"open","iconCls":"menu-57"}],"attributes":{},"id":50,"text":"系统管理","state":"closed","iconCls":"menu-5"},{"children":[{"attributes":{"url":"/admin/employees/employees"},"id":3010,"text":"员工信息管理","state":"open","iconCls":"menu-31"}],"attributes":{},"id":30,"text":"员工管理","state":"closed","iconCls":"menu-3"}],"attributes":{},"id":1,"text":"系统菜单","state":"closed","iconCls":"menu-plugin"}] Creating a new SqlSession SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@cae7d97] was not registered for synchronization because synchronization is not active JDBC Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@5690c43b] will not be managed by Spring ==> Preparing: select id, name, password, salt from user where name = ? ==> Parameters: zhang3(String) <== Columns: id, name, password, salt <== Row: 5, zhang3, 7429017bd19cc345733399a2fb648cd7, +iaowhMUpqjV47c8Qma0Ng== <== Total: 1 Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@cae7d97] Creating a new SqlSession SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@2ea6cdb6] was not registered for synchronization because synchronization is not active JDBC Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@5690c43b] will not be managed by Spring ==> Preparing: select r.* from user u,role r,user_role ur where ur.uid=u.id AND ur.rid=r.id AND u.id=? ==> Parameters: 5(Integer) <== Columns: id, name, desc_ <== Row: 1, 总管理员, 总管理员 <== Total: 1 Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@2ea6cdb6] Creating a new SqlSession SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@68feb115] was not registered for synchronization because synchronization is not active JDBC Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@5690c43b] will not be managed by Spring ==> Preparing: select m.* from role r,e_menu m,role_menu rm where rm.role_id = r.id and rm.menu_id =m.id and r.id = ? ==> Parameters: 1(Long) <== Columns: id, icon, name, state, url, p_id <== Row: 1, menu-plugin, 系统菜单, 1, null, -1 <== Row: 10, menu-1, 会员管理, 1, null, 1 <== Row: 1010, menu-11, 会员信息管理, 0, /admin/member/members, 10 <== Row: 1020, menu-12, 会员等级管理, 0, /admin/member/mrole, 10 <== Row: 20, menu-2, 货品管理, 1, null, 1 <== Row: 2010, menu-21, 石油焦信息, 0, /admin/goods/coke, 20 <== Row: 2020, menu-22, 煅后焦信息, 0, /admin/goods/calcined, 20 <== Row: 2030, menu-23, 改质沥青信息, 0, /admin/goods/asphalt, 20 <== Row: 2040, menu-24, 阳极信息, 0, /admin/goods/anode, 20 <== Row: 30, menu-3, 员工管理, 1, null, 1 <== Row: 3010, menu-31, 员工信息管理, 0, /admin/employees/employees, 30 <== Row: 40, menu-4, 管理员管理, 1, null, 1 <== Row: 4010, menu-41, 后台用户管理, 0, /admin/power/user, 40 <== Row: 4020, menu-42, 系统角色管理, 0, /admin/auth/roleconfig, 40 <== Row: 50, menu-5, 系统管理, 1, null, 1 <== Row: 5010, menu-51, 路径配置, 0, /admin/auth/menu, 50 <== Row: 5020, menu-52, 数据库备份, 0, /admin/auth/dbbackup, 50 <== Row: 5030, menu-53, 系统日志, 0, /admin/auth/syslog, 50 <== Row: 5040, menu-54, 会员日志, 0, /admin/auth/memberlog, 50 <== Row: 5050, menu-55, 系统配置, 0, /admin/auth/sysconfig, 50 <== Row: 5060, menu-56, 接口文档, 0, /admin/swagger, 50 <== Row: 5070, menu-57, 数据库监控, 0, /admin/druid, 50 <== Total: 22 Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@68feb115] 读取系统菜单中 通过redis获取session的menuids+currentUser获取了allMenu
由于在项目后台使用easyUI的树形菜单,在用户初次登录还未知晓其权限路径时,要通过各个数据库服务层进行查询,登录缓慢.
而当初次登录成功,再次登录后,由于加入了redis存储使用树形菜单ID来获取:
for (int menuId : menuIds) { menuIdStr += menuId + ","; } if (redisService.get(menuIdStr) != null) { System.out.println("loadMenuInfo获取到了redis中的allMenu数据"); allMenu = redisService.get(menuIdStr).toString(); return allMenu; } else {
很明显这次控制台没有输出"loadMenuInfo获取到了redis中的allMenu数据",只是初次加入了缓存redis中.
不停止项目运行,在web上选择用户退出,再次登录,并查看控制台打印信息:
rememberMe>>>>:null Creating a new SqlSession SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@265d4695] was not registered for synchronization because synchronization is not active JDBC Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@5690c43b] will not be managed by Spring ==> Preparing: select id, name, password, salt from user where name = ? ==> Parameters: zhang3(String) <== Columns: id, name, password, salt <== Row: 5, zhang3, 7429017bd19cc345733399a2fb648cd7, +iaowhMUpqjV47c8Qma0Ng== <== Total: 1 Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@265d4695] Creating a new SqlSession SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@59311f0a] was not registered for synchronization because synchronization is not active JDBC Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@5690c43b] will not be managed by Spring ==> Preparing: select id, name, password, salt from user where name = ? ==> Parameters: zhang3(String) <== Columns: id, name, password, salt <== Row: 5, zhang3, 7429017bd19cc345733399a2fb648cd7, +iaowhMUpqjV47c8Qma0Ng== <== Total: 1 Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@59311f0a] Creating a new SqlSession SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@73e1d269] was not registered for synchronization because synchronization is not active JDBC Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@5690c43b] will not be managed by Spring ==> Preparing: select r.* from user u,role r,user_role ur where ur.uid=u.id AND ur.rid=r.id AND u.id=? ==> Parameters: 5(Integer) <== Columns: id, name, desc_ <== Row: 1, 总管理员, 总管理员 <== Total: 1 Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@73e1d269] Creating a new SqlSession SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@130a0243] was not registered for synchronization because synchronization is not active JDBC Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@5690c43b] will not be managed by Spring ==> Preparing: select m.* from role r,e_menu m,role_menu rm where rm.role_id = r.id and rm.menu_id =m.id and r.id = ? ==> Parameters: 1(Long) <== Columns: id, icon, name, state, url, p_id <== Row: 1, menu-plugin, 系统菜单, 1, null, -1 <== Row: 10, menu-1, 会员管理, 1, null, 1 <== Row: 1010, menu-11, 会员信息管理, 0, /admin/member/members, 10 <== Row: 1020, menu-12, 会员等级管理, 0, /admin/member/mrole, 10 <== Row: 20, menu-2, 货品管理, 1, null, 1 <== Row: 2010, menu-21, 石油焦信息, 0, /admin/goods/coke, 20 <== Row: 2020, menu-22, 煅后焦信息, 0, /admin/goods/calcined, 20 <== Row: 2030, menu-23, 改质沥青信息, 0, /admin/goods/asphalt, 20 <== Row: 2040, menu-24, 阳极信息, 0, /admin/goods/anode, 20 <== Row: 30, menu-3, 员工管理, 1, null, 1 <== Row: 3010, menu-31, 员工信息管理, 0, /admin/employees/employees, 30 <== Row: 40, menu-4, 管理员管理, 1, null, 1 <== Row: 4010, menu-41, 后台用户管理, 0, /admin/power/user, 40 <== Row: 4020, menu-42, 系统角色管理, 0, /admin/auth/roleconfig, 40 <== Row: 50, menu-5, 系统管理, 1, null, 1 <== Row: 5010, menu-51, 路径配置, 0, /admin/auth/menu, 50 <== Row: 5020, menu-52, 数据库备份, 0, /admin/auth/dbbackup, 50 <== Row: 5030, menu-53, 系统日志, 0, /admin/auth/syslog, 50 <== Row: 5040, menu-54, 会员日志, 0, /admin/auth/memberlog, 50 <== Row: 5050, menu-55, 系统配置, 0, /admin/auth/sysconfig, 50 <== Row: 5060, menu-56, 接口文档, 0, /admin/swagger, 50 <== Row: 5070, menu-57, 数据库监控, 0, /admin/druid, 50 <== Total: 22 Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@130a0243] menuIdStr:2040,40,5020,5010,5070,4010,4020,1010,5050,10,5030,2010,2020,50,2030,30,20,3010,1,1020,5040,5060, (String)allMenuObj:[{"children":[{"children":[{"attributes":{"url":"/admin/member/members"},"id":1010,"text":"会员信息管理","state":"open","iconCls":"menu-11"},{"attributes":{"url":"/admin/member/mrole"},"id":1020,"text":"会员等级管理","state":"open","iconCls":"menu-12"}],"attributes":{},"id":10,"text":"会员管理","state":"closed","iconCls":"menu-1"},{"children":[{"attributes":{"url":"/admin/goods/coke"},"id":2010,"text":"石油焦信息","state":"open","iconCls":"menu-21"},{"attributes":{"url":"/admin/goods/calcined"},"id":2020,"text":"煅后焦信息","state":"open","iconCls":"menu-22"},{"attributes":{"url":"/admin/goods/asphalt"},"id":2030,"text":"改质沥青信息","state":"open","iconCls":"menu-23"},{"attributes":{"url":"/admin/goods/anode"},"id":2040,"text":"阳极信息","state":"open","iconCls":"menu-24"}],"attributes":{},"id":20,"text":"货品管理","state":"closed","iconCls":"menu-2"},{"children":[{"attributes":{"url":"/admin/power/user"},"id":4010,"text":"后台用户管理","state":"open","iconCls":"menu-41"},{"attributes":{"url":"/admin/auth/roleconfig"},"id":4020,"text":"系统角色管理","state":"open","iconCls":"menu-42"}],"attributes":{},"id":40,"text":"管理员管理","state":"closed","iconCls":"menu-4"},{"children":[{"attributes":{"url":"/admin/auth/menu"},"id":5010,"text":"路径配置","state":"open","iconCls":"menu-51"},{"attributes":{"url":"/admin/auth/dbbackup"},"id":5020,"text":"数据库备份","state":"open","iconCls":"menu-52"},{"attributes":{"url":"/admin/auth/syslog"},"id":5030,"text":"系统日志","state":"open","iconCls":"menu-53"},{"attributes":{"url":"/admin/auth/memberlog"},"id":5040,"text":"会员日志","state":"open","iconCls":"menu-54"},{"attributes":{"url":"/admin/auth/sysconfig"},"id":5050,"text":"系统配置","state":"open","iconCls":"menu-55"},{"attributes":{"url":"/admin/swagger"},"id":5060,"text":"接口文档","state":"open","iconCls":"menu-56"},{"attributes":{"url":"/admin/druid"},"id":5070,"text":"数据库监控","state":"open","iconCls":"menu-57"}],"attributes":{},"id":50,"text":"系统管理","state":"closed","iconCls":"menu-5"},{"children":[{"attributes":{"url":"/admin/employees/employees"},"id":3010,"text":"员工信息管理","state":"open","iconCls":"menu-31"}],"attributes":{},"id":30,"text":"员工管理","state":"closed","iconCls":"menu-3"}],"attributes":{},"id":1,"text":"系统菜单","state":"closed","iconCls":"menu-plugin"}] Creating a new SqlSession SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@2a51cd5] was not registered for synchronization because synchronization is not active JDBC Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@5690c43b] will not be managed by Spring ==> Preparing: select id, name, password, salt from user where name = ? ==> Parameters: zhang3(String) <== Columns: id, name, password, salt <== Row: 5, zhang3, 7429017bd19cc345733399a2fb648cd7, +iaowhMUpqjV47c8Qma0Ng== <== Total: 1 Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@2a51cd5] Creating a new SqlSession SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@44d0e7df] was not registered for synchronization because synchronization is not active JDBC Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@5690c43b] will not be managed by Spring ==> Preparing: select r.* from user u,role r,user_role ur where ur.uid=u.id AND ur.rid=r.id AND u.id=? ==> Parameters: 5(Integer) <== Columns: id, name, desc_ <== Row: 1, 总管理员, 总管理员 <== Total: 1 Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@44d0e7df] Creating a new SqlSession SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@1eb05f19] was not registered for synchronization because synchronization is not active JDBC Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@5690c43b] will not be managed by Spring ==> Preparing: select m.* from role r,e_menu m,role_menu rm where rm.role_id = r.id and rm.menu_id =m.id and r.id = ? ==> Parameters: 1(Long) <== Columns: id, icon, name, state, url, p_id <== Row: 1, menu-plugin, 系统菜单, 1, null, -1 <== Row: 10, menu-1, 会员管理, 1, null, 1 <== Row: 1010, menu-11, 会员信息管理, 0, /admin/member/members, 10 <== Row: 1020, menu-12, 会员等级管理, 0, /admin/member/mrole, 10 <== Row: 20, menu-2, 货品管理, 1, null, 1 <== Row: 2010, menu-21, 石油焦信息, 0, /admin/goods/coke, 20 <== Row: 2020, menu-22, 煅后焦信息, 0, /admin/goods/calcined, 20 <== Row: 2030, menu-23, 改质沥青信息, 0, /admin/goods/asphalt, 20 <== Row: 2040, menu-24, 阳极信息, 0, /admin/goods/anode, 20 <== Row: 30, menu-3, 员工管理, 1, null, 1 <== Row: 3010, menu-31, 员工信息管理, 0, /admin/employees/employees, 30 <== Row: 40, menu-4, 管理员管理, 1, null, 1 <== Row: 4010, menu-41, 后台用户管理, 0, /admin/power/user, 40 <== Row: 4020, menu-42, 系统角色管理, 0, /admin/auth/roleconfig, 40 <== Row: 50, menu-5, 系统管理, 1, null, 1 <== Row: 5010, menu-51, 路径配置, 0, /admin/auth/menu, 50 <== Row: 5020, menu-52, 数据库备份, 0, /admin/auth/dbbackup, 50 <== Row: 5030, menu-53, 系统日志, 0, /admin/auth/syslog, 50 <== Row: 5040, menu-54, 会员日志, 0, /admin/auth/memberlog, 50 <== Row: 5050, menu-55, 系统配置, 0, /admin/auth/sysconfig, 50 <== Row: 5060, menu-56, 接口文档, 0, /admin/swagger, 50 <== Row: 5070, menu-57, 数据库监控, 0, /admin/druid, 50 <== Total: 22 Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@1eb05f19] 读取系统菜单中 通过redis获取session的menuids+currentUser获取了allMenu
这次明显登录快了.那么应该是redis起了作用.那么重新测试,将redis中的数据清除,以及重启项目测试:
在登录控制方法中,有该语句:
Object allMenuObj = redisService.get(menuIdStr);
System.out.println("menuIdStr:" + menuIdStr);
if (allMenuObj != null) { redisService.set(menuIdStr, allMenuObj.toString()); System.out.println("(String)allMenuObj:" + (String) allMenuObj); session.setAttribute("menuIds", menuIdArr); redisService.set(session.getAttribute("menuIds").toString() + session.getAttribute("currentUser").toString(), allMenuObj.toString()); } else { String allMenu = eMenuUtils.getAllEMenuByParentIdAndMenuIds(-1, menuIdArr).toString(); System.out.println("login.allMenu:" + allMenu); redisService.set(menuIdStr, allMenu); session.setAttribute("menuIds", menuIdArr); redisService.set(session.getAttribute("menuIds").toString() + session.getAttribute("currentUser").toString(), allMenu); }
首先从redis服务中获取查看有没有相应的这个menuId组成的字符串的键的数据.
不出所料的话,这次是没有的,因为刚清空了redis,那么应该是走else,并输出 "login.allMenu:......."
rememberMe>>>>:null Creating a new SqlSession SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@5eeb1dd] was not registered for synchronization because synchronization is not active JDBC Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@dec5439] will not be managed by Spring ==> Preparing: select id, name, password, salt from user where name = ? ==> Parameters: zhang3(String) <== Columns: id, name, password, salt <== Row: 5, zhang3, 7429017bd19cc345733399a2fb648cd7, +iaowhMUpqjV47c8Qma0Ng== <== Total: 1 Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@5eeb1dd] Creating a new SqlSession SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@100cb3be] was not registered for synchronization because synchronization is not active JDBC Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@dec5439] will not be managed by Spring ==> Preparing: select id, name, password, salt from user where name = ? ==> Parameters: zhang3(String) <== Columns: id, name, password, salt <== Row: 5, zhang3, 7429017bd19cc345733399a2fb648cd7, +iaowhMUpqjV47c8Qma0Ng== <== Total: 1 Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@100cb3be] Creating a new SqlSession SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@30792f2d] was not registered for synchronization because synchronization is not active JDBC Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@dec5439] will not be managed by Spring ==> Preparing: select r.* from user u,role r,user_role ur where ur.uid=u.id AND ur.rid=r.id AND u.id=? ==> Parameters: 5(Integer) <== Columns: id, name, desc_ <== Row: 1, 总管理员, 总管理员 <== Total: 1 Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@30792f2d] 2019-04-24 16:03:38,535 - Starting without optional epoll library 2019-04-24 16:03:38,536 - Starting without optional kqueue library Creating a new SqlSession SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@1e50580c] was not registered for synchronization because synchronization is not active JDBC Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@dec5439] will not be managed by Spring ==> Preparing: select m.* from role r,e_menu m,role_menu rm where rm.role_id = r.id and rm.menu_id =m.id and r.id = ? ==> Parameters: 1(Long) <== Columns: id, icon, name, state, url, p_id <== Row: 1, menu-plugin, 系统菜单, 1, null, -1 <== Row: 10, menu-1, 会员管理, 1, null, 1 <== Row: 1010, menu-11, 会员信息管理, 0, /admin/member/members, 10 <== Row: 1020, menu-12, 会员等级管理, 0, /admin/member/mrole, 10 <== Row: 20, menu-2, 货品管理, 1, null, 1 <== Row: 2010, menu-21, 石油焦信息, 0, /admin/goods/coke, 20 <== Row: 2020, menu-22, 煅后焦信息, 0, /admin/goods/calcined, 20 <== Row: 2030, menu-23, 改质沥青信息, 0, /admin/goods/asphalt, 20 <== Row: 2040, menu-24, 阳极信息, 0, /admin/goods/anode, 20 <== Row: 30, menu-3, 员工管理, 1, null, 1 <== Row: 3010, menu-31, 员工信息管理, 0, /admin/employees/employees, 30 <== Row: 40, menu-4, 管理员管理, 1, null, 1 <== Row: 4010, menu-41, 后台用户管理, 0, /admin/power/user, 40 <== Row: 4020, menu-42, 系统角色管理, 0, /admin/auth/roleconfig, 40 <== Row: 50, menu-5, 系统管理, 1, null, 1 <== Row: 5010, menu-51, 路径配置, 0, /admin/auth/menu, 50 <== Row: 5020, menu-52, 数据库备份, 0, /admin/auth/dbbackup, 50 <== Row: 5030, menu-53, 系统日志, 0, /admin/auth/syslog, 50 <== Row: 5040, menu-54, 会员日志, 0, /admin/auth/memberlog, 50 <== Row: 5050, menu-55, 系统配置, 0, /admin/auth/sysconfig, 50 <== Row: 5060, menu-56, 接口文档, 0, /admin/swagger, 50 <== Row: 5070, menu-57, 数据库监控, 0, /admin/druid, 50 <== Total: 22 Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@1e50580c] menuIdStr:2040,40,5020,5010,5070,4010,4020,1010,5050,10,5030,2010,2020,50,2030,30,20,3010,1,1020,5040,5060, Creating a new SqlSession SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4b00d6ae] was not registered for synchronization because synchronization is not active JDBC Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@dec5439] will not be managed by Spring ==> Preparing: select id, icon, name, state, url, p_id from e_menu where p_id = ? and id in (select distinct menu_id from role_menu where menu_id in ( ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ) ) ==> Parameters: -1(Integer), 1(Integer), 10(Integer), 20(Integer), 30(Integer), 40(Integer), 50(Integer), 1010(Integer), 1020(Integer), 2010(Integer), 2020(Integer), 2030(Integer), 2040(Integer), 3010(Integer), 4010(Integer), 4020(Integer), 5010(Integer), 5020(Integer), 5030(Integer), 5040(Integer), 5050(Integer), 5060(Integer), 5070(Integer) <== Columns: id, icon, name, state, url, p_id <== Row: 1, menu-plugin, 系统菜单, 1, null, -1 <== Total: 1 Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4b00d6ae] Creating a new SqlSession SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@29b489a2] was not registered for synchronization because synchronization is not active JDBC Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@dec5439] will not be managed by Spring ==> Preparing: select id, icon, name, state, url, p_id from e_menu where p_id = ? and id in (select distinct menu_id from role_menu where menu_id in ( ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ) ) ==> Parameters: 1(Integer), 1(Integer), 10(Integer), 20(Integer), 30(Integer), 40(Integer), 50(Integer), 1010(Integer), 1020(Integer), 2010(Integer), 2020(Integer), 2030(Integer), 2040(Integer), 3010(Integer), 4010(Integer), 4020(Integer), 5010(Integer), 5020(Integer), 5030(Integer), 5040(Integer), 5050(Integer), 5060(Integer), 5070(Integer) <== Columns: id, icon, name, state, url, p_id <== Row: 10, menu-1, 会员管理, 1, null, 1 <== Row: 20, menu-2, 货品管理, 1, null, 1 <== Row: 40, menu-4, 管理员管理, 1, null, 1 <== Row: 50, menu-5, 系统管理, 1, null, 1 <== Row: 30, menu-3, 员工管理, 1, null, 1 <== Total: 5 Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@29b489a2] Creating a new SqlSession SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@47a4ef0f] was not registered for synchronization because synchronization is not active JDBC Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@dec5439] will not be managed by Spring ==> Preparing: select id, icon, name, state, url, p_id from e_menu where p_id = ? and id in (select distinct menu_id from role_menu where menu_id in ( ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ) ) ==> Parameters: 10(Integer), 1(Integer), 10(Integer), 20(Integer), 30(Integer), 40(Integer), 50(Integer), 1010(Integer), 1020(Integer), 2010(Integer), 2020(Integer), 2030(Integer), 2040(Integer), 3010(Integer), 4010(Integer), 4020(Integer), 5010(Integer), 5020(Integer), 5030(Integer), 5040(Integer), 5050(Integer), 5060(Integer), 5070(Integer) <== Columns: id, icon, name, state, url, p_id <== Row: 1010, menu-11, 会员信息管理, 0, /admin/member/members, 10 <== Row: 1020, menu-12, 会员等级管理, 0, /admin/member/mrole, 10 <== Total: 2 Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@47a4ef0f] Creating a new SqlSession SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@57057a95] was not registered for synchronization because synchronization is not active JDBC Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@dec5439] will not be managed by Spring ==> Preparing: select id, icon, name, state, url, p_id from e_menu where p_id = ? and id in (select distinct menu_id from role_menu where menu_id in ( ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ) ) ==> Parameters: 20(Integer), 1(Integer), 10(Integer), 20(Integer), 30(Integer), 40(Integer), 50(Integer), 1010(Integer), 1020(Integer), 2010(Integer), 2020(Integer), 2030(Integer), 2040(Integer), 3010(Integer), 4010(Integer), 4020(Integer), 5010(Integer), 5020(Integer), 5030(Integer), 5040(Integer), 5050(Integer), 5060(Integer), 5070(Integer) <== Columns: id, icon, name, state, url, p_id <== Row: 2010, menu-21, 石油焦信息, 0, /admin/goods/coke, 20 <== Row: 2020, menu-22, 煅后焦信息, 0, /admin/goods/calcined, 20 <== Row: 2030, menu-23, 改质沥青信息, 0, /admin/goods/asphalt, 20 <== Row: 2040, menu-24, 阳极信息, 0, /admin/goods/anode, 20 <== Total: 4 Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@57057a95] Creating a new SqlSession SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@59d00a7a] was not registered for synchronization because synchronization is not active JDBC Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@dec5439] will not be managed by Spring ==> Preparing: select id, icon, name, state, url, p_id from e_menu where p_id = ? and id in (select distinct menu_id from role_menu where menu_id in ( ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ) ) ==> Parameters: 40(Integer), 1(Integer), 10(Integer), 20(Integer), 30(Integer), 40(Integer), 50(Integer), 1010(Integer), 1020(Integer), 2010(Integer), 2020(Integer), 2030(Integer), 2040(Integer), 3010(Integer), 4010(Integer), 4020(Integer), 5010(Integer), 5020(Integer), 5030(Integer), 5040(Integer), 5050(Integer), 5060(Integer), 5070(Integer) <== Columns: id, icon, name, state, url, p_id <== Row: 4010, menu-41, 后台用户管理, 0, /admin/power/user, 40 <== Row: 4020, menu-42, 系统角色管理, 0, /admin/auth/roleconfig, 40 <== Total: 2 Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@59d00a7a] Creating a new SqlSession SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@77d1fc89] was not registered for synchronization because synchronization is not active JDBC Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@dec5439] will not be managed by Spring ==> Preparing: select id, icon, name, state, url, p_id from e_menu where p_id = ? and id in (select distinct menu_id from role_menu where menu_id in ( ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ) ) ==> Parameters: 50(Integer), 1(Integer), 10(Integer), 20(Integer), 30(Integer), 40(Integer), 50(Integer), 1010(Integer), 1020(Integer), 2010(Integer), 2020(Integer), 2030(Integer), 2040(Integer), 3010(Integer), 4010(Integer), 4020(Integer), 5010(Integer), 5020(Integer), 5030(Integer), 5040(Integer), 5050(Integer), 5060(Integer), 5070(Integer) <== Columns: id, icon, name, state, url, p_id <== Row: 5010, menu-51, 路径配置, 0, /admin/auth/menu, 50 <== Row: 5020, menu-52, 数据库备份, 0, /admin/auth/dbbackup, 50 <== Row: 5030, menu-53, 系统日志, 0, /admin/auth/syslog, 50 <== Row: 5040, menu-54, 会员日志, 0, /admin/auth/memberlog, 50 <== Row: 5050, menu-55, 系统配置, 0, /admin/auth/sysconfig, 50 <== Row: 5060, menu-56, 接口文档, 0, /admin/swagger, 50 <== Row: 5070, menu-57, 数据库监控, 0, /admin/druid, 50 <== Total: 7 Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@77d1fc89] Creating a new SqlSession SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@758acab8] was not registered for synchronization because synchronization is not active JDBC Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@dec5439] will not be managed by Spring ==> Preparing: select id, icon, name, state, url, p_id from e_menu where p_id = ? and id in (select distinct menu_id from role_menu where menu_id in ( ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ) ) ==> Parameters: 30(Integer), 1(Integer), 10(Integer), 20(Integer), 30(Integer), 40(Integer), 50(Integer), 1010(Integer), 1020(Integer), 2010(Integer), 2020(Integer), 2030(Integer), 2040(Integer), 3010(Integer), 4010(Integer), 4020(Integer), 5010(Integer), 5020(Integer), 5030(Integer), 5040(Integer), 5050(Integer), 5060(Integer), 5070(Integer) <== Columns: id, icon, name, state, url, p_id <== Row: 3010, menu-31, 员工信息管理, 0, /admin/employees/employees, 30 <== Total: 1 Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@758acab8] login.allMenu:[{"children":[{"children":[{"attributes":{"url":"/admin/member/members"},"id":1010,"text":"会员信息管理","state":"open","iconCls":"menu-11"},{"attributes":{"url":"/admin/member/mrole"},"id":1020,"text":"会员等级管理","state":"open","iconCls":"menu-12"}],"attributes":{},"id":10,"text":"会员管理","state":"closed","iconCls":"menu-1"},{"children":[{"attributes":{"url":"/admin/goods/coke"},"id":2010,"text":"石油焦信息","state":"open","iconCls":"menu-21"},{"attributes":{"url":"/admin/goods/calcined"},"id":2020,"text":"煅后焦信息","state":"open","iconCls":"menu-22"},{"attributes":{"url":"/admin/goods/asphalt"},"id":2030,"text":"改质沥青信息","state":"open","iconCls":"menu-23"},{"attributes":{"url":"/admin/goods/anode"},"id":2040,"text":"阳极信息","state":"open","iconCls":"menu-24"}],"attributes":{},"id":20,"text":"货品管理","state":"closed","iconCls":"menu-2"},{"children":[{"attributes":{"url":"/admin/power/user"},"id":4010,"text":"后台用户管理","state":"open","iconCls":"menu-41"},{"attributes":{"url":"/admin/auth/roleconfig"},"id":4020,"text":"系统角色管理","state":"open","iconCls":"menu-42"}],"attributes":{},"id":40,"text":"管理员管理","state":"closed","iconCls":"menu-4"},{"children":[{"attributes":{"url":"/admin/auth/menu"},"id":5010,"text":"路径配置","state":"open","iconCls":"menu-51"},{"attributes":{"url":"/admin/auth/dbbackup"},"id":5020,"text":"数据库备份","state":"open","iconCls":"menu-52"},{"attributes":{"url":"/admin/auth/syslog"},"id":5030,"text":"系统日志","state":"open","iconCls":"menu-53"},{"attributes":{"url":"/admin/auth/memberlog"},"id":5040,"text":"会员日志","state":"open","iconCls":"menu-54"},{"attributes":{"url":"/admin/auth/sysconfig"},"id":5050,"text":"系统配置","state":"open","iconCls":"menu-55"},{"attributes":{"url":"/admin/swagger"},"id":5060,"text":"接口文档","state":"open","iconCls":"menu-56"},{"attributes":{"url":"/admin/druid"},"id":5070,"text":"数据库监控","state":"open","iconCls":"menu-57"}],"attributes":{},"id":50,"text":"系统管理","state":"closed","iconCls":"menu-5"},{"children":[{"attributes":{"url":"/admin/employees/employees"},"id":3010,"text":"员工信息管理","state":"open","iconCls":"menu-31"}],"attributes":{},"id":30,"text":"员工管理","state":"closed","iconCls":"menu-3"}],"attributes":{},"id":1,"text":"系统菜单","state":"closed","iconCls":"menu-plugin"}] Creating a new SqlSession SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@74db844b] was not registered for synchronization because synchronization is not active JDBC Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@dec5439] will not be managed by Spring ==> Preparing: select id, name, password, salt from user where name = ? ==> Parameters: zhang3(String) <== Columns: id, name, password, salt <== Row: 5, zhang3, 7429017bd19cc345733399a2fb648cd7, +iaowhMUpqjV47c8Qma0Ng== <== Total: 1 Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@74db844b] Creating a new SqlSession SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@7efda913] was not registered for synchronization because synchronization is not active JDBC Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@dec5439] will not be managed by Spring ==> Preparing: select r.* from user u,role r,user_role ur where ur.uid=u.id AND ur.rid=r.id AND u.id=? ==> Parameters: 5(Integer) <== Columns: id, name, desc_ <== Row: 1, 总管理员, 总管理员 <== Total: 1 Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@7efda913] Creating a new SqlSession SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@3cde6a51] was not registered for synchronization because synchronization is not active JDBC Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@dec5439] will not be managed by Spring ==> Preparing: select m.* from role r,e_menu m,role_menu rm where rm.role_id = r.id and rm.menu_id =m.id and r.id = ? ==> Parameters: 1(Long) <== Columns: id, icon, name, state, url, p_id <== Row: 1, menu-plugin, 系统菜单, 1, null, -1 <== Row: 10, menu-1, 会员管理, 1, null, 1 <== Row: 1010, menu-11, 会员信息管理, 0, /admin/member/members, 10 <== Row: 1020, menu-12, 会员等级管理, 0, /admin/member/mrole, 10 <== Row: 20, menu-2, 货品管理, 1, null, 1 <== Row: 2010, menu-21, 石油焦信息, 0, /admin/goods/coke, 20 <== Row: 2020, menu-22, 煅后焦信息, 0, /admin/goods/calcined, 20 <== Row: 2030, menu-23, 改质沥青信息, 0, /admin/goods/asphalt, 20 <== Row: 2040, menu-24, 阳极信息, 0, /admin/goods/anode, 20 <== Row: 30, menu-3, 员工管理, 1, null, 1 <== Row: 3010, menu-31, 员工信息管理, 0, /admin/employees/employees, 30 <== Row: 40, menu-4, 管理员管理, 1, null, 1 <== Row: 4010, menu-41, 后台用户管理, 0, /admin/power/user, 40 <== Row: 4020, menu-42, 系统角色管理, 0, /admin/auth/roleconfig, 40 <== Row: 50, menu-5, 系统管理, 1, null, 1 <== Row: 5010, menu-51, 路径配置, 0, /admin/auth/menu, 50 <== Row: 5020, menu-52, 数据库备份, 0, /admin/auth/dbbackup, 50 <== Row: 5030, menu-53, 系统日志, 0, /admin/auth/syslog, 50 <== Row: 5040, menu-54, 会员日志, 0, /admin/auth/memberlog, 50 <== Row: 5050, menu-55, 系统配置, 0, /admin/auth/sysconfig, 50 <== Row: 5060, menu-56, 接口文档, 0, /admin/swagger, 50 <== Row: 5070, menu-57, 数据库监控, 0, /admin/druid, 50 <== Total: 22 Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@3cde6a51] 读取系统菜单中 通过redis获取session的menuids+currentUser获取了allMenu
果然,虽然大量的查询让登录缓慢,redis也没有获取数据,但是至少我的else成功执行了判定:
login.allMenu:[{"children":[{"children":[{"attributes":{"url":"/admin/member/members"},"id":1010,"text":"会员信息管理","state":"open","iconCls":"menu-11"},{"attributes":{"url":"/admin/member/mrole"},"id":1020,"text":"会员等级管理","state":"open","iconCls":"menu-12"}],"attributes":{},"id":10,"text":"会员管理","state":"closed","iconCls":"menu-1"},{"children":[{"attributes":{"url":"/admin/goods/coke"},"id":2010,"text":"石油焦信息","state":"open","iconCls":"menu-21"},{"attributes":{"url":"/admin/goods/calcined"},"id":2020,"text":"煅后焦信息","state":"open","iconCls":"menu-22"},{"attributes":{"url":"/admin/goods/asphalt"},"id":2030,"text":"改质沥青信息","state":"open","iconCls":"menu-23"},{"attributes":{"url":"/admin/goods/anode"},"id":2040,"text":"阳极信息","state":"open","iconCls":"menu-24"}],"attributes":{},"id":20,"text":"货品管理","state":"closed","iconCls":"menu-2"},{"children":[{"attributes":{"url":"/admin/power/user"},"id":4010,"text":"后台用户管理","state":"open","iconCls":"menu-41"},{"attributes":{"url":"/admin/auth/roleconfig"},"id":4020,"text":"系统角色管理","state":"open","iconCls":"menu-42"}],"attributes":{},"id":40,"text":"管理员管理","state":"closed","iconCls":"menu-4"},{"children":[{"attributes":{"url":"/admin/auth/menu"},"id":5010,"text":"路径配置","state":"open","iconCls":"menu-51"},{"attributes":{"url":"/admin/auth/dbbackup"},"id":5020,"text":"数据库备份","state":"open","iconCls":"menu-52"},{"attributes":{"url":"/admin/auth/syslog"},"id":5030,"text":"系统日志","state":"open","iconCls":"menu-53"},{"attributes":{"url":"/admin/auth/memberlog"},"id":5040,"text":"会员日志","state":"open","iconCls":"menu-54"},{"attributes":{"url":"/admin/auth/sysconfig"},"id":5050,"text":"系统配置","state":"open","iconCls":"menu-55"},{"attributes":{"url":"/admin/swagger"},"id":5060,"text":"接口文档","state":"open","iconCls":"menu-56"},{"attributes":{"url":"/admin/druid"},"id":5070,"text":"数据库监控","state":"open","iconCls":"menu-57"}],"attributes":{},"id":50,"text":"系统管理","state":"closed","iconCls":"menu-5"},{"children":[{"attributes":{"url":"/admin/employees/employees"},"id":3010,"text":"员工信息管理","state":"open","iconCls":"menu-31"}],"attributes":{},"id":30,"text":"员工管理","state":"closed","iconCls":"menu-3"}],"attributes":{},"id":1,"text":"系统菜单","state":"closed","iconCls":"menu-plugin"}]
上面的数据就是树形菜单的整体数据,这个树形菜单属于这个用户.
清空控制台,退出,重新登录.(不重启项目),看打印:
rememberMe>>>>:null Creating a new SqlSession SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@13f85f9d] was not registered for synchronization because synchronization is not active JDBC Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@dec5439] will not be managed by Spring ==> Preparing: select id, name, password, salt from user where name = ? ==> Parameters: zhang3(String) <== Columns: id, name, password, salt <== Row: 5, zhang3, 7429017bd19cc345733399a2fb648cd7, +iaowhMUpqjV47c8Qma0Ng== <== Total: 1 Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@13f85f9d] Creating a new SqlSession SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@53c81265] was not registered for synchronization because synchronization is not active JDBC Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@dec5439] will not be managed by Spring ==> Preparing: select id, name, password, salt from user where name = ? ==> Parameters: zhang3(String) <== Columns: id, name, password, salt <== Row: 5, zhang3, 7429017bd19cc345733399a2fb648cd7, +iaowhMUpqjV47c8Qma0Ng== <== Total: 1 Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@53c81265] Creating a new SqlSession SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@52bccd57] was not registered for synchronization because synchronization is not active JDBC Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@dec5439] will not be managed by Spring ==> Preparing: select r.* from user u,role r,user_role ur where ur.uid=u.id AND ur.rid=r.id AND u.id=? ==> Parameters: 5(Integer) <== Columns: id, name, desc_ <== Row: 1, 总管理员, 总管理员 <== Total: 1 Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@52bccd57] Creating a new SqlSession SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4b4f6ac3] was not registered for synchronization because synchronization is not active JDBC Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@dec5439] will not be managed by Spring ==> Preparing: select m.* from role r,e_menu m,role_menu rm where rm.role_id = r.id and rm.menu_id =m.id and r.id = ? ==> Parameters: 1(Long) <== Columns: id, icon, name, state, url, p_id <== Row: 1, menu-plugin, 系统菜单, 1, null, -1 <== Row: 10, menu-1, 会员管理, 1, null, 1 <== Row: 1010, menu-11, 会员信息管理, 0, /admin/member/members, 10 <== Row: 1020, menu-12, 会员等级管理, 0, /admin/member/mrole, 10 <== Row: 20, menu-2, 货品管理, 1, null, 1 <== Row: 2010, menu-21, 石油焦信息, 0, /admin/goods/coke, 20 <== Row: 2020, menu-22, 煅后焦信息, 0, /admin/goods/calcined, 20 <== Row: 2030, menu-23, 改质沥青信息, 0, /admin/goods/asphalt, 20 <== Row: 2040, menu-24, 阳极信息, 0, /admin/goods/anode, 20 <== Row: 30, menu-3, 员工管理, 1, null, 1 <== Row: 3010, menu-31, 员工信息管理, 0, /admin/employees/employees, 30 <== Row: 40, menu-4, 管理员管理, 1, null, 1 <== Row: 4010, menu-41, 后台用户管理, 0, /admin/power/user, 40 <== Row: 4020, menu-42, 系统角色管理, 0, /admin/auth/roleconfig, 40 <== Row: 50, menu-5, 系统管理, 1, null, 1 <== Row: 5010, menu-51, 路径配置, 0, /admin/auth/menu, 50 <== Row: 5020, menu-52, 数据库备份, 0, /admin/auth/dbbackup, 50 <== Row: 5030, menu-53, 系统日志, 0, /admin/auth/syslog, 50 <== Row: 5040, menu-54, 会员日志, 0, /admin/auth/memberlog, 50 <== Row: 5050, menu-55, 系统配置, 0, /admin/auth/sysconfig, 50 <== Row: 5060, menu-56, 接口文档, 0, /admin/swagger, 50 <== Row: 5070, menu-57, 数据库监控, 0, /admin/druid, 50 <== Total: 22 Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4b4f6ac3] menuIdStr:2040,40,5020,5010,5070,4010,4020,1010,5050,10,5030,2010,2020,50,2030,30,20,3010,1,1020,5040,5060, (String)allMenuObj:[{"children":[{"children":[{"attributes":{"url":"/admin/member/members"},"id":1010,"text":"会员信息管理","state":"open","iconCls":"menu-11"},{"attributes":{"url":"/admin/member/mrole"},"id":1020,"text":"会员等级管理","state":"open","iconCls":"menu-12"}],"attributes":{},"id":10,"text":"会员管理","state":"closed","iconCls":"menu-1"},{"children":[{"attributes":{"url":"/admin/goods/coke"},"id":2010,"text":"石油焦信息","state":"open","iconCls":"menu-21"},{"attributes":{"url":"/admin/goods/calcined"},"id":2020,"text":"煅后焦信息","state":"open","iconCls":"menu-22"},{"attributes":{"url":"/admin/goods/asphalt"},"id":2030,"text":"改质沥青信息","state":"open","iconCls":"menu-23"},{"attributes":{"url":"/admin/goods/anode"},"id":2040,"text":"阳极信息","state":"open","iconCls":"menu-24"}],"attributes":{},"id":20,"text":"货品管理","state":"closed","iconCls":"menu-2"},{"children":[{"attributes":{"url":"/admin/power/user"},"id":4010,"text":"后台用户管理","state":"open","iconCls":"menu-41"},{"attributes":{"url":"/admin/auth/roleconfig"},"id":4020,"text":"系统角色管理","state":"open","iconCls":"menu-42"}],"attributes":{},"id":40,"text":"管理员管理","state":"closed","iconCls":"menu-4"},{"children":[{"attributes":{"url":"/admin/auth/menu"},"id":5010,"text":"路径配置","state":"open","iconCls":"menu-51"},{"attributes":{"url":"/admin/auth/dbbackup"},"id":5020,"text":"数据库备份","state":"open","iconCls":"menu-52"},{"attributes":{"url":"/admin/auth/syslog"},"id":5030,"text":"系统日志","state":"open","iconCls":"menu-53"},{"attributes":{"url":"/admin/auth/memberlog"},"id":5040,"text":"会员日志","state":"open","iconCls":"menu-54"},{"attributes":{"url":"/admin/auth/sysconfig"},"id":5050,"text":"系统配置","state":"open","iconCls":"menu-55"},{"attributes":{"url":"/admin/swagger"},"id":5060,"text":"接口文档","state":"open","iconCls":"menu-56"},{"attributes":{"url":"/admin/druid"},"id":5070,"text":"数据库监控","state":"open","iconCls":"menu-57"}],"attributes":{},"id":50,"text":"系统管理","state":"closed","iconCls":"menu-5"},{"children":[{"attributes":{"url":"/admin/employees/employees"},"id":3010,"text":"员工信息管理","state":"open","iconCls":"menu-31"}],"attributes":{},"id":30,"text":"员工管理","state":"closed","iconCls":"menu-3"}],"attributes":{},"id":1,"text":"系统菜单","state":"closed","iconCls":"menu-plugin"}] Creating a new SqlSession SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@e980a58] was not registered for synchronization because synchronization is not active JDBC Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@dec5439] will not be managed by Spring ==> Preparing: select id, name, password, salt from user where name = ? ==> Parameters: zhang3(String) <== Columns: id, name, password, salt <== Row: 5, zhang3, 7429017bd19cc345733399a2fb648cd7, +iaowhMUpqjV47c8Qma0Ng== <== Total: 1 Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@e980a58] Creating a new SqlSession SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@12ac1047] was not registered for synchronization because synchronization is not active JDBC Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@dec5439] will not be managed by Spring ==> Preparing: select r.* from user u,role r,user_role ur where ur.uid=u.id AND ur.rid=r.id AND u.id=? ==> Parameters: 5(Integer) <== Columns: id, name, desc_ <== Row: 1, 总管理员, 总管理员 <== Total: 1 Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@12ac1047] Creating a new SqlSession SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@2a6c588a] was not registered for synchronization because synchronization is not active JDBC Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@dec5439] will not be managed by Spring ==> Preparing: select m.* from role r,e_menu m,role_menu rm where rm.role_id = r.id and rm.menu_id =m.id and r.id = ? ==> Parameters: 1(Long) <== Columns: id, icon, name, state, url, p_id <== Row: 1, menu-plugin, 系统菜单, 1, null, -1 <== Row: 10, menu-1, 会员管理, 1, null, 1 <== Row: 1010, menu-11, 会员信息管理, 0, /admin/member/members, 10 <== Row: 1020, menu-12, 会员等级管理, 0, /admin/member/mrole, 10 <== Row: 20, menu-2, 货品管理, 1, null, 1 <== Row: 2010, menu-21, 石油焦信息, 0, /admin/goods/coke, 20 <== Row: 2020, menu-22, 煅后焦信息, 0, /admin/goods/calcined, 20 <== Row: 2030, menu-23, 改质沥青信息, 0, /admin/goods/asphalt, 20 <== Row: 2040, menu-24, 阳极信息, 0, /admin/goods/anode, 20 <== Row: 30, menu-3, 员工管理, 1, null, 1 <== Row: 3010, menu-31, 员工信息管理, 0, /admin/employees/employees, 30 <== Row: 40, menu-4, 管理员管理, 1, null, 1 <== Row: 4010, menu-41, 后台用户管理, 0, /admin/power/user, 40 <== Row: 4020, menu-42, 系统角色管理, 0, /admin/auth/roleconfig, 40 <== Row: 50, menu-5, 系统管理, 1, null, 1 <== Row: 5010, menu-51, 路径配置, 0, /admin/auth/menu, 50 <== Row: 5020, menu-52, 数据库备份, 0, /admin/auth/dbbackup, 50 <== Row: 5030, menu-53, 系统日志, 0, /admin/auth/syslog, 50 <== Row: 5040, menu-54, 会员日志, 0, /admin/auth/memberlog, 50 <== Row: 5050, menu-55, 系统配置, 0, /admin/auth/sysconfig, 50 <== Row: 5060, menu-56, 接口文档, 0, /admin/swagger, 50 <== Row: 5070, menu-57, 数据库监控, 0, /admin/druid, 50 <== Total: 22 Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@2a6c588a] 读取系统菜单中 通过redis获取session的menuids+currentUser获取了allMenu
上面的打印应该是通过if判定.
(String)allMenuObj:[{"children":[{"children":[{"attributes":{"url":"/admin/member/members"},"id":1010,"text":"会员信息管理","state":"open","iconCls":"menu-11"},{"attributes":{"url":"/admin/member/mrole"},"id":1020,"text":"会员等级管理","state":"open","iconCls":"menu-12"}],"attributes":{},"id":10,"text":"会员管理","state":"closed","iconCls":"menu-1"},{"children":[{"attributes":{"url":"/admin/goods/coke"},"id":2010,"text":"石油焦信息","state":"open","iconCls":"menu-21"},{"attributes":{"url":"/admin/goods/calcined"},"id":2020,"text":"煅后焦信息","state":"open","iconCls":"menu-22"},{"attributes":{"url":"/admin/goods/asphalt"},"id":2030,"text":"改质沥青信息","state":"open","iconCls":"menu-23"},{"attributes":{"url":"/admin/goods/anode"},"id":2040,"text":"阳极信息","state":"open","iconCls":"menu-24"}],"attributes":{},"id":20,"text":"货品管理","state":"closed","iconCls":"menu-2"},{"children":[{"attributes":{"url":"/admin/power/user"},"id":4010,"text":"后台用户管理","state":"open","iconCls":"menu-41"},{"attributes":{"url":"/admin/auth/roleconfig"},"id":4020,"text":"系统角色管理","state":"open","iconCls":"menu-42"}],"attributes":{},"id":40,"text":"管理员管理","state":"closed","iconCls":"menu-4"},{"children":[{"attributes":{"url":"/admin/auth/menu"},"id":5010,"text":"路径配置","state":"open","iconCls":"menu-51"},{"attributes":{"url":"/admin/auth/dbbackup"},"id":5020,"text":"数据库备份","state":"open","iconCls":"menu-52"},{"attributes":{"url":"/admin/auth/syslog"},"id":5030,"text":"系统日志","state":"open","iconCls":"menu-53"},{"attributes":{"url":"/admin/auth/memberlog"},"id":5040,"text":"会员日志","state":"open","iconCls":"menu-54"},{"attributes":{"url":"/admin/auth/sysconfig"},"id":5050,"text":"系统配置","state":"open","iconCls":"menu-55"},{"attributes":{"url":"/admin/swagger"},"id":5060,"text":"接口文档","state":"open","iconCls":"menu-56"},{"attributes":{"url":"/admin/druid"},"id":5070,"text":"数据库监控","state":"open","iconCls":"menu-57"}],"attributes":{},"id":50,"text":"系统管理","state":"closed","iconCls":"menu-5"},{"children":[{"attributes":{"url":"/admin/employees/employees"},"id":3010,"text":"员工信息管理","state":"open","iconCls":"menu-31"}],"attributes":{},"id":30,"text":"员工管理","state":"closed","iconCls":"menu-3"}],"attributes":{},"id":1,"text":"系统菜单","state":"closed","iconCls":"menu-plugin"}]
Arrays.sort(menuIdArr); Object allMenuObj = redisService.get(menuIdStr); System.out.println("menuIdStr:" + menuIdStr); if (allMenuObj != null) { redisService.set(menuIdStr, allMenuObj.toString()); System.out.println("(String)allMenuObj:" + (String) allMenuObj); session.setAttribute("menuIds", menuIdArr); redisService.set(session.getAttribute("menuIds"
也就是说,这次的数据是通过redisService.get(menuIdStr)获取的. 自然登录就快了很多,因为不用再查数据库了!
那么问题来了,当该用户的权限被更改,即,该用户能查看的menuId被增或减了,那么redis中的数据是否还能有效地完成更改后的操作呢?
将这次登录的用户的角色改为"程序员"
那么问题又来了,改为程序员之后刷新页面,其实还有当时"总管理员"的查看权限,除非账户重新登录. (这是个问题)
先不管那个了,先重新登录该账户.
这次的是没错的,并且登录时又走了else判定,因为这次菜单集合的str是在redis中没有的.
login.allMenu:[{"children":[{"children":[{"attributes":{"url":"/admin/power/user"},"id":4010,"text":"后台用户管理","state":"open","iconCls":"menu-41"},{"attributes":{"url":"/admin/auth/roleconfig"},"id":4020,"text":"系统角色管理","state":"open","iconCls":"menu-42"}],"attributes":{},"id":40,"text":"管理员管理","state":"closed","iconCls":"menu-4"},{"children":[{"attributes":{"url":"/admin/auth/menu"},"id":5010,"text":"路径配置","state":"open","iconCls":"menu-51"},{"attributes":{"url":"/admin/auth/dbbackup"},"id":5020,"text":"数据库备份","state":"open","iconCls":"menu-52"},{"attributes":{"url":"/admin/auth/syslog"},"id":5030,"text":"系统日志","state":"open","iconCls":"menu-53"},{"attributes":{"url":"/admin/auth/memberlog"},"id":5040,"text":"会员日志","state":"open","iconCls":"menu-54"},{"attributes":{"url":"/admin/auth/sysconfig"},"id":5050,"text":"系统配置","state":"open","iconCls":"menu-55"}],"attributes":{},"id":50,"text":"系统管理","state":"closed","iconCls":"menu-5"}],"attributes":{},"id":1,"text":"系统菜单","state":"closed","iconCls":"menu-plugin"}]
再次登录,很明显,菜单数据会从redis中获取:
(String)allMenuObj:[{"children":[{"children":[{"attributes":{"url":"/admin/power/user"},"id":4010,"text":"后台用户管理","state":"open","iconCls":"menu-41"},{"attributes":{"url":"/admin/auth/roleconfig"},"id":4020,"text":"系统角色管理","state":"open","iconCls":"menu-42"}],"attributes":{},"id":40,"text":"管理员管理","state":"closed","iconCls":"menu-4"},{"children":[{"attributes":{"url":"/admin/auth/menu"},"id":5010,"text":"路径配置","state":"open","iconCls":"menu-51"},{"attributes":{"url":"/admin/auth/dbbackup"},"id":5020,"text":"数据库备份","state":"open","iconCls":"menu-52"},{"attributes":{"url":"/admin/auth/syslog"},"id":5030,"text":"系统日志","state":"open","iconCls":"menu-53"},{"attributes":{"url":"/admin/auth/memberlog"},"id":5040,"text":"会员日志","state":"open","iconCls":"menu-54"},{"attributes":{"url":"/admin/auth/sysconfig"},"id":5050,"text":"系统配置","state":"open","iconCls":"menu-55"}],"attributes":{},"id":50,"text":"系统管理","state":"closed","iconCls":"menu-5"}],"attributes":{},"id":1,"text":"系统菜单","state":"closed","iconCls":"menu-plugin"}]
这次的菜单id字符串 (key)
那么,显然是解决了问题.那么,是否还存在其它更好的方式呢?
又或者,这样的缓存是否有问题呢?
扫一扫
3081
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
