merchantinfomodifyaction.java

基于struts的网上商店源码

/*
 * 作者:刘云云
 * 时间:2007年11月28日
 * 功能:店铺管理 -＞个人资料/密码修改 
 * 修改店铺的商家个人资料和帐户密码
 */
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.MerchantInfoBean;
import com.mole.struts.dao.DBConnector;
import com.mole.struts.form.MerchantInfoModifyForm;

/**
 * MyEclipse Struts Creation date: 11-17-2007
 * 
 * XDoclet definition:
 * 
 * @struts.action validate="true"
 */
public class MerchantInfoModifyAction 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 = request.getParameter("action");
		if (action == null || action.equals("personal")) {// 获取商家帐户的个人资料的页面
			forward = showMerchantInfo(mapping, form, request);

		} else if (action.equals("onModify")) {// 修改个人资料
			forward = modifyMerchantInfo(mapping, form, request);

		} else if (action.equals("password")) {// 获取修改商家帐户的密码的页面
			forward = mapping.findForward("goMerchantInfoPassword");

		} else if (action.equals("onPassword")) {// 修改密码
			forward = modifyMerchantPassword(mapping, form, request);
		}
		return forward;
	}

	// 获取个人资料信息
	public ActionForward showMerchantInfo(ActionMapping mapping,
			ActionForm form, HttpServletRequest request) {
		String LoginId = (String) request.getSession().getAttribute("user");
		DBConnector db = new DBConnector();
		MerchantInfoBean info = new MerchantInfoBean();

		String sql = "select LoginName,Password,Role,Name,Gender,ISNULL(Email,''),ISNULL(Telephone,''),"
				+ "ISNULL(CellPhone,''),ISNULL(Address,''),CreateDate,LastLogin from Merchant where ID="
				+ LoginId;
		ArrayList<Object[]> list = null;
		try {
			list = db.executeQuery(sql.toString());
		} catch (Exception e) {
			e.printStackTrace();
		}
		if (list != null) {
			Object[] obj = list.get(0);
			info.setLoginName(obj[0].toString());
			info.setOldPassword(obj[1].toString());
			info.setRole(obj[2].toString());
			info.setName(obj[3].toString());
			info.setGender(obj[4].toString());
			info.setEmail(obj[5].toString());
			info.setTelephone(obj[6].toString());
			info.setCellphone(obj[7].toString());
			info.setAddress(obj[8].toString());
			info.setCreateDate(obj[9].toString().substring(0, 10));
			info.setLastLogin(obj[10].toString().substring(0, 10));
		}

		request.setAttribute("record", info);
		return mapping.findForward("goMerchantInfoModify");
	}

	// 修改密码
	public ActionForward modifyMerchantPassword(ActionMapping mapping,
			ActionForm form, HttpServletRequest request) {
		MerchantInfoModifyForm merchantModifyBaseInfoForm = (MerchantInfoModifyForm) form;
		String loginId = (String) request.getSession().getAttribute("user");
		HttpSession session = request.getSession();
		String newPassword = merchantModifyBaseInfoForm.getNewPassword();
		String password = merchantModifyBaseInfoForm.getPassword();

		DBConnector db = new DBConnector();
		String sql = "UPDATE merchant SET password='" + newPassword
				+ "' WHERE  ID=" + loginId + " AND Password='" + password + "'";
		int n = 0;
		try {
			n = db.executeUpdate(sql);
		} catch (Exception e1) {
			e1.printStackTrace();
		}
		if (n == 1) {
			session.setAttribute("title", "成功信息");
			session.setAttribute("message", "修改密码成功！");
			session.setAttribute("returnUrl",
					"merchantInfoModify.do?action=password");
			return mapping.findForward("goMessage");
		} else {
			session.setAttribute("title", "失败信息");
			session.setAttribute("message", "修改密码失败！");
			session.setAttribute("returnUrl",
					"merchantInfoModify.do?action=password");
			return mapping.findForward("goMessage");
		}

	}

	// 修改个人资料
	public ActionForward modifyMerchantInfo(ActionMapping mapping,
			ActionForm form, HttpServletRequest request) {

		MerchantInfoModifyForm merchantModifyBaseInfoForm = (MerchantInfoModifyForm) form;
		HttpSession session = request.getSession();
		DBConnector db = new DBConnector();

		String name = merchantModifyBaseInfoForm.getName();
		String userGender = merchantModifyBaseInfoForm.getGender();
		String userAddress = merchantModifyBaseInfoForm.getAddress();
		String userEmail = merchantModifyBaseInfoForm.getEmail();
		String userCellphone = merchantModifyBaseInfoForm.getCellphone();
		String userTelephone = merchantModifyBaseInfoForm.getTelephone();

		String loginId = (String) request.getSession().getAttribute("user");

		try {
			String sql = "UPDATE [Merchant] SET name='" + name + "', Gender='"
					+ userGender + "',Email='" + userEmail + "',Telephone='"
					+ userTelephone + "',Cellphone='" + userCellphone
					+ "',Address='" + userAddress + "' where ID=" + loginId;

			db.executeUpdate(sql);
		} catch (Exception e) {
			e.printStackTrace();
		}
		session.setAttribute("title", "成功信息");
		session.setAttribute("message", "修改个人资料成功！");
		session.setAttribute("returnUrl", "merchantInfoModify.do");
		return mapping.findForward("goMessage");
	}
}