merchantslavestoremanageaction.java

基于struts的网上商店源码

/*
 * 作者:刘云云
 * 时间:2007年12月02日
 * 功能:店铺管理 -＞分店开设管理
 */
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.MerchantSlaveStoreInfoBean;
import com.mole.struts.dao.MerchantSlaveStoreManageDAO;

/**
 * MyEclipse Struts Creation date: 12-02-2007
 * 
 * XDoclet definition:
 * 
 * @struts.action path="/merchantSlaveStoreManage"
 *                name="merchantSlaveStoreManageForm"
 *                input="/merchantSlaveStoreManage.jsp" scope="request"
 *                validate="true"
 */
public class MerchantSlaveStoreManageAction 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) {

		MerchantSlaveStoreManageDAO dao = new MerchantSlaveStoreManageDAO();

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

		if (action == null || action.equals("new")) { // 获取显示分店信息的页面

			String sql = "SELECT slaveStoreID FROM storeBind WHERE slaveStoreID="
					+ storeId;
			ArrayList<Object[]> al = dao.executeQuery(sql);
			if (al.size() != 0) {
				HttpSession session = request.getSession();
				session.setAttribute("title", "错误信息");
				session.setAttribute("message", "你无权限或访问失败！");
				session.setAttribute("returnUrl", "show.do?action=null");
				return mapping.findForward("goMessage");
			}

			sql = "SELECT b.[ID],a.[Name],b.[ScoreShare]"
					+ "FROM [Store] a,[StoreBind] b WHERE b.[MasterStoreID]="
					+ storeId + " AND  a.[ID]=b.[SlaveStoreID] order by a.[ID]";
			MerchantSlaveStoreInfoBean[] bean = dao.getStoreBindInfo(sql);

			request.setAttribute("result", bean);
			return mapping.findForward("goMerchantSlaveStore");

		} else if (action.equals("bind")) {// 绑定分店积分
			String sql = "update StoreBind set ScoreShare=1 where ID="
					+ request.getParameter("id");
			dao.executeUpdate(sql);
			return new ActionForward("/merchantSlaveStoreManage.do?action=new");

		} else if (action.equals("nobind")) {// 取消绑定分店积分
			String sql = "update StoreBind set ScoreShare=0 where ID="
					+ request.getParameter("id");
			dao.executeUpdate(sql);
			return new ActionForward("/merchantSlaveStoreManage.do?action=new");

		} else if (action.equals("delete")) {// 删除分店
			String sql = "DELETE FROM storeBInd WHERE ID="
					+ request.getParameter("id");
			dao.executeUpdate(sql);
			return new ActionForward("/merchantSlaveStoreManage.do?action=new");
		} else if (action.equals("add")) {// 获取添加分店的页面
			return mapping.findForward("goMerchantSlaveStoreManage");
		} else if (action.equals("onAdd")) {// 添加分店
			String loginName = request.getParameter("loginName");
			String password = request.getParameter("password");
			String sql = "SELECT storeID FROM merchant WHERE role=1 AND loginName='"
					+ loginName + "' AND password='" + password + "'";
			ArrayList<Object[]> al = dao.executeQuery(sql);
			if (al.size() == 0) {
				HttpSession session = request.getSession();
				session.setAttribute("title", "错误信息");
				session.setAttribute("message", "你无权开设或访问失败！");
				session.setAttribute("returnUrl", "show.do?action=null");
				return mapping.findForward("goMessage");
			}
			String slaveStoreId = al.get(0)[0].toString();
			sql = "INSERT INTO StoreBind (SlaveStoreID,MasterStoreID) "
					+ " VALUES('" + slaveStoreId + "','" + storeId + "')";
			dao.executeUpdate(sql);

			return new ActionForward("/merchantSlaveStoreManage.do?action=new");
		}
		return null;
	}
}