deletefabuaction.java

这是一个简单的办公管理系统

//Created by MyEclipse Struts
// XSL source (default): platform:/plugin/com.genuitec.eclipse.cross.easystruts.eclipse_4.1.1/xslt/JavaClass.xsl

package com.yourcompany.struts.action;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.apache.struts.action.Action;
import org.apache.struts.action.ActionErrors;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;
import org.apache.struts.action.ActionMessage;

import admin.DataControl;

public class DeletefabuAction extends Action {

	public ActionForward execute(
		ActionMapping mapping,
		ActionForm form,
		HttpServletRequest request,
		HttpServletResponse response) {
		ActionErrors err = new ActionErrors();
		try {
			System.out.println("");
			System.out.println("开始deletefabu");
            String id = request.getParameter("id");

			DataControl data = new DataControl();
			String sql ="delete from fabu where id="+id;
			int i = data.getDelete(sql);
			System.out.println(i);
			data.close();
			
			DataControl data1 = new DataControl();
			String sql1 = "delete from fabudept where fabuid="+id;
			int i1 = data1.getDelete(sql1);
			System.out.println(i1);
			data1.close();

			System.out.println("结束deletefabu");
			System.out.println("");
			}catch (Exception e) {
				err.add("err",new ActionMessage("fabu.delete.error",e.getMessage()));
				System.out.println("删除文件失败");
				this.saveErrors(request,err);
				return mapping.getInputForward();
			}	
		return mapping.findForward("gdfb");
	}
}