Java源码社

基于javaweb的SpringBoot学科竞赛管理系统(java+springboot+vue+mysql+maven)

更新于

运行环境

Java≥8、MySQL≥5.7、Node.js≥14

开发工具

后端：eclipse/idea/myeclipse/sts等均可配置运行
前端：WebStorm/VSCode/HBuilderX等均可

❗没学过node.js的不要搞前后端分离项目

适用

课程设计，大作业，毕业设计，项目练习，学习演示等

功能说明

071623282808

081623282808

091623282808

101623282808

基于javaweb的SpringBoot学科竞赛管理系统(java+springboot+vue+mysql+maven)

前端启动命令：npm run serve

学生
159951159 学生1

教师
445393889 123456

学院管理员
1212714291 123456

校级管理员
admin 123456

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
        return noticeService.addNotice(notice);
    }

    /**
     * 更新新的公告
     * @param notice
     * @return
     */
    @PostMapping("/updateNotice")
    public String updateNotice(Notice notice){
        return noticeService.addNotice(notice);
    }

    /**
     * 根据id删除公告
     * @param id
     * @return
     */
    @GetMapping("/deleteNoticeById")
    public String deleteNoticeById(int id){
        return noticeService.deleteNoticeById(id);
    }

    /**
     * 查询所有公告，并以类型分类，都以级别从高到底排列。
     * @return
     */
    @GetMapping("/selectAllByTypeOrderBYLevelDesc")
    public Map<String,List<Notice>> selectAllByTypeOrderBYLevelDesc(){
        return noticeService.findNoticeByTypeOrderByLevelDesc();
    }
}


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
    map.put("nowCount",nowCount);
    map.put("yesterday",count);
    map.put("week",week);
    return map;
}

@GetMapping("/getCollegeApplyCompInfoInCollege/{collegeId}")
public Map<String,Integer> getCollegeApplyCompInfoInCollege(@PathVariable Integer collegeId){
    Map<String,Integer> map=new HashMap<>();
    Date today = DateUtils.getStartTimeOfDay(new Date());
    Calendar calendar=Calendar.getInstance();
    calendar.add(Calendar.DATE,-1);
    Date yesterday = calendar.getTime();
    calendar.add(Calendar.DATE,-6);
    Date weekDay = calendar.getTime();

    List<Teacher_Project> Teacher_ProjectWeek = teacher_projectService.findAllByDate(weekDay, today);
    int week=0;
    for (Teacher_Project teacher_project : Teacher_ProjectWeek) {
        if(teacher_project.getApplyOrJoin()!=2&&teacher_project.getIsCreator()==true&&teacher_project.getProject().getComp().getCompState()<4&&collegeId==teacher_project.getProject().getCreateByTeacher().getCollege().getId())
            week++;
    }

    List<Teacher_Project> Teacher_Projects = teacher_projectService.findAllByDate(yesterday, today);
    int count=0;
    for (Teacher_Project teacher_project : Teacher_Projects) {
        if(teacher_project.getApplyOrJoin()!=2&&teacher_project.getIsCreator()==true&&teacher_project.getProject().getComp().getCompState()<4&&collegeId==teacher_project.getProject().getCreateByTeacher().getCollege().getId())
            count++;
    }

    List<Teacher_Project> all = teacher_projectRepository.findAll();
    int nowCount =0;
    for (Teacher_Project teacher_project  : all) {
        if(teacher_project.getApplyOrJoin()!=2&&teacher_project.getIsCreator()==true&&teacher_project.getProject().getComp().getCompState()<4&&collegeId==teacher_project.getProject().getCreateByTeacher().getCollege().getId())
            nowCount++;
    }
    map.put("nowCount",nowCount);
    map.put("yesterday",count);
    map.put("week",week);
    return map;
}


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
            endDate=startDate;
            startDate=calendar.getTime();
            eachMoth.add(count);
        }
        Collections.reverse(eachMoth);
        collegeName.add(college.getNickname());
        eachDataForCollege.put("name",college.getNickname());
        eachDataForCollege.put("type","line");
        eachDataForCollege.put("smooth",false);
        eachDataForCollege.put("data",eachMoth);
        eachData.add(eachDataForCollege);
    }
    Calendar calendar=Calendar.getInstance();
    for (int i =0;i<12;i++){

        if (calendar.get(Calendar.YEAR)<c.get(Calendar.YEAR)){
            showDate.add("去年"+(calendar.get(Calendar.MONTH)+1)+"月");
        }else{
            showDate.add((calendar.get(Calendar.MONTH)+1)+"月");
        }
        calendar.add(Calendar.MONTH,-1);
    }
    Collections.reverse(showDate);
    Collections.reverse(collegeName);
    Collections.reverse(eachData);
    infoMapDate.put("date",showDate);
    infoMapDate.put("collegeInfo",eachData);
    infoMapDate.put("collegeNames",collegeName);
    return infoMapDate;
}

