easyui java 树形_（一）easyUI之树形网络

package servlet;

import java.io.IOException;

import java.io.PrintWriter;

import java.sql.Connection;

import java.util.ArrayList;

import java.util.HashMap;

import java.util.List;

import java.util.Map;

import javax.servlet.ServletException;

import javax.servlet.annotation.WebServlet;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import org.apache.commons.dbutils.QueryRunner;

import org.apache.commons.dbutils.handlers.BeanListHandler;

import com.google.gson.Gson;

import bean.Dept;

import util.DBUtil;

/**

* Servlet implementation class DeptServlet

*/

@WebServlet("/servlet/treeGrid")

public class DeptServlet extends HttpServlet {

private static final long serialVersionUID = 1L;

/**

* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)

*/

protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

this.doPost(request, response);

}

/**

* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)

*/

protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

request.setCharacterEncoding("UTF-8");

response.setCharacterEncoding("UTF-8");

response.setContentType("text/html");

PrintWriter out=response.getWriter();

String treeGrid_json="";

String sql="";

Connection conn=null;

try {

conn=DBUtil.getConn();

QueryRunner queryRunner=new QueryRunner();

sql="select * from dept";

List> treeGridData=new ArrayList>();

MapdeptMap=null;

List deptList=queryRunner.query(conn,sql,new BeanListHandler<>(Dept.class));

Map> id_map=new HashMap>();

for(Dept dept:deptList){

deptMap=new HashMap();

deptMap.put("dept_id", dept.getDept_id());

deptMap.put("dept_name", dept.getDept_name());

deptMap.put("salary", dept.getSalary());

deptMap.put("address", dept.getAddress());

id_map.put(dept.getDept_id(), deptMap);

if(dept.getGrade()>2){

deptMap.put("state", "closed");

}

if(dept.getParent_id().equals("0")){

//如果是父节点，则直接添加到treeGridData中

treeGridData.add(deptMap);

}else{

//如果是子节点

MapparenMap=id_map.get(dept.getParent_id());

if (parenMap != null) {

List> children = null;

if (parenMap.get("children") == null) {

// 说明该父节点当前还没有一个子节点

children = new ArrayList>();

} else {

children = (List>) parenMap.get("children");

}

children.add(deptMap);

parenMap.put("children", children);

}

}

}

Gson gson=new Gson();

treeGrid_json=gson.toJson(treeGridData);

out.println(treeGrid_json);

out.flush();

out.close();

} catch (Exception e) {

e.printStackTrace();

}

}

}