cardopitionaction.java

基于struts的网上商店源码

/*
 * 作者：管磊
 * 功能：查询商家发放的和未发放的消费卡的信息。
 * 时间： 12-12-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.Page;
import com.mole.struts.dao.MerchantCardDAO;

/**
 * MyEclipse Struts Creation date: 12-12-2007
 * 
 * XDoclet definition:
 * 
 * @struts.action validate="true"
 */
public class CardOpitionAction 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) {
		String scid = null;
		String radiobutton = null;
		MerchantCardDAO dao = null;
		ArrayList mcvb = null;
		ArrayList cityList = null;
		scid = request.getParameter("scid");// 商家的ID
		radiobutton = request.getParameter("radiobutton");
		Page page = null;
		if (null == page)
			page = new Page();
		if (null == dao)
			dao = new MerchantCardDAO();
		if (scid != null && (!scid.trim().equals("")))// 根据商家的ID的多条件查询
		{
			String where = null;
			if ("1".equals(radiobutton)) {// 根据顾客的ID
				where = "where customerId='" + scid + "'";

			}
			if ("2".equals(radiobutton)) {// 根据消费卡的ID
				where = "where id='" + scid + "'";
			}
			try {
				cityList = dao.getArea();// 获取城市列表
				mcvb = dao.getCardById(where);// 从数据库中查询卡信息
				request.setAttribute("MerchantCardView", mcvb);
				request.setAttribute("cityList", cityList);
				return new ActionForward("/adminCardOperation.jsp");
			} catch (Exception e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		// 如果没有根据商家的ID进行卡的笼统信息查询。翻页数据库操作
		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(pageSize);// 获取数据库中卡的总个数。
		page.setPageSize(pageSize);
		page.setRecordCount(count);
		page.setPageCount((count + pageSize - 1) / pageSize);
		page.setCurrentPage(currentPage);
		request.setAttribute("cityList", cityList);

		try {
			mcvb = dao.queryCardView(page.getCurrentPage(), page.getPageSize());
			cityList = dao.getArea();
		} 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);
		request.setAttribute("cityList", cityList);
		return new ActionForward("/adminCardOperation.jsp");
	}
}