optxloadtreeserver.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 OptXloadTreeServer 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 orgcode = request.getParameter("orgcode");
		String orgid = request.getParameter("orgid");
		out.println("<?xml version=\"1.0\" encoding=\"gb2312\"?>");
		out.println("<tree>");
		Connection conn = null;
		try {
			conn = DBManager.getConnect();
			String sql = "";
			if (orgcode != null)
				sql = "select * from metadata where length(metaid)=8 and examstatus='2' and regtype='0' and resporgcode='"
						+ orgcode + "'";
			else
				sql = "select * from subjectsort where type=9 and length(code)='13'  and parentid="
						+ orgid + " order by orderid,nodeid";
			ExeSQL es = new ExeSQL(conn);
			SSRS sr = es.execSQL(sql);

			if (sr.getMaxRow() > 0) {
				for (int i = 1; i <= sr.getMaxRow(); i++) {

					MaxTreeItem item = (MaxTreeItem) MaxTreeFactory
							.getBean("MaxTreeItem");

					// item.setSXmlSrc("/OptXloadTreeServer?pmetaid=" + metaid);
					if (orgcode != null) {
						String metaname = sr.GetText(i, 4);
						String metaid = sr.GetText(i, 1);
						item.setSText(metaname);
						item.setSID(metaid);
						item.setSAction("javascript:clickMetaNode('" + metaid
								+ "')");
						item.setSIcon("../global/images/tree/file.png");
						// item.setSOpenIcon("../global/images/tree/normal.gif");
					} else {
						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 metasql = "select count(*) from metadata where length(metaid)=8 and examstatus='2' and regtype='0' and inforesno like '%"
								+ forwardid + "%'";
						SSRS sr3 = es.execSQL(metasql);
						String number = "0";
						if (!forwardid.equalsIgnoreCase("")) {
							if (sr3.getMaxRow() > 0)
								number = sr3.GetText(1, 1);
						}
						item.setSText(nodename + "(" + number + ")");
						item.setSID(nodecode);
						item.setSAction("javascript:clickNode('" + nodename
								+ "','" + forwardid + "')");
						item.setSXmlSrc("/OptXloadTreeServer?orgcode="
								+ nodecode);
					}
					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();
			}
		}

	}

	// public void doPost(HttpServletRequest request, HttpServletResponse
	// response)
	// throws ServletException, IOException {
	// PrintWriter out = response.getWriter();
	// response.setContentType("text/xml");
	// String opt = request.getParameter("opt");
	// String pmetaid = request.getParameter("pmetaid");
	// out.println("<?xml version=\"1.0\" encoding=\"gb2312\"?>");
	// out.println("<tree>");
	// Connection conn = null;
	// try {
	// conn = DBManager.getConnect();
	// String sql = "";
	// if (opt != null)
	// sql = "select * from metadata where length(metaid)=8 and relatedeal='"
	// + opt + "'";
	// else
	// sql = "select * from metadata where (length(metaid)=length("
	// + pmetaid + ")+8) and metaid like '%" + pmetaid + "%'";
	// ExeSQL es = new ExeSQL(conn);
	// SSRS sr = es.execSQL(sql);
	//
	// if (sr.getMaxRow() > 0) {
	// for (int i = 1; i <= sr.getMaxRow(); i++) {
	// String metaname = sr.GetText(i, 4);
	// String metaid = sr.GetText(i, 1);
	// MaxTreeItem item = (MaxTreeItem) MaxTreeFactory
	// .getBean("MaxTreeItem");
	// item.setSText(metaname);
	// item.setSID(metaid);
	// item.setSXmlSrc("/OptXloadTreeServer?pmetaid=" + metaid);
	// item.setSAction("javascript:clickMetaNode('" + metaid + "')");
	// 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() {
	}

}