You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
115 lines
2.4 KiB
115 lines
2.4 KiB
package servlet;
|
|
|
|
import java.io.IOException;
|
|
import java.util.List;
|
|
import java.util.Map;
|
|
|
|
import javax.servlet.RequestDispatcher;
|
|
import javax.servlet.ServletConfig;
|
|
import javax.servlet.ServletException;
|
|
import javax.servlet.http.HttpServlet;
|
|
import javax.servlet.http.HttpServletRequest;
|
|
import javax.servlet.http.HttpServletResponse;
|
|
import javax.servlet.http.HttpSession;
|
|
|
|
import util.Util;
|
|
import bean.User;
|
|
import bean.Wenti;
|
|
import dao.WentiDao;
|
|
|
|
|
|
|
|
public class ShouyeServlet extends HttpServlet {
|
|
|
|
|
|
|
|
|
|
private static final long serialVersionUID = 1L;
|
|
|
|
|
|
|
|
public void init(ServletConfig config) throws ServletException {
|
|
// TODO Auto-generated method stub
|
|
super.init(config);
|
|
}
|
|
|
|
|
|
public void destroy() {
|
|
|
|
super.destroy();
|
|
}
|
|
|
|
|
|
protected void doGet(HttpServletRequest req, HttpServletResponse resp)
|
|
throws ServletException, IOException {
|
|
this.doPost(req, resp);
|
|
}
|
|
|
|
protected void doPost(HttpServletRequest request, HttpServletResponse response)
|
|
throws ServletException, IOException {
|
|
|
|
//分页页数定义
|
|
int pagenum =1;//当前页
|
|
int pagesize = 4;//每页显示的数量
|
|
|
|
WentiDao wentiDao = new WentiDao();
|
|
|
|
HttpSession session = request.getSession();
|
|
User u = (User)session.getAttribute("user");
|
|
|
|
|
|
String wenti = request.getParameter("wenti");
|
|
|
|
String url = "shouye";
|
|
|
|
if(request.getParameter("pagenum")!=null){
|
|
pagenum = Integer.parseInt(request.getParameter("pagenum"));
|
|
}
|
|
StringBuffer sb = new StringBuffer();
|
|
sb.append(" where ");
|
|
|
|
if(wenti!=null&&!"".equals(wenti)){
|
|
wenti = Util.bianma(wenti);
|
|
|
|
sb.append(" wenti like '%"+wenti+"%' ");
|
|
sb.append(" and ");
|
|
|
|
request.setAttribute("wenti", wenti);
|
|
}
|
|
|
|
if(u==null){
|
|
|
|
sb.append(" kejianzhuangtai ='整个网络可见' ");
|
|
sb.append(" and ");
|
|
}else{
|
|
|
|
sb.append(" (fromuserid in (select fromuserid from t_haoyou where tuuserid="+u.getId()+" ) or kejianzhuangtai ='整个网络可见' )");
|
|
sb.append(" and ");
|
|
|
|
}
|
|
|
|
|
|
sb.append(" 1=1 ");
|
|
String where = sb.toString();
|
|
|
|
|
|
Map<String,List<Wenti>> map = wentiDao.getList(pagenum,pagesize,url,where);
|
|
|
|
String pagerinfo = map.keySet().iterator().next();
|
|
List<Wenti> list = map.get(pagerinfo);
|
|
|
|
|
|
request.setAttribute("pagerinfo", pagerinfo);
|
|
request.setAttribute("list", list);
|
|
|
|
|
|
RequestDispatcher dispatcher = request.getRequestDispatcher("/index.jsp");
|
|
dispatcher.forward(request, response);
|
|
|
|
|
|
|
|
|
|
}
|
|
|
|
}
|