《学生成绩管理系统》毕业设计 Java+MySQL开发 Java+MySQL开发的《学生成绩管理系统》毕业设计，系统采用java

package com.wnn.controller; import com.wnn.entity.*; import com.wnn.service.ClassesService; import com.wnn.service.ResultService; import com.wnn.service.SubTeaService; import com.wnn.service.TeacherSevice; import com.wnn.utils.JsonUtils; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Controller; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.ResponseBody; import javax.servlet.http.HttpServletRequest; import java.text.DecimalFormat; import java.util.List; import static com.wnn.controller.SelectResultController.df; @Controller @RequestMapping("teacher") public class TeacherController { @Autowired TeacherSevice teacherSevice; @Autowired ResultService resultService; @Autowired SubTeaService subTeaService; @Autowired ClassesService classesService; @RequestMapping("/toTeacher") public String toStudent(){ return "model/admin/teacher"; } @ResponseBody @RequestMapping("/json") public String getXiByLimit(Teacher teacher){ List<Teacher> list=teacherSevice.selectEntity(teacher); return "{\"total\":"+teacherSevice.selectCount(teacher)+",\"rows\":"+ JsonUtils.getJson(list)+"}"; } @RequestMapping("/insert") @ResponseBody public int insertAdmin(Teacher teacher){ return teacherSevice.insert(teacher); } @ResponseBody @RequestMapping("/delete") public int deleteAdmin(Teacher teacher){ return teacherSevice.delete(teacher); } @RequestMapping("/toUpdatePwd") public String toUpdatePwd(){ return "model/teacher/updatePwd"; } @ResponseBody @RequestMapping("/update") public int update(Teacher teacher){ return teacherSevice.updatePwd(teacher); } /** * 去老师管理的界面 * @return */ @RequestMapping("/toTeacherResult") public String toResultResult(){ return "model/teacher/teacherInto"; } @RequestMapping("/toUserInfo") public String toUserInfo(){ return "model/teacher/userInfo"; } /** * 老师按照学生学号和姓名查询成绩 * @param request * @param result * @return */ @RequestMapping("/selectStudent") public String selectStudent(HttpServletRequest request, Result result){ List<Result> resultList=resultService.selectResult(result); System.out.println(resultList.size()); request.setAttribute("results",resultList); request.setAttribute("searchName",result.getSearchName()); if(resultList!=null && resultList.size()>0) { double total = 0; double number=0; double totalSuNumber=0; int size=0; for (Result r : resultList) { if(r!=null){ if (r.getResult() != null) { int sujNumber=r.getSubject().getNumber(); total += r.getResult(); if(r.getResult()>=90 && r.getResult()<=100){ number+=sujNumber*4; }else if(r.getResult()>=80 && r.getResult()<90){ number+=sujNumber*3; }else if(r.getResult()>=70 && r.getResult()<80){ number+=sujNumber*2; }else if(r.getResult()>=60 && r.getResult()<70){ number+=sujNumber*1; } totalSuNumber+=sujNumber; size+=1; } } } request.setAttribute("avg", df.format(total / size)); request.setAttribute("number", df.format(number /totalSuNumber)); request.setAttribute("total", total); request.setAttribute("explain", "其中有成绩的学科有"+size+"门,其中总绩点为"+number+",学科总学分为"+totalSuNumber); } return "model/teacher/teacherInto"; } /** * 按照学科查询成绩 * @param request * @param result * @return */ @RequestMapping("/toStudentSubject") public String toStudentSubject(HttpServletRequest request, Result result){ String year= (String) request.getSession().getAttribute("year"); result.setTerm(year); request.setAttribute("subjects", subTeaService.selectSubjectByTeacherId(result)); if(result.getSubId()!=null && !"".equals(result.getSubId()) && result.getSearchName()!=null && !"".equals(result.getSearchName())){ List<Result> resultList=resultService.selectResult(result); request.setAttribute("searchName",result.getSearchName()); request.setAttribute("subId",result.getSubId()); for (Result r:resultList){ if(r!=null){ r.setMinResult(resultService.selectMinResult(r)); r.setMaxResult(resultService.selectMaxResult(r)); r.setAvg(resultService.selectAvg(r)); r.setAsc(resultService.selectAsc(r)); } } request.setAttribute("results",resultList); } return "model/teacher/studentSubject"; } @RequestMapping("/toSelectClasses") public String toselectClasses(HttpServletRequest request,Result result){ String year= (String) request.getSession().getAttribute("year"); result.setTerm(year); request.setAttribute("subjects", subTeaService.selectSubjectByTeacherId(result)); request.setAttribute("classess", classesService.selectClassesByTeacherId(result)); if(result.getSubId()!=null &&!"".equals(result.getSubId()) && result.getClassesId()!=null &&!"".equals(result.getClassesId())){ List<Result> resultList=resultService.selectResult(result); request.setAttribute("claId",result.getClassesId()); request.setAttribute("subId",result.getSubId()); request.setAttribute("results",resultList); } return "model/teacher/selectClasses"; } @RequestMapping("/toTatolResult") public String toTatolResult(HttpServletRequest request,Result result){ String year= (String) request.getSession().getAttribute("year"); result.setTerm(year); request.setAttribute("subjects", subTeaService.selectSubjectByTeacherId(result)); request.setAttribute("subId",result.getSubId()); if(result.getSubId()!=null && !"".equals(result.getSubId())){ Pass pass=new Pass(); int passInt=resultService.selectPass(result); int noPassInt=resultService.selectNoPass(result); int excellentInt=resultService.selectExcellent(result); int size=resultService.selectAllSize(result); pass.setNoPassInt(noPassInt); pass.setPassInt(passInt); pass.setExcellentInt(excellentInt); float num= (float)noPassInt/size; DecimalFormat df = new DecimalFormat("0.00");//格式化小数 pass.setNoPassBFB(df.format(num)); float num1= (float)passInt/size; pass.setPassBFB(df.format(num1)); float num2= (float)passInt/size; pass.setExcellentBFB(df.format(num2)); pass.setSize(size); request.setAttribute("pass",pass); } return "model/teacher/tatolResult"; } @RequestMapping("/toTeacherSelect") public String toSelectResult(HttpServletRequest request,Result result){ String year= (String) request.getSession().getAttribute("year"); result.setTerm(year); request.setAttribute("subjects", subTeaService.sele