deleteaction.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;

/** 
 * MyEclipse Struts
 * Creation date: 02-24-2009
 * 
 * XDoclet definition:
 * @struts.action validate="true"
 */
public class DeleteAction 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 deleteType = request.getParameter("type");
		String id = request.getParameter("id");
		
		JdbcUtil jdbc = new JdbcUtil();
		
		boolean success = false;
		
		if(deleteType.equals("dept")){//删除部门
			jdbc.openConn();
			String sql = "delete from dept where pk_dept="+id;
			success = jdbc.executeUpdate(sql);
			jdbc.closeConn();
			
		}else if(deleteType.equals("post")){//删除职务
			jdbc.openConn();
			String sql = "delete from post where pk_post="+id;
			success = jdbc.executeUpdate(sql);
			jdbc.closeConn();
		}else if(deleteType.equals("emptype")){
			jdbc.openConn();
			String sql = "delete from post 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;
	}
}