merchantmemberaction.java

基于struts的网上商店源码

/*
 * 作者:刘云云
 * 时间:2007年11月19日
 * 功能:店铺管理-＞帐户管理
 * 管理商家的帐户
 */
package com.mole.struts.action;

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.MerchantMemberBean;
import com.mole.struts.dao.MerchantMemberDAO;
import com.mole.struts.form.MerchantMemberForm;

/**
 * MyEclipse Struts Creation date: 11-19-2007
 * 
 * XDoclet definition:
 * 
 * @struts.action path="/staffInfo" name="staffInfoForm" input="/staffInfo.jsp"
 *                scope="request" validate="true"
 */
public class MerchantMemberAction 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) {

		ActionForward forward = null;
		String action = (String) request.getParameter("action");

		if (action == null || action.equals("show")) {// 获取显示商家的账户信息页面
			forward = showStaffInfo(mapping, form, request);

		} else if (action.equals("modify")) {// 获取修改商家的账户信息页面
			forward = ModifyStaffInfo(mapping, form, request);

		} else if (action.equals("delete")) {// 删除商家的账户
			MerchantMemberDAO dao = new MerchantMemberDAO();
			String sql = "DELETE FROM [Merchant] WHERE ID="
					+ request.getParameter("staffId");
			dao.executeUpdate(sql);
			forward = showStaffInfo(mapping, form, request);

		} else if (action.equals("add")) {// 获取添加商家的账户页面
			forward = mapping.findForward("goMerchantMemberAdd");

		} else if (action.equals("onAdd")) {// 添加商家的账户
			String storeId = (String) request.getSession()
					.getAttribute("store");
			MerchantMemberDAO dao = new MerchantMemberDAO();
			MerchantMemberForm aForm = (MerchantMemberForm) form;
			String sql = "INSERT INTO Merchant(StoreID,LoginName,Password,Role,State,Name,Gender,Email,Telephone,Cellphone,Address)"
					+ "VALUES('"
					+ storeId
					+ "','"
					+ aForm.getLoginName()
					+ "','"
					+ aForm.getPassword()
					+ "','"
					+ aForm.getRole()
					+ "','"
					+ aForm.getState()
					+ "','"
					+ aForm.getName()
					+ "','"
					+ aForm.getGender()
					+ "','"
					+ aForm.getEmail()
					+ "','"
					+ aForm.getTelephone()
					+ "','"
					+ aForm.getCellphone()
					+ "','" + aForm.getAddress() + "')";
			dao.executeUpdate(sql);
			forward = showStaffInfo(mapping, form, request);

		} else if (action.equals("onModify")) {// 修改商家的账户
			MerchantMemberDAO dao = new MerchantMemberDAO();
			MerchantMemberForm aForm = (MerchantMemberForm) form;
			String sql = "UPDATE Merchant SET role=" + aForm.getRole()
					+ ",state=" + aForm.getState() + " WHERE ID="
					+ aForm.getId();
			dao.executeUpdate(sql);
			forward = showStaffInfo(mapping, form, request);
		}
		return forward;
	}

	// 获取显示商家的账户信息
	public ActionForward showStaffInfo(ActionMapping mapping, ActionForm form,
			HttpServletRequest request) {
		MerchantMemberDAO dao = new MerchantMemberDAO();
		String user = (String) request.getSession().getAttribute("user");
		if (dao.checkRoleandState(user)) {
			String storeId = (String) request.getSession()
					.getAttribute("store");
			String sql = "SELECT LoginName,Role,State,Name,Gender,LastLogin,ID FROM Merchant "
					+ "WHERE id<>" + user + " AND StoreID=" + storeId;
			MerchantMemberBean[] result = dao.getAllStaffInfo(sql);
			request.setAttribute("result", result);
			return mapping.findForward("goMerchantMember");
		} else {
			HttpSession session = request.getSession();
			session.setAttribute("title", "错误信息");
			session.setAttribute("message", "你无权使用该功能");
			session.setAttribute("returnUrl", "show.do?action=null");
			return mapping.findForward("goMessage");
		}
	}

	// 获取修改商家的账户信息
	public ActionForward ModifyStaffInfo(ActionMapping mapping,
			ActionForm form, HttpServletRequest request) {
		MerchantMemberDAO dao = new MerchantMemberDAO();
		String sql = "SELECT LoginName,Role,State,Name,Gender,Email,Telephone,Cellphone,CreateDate,LastLogin,ID "
				+ "FROM Merchant WHERE ID='"
				+ request.getParameter("staffId")
				+ "'";
		MerchantMemberBean detailinfo = dao.getDetailStaffInfo(sql);
		request.setAttribute("detailinfo", detailinfo);

		return mapping.findForward("goMerchantMemberDetail");
	}
}