public User getUserDetails(String userId) { PreparedStatement ps = null; ResultSet rs = null; User user = null; RegisterService registerService = new RegisterService(); try { ps = connection.prepareStatement("SELECT * FROM user WHERE username=? LIMIT 1"); ps.setString(1, username); rs = ps.executeQuery(); if (rs != null && rs.next()) { user = new User(userId); user.setFirstName(rs.getString("firstname")); user.setLastName(rs.getString("lastname")); user.setEmail(rs.getString("email")); user.setPhoneNumber(rs.getString("primaryPhone")); user.setCellphone(rs.getString("secondaryPhone")); user.setAddress(registerService.createAddressFromID(rs.getInt("addressID"))); user.setCard(registerService.createCardFromID(rs.getInt("creditCardID"))); } } catch (SQLException e) { e.printStackTrace(); } return user; }
@Test public void testCreatingARegister() throws Exception { RegisterService service = Context.getService(RegisterService.class); Register register = new Register(); register.setName("register"); service.saveRegister(register); Assert.assertNotNull(register.getId()); }
@Test public void shouldReturnAListOfRegisters() { RegisterService service = Context.getService(RegisterService.class); List<Register> registers = service.getRegisters(true); assertEquals(registers.size(), 1); }
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { Map<String, String> errorMsgs = new LinkedHashMap<String, String>(); Map<String, String> cancelMessage = new LinkedHashMap<String, String>(); request.setAttribute("errorMsgs", errorMsgs); request.setAttribute("cancelMessage", cancelMessage); String tempregID = request.getParameter("regID"); int regID = RegisterVO.convertInt(tempregID); String classID = request.getParameter("classID"); String tempclassNum = request.getParameter("classNum"); int classNum = RegisterVO.convertInt(tempclassNum); RegisterService rs = new RegisterService(); RegisterVO registerVO = new RegisterVO(); registerVO = rs.findByPrimaryKey(regID); System.out.println(tempregID + "," + classID + "," + tempclassNum); System.out.println(registerVO.getRegStatus().toString()); if (Boolean.valueOf(registerVO.getPayStatus())) { errorMsgs.put("payStatus", "此飛行員已完成繳費不得取消"); System.out.println("此飛行員已完成繳費不得取消"); } if ("取消報名".equals(registerVO.getRegStatus().toString())) { errorMsgs.put("regStatus", "此飛行員已經取消過報名"); System.out.println("此飛行員紀錄已為取消報名 取消失敗"); } ClassListDAO classListDao = new ClassListDAO(); ClassListVO classListVO = classListDao.findByPrimayKey( registerVO.getClassListVO().getClassTypeVO().getClassID(), registerVO.getClassListVO().getClassNum()); if (classListVO.getRegNum() == 0) { errorMsgs.put("regNum", "報名人數請確認"); } String action = request.getParameter("action"); System.out.println(action); if (action.equals("reg")) { if (errorMsgs != null && !errorMsgs.isEmpty()) { RegisterDAO dao = new RegisterDAO(); List<RegisterVO> list = dao.getByPilotID(request.getSession().getAttribute("pilotID").toString()); request.setAttribute("registerList", list); request .getRequestDispatcher("/WEB-INF/register/register_info.jsp") .forward(request, response); return; } } else { if (errorMsgs != null && !errorMsgs.isEmpty()) { Set<RegisterVO> result = new LinkedHashSet<RegisterVO>(); result = rs.getRegisterByClass(classID, classNum); request.setAttribute("RegisterList", result); request .getRequestDispatcher("/WEB-INF/register/RegisterList.jsp") .forward(request, response); return; } } registerVO.setRegStatus("取消報名"); int currentRegNum = classListVO.getRegNum(); currentRegNum = currentRegNum - 1; classListVO.setRegNum(currentRegNum); System.out.println(currentRegNum); rs.cancelRegister(registerVO, classListVO); cancelMessage.put("cancelMessage", "成功將此飛行員取消報名"); if (action.equals("reg")) { RegisterDAO dao = new RegisterDAO(); List<RegisterVO> list = dao.getByPilotID(request.getSession().getAttribute("pilotID").toString()); request.setAttribute("registerList", list); request .getRequestDispatcher("/WEB-INF/register/register_info.jsp") .forward(request, response); } else { Set<RegisterVO> result = new LinkedHashSet<RegisterVO>(); result = rs.getRegisterByClass(classID, classNum); request.setAttribute("RegisterList", result); request.getRequestDispatcher("/WEB-INF/register/RegisterList.jsp").forward(request, response); } }