@RequestMapping(value = "/delete.do") public ModelAndView guestDelete(@RequestParam("idx") int data) { System.out.println("ModelAndView guestDelete(int)"); ModelAndView mav = new ModelAndView(); dao.dbDelete(data); // String url="/WEB-INF/views/guestDetail.jsp"; mav.setViewName("redirect:/list.do"); return mav; } // end
@RequestMapping(value = "/guestEdit.do") public ModelAndView guestEditForm(@RequestParam("idx") int idx) { ModelAndView mav = new ModelAndView(); GuestDTO dto = dao.dbDetail(idx); String url = "/WEB-INF/views/guestEdit.jsp"; mav.addObject("bean", dto); mav.setViewName(url); return mav; } // end
@RequestMapping(value = "/detail.do") // public ModelAndView guestDetail(@RequestParam("idx") int idx){ public ModelAndView guestDetail(HttpServletRequest request) { System.out.println("\nModelAndView guestDetail(int)"); ModelAndView mav = new ModelAndView(); int data = Integer.parseInt(request.getParameter("idx")); GuestDTO bean = dao.dbDetail(data); System.out.println("넘어온상세 idx = " + data); mav.addObject("bean", bean); String url = "/WEB-INF/views/guestDetail.jsp"; mav.setViewName(url); return mav; } // end
@RequestMapping(value = "/insert.do") public ModelAndView guestInsert(GuestDTO dto) { ModelAndView mav = new ModelAndView(); System.out.println("\nguestInsert(GuestDTO dto)"); System.out.println("Controller넘어온사번=" + dto.getSabun()); System.out.println("Controller넘어온이름=" + dto.getName()); System.out.println("Controller넘어온제목=" + dto.getTitle()); System.out.println("Controller넘어온급여=" + dto.getPay()); dao.dbInsert(dto); String url = "/WEB-INF/views/guestList.jsp"; mav.setViewName("redirect:list.do"); return mav; } // end
@RequestMapping(value = "/list.do") public ModelAndView guestList(@RequestParam(value = "pagenum", defaultValue = "1") int pagenum) { int countall = dao.countAll(); // int countall =286; int pageSize = 10; int limit = 8; int pageAll = 1; if (countall % pageSize == 0) { pageAll = (countall / pageSize); } else { pageAll = (countall / pageSize) + 1; } // int start = ((pagenum-1)*limit)+1; //[2]..11~ // int end = (pagenum*limit); //[2]..~20 int tmp = (pagenum - 1) % limit; int startPage = pagenum - tmp; int endPage = startPage + pageSize - 1; ModelAndView mav = new ModelAndView(); System.out.println("\nModelAndView guestList()"); List<GuestDTO> bean = dao.dbSelect(startPage, endPage); System.out.println("startPage : endPage :::: " + startPage + "\t" + endPage); System.out.println("pageAll : " + pageAll); // System.out.println("bean : " + bean.toString()); mav.addObject("pagenum", pagenum); mav.addObject("startPage", startPage); mav.addObject("endPage", endPage); mav.addObject("pageAll", pageAll); mav.addObject("bean", bean); mav.addObject("countAll", countall); String url = "/WEB-INF/views/guestList.jsp"; mav.setViewName(url); return mav; } // end
@RequestMapping(value = "/list2.do", method = RequestMethod.GET, consumes = "application/json") public @ResponseBody List<GuestDTO> guestList2( Model model, @RequestParam(value = "start", defaultValue = "1") int start, @RequestParam(value = "end", defaultValue = "10") int end, @RequestParam(value = "pagenum", defaultValue = "1") int pagenum) { System.out.println("list2 start end " + start + " :: " + end); int countall = dao.countAll(); // int countall =286; int pageSize = 10; int limit = 8; int pageAll = 1; if (countall % pageSize == 0) { pageAll = (countall / pageSize); } else { pageAll = (countall / pageSize) + 1; } // int start = ((pagenum-1)*limit)+1; //[2]..11~ // int end = (pagenum*limit); //[2]..~20 int tmp = (pagenum - 1) % limit; int startPage = pagenum - tmp; int endPage = startPage + pageSize - 1; ModelAndView mav = new ModelAndView(); System.out.println("\nModelAndView guestList()"); List<GuestDTO> list = dao.dbSelect(start, end); System.out.println("list2 : " + list.toString()); // model.addAttribute("countAll",countall); System.out.println("pageAll : " + pageAll); // System.out.println("bean : " + bean.toString()); return list; } // end