//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 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 org.infosys.logic.ClassList;import org.infosys.logic.ComList;import org.infosys.logic.CommonInfo;import org.infosys.logic.InfoList;import org.infosys.logic.InfoTips;import org.infosys.logic.PagesInfo;import org.infosys.security.Check;import org.infosys.util.DbPages;import org.infosys.util.ParamUtil;/**  * MyEclipse Struts * Creation date: 08-27-2005 *  * XDoclet definition: * @struts:action * @struts:action-forward name="admin/info_man" path="/admin/info_man.jsp" */public class Info_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) {		//驗證登錄以及權限		String isrights=Check.isRights(request,response);		if(!isrights.equals("OK")){			org.infosys.security.Check.redirectErr(request,response,"err.do?errmsg="+isrights);			return null;		}else{			//業務邏輯			boolean isdata=false;			int pageSize=org.infosys.common.Constants.PAGE_SIZE;			String page=request.getParameter("page");			page=(page==null)?"1":page.trim();						//構建查詢過濾語句-start			String newsClass=request.getParameter("newsclass");			String keywords=request.getParameter("keywords");			String sqlFilter="";			if(newsClass==null){				newsClass="0";			}			if(keywords!=null && !keywords.equals("")){			   keywords=ParamUtil.sqlStrchop(keywords);			   sqlFilter=" and (a.title like '%"+keywords+"%' or a.content like '%"+keywords+"%' or a.pubuser like '%"+keywords+"%' or a.infofrom like '%"+keywords+"%' or a.pubdate like '%"+keywords+"%')";			}else{			   keywords="";			}			if(!newsClass.equals("0")){			   sqlFilter+=" and a.infoclass like '%,"+newsClass+",%'";			}			//構建查詢過濾語句-end						ComList itera=new ComList();			String dbPagesArr[]=(new DbPages()).GetPageInfo(pageSize,page,"select count(*) from TblNews a where a.status in (0,1) "+sqlFilter,"info_man.do?newsclass="+newsClass+"&keywords="+keywords+"&");			String PagesStr=dbPagesArr[2];			Integer.parseInt(dbPagesArr[0]);			itera=(new InfoList()).get(Integer.parseInt(dbPagesArr[0]),pageSize,sqlFilter);			dbPagesArr=null;			if(itera.getParamlist()!=null && itera.getParamlist().size()>0){				isdata=true; //有數據			}			request.setAttribute("ComList",itera);					if(isdata){ //有數據				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;			//顯示class列表			request.setAttribute("ClassList",new ClassList(newsClass));			request.setAttribute("CommonInfo",new CommonInfo(keywords));			return mapping.findForward("admin/info_man");		}	}}