Java项目:教师资格证报名系统(java+SpringBoot+vue+maven+mysql+elementui)

JDK1.8、IDEA、webstorm，mysql5.7、Navicat，node，vue

身份：管理员、考生
1.登录注册
2.考生报名
3.查看报考信息
4.考生管理
5.报考管理
6.考场管理
7.面试管理
8.查询考试结果并预约面试
9.获取合格证书并下载

package com.zl.controller;


import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.zl.entity.ExamRoom;
import com.zl.entity.SignMes;
import com.zl.entity.User;
import com.zl.mapper.SignMesMapper;
import com.zl.service.ExamRoomService;
import com.zl.service.SignMesService;
import com.zl.service.UserService;
import com.zl.vo.Result;
import com.zl.vo.SearchVo;
import org.apache.commons.lang3.StringUtils;
import org.springframework.web.bind.annotation.*;

import javax.annotation.Resource;

//QQ:2434110694/2691307716
//QQ:2434110694/2691307716
//QQ:2434110694/2691307716
//QQ:2434110694/2691307716
//QQ:2434110694/2691307716
@RestController
@RequestMapping("/sign")
@CrossOrigin
public class SignMesController {
    @Resource
    private SignMesService signMesService;
    @Resource
    private SignMesMapper signMesMapper;
    @Resource
    private ExamRoomService examRoomService;
    @Resource
    private UserService userService;


    //注册
    @PostMapping("/add")
    public Result add(@RequestBody SignMes signMes){
        SignMes dbSignMes = signMesMapper.findBySignMes(signMes.getUid().toString());
        if (dbSignMes!=null){
            return Result.error().message("您已完成报名!!!");
        }
        ExamRoom dbExamRoom = examRoomService.getById(signMes.getRid());
        Integer count = signMesMapper.count(signMes.getRid().toString());
        System.out.println("count+"+count);
        if (count!=null){
            if (dbExamRoom.getPeopleNum()<=count){
                return Result.error().message("该考场人数已满，请选择另外考场!!!");
            }
        }
        signMes.setState(0);
        return signMesService.save(signMes)?Result.ok().message("报名成功"):Result.error().message("服务器异常，请稍后再试");
    }

    //模糊查询报考信息
    @PostMapping("/list")
    public IPage list(@RequestBody SearchVo searchVo){
        Page page = new Page<>(searchVo.getPageNumber(), searchVo.getPageCount());
        QueryWrapper wrapper = new QueryWrapper<>();
        wrapper.like(StringUtils.isNotEmpty(searchVo.getName()),"name",searchVo.getName());
        Page selectPage = signMesMapper.selectPage(page, wrapper);
        for (SignMes thisSign : selectPage.getRecords()) {
            if (StringUtils.isNotEmpty(thisSign.getRid().toString())){
                thisSign.setRoom(examRoomService.getById(thisSign.getRid()));
            }
            if (StringUtils.isNotEmpty(thisSign.getUid().toString())){
                thisSign.setUser(userService.getById(thisSign.getUid()));
            }
        }
        return selectPage;
    }

    //id查询
    @GetMapping("/{id}")
    public SignMes find(@PathVariable("id") String id){
        SignMes sign = signMesService.getById(id);
        sign.setRoom(examRoomService.getById(sign.getRid()));
        return sign;
    }

    //删除
    @DeleteMapping("/{id}")
    public Result delete(@PathVariable("id") String id){
        return signMesService.removeById(id)?Result.ok().message("删除成功"):Result.error().message("服务器异常，请稍后再试");
    }

    //修改
    @PutMapping("/update")
    public Result update(@RequestBody SignMes signMes){
        return signMesService.updateById(signMes)?Result.ok().message("修改成功"):Result.error().message("服务器异常，请稍后再试");
    }

    //查询报名信息
    @GetMapping("/get/{uid}")
    public SignMes getUid(@PathVariable("uid") String uid){
        SignMes signMes = signMesMapper.findBySignMes(uid);
        signMes.setRoom(examRoomService.getById(signMes.getRid()));
        return signMes;
    }

    //不及格
    @PutMapping("/update/{id}")
    public Result update(@PathVariable("id") String id){
        SignMes dbSignMes = signMesService.getById(id);
        dbSignMes.setState(1);
        return signMesService.updateById(dbSignMes)?Result.ok().message("修改成功"):Result.error().message("服务器异常，请稍后再试");
    }

    //及格
    @PutMapping("/pass/{id}")
    public Result pass(@PathVariable("id") String id){
        SignMes dbSignMes = signMesService.getById(id);
        dbSignMes.setState(2);
        return signMesService.updateById(dbSignMes)?Result.ok().message("修改成功"):Result.error().message("服务器异常，请稍后再试");
    }

}