Java easyui树形表格TreeGrid的实现代码

2019-11-26 12:48:14

字体：大中小

来源：转载

供稿：网友

自己搞了一下午，终于用JAVA实现了数据网格。记录一下实现的代码。（PS：此处的easyui是1.5版本，楼主只贴了核心的代码）

实现图

JSP页面

<head>//权限列表$( document ).ready(function(){      var parentId = 0;      $('#tt').treegrid({          url:'queryPrivilege.action?parentId='+parentId,          idField:'id',          treeField:'RecordStatus',        columns:[[            {title:'id',field:'id',width:180},           {field:'RecordStatus',title:'RecordStatus',width:180} ,          {field:'PrivilegeOperation',title:'PrivilegeOperation',width:180}          ]],        onBeforeExpand:function(row){          //动态设置展开查询的url          $(this).treegrid('options').url = 'queryPrivilege.action?parentId='+row.id;          }      });     }) </script> </head> <body><table id="tt" style="width:600px;height:400px"></table></body>

ACTION层代码

  //输出    public PrintWriter out()throws IOException{      HttpServletResponse response=ServletActionContext.getResponse();       response.setContentType("text/html");       response.setContentType("text/plain; charset=utf-8");      PrintWriter out= response.getWriter();      return out;    }    public String queryPrivilege() throws IOException{    returnpd="ok";    JSONArray array =new JSONArray();        array = privilegeService.getMenu(parentId);    String str=array.toString();    out().print(str);    out().flush();    out().close();    return returnpd;  }

Service层接口代码

JSONArray getMenu(int parentId);

ServiceImpl层代码（实现service层）

@Override  public JSONArray getMenu(int parentId) {    // TODO Auto-generated method stub    return (JSONArray)privilegeDao.getMenu(parentId);  }

Dao层代码

JSONArray getMenu(int parentId);

DaoImpl层代码（实现Dao层）

  @Override  public JSONArray getMenu(int parentId) {    // TODO Auto-generated method stub    String hql="";    JSONArray array=new JSONArray();    hql="FROM Privilege p WHERE p.parentID = "+parentId;    for(Privilege privilege:(List<Privilege>)(getSession().createQuery(hql).list())){      JSONObject jo=new JSONObject();      jo.put("id", privilege.getId());      jo.put("RecordStatus", privilege.getRecordStatus());      jo.put("parendId",privilege.getParentID());       if(privilege.getParentID()==0){          jo.put("state","closed");                }        else{          jo.put("state","open");          System.out.println(parentId);        }      array.add(jo);    }    return array;  }

数据库一览