//Created by MyEclipse Struts// XSL source (default): platform:/plugin/com.genuitec.eclipse.cross.easystruts.eclipse_3.8.4/xslt/JavaClass.xslpackage com.infosys.struts.action;import java.util.ArrayList;import java.util.List;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import net.sf.hibernate.HibernateException;import net.sf.hibernate.Query;import net.sf.hibernate.Session;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 org.infosys.logic.ComList;import org.infosys.logic.ComParam;import org.infosys.logic.InfoTips;import org.infosys.logic.PagesInfo;import org.infosys.security.Check;import org.infosys.util.DbPages;import com.infosys.Hibernate.PGroup;import com.infosys.Hibernate.SessionFactory;/**  * MyEclipse Struts * Creation date: 08-25-2005 *  * XDoclet definition: * @struts:action path="/admin/group_man" name="group_manForm" input="/admin/group_man.jsp" scope="request" validate="true" * @struts:action-forward name="admin/group_man" path="/admin/group_man.jsp" */public class Group_manAction 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) {		//驗(yàn)證登錄以及權(quán)限		String isrights=Check.isRights(request,response);		if(!isrights.equals("OK")){			org.infosys.security.Check.redirectErr(request,response,"err.do?errmsg="+isrights);			return null;		}else{			//業(yè)務(wù)邏輯			boolean isdata=false;			int pageSize=org.infosys.common.Constants.PAGE_SIZE;			String page=request.getParameter("page");			page=(page==null)?"1":page.trim();			ComList itera=new ComList();			ComParam para;			String PagesStr="";			Session session;			try {				session = SessionFactory.currentSession();				int totalNum=((Integer)session.createQuery("select count(*) from PGroup p").uniqueResult()).intValue();				String dbPagesArr[]=(new DbPages()).GetPageInfo(totalNum+"",pageSize,page,"group_man.do?");				PagesStr=dbPagesArr[2];				Query query=session.createQuery("from PGroup p order by p.code asc");				query.setFirstResult(Integer.parseInt(dbPagesArr[0]));				query.setMaxResults(pageSize);				List querylist=query.list();				if(querylist!=null && querylist.size()>0){					List list=new ArrayList();					PGroup groupObj;					String bgcolor="#ffffff";					for(int i=0;i<querylist.size();i++){						bgcolor=((i % 2)==0)?"#ffffff":"#eaeaea";						groupObj=(PGroup)querylist.get(i);						para=new ComParam();						para.setParam0(bgcolor);						para.setParam1(groupObj.getGroupid());						para.setParam2(groupObj.getName());						para.setParam3(groupObj.getCode());						para.setParam4(groupObj.getRemark());						para.setParam5((groupObj.getStatus().intValue()==1)?"啟用":"停用");						list.add(para);					}					itera.setParamlist(list);					groupObj=null;					isdata=true; //有數(shù)據(jù)				}				dbPagesArr=null;				querylist=null;			} catch (HibernateException e) {				e.printStackTrace();			} finally {				try {					SessionFactory.closeSession();				} catch (HibernateException e1) {					e1.printStackTrace();				}			}						request.setAttribute("ComList",itera);			if(isdata){ //有數(shù)據(jù)				PagesInfo pagesinfo=new PagesInfo();				pagesinfo.setPageinfo(PagesStr);				request.setAttribute("PagesInfo",pagesinfo);			}else{				InfoTips infotips=new InfoTips();				infotips.setTipsInfo("No data");				request.setAttribute("InfoTips",infotips);			}			itera=null;			return mapping.findForward("admin/group_man");		}	}}