jquery easyUI tree 后台实现代码

最新推荐文章于 2021-09-13 09:44:48 发布

xuj085128

最新推荐文章于 2021-09-13 09:44:48 发布

阅读量423

点赞数

文章标签： javascript java json ViewUI

本文链接：https://blog.csdn.net/xuj085128/article/details/84173204

版权

根据demo

jquery easyUI tree的树形格式的json形式为

[{
"id":1,
"text":"Folder1",
"iconCls":"icon-ok",
"children":[{
  "id":2,
  "text":"File1",
  "checked":true
},{
  "id":3,
  "text":"Folder2",
  "state":"open",
  "children":[{
   "id":4,
   "text":"File3",
   "attributes":{
    "p1":"value1",
    "p2":"value2"
   },
   "checked":true,
   "iconCls":"icon-reload"
  },{
   "id": 8,
   "text":"Async Folder",
   "state":"closed"
  }]
}]
},{
"text":"Languages",
"state":"closed",
"children":[{
  "id":"j1",
  "text":"Java"
},{
  "id":"j2",
  "text":"C#"
}]
}]

前台调用代码：

<%@ page language="java" contentType="text/html;charset=UTF-8"
errorPage=""%>
<%@ include file="/admin/CommonFiles/struts.jsp" %>
<html>
<head>
  <title>信息发布平台</title>
  <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  <link rel="stylesheet" type="text/css" href="${ctx}/admin/css/easyui.css"></link>
  <script type="text/javascript" src="${ctx}/admin/js/jquery-1.4.2.js"></script>
  <script type="text/javascript" src="${ctx}/admin/js/jquery.easyui.min.js"></script>
  <link rel="stylesheet" href="${ctx}/admin/style.css" type="text/css">
  <script type="text/javascript">

  $(function(){
   $('#tt2').tree({
    checkbox: true,
    url: '${ctx}/ItemTree.do?method=createTree',
    onClick:function(node){
     $(this).tree('toggle', node.target);
     var ss=node.attributes.cas.toString();//p1
     alert('you click '+ss);
    },
    onContextMenu: function(e, node){
     e.preventDefault();
     $('#tt2').tree('select', node.target);
     $('#mm').menu('show', {
      left: e.pageX,
      top: e.pageY
     });
    }
   });
  });

  </script>
</head>
<body bgcolor="#EBF1FA" leftmargin="5" topmargin="5" marginwidth="0"
  marginheight="0">
   <ul id="tt2"></ul>
</body>
</html>

后台服务端的递归代码(遍历每一个节点)：

/**
* @param mapping
* @param form
* @param request
* @param response
* @return
* @throws Exception
*/
public ActionForward createTree(ActionMapping mapping, ActionForm form,
   HttpServletRequest request, HttpServletResponse response)
   throws Exception {
  m_objsa = (SessionAdmin) request.getSession().getAttribute("amUser");
  int parentid=NumberUtils.stringToInt(request.getParameter("xxxx"));
  String state="";
  String sel="";

  List<TreeDto> list = new ArrayList<TreeDto>();

  createTree(parentid,state,sel,list);


  String str =JSONArray.fromObject(list).toString();

  //返回结果到前台
  response.getWriter().write(str);
  response.getWriter().flush();
  response.getWriter().close();

  return null;

}
//显示树型主函数，递归，选择所属栏目用，sel已选中的ID，curitem当前栏目ID
//添加内容的时候，选择所属栏目
public List<TreeDto> createTree(int parentid,String state,String sel,List<TreeDto> list2) throws SQLException
{

//  list2=new ArrayList<TreeDto>();
  ArrayList<TreeDto> al = getPrivateSubItem(parentid);
  if(al != null && !al.isEmpty())
  {
   int n = al.size();
   for(int i = 0; i < n;i++)
   {
    TreeDto o = (TreeDto)al.get(i);

    //不包含子菜单
    if(!isHaveSubItem(o.getId()))
    {
    }else{
     List<TreeDto> list333=new ArrayList<TreeDto>();
     o.setChildren(createTree(o.getId(), state, sel,list333));
    }

    list2.add(o);

   }
  }

  return al;
}

//检索

private ArrayList<TreeDto> getPrivateSubItem(int parentid) throws SQLException
{
  m_strSql = new StringBuffer();
  m_strSql.append("Select ID,Name From Item Where IsAuditing = 1");
  m_strSql.append("And WebID = " + m_objsa.getWebID());
//  if(!m_objsa.isWebSuperAdmin())
//   m_strSql.append(" And '" + m_objsa.getItemPower() + "' Like '%' + CONVERT(varchar,ID) + '_0%'");
  m_strSql.append(" And ParentID = " + parentid);


  Connection conn = null;
  PreparedStatement stmt = null;
  ResultSet rs = null;
  ArrayList<TreeDto> al = new ArrayList<TreeDto>();
  try {
   conn = this.getSqlSession().getConnection();
   stmt = conn.prepareStatement(m_strSql.toString());
   rs = stmt.executeQuery();

   if(rs!=null){
    while(rs.next())
    {
     TreeDto o = new TreeDto();
     o.setId(rs.getInt("ID"));
     o.setText(rs.getString("Name"));
     al.add(o);
    }
   }

  }catch(Exception se){
   se.printStackTrace();
  }finally{
   DBUtils.close(rs, stmt, conn);
  }

  return al;
}

//判断是否具有子节点

private boolean isHaveSubItem(int parentid) throws SQLException
{
  m_strSql = new StringBuffer();
  m_strSql.append("Select Count(ID) as C From Item Where IsAuditing = 1 And WebID = " + m_objsa.getWebID());
  m_strSql.append(" And ParentID = " + parentid);

  Connection conn = null;
  PreparedStatement stmt = null;
  ResultSet rs = null;

  try {
   conn = this.getSqlSession().getConnection();
   stmt = conn.prepareStatement(m_strSql.toString());
   rs = stmt.executeQuery();

   if(rs.next() && rs != null)
   {
    int i = rs.getInt("C");
    rs.close();
    return i > 0;
   }

  }catch(Exception se){
   se.printStackTrace();
  }finally{
   DBUtils.close(rs, stmt, conn);
  }

  return false;
}

xuj085128

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
jquery easyUI tree 后台实现代码

根据demojquery easyUI tree的树形格式的json形式为[{ "id":1, "text":"Folder1", "iconCls":"icon-ok", "children":[{ "id":2, "text":"File1", "checked":true },{ &quo
复制链接

扫一扫