// 테이블디비에 storeCode 로 최근 tableNo select (박은영) @RequestMapping(value = "/newTable.action", method = RequestMethod.GET) public void newTable(HttpServletResponse response, String storeCode1) throws IOException { Integer recentableNo = tableService.selectRecentTableNo(storeCode1); // 처음에 0이 들어옴 // System.out.println("saleController: recentTableno:" + recentableNo); StoreTable st = new StoreTable(); st.setStoreCode(storeCode1); st.setTableNo(recentableNo + 1); tableService.insertTable(st); response.setContentType("text/plain;charset=utf-8"); PrintWriter out = response.getWriter(); out.print(recentableNo); }
// 윤수오빠화면으로 테스트해봄 --박은영 @RequestMapping(value = "/salehome_test.action", method = RequestMethod.GET) public String SaleHome( Model model, String storeCode1, HttpSession session, HttpServletRequest req) { System.out.println("salehome.test storecode " + storeCode1); List<StoreTable> st = tableService.selectCurrentTables(storeCode1); model.addAttribute("st", st); List<Menu> menus = saleService.getAllMenus(); model.addAttribute("menus", menus); // Integer recentableNo=tableService.selectRecentTableNo(storeCode1); // model.addAttribute("recentno", recentableNo); return "sale/salehome_test2_eunyoung"; }