querydrawaction.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.draw;

import java.util.Calendar;
import java.util.Date;
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.draw.LingliaoDao;
import com.gensou.util.PagesMax;

/** 
 * MyEclipse Struts
 * Creation date: 01-27-2007
 * 
 * XDoclet definition:
 * @struts.action path="/queryDraw" name="queryDrawForm" scope="request" validate="true"
 */
public class QueryDrawAction 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) {
		QueryDrawForm queryDrawForm = (QueryDrawForm) form;
		String pinming="";
		String guige="";
		String year;
		String month;
		String pageS=request.getParameter("pageS");
		int pageI;
		try{pageI=Integer.parseInt(pageS);}catch(Exception e){pageI=1;}
		try{
			pinming=queryDrawForm.getPinming();
			guige=queryDrawForm.getGuige();
			year=queryDrawForm.getYear();
			month=queryDrawForm.getMonth();
		}catch(NullPointerException npe){
			pinming=request.getParameter("pinming");
			guige=request.getParameter("guige");
			year=request.getParameter("year");
			month=request.getParameter("month");
		}
		if(year==null || year.equals("")){
			year=Calendar.getInstance().get(Calendar.YEAR)+"";
		}
		if(month==null || month.equals("")){
			month=(Calendar.getInstance().get(Calendar.MONTH)+1)+"";
		}
		String hql="select count(id) from Lingliaodan where riqi like '"+year+"-"+month+"%'";
		if((pinming==null || pinming.equals(""))&& (guige==null || guige.equals(""))){
			pinming="";
			guige="";
		}else{
			if(pinming!=null && !pinming.equals("") && guige!=null && !guige.equals("")){
			    hql+=" and pinming like "+"'%"+pinming+"%' and guige like "+"'%"+guige+"%'";
			}else{
				if((pinming==null || pinming.equals(""))&& guige!=null && !guige.equals("")){
					hql+=" and guige like "+"'%"+guige+"%'";
				}else{
					hql+=" and pinming like "+"'%"+pinming+"%'";
				}
			}
		}
		int maxPage=PagesMax.max(hql);
		LingliaoDao lingDao=new LingliaoDao();
		List list=lingDao.queryLingliao(pinming,guige,year+"-"+month,pageI,maxPage);
		if(list.size()==0){
			request.setAttribute("error","没有符合条件的记录");
		}else{
			request.setAttribute("year",year);
			request.setAttribute("month",month);
			request.setAttribute("pinming",pinming);
			request.setAttribute("guige",guige);
			request.setAttribute("pageS",pageI+"");
			request.setAttribute("maxPage",maxPage+"");
			request.setAttribute("list",list);
		}
		return mapping.findForward("toQuery");
	}

}