• Java项目：基于JavaWeb的教务管理系统的设计与实现

    作者主页：夜未央5788

     简介：Java领域优质创作者、Java项目、学习资料、技术互助

    文末获取源码

    项目介绍

    本项目为基于WEB的教务管理系统。
    主要系统功能包括：
    学生管理：显示所有学生、添加学生；
    课程管理：显示所有课程、添加课程；
    学院管理：显示所有学院、添加学院；
    专业管理：所有专业、设置专业；

    环境需要

    1.运行环境：最好是java jdk 1.8，我们在这个平台上运行的。其他版本理论上也可以。
    2.IDE环境：IDEA，Eclipse,Myeclipse都可以。推荐IDEA;
    3.tomcat环境：Tomcat 7.x,8.x,9.x版本均可
    4.硬件环境：windows 7/8/10 1G内存以上；或者 Mac OS； 
    5.数据库：MySql 5.7版本；

    6.是否Maven项目: 是

    技术栈

    1. 后端：servlet

    2. 前端：JSP+css+javascript+layui

    使用说明

    1. 使用Navicat或者其它工具，在mysql中创建对应名称的数据库，并导入项目的sql文件；
    2. 使用IDEA/Eclipse/MyEclipse导入项目，Eclipse/MyEclipse导入时，导入成功后请执行maven clean;
    maven install命令，然后运行；
    3. 将项目中util/ConnectionUtil.java修改数据库信息
    4. 运行项目，在浏览器中输入http://localhost:8080/student-sys  登录

    管理员用户名：123456 密码：123456

    运行截图

     

     

     

     

     

     

     

     

    相关代码 

    AcademyController

    1. package controller;
    2.  
    3. import common.Pager;
    4. import domain.AcademyDomain;
    5. import domain.AdminDomain;
    6. import org.springframework.beans.factory.annotation.Autowired;
    7. import org.springframework.stereotype.Controller;
    8. import org.springframework.web.bind.annotation.RequestMapping;
    9. import org.springframework.web.servlet.ModelAndView;
    10. import service.AcademyService;
    11. import service.AdminService;
    12. import service.CourseService;
    13. import service.MajorService;
    14. import service.StudentService;
    15.  
    16. import java.util.List;
    17.  
    18. import javax.servlet.http.HttpServletRequest;
    19. import javax.servlet.http.HttpSession;
    20.  
    21. @Controller
    22. @RequestMapping("/students")
    23. public class AcademyController {
    24. 	@Autowired
    25. 	private AcademyService service;
    26. 	@Autowired
    27. 	private CourseService courseService;
    28. 	@Autowired 
    29. 	private MajorService majorService;
    30. 	
    31. 	public CourseService getCourseService() {
    32. 		return courseService;
    33. 	}
    34. 	public void setCourseService(CourseService courseService) {
    35. 		this.courseService = courseService;
    36. 	}
    37. 	public MajorService getMajorService() {
    38. 		return majorService;
    39. 	}
    40. 	public void setMajorService(MajorService majorService) {
    41. 		this.majorService = majorService;
    42. 	}
    43. 	public AcademyService getService() {
    44. 		return service;
    45. 	}
    46. 	public void setService(AcademyService service) {
    47. 		this.service = service;
    48. 	}
    49. 	
    50. 	//显示所有学院信息
    51. 	@RequestMapping("/showAllAcademy.do")
    52. 	public ModelAndView findAllAcademy( Integer page,Integer perPage,HttpServletRequest request){
    53. 		ModelAndView mv=new ModelAndView();
    54. 		HttpSession session = request.getSession();
    55. 		String error = (String) session.getAttribute("error");
    56. 		request.setAttribute("error", error);
    57. 		mv.setViewName("showAllAcademy");
    58. 		session.removeAttribute("error");
    59. 		Pager list=service.findAllAcademy(page,perPage);
    60. 		mv.addObject("Pager",list);
    61. 		return mv;
    62. 	}
    63. 	//删除学院
    64. 	@RequestMapping("/delAcademy.do")
    65. 	public ModelAndView delAcademy(Integer id,HttpServletRequest req){
    66. 		HttpSession session = req.getSession();
    67. 		String error = "";
    68. 		if (majorService.findByAId(id)) {
    69. 			error= "该学院下有专业，不能删除该学院！！！";
    70. 			session.setAttribute("error", error);
    71. 		}else {
    72. 			if (courseService.findByAId(id)) {
    73. 				error= "该学院下有课程，不能删除该学院！！！";
    74. 				session.setAttribute("error", error);
    75. 			}else {
    76. 				service.delAcademy(id);
    77. 			}
    78. 		}
    79. 		return new ModelAndView("redirect:/students/showAllAcademy.do");
    80. 	}
    81. 	//添加预处理
    82. 	@RequestMapping("/preAddAcademy.do")
    83. 	public ModelAndView preAddAcademy(){
    84. 		ModelAndView mv=new ModelAndView();
    85. 		mv.setViewName("addAcademy");
    86. 		return mv;
    87. 	}
    88. 	
    89. 	//添加学院
    90. 	@RequestMapping("/addAcademy.do")
    91. 	public ModelAndView addAcademy(AcademyDomain domain){
    92. 		service.addAcademy(domain);
    93. 		return new ModelAndView("redirect:/students/showAllAcademy.do");
    94. 	}
    95. 	//修改学院
    96. 	@RequestMapping("/modifyAcademy.do")
    97. 	public ModelAndView modifyAcademy(Integer id,AcademyDomain domain){
    98. 		service.modifyAcademy(id, domain);
    99. 		return new ModelAndView("redirect:/students/showAllAcademy.do");
    100. 	}
    101. 	
    102. }

    AdminController

    1. package controller;
    2.  
    3. import domain.AdminDomain;
    4. import org.springframework.beans.factory.annotation.Autowired;
    5. import org.springframework.stereotype.Controller;
    6. import org.springframework.web.bind.annotation.RequestMapping;
    7. import org.springframework.web.servlet.ModelAndView;
    8. import service.AdminService;
    9.  
    10. import javax.servlet.http.HttpServletRequest;
    11. import javax.servlet.http.HttpSession;
    12. import java.util.List;
    13.  
    14. @Controller
    15. @RequestMapping("/students")
    16. public class AdminController {
    17.  
    18. 	@Autowired
    19. 	private AdminService service;
    20.  
    21.  
    22. 	public AdminService getService() {
    23. 		return service;
    24. 	}
    25.  
    26. 	public void setService(AdminService service) {
    27. 		this.service = service;
    28. 	}
    29.  
    30. 	// 判断登录
    31. 	@RequestMapping("/login.do")
    32. 	public ModelAndView doLogin(AdminDomain ae, HttpServletRequest req) {
    33. 		HttpSession session = req.getSession();
    34. 		List list = service.findAll();
    35. 		ModelAndView mv = new ModelAndView();
    36. 		for (AdminDomain ad : list) {
    37. 			if (ae.getName().equals(ad.getName()) && ae.getPassword().equals(ad.getPassword())) {
    38. 				mv.addObject("ae", ae);
    39. 				session.setAttribute("user", ae);
    40. 				mv.setViewName("Main");
    41. 				return mv;
    42. 			}
    43. 		}
    44. 		mv.setViewName("loginFailure");
    45. 		return mv;
    46.  
    47. 	}
    48. }

    CourseController

    1. package controller;
    2.  
    3. import domain.AcademyDomain;
    4. import domain.CourseDomain;
    5. import org.springframework.beans.factory.annotation.Autowired;
    6. import org.springframework.stereotype.Controller;
    7. import org.springframework.web.bind.annotation.RequestMapping;
    8. import org.springframework.web.servlet.ModelAndView;
    9. import service.AcademyService;
    10. import service.CourseService;
    11.  
    12. import java.io.UnsupportedEncodingException;
    13. import java.util.List;
    14.  
    15. import javax.servlet.http.HttpServletRequest;
    16. import javax.servlet.http.HttpServletResponse;
    17.  
    18. @Controller
    19. @RequestMapping("/students")
    20. public class CourseController {
    21. 	@Autowired
    22. 	private CourseService service;
    23. 	@Autowired
    24. 	private AcademyService aService;
    25. 	
    26. 	public AcademyService getaService() {
    27. 		return aService;
    28. 	}
    29.  
    30. 	public void setaService(AcademyService aService) {
    31. 		this.aService = aService;
    32. 	}
    33.  
    34. 	public CourseService getService() {
    35. 		return service;
    36. 	}
    37.  
    38. 	public void setService(CourseService service) {
    39. 		this.service = service;
    40. 	}
    41. 	
    42. 	@RequestMapping("/showAllCourse.do")
    43. 	public ModelAndView showAllCourse(){
    44. 		ModelAndView mv=new ModelAndView();
    45. 		mv.setViewName("showAllCourse");
    46. 		List list=service.findAllCourse();
    47. 		mv.addObject("list",list);
    48. 		return mv;
    49. 	}
    50. 	//添加课程预处理
    51. 	@RequestMapping("/preAddCourse.do")
    52. 	public ModelAndView preAdd(){
    53. 		ModelAndView mv=new ModelAndView();
    54. 		List list=aService.findAllAcademy1();
    55. 		mv.addObject("list",list);
    56. 		mv.setViewName("addcourse");
    57. 		return mv;
    58. 	}
    59. 	//
    60. 	@RequestMapping("/addCourse.do")
    61. 	public ModelAndView addCourse(CourseDomain domain,HttpServletRequest request,HttpServletResponse response) throws Exception{
    62. 		request.setCharacterEncoding("UTF-8" );
    63. 		response.setCharacterEncoding("UTF-8");
    64. 		service.addCourse(domain);
    65. 		return new ModelAndView("redirect:/students/showAllCourse.do");
    66. 	}
    67. 	@RequestMapping("/delCourse.do")
    68. 	public ModelAndView delCourse(Integer id){
    69. 		service.delCourse(id);
    70. 		return new ModelAndView("redirect:/students/showAllCourse.do");
    71. 	}
    72. 	
    73. 	@RequestMapping("/preModifyCourse.do")
    74. 	public ModelAndView preModifyCourse(Integer id) throws Exception{
    75. 		ModelAndView mv=new ModelAndView();
    76. 		List alist=aService.findAllAcademy1();
    77. 		CourseDomain courseDomain = service.findById(id);
    78. 		mv.addObject("courseDomain", courseDomain);
    79. 		mv.addObject("alist",alist);
    80. 		mv.setViewName("modifyCourse");
    81. 		return mv;
    82. 	}
    83. 	
    84. 	@RequestMapping("/modifyCourse.do")
    85. 	public ModelAndView modifyCourse(Integer id,CourseDomain domain,HttpServletRequest request,HttpServletResponse response) throws Exception{
    86. 		request.setCharacterEncoding("UTF-8");
    87. 		response.setCharacterEncoding("UTF-8");
    88. 		service.modifyCourse(id, domain);
    89. 		return new ModelAndView("redirect:/students/showAllCourse.do");
    90. 	}
    91. }

    MajorController

    1. package controller;
    2.  
    3. import domain.AcademyDomain;
    4. import domain.MajorDomain;
    5. import org.springframework.beans.factory.annotation.Autowired;
    6. import org.springframework.stereotype.Controller;
    7. import org.springframework.web.bind.annotation.RequestMapping;
    8. import org.springframework.web.servlet.ModelAndView;
    9. import service.AcademyService;
    10. import service.MajorService;
    11. import service.StudentService;
    12.  
    13. import java.util.List;
    14.  
    15. import javax.servlet.http.HttpServletRequest;
    16. import javax.servlet.http.HttpServletResponse;
    17. import javax.servlet.http.HttpSession;
    18.  
    19. @Controller
    20. @RequestMapping("/students")
    21. public class MajorController {
    22. 	@Autowired
    23. 	private MajorService service;
    24. 	@Autowired
    25. 	private AcademyService aService;
    26. 	@Autowired
    27. 	private StudentService studentService;
    28. 	
    29. 	public StudentService getStudentService() {
    30. 		return studentService;
    31. 	}
    32.  
    33. 	public void setStudentService(StudentService studentService) {
    34. 		this.studentService = studentService;
    35. 	}
    36.  
    37. 	public AcademyService getaService() {
    38. 		return aService;
    39. 	}
    40.  
    41. 	public void setaService(AcademyService aService) {
    42. 		this.aService = aService;
    43. 	}
    44.  
    45. 	public MajorService getService() {
    46. 		return service;
    47. 	}
    48.  
    49. 	public void setService(MajorService service) {
    50. 		this.service = service;
    51. 	}
    52. 	//显示所有
    53. 	@RequestMapping("/showAllMajor.do")
    54. 	public ModelAndView findAll(HttpServletRequest request){
    55. 		HttpSession session = request.getSession();
    56. 		ModelAndView mv=new ModelAndView();
    57. 		String error = (String) session.getAttribute("error");
    58. 		request.setAttribute("error", error);
    59. 		mv.setViewName("showAllMajor");
    60. 		session.removeAttribute("error");
    61. 		List list=service.findAll();
    62. 		mv.addObject("list",list);
    63. 		return mv;
    64. 	}
    65. 	
    66. 	
    67. 	//添加预处理
    68. 	@RequestMapping("/preAddMajor.do")
    69. 	public ModelAndView preAdd(){
    70. 		ModelAndView mv=new ModelAndView();
    71. 		List majorList=aService.findAllAcademy1();
    72. 		mv.addObject("majorList",majorList);
    73. 		mv.setViewName("addMajor");
    74. 		return mv;
    75. 	}
    76. 	
    77. 	//添加专业
    78. 	@RequestMapping("/addMajor.do")
    79. 	public ModelAndView addMajor(MajorDomain domain,HttpServletRequest request,HttpServletResponse response) throws Exception{
    80. 		request.setCharacterEncoding("UTF-8" );
    81. 		response.setCharacterEncoding("UTF-8");
    82. 		service.addMajor(domain);	
    83. 		return new ModelAndView("redirect:/students/showAllMajor.do");
    84. 	}
    85. 	//删除
    86. 	@RequestMapping("/delMajor.do")
    87. 	public ModelAndView delMajor(Integer id,HttpServletRequest req){
    88. 		HttpSession session = req.getSession();
    89. 		String error = "";
    90. 		if (studentService.findByMajorId(id)) {
    91. 			error= "该专业类别下有学生，不能删除该专业！！！";
    92. 			session.setAttribute("error", error);
    93. 		}else {
    94. 			service.delMajor(id);
    95. 			
    96. 		}
    97. 		return new ModelAndView("redirect:/students/showAllMajor.do");
    98. 	}
    99. 	
    100. 	//修改
    101. 		@RequestMapping("/preModifyMajor.do")
    102. 		public ModelAndView preModifyMajor(Integer id ){
    103. 			ModelAndView mv=new ModelAndView();
    104. 			List academList=aService.findAllAcademy1();
    105. 			MajorDomain majorDomain = service.findById(id);
    106. 			mv.addObject("majorDomain",majorDomain);
    107. 			mv.addObject("majorList",academList);
    108. 			mv.setViewName("modifyMajor");
    109. 			return mv;
    110. 		}
    111. 	
    112. 	//修改
    113. 	@RequestMapping("/modifyMajor.do")
    114. 	public ModelAndView modifyMajor(Integer id ,MajorDomain domain,HttpServletRequest request,HttpServletResponse response) throws Exception{
    115. 		request.setCharacterEncoding("UTF-8" );
    116. 		response.setCharacterEncoding("UTF-8");
    117. 		service.modifyMajor(id, domain);
    118. 		return new ModelAndView("redirect:/students/showAllMajor.do");
    119. 	}
    120. 	
    121. }

    StudentController

    1. package controller;
    2.  
    3. import common.Pager;
    4. import domain.MajorDomain;
    5. import domain.StudentDomain;
    6. import org.springframework.beans.factory.annotation.Autowired;
    7. import org.springframework.stereotype.Controller;
    8. import org.springframework.web.bind.annotation.RequestMapping;
    9. import org.springframework.web.bind.annotation.RequestParam;
    10. import org.springframework.web.servlet.ModelAndView;
    11. import service.MajorService;
    12. import service.StudentService;
    13.  
    14. import java.util.List;
    15.  
    16. import javax.servlet.http.HttpServletRequest;
    17. import javax.servlet.http.HttpServletResponse;
    18.  
    19. /*
    20.  * MVC -->　Model + View + Controller
    21.  * ModelAndView 封装业务数据以及逻辑视图名
    22.  * Bean对象  --> 作用域  （ singleton prototype）
    23.  */
    24. @Controller
    25. @RequestMapping("/students")
    26. public class StudentController {
    27. 	@Autowired // 自动注入 ( byName byType)
    28. 	private StudentService service;
    29. 	@Autowired
    30. 	private MajorService majorservice;
    31.  
    32. 	public MajorService getMajorservice() {
    33. 		return majorservice;
    34. 	}
    35.  
    36. 	public void setMajorservice(MajorService majorservice) {
    37. 		this.majorservice = majorservice;
    38. 	}
    39.  
    40. 	public StudentService getService() {
    41. 		return service;
    42. 	}
    43.  
    44. 	public void setService(StudentService service) {
    45. 		this.service = service;
    46. 	}
    47.  
    48. 	// 添加学生预处理
    49. 	@RequestMapping("/preAdd.do")
    50. 	public ModelAndView preAddStudent() {
    51. 		List list = null;
    52. 		list = majorservice.findAll();
    53. 		ModelAndView mv = new ModelAndView();
    54. 		mv.addObject("list", list);
    55. 		mv.setViewName("addstudent");
    56. 		return mv;
    57. 	}
    58.  
    59. 	@RequestMapping("/create.do")
    60. 	public ModelAndView createStudent(StudentDomain domain, HttpServletRequest request, HttpServletResponse response)
    61. 			throws Exception {
    62. 		request.setCharacterEncoding("UTF-8");
    63. 		response.setCharacterEncoding("UTF-8");
    64. 		service.addStudent(domain);
    65. 		return new ModelAndView("redirect:/students/findForPager.do");
    66. 	}
    67.  
    68. 	// 显示所有
    69. 	@RequestMapping("/findForPager.do")
    70. 	// page, perPage 数据绑定
    71. 	// 获取参数
    72. 	public ModelAndView findForPager(@RequestParam(required = false) Integer page,
    73. 			@RequestParam(required = false) Integer perPage) {
    74.  
    75. 		ModelAndView mv = new ModelAndView();
    76. 		Pager pager = service.findForPager(page, perPage);
    77. 		mv.setViewName("showAll");
    78. 		mv.addObject("pager", pager);
    79. 		return mv;
    80. 	}
    81.  
    82. 	// 删除
    83. 	@RequestMapping("/delStudents.do")
    84. 	public ModelAndView delStuent(String id) {
    85. 		service.DelStudent(id);
    86. 		return new ModelAndView("redirect:/students/findForPager.do");
    87. 	}
    88.  
    89. 	// 修改
    90. 	@RequestMapping("/preModifyStudents.do")
    91. 	public ModelAndView preModifyStudent(Integer id) throws Exception {
    92. 		List list = null;
    93. 		list = majorservice.findAll();
    94. 		ModelAndView mv = new ModelAndView();
    95. 		StudentDomain studentDomain = service.findById(id);
    96. 		mv.addObject("mojorList", list);
    97. 		mv.addObject("student", studentDomain);
    98. 		mv.setViewName("modifystudent");
    99. 		return mv;
    100. 	}
    101.  
    102. 	// 修改
    103. 	@RequestMapping("/modifyStudents.do")
    104. 	public ModelAndView modifyStudent(Integer id, StudentDomain stu, HttpServletRequest request,
    105. 			HttpServletResponse response) throws Exception {
    106. 		request.setCharacterEncoding("UTF-8");
    107. 		response.setCharacterEncoding("UTF-8");
    108. 		service.Modify(id, stu);
    109. 		return new ModelAndView("redirect:/students/findForPager.do");
    110. 	}
    111.  
    112. 	// 按姓名查找
    113. 	@RequestMapping("/findByName.do")
    114. 	public ModelAndView findByName(String name, HttpServletRequest request, HttpServletResponse response)
    115. 			throws Exception {
    116. 		request.setCharacterEncoding("UTF-8");
    117. 		response.setCharacterEncoding("UTF-8");
    118. 		ModelAndView mv = new ModelAndView();
    119. 		Pager list = service.findByName(name);
    120. 		mv.setViewName("showAll");
    121. 		mv.addObject("pager", list);
    122. 		return mv;
    123. 	}
    124.  
    125. }

    如果也想学习本系统，下面领取。关注并回复：125jsp

  • 相关阅读:
    全志ARM926 Melis2.0系统的开发指引⑦
    mysql表结构生成工具——mysql_markdown
    分片架构设计技巧
    Postman 的使用教程（详细）
    排错 rpmbuild -ba ***.spec时出现 警告：发现已安装(但未打包的)文件/错误：警告：发现已安装(但未打包的)文件
    上海再发区块链专项方案 和数集团欲打造新一代Web3.0创新生态
    SSB技术介绍
    我决定把一个收费视频课全免费公开了，今天起，慢慢放出“人人都需要的产品思维课”...
    Python中[-1]、[:-1]、[::-1]、[n::-1]、[:,:,0]、[…,0]、[…,::-1] 的理解
    Ghidra反编译报错Can‘t read language spec ***/***/***/mips32be.sla
  • 原文地址：https://blog.csdn.net/hanyunlong1989/article/details/126844994