sendgoodsaction.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 SendGoodsAction 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) {
		// TODO Auto-generated method stub
		
      //实例化DateBean对象
		DateBean db = new DateBean();
		//初始化变量值
		int temp=0,temp1=0;
		int quantities=0;
		String orderID =request.getParameter("orderID");
		String sql="update Orders set status="+true+" where orderID=orderID";
		String sql1 ="select quantities from OrderDetails where orderID=orderID";
		String sql2="update OrderDetails set quantities="+quantities+" where orderID=orderID";
		ResultSet rs=null;
		
		//设置status为true，即已经发货。
		try{
			temp = db.executeUpdate(sql);		
		    if(temp>0)
			   return mapping.findForward("success");
		    else
			   return mapping.findForward("error");
		    }catch (SQLException e) {
                e.printStackTrace();
           }
		
		//实现对quantities减1
		try{
		   rs=db.executeQuery(sql1);
		   quantities=rs.getInt("quantities");
		   quantities=quantities-1;
		   temp1=db.executeUpdate(sql2);
		   if(temp1>0)
		       return mapping.findForward("success");
		   else
			   return mapping.findForward("error");
		   }catch (SQLException e) {
               e.printStackTrace();
           }
		
		return null;			
	}
}