orgxloadtreeserver.java

VC++

package com.sinosoft.security.util.maxtree.servlet;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.util.List;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.jdom.Document;
import org.jdom.Element;
import org.jdom.xpath.XPath;

import com.sinosoft.security.util.SecurityUtil;
import com.sinosoft.security.util.maxtree.MaxTree;
import com.sinosoft.security.util.maxtree.MaxTreeFactory;
import com.sinosoft.security.util.maxtree.MaxTreeItem;
import com.sinosoft.utility.ExeSQL;
import com.sinosoft.utility.SSRS;
import common.DBManager;
import common.MMException;

public class OrgXloadTreeServer extends HttpServlet {

	private static final String CONTENT_TYPE = "text/html; charset=GBK";

	// Initialize global variables
	public void init() throws ServletException {

	}

	// Process the HTTP Get request
	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		System.out.println("-----start run ShowNodeHandler-----");
		this.doPost(request, response);
	}

	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		PrintWriter out = response.getWriter();
		response.setContentType("text/xml");
		String nodeid = request.getParameter("nodeid");
		out.println("<?xml version=\"1.0\" encoding=\"gb2312\"?>");
		out.println("<tree>");
		Connection conn = null;
		try {
			conn = DBManager.getConnect();
			String sql = "select * from subjectsort where type=9 and length(code)='13'  and parentid="
					+ nodeid + " order by orderid,nodeid";
			ExeSQL es = new ExeSQL(conn);
			SSRS sr = es.execSQL(sql);
			for (int i = 1; i <= sr.getMaxRow(); i++) {
				String nodename = sr.GetText(i, 5);
				String nodecode = sr.GetText(i, 4);
				String forwardid = sr.GetText(i, 7);
				String itemnodeid = sr.GetText(i, 1);
				String number = "0";
				if (!forwardid.equalsIgnoreCase("")) {
					String metasql = "select count(*) from metadata where length(metaid)=8 and examstatus='2' and regtype='0' and inforesno like '%"
							+ forwardid + "%'";
					SSRS sr3 = es.execSQL(metasql);
					if (sr3.getMaxRow() > 0)
						number = sr3.GetText(1, 1);
				}
				MaxTreeItem item = (MaxTreeItem) MaxTreeFactory
						.getBean("MaxTreeItem");
				item.setSText(nodename + "(" + number + ")");
				item.setSID(nodecode);
				item.setSXmlSrc("/OrgXloadTreeServer?nodeid=" + itemnodeid);
				item.setSAction("javascript:clickNode('" + nodename + "','"
						+ forwardid + "')");
				String str = item.toXML();
				str = new String(str.getBytes("gb2312"), "ISO8859_1");
				out.println(str);
			}
			out.println("</tree>");

		} catch (MMException e) {
			e.printStackTrace();
		} finally {
			try {
				conn.close();
			} catch (Exception e) {
				e.printStackTrace();
			}
		}

	}

	// Clean up resources
	public void destroy() {
	}

}