merchantstoreinfoaction.java

基于struts的网上商店源码

/*
 * 作者:
 * 时间:2007年11月18日
 * 功能:店铺管理 -＞店铺资料修改
 */
package com.mole.struts.action;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

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.MerchantStoreInfoModifyBean;
import com.mole.struts.dao.DBConnector;
import com.mole.struts.dao.MerchantStoreInfoDAO;

/**
 * MyEclipse Struts Creation date: 11-18-2007
 * 
 * XDoclet definition:
 * 
 * @struts.action path="/storeInfo" name="storeInfoForm" input="/storeInfo.jsp"
 *                scope="request" validate="true"
 */
public class MerchantStoreInfoAction 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");
		String action = request.getParameter("action");
		if (action == null || action.equals("show")) {
			MerchantStoreInfoDAO dao = new MerchantStoreInfoDAO();
			String sql = "SELECT name,typeName,cityName,areaName,image,address,telephone,"
					+ "createDate,ISNULL(typeName2,''),ISNULL(typeName3,''),ISNULL(typeName4,'') "
					+ " FROM v_StoreInfo WHERE ID=" + storeId;
			MerchantStoreInfoModifyBean record = dao.getMerchantStoreInfo(sql);
			request.setAttribute("record", record);
			return mapping.findForward("goMerchantStoreInfo");
		} else if (action.equals("modify")) {

			DBConnector dbc = new DBConnector();
			String sql = "UPDATE Store SET Name=?,Address=?,Telephone=?,Image=? where ID='"
					+ storeId + "'";
			try {
				String name = request.getParameter("name");
				String telephone = request.getParameter("telephone");
				String address = request.getParameter("address");
				String image = request.getParameter("image");
				dbc.executeUpdate(sql, name, address, telephone, image);
				request.getSession().setAttribute("title", "成功信息");
				request.getSession().setAttribute("message",
						"店铺资料修改成功成功，即将返回首页！");
				request.getSession().setAttribute("returnUrl",
						"show.do?action=getStroeInfo");
				return mapping.findForward("goMessage");
			} catch (Exception e) {
				e.printStackTrace();
				request.getSession().setAttribute("title", "错误信息");
				request.getSession().setAttribute("message", "修改失败，即将返回首页！");
				request.getSession().setAttribute("returnUrl",
						"show.do?action=getStroeInfo");
				return mapping.findForward("goMessage");
			}
		}
		return null;
	}
}