queryuseraction.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.user;

import java.util.ArrayList;
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.mange.user.UserDao;
import com.gensou.struts.mamage.user.form.QueryUserForm;
import com.gensou.util.PagesMax;

/** 
 * MyEclipse Struts
 * Creation date: 01-27-2007
 * 
 * XDoclet definition:
 * @struts.action path="/queryUser" name="queryUserForm" scope="request" validate="true"
 * @struts.action-forward name="queryUserY" path="/gjsp/manage/user/queryUser.jsp"
 * @struts.action-forward name="queryUserN" path="/gjsp/manage/user/queryUser.jsp"
 */
public class QueryUserAction extends Action {

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

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

	/** 
	 * Method execute
	 * @param mapping
	 * @param form
	 * @param request
	 * @param response
	 * @return ActionForward
	 * @throws Exception 
	 */
	public ActionForward execute(
		ActionMapping mapping,
		ActionForm form,
		HttpServletRequest request,
		HttpServletResponse response) throws Exception {
		QueryUserForm queryUserForm = (QueryUserForm) form;
		String way = null;
		String trams=null;
		String pages=request.getParameter("pageS");
		int pagei=Integer.parseInt(pages);
		String hql;
		int maxpage=1;
		UserDao user = new UserDao();
		List list=new ArrayList();
		try{
			
			way=queryUserForm.getWay();
			trams=queryUserForm.getTrams();
			if(way==null||way.equals("")||trams==null||trams.equals("")){
				way=(String)request.getParameter("way");
				trams=(String)request.getParameter("trams");
				if(way==null||way.equals("")||trams==null||trams.equals("")){
					 hql="select count(id) from Yonghubiao";
						
					 maxpage=PagesMax.max(hql);
					 
					 list=user.queryUser(way,trams,pagei,maxpage);
				}
			}else{
				hql="select count(id) from Yonghubiao where "+way+" like '%"+trams+"%'";
				maxpage=PagesMax.max(hql);
				list=user.queryUser(way,trams,pagei,maxpage);
			}
		}catch(NullPointerException e){}

		if(list != null && !list.isEmpty()){
			request.setAttribute("way",way);
			request.setAttribute("trams",trams);
			request.setAttribute("pageS",pagei+"");
			request.setAttribute("maxpages",maxpage+"");
			request.setAttribute("queryUser",list);
			return mapping.findForward("queryUserY");
		}else{
			String queryUserError = "没有符合查询条件的数据！";
			request.setAttribute("queryUserError",queryUserError);
			return mapping.findForward("queryUserN");
		}
	}

}