orderaction.java

在线购物 商品管理 用户管理 购物车 订单管理 权限控制

/**
 * 
 */
package com.qrsx.shop.action;

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

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

import com.qrsx.shop.dao.JdbcUtil;
import com.qrsx.shop.dao.OrderDAO;
import com.qrsx.shop.model.Order;

/**
 * 
 *@Author:李世海	
 *@Address:青岛软件园
 *@Date: Apr 6, 2009
 */
public class OrderAction extends BaseAction<OrderDAO , Order>{
	private Order order;
	public OrderAction(HttpServletRequest request,
			HttpServletResponse response,  Order order) {
		super(request, response, new OrderDAO(), order);
		this.order = entity;
	}
	/**
	 * 形成初步订单
	 */
	public void listOrder(){
		try{
			order = dao.listOrder(order.getUserId());
			request.setAttribute("order", order);
			JdbcUtil.commitTransaction();
		}catch(SQLException e) {
			e.printStackTrace();
			JdbcUtil.rollbackTransaction();
		}finally{
			JdbcUtil.closeCurrentConnection();
		}
	}
	/**
	 * 创建初步订单
	 */
	public void create(String[] amounts){
		try{
			dao.create(order, amounts);
			JdbcUtil.commitTransaction();
			saveMessage("初步订单提交成功！");
		}catch(SQLException e) {
			e.printStackTrace();
			saveError("初步订单提交失败！");
			JdbcUtil.rollbackTransaction();
		}finally{
			JdbcUtil.closeCurrentConnection();
		}
	}
	/**
	 * 用户查看自己的订单
	 */
	public void findByUserId(){
		try{
			List<Order> list = dao.findByUserId(order.getUserId());
			request.setAttribute("orders", list);
			JdbcUtil.commitTransaction();
		}catch(SQLException e) {
			e.printStackTrace();
			
			JdbcUtil.rollbackTransaction();
		}finally{
			JdbcUtil.closeCurrentConnection();
		}
	}
	/**
	 * 用户删除订单
	 */
	public void delete(){
		try{
			dao.delete(order.getId());
			request.setAttribute("userId",order.getUserId());
			JdbcUtil.commitTransaction();
			saveMessage("删除成功！");
		}catch(SQLException e) {
			e.printStackTrace();
			saveError("删除失败！");
			JdbcUtil.rollbackTransaction();
		}finally{
			JdbcUtil.closeCurrentConnection();
		}
	}
	/**
	 * 用户提交订单
	 */
	public void update(){
		try{
			dao.update(order);
			request.setAttribute("userId",order.getUserId());
			saveMessage("提交成功！");
			JdbcUtil.commitTransaction();
		}catch(SQLException e) {
			e.printStackTrace();
			saveError("提交失败！");
			JdbcUtil.rollbackTransaction();
		}finally{
			JdbcUtil.closeCurrentConnection();
		}
	}
	/**
	 * 管理员查看订单
	 */
	public void findAll(){
		try{
			List<Order> list = dao.findAll();
			request.setAttribute("orders", list);
			JdbcUtil.commitTransaction();
		}catch(SQLException e) {
			e.printStackTrace();
			JdbcUtil.rollbackTransaction();
		}finally{
			JdbcUtil.closeCurrentConnection();
		}
	}
	/**
	 * 管理员根据主键查看订单明细
	 */
	public void findById(){
		try{
			order = dao.findById(order.getId());
			request.setAttribute("order", order);
		}catch(SQLException e) {
			e.printStackTrace();
			JdbcUtil.rollbackTransaction();
		}finally{
			JdbcUtil.closeCurrentConnection();
		}
	}
}