基于javaweb的JSP+Servlet教务管理系统(java+jsp+springmvc+jdbc+layui+mysql)

运行环境

Java≥8、MySQL≥5.7、Tomcat≥8

开发工具

eclipse/idea/myeclipse/sts等均可配置运行

适用

课程设计，大作业，毕业设计，项目练习，学习演示等

功能说明

基于javaweb的JSP+Servlet教务管理系统(java+jsp+springmvc+jdbc+layui+mysql)

项目介绍

本项目为基于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版本；

技术栈

1. 后端：springmvc+jdbc 2. 前端：JSP+css+javascript+layui

使用说明

1. 使用Navicat或者其它工具，在mysql中创建对应名称的数据库，并导入项目的sql文件； 2. 将项目中util/ConnectionUtil.java修改数据库信息 4. 运行项目，在浏览器中输入http://localhost:8080/student-sys 登录 管理员用户名：123456 密码：123456  

		this.service = service;
	}

	// 判断登录
	@RequestMapping("/login.do")
	public ModelAndView doLogin(AdminDomain ae, HttpServletRequest req) {
		HttpSession session = req.getSession();
		List<AdminDomain> list = service.findAll();
		ModelAndView mv = new ModelAndView();
		for (AdminDomain ad : list) {
			if (ae.getName().equals(ad.getName()) && ae.getPassword().equals(ad.getPassword())) {
				mv.addObject("ae", ae);
				session.setAttribute("user", ae);
				mv.setViewName("Main");
				return mv;
			}
		}
		mv.setViewName("loginFailure");
		return mv;

	}
}
package filter;



/** 
 * @description 认证Filter 
 */
public class AuthenticationFilter implements Filter{

