本文共 1871 字，大约阅读时间需要 6 分钟。
JSP代码片段
<%@ page language="java" contentType="text/html; charset=utf-8" pageEncoding="utf-8"%> Insert title here
action处理如下
public void getNodeData() { List > nodedata = service.getNodes(this.getId()); List > list = new ArrayList >(); Map tmp = null; for (Map map : nodedata) { tmp = new HashMap (); tmp.put("id", map.get("id")); tmp.put("name", map.get("name")); tmp.put("isParent", Integer.valueOf(map.get("cnt").toString()) > 0 ? true : false); list.add(tmp); } try { PrintWriter out; JSONObject jo = new JSONObject(); response.setCharacterEncoding("gbk"); response.setContentType("text/html; charset=GBK"); out = response.getWriter(); System.out.println(JSONArray.fromObject(list).toString()); out.print(JSONArray.fromObject(list).toString()); out.close(); } catch (IOException e) { e.printStackTrace(); } }
Service处理如下
public List > getNodes(String id) { return dao.getNodes(id); }
Dao处理如下
public List > getNodes(String id) { List params = new ArrayList (); StringBuffer querySQL = new StringBuffer(); querySQL.append("SELECT tt.wsystemcode id,tt.wsystemname name"); querySQL.append(",(SELECT COUNT (1) cnt FROM datacenter_v3.tcode.t_cod_wsystem t WHERE t.parentcode = tt.wsystemcode) cnt"); querySQL.append(" FROM datacenter_v3.tcode.t_cod_wsystem tt"); querySQL.append(" WHERE 1=1"); if(Tool.isNull(id)){ querySQL.append(" and tt.parentcode is null"); }else{ querySQL.append(" and tt.parentcode = ?"); params.add(id); } querySQL.append(" GROUP BY tt.wsystemcode,tt.wsystemname"); querySQL.append(" ORDER BY tt.wsystemcode"); return search(querySQL.toString(), params.toArray()); }
转载于:https://www.cnblogs.com/fxfly/p/4642221.html