deleteorderaction.java

主要是用于一个订货的系统.分为几层。。较好的区分的类别

/*
 * Generated by MyEclipse Struts
 * Template path: templates/java/JavaClass.vtl
 */
package com.yourcompany.struts.action;

import java.sql.ResultSet;
import java.sql.SQLException;

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 com.DateBean.DateBean;

/** 
 * MyEclipse Struts
 * Creation date: 01-19-2008
 * 
 * XDoclet definition:
 * @struts.action validate="true"
 * @struts.action-forward name="success" path="/success.jsp"
 * @struts.action-forward name="error" path="/error.jsp"
 */
public class DeleteOrderAction extends Action {
	/*
	 * Generated Methods
	 */

	/** 
	 * Method execute
	 * @param mapping
	 * @param form
	 * @param request
	 * @param response
	 * @return ActionForward
	 * @throws SQLException 
	 */
	public ActionForward execute(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) throws SQLException {
		// TODO Auto-generated method stub
		ResultSet rs = null;
		//实例化DateBean对象
		DateBean db = new DateBean();
		//获取orderID值
		String orderID = (String)request.getParameter("orderID");
		//初始化变量值
		boolean status=true;
		int temp = 0;
		String sql1 = "select status from Orders where orderID=orderID";
		String sql2 = "delete * from Orders where orderID=orderID";
		//查询status状态
		rs = db.executeQuery(sql1);
		status =rs.getBoolean("status");
		//如果status为false则返回出错页面，即不能删除。如果status为true则可以删除。
		if(status)			
		{ return mapping.findForward("error");}
		else
			{temp = db.executeUpdate(sql2);
			//删除成功返回success页面，否则返回出错页面。
			 if(temp>0)
				 return mapping.findForward("success");
			 else
				 return mapping.findForward("error");
	}
}}