留言公告管理系统J2EE

package com.ns.controller; import java.io.IOException; import java.sql.SQLException; import java.util.ArrayList; import java.util.Date; import java.util.List; import javax.servlet.RequestDispatcher; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import com.ns.bean.NoticeBean; import com.ns.dao.NoticeDao; public class NoticeServlet extends HttpServlet { @Override protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { this.doPost(req, resp); } @Override protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { req.setCharacterEncoding("utf-8"); int pageSize=10; String method=req.getParameter("method"); String title=req.getParameter("title"); String content=req.getParameter("content"); String publisher=""; String username=""; Date publishTime=null; NoticeBean notice=new NoticeBean(); NoticeDao noticeDao=new NoticeDao(); List<NoticeBean> notices=new ArrayList<NoticeBean>(); RequestDispatcher rd; //增加公告信息开始 if(method.equals("add")){ System.out.println("开始添加。。。"); notice=new NoticeBean(); publisher=(String)req.getSession().getAttribute("username"); publishTime=new Date(); notice.setTitle(title); notice.setContent(content); notice.setPublisher(publisher); notice.setPublishTime(publishTime); try{ noticeDao.addNotice(notice); req.setAttribute("method", "addnotice"); rd=req.getRequestDispatcher("/success.jsp"); rd.forward(req, resp); }catch(SQLException e){ rd=req.getRequestDispatcher("/failure.jsp"); rd.forward(req, resp); } }//增加公告信息结束 else if(method.equals("modifyall")){ int nowPage=Integer.parseInt(req.getParameter("nowPage")); int recordNum=0; int pageNum=0; username=(String)req.getSession().getAttribute("username"); try{ recordNum=noticeDao.getAllNotice(username); if((recordNum%pageSize)!=0){ pageNum=(recordNum/pageSize)+1; }else{ pageNum=recordNum/pageSize; } if(nowPage<=0){ nowPage=1; }else if(nowPage>pageNum){ nowPage=pageNum; } notices=noticeDao.getAllNotice(nowPage,pageSize,username); req.setAttribute("pageNum", pageNum); req.getSession().setAttribute("notices", notices); req.setAttribute("nowPage", nowPage); rd=req.getRequestDispatcher("/admin_modnotice.jsp"); rd.forward(req, resp); }catch(SQLException e){ rd=req.getRequestDispatcher("/failure.jsp"); rd.forward(req, resp); } } else if(method.equals("modifyone")){ int id=Integer.parseInt(req.getParameter("id")); try{ notice=noticeDao.getNoticeById(id); req.setAttribute("notice", notice); rd=req.getRequestDispatcher("/admin_modone.jsp"); rd.forward(req, resp); }catch(SQLException e){ rd=req.getRequestDispatcher("/failure.jsp"); rd.forward(req, resp); } } //修改公告信息开始 else if(method.equals("modify")){ int id=Integer.parseInt(req.getParameter("id")); publishTime=new Date(); notice=new NoticeBean(); notice.setId(id); notice.setTitle(title); notice.setContent(content); notice.setPublishTime(publishTime); try{ noticeDao.modifyNotice(notice); req.setAttribute("method", "modnotice"); rd=req.getRequestDispatcher("/success.jsp"); rd.forward(req, resp); }catch(SQLException e){ rd=req.getRequestDispatcher("/failure.jsp"); rd.forward(req, resp); } }//修改公告信息结束 //查询所有公告信息开始 else if(method.equals("selectall")){ int nowPage=Integer.parseInt(req.getParameter("nowPage")); int recordNum=0; int pageNum=0; try{ recordNum=noticeDao.getAllNotice(); if((recordNum%pageSize)!=0){ pageNum=(recordNum/pageSize)+1; }else{ pageNum=recordNum/pageSize; } if(nowPage<=0){ nowPage=1; }else if(nowPage>pageNum){ nowPage=pageNum; } notices=noticeDao.getAllNotice(nowPage,pageSize); req.setAttribute("pageNum", pageNum); req.getSession().setAttribute("notices", notices); req.setAttribute("nowPage", nowPage); rd=req.getRequestDispatcher("/common_notices.jsp"); rd.forward(req, resp); }catch(SQLException e){ rd=req.getRequestDispatcher("/failure.jsp"); rd.forward(req, resp); } }//查询所有公告信息结束 //查询部分公告信息开始 else if(method.equals("selectsome")){ int nowPage=Integer.parseInt(req.getParameter("nowPage")); int recordNum=0; int pageNum=0; username=(String)req.getSession().getAttribute("username"); try{ recordNum=noticeDao.getAllNotice(username); if((recordNum%pageSize)!=0){ pageNum=(recordNum/pageSize)+1; }else{ pageNum=recordNum/pageSize; } if(nowPage<=0){ nowPage=1; }else if(nowPage>pageNum){ nowPage=pageNum; } notices=noticeDao.getAllNotice(nowPage,pageSize,username); req.setAttribute("pageNum", pageNum); req.getSession().setAttribute("notices", notices); req.setAttribute("nowPage", nowPage); rd=req.getRequestDispatcher("/admin_notices.jsp"); rd.forward(req, resp); }catch(SQLException e){ rd=req.getRequestDispatcher("/failure.jsp"); rd.forward(req, resp); } }//查询部分公告信息结束 //查看公告信息的具体内容开始 else if(method.equals("selectone")){ int id=Integer.parseInt(req.getParameter("id")); try{ notice=noticeDao.getNoticeById(id); req.setAttribute("notice", notice); rd=req.getRequestDispatcher("/singlenotice.jsp"); rd.forward(req, resp); }catch(SQLException e){ rd=req.getRequestDispatcher("/failure.jsp"); rd.forward(req, resp); } }//查看公告信息的具体内容结束 else if(method.equals("deleteall")){ int nowPage=Integer.parseInt(req.getParameter("nowPage")); int recordNum=0; int pageNum=0; username=(String)req.getSession().getAttribute("username"); try{ recordNum=noticeDao.getAllNotice(username); if((recordNum%pageSize)!=0){ pageNum=(recordNum/pageSize)+1; }else{ pageNum=recordNum/pageSize; } if(nowPage<=0){ nowPage=1; }else if(nowPage>pageNum){ nowPage=pageNum; } notices=noticeDao.getAllNotice(nowPage,pageSize,username); req.setAttribute("pageNum", pageNum); req.getSession().setAttribute("notices", notices); req.setAttribute("nowPage", nowPage); rd=req.getRequestDispatcher("/admin_delnotice.jsp"); rd.forward(req, resp); }catch(SQLException e){ rd=req.getRequestDispatcher("/failure.jsp"); rd.forward(req, resp); } } else if(method.equals("delete")){ int id=Integer.parseInt(req.getParameter("id")); try{ noticeDao.deleteNoticeById(id); req.setAttribute("method", "delnotice"); rd=req.getRequestDispatcher("/success.jsp"); rd.forward(req, resp); }catch(SQLException e){ rd=req.getRequestDispatcher("/failure.jsp"); rd.forward(req, resp); } } } }