merchantmasterstoreinfoaction.java

基于struts的网上商店源码

/*
 * 作者:王亮亮
 * 时间:2007年12月1日
 * 功能:查询总店基本信息
 */
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: 12-01-2007
 * 
 * XDoclet definition:
 * 
 * @struts.action validate="true"
 */
public class MerchantMasterStoreInfoAction 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 storeId = (String) request.getSession().getAttribute("store");

		List<Object[]> res = null;
		DBConnector db = new DBConnector();
		String sql = "select  MasterStoreID from StoreBind where SlaveStoreID='"
				+ storeId + "'";
		try {
			res = db.executeQuery(sql);// 查询总店信息
		} 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");
		}
		String masterStoreId;
		if (res.size() == 0)
			masterStoreId = storeId;
		else
			masterStoreId = (String) ((Object[]) res.get(0))[0];

		sql = "SELECT * FROM v_masterStoreInfo where ID='" + masterStoreId
				+ "'";

		try {
			res = db.executeQuery(sql);
		} 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 masterStoreInfo[] = new Object[10];
		for (int i = 0; i < masterStoreInfo.length; i++) {
			masterStoreInfo[i] = ((Object[]) res.get(0))[i];
		}

		request.setAttribute("masterStoreInfo", masterStoreInfo);
		return mapping.findForward("goMerchantMasterStoreInfo");

	}
}