orderaction.java

网上购物系统

package example.order;

import java.sql.SQLException;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

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

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 org.apache.struts.action.ActionMessages;

import com.shsafe.common.database.DatabaseConnection;
import com.shsafe.common.database.DatabaseConnectionManager;
import com.shsafe.common.struts.action.BaseAction;

import example.common.dto.OrderDTO;


public class OrderAction extends BaseAction {

	/**
	 * @param mapping
	 * @param form
	 * @param request
	 * @param response
	 * @return ActionForward
	 * @throws Exception
	 */
	public ActionForward init(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response)
			throws Exception {
		 log.trace("Start");
		 OrderForm orderForm = ((OrderForm) form);
		 OrderDTO order = orderForm.getCondition();
		 order.setOrderId("");
		 order.setOrderName("");
		 order.setReferDate("");
		 order.setDealDate("");
		 order.setUserId("");
         orderForm.setListData(null);
		return mapping.findForward("orderPage");
	}
	
	/**
	 * @param mapping
	 * @param form
	 * @param request
	 * @param response
	 * @return ActionForward
	 * @throws Exception
	 */
	public ActionForward init1(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response)
			throws Exception {
		 log.trace("Start");
		 OrderForm orderForm = ((OrderForm) form);
		 OrderDTO order = orderForm.getCondition();
		 order.setOrderId("");
		 order.setOrderName("");
		 order.setReferDate("");
		 order.setDealDate("");
		 order.setUserId("");
         orderForm.setListData(null);
		 log.trace("End");
		return mapping.findForward("success");
	}

	/**
	 * @param mapping
	 * @param form
	 * @param request
	 * @param response
	 * @return ActionForward
	 * @throws Exception
	 */
	public ActionForward search(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response)
			throws Exception {

		OrderForm orderForm = (OrderForm) form;
		DatabaseConnection connection = DatabaseConnectionManager
				.getMyConnection();
		OrderDAO dao = new OrderDAO(connection);

		int count = dao.countOrders(orderForm.getCondition());
		orderForm.getPageInfo().setMaxRecordNum(count);
		if (count == 0) {
			ActionMessages msgs = new ActionMessages();
			msgs.add("all", new ActionMessage("dataNotFound"));
			saveErrors(request, msgs);
			return mapping.findForward("failure");
		}

		List<OrderDTO> dtoList = dao.searchOrder(orderForm.getCondition(),
				orderForm.getPageInfo());
		orderForm.setListData(dtoList);

		return mapping.findForward("success");
	}
	
	
	public ActionForward searchOne(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response)
			throws Exception {
		
		OrderForm orderForm = (OrderForm) form;
		DatabaseConnection connection = DatabaseConnectionManager.getMyConnection();
		OrderDAO dao = new OrderDAO(connection);
		OrderDTO order1 = (OrderDTO)(orderForm.getListData().get(orderForm.getIndex()));

		OrderDTO order = dao.searchOne(order1.getOrderId());
		orderForm.setCondition(order);

		return new ActionForward("/orderInfo/orderDetails.jsp");
		
	}
	
	public ActionForward searchOne1(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response)
			throws Exception {
		
		OrderForm orderForm = (OrderForm) form;
		DatabaseConnection connection = DatabaseConnectionManager.getMyConnection();
		OrderDAO dao = new OrderDAO(connection);
		OrderDTO order1 = (OrderDTO)(orderForm.getListData().get(orderForm.getIndex()));

		OrderDTO order = dao.searchOne1(order1.getOrderId());
		orderForm.setCondition(order);

		return new ActionForward("/orderInfo/orderDetail.jsp");
		
	}
	
	
	public ActionForward modifyOne(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response)
			throws Exception {
		
		OrderForm orderForm = (OrderForm) form;
		DatabaseConnection connection = DatabaseConnectionManager.getMyConnection();
		OrderDAO dao = new OrderDAO(connection);
		OrderDTO order1 = (OrderDTO)(orderForm.getListData().get(orderForm.getIndex()));
		OrderDTO order = dao.searchOne(order1.getOrderId());
		
		orderForm.setCondition(order);

		return new ActionForward("/orderInfo/orderInfoUpdate.jsp");
		
	}
	public ActionForward modifyOne1(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response)
			throws Exception {
		
		OrderForm orderForm = (OrderForm) form;
		DatabaseConnection connection = DatabaseConnectionManager.getMyConnection();
		OrderDAO dao = new OrderDAO(connection);
		OrderDTO order1 = (OrderDTO)(orderForm.getListData().get(orderForm.getIndex()));

		OrderDTO order = dao.searchOne1(order1.getOrderId());
		orderForm.setBeforeOrderId(order.getOrderId());
		orderForm.setCondition(order);
		
		return new ActionForward("/orderInfo/orderDeal.jsp");
		
	}
	public ActionForward save(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response)
			throws Exception {

		OrderForm orderForm = (OrderForm) form;
		DatabaseConnection connection = DatabaseConnectionManager
				.getMyConnection();
		OrderDAO dao = new OrderDAO(connection);

		int countOrder = dao.saveOrder(orderForm.getCondition());

		if (countOrder <= 0) {
			ActionMessages msgs = new ActionMessages();
			msgs.add("all", new ActionMessage("保存失败", false));
			saveErrors(request, msgs);
			return mapping.findForward("failure");
		}
		return mapping.findForward("success");
	}
	
	public ActionForward modify(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response)
			throws Exception {

		OrderForm orderForm = (OrderForm) form;
		DatabaseConnection connection = DatabaseConnectionManager.getMyConnection();
		OrderDAO dao = new OrderDAO(connection);
		
		OrderDTO order = orderForm.getCondition();//dto
		orderForm.getCondition().setBeforeOrderId(order.getBeforeOrderId());
		int countOrder = dao.modify(order);
		
		if (countOrder < 0) {
			ActionMessages msgs = new ActionMessages();
			msgs.add("all", new ActionMessage("保存失败", false));
			saveErrors(request, msgs);
			return mapping.findForward("failure");
		}
		return mapping.findForward("success");
	}
	public ActionForward modify1(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response)
			throws Exception {

		OrderForm orderForm = (OrderForm) form;
		DatabaseConnection connection = DatabaseConnectionManager.getMyConnection();
		OrderDAO dao = new OrderDAO(connection);
		
		OrderDTO order = orderForm.getCondition();//dto
		orderForm.getCondition().setBeforeOrderId(order.getOrderId());
		int countOrder = dao.modify1(order);
		
		if (countOrder < 0) {
			ActionMessages msgs = new ActionMessages();
			msgs.add("all", new ActionMessage("保存失败", false));
			saveErrors(request, msgs);
			return mapping.findForward("failure");
		}
		return mapping.findForward("success");
	}
	public ActionForward delete(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) throws Exception{
        
		OrderForm orderForm = (OrderForm) form;
		DatabaseConnection connection = DatabaseConnectionManager.getMyConnection();
		OrderDAO dao = new OrderDAO(connection);
		OrderDTO order = (OrderDTO)(orderForm.getListData().get(orderForm.getIndex()));
		int count = dao.delete(order);
		
		
		log.info(count + " rows delete");
		ActionMessages msg = new ActionMessages();
		msg.add("all", new ActionMessage("Success"));
		return search(mapping, form, request, response);
	}
}