[Redis] - redis实战1

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)

 

那么,显然是解决了问题.那么,是否还存在其它更好的方式呢?

又或者,这样的缓存是否有问题呢?