querystockaction.java

gensou.rar为某渔具厂的一个简单ERP系统。为比较基础的工程

//Created by MyEclipse Struts
// XSL source (default): platform:/plugin/com.genuitec.eclipse.cross.easystruts.eclipse_4.1.1/xslt/JavaClass.xsl

package com.gensou.struts.depot.stock;

import java.util.List;

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.gensou.dao.depot.stock.KucunDao;
import com.gensou.util.PagesMax;

/** 
 * MyEclipse Struts
 * Creation date: 01-26-2007
 * 
 * XDoclet definition:
 * @struts.action path="/queryStock" name="queryStockForm" scope="request" validate="true"
 */
public class QueryStockAction extends Action {

	// --------------------------------------------------------- Instance Variables

	// --------------------------------------------------------- Methods

	/** 
	 * Method execute
	 * @param mapping
	 * @param form
	 * @param request
	 * @param response
	 * @return ActionForward
	 */
	public ActionForward execute(
		ActionMapping mapping,
		ActionForm form,
		HttpServletRequest request,
		HttpServletResponse response) {
		QueryStockForm queryStockForm = (QueryStockForm) form;
		String pinming="";
		String guige="";
		String pageS=request.getParameter("pageS");
		int pageI;
		try{pageI=Integer.parseInt(pageS);}catch(Exception e){pageI=1;}
		try{
			pinming=queryStockForm.getPinming();
			guige=queryStockForm.getGuige();
		}catch(NullPointerException npe){
			pinming=request.getParameter("pinming");
			guige=request.getParameter("guige");
		}
		String hql="select count(id) from Kucunxinxi";
		if((pinming==null || pinming.equals(""))&& (guige==null || guige.equals(""))){
            //TODO Auto-generated method stub
			pinming="";
			guige="";
		}else{
			if(pinming!=null && !pinming.equals("") && guige!=null && !guige.equals("")){
			    hql+=" where pinming like "+"'%"+pinming+"%' and guige like "+"'%"+guige+"%'";
			}else{
				if((pinming==null || pinming.equals(""))&& guige!=null && !guige.equals("")){
					hql+=" where guige like "+"'%"+guige+"%'";
				}else{
					hql+=" where pinming like "+"'%"+pinming+"%'";
				}
			}
		}		
		int maxPage=PagesMax.max(hql);
		KucunDao kcDao=new KucunDao();
		List list=kcDao.queryKucun(pinming,guige,pageI,maxPage);
		if(list.size()==0){
			request.setAttribute("error","没有符合条件的记录");
		}else{
			request.setAttribute("pinming",pinming);
			request.setAttribute("guige",guige);
			request.setAttribute("pageS",pageI+"");
			request.setAttribute("maxPage",maxPage+"");
			request.setAttribute("list",list);
		}
		return mapping.findForward("toQuery");
	}

}