欢迎您访问365答案网,请分享给你的朋友!
生活常识 学习资料

项目冲刺二总结

时间:2023-07-04
文章目录

前言一、开启关卡学习

1.1 开启关卡1.2设置完成时间/关闭时间 二、查询学科、阶段、关卡

2.1 根据阶段名称查询所有的关卡学习信息(管理员操作)2.2 根据用户名称和阶段名称查询所有的关卡学习信息(用户操作)2.3 根据学科名称查询关卡学习信息(管理员操作)2.4 根据用户名称和学科名称查询关卡学习信息(用户操作) 总结 前言

第一次做一个关于团队的合作项目——禅道,肯定做的不是那么顺利,但是根据流程走还是可以做下来的,后面的冲刺有这次的经验就会相对简单一些。在最开始分配任务的时候,一定要和相关人员讨论好需求,不然会浪费大量时间。在本次冲刺阶段我主要任务是开启关卡学习和查询学科、阶段、关卡功能。

一、开启关卡学习 1.1 开启关卡

功能:通过对未开始的关卡进行学习。在开启的时候要注意修改状态为进行中。部分代码如下:

@RequestMapping(value = "/startCustomspassStudy") @ResponseBody public ResultInfo startStageStudy( @RequestParam(value = "id") int id, @RequestParam(value = "start") String start, @RequestParam(value = "end") String end) throws ParseException { ResultInfo info=customspassService.startCustomspassStudy(id,start,end); return info; }

