displayorderaction.java

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

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

import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;

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

/** 
 * MyEclipse Struts
 * Creation date: 01-19-2008
 * 
 * XDoclet definition:
 * @struts.action validate="true"
 */
public class DisplayOrderAction 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 {
		
		DateBean db = new DateBean();
		boolean status1 = false;
        ResultSet rs = null;
		ArrayList Orders = new ArrayList();
		
		String sql = "select * from Orders where status=status1";
		rs = db.executeQuery(sql);			
          while(rs.next()){
            	Order orders=new Order();
            	orders.setorderID(rs.getString("orderID"));
            	orders.setcustomerID(rs.getString("customerID"));
            	orders.setemployeeID(rs.getString("employeeID"));
            	orders.setorderDate(rs.getString("orderDate"));
            	orders.setsendDate(rs.getString("sendDate"));
            	orders.setstatus(rs.getString("status"));               
            	Orders.add(orders);
            }        		
		request.setAttribute("Order","order");			
		return mapping.findForward("display");
		
	}
}