1、下载 BladeX-Boot 和 Sword 的工程源码,导入 IDE,导入数据库,安装依赖,启动工程。
2、登陆系统,找到 权限管理 / 数据权限,随便找一条数据,点配置,如下图:
3、在弹出的表单中点 新增:
4、 在 权限名称 一栏随便输入点内容:
5、再在 权限字段 一栏输入点东西,此时会发现 权限名称 输入的内容自动清空了:
6、 继续在其它字段随便输入点内容,然后点击保存:
保存成功,但列表上没有显示出来:
7、 自己去点一下查询按钮,发现报错:
对应的后端打印信息:
前端发送请求的参数 scopeType = undefined 会导致报错 NumberFormatException:
8、自己去点一下 重置 按钮,又能查出来,但是权限名称、权限编号之前明明有填写的,又没有内容,明显是没有保存到数据库。
期待结果:
新增数据权限,填写表单时,权限名称一项,不会自动清空
新增数据权限,填写表单时,规则类型一项,不应该是 undefined
新增数据权限后,查询权限数据列表,应该不会报错,且能成功显示权限数据
实际看到:
新增数据权限,填写表单时,权限名称一项,会自动清空
新增数据权限,填写表单时,规则类型一项,是 undefined
新增数据权限后,查询权限数据列表,报错,且不能成功显示权限数据
产品:Bladex-Boot 、Sword
版本:2.9.1、3.0.1
操作系统:Deepin V20.7
点击 配置 弹出“[参数管理] 数据权限配置”弹窗时,后端对应的日志:
2022-09-09 11:19:37.254 INFO 53931 --- [ XNIO-1 task-1] o.s.core.log.aspect.RequestLogAspect : ================ Request Start ================ ===> GET: /blade-system/dict/dictionary Parameters: {"code":"data_scope_type"} ===Headers=== sec-fetch-mode: cors ===Headers=== referer: http://localhost:8888/ ===Headers=== sec-fetch-site: same-origin ===Headers=== blade-auth: bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzUxMiJ9.eyJpc3MiOiJpc3N1c2VyIiwiYXVkIjoiYXVkaWVuY2UiLCJ0ZW5hbnRfaWQiOiIwMDAwMDAiLCJyb2xlX25hbWUiOiJhZG1pbmlzdHJhdG9yIiwicG9zdF9pZCI6IjExMjM1OTg4MTc3Mzg2NzUyMDEiLCJ1c2VyX2lkIjoiMTEyMzU5ODgyMTczODY3NTIwMSIsInJvbGVfaWQiOiIxMTIzNTk4ODE2NzM4Njc1MjAxIiwidXNlcl9uYW1lIjoiYWRtaW4iLCJuaWNrX25hbWUiOiLnrqHnkIblkZgiLCJkZXRhaWwiOnsidHlwZSI6IndlYiJ9LCJ0b2tlbl90eXBlIjoiYWNjZXNzX3Rva2VuIiwiZGVwdF9pZCI6IjExMjM1OTg4MTM3Mzg2NzUyMDEiLCJhY2NvdW50IjoiYWRtaW4iLCJjbGllbnRfaWQiOiJzd29yZCIsImV4cCI6MTY2MjY5NjgyNywibmJmIjoxNjYyNjkzMjI3fQ.ljbut1pWFHW05sN9SBeS7BLi11R3-1HrjCs_aX0btEE4ZV6jUtNo_raYHLBgqrgvYb3E9MItcAeMpl-s9O0Lmw ===Headers=== accept-language: zh-CN,zh;q=0.9 ===Headers=== cookie: rememberMe=true; XXL_JOB_LOGIN_IDENTITY=7b226964223a312c22757365726e616d65223a2261646d696e222c2270617373776f7264223a226531306164633339343962613539616262653536653035376632306638383365222c22726f6c65223a312c227065726d697373696f6e223a6e756c6c7d; JSESSIONID=0uOtcfDIzsymqnpQ0rbLavZd9pIk0T_Ha2zmipfB; Hm_lvt_8117e2ede53d19f7eace5e3683f6a005=1656898278; Hm_lpvt_8117e2ede53d19f7eace5e3683f6a005=1656898282; sidebarStatus=1; username=admin; password=CJxD+8VO+A250zcuhrSUNQQsdFnw5ptyqhZ7HOtVeL5WaGsLhoOW22m3tYD+F4GxTSt3z8xokmPemfsGyPMq5A==; Admin-Token=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJsb2dpblR5cGUiOiJsb2dpbiIsImxvZ2luSWQiOiJzeXNfdXNlcjoxIiwicm5TdHIiOiJFeGpGTHhjQld3eUVlSXhJem9WQUYySndiZ3ozR0xmMSJ9.lQYvj3gS9b3kYd8ubgauy73E3MZG0AO3q49bMmZhMw8; Hm_lvt_931a8de1263e8fcdea855e1b3c00abff=1661158846; Hm_lpvt_931a8de1263e8fcdea855e1b3c00abff=1661418864 ===Headers=== accept: */* ===Headers=== authorization: Basic c3dvcmQ6c3dvcmRfc2VjcmV0 ===Headers=== sec-ch-ua: "Chromium";v="104", " Not A;Brand";v="99", "Google Chrome";v="104" ===Headers=== sec-ch-ua-mobile: ?0 ===Headers=== sec-ch-ua-platform: "Linux" ===Headers=== host: 127.0.0.1:7033 ===Headers=== connection: close ===Headers=== accept-encoding: gzip, deflate, br ===Headers=== user-agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/104.0.0.0 Safari/537.36 ===Headers=== sec-fetch-dest: empty ================ Request End ================ 2022-09-09 11:19:37.260 INFO 53931 --- [ XNIO-1 task-1] o.s.core.mp.plugins.SqlLogInterceptor : ============== Sql Start ============== Execute SQL : select id, parent_id, code, dict_key, dict_value , sort, remark from blade_dict where code = 'data_scope_type' and parent_id > 0 and is_sealed = 0 and is_deleted = 0 Execute Time: 1.076ms ============== Sql End ============== 2022-09-09 11:19:37.260 INFO 53931 --- [ XNIO-1 task-1] o.s.core.log.aspect.RequestLogAspect : =============== Response Start ================ ===Result=== {"code":200,"success":true,"data":[{"id":"1123598814738675232","parentId":"1123598814738675231","code":"data_scope_type","dictKey":"1","dictValue":"全部可见","sort":1,"remark":null,"isSealed":null,"isDeleted":null},{"id":"1123598814738675233","parentId":"1123598814738675231","code":"data_scope_type","dictKey":"2","dictValue":"本人可见","sort":2,"remark":null,"isSealed":null,"isDeleted":null},{"id":"1123598814738675234","parentId":"1123598814738675231","code":"data_scope_type","dictKey":"3","dictValue":"所在机构可见","sort":3,"remark":null,"isSealed":null,"isDeleted":null},{"id":"1123598814738675235","parentId":"1123598814738675231","code":"data_scope_type","dictKey":"4","dictValue":"所在机构及子级可见","sort":4,"remark":null,"isSealed":null,"isDeleted":null},{"id":"1123598814738675236","parentId":"1123598814738675231","code":"data_scope_type","dictKey":"5","dictValue":"自定义","sort":5,"remark":null,"isSealed":null,"isDeleted":null}],"msg":"操作成功"} <=== GET: /blade-system/dict/dictionary (6 ms) =============== Response End ================ 2022-09-09 11:19:37.378 INFO 53931 --- [ XNIO-1 task-1] o.s.core.log.aspect.RequestLogAspect : ================ Request Start ================ ===> GET: /blade-system/data-scope/list Parameters: {"query":{"current":null,"size":null,"ascs":null,"descs":null},"dataScope":{"id":null,"createUser":null,"createDept":null,"createTime":null,"updateUser":null,"updateTime":null,"status":null,"isDeleted":null,"menuId":1123598815738675209,"resourceCode":null,"scopeName":null,"scopeField":null,"scopeClass":null,"scopeColumn":null,"scopeType":null,"scopeValue":null,"remark":null}} ===Headers=== sec-fetch-mode: cors ===Headers=== referer: http://localhost:8888/ ===Headers=== sec-fetch-site: same-origin ===Headers=== blade-auth: bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzUxMiJ9.eyJpc3MiOiJpc3N1c2VyIiwiYXVkIjoiYXVkaWVuY2UiLCJ0ZW5hbnRfaWQiOiIwMDAwMDAiLCJyb2xlX25hbWUiOiJhZG1pbmlzdHJhdG9yIiwicG9zdF9pZCI6IjExMjM1OTg4MTc3Mzg2NzUyMDEiLCJ1c2VyX2lkIjoiMTEyMzU5ODgyMTczODY3NTIwMSIsInJvbGVfaWQiOiIxMTIzNTk4ODE2NzM4Njc1MjAxIiwidXNlcl9uYW1lIjoiYWRtaW4iLCJuaWNrX25hbWUiOiLnrqHnkIblkZgiLCJkZXRhaWwiOnsidHlwZSI6IndlYiJ9LCJ0b2tlbl90eXBlIjoiYWNjZXNzX3Rva2VuIiwiZGVwdF9pZCI6IjExMjM1OTg4MTM3Mzg2NzUyMDEiLCJhY2NvdW50IjoiYWRtaW4iLCJjbGllbnRfaWQiOiJzd29yZCIsImV4cCI6MTY2MjY5NjgyNywibmJmIjoxNjYyNjkzMjI3fQ.ljbut1pWFHW05sN9SBeS7BLi11R3-1HrjCs_aX0btEE4ZV6jUtNo_raYHLBgqrgvYb3E9MItcAeMpl-s9O0Lmw ===Headers=== accept-language: zh-CN,zh;q=0.9 ===Headers=== cookie: rememberMe=true; XXL_JOB_LOGIN_IDENTITY=7b226964223a312c22757365726e616d65223a2261646d696e222c2270617373776f7264223a226531306164633339343962613539616262653536653035376632306638383365222c22726f6c65223a312c227065726d697373696f6e223a6e756c6c7d; JSESSIONID=0uOtcfDIzsymqnpQ0rbLavZd9pIk0T_Ha2zmipfB; Hm_lvt_8117e2ede53d19f7eace5e3683f6a005=1656898278; Hm_lpvt_8117e2ede53d19f7eace5e3683f6a005=1656898282; sidebarStatus=1; username=admin; password=CJxD+8VO+A250zcuhrSUNQQsdFnw5ptyqhZ7HOtVeL5WaGsLhoOW22m3tYD+F4GxTSt3z8xokmPemfsGyPMq5A==; Admin-Token=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJsb2dpblR5cGUiOiJsb2dpbiIsImxvZ2luSWQiOiJzeXNfdXNlcjoxIiwicm5TdHIiOiJFeGpGTHhjQld3eUVlSXhJem9WQUYySndiZ3ozR0xmMSJ9.lQYvj3gS9b3kYd8ubgauy73E3MZG0AO3q49bMmZhMw8; Hm_lvt_931a8de1263e8fcdea855e1b3c00abff=1661158846; Hm_lpvt_931a8de1263e8fcdea855e1b3c00abff=1661418864 ===Headers=== accept: */* ===Headers=== authorization: Basic c3dvcmQ6c3dvcmRfc2VjcmV0 ===Headers=== sec-ch-ua: "Chromium";v="104", " Not A;Brand";v="99", "Google Chrome";v="104" ===Headers=== sec-ch-ua-mobile: ?0 ===Headers=== sec-ch-ua-platform: "Linux" ===Headers=== host: 127.0.0.1:7033 ===Headers=== connection: close ===Headers=== accept-encoding: gzip, deflate, br ===Headers=== user-agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/104.0.0.0 Safari/537.36 ===Headers=== sec-fetch-dest: empty ================ Request End ================ 2022-09-09 11:19:37.389 INFO 53931 --- [ XNIO-1 task-1] o.s.core.mp.plugins.SqlLogInterceptor : ============== Sql Start ============== Execute SQL : select count(*) as total from blade_scope_data where menu_id = 1123598815738675209 and is_deleted = 0 Execute Time: 1.467ms ============== Sql End ============== 2022-09-09 11:19:37.393 INFO 53931 --- [ XNIO-1 task-1] o.s.core.mp.plugins.SqlLogInterceptor : ============== Sql Start ============== Execute SQL : select id, menu_id, resource_code, scope_name, scope_field , scope_class, scope_column, scope_type, scope_value, remark , create_user, create_dept, create_time, update_user, update_time , status, is_deleted from blade_scope_data where menu_id = 1123598815738675209 and is_deleted = 0 limit 10 Execute Time: 1.162ms ============== Sql End ============== 2022-09-09 11:19:37.442 INFO 53931 --- [ XNIO-1 task-4] o.s.core.log.aspect.RequestLogAspect : ================ Request Start ================ ===> GET: /blade-system/data-scope/list Parameters: {"query":{"current":1,"size":10,"ascs":null,"descs":null},"dataScope":{"id":null,"createUser":null,"createDept":null,"createTime":null,"updateUser":null,"updateTime":null,"status":null,"isDeleted":null,"menuId":1123598815738675209,"resourceCode":null,"scopeName":null,"scopeField":null,"scopeClass":null,"scopeColumn":null,"scopeType":1,"scopeValue":null,"remark":null}} ===Headers=== sec-fetch-mode: cors ===Headers=== referer: http://localhost:8888/ ===Headers=== sec-fetch-site: same-origin ===Headers=== blade-auth: bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzUxMiJ9.eyJpc3MiOiJpc3N1c2VyIiwiYXVkIjoiYXVkaWVuY2UiLCJ0ZW5hbnRfaWQiOiIwMDAwMDAiLCJyb2xlX25hbWUiOiJhZG1pbmlzdHJhdG9yIiwicG9zdF9pZCI6IjExMjM1OTg4MTc3Mzg2NzUyMDEiLCJ1c2VyX2lkIjoiMTEyMzU5ODgyMTczODY3NTIwMSIsInJvbGVfaWQiOiIxMTIzNTk4ODE2NzM4Njc1MjAxIiwidXNlcl9uYW1lIjoiYWRtaW4iLCJuaWNrX25hbWUiOiLnrqHnkIblkZgiLCJkZXRhaWwiOnsidHlwZSI6IndlYiJ9LCJ0b2tlbl90eXBlIjoiYWNjZXNzX3Rva2VuIiwiZGVwdF9pZCI6IjExMjM1OTg4MTM3Mzg2NzUyMDEiLCJhY2NvdW50IjoiYWRtaW4iLCJjbGllbnRfaWQiOiJzd29yZCIsImV4cCI6MTY2MjY5NjgyNywibmJmIjoxNjYyNjkzMjI3fQ.ljbut1pWFHW05sN9SBeS7BLi11R3-1HrjCs_aX0btEE4ZV6jUtNo_raYHLBgqrgvYb3E9MItcAeMpl-s9O0Lmw ===Headers=== accept-language: zh-CN,zh;q=0.9 ===Headers=== cookie: rememberMe=true; XXL_JOB_LOGIN_IDENTITY=7b226964223a312c22757365726e616d65223a2261646d696e222c2270617373776f7264223a226531306164633339343962613539616262653536653035376632306638383365222c22726f6c65223a312c227065726d697373696f6e223a6e756c6c7d; JSESSIONID=0uOtcfDIzsymqnpQ0rbLavZd9pIk0T_Ha2zmipfB; Hm_lvt_8117e2ede53d19f7eace5e3683f6a005=1656898278; Hm_lpvt_8117e2ede53d19f7eace5e3683f6a005=1656898282; sidebarStatus=1; username=admin; password=CJxD+8VO+A250zcuhrSUNQQsdFnw5ptyqhZ7HOtVeL5WaGsLhoOW22m3tYD+F4GxTSt3z8xokmPemfsGyPMq5A==; Admin-Token=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJsb2dpblR5cGUiOiJsb2dpbiIsImxvZ2luSWQiOiJzeXNfdXNlcjoxIiwicm5TdHIiOiJFeGpGTHhjQld3eUVlSXhJem9WQUYySndiZ3ozR0xmMSJ9.lQYvj3gS9b3kYd8ubgauy73E3MZG0AO3q49bMmZhMw8; Hm_lvt_931a8de1263e8fcdea855e1b3c00abff=1661158846; Hm_lpvt_931a8de1263e8fcdea855e1b3c00abff=1661418864 ===Headers=== accept: */* ===Headers=== authorization: Basic c3dvcmQ6c3dvcmRfc2VjcmV0 ===Headers=== sec-ch-ua: "Chromium";v="104", " Not A;Brand";v="99", "Google Chrome";v="104" ===Headers=== sec-ch-ua-mobile: ?0 ===Headers=== sec-ch-ua-platform: "Linux" ===Headers=== host: 127.0.0.1:7033 ===Headers=== connection: close ===Headers=== accept-encoding: gzip, deflate, br ===Headers=== user-agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/104.0.0.0 Safari/537.36 ===Headers=== sec-fetch-dest: empty ================ Request End ================ 2022-09-09 11:19:37.443 INFO 53931 --- [ XNIO-1 task-1] o.s.core.log.aspect.RequestLogAspect : =============== Response Start ================ ===Result=== {"code":200,"success":true,"data":{"records":[{"id":"1568073026364715010","createUser":"1123598821738675201","createDept":"1123598813738675201","createTime":"2022-09-09 11:05:18","updateUser":"1123598821738675201","updateTime":"2022-09-09 11:05:18","status":1,"isDeleted":0,"menuId":1123598815738675209,"resourceCode":null,"scopeName":null,"scopeField":"xx","scopeClass":"xxx","scopeColumn":"bbb","scopeType":3,"scopeValue":"xxxx","remark":"vvvv","scopeTypeName":"所在机构可见"}],"total":1,"size":10,"current":1,"orders":[],"optimizeCountSql":true,"searchCount":true,"countId":null,"maxLimit":null,"pages":1},"msg":"操作成功"} <=== GET: /blade-system/data-scope/list (64 ms) =============== Response End ================ 2022-09-09 11:19:37.460 INFO 53931 --- [ XNIO-1 task-4] o.s.core.mp.plugins.SqlLogInterceptor : ============== Sql Start ============== Execute SQL : select count(*) as total from blade_scope_data where menu_id = 1123598815738675209 and scope_type = 1 and is_deleted = 0 Execute Time: 5.676ms ============== Sql End ============== 2022-09-09 11:19:37.461 INFO 53931 --- [ XNIO-1 task-4] o.s.core.log.aspect.RequestLogAspect : =============== Response Start ================ ===Result=== {"code":200,"success":true,"data":{"records":[],"total":0,"size":10,"current":1,"orders":[],"optimizeCountSql":true,"searchCount":true,"countId":null,"maxLimit":null,"pages":0},"msg":"操作成功"} <=== GET: /blade-system/data-scope/list (18 ms) =============== Response End ================
对应的页面:
在“[参数管理] 数据权限配置”弹窗点击“查询”,对应的后端日志:
2022-09-09 11:22:39.005 INFO 53931 --- [ XNIO-1 task-4] o.s.core.log.aspect.RequestLogAspect : ================ Request Start ================ ===> GET: /blade-system/data-scope/list Parameters: {"query":{"current":1,"size":10,"ascs":null,"descs":null},"dataScope":{"id":null,"createUser":null,"createDept":null,"createTime":null,"updateUser":null,"updateTime":null,"status":null,"isDeleted":null,"menuId":1123598815738675209,"resourceCode":null,"scopeName":null,"scopeField":null,"scopeClass":null,"scopeColumn":null,"scopeType":1,"scopeValue":null,"remark":null}} ===Headers=== sec-fetch-mode: cors ===Headers=== referer: http://localhost:8888/ ===Headers=== sec-fetch-site: same-origin ===Headers=== blade-auth: bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzUxMiJ9.eyJpc3MiOiJpc3N1c2VyIiwiYXVkIjoiYXVkaWVuY2UiLCJ0ZW5hbnRfaWQiOiIwMDAwMDAiLCJyb2xlX25hbWUiOiJhZG1pbmlzdHJhdG9yIiwicG9zdF9pZCI6IjExMjM1OTg4MTc3Mzg2NzUyMDEiLCJ1c2VyX2lkIjoiMTEyMzU5ODgyMTczODY3NTIwMSIsInJvbGVfaWQiOiIxMTIzNTk4ODE2NzM4Njc1MjAxIiwidXNlcl9uYW1lIjoiYWRtaW4iLCJuaWNrX25hbWUiOiLnrqHnkIblkZgiLCJkZXRhaWwiOnsidHlwZSI6IndlYiJ9LCJ0b2tlbl90eXBlIjoiYWNjZXNzX3Rva2VuIiwiZGVwdF9pZCI6IjExMjM1OTg4MTM3Mzg2NzUyMDEiLCJhY2NvdW50IjoiYWRtaW4iLCJjbGllbnRfaWQiOiJzd29yZCIsImV4cCI6MTY2MjY5NjgyNywibmJmIjoxNjYyNjkzMjI3fQ.ljbut1pWFHW05sN9SBeS7BLi11R3-1HrjCs_aX0btEE4ZV6jUtNo_raYHLBgqrgvYb3E9MItcAeMpl-s9O0Lmw ===Headers=== accept-language: zh-CN,zh;q=0.9 ===Headers=== cookie: rememberMe=true; XXL_JOB_LOGIN_IDENTITY=7b226964223a312c22757365726e616d65223a2261646d696e222c2270617373776f7264223a226531306164633339343962613539616262653536653035376632306638383365222c22726f6c65223a312c227065726d697373696f6e223a6e756c6c7d; JSESSIONID=0uOtcfDIzsymqnpQ0rbLavZd9pIk0T_Ha2zmipfB; Hm_lvt_8117e2ede53d19f7eace5e3683f6a005=1656898278; Hm_lpvt_8117e2ede53d19f7eace5e3683f6a005=1656898282; sidebarStatus=1; username=admin; password=CJxD+8VO+A250zcuhrSUNQQsdFnw5ptyqhZ7HOtVeL5WaGsLhoOW22m3tYD+F4GxTSt3z8xokmPemfsGyPMq5A==; Admin-Token=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJsb2dpblR5cGUiOiJsb2dpbiIsImxvZ2luSWQiOiJzeXNfdXNlcjoxIiwicm5TdHIiOiJFeGpGTHhjQld3eUVlSXhJem9WQUYySndiZ3ozR0xmMSJ9.lQYvj3gS9b3kYd8ubgauy73E3MZG0AO3q49bMmZhMw8; Hm_lvt_931a8de1263e8fcdea855e1b3c00abff=1661158846; Hm_lpvt_931a8de1263e8fcdea855e1b3c00abff=1661418864 ===Headers=== accept: */* ===Headers=== authorization: Basic c3dvcmQ6c3dvcmRfc2VjcmV0 ===Headers=== sec-ch-ua: "Chromium";v="104", " Not A;Brand";v="99", "Google Chrome";v="104" ===Headers=== sec-ch-ua-mobile: ?0 ===Headers=== sec-ch-ua-platform: "Linux" ===Headers=== host: 127.0.0.1:7033 ===Headers=== connection: close ===Headers=== accept-encoding: gzip, deflate, br ===Headers=== user-agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/104.0.0.0 Safari/537.36 ===Headers=== sec-fetch-dest: empty ================ Request End ================ 2022-09-09 11:22:39.015 WARN 53931 --- [ XNIO-1 task-4] c.a.druid.pool.DruidAbstractDataSource : discard long time none received connection. , jdbcUrl : jdbc:mysql://localhost:3306/bladex_boot_301?useSSL=false&useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull&transformedBitIsBoolean=true&serverTimezone=GMT%2B8&nullCatalogMeansCurrent=true&allowPublicKeyRetrieval=true, version : 1.2.8, lastPacketReceivedIdleMillis : 181558 2022-09-09 11:22:39.017 WARN 53931 --- [ XNIO-1 task-4] c.a.druid.pool.DruidAbstractDataSource : discard long time none received connection. , jdbcUrl : jdbc:mysql://localhost:3306/bladex_boot_301?useSSL=false&useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull&transformedBitIsBoolean=true&serverTimezone=GMT%2B8&nullCatalogMeansCurrent=true&allowPublicKeyRetrieval=true, version : 1.2.8, lastPacketReceivedIdleMillis : 243270 2022-09-09 11:22:39.052 INFO 53931 --- [ XNIO-1 task-4] o.s.core.mp.plugins.SqlLogInterceptor : ============== Sql Start ============== Execute SQL : select count(*) as total from blade_scope_data where menu_id = 1123598815738675209 and scope_type = 1 and is_deleted = 0 Execute Time: 4.487ms ============== Sql End ============== 2022-09-09 11:22:39.053 INFO 53931 --- [ XNIO-1 task-4] o.s.core.log.aspect.RequestLogAspect : =============== Response Start ================ ===Result=== {"code":200,"success":true,"data":{"records":[],"total":0,"size":10,"current":1,"orders":[],"optimizeCountSql":true,"searchCount":true,"countId":null,"maxLimit":null,"pages":0},"msg":"操作成功"} <=== GET: /blade-system/data-scope/list (47 ms) =============== Response End ================
对应的页面:
在“[参数管理] 数据权限配置”弹窗点击“重置”,对应的后端日志:
2022-09-09 11:24:07.520 INFO 53931 --- [ XNIO-1 task-4] o.s.core.log.aspect.RequestLogAspect : ================ Request Start ================ ===> GET: /blade-system/data-scope/list Parameters: {"query":{"current":1,"size":10,"ascs":null,"descs":null},"dataScope":{"id":null,"createUser":null,"createDept":null,"createTime":null,"updateUser":null,"updateTime":null,"status":null,"isDeleted":null,"menuId":1123598815738675209,"resourceCode":null,"scopeName":null,"scopeField":null,"scopeClass":null,"scopeColumn":null,"scopeType":null,"scopeValue":null,"remark":null}} ===Headers=== sec-fetch-mode: cors ===Headers=== referer: http://localhost:8888/ ===Headers=== sec-fetch-site: same-origin ===Headers=== blade-auth: bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzUxMiJ9.eyJpc3MiOiJpc3N1c2VyIiwiYXVkIjoiYXVkaWVuY2UiLCJ0ZW5hbnRfaWQiOiIwMDAwMDAiLCJyb2xlX25hbWUiOiJhZG1pbmlzdHJhdG9yIiwicG9zdF9pZCI6IjExMjM1OTg4MTc3Mzg2NzUyMDEiLCJ1c2VyX2lkIjoiMTEyMzU5ODgyMTczODY3NTIwMSIsInJvbGVfaWQiOiIxMTIzNTk4ODE2NzM4Njc1MjAxIiwidXNlcl9uYW1lIjoiYWRtaW4iLCJuaWNrX25hbWUiOiLnrqHnkIblkZgiLCJkZXRhaWwiOnsidHlwZSI6IndlYiJ9LCJ0b2tlbl90eXBlIjoiYWNjZXNzX3Rva2VuIiwiZGVwdF9pZCI6IjExMjM1OTg4MTM3Mzg2NzUyMDEiLCJhY2NvdW50IjoiYWRtaW4iLCJjbGllbnRfaWQiOiJzd29yZCIsImV4cCI6MTY2MjY5NjgyNywibmJmIjoxNjYyNjkzMjI3fQ.ljbut1pWFHW05sN9SBeS7BLi11R3-1HrjCs_aX0btEE4ZV6jUtNo_raYHLBgqrgvYb3E9MItcAeMpl-s9O0Lmw ===Headers=== accept-language: zh-CN,zh;q=0.9 ===Headers=== cookie: rememberMe=true; XXL_JOB_LOGIN_IDENTITY=7b226964223a312c22757365726e616d65223a2261646d696e222c2270617373776f7264223a226531306164633339343962613539616262653536653035376632306638383365222c22726f6c65223a312c227065726d697373696f6e223a6e756c6c7d; JSESSIONID=0uOtcfDIzsymqnpQ0rbLavZd9pIk0T_Ha2zmipfB; Hm_lvt_8117e2ede53d19f7eace5e3683f6a005=1656898278; Hm_lpvt_8117e2ede53d19f7eace5e3683f6a005=1656898282; sidebarStatus=1; username=admin; password=CJxD+8VO+A250zcuhrSUNQQsdFnw5ptyqhZ7HOtVeL5WaGsLhoOW22m3tYD+F4GxTSt3z8xokmPemfsGyPMq5A==; Admin-Token=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJsb2dpblR5cGUiOiJsb2dpbiIsImxvZ2luSWQiOiJzeXNfdXNlcjoxIiwicm5TdHIiOiJFeGpGTHhjQld3eUVlSXhJem9WQUYySndiZ3ozR0xmMSJ9.lQYvj3gS9b3kYd8ubgauy73E3MZG0AO3q49bMmZhMw8; Hm_lvt_931a8de1263e8fcdea855e1b3c00abff=1661158846; Hm_lpvt_931a8de1263e8fcdea855e1b3c00abff=1661418864 ===Headers=== accept: */* ===Headers=== authorization: Basic c3dvcmQ6c3dvcmRfc2VjcmV0 ===Headers=== sec-ch-ua: "Chromium";v="104", " Not A;Brand";v="99", "Google Chrome";v="104" ===Headers=== sec-ch-ua-mobile: ?0 ===Headers=== sec-ch-ua-platform: "Linux" ===Headers=== host: 127.0.0.1:7033 ===Headers=== connection: close ===Headers=== accept-encoding: gzip, deflate, br ===Headers=== user-agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/104.0.0.0 Safari/537.36 ===Headers=== sec-fetch-dest: empty ================ Request End ================ 2022-09-09 11:24:07.535 WARN 53931 --- [ XNIO-1 task-4] c.a.druid.pool.DruidAbstractDataSource : discard long time none received connection. , jdbcUrl : jdbc:mysql://localhost:3306/bladex_boot_301?useSSL=false&useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull&transformedBitIsBoolean=true&serverTimezone=GMT%2B8&nullCatalogMeansCurrent=true&allowPublicKeyRetrieval=true, version : 1.2.8, lastPacketReceivedIdleMillis : 88476 2022-09-09 11:24:07.542 INFO 53931 --- [ XNIO-1 task-4] o.s.core.mp.plugins.SqlLogInterceptor : ============== Sql Start ============== Execute SQL : select count(*) as total from blade_scope_data where menu_id = 1123598815738675209 and is_deleted = 0 Execute Time: 2.753ms ============== Sql End ============== 2022-09-09 11:24:07.548 INFO 53931 --- [ XNIO-1 task-4] o.s.core.mp.plugins.SqlLogInterceptor : ============== Sql Start ============== Execute SQL : select id, menu_id, resource_code, scope_name, scope_field , scope_class, scope_column, scope_type, scope_value, remark , create_user, create_dept, create_time, update_user, update_time , status, is_deleted from blade_scope_data where menu_id = 1123598815738675209 and is_deleted = 0 limit 10 Execute Time: 1.830ms ============== Sql End ============== 2022-09-09 11:24:07.551 INFO 53931 --- [ XNIO-1 task-4] o.s.core.log.aspect.RequestLogAspect : =============== Response Start ================ ===Result=== {"code":200,"success":true,"data":{"records":[{"id":"1568073026364715010","createUser":"1123598821738675201","createDept":"1123598813738675201","createTime":"2022-09-09 11:05:18","updateUser":"1123598821738675201","updateTime":"2022-09-09 11:05:18","status":1,"isDeleted":0,"menuId":1123598815738675209,"resourceCode":null,"scopeName":null,"scopeField":"xx","scopeClass":"xxx","scopeColumn":"bbb","scopeType":3,"scopeValue":"xxxx","remark":"vvvv","scopeTypeName":"所在机构可见"}],"total":1,"size":10,"current":1,"orders":[],"optimizeCountSql":true,"searchCount":true,"countId":null,"maxLimit":null,"pages":1},"msg":"操作成功"} <=== GET: /blade-system/data-scope/list (31 ms) =============== Response End ================
对应的页面:
扫一扫访问 Blade技术社区 移动端