getcorpaction.java

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

package com.idealab.struts.action;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.sql.ResultSet;
import java.util.Date;
import java.io.PrintWriter;
import java.util.Map;
import java.util.HashMap;

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.FromJsonUtil;
import com.idealab.util.JdbcUtil;
import com.idealab.util.ToJsonUtil;
import com.idealab.dao.Corp;

public class GetCorpAction extends Action {

	/**
	 * 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 {
		ResultSet rs;
		PrintWriter writer = response.getWriter();
		response.setCharacterEncoding("UTF-8");
		response.setContentType("text/html;charset=utf8");
		
		JdbcUtil jdbc = new JdbcUtil();
		jdbc.openConn();
		Corp corp = new Corp();
		String sql = "select * from corp where pk_corp = 1";
		// TODO Change pk_corp to 1 after table is configured correctly.
		rs = jdbc.executeQuery(sql);
		if (rs.first()) {
			corp.setName(rs.getString("name"));
			corp.setAddr(rs.getString("addr"));
			corp.setPostcode(rs.getString("postcode"));
			corp.setLegalperson(rs.getString("legalperson"));
			corp.setRegicode(rs.getString("regicode"));
			corp.setRegicapital(rs.getString("regicapital"));
			corp.setRegiorg(rs.getString("regiorg"));
			corp.setCorptype(rs.getString("corptype"));
			corp.setIndustry(rs.getString("industry"));
			corp.setWebsite(rs.getString("website"));
			corp.setEmail(rs.getString("email"));
			corp.setTel(rs.getString("tel"));
			corp.setTel2(rs.getString("tel2"));
			corp.setFax(rs.getString("fax"));
			corp.setContent(rs.getString("content"));
			corp.setGoal(rs.getString("goal"));
			corp.setDevcourse(rs.getString("devcourse"));
			corp.setHonor(rs.getString("honor"));
		}
		rs.close();
		jdbc.closeConn();

		JSONObject jsonInner = FromJsonUtil.getJsonObject4JavaPOJO(corp,
				"yyyy-mm-dd");
		JSONArray jsonArray = new JSONArray();
		jsonArray.add(jsonInner);
		JSONObject jsonOuter = new JSONObject();
		jsonOuter.put("success", true);
		jsonOuter.put("data", jsonArray);
		System.out.println(jsonOuter);
		writer.print(jsonOuter);
		return null;
	}
}