merchantbizgroupfavoriteaction.java

基于struts的网上商店源码

/*
 * 作者:刘云云
 * 时间:2007年11月28日
 * 功能:我的商业合作-＞关注中的商圈
 * 查看自已关注的商圈
 */
package com.mole.struts.action;

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.mole.struts.bean.MerchantBizGroupInfoBean;
import com.mole.struts.dao.MerchantBizGroupFavoriteDAO;

/**
 * MyEclipse Struts Creation date: 11-25-2007
 * 
 * XDoclet definition:
 * 
 * @struts.action validate="true"
 */
public class MerchantBizGroupFavoriteAction 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 storeId = (String) request.getSession().getAttribute("store");
		MerchantBizGroupFavoriteDAO dao = new MerchantBizGroupFavoriteDAO();

		String action = request.getParameter("action");
		if (action != null && action.equals("del")) {// 删除一条关注的商圈的记录
			int num = Integer.parseInt(request.getParameter("num"));
			String sql = "DELETE FROM [BizGroupFavorite] WHERE StoreID="
					+ storeId + " and BizGroupID=" + num;
			dao.executeUpdate(sql);
		} else if (action != null && action.equals("favorite")) {// 获取查看关注的商圈的页面
			String id = request.getParameter("id");
			String sql = "INSERT INTO BizGroupFavorite (StoreID,BizGroupID) VALUES('"
					+ storeId + "'," + id + ")";
			dao.executeUpdate(sql);
			return new ActionForward("/merchantBizGroupFavorite.do?action=new");
		}
		String sql = "SELECT ID,Name,activityDes,StartDate,EndDate,State,StoreName,"
				+ "typeName,cityName,areaName,ISNULL(typeName2,''),ISNULL(typeName3,''),ISNULL(typeName4,'') "
				+ " FROM v_bizGroupInfo WHERE ID in(SELECT BizGroupID "
				+ "FROM BizGroupFavorite WHERE StoreID='" + storeId + "')";
		MerchantBizGroupInfoBean[] result = dao.getFavoriteBizGroup(sql);
		request.setAttribute("result", result);
		return mapping.findForward("goMerchantBizGroupFavorite");
	}
}