	public void destroy() {
				
	}
	public void doFilter(ServletRequest arg0, ServletResponse arg1,
			FilterChain chain) throws IOException, ServletException {
		HttpServletRequest req = (HttpServletRequest)arg0;
		HttpServletResponse res=(HttpServletResponse) arg1;
		HttpSession session=req.getSession();
		
		AdminDomain admin=(AdminDomain) session.getAttribute("user");
		
		String path=req.getRequestURI();
		
		if(path.indexOf("index.jsp")>-1||path.indexOf("login.do")>-1||path.endsWith("css")||path.endsWith("js")||path.endsWith("jpg")){

@Controller
@RequestMapping("/students")
public class AdminController {

	@Autowired
	private AdminService service;


	public AdminService getService() {
		return service;
	}

	public void setService(AdminService service) {
		this.service = service;
	}

	// 判断登录
	@RequestMapping("/login.do")
	public ModelAndView doLogin(AdminDomain ae, HttpServletRequest req) {
		HttpSession session = req.getSession();
		List<AdminDomain> list = service.findAll();
		ModelAndView mv = new ModelAndView();
		for (AdminDomain ad : list) {
			if (ae.getName().equals(ad.getName()) && ae.getPassword().equals(ad.getPassword())) {
				mv.addObject("ae", ae);
				session.setAttribute("user", ae);
				mv.setViewName("Main");
				return mv;
			}
		}
		mv.setViewName("loginFailure");

@Controller
@RequestMapping("/students")
public class AcademyController {
	@Autowired
	private AcademyService service;
	@Autowired
	private CourseService courseService;
	@Autowired 
	private MajorService majorService;
	
	public CourseService getCourseService() {
		return courseService;
	}
	public void setCourseService(CourseService courseService) {
		this.courseService = courseService;
	}
	public MajorService getMajorService() {
		return majorService;
	}
	public void setMajorService(MajorService majorService) {
		this.majorService = majorService;
	}
	public AcademyService getService() {
		return service;
	}
	public void setService(AcademyService service) {
		this.service = service;
	}
	
	//显示所有学院信息
	@RequestMapping("/showAllAcademy.do")
	public ModelAndView findAllAcademy( Integer page,Integer perPage,HttpServletRequest request){
		ModelAndView mv=new ModelAndView();
		HttpSession session = request.getSession();
		String error = (String) session.getAttribute("error");
		request.setAttribute("error", error);
		mv.setViewName("showAllAcademy");

private MajorService majorservice;

public MajorService getMajorservice() {
	return majorservice;
}

public void setMajorservice(MajorService majorservice) {
	this.majorservice = majorservice;
}

public StudentService getService() {
	return service;
}

public void setService(StudentService service) {
	this.service = service;
}

// 添加学生预处理
@RequestMapping("/preAdd.do")
public ModelAndView preAddStudent() {
	List<MajorDomain> list = null;
	list = majorservice.findAll();
	ModelAndView mv = new ModelAndView();
	mv.addObject("list", list);
	mv.setViewName("addstudent");
	return mv;
}

@RequestMapping("/create.do")
public ModelAndView createStudent(StudentDomain domain, HttpServletRequest request, HttpServletResponse response)
		throws Exception {
	request.setCharacterEncoding("UTF-8");
	response.setCharacterEncoding("UTF-8");
	service.addStudent(domain);
	return new ModelAndView("redirect:/students/findForPager.do");
}

// 显示所有
@RequestMapping("/findForPager.do")
// page, perPage 数据绑定
// 获取参数
public ModelAndView findForPager(@RequestParam(required = false) Integer page,
		@RequestParam(required = false) Integer perPage) {

	ModelAndView mv = new ModelAndView();
	Pager<StudentDomain> pager = service.findForPager(page, perPage);

	public ModelAndView modifyCourse(Integer id,CourseDomain domain,HttpServletRequest request,HttpServletResponse response) throws Exception{
		request.setCharacterEncoding("UTF-8");
		response.setCharacterEncoding("UTF-8");
		service.modifyCourse(id, domain);
		return new ModelAndView("redirect:/students/showAllCourse.do");
	}
}
package util;


public class DoLogin implements Filter{
	public void destroy() {
		// TODO Auto-generated method stub
		
	}

	
	public void doFilter(ServletRequest request, ServletResponse response,
			FilterChain chain) throws IOException, ServletException {
		//获取session，request，response对象
		HttpServletRequest servletRequest=(HttpServletRequest)request;
		HttpServletResponse servletResponse=(HttpServletResponse)response;
		HttpSession session=servletRequest.getSession();
		//获取请求URI
		String path=servletRequest.getRequestURI();
		//从Session中获取管理员
		
		String adminName=(String) session.getAttribute("name");
		
		String password=(String)session.getAttribute("password");
		
		if(path.indexOf("/index.jsp")>-1)
		{
			chain.doFilter(servletRequest, servletResponse);
			return;
		}

public AcademyService getaService() {
	return aService;
}

public void setaService(AcademyService aService) {
	this.aService = aService;
}

public MajorService getService() {
	return service;
}

public void setService(MajorService service) {
	this.service = service;
}
//显示所有
@RequestMapping("/showAllMajor.do")
public ModelAndView findAll(HttpServletRequest request){
	HttpSession session = request.getSession();
	ModelAndView mv=new ModelAndView();
	String error = (String) session.getAttribute("error");
	request.setAttribute("error", error);
	mv.setViewName("showAllMajor");
	session.removeAttribute("error");
	List<MajorDomain> list=service.findAll();
	mv.addObject("list",list);
	return mv;
}


//添加预处理
@RequestMapping("/preAddMajor.do")
public ModelAndView preAdd(){
	ModelAndView mv=new ModelAndView();
	List<AcademyDomain> majorList=aService.findAllAcademy1();
	mv.addObject("majorList",majorList);
	mv.setViewName("addMajor");
	return mv;
}

//添加专业
@RequestMapping("/addMajor.do")
public ModelAndView addMajor(MajorDomain domain,HttpServletRequest request,HttpServletResponse response) throws Exception{
	request.setCharacterEncoding("UTF-8" );
	response.setCharacterEncoding("UTF-8");

---

项目链接：
https://javayms.github.io?id=591122522008200pp
https://javayms.pages.dev?id=591122522008200pp