Java项目：基于SpringBoot+Vue+mysql实现的学生成绩管理系统前后端分离（源码+数据库），界面优美，推荐！！！

package com.student.servie; import cn.hutool.core.lang.UUID; import cn.hutool.core.util.RandomUtil; import com.alibaba.fastjson.JSONArray; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.student.common.Result; import com.student.dao.entity.*; import com.student.dao.mapper.StCourseMapper; import com.student.dao.mapper.StGradeTeaMapper; import com.student.dao.service.*; import com.student.redis.delay.bean.Job; import com.student.utils.MainUtils; import com.student.vo.VoRoom; import com.student.dao.myenum.couEnum; import com.student.vo.VoStudent; import org.apache.shiro.SecurityUtils; import org.jeecgframework.poi.excel.ExcelImportUtil; import org.jeecgframework.poi.excel.entity.ImportParams; import org.springframework.beans.BeanUtils; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.beans.factory.annotation.Value; import org.springframework.stereotype.Service; import org.springframework.web.multipart.MultipartFile; import javax.xml.crypto.Data; import java.io.File; import java.io.IOException; import java.text.ParseException; import java.text.SimpleDateFormat; import java.util.*; /** * @author 李123 * 处理课程选修等相关信息 */ @Service public class CourseService { //课程背景图片上传地址 @Value("${couImgFile}") private String couImgPath; @Autowired private IStMajorService majorService; @Autowired private IStCourseService courseService; @Autowired private StCourseMapper courseMapper; @Autowired private StGradeTeaMapper gradeTeaMapper; @Autowired private IStGradeTeaService gradeTeaService; @Autowired private IStGradeStuService gradeStuService; @Autowired private IStReGradeStuService reGradeStuService; @Autowired private IStClassRoomService classRoomService; @Autowired private JobService jobService; /** * 初始化教师学年栏 */ public Result labelInit(){ StUser user = (StUser) SecurityUtils.getSubject().getPrincipal(); List<String> resultList=new LinkedList<>(); //构造查询条件 QueryWrapper<StClassRoom> query=new QueryWrapper<>(); List<Long> idList = getIdList(user.getId(), 1); int year; String time; //当前学期 Calendar date = Calendar.getInstance(); Map<String,Object> map= MainUtils.getStuDay(date.get(Calendar.YEAR),date.get(Calendar.MONTH)); int temYear=(int)map.get("year"); String temTime=(String)map.get("time"); //最早学期 if(idList.size()>0){ query.in("id", idList) .orderByAsc("stu_year"); String firstYear=classRoomService.list(query).get(0).getStuYear(); String[] split = firstYear.split(","); year=Integer.parseInt(split[0]); time=split[1]; }else{ year=temYear; time=temTime; } // year=2019; // time="一"; for(int i=0;year<=temYear;i++,year++){ if(year==temYear&&time.equals(temTime)){ resultList.add(year+"-"+(year+1)+"第一学期"); if("二".equals(temTime)){ resultList.add(year+"-"+(year+1)+"第"+temTime+"学期"); } break; } if(i==0){ if("一".equals(time)){ resultList.add(year+"-"+(year+1)+"第一学期"); } }else { resultList.add(year+"-"+(year+1)+"第一学期"); } resultList.add(year+"-"+(year+1)+"第二学期"); } return Result.succ(resultList); } /** * 定时开课 */ public Result timingStart(String time,Long roomId) throws ParseException { SimpleDateFormat format=new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); Date date=format.parse(time); StClassRoom classRoom = new StClassRoom(); classRoom.setId(roomId); classRoom.setTiming(time); //创建定时任务 Job job=new Job(); job.setDelayTime(date.getTime()-System.currentTimeMillis()); job.setId(roomId); job.setTopic("test"); jobService.addDefJob(job); if(classRoomService.updateById(classRoom)){ return Result.succ(null); }else { return Result.fail("定时失败"); } } /** * 更改课程状态 */ public Result changeState(int state,Long roomId){ StClassRoom classRoom = new StClassRoom(); SimpleDateFormat format=new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); classRoom.setId(roomId); if(state==2){ //结束课程 classRoom.setState(couEnum.END); }else { //即刻开课 classRoom.setState(couEnum.DING); classRoom.setTiming(format.format(new Date())); } if(classRoomService.updateById(classRoom)){ return Result.succ(null); }else { return Result.fail("更改失败"); } } /** * 根据学年和专业获取教师以创课堂 */ public Result getTeaRoom(String stuYear,String major){ StUser user = (StUser) SecurityUtils.getSubject().getPrincipal(); Long majorId=majorService.getOne(new QueryWrapper<StMajor>().eq("name",major)).getId(); List<Long> idList = getIdList(user.getId(), 1); List<VoRoom> rooms=new ArrayList<>(); if(idList.size()>0){ //构造查询条件 QueryWrapper<StClassRoom> query=new QueryWrapper<>(); query.in("id",idList) .eq("stu_year", stuYear) .eq("major_id",majorId); List<StClassRoom> list = classRoomService.list(query); if(list.size()>0){ list.forEach(item->{ VoRoom room=new VoRoom(); BeanUtils.copyProperties(item,room); if("".equals(item.getTiming())){ room.setTiming("待定"); } //查询选课人数 Long stuSum=gradeStuService.count(new QueryWrapper<StGradeStu>().eq("room_id",item.getId())); Long reStuSum=reGradeStuService.count(new QueryWrapper<StReGradeStu>().eq("room_id",item.getId())); //查询课程名称 room.setCouName(courseMapper.getCourse(item.getId()).getCouName()); room.setStuSum(stuSum+reStuSum); //赋予课程状态 room.setCouState(item.getState().getState()); rooms.add(room); }); } } return Result.succ(rooms); } /** * 更改课程背景图片 */ public Result upBcImg(MultipartFile file,Long roomId){ StUser user= (StUser) SecurityUtils.getSubject().getPrincipal(); String oriFilename= file.getOriginalFilename(); //用uuid构造唯一文件名 String newFilename= UUID.randomUUID()+"-"+user.getUsername()+"-"+oriFilename; //文件路径 File filePath = new File(couImgPath); if(!filePath.exists()){ if(!filePath.mkdirs()) { return Result.fail("文件路径创建失败"); } } //删除旧文件 String oldFilename=classRoomService.getById(roomId).getBcImg(); if(!"couBcImg.jpg".equals(oldFilename)){ File oldFile=new File(couImgPath+oldFilename); if(!oldFile.exists()||!oldFile.delete()){ return Result.fail("原有图片移除失败"); } } //上传文件 try { file.transferTo(new File(couImgPath+newFilename)); } catch (IOException e) { return Result.succ("背景图片上传失败"); } //