北大青鸟ACCP5.0第二学年项目：E家园

package y2javaee.xmal2.operation; import java.util.ArrayList; import java.util.List; import java.util.Map; import javax.servlet.ServletRequest; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpSession; import javax.servlet.jsp.jstl.sql.Result; import y2javaee.xmal2.common.ArticleDao; import y2javaee.xmal2.common.IArticleDao; import y2javaee.xmal2.common.IuserDao; import y2javaee.xmal2.common.userDao; import y2javaee.xmal2.entity.Aritcle; import y2javaee.xmal2.entity.IAritcle; import y2javaee.xmal2.entity.IUsers; import y2javaee.xmal2.entity.Users; /* * 处理对文章的相关操作 **/ public class ArticleBo implements ICommand{ private String nextPage; private Result result; private IArticleDao dao=null; private IAritcle aritcle=null; public ArticleBo(String nextPage) { this.nextPage=nextPage; dao=new ArticleDao(); } public String execute(ServletRequest request) { String cmd=request.getParameter("cmd"); //处理搜索 if(cmd.equalsIgnoreCase("selectArticle")) { int type=0; type=Integer.parseInt(request.getParameter("type"));//文章类型 String title=request.getParameter("title");//标题 String writer=request.getParameter("writer");//作者 List values=new ArrayList(); String sqlValue=""; HttpSession session = ((HttpServletRequest)request).getSession(); IUsers user=(IUsers)session.getAttribute("user"); if(user==null) { sqlValue="select * from Article where 1=1"; } else { sqlValue="select * from Article where 1=1 and userid=?"; values.add(user.getUserId()); } if(type!=0) { values.add(type); sqlValue=sqlValue+" and type=?"; } if(!title.equalsIgnoreCase("")) { sqlValue=sqlValue+" and title like ?"; values.add("%"+title+"%"); } if(!writer.equalsIgnoreCase("")) { IuserDao uDao=new userDao(); result=uDao.validUser(writer); if(result!=null) { Map row=result.getRows()[0]; int uid=((Integer)row.get("userId")).intValue(); if(user!=null) { sqlValue=sqlValue+" or userID=?"; } else { sqlValue=sqlValue+" and userID=?"; } values.add(uid); }else { request.setAttribute("msg", "对不起，没有此作者!"); } } result=dao.selectArticleByType(values, sqlValue); /*HttpSession session = ((HttpServletRequest)request).getSession(); IUsers user=(IUsers)session.getAttribute("user"); int userID=0;//记录用户的纺号 //判断有没有输入作者查询 if(writer!="") { IuserDao uDao=new userDao(); result=uDao.validUser(writer); if(result!=null) { Map row=result.getRows()[0]; userID=((Integer)row.get("userId")).intValue(); } { userID=0; } } //判断有没有登录 if(user==null) { //非登录用户查询 if(title.equalsIgnoreCase("")&&writer.equalsIgnoreCase("")) { result=dao.selectArticleByType(type); } else if(!title.equalsIgnoreCase("")&&writer.equalsIgnoreCase("")) { result=dao.selectArticleByType(title,type); } else if(title.equalsIgnoreCase("")&&!writer.equalsIgnoreCase("")) { result=dao.selectArticleByType(type,userID); } else { result=dao.selectArticleByType(type,userID,title); } } else { //登录用户查贸询 if(title.equalsIgnoreCase("")&&writer.equalsIgnoreCase("")) { result=dao.selectArticleByType(type); } else if(!title.equalsIgnoreCase("")&&writer.equalsIgnoreCase("")) { result=dao.selectArticleByType(title,type); } else if(title.equalsIgnoreCase("")&&!writer.equalsIgnoreCase("")) { result=dao.selectArticleByType(type,user.getUserId()); } else if(!title.equalsIgnoreCase("")&&!writer.equalsIgnoreCase("")) { result=dao.selectArticleByType(type,user.getUserId(),title); } else { IuserDao uDao=new userDao(); result=uDao.validUser(user.getUserName()); Map row=result.getRows()[0]; int uid=((Integer)row.get("userId")).intValue(); dao=new ArticleDao(); result=dao.selectArticleByType(type,uid); } //跳转到登录用户页面 }*/ //判断有没有搜索到相关文章 if(result==null||result.getRowCount()==0) { request.setAttribute("msg", "没有你要找的相关文章"); } else { //实例list对象 List<IAritcle> list=new ArrayList<IAritcle>(); //调用静态方法把搜到的文章放在list列表中 list=ShowAllArticle.showArticle(result); //把搜到的条目放到请求中转到页面 request.setAttribute("list", list); } return this.nextPage; } //文章详细信息 else if(cmd.equalsIgnoreCase("articleParticular")) { HttpSession session = ((HttpServletRequest)request).getSession(); IUsers user=(Users)session.getAttribute("user"); if(user==null) { request.setAttribute("msg", "对不起，你还没有登录，请先登录！"); nextPage="/index.jsp"; } else { aritcle=new Aritcle(); //从请求中获得文章ID int articleID=Integer.parseInt(request.getParameter("articleId")); //查出对应文章详细信息 result=dao.selectArticleId(articleID); //调用自定义静态方法获得对应文章的详细信息 aritcle=ShowAllArticle.showArticleId(result); userDao uDao=new userDao(); //查出文章的作者 result=uDao.validUser(aritcle.getUserID()); Map row1=result.getRows()[0]; String userName=(String)row1.get("userName"); request.setAttribute("userName", userName); request.setAttribute("aritcle", aritcle); nextPage="/WEB-INF/jsp/show.jsp"; } return this.nextPage; } //显示某个类型的文章信息 else if(cmd.equalsIgnoreCase("article")) { HttpSession session = ((HttpServletRequest)request).getSession(); IUsers user=(Users)session.getAttribute("user"); aritcle=new Aritcle(); int type=Integer.parseInt(request.getParameter("type")); result=dao.selectArticleByType(type); //实例list对象 List<IAritcle> list=new ArrayList<IAritcle>(); //调用静态方法把搜到的文章放在list列表中 list=ShowAllArticle.showArticle(result); //把搜到的条目放到请求中转到页面 request.setAttribute("list", list); return this.nextPage; } //转到发表文章页面判断是否是登录用户 else if(cmd.trim().equalsIgnoreCase("publishPage")) { HttpSession session = ((HttpServletRequest)request).getSession(); IUsers user=new Users(); user=(Users)session.getAttribute("user"); if(user==null) { request.setAttribute("msg", "对不起!您还没有登录!请先登录!"); nextPage="/index.jsp"; } return this.nextPage; } //发表文章 else if(cmd.trim().equalsIgnoreCase("publish")) { String title=request.getParameter("title"); String content=request.getParameter("content"); int type=Integer.parseInt(request.getParameter("type")); HttpSession session = ((HttpServletRequest)request).getSession(); IUsers user=new Users(); user=(Users)session.getAttribute("user"); int userId=user.getUserId(); aritcle=new Aritcle(); aritcle.setTitle(title); aritcle.setContent(content); aritcle.setType(type); aritcle.setUserID(userId); int count=dao.insertArticle(aritcle); if(count==0) { request.setAttribute("msg", "发表失败,请刷新后重试"); } else { request.setAttribute("msg", "恭喜你！发表成功！"); } return this.nextPage; } //首页显示所有文章 else if(cmd.trim().equalsIgnoreCase("main")) { List[] ars=new ArrayList[4]; //调用自定义静态方法，取得所有文章 ars=ShowAllArticle.showArticle(); request.setAttribute("ars", ars); return this.nextPage; } return nextPage; } }