权限管理--权限资源管理

来源：互联网发布：淘宝网怎么没有一淘了编辑：程序博客网时间：2024/05/16 15:34

一:界面展示

1：主界面

主界面时用的easyUi的treeGrid进行展示的

2：新增界面

3：修改界面

二：难点解析

1：treeGrid 的数据展示

treegrid 的疏解格式有两种格式

（1）基本的数据类型

[{      "id":1,      "name":"C",      "size":"",      "date":"02/19/2010",      "children":[{          "id":2,          "name":"Program Files",          "size":"120 MB",          "date":"03/20/2010",          "children":[{              "id":21,              "name":"Java",              "size":"",              "date":"01/13/2010",              "state":"closed",              "children":[{                  "id":211,                  "name":"java.exe",                  "size":"142 KB",                  "date":"01/13/2010"              },{                  "id":212,                  "name":"jawt.dll",                  "size":"5 KB",                  "date":"01/13/2010"              }]          },{              "id":22,              "name":"MySQL",              "size":"",              "date":"01/13/2010",              "state":"closed",              "children":[{                  "id":221,                  "name":"my.ini",                  "size":"10 KB",                  "date":"02/26/2009"              },{                  "id":222,                  "name":"my-huge.ini",                  "size":"5 KB",                  "date":"02/26/2009"              },{                  "id":223,                  "name":"my-large.ini",                  "size":"5 KB",                  "date":"02/26/2009"              }]          }]      },{          "id":3,          "name":"eclipse",          "size":"",          "date":"01/20/2010",          "children":[{              "id":31,              "name":"eclipse.exe",              "size":"56 KB",              "date":"05/19/2009"          },{              "id":32,              "name":"eclipse.ini",              "size":"1 KB",              "date":"04/20/2010"          },{              "id":33,              "name":"notice.html",              "size":"7 KB",              "date":"03/17/2005"          }]      }]  }]

（2）简单的数据类型

{"total":7,"rows":[      {"id":1,"name":"All Tasks","begin":"3/4/2010","end":"3/20/2010","progress":60,"iconCls":"icon-ok"},      {"id":2,"name":"Designing","begin":"3/4/2010","end":"3/10/2010","progress":100,"_parentId":1,"state":"closed"},      {"id":21,"name":"Database","persons":2,"begin":"3/4/2010","end":"3/6/2010","progress":100,"_parentId":2},      {"id":22,"name":"UML","persons":1,"begin":"3/7/2010","end":"3/8/2010","progress":100,"_parentId":2},      {"id":23,"name":"Export Document","persons":1,"begin":"3/9/2010","end":"3/10/2010","progress":100,"_parentId":2},      {"id":3,"name":"Coding","persons":2,"begin":"3/11/2010","end":"3/18/2010","progress":80},      {"id":4,"name":"Testing","persons":1,"begin":"3/19/2010","end":"3/20/2010","progress":20}  ],"footer":[      {"name":"Total Persons:","persons":7,"iconCls":"icon-sum"}  ]}

基本的数据类型的话和之前加载tree组件的数据类型是一样的，在此就不在多说。

简单的数据类型的有一个小的坑么就是上级父节点的关键字必须为“_parentId”,把握住这一点，结合下面的一篇文章就能够轻轻松松解决。

点击打开链接

2：删除时根据父节点时删除其下所有关联节点 ---connect by prior 递归算法

当用户删除权限时，需要把其下的所有权限都删掉。倘若父级权限不存在，再多的下级权限也变的无意义。

sql如下

delete from sys_res_info where res_id in (SELECT res_id                    FROM sys_res_info                  CONNECT BY PRIOR res_id = res_parent_id                   start WITH res_id = #{resId})

阅读全文

0 0