reaschstoreaction.java

来自「基于struts的网上商店源码」· Java 代码 · 共 99 行

/*
 * 作者:管磊
 * 时间:01-04-2008
 * 功能:查询商家的信息。
 */
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.Page;
import com.mole.struts.dao.searchStoreDAO;

/**
 * MyEclipse Struts Creation date: 12-08-2007
 * 
 * XDoclet definition:
 * 
 * @struts.action validate="true"
 */
public class ReaschStoreAction extends Action {
	/*
	 * Generated Methods
	 */
	private searchStoreDAO dao;

	/**
	 * Method execute
	 * 
	 * @param mapping
	 * @param form
	 * @param request
	 * @param response
	 * @return ActionForward
	 */
	public ActionForward execute(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
		String area = request.getParameter("storeArea");// 地区
		String storeName = request.getParameter("storeName");// 店名
		String storeKind = request.getParameter("storeKind");// 店的类型
		String storeProvience = request.getParameter("Pid");// 店在的省份
		String sqlWhere = null;
		if (area == null || "null".equals(area))
			area = "";
		if (storeName == null || "null".equals(storeName))
			storeName = "";
		if (storeKind == null || "null".equals(storeKind))
			storeKind = "";
		if (storeProvience == null || "null".equals(storeProvience))
			storeKind = "";

		if (dao == null)
			dao = new searchStoreDAO();
		if (storeKind == "")// 店名和地区名均为模糊查询,省份是精确查询,店的类型是列表精确查询。
			sqlWhere = "where area like '%" + area
					+ "%' and [storeName] like '%" + storeName + "%' ";
		else if (storeKind != "")
			sqlWhere = "where area like '%" + area
					+ "%' and [storeName] like '%" + storeName
					+ "%' and storeType='" + storeKind + "'";
		if (storeProvience != "") {
			sqlWhere = sqlWhere + " and [province]='" + storeProvience + "'";
		}
		Page page = new Page();
		int pageSize = (request.getParameter("pageSizeSelect") == null ? 10
				: Integer.parseInt(request.getParameter("pageSizeSelect")));
		int currentPage = (request.getParameter("page") == null ? 1 : Integer
				.parseInt(request.getParameter("page")));
		ArrayList al = new ArrayList();
		try {

			int count = dao.getPageInfo(sqlWhere, pageSize);
			page.setPageSize(pageSize);
			page.setRecordCount(count);
			page.setPageCount((count + pageSize - 1) / pageSize);
			page.setCurrentPage(currentPage);
			al = dao.getSearchStoreResult(sqlWhere, pageSize, currentPage);
		} 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");
		}
		request.setAttribute("storeList", al);
		request.setAttribute("Page", page);
		return new ActionForward("/searchMerchant.jsp");

	}
}