updateaction.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.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.Corp;

/** 
 * MyEclipse Struts
 * Creation date: 02-24-2009
 * 
 * XDoclet definition:
 * @struts.action validate="true"
 */
public class UpdateAction 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{
		response.setContentType("text/html;charset=UTF-8");
		response.setCharacterEncoding("UTF-8");
		PrintWriter writer = response.getWriter();
		String updateType = request.getParameter("type");
		String id = request.getParameter("id");
		
		JdbcUtil jdbc = new JdbcUtil();
		boolean success = false;
		if(updateType.equals("corp")){
			jdbc.openConn();
			String sql = "update corp set name='"+request.getParameter("name")
				+"',addr='"+request.getParameter("addr")
				+"',postcode='"+request.getParameter("postcode")
				+"',legalperson='"+request.getParameter("legalperson")
				+"',regicode='"+request.getParameter("regicode")
				+"',regicapital='"+request.getParameter("regicapital")
				+"',regiorg='"+request.getParameter("regiorg")
				+"',corptype='"+request.getParameter("corptype")
				+"',industry='"+request.getParameter("industry")
				+"',website='"+request.getParameter("website")
				+"',email='"+request.getParameter("email")
				+"',tel='"+request.getParameter("tel")
				+"',tel2='"+request.getParameter("tel2")
				+"',fax='"+request.getParameter("fax")+"' where pk_corp = 1";
			success = jdbc.executeUpdate(sql);
			jdbc.closeConn();
			
		}else if(updateType.equals("dept")){//更新部门信息
			jdbc.openConn();
			String sql = "update dept set deptname='"+request.getParameter("deptname")
				+"',depttype='"+request.getParameter("depttype")
				+"',deptduty='"+request.getParameter("deptduty")
				+"',addr='"+request.getParameter("addr")
				+"',tel='"+request.getParameter("tel")+"' where pk_dept="+id;
			success = jdbc.executeUpdate(sql);
			jdbc.closeConn();
			
		}else if(updateType.equals("post")){//更新职务信息
			jdbc.openConn();
			String sql =  "update post set postname='"+request.getParameter("postname")
				+"',posttype='"+request.getParameter("posttype")
				+"',postdesc='"+request.getParameter("postdesc")
				+"',postgoal='"+request.getParameter("postgoal")
				+"',postduty='"+request.getParameter("postduty")+"' where pk_post="+id;
			success = jdbc.executeUpdate(sql);
			jdbc.closeConn();
		}else if(updateType.equals("emptype")){
			jdbc.openConn();
			String sql =  "update emptype set typename='"+request.getParameter("typename")
				+"',typecode='"+request.getParameter("typecode")
				+"',typedesc='"+request.getParameter("typedesc")+"' where pk_emptype="+id;
			success = jdbc.executeUpdate(sql);
			jdbc.closeConn();
		}
		if (success == true) {
			writer.write("{success:true,message:'更新成功！'}");
		} else
			writer.write("{success:false,message:'更新失败！'}");
		writer.flush();
		writer.close();
		return null;
	}
}