@Override public ResultInfo startCustomspassStudy(int id, String _start, String _end) throws ParseException { ResultInfo info=new ResultInfo(); info.setFlag(true); //将日期转为java日期 SimpleDateFormat sdf=new SimpleDateFormat("yyyy-MM-dd"); Date start1 = sdf.parse(_start); Date end1 = sdf.parse(_end); java.sql.Date start = new java.sql.Date(start1.getTime()); java.sql.Date end = new java.sql.Date(end1.getTime());// System.out.println(email); try { //添加关卡学习记录 customspassMapper.startCustomspassStudy(id, start, end); //根据关卡学习id修改status=3(进行中) customspassMapper.updateStusyCustomspassStatusById(id); }catch (Exception e){ info.setFlag(false); info.setErrorMsg("开启关卡失败"); e.printStackTrace(); } return info; }

1.2设置完成时间/关闭时间

功能:通过关卡编号来设置完成时间/关闭时间。都要修改相应的状态(已完成、已关闭)部分代码如下:

@RequestMapping("/updateFinishTimeById") @ResponseBody public ResultInfo updateFinishTimeById( @RequestParam(value = "id") int id, @RequestParam(value = "actualFinishTime") String actualFinishTime ) throws ParseException { ResultInfo info=customspassService.updateFinishTimeById(id,actualFinishTime); return info; }

@Override public ResultInfo updateFinishTimeById(int id, String _actualFinishTime) throws ParseException { ResultInfo info=new ResultInfo(); info.setFlag(true); //Java日期转为sql日期 SimpleDateFormat sdf=new SimpleDateFormat("yyyy-MM-dd"); Date actualFinishTime1 = sdf.parse(_actualFinishTime); java.sql.Date actualFinishTime = new java.sql.Date(actualFinishTime1.getTime()); try { //设置实际完成时间 customspassMapper.updateFinishTimeById(id,actualFinishTime); //修改status=0 customspassMapper.updateFinishStatusById(id); //根据id查询StudyCustomspass StudyCustomspass studyCustomspass = customspassMapper.selectStudyCustomspassById(id); //计算实际完成的天数 Long actualFinishDay = between_days(studyCustomspass.getStart(), studyCustomspass.getActualFinishTime()); //判断该关卡是否逾期,是:修改status=2 Long aLong = between_days(studyCustomspass.getActualFinishTime(), studyCustomspass.getEnd()); if (aLong<0){ //根据关卡学习id修改status=2 customspassMapper.updateStatusById(id); //计算开始时间、结束时间相差的天数 Long betweenDays = between_days(studyCustomspass.getStart(), studyCustomspass.getEnd()); customspassMapper.updateActualFinishDayById(id,betweenDays); }else { //根据关卡学习id设置实际完成天数 customspassMapper.updateActualFinishDayById(id,actualFinishDay); } }catch (Exception e){ info.setFlag(false); info.setErrorMsg("设置失败"); } return info; }

二、查询学科、阶段、关卡

功能:根据阶段名称、用户名称、学科名称查询关卡学习信息。

2.1 根据阶段名称查询所有的关卡学习信息(管理员操作)

部分代码如下:

@Override public ResultInfo selectStudyCustomspassByStageName(String stageName) { ResultInfo info=new ResultInfo(); info.setFlag(true); try { List studyCustomspassList=customspassMapper.selectStudyCustomspassByStageName(stageName); info.setData(studyCustomspassList); }catch (Exception e){ info.setFlag(false); info.setErrorMsg("查询失败"); e.printStackTrace(); } return info; }

@Select("SELECT * FROM study_customspass WHERe customspassId IN(n" + "tSELECt customspassId FROM stage_customspass WHERe stageId IN(n" + "ttSELECt stageId FROM stage WHERe `name`=#{stageName} n" + "t)n" + ")") List selectStudyCustomspassByStageName(String stageName);

2.2 根据用户名称和阶段名称查询所有的关卡学习信息(用户操作)

部分代码如下:

@Override public ResultInfo selectStudyCustomspassByUsernameAndStageName(String username, String stageName) { ResultInfo info=new ResultInfo(); info.setFlag(true); try { List studyCustomspassList=customspassMapper.selectStudyCustomspassByUsernameAndStageName(username,stageName); info.setData(studyCustomspassList); }catch (Exception e){ info.setFlag(false); info.setErrorMsg("查询失败"); e.printStackTrace(); } return info; }

@Select("SELECT * FROM study_customspass WHERe customspassId IN(n" + "tSELECt customspassId FROM stage_customspass WHERe stageId IN(n" + "ttSELECt stageId FROM stage WHERe `name`=#{stageName} n" + "t)n" + ")AND username=#{username}") List selectStudyCustomspassByUsernameAndStageName( @Param("username") String username, @Param("stageName") String stageName);

2.3 根据学科名称查询关卡学习信息(管理员操作)

部分代码如下:

@Override public ResultInfo selectStudyCustomspassBySubjectName(String subjectName) { ResultInfo info=new ResultInfo(); info.setFlag(true); try { Subject subject = subjectMapper.selectSubjectBySubjectName(subjectName); List studyCustomspassList=customspassMapper.selectStudyCustomspassBySubjectId(subject.getSubjectId()); info.setData(studyCustomspassList); }catch (Exception e){ info.setFlag(false); info.setErrorMsg("查询失败"); e.printStackTrace(); } return info; }

@Select("SELECT * FROM study_customspass WHERe customspassId IN(n" + "tSELECt customspassId FROM stage_customspass WHERe stageId IN(n" + "ttSELECt stageId FROM subject_stage WHERe subjectId=#{subjectId}n" + "t)n" + ")") List selectStudyCustomspassBySubjectId(int subjectId);

2.4 根据用户名称和学科名称查询关卡学习信息(用户操作)

部分代码如下:

@Override public ResultInfo selectStudyCustomspassByUsernameAndSubjectName(String username, String subjectName) { ResultInfo info=new ResultInfo(); info.setFlag(true); try { Subject subject = subjectMapper.selectSubjectBySubjectName(subjectName); List studyCustomspassList=customspassMapper.selectStudyCustomspassByUsernameAndSubjectId(username,subject.getSubjectId()); info.setData(studyCustomspassList); }catch (Exception e){ info.setFlag(false); info.setErrorMsg("查询失败"); e.printStackTrace(); } return info; }

@Select("SELECT * FROM study_customspass WHERe customspassId IN(n" + "tSELECt customspassId FROM stage_customspass WHERe stageId IN(n" + "ttSELECt stageId FROM subject_stage WHERe subjectId=#{subjectId}n" + "t)n" + ")AND username=#{username}") List selectStudyCustomspassByUsernameAndSubjectId(@Param("username") String username,@Param("subjectId") int subjectId);

总结

在本次冲刺阶段学习很多,不仅是框架知识层面的学习,还有团队层面的学习,这在团队合作中是相当重要的。在最开始就是因为我们没有把需求理解一致,导致后面出现许多问题,所以团队配合十分重要。在此冲刺中还用到了番茄钟,让自己在一定的时间段里面让自己专注在一件事件中,也让我收获颇多。在后面的冲刺中也会利用这次的经验做的更好!

Copyright © 2016-2020 www.365daan.com All Rights Reserved. 365答案网 版权所有 备案号:

部分内容来自互联网,版权归原作者所有,如有冒犯请联系我们,我们将在三个工作时内妥善处理。