getbyidaction.java

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

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

import java.util.Date;
import java.util.HashMap;
import java.util.Iterator;
import java.util.List;
import java.util.ArrayList;
import java.util.Map;
import java.io.PrintWriter;
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.util.JdbcUtil;
import com.idealab.dao.Emp;
import com.idealab.dao.EmpDAO;
import com.idealab.dao.Empdoc;
import com.idealab.dao.EmpdocDAO;

/**
 * MyEclipse Struts Creation date: 02-24-2009
 * 
 * XDoclet definition:
 * 
 * @struts.action validate="true"
 */
public class GetByIdAction 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 {
		// TODO Auto-generated method stub
		response.setContentType("text/html;charset=UTF-8");
		response.setCharacterEncoding("UTF-8");
		PrintWriter writer = response.getWriter();
		String getType = request.getParameter("type");
		String id = request.getParameter("id");

		JdbcUtil jdbc = new JdbcUtil();

		JSONArray jsonInner = new JSONArray();

		if (getType.equals("dept")) {// 获得部门信息
			jdbc.openConn();
			if (id == null) {// 若id为空，则查询全部数据，返回数据供comboBox使用
				String sql = "select * from dept";
				ResultSet rs = jdbc.executeQuery(sql);
				while (rs.next()) {
					JSONObject jsonObj = new JSONObject();
					jsonObj.put("id", rs.getString("pk_dept"));
					jsonObj.put("deptname", rs.getString("deptname"));
					jsonInner.add(jsonObj);
				}
				rs.close();
				jdbc.closeConn();

			} else {
				String sql = "select * from dept where pk_dept =" + id;
				ResultSet rs = jdbc.executeQuery(sql);
				Map map = new HashMap();
				if (rs.first()) {
					map.put("deptname", rs.getString("deptname"));
					map.put("depttype", rs.getString("depttype"));
					map.put("deptduty", rs.getString("deptduty"));
					map.put("addr", rs.getString("addr"));
					map.put("tel", rs.getString("tel"));
				}
				
				jsonInner = JSONArray.fromObject(map);
				rs.close();
				jdbc.closeConn();
				System.out.println("JsonInner is:"+jsonInner.toString());
			}

		} else if (getType.equals("post")) {// 获得职务信息
			jdbc.openConn();
			if (id == null) {// 若id为空，则查询全部数据
				String sql = "select * from post";
				ResultSet rs = jdbc.executeQuery(sql);

				while (rs.next()) {
					JSONObject jsonObj = new JSONObject();
					jsonObj.put("id", rs.getString("pk_post"));
					jsonObj.put("postname", rs.getString("postname"));
					jsonInner.add(jsonObj);
					System.out.println("pk_post=" + rs.getString("pk_post")
							+ "\t" + rs.getString("postname"));
				}
				rs.close();
				jdbc.closeConn();

			} else {
				String sql = "select * from post where pk_post =" + id;
				ResultSet rs = jdbc.executeQuery(sql);
				Map map = new HashMap();
				if (rs.first()) {
					map.put("postname", rs.getString("postname"));
					map.put("posttype", rs.getString("posttype"));
					map.put("postdesc", rs.getString("postdesc"));
					map.put("postgoal", rs.getString("postgoal"));
					map.put("postduty", rs.getString("postduty"));
				}
				rs.close();
				jdbc.closeConn();
				jsonInner = JSONArray.fromObject(map);
			}
		} else if (getType.equals("job")) {// 获得岗位信息
			jdbc.openConn();
			if (id == null) {
				String sql = "select * from job";
				ResultSet rs = jdbc.executeQuery(sql);
				while (rs.next()) {
					JSONObject jsonObj = new JSONObject();
					jsonObj.put("id", rs.getInt("pk_outer_post"));
					jsonObj.put("jobname", rs.getString("jobname"));
					jsonInner.add(jsonObj);
				}
				rs.close();
				jdbc.closeConn();
			} else {
				// Note:此时的id为部门主键，此查询响应部门树点击事件
				String sql = "select * from job where pk_dept=" + id;
				ResultSet rs = jdbc.executeQuery(sql);

				while (rs.next()) {
					JSONObject jsonObj = new JSONObject();

					jsonObj.put("jobcode", rs.getString("jobcode"));
					jsonObj.put("jobname", rs.getString("jobname"));
					jsonObj.put("pk_outer_post", rs.getInt("pk_outer_post"));
					jsonObj.put("jobtype", rs.getString("jobtype"));
					jsonObj.put("jobdesc", rs.getString("jobdesc"));
					jsonInner.add(jsonObj);
				}
				rs.close();
				jdbc.closeConn();
			}

		} else if (getType.equals("emptype")) {// 获得人员类别信息
			jdbc.openConn();
			if (id == null) {
				String sql = "select * from emptype";
				ResultSet rs = jdbc.executeQuery(sql);
				while (rs.next()) {
					JSONObject jsonObj = new JSONObject();
					jsonObj.put("id", rs.getString("pk_emptype"));
					jsonObj.put("typename", rs.getString("typename"));
					jsonInner.add(jsonObj);
				}
				rs.close();
				jdbc.closeConn();
			} else {
				String sql = "select * from emptype where pk_emptype=" + id;
				ResultSet rs = jdbc.executeQuery(sql);
				if (rs.first()) {
					JSONObject jsonObj = new JSONObject();
					jsonObj.put("typecode", rs.getString("typecode"));
					jsonObj.put("typename", rs.getString("typename"));
					jsonObj.put("typedesc", rs.getString("typedesc"));
					jsonInner.add(jsonObj);
				}
				rs.close();
				jdbc.closeConn();
			}
		} else if (getType.equals("emp")) {// 根据部门查询
			if (id == null) {
				// TODO
				EmpDAO dao = new EmpDAO();
				List<Emp> list = dao.findAll();
				Iterator iterator = list.iterator();
				while (iterator.hasNext()) {
					JSONObject jsonObj = new JSONObject();
					Emp emp = (Emp) iterator.next();
					jsonObj.put("pk_emp", emp.getPkEmp());
					jsonObj.put("empname", emp.getName());
					jsonInner.add(jsonObj);
				}
			} else {
				EmpdocDAO dao = new EmpdocDAO();
				List<Empdoc> list = dao.findByPkOuterDept(Integer.valueOf(id));
				jsonInner.fromObject(list);
			}
		}
		JSONObject json = new JSONObject();
		json.put("success", true);
		json.put("data", jsonInner);
		writer.write(json.toString());
		return null;
	}
}