deleteybwjaction.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 java.sql.ResultSet;

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 DeleteybwjAction extends Action {

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

			DataControl data = new DataControl();
			String sql ="delete from chuliqianzi where fabuid="+id+" and dept='"+dept+"'";
			int i = data.getDelete(sql);
			System.out.println(i);
			data.close();
			
			DataControl data1 = new DataControl();
			String sql1 ="delete from chuli where fabuid="+id+" and dept='"+dept+"'";
			int i1 = data1.getDelete(sql1);
			System.out.println(i1);
			data1.close();
			
			DataControl data2 = new DataControl();
			String sql2 ="delete from fabudept where fabuid="+id+" and dept='"+dept+"'";
			int i2 = data2.getDelete(sql2);
			System.out.println(i2);
			data2.close();
			
			DataControl data3 = new DataControl();
			String sql3 ="select * from fabudept where fabuid="+id;
			ResultSet rs3 = data3.getResulSet(sql3);
			if(rs3.next()){}else{
				DataControl data4 = new DataControl();
				String sql4 ="delete from fabu where id="+id;
				int i4 = data4.getDelete(sql4);
				System.out.println(i4);
				data4.close();
			}
			
			System.out.println("结束deleteybwj");
			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("gdwj");
	}
}