@Override public ActionForward execute( ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) throws Exception { modifyNoticeForm f = (modifyNoticeForm) form; Session s = HibernateSessionFactory.getSession(); try { s.beginTransaction(); // 获取当前时间 SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); String time = df.format(new Date()).toString(); Notice notice = (Notice) s.get(Notice.class, f.getNoticeid()); notice.setChangetime(time); notice.setContent(f.getContent()); notice.setTitle(f.getNoticetitle()); s.save(notice); s.getTransaction().commit(); s.close(); } catch (Exception ex) { if (s.getTransaction() != null) s.getTransaction().rollback(); ex.printStackTrace(); } return mapping.findForward("success"); }
@Override public ActionForward execute( ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) throws Exception { PrintWriter out = response.getWriter(); Session s = HibernateSessionFactory.getSession(); String role = request.getParameter("role"); if (role.equals("stu")) { Query query = s.createQuery("from Student"); int listNum = query.list().size(); int totalPage = listNum / PageItemNum; if (listNum % PageItemNum != 0) totalPage++; Integer Stupn = (Integer) request.getSession().getAttribute("Stupn"); if (Stupn == null) { request.getSession().setAttribute("Stupn", 1); Stupn = 1; } int limit = totalPage + 1; if (listNum == 0) limit = 2; out.println(limit + "," + Stupn); } else if (role.equals("tea")) { Query query = s.createQuery("from Teacher"); int listNum = query.list().size(); int totalPage = listNum / PageItemNum; if (listNum % PageItemNum != 0) totalPage++; Integer Teapn = (Integer) request.getSession().getAttribute("Teapn"); if (Teapn == null) { request.getSession().setAttribute("Teapn", 1); Teapn = 1; } int limit = totalPage + 1; if (listNum == 0) limit = 2; out.println(limit + "," + Teapn); } else if (role.equals("course")) { Query query = s.createQuery("from Course"); int listNum = query.list().size(); int totalPage = listNum / PageItemNum; if (listNum % PageItemNum != 0) totalPage++; Integer Coursepn = (Integer) request.getSession().getAttribute("Coursepn"); if (Coursepn == null) { request.getSession().setAttribute("Coursepn", 1); Coursepn = 1; } int limit = totalPage + 1; if (listNum == 0) limit = 2; out.println(limit + "," + Coursepn); } else if (role.equals("uncheckedStu")) { Query query = s.createQuery("from Unchecked un where un.role='stu'"); int listNum = query.list().size(); int totalPage = listNum / PageItemNum; if (listNum % PageItemNum != 0) totalPage++; Integer UncheckedStupn = (Integer) request.getSession().getAttribute("UncheckedStupn"); if (UncheckedStupn == null) { request.getSession().setAttribute("UncheckedStupn", 1); UncheckedStupn = 1; } int limit = totalPage + 1; if (listNum == 0) limit = 2; // System.out.println("limitstu:"+limit+" uncheckedstupn:"+UncheckedStupn); out.println(limit + "," + UncheckedStupn); } else if (role.equals("uncheckedTea")) { Query query = s.createQuery("from Unchecked un where un.role='tea'"); int listNum = query.list().size(); int totalPage = listNum / PageItemNum; if (listNum % PageItemNum != 0) totalPage++; Integer UncheckedTeapn = (Integer) request.getSession().getAttribute("UncheckedTeapn"); if (UncheckedTeapn == null) { request.getSession().setAttribute("UncheckedTeapn", 1); UncheckedTeapn = 1; } int limit = totalPage + 1; if (listNum == 0) limit = 2; out.println(limit + "," + UncheckedTeapn); } else if (role.equals("admin")) { Query query = s.createQuery("from Admin"); int listNum = query.list().size(); int totalPage = listNum / PageItemNum; if (listNum % PageItemNum != 0) totalPage++; Integer Adminpn = (Integer) request.getSession().getAttribute("Adminpn"); if (Adminpn == null) { request.getSession().setAttribute("Adminpn", 1); Adminpn = 1; } int limit = totalPage + 1; if (listNum == 0) limit = 2; out.println(limit + "," + Adminpn); } else if (role.equals("teaCourse")) { String userid = (String) request.getSession().getAttribute("userid"); Query query = s.createQuery("from Course c where c.teacher.id = '" + userid + "'"); int listNum = query.list().size(); int totalPage = listNum / PageItemNum; if (listNum % PageItemNum != 0) totalPage++; Integer Teacoursepn = (Integer) request.getSession().getAttribute("Teacoursepn"); if (Teacoursepn == null) { request.getSession().setAttribute("Teacoursepn", 1); Teacoursepn = 1; } int limit = totalPage + 1; if (listNum == 0) limit = 2; out.println(limit + "," + Teacoursepn); } else if (role.equals("stuRelCourse")) { String userid = (String) request.getSession().getAttribute("userid"); Student student = (Student) s.get(Student.class, userid); List<Course> allCourses = new ArrayList(student.getCourses()); int listNum = allCourses.size(); int totalPage = listNum / PageItemNum; if (listNum % PageItemNum != 0) totalPage++; Integer StuRelcoursepn = (Integer) request.getSession().getAttribute("StuRelcoursepn"); if (StuRelcoursepn == null) { request.getSession().setAttribute("StuRelcoursepn", 1); StuRelcoursepn = 1; } int limit = totalPage + 1; if (listNum == 0) limit = 2; out.println(limit + "," + StuRelcoursepn); } else if (role.equals("stuAllCourse")) { Query query = s.createQuery("from Course"); int listNum = query.list().size(); int totalPage = listNum / PageItemNum; if (listNum % PageItemNum != 0) totalPage++; Integer StuAllcoursepn = (Integer) request.getSession().getAttribute("StuAllcoursepn"); if (StuAllcoursepn == null) { request.getSession().setAttribute("StuAllcoursepn", 1); StuAllcoursepn = 1; } int limit = totalPage + 1; if (listNum == 0) limit = 2; out.println(limit + "," + StuAllcoursepn); } else if (role.equals("stuAllNotice")) { Query query = s.createQuery("from Notice"); int listNum = query.list().size(); int totalPage = listNum / PageItemNum; if (listNum % PageItemNum != 0) totalPage++; Integer StuAllnoticepn = (Integer) request.getSession().getAttribute("StuAllnoticepn"); if (StuAllnoticepn == null) { request.getSession().setAttribute("StuAllnoticepn", 1); StuAllnoticepn = 1; } int limit = totalPage + 1; if (listNum == 0) limit = 2; out.println(limit + "," + StuAllnoticepn); } else if (role.equals("homework")) { s.beginTransaction(); Integer taskid = (Integer) request.getSession().getAttribute("homeworktaskid"); Task task = (Task) s.get(Task.class, taskid); request.setAttribute("tasktitle", task.getTitle()); Query query = s.createQuery("from Work wk where taskid = '" + taskid + "'"); int listNum = query.list().size(); int totalPage = listNum / PageItemNum; if (listNum % PageItemNum != 0) totalPage++; Integer Homeworkpn = (Integer) request.getSession().getAttribute("Homeworkpn"); if (Homeworkpn == null) { request.getSession().setAttribute("Homeworkpn", 1); Homeworkpn = 1; } int limit = totalPage + 1; if (listNum == 0) limit = 2; out.println(limit + "," + Homeworkpn); } out.flush(); out.close(); s.close(); return super.execute(mapping, form, request, response); }