serachpublishdo.java

一个bbs论坛系统

package com.lovo.servlet;

import com.lovo.factory.BOFactory;
import com.lovo.po.PublishPO;
import com.lovo.po.ReplyPO;
import com.lovo.po.UserPO;

import java.io.IOException;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;


public class SerachPublishDO extends HttpServlet {
	protected void doGet(HttpServletRequest request,
			HttpServletResponse response) throws ServletException, IOException {
		this.doPost(request, response);
	}

	protected void doPost(HttpServletRequest request,
			HttpServletResponse response) throws ServletException, IOException {
		request.setCharacterEncoding("utf-8");
		response.setContentType("text/html;charset=utf-8");
		response.setCharacterEncoding("utf-8");
		
		HttpSession session = request.getSession(true);
		String condition = request.getParameter("condition");
		String key = request.getParameter("key");
		List<PublishPO> serachPublisnList = (List)session.getAttribute("serachPublisnList");
		if(serachPublisnList == null) {
			serachPublisnList = new ArrayList<PublishPO>();
		}
		if(key == "") {
			response.sendRedirect("web/search.jsp");
			return;
		}
		if(condition.equals("0")) {
			serachPublisnList = this.queryByPublishUser(key, request, response);
		} else if(condition.equals("1")) {
			serachPublisnList = this.queryByReplyUser(key, request, response);
		} else if(condition.equals("4")) {
			serachPublisnList = this.queryByPublishTitle(key, request, response);
		} else if(condition.equals("5")) {
			serachPublisnList = this.queryByPublishContent(key, request, response);
		}
		for(int i=0; i<serachPublisnList.size(); i++) {
			PublishPO publish = serachPublisnList.get(i);
			UserPO publishMan = BOFactory.getUserBOInstance().queryById(publish.getPublishMan().getId());
			publish.setPublishMan(publishMan);
		}
		session.setAttribute("serachPublisnList", serachPublisnList);
		response.sendRedirect("web/search.jsp");
	}
	//0.根据发帖人查询帖子
	public List<PublishPO> queryByPublishUser(String key, HttpServletRequest request,
			HttpServletResponse response) throws IOException {
		UserPO publishMan = BOFactory.getUserBOInstance().queryByName(key);
		if(publishMan == null) {
			response.sendRedirect("web/search.jsp");
			return null;
		}
		List<PublishPO> searchPublishList = BOFactory.getPublishBOInstance().queryPubByUserid(publishMan.getId());
		return searchPublishList;
	}
	
	//1.根据回帖人查询帖子
	public List<PublishPO> queryByReplyUser(String key, HttpServletRequest request,
			HttpServletResponse response) throws IOException {
		UserPO replyMan = BOFactory.getUserBOInstance().queryByName(key);
		if(replyMan == null) {
			response.sendRedirect("web/search.jsp");
			return null;
		}
		//查询replyMan的回帖
		List<PublishPO> searchPublishList = new ArrayList<PublishPO>();
		List<ReplyPO> replyList = BOFactory.getReplyBoInstance().queryRepByUserId(replyMan.getId());
		for(int i=0; i<replyList.size(); i++) {
			ReplyPO reply = replyList.get(i);
			PublishPO publish = BOFactory.getPublishBOInstance().queryById(reply.getPublish().getId());
			searchPublishList.add(publish);
		}
		return searchPublishList;
	}
	//2.根据区域搜索帖子
	public List<PublishPO> queryByArea(String key, HttpServletRequest request,
			HttpServletResponse response) throws IOException {
				return null;
		
	}
	//4.根据帖子标题查询
	
	public List<PublishPO> queryByPublishTitle(String key, HttpServletRequest request,
			HttpServletResponse response) throws IOException {
		
		List<PublishPO> searchPublishList = null;
		try {
			searchPublishList = BOFactory.getPublishBOInstance().queryByTitle(key);
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return searchPublishList;
	}
	
	//5.根据帖子内容搜索
	
	public List<PublishPO> queryByPublishContent(String key, HttpServletRequest request,
			HttpServletResponse response) throws IOException {
		
		List<PublishPO> searchPublishList = null;
		try {
			searchPublishList = BOFactory.getPublishBOInstance().queryByContent(key);
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return searchPublishList;
	}
}