getnodesaction.java

一个简单ssh+extjs的人力资源管理系统（转载）

/*
 * Generated by MyEclipse Struts
 * Template path: templates/java/JavaClass.vtl
 */
package com.idealab.struts.action;

import java.io.PrintWriter;
import java.util.ArrayList;
import java.util.List;
import java.util.Map;
import java.sql.ResultSet;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;
import net.sf.json.JSONObject;
import net.sf.json.JSONArray;

import com.idealab.dao.TreeNode;
import com.idealab.util.JdbcUtil;

/**
 * MyEclipse Struts Creation date: 02-23-2009
 * 
 * XDoclet definition:
 * 
 * @struts.action validate="true"
 */
public class GetNodesAction extends Action {
	/*
	 * Generated Methods
	 */

	/**
	 * Method execute
	 * 
	 * @param mapping
	 * @param form
	 * @param request
	 * @param response
	 * @return ActionForward
	 */
	public ActionForward execute(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response)
			throws Exception {
		PrintWriter writer = response.getWriter();
		response.setCharacterEncoding("UTF-8");
		response.setContentType("text/html;charset=utf8");
		String nodeType = request.getParameter("type");

		JdbcUtil jdbc = new JdbcUtil();
		
		if (nodeType.equals("dept")) {// 获得部门树
			String sql = "select * from dept";
			jdbc.openConn();
			ResultSet rs = jdbc.executeQuery(sql);
			List<TreeNode> nodes = new ArrayList();
			
			while (rs.next()) {
				TreeNode node = new TreeNode();
				node.setId(rs.getInt("pk_dept"));
				node.setText(rs.getString("deptname"));
				node.setLeaf(true);
				nodes.add(node);
			}
			rs.close();
			jdbc.closeConn();

			JSONArray jsonDepts = JSONArray.fromObject(nodes);
			writer.write(jsonDepts.toString());
			
		} else if (nodeType.equals("post")) {// 获得职务树
			jdbc.openConn();
			String sql = "select * from post";
			ResultSet rs = jdbc.executeQuery(sql);
			List<TreeNode> nodes = new ArrayList();
			
			while (rs.next()) {
				TreeNode node = new TreeNode();
				node.setId(rs.getInt("pk_post"));
				node.setText(rs.getString("postname"));
				node.setLeaf(true);
				nodes.add(node);
			}
			rs.close();
			jdbc.closeConn();

			JSONArray jsonPosts = JSONArray.fromObject(nodes);
			writer.write(jsonPosts.toString());
			
		} else if (nodeType.equals("emptype")) {// 获得人员类别树
			jdbc.openConn();
			String sql = "select * from emptype";
			ResultSet rs = jdbc.executeQuery(sql);

			List<TreeNode> nodes = new ArrayList();
			while (rs.next()) {
				TreeNode node = new TreeNode();
				node.setId(rs.getInt("pk_emptype"));
				node.setText(rs.getString("typename"));
				node.setLeaf(true);
				nodes.add(node);
			}
			rs.close();
			jdbc.closeConn();

			JSONArray jsonEmptypes = JSONArray.fromObject(nodes);
			writer.write(jsonEmptypes.toString());
			
		}
		return null;
	}
}