merchantscorepolicyaction.java

基于struts的网上商店源码

/*
 * 作者:刘云云
 * 时间:2007年11月11日
 * 功能:店铺管理-＞积分政策。
 */
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.MerchantScorePolicyBean;
import com.mole.struts.dao.MerchantScorePolicyDAO;
import com.mole.struts.form.MerchantScorePolicyForm;

/**
 * MyEclipse Struts Creation date: 11-11-2007
 * 
 * XDoclet definition:
 * 
 * @struts.action validate="true"
 * @struts.action-forward name="scorePolicy" path="/scorePolicy.jsp"
 */
public class MerchantScorePolicyAction 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) {

		MerchantScorePolicyDAO dao = new MerchantScorePolicyDAO();

		String storeId = (String) request.getSession().getAttribute("store");
		String action = (String) request.getParameter("action");
		if (action == null || action.equals("new")) { // 获取显示积分信息页面
			MerchantScorePolicyBean[] records = dao
					.getScorePolicy((String) request.getSession().getAttribute(
							"store"));
			request.setAttribute("result", records);
			return mapping.findForward("goMerchantscorePolicy");

		} else if (action.equals("add")) {// 获取添加积分信息页面
			MerchantScorePolicyBean record = new MerchantScorePolicyBean();
			request.setAttribute("pageAction", "add");
			request.setAttribute("detailInfo", record);
			return mapping.findForward("goMerchantScorePolicyDetail");

		} else if (action.equals("modify")) {// 获取修改积分信息页面
			MerchantScorePolicyBean bean = dao.getScorePolicyInfo(request
					.getParameter("id"));
			;
			request.setAttribute("pageAction", "modify");
			request.setAttribute("detailInfo", bean);
			return mapping.findForward("goMerchantScorePolicyDetail");

		} else if (action.equals("delete")) {// 删除一条积分记录
			String sql = "DELETE FROM [ScoreDiscount] WHERE ID="
					+ request.getParameter("id");
			dao.executeUpdate(sql);
		} else if (action.equals("onAdd")) {// 添加一条积分记录
			MerchantScorePolicyForm spForm = (MerchantScorePolicyForm) form;
			String sql = "INSERT INTO [ScoreDiscount]([StoreID],[Score],[Discount],[Description]) "
					+ "VALUES('"
					+ storeId
					+ "',"
					+ spForm.getScore()
					+ ","
					+ spForm.getDiscount()
					+ ",'"
					+ spForm.getDescription()
					+ "')";
			dao.executeUpdate(sql);
		} else if (action.equals("onModify")) {// 修改一条积分记录
			MerchantScorePolicyForm spForm = (MerchantScorePolicyForm) form;
			String sql = "UPDATE [ScoreDiscount] SET [Score]="
					+ spForm.getScore() + " ,[Discount]="
					+ spForm.getDiscount() + ",[Description]='"
					+ spForm.getDescription() + "' WHERE [ID]="
					+ spForm.getId();
			dao.executeUpdate(sql);
		}
		return new ActionForward("/merchantScorePolicy.do?action=new");
	}
}