Java源码社

基于javaweb的JSP+Servlet学生信息管理系统(java+servlet+jsp+easyui+mysql)

更新于

运行环境

Java≥8、MySQL≥5.7、Tomcat≥8

开发工具

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

适用

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

功能说明

350023572402

360023572402

370023572402

380023572402

390023572402

400023572402

基于javaweb的JSP+Servlet学生信息管理系统(java+servlet+jsp+easyui+mysql)

介绍

学生信息管理系统,该项目分为管理员、老师、学生三种角色； 管理员主要功能： 学生信息管理、班级信息管理、教师信息管理、系统管理； 老师主要功能： 学生信息管理、班级信息管理、教师信息管理、系统管理； 学生主要功能： 学生信息管理、系统管理；

环境需要

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.是否Maven项目: 否；查看源码目录中是否包含pom.xml；若包含，则为maven项目，否则为非maven项目  6.数据库：MySql 5.7版本；

技术栈

  1. Servlet+Jsp+easyui

使用说明

  1. 使用IDEA/Eclipse/MyEclipse导入项目，Eclipse/MyEclipse导入时，若为maven项目请选择maven;若为maven项目，导入成功后请执行maven clean;maven install命令，配置tomcat，然后运行； 2. 使用Navicat或者其它工具，在mysql中创建对应名称的数据库，并导入项目的sql文件； 3. 将项目中DbUtil.java中的数据库配置改为自己的配置 4. 配置tomcat,运行项目，在浏览器中输入localhost:8080/xxx 登录 5.管理员账号：admin 密码：admin 教师账号：王鹤翔老师 密码：111 学生账号：江小雷 密码：1

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
	String method = request.getParameter("method");
	if("toPersonalView".equals(method)){
		personalView(request,response);
		return;
	}else if("EditPasswod".equals(method)){
		editPassword(request,response);
		return;
	}
	try {
		request.getRequestDispatcher("view/system.jsp").forward(request, response);
	} catch (ServletException e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
	}
}
private void editPassword(HttpServletRequest request,
		HttpServletResponse response) {
	// TODO Auto-generated method stub
	String password = request.getParameter("password");
	String newPassword = request.getParameter("newpassword");
	response.setCharacterEncoding("UTF-8");
	int userType = Integer.parseInt(request.getSession().getAttribute("userType").toString());
	if(userType == 1){
		//管理员
		Admin admin = (Admin)request.getSession().getAttribute("user");
		if(!admin.getPassword().equals(password)){
			try {
				response.getWriter().write("原密码错误！");
				return;
			} catch (IOException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		AdminDao adminDao = new AdminDao();
		if(adminDao.editPassword(admin, newPassword)){
			try {
				response.getWriter().write("success");
			} catch (IOException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
		Integer pageSize = request.getParameter("rows") == null ? 999 : Integer.parseInt(request.getParameter("rows"));
		Clazz clazz = new Clazz();
		clazz.setName(name);
		ClazzDao clazzDao = new ClazzDao();
		List<Clazz> clazzList = clazzDao.getClazzList(clazz, new Page(currentPage, pageSize));
		int total = clazzDao.getClazzListTotal(clazz);
		clazzDao.closeCon();
		response.setCharacterEncoding("UTF-8");
		Map<String, Object> ret = new HashMap<String, Object>();
		ret.put("total", total);
		ret.put("rows", clazzList);
		try {
			String from = request.getParameter("from");
			if("combox".equals(from)){
				response.getWriter().write(JSONArray.fromObject(clazzList).toString());
			}else{
				response.getWriter().write(JSONObject.fromObject(ret).toString());
			}
		} catch (IOException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
}
package com.ischoolbar.programmer.servlet;




/**
 * 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
				loginStatus = "loginSuccess";
				break;
			}
			case 2:{
				StudentDao studentDao = new StudentDao();
				Student student = studentDao.login(name, password);
				studentDao.closeCon();
				if(student == null){
					response.getWriter().write("loginError");
					return;
				}
				HttpSession session = request.getSession();
				session.setAttribute("user", student);
				session.setAttribute("userType", type);
				loginStatus = "loginSuccess";
				break;
			}
			case 3:{
				TeacherDao teahcerDao = new TeacherDao();
				Teacher teacher = teahcerDao.login(name, password);
				teahcerDao.closeCon();
				if(teacher == null){
					response.getWriter().write("loginError");
					return;
				}
				HttpSession session = request.getSession();
				session.setAttribute("user", teacher);
				session.setAttribute("userType", type);
				loginStatus = "loginSuccess";
				break;
			}
			default:
				break;
			}
		response.getWriter().write(loginStatus);
		
	}
	
	private void logout(HttpServletRequest request,HttpServletResponse response) throws IOException{
		request.getSession().removeAttribute("user");
		request.getSession().removeAttribute("userType");
		response.sendRedirect("index.jsp");
	}
}
package com.ischoolbar.programmer.servlet;


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
			leaveDao.closeCon();
		}
	}
}
package com.ischoolbar.programmer.servlet;




/**
 * 
 *学生信息管理功能实现servlet
 */
public class StudentServlet extends HttpServlet {
	public void doGet(HttpServletRequest request,HttpServletResponse response) throws IOException{
		doPost(request, response);
	}
	public void doPost(HttpServletRequest request,HttpServletResponse response) throws IOException{
		String method = request.getParameter("method");
		if("toStudentListView".equals(method)){
			studentList(request,response);
		}else if("AddStudent".equals(method)){
			addStudent(request,response);
		}else if("StudentList".equals(method)){
			getStudentList(request,response);
		}else if("EditStudent".equals(method)){
			editStudent(request,response);
		}else if("DeleteStudent".equals(method)){
			deleteStudent(request,response);
		}
	}
	private void deleteStudent(HttpServletRequest request,
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
	// TODO Auto-generated method stub
	String name = request.getParameter("name");
	int id = Integer.parseInt(request.getParameter("id"));
	String sex = request.getParameter("sex");
	String mobile = request.getParameter("mobile");
	String qq = request.getParameter("qq");
	int clazzId = Integer.parseInt(request.getParameter("clazzid"));
	Student student = new Student();
	student.setClazzId(clazzId);
	student.setMobile(mobile);
	student.setName(name);
	student.setId(id);
	student.setQq(qq);
	student.setSex(sex);
	StudentDao studentDao = new StudentDao();
	if(studentDao.editStudent(student)){
		try {
			response.getWriter().write("success");
		} catch (IOException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			studentDao.closeCon();
		}
	}
}
private void getStudentList(HttpServletRequest request,
		HttpServletResponse response) {
	// TODO Auto-generated method stub
	String name = request.getParameter("studentName");
	Integer currentPage = request.getParameter("page") == null ? 1 : Integer.parseInt(request.getParameter("page"));
	Integer pageSize = request.getParameter("rows") == null ? 999 : Integer.parseInt(request.getParameter("rows"));
	Integer clazz = request.getParameter("clazzid") == null ? 0 : Integer.parseInt(request.getParameter("clazzid"));
	//获取当前登录用户类型
	int userType = Integer.parseInt(request.getSession().getAttribute("userType").toString());
	Student student = new Student();
	student.setName(name);
	student.setClazzId(clazz);
	if(userType == 2){
		//如果是学生，只能查看自己的信息
		Student currentUser = (Student)request.getSession().getAttribute("user");
		student.setId(currentUser.getId());
	}
	StudentDao studentDao = new StudentDao();
	List<Student> clazzList = studentDao.getStudentList(student, new Page(currentPage, pageSize));
	int total = studentDao.getStudentListTotal(student);
	studentDao.closeCon();
	response.setCharacterEncoding("UTF-8");
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
				}
			}
		}
		String path = request.getSession().getServletContext().getRealPath("");
		File file = new File(path+"\\file\\logo.jpg");
		try {
			FileInputStream fis = new FileInputStream(file);
			byte[] b = new byte[fis.available()];
			fis.read(b);
			response.getOutputStream().write(b,0,b.length);
			
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
}
package com.ischoolbar.programmer.servlet;

/**
 * 教师信息管理servlet类
 */



public class TeacherServlet extends HttpServlet {

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