merchantmemberdetailaction.java

基于struts的网上商店源码

/*
 * 作者:张建
 * 时间:2007年12月15日
 * 功能:商家查询会员详细信息。
 */
package com.mole.struts.action;

import java.util.List;

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.dao.DBConnector;

/**
 * MyEclipse Struts Creation date: 11-22-2007
 * 
 * XDoclet definition:
 * 
 * @struts.action validate="true"
 */
public class MerchantMemberDetailAction 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 customerId = request.getParameter("customerId");
		DBConnector db = new DBConnector();
		List<Object[]> res = null;
		String sql = "select LoginName,CustomerName,Gender,Email,CreateDate,TelePhone,Cellphone,Address,Company "
				+ " from v_StoreMember where CustomerID='" + customerId + "'";
		try {
			res = db.executeQuery(sql.toString());
		} catch (Exception e) {
			e.printStackTrace();
			HttpSession session = request.getSession();
			session.setAttribute("title", "错误信息");
			session.setAttribute("message", "用户名或密码错误，请登陆！");
			session.setAttribute("returnUrl", "show.do?action=goLogin");
			return mapping.findForward("goMessage");
		}
		Object memberDetailInfo[] = new Object[9];
		for (int i = 0; i < 9; i++)
			memberDetailInfo[i] = (res.get(0))[i];
		request.setAttribute("BizGroupCustomerInfo", memberDetailInfo);
		return mapping.findForward("memberDetailInfo");
	}

}