本科毕业设计-课程设计作业-基于SSM框架+mysql开发的家校通项目.zip

package schoolhome.core.controller; import java.io.IOException; import java.io.PrintWriter; import java.sql.Timestamp; import java.text.DateFormat; import java.text.ParseException; import java.text.SimpleDateFormat; import java.time.LocalDateTime; import java.util.ArrayList; import java.util.Date; import java.util.Locale; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import javax.servlet.http.HttpSession; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Controller; import org.springframework.ui.Model; import org.springframework.web.bind.annotation.RequestMapping; import schoolhome.core.po.ClassBean; import schoolhome.core.po.Commodity; import schoolhome.core.po.Homework; import schoolhome.core.po.Student; import schoolhome.core.po.StudentGrade; import schoolhome.core.po.StudentWithHomework; import schoolhome.core.po.Teacher; import schoolhome.core.po.TeacherCommodityHomework; import schoolhome.core.service.ClassBeanWithCommodityService; import schoolhome.core.service.HomeworkService; import schoolhome.core.service.StudentGradeService; import schoolhome.core.service.StudentService; import schoolhome.core.service.StudentWithHomeworkService; import schoolhome.core.service.TeacherCommodityHomeworkService; import schoolhome.core.service.TeacherService; @Controller public class TeacherController { @Autowired private TeacherService teacherService; @Autowired private StudentGradeService studentGradeService; @Autowired private ClassBeanWithCommodityService classBeanWithCommodityService; @Autowired private StudentService studentService; @Autowired private HomeworkService homeworkService; @Autowired private TeacherCommodityHomeworkService teacherCommodityHomeworkService; @Autowired private StudentWithHomeworkService studentWithHomeworkService; /** * 分页显示老师信息列表 * */ @RequestMapping(value="/teacherInformation.action") public String queryAllOrderPage(Model model,HttpSession session,HttpServletRequest request){ session.removeAttribute("page_count"); session.removeAttribute("teacherList"); session.removeAttribute("p"); int page_count;//总页数 int p;//当前页数 int size = 15;//每页记录数 int result_count = teacherService.queryCountOfRows();//总记录数 int begin;//当前页第一条记录索引号 page_count = (result_count+size-1)/size; String page_s = request.getParameter("page"); if(page_s==null) page_s="1"; p=Integer.parseInt(page_s); begin = (p-1)*size; ArrayList<Teacher> beans = teacherService.queryAllOrderPage(begin, size); session.setAttribute("teacherList", beans); session.setAttribute("page_count", page_count); session.setAttribute("p", p); return "/admin/teacherInformation"; } /** * 添加老师 * */ @RequestMapping(value="/addTeacher.action") public void addUser(Teacher teacher,HttpServletResponse response){ response.setHeader("content-type", "text/html;charset=utf-8"); response.setCharacterEncoding("utf-8"); PrintWriter out = null; try { out = response.getWriter(); } catch (IOException e) { // TODO Auto-generated catch block e.printStackTrace(); } if (teacherService.selectTeacherByTeacherUserName(teacher.getUserName())==null) { teacherService.addTeacher(teacher); out.print("<script>alert('添加成功');window.location='/test5/teacherInformation.action'</script>"); out.flush(); out.close(); }else { out.print("<script>alert('userName用户名已存在');window.location='/test5/teacherInformation.action'</script>"); out.flush(); out.close(); } } /** * 修改老师信息 * */ @RequestMapping("/teacherInformationUpdate.action") public void updateTeacherInformation(int teacherId,String userName,String password,String teacherName,int age,String telephone,String gender,HttpServletResponse response){ Teacher teacher = new Teacher(teacherId, userName, password, teacherName, age, telephone, gender); response.setHeader("content-type", "text/html;charset=utf-8"); response.setCharacterEncoding("utf-8"); PrintWriter out=null; try { out = response.getWriter(); } catch (IOException e) { // TODO Auto-generated catch block e.printStackTrace(); } if (teacherService.selectTeacherByTeacherUserName(teacher.getUserName())!=null && teacherService.selectTeacherByTeacherUserName(teacher.getUserName()).getId()!=teacher.getId()) { out.print("<script>alert('userName用户名已存在');window.location='/test5/teacherInformation.action'</script>"); out.flush(); out.close(); }else { teacherService.updateTeacherInformation(teacher); out.print("<script>alert('修改成功');window.location='/test5/teacherInformation.action'</script>"); out.flush(); out.close(); } } /** * 删除老师通过id * */ @RequestMapping("/deleteTeacherById.action") public void deleteTeacherrById(int id,HttpServletResponse response){ response.setHeader("content-type", "text/html;charset=utf-8"); response.setCharacterEncoding("utf-8"); PrintWriter out=null; try { out = response.getWriter(); } catch (IOException e) { // TODO Auto-generated catch block e.printStackTrace(); } if(teacherService.queryTeacherById(id)==null){ out.print("<script>alert('用户不存在');window.location='/test5/teacherInformation.action'</script>"); out.flush(); out.close(); }else { teacherService.deleteTeacherById(id); out.print("<script>alert('删除成功');window.location='/test5/teacherInformation.action'</script>"); out.flush(); out.close(); } } /** * 老师修改学生成绩 * */ @RequestMapping("/teacherUpdateStudentGrade.action") public void teacherUpdateStudentGrade(int classBean_id,int student_id,int commodity_id,double grade,HttpServletResponse response,HttpSession session,HttpServletRequest request){ response.setHeader("content-type", "text/html;charset=utf-8"); response.setCharacterEncoding("utf-8"); Teacher teacher = (Teacher)session.getAttribute("userinfor"); session.removeAttribute("userinfor"); PrintWriter out=null; try { out = response.getWriter(); } catch (IOException e) { // TODO Auto-generated catch block e.printStackTrace(); } StudentGrade studentGrade=studentGradeService.queryStudentGradeByStudentIdAndCommodityId(student_id, commodity_id); if(studentGrade!=null){ studentGrade.setGrade(grade); studentGradeService.updateStudentGradeInformation(studentGrade); for(ClassBean classBean:teacher.getClassBeanList()){ if(classBean.getId()==classBean_id){ for(Student studentBean:classBean.getStudentList()){ if(studentBean.getId()==student_id){ //studentBean=studentService.queryStudentById(student_id); for(Commodity studentCommodity:studentBean.getCommodityList()){ if(studentCommodity.getId()==commodity_id){ studentCommodity.setGrade(grade); break; } } break; } } break; } } session.setAttribute("userinfor", teacher); out.print("<script>alert('成绩修改成功');window.location='/test5/teacherQueryStudentGradeInformation.action?id="+classBean_id+"'</script>"); out.flush(); out.close(); }else { studentGrade = new StudentGrade(); studentGrade.setStudent_id(student_id); studentGrade.setCommodity_id(commodity_id); studentGrade.setGrade(grade); studentGradeService.addStudentGrade(studentGrade); for(ClassBean classBean:teacher.getClassBeanList()){ if(classBean.getId()==classBean_id){ for(Student studentBean:classBean.getStudentList()){ if(studentBean.getId()==student_id){ classBean.getStudentList().remove(studentBean); Student newStudentBean=studentService.queryStudentById(student_id); for(Commodity studentCommodity:newStudentBean.getCommodityList()) studentCommodity.setClassBeanTeacher(classBeanWithCommodityService.queryT