基于Java Web的网络教学辅助平台-源代码

/*控制器 分发请求*/ package com.xafdy.web; import java.io.File; import java.io.IOException; import java.io.InputStream; import java.text.DecimalFormat; import java.util.ArrayList; import java.util.Date; import java.util.HashMap; import java.util.List; import java.util.Map; import javax.annotation.Resource; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpSession; import org.apache.poi.hssf.usermodel.HSSFCell; import org.apache.poi.hssf.usermodel.HSSFRow; import org.apache.poi.hssf.usermodel.HSSFSheet; import org.apache.poi.hssf.usermodel.HSSFWorkbook; import org.springframework.stereotype.Controller; import org.springframework.web.bind.annotation.PathVariable; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RequestParam; import org.springframework.web.bind.annotation.ResponseBody; import org.springframework.web.multipart.MultipartFile; import org.springframework.web.servlet.ModelAndView; import com.xafdy.dto.Answer; import com.xafdy.model.Admin; import com.xafdy.model.College; import com.xafdy.model.Course; import com.xafdy.model.CourseFile; import com.xafdy.model.CourseVideo; import com.xafdy.model.Discuss; import com.xafdy.model.DiscussPost; import com.xafdy.model.Notice; import com.xafdy.model.Student; import com.xafdy.model.StudentFile; import com.xafdy.model.StudentTask; import com.xafdy.model.Task; import com.xafdy.model.TaskQuestion; import com.xafdy.model.Teacher; import com.xafdy.service.IndexService; @Controller public class IndexController { @Resource private IndexService indexService; @RequestMapping("/index") public ModelAndView index() { ModelAndView mav = new ModelAndView(); mav.setViewName("index"); return mav; } @RequestMapping("/logon") public ModelAndView logon() { ModelAndView mav = new ModelAndView(); mav.addObject("info", "请登录"); mav.setViewName("logon"); return mav; } @RequestMapping("/register") public ModelAndView register() { ModelAndView mav = new ModelAndView(); mav.addObject("colleges", indexService.searchCollege()); mav.setViewName("register"); return mav; } //注册 @RequestMapping("/addStudent") public ModelAndView addStudent(Student student) { indexService.saveStudent(student); return new ModelAndView("redirect:/logon.html"); } @RequestMapping("/userLogon") public ModelAndView userLogon(String account, String password, Integer role, HttpSession session) { Map<String, String> map = new HashMap<>(); map.put("account", account); map.put("password", password); if (role == 0) { Admin admin = indexService.adminLogon(map); if (admin == null) { ModelAndView mav = new ModelAndView(); mav.addObject("info", "用户名或密码错误！"); mav.setViewName("logon"); return mav; } else { session.setAttribute("user", admin); return new ModelAndView("redirect:/index.html"); } } else if (role == 1) { Teacher teacher = indexService.teacherLogon(map); if (teacher == null) { ModelAndView mav = new ModelAndView(); mav.addObject("info", "用户名或密码错误！"); mav.setViewName("logon"); return mav; } else { session.setAttribute("user", teacher); return new ModelAndView("redirect:/teacherIndex.html"); } } else { Student student = indexService.studentLogon(map); if (student == null) { ModelAndView mav = new ModelAndView(); mav.addObject("info", "用户名或密码错误！"); mav.setViewName("logon"); return mav; } else { session.setAttribute("user", student); return new ModelAndView("redirect:/studentIndex.html"); } } } @RequestMapping("/teacherIndex") public ModelAndView teacherindex() { ModelAndView mav = new ModelAndView(); mav.setViewName("teacherIndex"); return mav; } @RequestMapping("/studentIndex") public ModelAndView studentIndex() { ModelAndView mav = new ModelAndView(); mav.setViewName("studentIndex"); return mav; } @RequestMapping("/createStudent") public ModelAndView createStudent() { ModelAndView mav = new ModelAndView(); mav.addObject("colleges", indexService.searchCollege()); mav.setViewName("createStudent"); return mav; } @RequestMapping("/createTeacher") public ModelAndView createTeacher() { ModelAndView mav = new ModelAndView(); mav.addObject("colleges", indexService.searchCollege()); mav.addObject("courses", indexService.searchCourse()); mav.setViewName("createTeacher"); return mav; } @RequestMapping("/createCollege") public ModelAndView createCollege() { ModelAndView mav = new ModelAndView(); mav.setViewName("createCollege"); return mav; } @RequestMapping("/saveStudent") public ModelAndView saveStudent(Student student) { indexService.saveStudent(student); return new ModelAndView("redirect:/createStudent.html"); } @RequestMapping("/saveTeacher") public ModelAndView saveStudent(Teacher teacher) { indexService.saveTeacher(teacher); return new ModelAndView("redirect:/createTeacher.html"); } @RequestMapping("/saveCollege") public ModelAndView saveCollege(College college) { indexService.saveCollege(college); return new ModelAndView("redirect:/createCollege.html"); } @RequestMapping("/searchStudent") public ModelAndView searchStudent() { ModelAndView mav = new ModelAndView(); mav.addObject("students", indexService.searchStudent()); mav.setViewName("searchStudent"); return mav; } @RequestMapping("/searchTeacher") public ModelAndView searchTeacher() { ModelAndView mav = new ModelAndView(); mav.addObject("teachers", indexService.searchTeacher()); mav.setViewName("searchTeacher"); return mav; } @RequestMapping("/searchCollege") public ModelAndView searchCollege() { ModelAndView mav = new ModelAndView(); mav.addObject("colleges", indexService.searchCollege()); mav.setViewName("searchCollege"); return mav; } @RequestMapping("/deleteStudent/{id}") public ModelAndView deleteStudent(@PathVariable("id") Integer id) { indexService.deleteStudent(id); return new ModelAndView("redirect:/searchStudent.html"); } @RequestMapping("/deleteStudents/{id}") /* @PathVariable获取的是请求路径中参数的值 */ public ModelAndView deleteStudents(@PathVariable("id") String id) { indexService.deleteStudents(id); return new ModelAndView("redirect:/searchStudent.html"); } @RequestMapping("/deleteTeacher/{id}") public ModelAndView deleteTeacher(@PathVariable("id") Integer id) { indexService.deleteTeacher(id); return new ModelAndView("redirect:/searchTeacher.html"); } @RequestMapping("/deleteCollege/{id}") public ModelAndView deleteCollege(@PathVariable("id") Integer id) { indexService.deleteColege(id); return new ModelAndView("redirect:/searchCollege.html"); } @RequestMapping("/updateStudent/{id}") public ModelAndView updateStudent(@PathVariable("id") Integer id) { ModelAndView mav = new ModelAndView(); mav.addObject("colleges", indexService.searchCollege()); mav.addObject("student", indexService.getStudentById(id)); mav.setViewName("updateStudent"); return mav; } @RequestMapping("/updateStudentInfo") public ModelAndView updateStudentInfo(HttpSession session) { Student student = (Student)session.getAttribute("user"); ModelAndView mav = new ModelAndView(); mav.addObject("colleges", indexService.searchCollege()); mav.addObject("student", indexService.getStudentById(student.getId())); mav.setViewName("updateStudentInfo"); return mav; } @RequestMapping("/updateTeacher/{id}") public ModelAndView updateTeacher(@PathVariable("id") Integer id) { ModelAndView mav = new ModelAndView(); mav.addObject("colleges", indexService.searchCollege()); mav.addObject("courses", indexService.searchCourse()); mav.addObject("teacher", indexService.getTeacherById(id)); mav.setViewName("updateTeacher"); retur