?? reaschstoreaction.java
字號(hào):
/*
* 作者:管磊
* 時(shí)間: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");// 地區(qū)
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 == "")// 店名和地區(qū)名均為模糊查詢,省份是精確查詢,店的類型是列表精確查詢。
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", "錯(cuò)誤信息");
session.setAttribute("message", "用戶名或密碼錯(cuò)誤,請(qǐng)重新登陸!");
session.setAttribute("returnUrl", "show.do?action=goLogin");
return mapping.findForward("goMessage");
}
request.setAttribute("storeList", al);
request.setAttribute("Page", page);
return new ActionForward("/searchMerchant.jsp");
}
}
?? 快捷鍵說(shuō)明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -