@Override public StudentManagerDTO saveStudent(String name, String classId, String schoolId) { UserDTO userDTO = new UserDTO(); userDTO.setRealName(name); userDTO.setIdentityId(IdentityIdConstants.STUDENT); userDTO.setIdentityDescription("学生"); userDTO.setSchoolId(schoolId); userDTO.setArea(mSchoolMapper.selectByPrimaryKey(schoolId).getArea()); UserDTO users = userService.saveUser(userDTO); MClass mclass = classMapper.selectByPrimaryKey(classId, schoolId); StudentDTO studentDTO = new StudentDTO(); studentDTO.setUserId(users.getUserId()); studentDTO.setSchoolId(mclass.getSchoolId()); studentDTO.setSchoolName(mclass.getSchoolName()); studentDTO.setClassName(mclass.getName()); studentDTO.setClassId(classId); studentDTO.setClassAliasName(mclass.getAliasName()); studentDTO.setJoinClass(new Date()); MStudent mStudent = new MStudent(); BeanUtils.copyProperties(studentDTO, mStudent); studentMapper.insert(mStudent); MStudentManager studentManager = studentMapper.selectStudentByUserId(mStudent.getUserId(), schoolId); StudentManagerDTO studentManagerDTO = new StudentManagerDTO(); BeanUtils.copyProperties(studentManager, studentManagerDTO); studentManagerDTO.setClassAliasName( ClassNameUtil.getFullName(studentManager.getYears(), studentManager.getClassAliasName())); return studentManagerDTO; }
public void testHuaTai_nologinUnderWriting() throws Exception { System.out.println("华泰-----------------------------免登录投保"); // 用户相关信息 UserDTO user = (new UserSet()).setXYZ_nologin(); String payPwd = user.getPayPwd(); int loginId = user.getLoginId(); // 产品相关信息 String[] products = (new AllProductSet()).setHuaTai(); PayResultDTO[] payResults = new PayResultDTO[products.length]; // CheckAfterPay check = new CheckAfterPay(); Ins_Front insF = new Ins_Front(); int start = 0; for (int i = start; i < products.length; i++) { System.out.println(i + 1); String proName = products[i]; // 前台购买保险产品 payResults[i] = insF.pay_YJX(selenium, proName, payPwd, 4, true, loginId); System.err.println(payResults[i].getFlag()); if (payResults[i].getFlag().equalsIgnoreCase("noProduct")) start++; else { selenium.close(); selenium.selectWindow(null); } } // 购买后查询投保单状态 // Thread.sleep(50000); // if (!check.checkAppStatus(payResults, start)) { // String report = "未全部承保,请检查!!!"; // selenium.click("link=" + report); // } }
@RequestMapping("add") public String register(UserDTO userDTO) { userService.createNewUser(userDTO.getUsername(), userDTO.getPassword(), userDTO.isEnable()); return "index"; }
public void setTempPassword(UserDTO user) { try (Connection conn = Conn.getConnection(); PreparedStatement pstmt = conn.prepareStatement("update user set password=? where user_id=?"); ) { pstmt.setString(1, Sha256.encrypt(user.getPassword())); pstmt.setInt(2, user.getUid()); pstmt.executeUpdate(); } catch (Exception e) { e.printStackTrace(); } }
public void userAdd(UserDTO user) { try (Connection conn = Conn.getConnection(); PreparedStatement pstmt = conn.prepareStatement("insert into user values(?,?,?,?)"); ) { pstmt.setInt(1, user.getUid()); pstmt.setString(2, Sha256.encrypt(user.getPassword())); pstmt.setString(3, user.getName()); pstmt.setString(4, user.getAuth()); pstmt.executeUpdate(); } catch (Exception e) { e.printStackTrace(); } }
public static String checkLogin(String userMobileNo, Context _context) throws Exception { String errorCode = ""; try { JSONObject reqParameters = new JSONObject(); reqParameters.put("UMOBILENO", userMobileNo); JsonHandler jsonHandler = JsonHandler.getInstance(); String url = jsonHandler.getFullUrl("UserLogin.php"); JSONObject result = jsonHandler.postJsonDataToServer(url, reqParameters, _context); if (result != null) { String resultCode = result.getString("RESULT"); if (resultCode.contentEquals(AppConstant.PHPRESPONSE_KO)) { errorCode = result.getString("ERRORCODE"); } else { JSONObject jsonData = result.getJSONObject("USERDATA"); UserDTO userDto = new UserDTO(); LaunchActivity.loginUserId = jsonData.getInt("USERID"); userDto.setUserId(LaunchActivity.loginUserId); userDto.setFirstName(jsonData.getString("UFNAME")); userDto.setLastName(jsonData.getString("ULNAME")); userDto.setCityId(jsonData.getInt("CITYID")); userDto.setGender(jsonData.getInt("GENDER")); userDto.setAge(jsonData.getInt("AGE")); userDto.setContactNo(jsonData.getString("UCONTACTNO")); userDto.setUserCity(jsonData.getString("USERCITY")); userDto.setAppLoginUser(true); LaunchActivity.repository.addUserDTO(userDto); } } else { errorCode = PHP_ERROR_CODE.TECHNICAL; } } catch (JSONException e) { // e.printStackTrace(); throw e; } catch (ClientProtocolException e) { // e.printStackTrace(); throw e; } catch (IOException e) { // e.printStackTrace(); throw e; } catch (Exception e) { // e.printStackTrace(); throw e; } return errorCode; }
// Container managed transaction public List<UserDTO> findAllUsers() { LOG.debug("findAllUsers()"); // TODO: Exception handling List<User> list = dao.findAll(); List<UserDTO> result = UserDTO.toUserDTOList(list); return result; }
boolean checkExpire() { long curTime = Calendar.getInstance().getTimeInMillis(); if ((curTime - UserDTO.getInstance().startTime) > 36000000) { return true; } else { return false; } }
@Override public StudentDTO queryStudentForAPP(String userId, String schoolId) { UserDTO mUsers = userService.getByUserId(userId); if (mUsers == null) { logger.debug("未找到学乐号为" + userId + "的学生用户"); return null; } MStudent mStudent = studentMapper.selectByPrimaryKey(userId, schoolId); if (mStudent == null) { logger.debug("未找到学生id为" + userId + "的学生"); throw new MemberException("未找到学生id为" + userId + "的学生"); } // 学生信息 StudentDTO studentDTO = new StudentDTO(); studentDTO.setUserId(userId); studentDTO.setRealName(mUsers.getRealName()); studentDTO.setSchoolId(mStudent.getSchoolId()); studentDTO.setSchoolName(mStudent.getSchoolName()); studentDTO.setClassId(mStudent.getClassId()); studentDTO.setClassName(mStudent.getClassName()); studentDTO.setMobile(mUsers.getMobile()); studentDTO.setEmail(mUsers.getEmail()); // 学校所在区域信息 MSchool mSchool = mSchoolMapper.selectByPrimaryKey(mUsers.getSchoolId()); if (mSchool == null) { logger.debug("未找到学乐号为" + userId + "的学生用户所在的学校"); return null; } studentDTO.setAreaCode(mSchool.getArea()); studentDTO.setAreaName(mSchool.getAreaName()); // 班级信息 MClass mClass = classMapper.selectByPrimaryKey(mStudent.getClassId(), schoolId); if (mClass == null) { logger.debug("未找到学乐号为" + userId + "的学生用户所在的班级"); return null; } studentDTO.setGradeNum(getGradeNum(mClass.getYears())); studentDTO.setYear(mClass.getYears()); return studentDTO; }
public boolean passwordCheck(UserDTO user) { boolean check = false; try (Connection conn = Conn.getConnection(); PreparedStatement pstmt = conn.prepareStatement("select user_id from user where user_id=? and password=? "); ) { pstmt.setInt(1, user.getUid()); pstmt.setString(2, Sha256.encrypt(user.getPassword())); ResultSet rs = pstmt.executeQuery(); if (rs.next()) { check = true; } else { check = false; } } catch (Exception e) { e.printStackTrace(); } return check; }
public boolean userDelete(UserDTO user) { try (Connection conn = Conn.getConnection(); PreparedStatement pstmt = conn.prepareStatement("delete from user where user_id=?"); ) { pstmt.setInt(1, user.getUid()); pstmt.executeUpdate(); } catch (Exception e) { return false; } return true; }
public UserDTO login(UserDTO user) { UserDTO dto = null; try (Connection conn = Conn.getConnection(); PreparedStatement pstmt = conn.prepareStatement( "select user_id,name,auth from user where user_id=? and password=?"); ) { pstmt.setInt(1, user.getUid()); pstmt.setString(2, Sha256.encrypt(user.getPassword())); // pstmt.setString(2, user.getPassword()); try (ResultSet rs = pstmt.executeQuery(); ) { if (rs.next()) { dto = new UserDTO(); dto.setUid(rs.getInt("user_id")); dto.setName(rs.getString("name")); dto.setAuth(rs.getString("auth")); } } catch (Exception e) { e.printStackTrace(); } } catch (Exception e) { e.printStackTrace(); } return dto; }
public boolean overlapCheck(UserDTO user) { boolean check = false; try (Connection conn = Conn.getConnection(); PreparedStatement pstmt = conn.prepareStatement("select user_id from user where user_id=?"); ) { pstmt.setInt(1, user.getUid()); try (ResultSet rs = pstmt.executeQuery(); ) { if (rs.next()) { check = true; } } catch (Exception e) { e.printStackTrace(); return check; } } catch (Exception e) { e.printStackTrace(); return check; } return check; }
public void testThirdPayYJX() throws Exception { // 用户相关信息 UserDTO user = (new UserSet()).setNormalUser(); String username = user.getUsername(); String password = user.getPassword(); String payPwd = user.getPayPwd(); int loginId = user.getLoginId(); BigDecimal acc = user.getAcc(); // 账户最低余额:0-普通账户,-5000-vip账户 BigDecimal before_pay = null; // 支付前账户余额 BigDecimal after_pay = null; // 支付后账户余额 // 产品相关信息 ProductDTO[] products = new ProductDTO[2]; products[0] = (new ProductSet()).setYJX(); products[1] = (new ProductSet()).setYJX_Coupon(); // 登录 Ins_Front insF = new Ins_Front(); insF.loginFront(selenium, username, password); for (int i = 0; i < products.length; i++) { System.out.println(i + 1); String proName = products[i].getProName(); String proType = products[i].getProductType(); int coupon = products[i].getPCoupon(); // 支付时是否可以使用优惠券:0-不可以,1-可以 // 前台购买保险产品,购买前查询账户余额 before_pay = (new CommSql()).getAccBall(loginId, acc); PayResultDTO payResult = insF.pay_YJX(selenium, proName, payPwd, 4, true, loginId); Thread.sleep(30000); after_pay = (new CommSql()).getAccBall(loginId, acc); System.out.println("购买前账户余额:" + before_pay); System.out.println("购买后账户余额:" + after_pay); // 支付完成后判断订单、投保单状态及账户余额的正确性 CheckAfterPay check = new CheckAfterPay(); check.checkAfterThirdPay(selenium, before_pay, after_pay, payResult, coupon, proType); } }
public UserDTO build() { UserDTO userDTO = new UserDTO(); userDTO.setId(id); userDTO.setLogin(login); userDTO.setPassword(password); userDTO.setUserRole(userRole); userDTO.setFirstName(firstName); userDTO.setLastName(lastName); userDTO.setEmail(email); userDTO.setLastModified(lastModified); userDTO.setState(state); userDTO.setGroups(groups); return userDTO; }
public static ProjectDTO getProjectByName(String name) { Project p; p = ProxyManager.getProjectProxy().findProjectByName(name); if (p != null) { ProjectDTO projectDTO = new ProjectDTO(); projectDTO.setProjectId(p.getProjectId()); projectDTO.setName(p.getName()); projectDTO.setDescription(p.getDescription()); projectDTO.setStatus(p.getStatus()); Team team = p.getTeamTeamId(); if (team != null) { TeamDTO teamDTO = new TeamDTO(); teamDTO.setTeamId(team.getTeamId()); teamDTO.setProductOwnerId(team.getProductOwnerId()); teamDTO.setScrumMasterId(team.getScrumMasterId()); ArrayList<UserDTO> userDTOList = new ArrayList<UserDTO>(); for (User user : team.getUserList()) { UserDTO userDTO = new UserDTO(); userDTO.setUserId(user.getUserId()); userDTO.setUsername(user.getUsername()); userDTO.setPassword(user.getPassword()); userDTO.setFirstName(user.getFirstName()); userDTO.setLastName(user.getLastName()); userDTO.setEmail(user.getEmail()); userDTO.setAdmin(user.getIsAdmin()); userDTO.setSalt(user.getSalt()); userDTO.setActive(user.getIsActive()); userDTO.setTimeCreated(user.getTimeCreated()); userDTOList.add(userDTO); } teamDTO.setUserList(userDTOList); projectDTO.setTeamTeamId(teamDTO); } else projectDTO.setTeamTeamId(null); List<SprintDTO> sprintDTOList = new ArrayList<SprintDTO>(); if (p.getSprintList() != null) { for (Sprint s : p.getSprintList()) { s = ProxyManager.getSprintProxy().findSprint(s.getSprintPK()); SprintDTO sprintDTO = new SprintDTO(); SprintPKDTO sprintPKDTO = new SprintPKDTO(); sprintPKDTO.setSprintId(s.getSprintPK().getSprintId()); sprintPKDTO.setProjectProjectId(s.getSprintPK().getProjectProjectId()); sprintDTO.setSprintPK(sprintPKDTO); sprintDTO.setSeqNumber(s.getSeqNumber()); sprintDTO.setStatus(s.getStatus()); sprintDTO.setStartDate(s.getStartDate()); sprintDTO.setEndDate(s.getEndDate()); sprintDTO.setVelocity(s.getVelocity()); if (s.getUserStoryList() != null) { List<UserStoryDTO> userStoryDTOList = new ArrayList<UserStoryDTO>(); for (UserStory userStory : s.getUserStoryList()) { userStory = ProxyManager.getUserStoryProxy().findUserStory(userStory.getStoryId()); UserStoryDTO userStoryDTO = new UserStoryDTO(); userStoryDTO.setStoryId(userStory.getStoryId()); userStoryDTO.setName(userStory.getName()); userStoryDTO.setContent(userStory.getContent()); userStoryDTO.setBusinessValue(userStory.getBusinessValue()); userStoryDTO.setStatus(userStory.getStatus()); if (userStory.getEstimateTime() != null) { userStoryDTO.setEstimateTime(userStory.getEstimateTime().doubleValue()); } else userStoryDTO.setEstimateTime(null); userStoryDTO.setStoryId(userStory.getStoryId()); userStoryDTO.setProjectProjectId(projectDTO); userStoryDTO.setComment(userStory.getComment()); userStoryDTO.setSprint(sprintDTO); PriorityDTO priorityDTO = new PriorityDTO(); priorityDTO.setPriorityId(userStory.getPriorityPriorityId().getPriorityId()); priorityDTO.setName(userStory.getPriorityPriorityId().getName()); userStoryDTO.setPriorityPriorityId(priorityDTO); List<AcceptanceTestDTO> acceptanceTestDTOList = new ArrayList<AcceptanceTestDTO>(); for (AcceptanceTest at : userStory.getAcceptanceTestList()) { AcceptanceTestDTO acceptanceTestDTO = new AcceptanceTestDTO(); acceptanceTestDTO.setAcceptanceTestId(at.getAcceptanceTestId()); acceptanceTestDTO.setContent(at.getContent()); acceptanceTestDTOList.add(acceptanceTestDTO); } userStoryDTO.setAcceptanceTestList(acceptanceTestDTOList); if (userStory.getTaskList() != null) { List<TaskDTO> taskDTOList = new ArrayList<TaskDTO>(); for (Task task : userStory.getTaskList()) { task = ProxyManager.getTaskProxy().findTask(task.getTaskPK()); TaskDTO taskDTO = new TaskDTO(); taskDTO.setDescription(task.getDescription()); taskDTO.setTimeRemaining(task.getTimeRemaining()); taskDTO.setEstimatedTime(task.getEstimatedTime()); taskDTO.setStatus(task.getStatus()); taskDTO.setPreassignedUserName(task.getPreassignedUserName()); taskDTO.setAssignedDate(task.getAssignedDate()); taskDTO.setUserStory(userStoryDTO); TaskPKDTO taskPKDTO = new TaskPKDTO(); taskPKDTO.setTaskId(task.getTaskPK().getTaskId()); taskPKDTO.setUserStoryStoryId(task.getTaskPK().getUserStoryStoryId()); taskDTO.setTaskPK(taskPKDTO); if (task.getUserUserId() != null) { User user = ProxyManager.getUserProxy().findUser(task.getUserUserId().getUserId()); UserDTO userDTO = new UserDTO(); userDTO.setUserId(user.getUserId()); userDTO.setUsername(user.getUsername()); userDTO.setPassword(user.getPassword()); userDTO.setFirstName(user.getFirstName()); userDTO.setLastName(user.getLastName()); userDTO.setEmail(user.getEmail()); userDTO.setAdmin(user.getIsAdmin()); userDTO.setSalt(user.getSalt()); userDTO.setActive(user.getIsActive()); userDTO.setTimeCreated(user.getTimeCreated()); taskDTO.setUserUserId(userDTO); } List<WorkloadDTO> workloadDTOList = new ArrayList<WorkloadDTO>(); for (Workload workload : task.getWorkloadList()) { workload = ProxyManager.getWorkloadProxy().findWorkload(workload.getWorkloadPK()); WorkloadDTO workloadDTO = new WorkloadDTO(); workloadDTO.setDay(workload.getDay()); workloadDTO.setTimeRemaining(workload.getTimeRemaining()); workloadDTO.setTimeSpent(workload.getTimeSpent()); workloadDTO.setStarted(workload.getStarted()); workloadDTO.setStartTime(workload.getStartTime()); workloadDTO.setStopTime(workload.getStopTime()); User user = ProxyManager.getUserProxy().findUser(workload.getUser().getUserId()); UserDTO userDTO = new UserDTO(); userDTO.setUserId(user.getUserId()); userDTO.setUsername(user.getUsername()); userDTO.setPassword(user.getPassword()); userDTO.setFirstName(user.getFirstName()); userDTO.setLastName(user.getLastName()); userDTO.setEmail(user.getEmail()); userDTO.setAdmin(user.getIsAdmin()); userDTO.setSalt(user.getSalt()); userDTO.setActive(user.getIsActive()); userDTO.setTimeCreated(user.getTimeCreated()); workloadDTO.setUser(userDTO); workloadDTO.setTask(taskDTO); WorkloadPKDTO workloadPKDTO = new WorkloadPKDTO(); WorkloadPK workloadPK = workload.getWorkloadPK(); workloadPKDTO.setTaskTaskId(workloadPK.getTaskTaskId()); workloadPKDTO.setTaskUserStoryStoryId(workloadPK.getTaskUserStoryStoryId()); workloadPKDTO.setUserUserId(workloadPK.getUserUserId()); workloadPKDTO.setWorkloadId(workloadPK.getWorkloadId()); workloadDTO.setWorkloadPK(workloadPKDTO); List<WorkblockDTO> workblockDTOList = new ArrayList<WorkblockDTO>(); for (Workblock workblock : workload.getWorkblockList()) { workblock = ProxyManager.getWorkblockProxy() .findWorkblock(workblock.getWorkblockPK()); WorkblockDTO workblockDTO = new WorkblockDTO(); workblockDTO.setTimeStart(workblock.getTimeStart()); workblockDTO.setTimeStop(workblock.getTimeStop()); workblockDTO.setWorkload(workloadDTO); WorkblockPKDTO workblockPKDTO = new WorkblockPKDTO(); WorkblockPK workblockPK = workblock.getWorkblockPK(); workloadPKDTO.setWorkloadId(workblockPK.getWorkloadWorkloadId()); workblockPKDTO.setWorkloadTaskTaskId(workloadPK.getTaskTaskId()); workblockPKDTO.setWorkloadTaskUserStoryStoryId( workblockPK.getWorkloadTaskUserStoryStoryId()); workblockPKDTO.setWorkloadUserUserId(workblockPK.getWorkloadUserUserId()); workblockPKDTO.setWorkloadWorkloadId(workblockPK.getWorkloadWorkloadId()); workblockDTO.setWorkblockPK(workblockPKDTO); workblockDTOList.add(workblockDTO); } workloadDTO.setWorkblockList(workblockDTOList); workloadDTOList.add(workloadDTO); } taskDTO.setWorkloadList(workloadDTOList); taskDTOList.add(taskDTO); } userStoryDTO.setTaskList(taskDTOList); } userStoryDTOList.add(userStoryDTO); } sprintDTO.setUserStoryList(userStoryDTOList); } sprintDTOList.add(sprintDTO); } projectDTO.setSprintList(sprintDTOList); } else projectDTO.setSprintList(null); List<UserStoryDTO> userStoryDTOList = new ArrayList<UserStoryDTO>(); if (p.getUserStoryList() != null) { for (UserStory us : p.getUserStoryList()) { UserStoryDTO userStoryDTO = new UserStoryDTO(); userStoryDTO.setStoryId(us.getStoryId()); userStoryDTO.setName(us.getName()); userStoryDTO.setContent(us.getContent()); userStoryDTO.setBusinessValue(us.getBusinessValue()); userStoryDTO.setStatus(us.getStatus()); if (us.getEstimateTime() != null) { userStoryDTO.setEstimateTime(us.getEstimateTime().doubleValue()); } else userStoryDTO.setEstimateTime(null); userStoryDTO.setStoryId(us.getStoryId()); userStoryDTO.setProjectProjectId(projectDTO); PriorityDTO priorityDTO = new PriorityDTO(); priorityDTO.setPriorityId(us.getPriorityPriorityId().getPriorityId()); priorityDTO.setName(us.getPriorityPriorityId().getName()); userStoryDTO.setPriorityPriorityId(priorityDTO); List<AcceptanceTestDTO> acceptanceTestDTOList = new ArrayList<AcceptanceTestDTO>(); for (AcceptanceTest at : us.getAcceptanceTestList()) { AcceptanceTestDTO acceptanceTestDTO = new AcceptanceTestDTO(); acceptanceTestDTO.setAcceptanceTestId(at.getAcceptanceTestId()); acceptanceTestDTO.setContent(at.getContent()); acceptanceTestDTOList.add(acceptanceTestDTO); } userStoryDTO.setAcceptanceTestList(acceptanceTestDTOList); // TODO: Set taskList to userStoryDTO if (us.getTaskList() != null) { List<TaskDTO> taskDTOList = new ArrayList<TaskDTO>(); for (Task task : us.getTaskList()) { task = ProxyManager.getTaskProxy().findTask(task.getTaskPK()); TaskDTO taskDTO = new TaskDTO(); taskDTO.setDescription(task.getDescription()); taskDTO.setTimeRemaining(task.getTimeRemaining()); taskDTO.setEstimatedTime(task.getEstimatedTime()); taskDTO.setStatus(task.getStatus()); taskDTO.setPreassignedUserName(task.getPreassignedUserName()); taskDTO.setAssignedDate(task.getAssignedDate()); taskDTO.setUserStory(userStoryDTO); TaskPKDTO taskPKDTO = new TaskPKDTO(); taskPKDTO.setTaskId(task.getTaskPK().getTaskId()); taskPKDTO.setUserStoryStoryId(task.getTaskPK().getUserStoryStoryId()); taskDTO.setTaskPK(taskPKDTO); if (task.getUserUserId() != null) { User user = ProxyManager.getUserProxy().findUser(task.getUserUserId().getUserId()); UserDTO userDTO = new UserDTO(); userDTO.setUserId(user.getUserId()); userDTO.setUsername(user.getUsername()); userDTO.setPassword(user.getPassword()); userDTO.setFirstName(user.getFirstName()); userDTO.setLastName(user.getLastName()); userDTO.setEmail(user.getEmail()); userDTO.setAdmin(user.getIsAdmin()); userDTO.setSalt(user.getSalt()); userDTO.setActive(user.getIsActive()); userDTO.setTimeCreated(user.getTimeCreated()); taskDTO.setUserUserId(userDTO); } List<WorkloadDTO> workloadDTOList = new ArrayList<WorkloadDTO>(); for (Workload workload : task.getWorkloadList()) { workload = ProxyManager.getWorkloadProxy().findWorkload(workload.getWorkloadPK()); WorkloadDTO workloadDTO = new WorkloadDTO(); workloadDTO.setDay(workload.getDay()); workloadDTO.setTimeRemaining(workload.getTimeRemaining()); workloadDTO.setTimeSpent(workload.getTimeSpent()); User user = ProxyManager.getUserProxy().findUser(workload.getUser().getUserId()); UserDTO userDTO = new UserDTO(); userDTO.setUserId(user.getUserId()); userDTO.setUsername(user.getUsername()); userDTO.setPassword(user.getPassword()); userDTO.setFirstName(user.getFirstName()); userDTO.setLastName(user.getLastName()); userDTO.setEmail(user.getEmail()); userDTO.setAdmin(user.getIsAdmin()); userDTO.setSalt(user.getSalt()); userDTO.setActive(user.getIsActive()); userDTO.setTimeCreated(user.getTimeCreated()); workloadDTO.setUser(userDTO); workloadDTO.setTask(taskDTO); WorkloadPKDTO workloadPKDTO = new WorkloadPKDTO(); WorkloadPK workloadPK = workload.getWorkloadPK(); workloadPKDTO.setTaskTaskId(workloadPK.getTaskTaskId()); workloadPKDTO.setTaskUserStoryStoryId(workloadPK.getTaskUserStoryStoryId()); workloadPKDTO.setUserUserId(workloadPK.getUserUserId()); workloadPKDTO.setWorkloadId(workloadPK.getWorkloadId()); workloadDTO.setWorkloadPK(workloadPKDTO); List<WorkblockDTO> workblockDTOList = new ArrayList<WorkblockDTO>(); for (Workblock workblock : workload.getWorkblockList()) { workblock = ProxyManager.getWorkblockProxy().findWorkblock(workblock.getWorkblockPK()); WorkblockDTO workblockDTO = new WorkblockDTO(); workblockDTO.setTimeStart(workblock.getTimeStart()); workblockDTO.setTimeStop(workblock.getTimeStop()); workblockDTO.setWorkload(workloadDTO); WorkblockPKDTO workblockPKDTO = new WorkblockPKDTO(); WorkblockPK workblockPK = workblock.getWorkblockPK(); workloadPKDTO.setWorkloadId(workblockPK.getWorkloadWorkloadId()); workblockPKDTO.setWorkloadTaskTaskId(workloadPK.getTaskTaskId()); workblockPKDTO.setWorkloadTaskUserStoryStoryId( workblockPK.getWorkloadTaskUserStoryStoryId()); workblockPKDTO.setWorkloadUserUserId(workblockPK.getWorkloadUserUserId()); workblockPKDTO.setWorkloadWorkloadId(workblockPK.getWorkloadWorkloadId()); workblockDTO.setWorkblockPK(workblockPKDTO); workblockDTOList.add(workblockDTO); } workloadDTO.setWorkblockList(workblockDTOList); workloadDTOList.add(workloadDTO); } taskDTO.setWorkloadList(workloadDTOList); taskDTOList.add(taskDTO); } userStoryDTO.setTaskList(taskDTOList); } else userStoryDTO.setTaskList(null); SprintDTO sprintDTO = new SprintDTO(); if (us.getSprint() != null) { SprintPKDTO sprintPKDTO = new SprintPKDTO(); sprintPKDTO.setSprintId(us.getSprint().getSprintPK().getSprintId()); sprintPKDTO.setProjectProjectId(us.getSprint().getSprintPK().getProjectProjectId()); sprintDTO.setSprintPK(sprintPKDTO); sprintDTO.setSeqNumber(us.getSprint().getSeqNumber()); sprintDTO.setStatus(us.getSprint().getStatus()); sprintDTO.setStartDate(us.getSprint().getStartDate()); sprintDTO.setEndDate(us.getSprint().getEndDate()); sprintDTO.setVelocity(us.getSprint().getVelocity()); } else sprintDTO = null; userStoryDTO.setSprint(sprintDTO); userStoryDTOList.add(userStoryDTO); } projectDTO.setUserStoryList(userStoryDTOList); } return projectDTO; } else return null; }
public static Pair<Boolean, String> updateProject( ProjectDTO projectDTO, boolean changedProjectName, String originalProjectName) { try { // Additional duplication control Project existingProject; if (changedProjectName) { existingProject = ProxyManager.getProjectProxy().findProjectByName(projectDTO.getName()); } else existingProject = null; if (existingProject != null && changedProjectName) { System.out.println("Existing project exists!"); return Pair.of(false, "Project with this name already exists!"); } Project p = ProxyManager.getProjectProxy().findProjectByName(originalProjectName); p.setProjectId(projectDTO.getProjectId()); p.setName(projectDTO.getName()); p.setDescription(projectDTO.getDescription()); p.setStatus(projectDTO.getStatus()); Team team = new Team(); team.setTeamId(projectDTO.getTeamTeamId().getTeamId()); team.setScrumMasterId(projectDTO.getTeamTeamId().getScrumMasterId()); team.setProductOwnerId(projectDTO.getTeamTeamId().getProductOwnerId()); List<User> userList = new ArrayList<User>(); if (projectDTO.getTeamTeamId().getUserList() != null) { for (UserDTO userDTO : projectDTO.getTeamTeamId().getUserList()) { User user = new User(); user.setUserId(userDTO.getUserId()); user.setUsername(userDTO.getUsername()); user.setPassword(userDTO.getPassword()); user.setFirstName(userDTO.getFirstName()); user.setLastName(userDTO.getLastName()); user.setEmail(userDTO.getEmail()); user.setIsAdmin(userDTO.isAdmin()); user.setSalt(userDTO.getSalt()); user.setIsActive(userDTO.isActive()); user.setTimeCreated(userDTO.getTimeCreated()); userList.add(user); } team.setUserList(userList); } else return Pair.of(false, "No project list when saving team."); p.setTeamTeamId(team); try { if (p == null) return Pair.of(false, "Data error!"); ProxyManager.getProjectProxy().edit(p); } catch (Exception e) { System.err.println("Error: " + e.getMessage()); return Pair.of(false, e.getMessage()); } } catch (Exception e) { e.printStackTrace(); return Pair.of(false, e.getMessage()); } return Pair.of(true, "Project updated successfully."); }
@Override public void reset() { super.reset(); }
public static Pair<Boolean, String> saveNewProject(ProjectDTO projectDTO) { // check for project in database System.out.println("Project to check in base: " + projectDTO.getName()); Project existingProject = ProxyManager.getProjectProxy().findProjectByName(projectDTO.getName()); try { if (existingProject != null) { System.out.println("Existing project exists!"); return Pair.of(false, "Project with this name already exists!"); } else System.out.println("Project check passed, no existing project."); Project p = new Project(); p.setName(projectDTO.getName()); p.setDescription(projectDTO.getDescription()); p.setStatus(projectDTO.getStatus()); Team team = new Team(); team.setTeamId(projectDTO.getTeamTeamId().getTeamId()); team.setScrumMasterId(projectDTO.getTeamTeamId().getScrumMasterId()); team.setProductOwnerId(projectDTO.getTeamTeamId().getProductOwnerId()); List<User> userList = new ArrayList<User>(); if (projectDTO.getTeamTeamId().getUserList() != null) { for (UserDTO userDTO : projectDTO.getTeamTeamId().getUserList()) { User user = new User(); user.setUserId(userDTO.getUserId()); user.setUsername(userDTO.getUsername()); user.setPassword(userDTO.getPassword()); user.setFirstName(userDTO.getFirstName()); user.setLastName(userDTO.getLastName()); user.setEmail(userDTO.getEmail()); user.setIsAdmin(userDTO.isAdmin()); user.setSalt(userDTO.getSalt()); user.setIsActive(userDTO.isActive()); user.setTimeCreated(userDTO.getTimeCreated()); userList.add(user); } team.setUserList(userList); } else return Pair.of(false, "No user list when saving team."); p.setTeamTeamId(team); try { if (p == null) return Pair.of(false, "Data error!"); ProxyManager.getProjectProxy().create(p); } catch (Exception e) { System.err.println("Error: " + e.getMessage()); return Pair.of(false, e.getMessage()); } } catch (Exception e) { e.printStackTrace(); return Pair.of(false, e.getMessage()); } return Pair.of(true, "Project saved successfully."); }
@Override public StudentDTO updateStudentForAPP(StudentDTO studentDTO) { // 更新联系方式 UserDTO userDTO = new UserDTO(); boolean isAllNot = true; // 学生姓名 String name = studentDTO.getRealName(); if (!StringUtils.isEmpty(name)) { userDTO.setRealName(name); isAllNot = false; } String school = studentDTO.getSchoolId(); if (school != null) { userDTO.setSchoolId(school); isAllNot = false; } else { logger.warn("schoolId不能为空"); return null; } String userId = studentDTO.getUserId(); if (!StringUtils.isEmpty(userId)) { userDTO.setUserId(userId); } else { logger.warn("userId不能为空"); return null; } String mobile = studentDTO.getMobile(); if (!StringUtils.isEmpty(mobile)) { userDTO.setMobile(mobile); isAllNot = false; } String email = studentDTO.getEmail(); if (!StringUtils.isEmpty(email)) { userDTO.setEmail(email); isAllNot = false; } if (!isAllNot) { userService.updateByUserId(userDTO); } // 更新班级 String schoolId = userService.getSchoolId(userId); if (StringUtils.isEmpty(schoolId)) { throw new MemberException("该学生没有学校"); } MSchool mSchool = mSchoolMapper.selectByPrimaryKey(schoolId); String classId = studentDTO.getClassId(); if (!StringUtils.isEmpty(classId)) { MClass mClass = classMapper.selectByPrimaryKey(classId, schoolId); if (mClass == null) { logger.warn("找不到班级号为" + classId + "的班级"); return null; } MStudent mStudent = new MStudent(); mStudent.setUserId(studentDTO.getUserId()); mStudent.setClassName(mClass.getName()); mStudent.setClassId(classId); mStudent.setSchoolId(schoolId); studentMapper.updateByPrimaryKey(mStudent); } studentDTO.setClassId(classId); studentDTO.setSchoolId(schoolId); studentDTO.setSchoolName(mSchool.getName()); return studentDTO; }
@Test public void testUserCreate() throws Exception { System.out.println("testUserCreate: START"); // ================================================================================= int id = 0; String username = "******"; String password = "******"; boolean active = true; boolean admin = true; String dob = "11/03/1966"; String email = "*****@*****.**"; String securityQuestion1 = "XXX"; String securityAnswer1 = "XXX"; String securityQuestion2 = "YYY"; String securityAnswer2 = "YYY"; Date birthDate = sdf.parse(dob); // ================================================================================= System.out.println("testUserCreate: START: CREATE"); UserDTO user = new UserDTO(); assertNotNull(user); // *************************************************************** user.setId(id); user.setUsername(username); user.setPassword(password); user.setActive(active); user.setEmail(email); user.setSecurityQuestion1(securityQuestion1); user.setSecurityAnswer1(securityAnswer1); user.setSecurityQuestion2(securityQuestion2); user.setSecurityAnswer2(securityAnswer2); System.out.println("testUserCreate: user="******"testUserCreate: FINISH: CREATE"); }
public static List<ProjectDTO> getAllProject() { // Get project list List<Project> projectList; // retrieve project list from JPA controller projectList = ProxyManager.getProjectProxy().getProjectsList(); ArrayList<ProjectDTO> resList = new ArrayList<ProjectDTO>(); ProjectDTO projectDTO; for (Project p : projectList) { projectDTO = new ProjectDTO(); projectDTO.setName(p.getName()); projectDTO.setDescription(p.getDescription()); projectDTO.setStatus(p.getStatus()); Team team = p.getTeamTeamId(); if (team != null) { TeamDTO teamDTO = new TeamDTO(); teamDTO.setTeamId(team.getTeamId()); teamDTO.setProductOwnerId(team.getProductOwnerId()); teamDTO.setScrumMasterId(team.getScrumMasterId()); ArrayList<UserDTO> userDTOList = new ArrayList<UserDTO>(); for (User user : team.getUserList()) { UserDTO userDTO = new UserDTO(); userDTO.setUserId(user.getUserId()); userDTO.setUsername(user.getUsername()); userDTO.setPassword(user.getPassword()); userDTO.setFirstName(user.getFirstName()); userDTO.setLastName(user.getLastName()); userDTO.setEmail(user.getEmail()); userDTO.setAdmin(user.getIsAdmin()); userDTO.setSalt(user.getSalt()); userDTO.setActive(user.getIsActive()); userDTO.setTimeCreated(user.getTimeCreated()); userDTOList.add(userDTO); } teamDTO.setUserList(userDTOList); projectDTO.setTeamTeamId(teamDTO); } else projectDTO.setTeamTeamId(null); // TODO: possible break resList.add(projectDTO); } return resList; }