merchantcardviewaction.java

基于struts的网上商店源码

/*
 * 作者:管磊
 * 时间: 11-26-2007
 * 功能:商家对会员卡的注销和激活
 */
package com.mole.struts.action;

import java.util.ArrayList;

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

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.mole.struts.bean.MerchantCardViewBean;
import com.mole.struts.bean.Page;
import com.mole.struts.dao.MerchantCardViewDAO;

/**
 * MyEclipse Struts Creation date: 11-26-2007
 * 
 * XDoclet definition:
 * 
 * @struts.action validate="true"
 */
public class MerchantCardViewAction extends Action {
	/**
	 * Method execute
	 * 
	 * @param mapping
	 * @param form
	 * @param request
	 * @param response
	 * @return ActionForward
	 */
	public ActionForward execute(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {

		String storeId = (String) request.getSession().getAttribute("store");

		MerchantCardViewDAO dao = new MerchantCardViewDAO();
		ArrayList<MerchantCardViewBean> mcvb = null;

		String action = request.getParameter("action");
		if (action != null && action.equals("stop")) {// 冻结卡
			String sql = "UPDATE card SET state=1 WHERE ID="
					+ request.getParameter("cardId");
			dao.executeUpdate(sql);
		} else if (action != null && action.equals("start")) {// 激活卡。
			String sql = "UPDATE card SET state=0 WHERE ID="
					+ request.getParameter("cardId");
			dao.executeUpdate(sql);
		}

		Page page = new Page();
		int pageSize = (request.getParameter("pageSizeSelect") == null ? 10
				: Integer.parseInt(request.getParameter("pageSizeSelect")));
		int currentPage = (request.getParameter("page") == null ? 1 : Integer
				.parseInt(request.getParameter("page")));
		int count = dao.getPageInfo(storeId, pageSize);
		page.setPageSize(pageSize);
		page.setRecordCount(count);
		page.setPageCount((count + pageSize - 1) / pageSize);
		page.setCurrentPage(currentPage);
		try {// 获取卡的信息。
			mcvb = dao.queryCardView(storeId, page.getCurrentPage());
		} catch (Exception e) {
			e.printStackTrace();
			HttpSession session = request.getSession();
			session.setAttribute("title", "错误信息");
			session.setAttribute("message", "出现错误，查询失败，请重新登陆！");
			session.setAttribute("returnUrl", "show.do?action=goLogin");
			return mapping.findForward("goMessage");
		}
		request.setAttribute("MerchantCardView", mcvb);
		request.setAttribute("Page", page);
		return mapping.findForward("goMerchantCardView");
	}

}