faqaction.java

论坛软件系统亦称电子公告板(BBS)系统

package cn.jsprun.struts.foreg.actions;

import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;
import org.apache.struts.actions.DispatchAction;

import cn.jsprun.service.system.DataBaseService;
import cn.jsprun.utils.BeanFactory;
import cn.jsprun.utils.Common;

public class FaqAction extends DispatchAction {
	private DataBaseService dataBaseService = (DataBaseService) BeanFactory.getBean("dataBaseService");
	@SuppressWarnings("unchecked")
	public ActionForward toDistags(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) {
		String action = request.getParameter("action");
		if (action == null) {
			List<Map<String,String>> faqparent=new ArrayList<Map<String,String>>();
			Map<String,List<Map<String,String>>> faqsub=new HashMap<String,List<Map<String,String>>>();
			List<Map<String,String>> faqs=dataBaseService.executeQuery("SELECT id, fpid, title FROM jrun_faqs ORDER BY displayorder");
			for(Map<String,String> faq:faqs){
				String fpid=faq.get("fpid");
				if("0".equals(fpid)){
					faqparent.add(faq);
				}else{
					List<Map<String,String>> sub=faqsub.get(fpid);
					if(sub==null){
						sub=new ArrayList<Map<String,String>>();
						faqsub.put(fpid, sub);
					}
					sub.add(faq);
				}
			}
			request.setAttribute("faqparent",faqparent);
			request.setAttribute("faqsub",faqsub);
		} else if("message".equals(action)){
			String id = request.getParameter("id");
			List<Map<String,String>> faqs=dataBaseService.executeQuery("SELECT * FROM jrun_faqs WHERE id='"+id+"'");
			if(faqs!=null&&faqs.size()>0){
				Map<String,String> faq=faqs.get(0);
				List<Map<String,String>> otherfaqs=dataBaseService.executeQuery("SELECT id, fpid, title FROM jrun_faqs WHERE fpid='"+faq.get("fpid")+"' AND id!='"+faq.get("id")+"' ORDER BY displayorder");
				request.setAttribute("navigation", "&raquo; "+faq.get("title"));
				request.setAttribute("faq", faq);
				request.setAttribute("otherfaqs",otherfaqs!=null&&otherfaqs.size()>0?otherfaqs:null);
			}else{
				request.setAttribute("successInfo", "指定的帮助项目不存在，请返回。");
				request.setAttribute("requestPath", "faq.jsp");
				return mapping.findForward("showMessage");
			}
		}else if("search".equals(action)){
			request.setAttribute("navigation","&raquo; 搜索帮助");
			String keyword=request.getParameter("keyword");
			if(keyword==null||"".equals(keyword.trim())){
				request.setAttribute("successInfo", "您没有指定要搜索的关键字，请返回重新填写。");
				request.setAttribute("requestPath", "faq.jsp");
				return mapping.findForward("showMessage");
			}
			String searchtype=request.getParameter("searchtype");
			if(!Common.matches(searchtype, "(all|title|message)")){
				searchtype="all";
			}
			String sqlsrch=null;
			if("all".equals(searchtype)){
				sqlsrch ="WHERE title LIKE '%"+keyword+"%' OR message LIKE '%"+keyword+"%'";
			}else if("title".equals(searchtype)){
				sqlsrch ="WHERE title LIKE '%"+keyword+"%'";
			}else if("message".equals(searchtype)){
				sqlsrch ="WHERE message LIKE '%"+keyword+"%'";
			}
			List<Map<String,String>> faqs=dataBaseService.executeQuery("SELECT fpid,title, message FROM jrun_faqs "+sqlsrch+" ORDER BY displayorder");
			if(faqs!=null&&faqs.size()>0){
				for(Map<String,String> faq:faqs){
					if(!"0".equals(faq.get("fpid"))){
						String title=faq.get("title");
						String message=faq.get("message");
						faq.put("title", Common.matches(title, "\\</?[a-zA-Z]*\\>")?title:title.replaceAll(keyword, "<u><b><font color='#FF0000'>"+keyword+"</font></b></u>"));
						faq.put("message", Common.matches(message, "\\</?[a-zA-Z]*\\>")?message:message.replaceAll(keyword, "<u><b><font color='#FF0000'>"+keyword+"</font></b></u>"));
					}
				}
			}
			request.setAttribute("faqs", faqs);
			request.setAttribute("keyword", keyword);
		}else{
			request.setAttribute("errorInfo", "未定义操作，请返回。");
			return mapping.findForward("showMessage");
		}
		request.setAttribute("action", action);
		return mapping.findForward("todisfaqs");
	}
}