体育馆场地管理系统 JSP

package com.gym.control; import java.io.IOException; import java.io.PrintWriter; import java.sql.Timestamp; import java.util.Calendar; import java.util.List; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import com.gym.pojo.BooklistE; import com.gym.pojo.BooklistP; import com.gym.pojo.Client; import com.gym.pojo.Equipment; import com.gym.pojo.Playground; import com.gym.service.client.BookManager; import com.gym.service.client.ClientManager; import com.gym.service.client.DepartmentManager; import com.gym.service.client.EquipmentManager; import com.gym.service.client.PlaygroundManager; public class BookAction extends HttpServlet { PlaygroundManager playgroundManager = new PlaygroundManager(); EquipmentManager equipmentManager = new EquipmentManager(); BookManager bookManager = new BookManager(); DepartmentManager departmentManager = new DepartmentManager(); ClientManager clientManager = new ClientManager(); public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { this.doPost(request, response); } public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { String action = request.getParameter("action"); /** * 用户权限判断，如果没有管理员登陆，将跳转到error.jsp页面里 */ if(request.getSession().getAttribute("type")==null || request.getSession().getAttribute("username")==null) { String errMsg = "很抱歉，您没有权限执行该操作，请先登陆！"; request.setAttribute("errMsg", errMsg); request.getRequestDispatcher("/client/error.jsp").forward(request, response); return ; } if(action==null || action.equals("")) { action = "indexClient"; } if(action.equals("indexClient")) { request.getRequestDispatcher("/client/index.jsp").forward(request, response); } //列出我的所有预约信息 if(action.equals("myBookList")) { String username = (String)request.getSession().getAttribute("username"); Client client = clientManager.findByClientName(username); List bookListP = bookManager.playgroundBookByClientName(username); List bookListE = bookManager.equipmentBookByClientName(username); request.setAttribute("client", client); request.setAttribute("bookListP", bookListP); request.setAttribute("bookListE", bookListE); request.getRequestDispatcher("/client/myBookList.jsp").forward(request, response); } //查看我的某个预约的详细信息 if(action.equals("bookListDetail")) { String type = request.getParameter("type"); String username = (String)request.getSession().getAttribute("username"); int bookListId = Integer.parseInt(request.getParameter("bookListId")); Client client = clientManager.findByClientName(username); request.setAttribute("client", client); if(type.equals("1")) { BooklistP bookp = bookManager.playgroundBookById(bookListId); request.setAttribute("bookp", bookp); request.setAttribute("type", type); request.getRequestDispatcher("/client/bookDetail.jsp").forward(request, response); } else if(type.equals("2")) { BooklistE booke = bookManager.equipmentBookById(bookListId); request.setAttribute("booke", booke); request.setAttribute("type", type); request.getRequestDispatcher("/client/bookDetail.jsp").forward(request, response); } else { String errMsg = "您提交的数据不正确，请重试！"; request.getRequestDispatcher("/client/error.jsp").forward(request, response); } } //取消某个预约信息 if(action.equals("quitBook")) { String type = request.getParameter("type"); String username = (String)request.getSession().getAttribute("username"); int bookListId = Integer.parseInt(request.getParameter("bookListId")); if(type.equals("1")) { BooklistP book = bookManager.playgroundBookById(bookListId); if(!book.getClient().getClientName().equals(username)) { String errMsg = "您没有权限取消本预约，请核对后再试！"; request.getRequestDispatcher("/client/error.jsp").forward(request, response); } else { bookManager.deleteBookListP(bookListId); Client client = clientManager.findByClientName(username); List bookListP = bookManager.playgroundBookByClientName(username); List bookListE = bookManager.equipmentBookByClientName(username); request.setAttribute("client", client); request.setAttribute("bookListP", bookListP); request.setAttribute("bookListE", bookListE); request.getRequestDispatcher("/client/myBookList.jsp").forward(request, response); } } else if(type.equals("2")) { BooklistE book = bookManager.equipmentBookById(bookListId); if(!book.getClient().getClientName().equals(username)) { String errMsg = "您没有权限取消本预约，请核对后再试！"; request.getRequestDispatcher("/client/error.jsp").forward(request, response); } else { bookManager.deleteBookListE(bookListId); Client client = clientManager.findByClientName(username); List bookListP = bookManager.playgroundBookByClientName(username); List bookListE = bookManager.equipmentBookByClientName(username); request.setAttribute("client", client); request.setAttribute("bookListP", bookListP); request.setAttribute("bookListE", bookListE); request.getRequestDispatcher("/client/myBookList.jsp").forward(request, response); } } else { String errMsg = "您提交的数据不正确，请重试！"; request.getRequestDispatcher("/client/error.jsp").forward(request, response); } } //跳转到预约场地预约的页面 if(action.equals("bookPlayground")) { int playground_id = Integer.parseInt(request.getParameter("playground_id")); Playground playground = playgroundManager.findById(playground_id); List bookList = bookManager.findByPlaygroundId(playground_id); List allDepartment = departmentManager.findAllDepartment(); request.setAttribute("playground", playground); request.setAttribute("bookList", bookList); request.setAttribute("allDepartment", allDepartment); request.getRequestDispatcher("/client/bookPlayground.jsp").forward(request, response); } //场地预约处理程序 if(action.equals("bookPlaygroundDeal")) { int playground_id = Integer.parseInt(request.getParameter("playground_id")); int year = Integer.parseInt(request.getParameter("year")); int month = Integer.parseInt(request.getParameter("month")); int day = Integer.parseInt(request.getParameter("day")); int starttime = Integer.parseInt(request.getParameter("starttime")); int endtime = Integer.parseInt(request.getParameter("endtime")); String username = (String)request.getSession().getAttribute("username"); Calendar c = Calendar.getInstance(); Client client = clientManager.findByClientName(username); Playground playground = playgroundManager.findById(playground_id); Timestamp book_time = new Timestamp(c.get(Calendar.YEAR)-1900,c.get(Calendar.MONTH),c.get(Calendar.DAY_OF_MONTH),c.get(Calendar.HOUR_OF_DAY),c.get(Calendar.MINUTE),0,0); Timestamp start_time = new Timestamp(year-1900,month-1,day,starttime,0,0,0); Timestamp end_time = new Timestamp(year-1900,month-1,day,endtime,0,0,0); if(bookManager.testBookPlayground(playground, book_time, start_time, end_time).equals("ok")) { BooklistP bkltp = new BooklistP(client,playground,book_time,start_time,end_time); bookManager.saveBookListP(bkltp); playground = playgroundManager.findById(playground_id); List bookList = bookManager.findByPlaygroundId(playground_id); List allDepar