@GetMapping("/getStudentJoinCompInfo")
public Map<String,Integer> getStudentJoinCompInfo(){
    Map<String,Integer> map=new HashMap<>();
    Date today = DateUtils.getStartTimeOfDay(new Date());
    Calendar calendar=Calendar.getInstance();
    calendar.add(Calendar.DATE,-1);
    Date yesterday = calendar.getTime();
    calendar.add(Calendar.DATE,-6);
    Date weekDay = calendar.getTime();

    List<Student_Project> studentProjectWeek = student_projectService.findAllByDate(weekDay, today);
    int week=0;
    for (Student_Project student_project : studentProjectWeek) {
        if(student_project.getApplyOrJoin()!=2&&student_project.getProject().getComp().getCompState()<4)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
@GetMapping("/getUnReadList/{receive}")
public List<Map<String ,Object>> getUnReadList(@PathVariable String receive){
    List<Map<String ,Object>> result=new ArrayList<>();
    List<Message> unReadMessage = messageService.findUnReadMessage(receive);
    for (Message message : unReadMessage) {
        Map<String ,Object> map=new HashMap<>();
        map.put("id",message.getId());
        map.put("date",message.getMsgDate());
        map.put("title",message.getTitle());
        map.put("content",message.getContent());
        if(message.getSenderRole()==0){
            Student student = studentRepository.findStudentByTargetId(message.getSender());
            map.put("sendUsername",student.getUsername());
            map.put("sendName",student.getNickname());
        }else if(message.getSenderRole()==1){
            Teacher teacher = teacherRepository.findTeacherByTargetId(message.getSender());
            map.put("sendUsername",teacher.getUsername());
            map.put("sendName",teacher.getNickname());
        }else if(message.getSenderRole()==2){
            College college = collegeRepository.findCollegeByTargetId(message.getSender());
            map.put("sendUsername",college.getUsername());
            map.put("sendName",college.getNickname());
        }else{
            Admin admin = adminRepository.findAdminByTargetId(message.getSender());
            map.put("sendUsername",admin.getUsername());
            map.put("sendName",admin.getNickname());
        }
        result.add(map);
    }
    return result;
}

@GetMapping("/getReadList/{receive}")
public List<Map<String ,Object>> getReadList(@PathVariable String receive){
    List<Map<String ,Object>> result=new ArrayList<>();
    List<Message> readMessage = messageService.findReadMessage(receive);
    for (Message message : readMessage) {
        Map<String ,Object> map=new HashMap<>();
        map.put("id",message.getId());
        map.put("date",message.getMsgDate());
        map.put("title",message.getTitle());
        map.put("content",message.getContent());
        if(message.getSenderRole()==0){
            Student student = studentRepository.findStudentByTargetId(message.getSender());
            map.put("sendUsername",student.getUsername());
            map.put("sendName",student.getNickname());
        }else if(message.getSenderRole()==1){
            Teacher teacher = teacherRepository.findTeacherByTargetId(message.getSender());
            map.put("sendUsername",teacher.getUsername());
            map.put("sendName",teacher.getNickname());
        }else if(message.getSenderRole()==2){
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
            compResult.setCode(200);
            compResult.setMessage("操作成功！");
        }else {
            compResult.setCode(400);
            compResult.setMessage("操作失败！");
        }
        return compResult;
    }
}



@RestController
@RequestMapping("/msg")
public class MessageController {

    @Autowired
    private MessageService messageService;

    @Autowired
    private AdminRepository adminRepository;

    @Autowired
    private StudentRepository studentRepository;

    @Autowired
    private CollegeRepository collegeRepository;

    @Autowired
    private TeacherRepository teacherRepository;
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49


@RestController
@RequestMapping("/data")
public class DataController {

    @Autowired
    private College_CompRepository college_compRepository;

    @Autowired
    private College_CompService college_compService;

    @Autowired
    private Teacher_ProjectService teacher_projectService;

    @Autowired
    private Student_ProjectService student_projectService;

    @Autowired
    private CollegeRepository collegeRepository;

    @Autowired
    private Student_ProjectRepository student_projectRepository;

    @Autowired
    private Teacher_ProjectRepository teacher_projectRepository;

    //----------------------------------admin端--------------------------------------------

    @GetMapping("/getAllCollegeJoinCompInfo")
    public Map<String ,Object> getAllCollegeInfo(){
        Map<String ,Object> infoMap=new HashMap<>();
        List<College> colleges = collegeRepository.findAll();
        List<College_Comp> collegeComps = college_compRepository.findAll();
        List<Map<String ,Object>> maps=new ArrayList<>();
        Integer sum=0;
        for (College college : colleges) {
            Map<String ,Object> map=new HashMap<>();
            int count=0;
            for (College_Comp collegeComp : collegeComps) {
                if(collegeComp.getCollege().getId()==college.getId()&&collegeComp.getApplyOrJoin()!=2)
                    count++;
            }
            map.put("name",college.getNickname());
            map.put("value",count);
            sum+=count;
            maps.add(map);
        }
        infoMap.put("collegeInfo",maps);

项目链接：
https://javayms.github.io?id=061623282808201cs
https://javayms.pages.dev?id=061623282808201cs