项目冲刺二总结

最新推荐文章于 2025-11-24 14:38:27 发布

原创最新推荐文章于 2025-11-24 14:38:27 发布 · 803 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#java #后端

本文总结了一次使用禅道进行团队项目的冲刺经验，重点讲述了开启关卡学习与根据不同条件查询学科、阶段、关卡的功能实现。强调了需求讨论的重要性以及团队配合在项目中的关键作用，并提及了番茄工作法对提高专注力的帮助。

文章目录

前言
一、开启关卡学习
- 1.1 开启关卡
- 1.2设置完成时间/关闭时间
二、查询学科、阶段、关卡
总结

前言

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

一、开启关卡学习

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<StudyCustomspass> 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" +
            "\t\tSELECT stageId FROM stage WHERE `name`=#{stageName} \n" +
            "\t)\n" +
            ")")
    List<StudyCustomspass> selectStudyCustomspassByStageName(String stageName);

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

部分代码如下：

    @Override
    public ResultInfo selectStudyCustomspassByUsernameAndStageName(String username, String stageName) {
        ResultInfo info=new ResultInfo();
        info.setFlag(true);
        try {
            List<StudyCustomspass> 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" +
            "\t\tSELECT stageId FROM stage WHERE `name`=#{stageName} \n" +
            "\t)\n" +
            ")AND username=#{username}")
    List<StudyCustomspass> 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<StudyCustomspass> 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" +
            "\t\tSELECT stageId FROM subject_stage WHERE subjectId=#{subjectId}\n" +
            "\t)\n" +
            ")")
    List<StudyCustomspass> 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<StudyCustomspass> 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" +
            "\t\tSELECT stageId FROM subject_stage WHERE subjectId=#{subjectId}\n" +
            "\t)\n" +
            ")AND username=#{username}")
    List<StudyCustomspass> selectStudyCustomspassByUsernameAndSubjectId(@Param("username") String username,@Param("subjectId") int subjectId);

总结

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