EXTjs+oracle

package TreePage; import java.io.IOException; import java.util.List; import test.getConns; import java.util.*; import javax.servlet.Servlet; import javax.servlet.ServletException; import javax.servlet.ServletOutputStream; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import java.sql.Date; import net.sf.json.JSONArray; public class TreeTest extends HttpServlet implements Servlet { GetTree tree =new GetTree(); public void getsubTree(HttpServletRequest request,HttpServletResponse response){ try{ response.setHeader("Cache-Control","no-store"); response.setHeader("Pragma","no-cache"); response.setContentType("text/xml;charset=utf-8"); ServletOutputStream sos = response.getOutputStream(); int id =Integer.parseInt(request.getParameter("id")); System.out.println(id); List list= tree.getTree(id); StringBuffer JSONStr = new StringBuffer(); //声明json JSONStr.append("["); Iterator it=list.iterator(); String target ="mainFrame"; while(it.hasNext()){ Tree i=(Tree) it.next(); boolean isLeaf = tree.getleaf(i.getId()); //isLeaf()为判断是否有以该id为parentId的节点，具体没有给出 String icon = isLeaf?"file":"folder"; // String target="myframe"; JSONStr.append("{\"text\":\""+ i.getText()+"\",\"id\":\""+ i.getId()+"\",\"leaf\":"+ isLeaf+",\"hrefTarget\":\""+target+"\",\"cls\":\""+icon+"\",\"href\":\""+i.getHref()+"\"},"); // "\"field\":{\"title\":\""+i.getText()+"\",\"url\":\""+i.getHref()+"\",\"Did\":\""+i.getId()+"\"}},"); } JSONStr.deleteCharAt(JSONStr.lastIndexOf(",")); JSONStr.append("]"); System.out.println(JSONStr); sos.print(JSONStr.toString()); }catch(Exception e){ e.printStackTrace(); } } //根据id生成树 public void getsubdept(HttpServletRequest request, HttpServletResponse response){ try{ ServletOutputStream sos = response.getOutputStream(); response.setHeader("Cache-Control","no-store"); response.setHeader("Pragma","no-cache"); response.setContentType("text/xml;charset=utf-8"); int id =Integer.parseInt(request.getParameter("id")); System.out.println(id); List list =tree.getTree(id); Iterator it=list.iterator(); Object value = new Object(); while(it.hasNext()){ Tree tree=(Tree) it.next(); } JSONArray jsonArray = JSONArray.fromObject(list); sos.println(jsonArray.toString()); }catch(Exception e){ e.printStackTrace(); } } protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { getsubTree(request,response); } protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { getsubTree(request,response); } }