NEC.rar_jsp_jsp word_jsp 班级网站_word_班级 网站

package notice; //import javax.servlet. ; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import javax.servlet.ServletException; import java.io.IOException; import java.sql.Connection; import java.sql.*; import java.util.List; import java.util.ArrayList; import util.DBConnectionManager; import util.StringUtil; public class NoticeServlet extends HttpServlet { private String PATH = "/admin/notice/"; private String LIST_PAGE = PATH + "notice_list.jsp"; private String ADD_PAGE = PATH + "notice_add.jsp"; private String UPDATE_PAGE = PATH + "notice_update.jsp"; private String DELETE_PAGE = PATH + "notice_result.jsp"; private String DO_UPDATE_PAGE = PATH + "notice_result.jsp"; private String DO_ADD_PAGE = PATH + "notice_result.jsp"; private String ERROR_PAGE = "/admin/error.jsp"; private String DETAIL_PAGE=PATH+"notice_detail.jsp"; private int PAGE_SIZE=8; Connection conn=null; NoticeDAO dao=null; public void doGet(HttpServletRequest req,HttpServletResponse res)throws ServletException,IOException { doPost(req,res); } public void doPost(HttpServletRequest req,HttpServletResponse res)throws ServletException,IOException { DBConnectionManager dbManger=DBConnectionManager.getInstance(); conn=dbManger.getConnection("DBpool"); //conn=DBConnectionManager.getConnection(); /* try { //Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); //conn = DriverManager.getConnection("jdbc:odbc:humanresource"); conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=NECDB","sa","123456"); } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } */ String operType=req.getParameter("operType"); //System.out.println("the operation is: "+operType); if(operType.equals("list")) { list(req,res); } else if(operType.equals("add")) { add(req,res); } else if(operType.equals("do_add")) { do_add(req,res); } else if(operType.equals("update")) { update(req,res); } else if(operType.equals("do_update")) { do_update(req,res); } else if(operType.equals("delete")) { delete(req,res); }else if(operType.equals("detail")) { detail(req,res); } dbManger.freeConnection("DBpool",conn); } public void add(HttpServletRequest request,HttpServletResponse response)throws ServletException,IOException { NoticeDTO noticeDto = new NoticeDTO(); //request.setAttribute("operType", "do_add"); //request.setAttribute("noticeDto", noticeDto); request.getRequestDispatcher(ADD_PAGE).forward(request, response); } public void do_add(HttpServletRequest request,HttpServletResponse response)throws ServletException,IOException { NoticeDTO noticeDto = new NoticeDTO(); dao=new NoticeDAO(); noticeDto.setWriter(StringUtil.toCN(request.getParameter("writer"))); //System.out.println("writer: "+request.getParameter("writer")); noticeDto.setType(request.getParameter("type")); noticeDto.setTitle(StringUtil.toCN(request.getParameter("title"))); noticeDto.setContent(StringUtil.toCN(request.getParameter("content"))); //System.out.println(request.getParameter("content")); dao.setConnection(conn); boolean ok = dao.add(noticeDto); if (ok) { //request.setAttribute("deptDto", deptDto); request.getRequestDispatcher(DO_ADD_PAGE).forward(request,response); } else { request.setAttribute("msg", "新增数据时出错！"); request.getRequestDispatcher(ERROR_PAGE).forward(request, response); } } public void update(HttpServletRequest request,HttpServletResponse response)throws ServletException,IOException { String nid=(String)request.getParameter("nid"); //System.out.println(nid); dao=new NoticeDAO(); dao.setConnection(this.conn); NoticeDTO noticeDto =dao.getANotice(nid); //request.setAttribute("operType", "do_update"); request.setAttribute("noticeDto", noticeDto); request.getRequestDispatcher(UPDATE_PAGE).forward(request, response); } public void do_update(HttpServletRequest request,HttpServletResponse response)throws ServletException,IOException { NoticeDTO noticeDto = new NoticeDTO(); dao=new NoticeDAO(); noticeDto.setWriter(StringUtil.toCN(request.getParameter("writer"))); //System.out.println("writer: "+request.getParameter("writer")); noticeDto.setType(request.getParameter("type")); noticeDto.setTitle(StringUtil.toCN(request.getParameter("title"))); noticeDto.setContent(StringUtil.toCN(request.getParameter("content"))); //System.out.println(StringUtil.toCN(request.getParameter("content"))); noticeDto.setId(request.getParameter("nid")); dao.setConnection(conn); boolean ok = dao.update(noticeDto); if (ok) { //request.setAttribute("deptDto", deptDto); request.getRequestDispatcher(DO_ADD_PAGE).forward(request,response); } else { request.setAttribute("msg", "新增数据时出错！"); request.getRequestDispatcher(ERROR_PAGE).forward(request, response); } } public void delete(HttpServletRequest request,HttpServletResponse response)throws ServletException,IOException { String nid=request.getParameter("nid"); dao=new NoticeDAO(); dao.setConnection(this.conn); boolean ok=dao.delete(nid); if(ok) { request.getRequestDispatcher(DELETE_PAGE).forward(request,response); } else { request.setAttribute("msg", "删除数据是出错"); request.getRequestDispatcher(ERROR_PAGE).forward(request, response); } } public void list(HttpServletRequest request,HttpServletResponse response)throws ServletException,IOException { String parePage=(String)request.getParameter("page"); int totalPage=1; int page=1; List noticeList=new ArrayList(); //NoticeDTO cond = new NoticeDTO(); NoticeDAO dao=new NoticeDAO(); dao.setConnection(this.conn); int totalrecord=dao.getTotalNumber(); if(totalrecord % PAGE_SIZE ==0) totalPage = totalrecord / PAGE_SIZE; else totalPage = (int) Math.floor( totalrecord / PAGE_SIZE ) + 1; if(totalPage == 0) totalPage = 1; if(parePage==null || parePage.equals("")) page = 1; else try { page = Integer.parseInt(parePage); } catch(java.lang.NumberFormatException e){ page = 1; } if(page < 1) page = 1; if(page > totalPage) page = totalPage; noticeList=dao.getPageNotices(page); request.setAttribute("noticeList", noticeList); request.setAttribute("page",page); request.setAttribute("totalPage",totalPage); //System.out.println(noticeList.size()+"条记录将被传到.jsp"); request.getRequestDispatcher(LIST_PAGE).forward(request, response); //request.setAttribute("deptList", deptList); //request.getRequestDispatcher(LIST_PAGE).forward(request, response); } public void detail(HttpServletRequest request,HttpServletResponse response)throws ServletException,IOException { String nid=request.getParameter("nid"); dao=new NoticeDAO(); NoticeDTO noticeDTO=new NoticeDTO(); dao.setConnection(this.conn); noticeDTO=dao.getANotice(nid); request.setAttribute("NoticeDTO",noticeDTO); request.getRequestDispatcher(DETAIL_PAGE).forward(request,response); } }