基于javaweb+JSP+Servlet学生成绩管理系统(管理员、教师、学生)_java web学生成绩管理系统文档

基于javaweb+JSP+Servlet学生成绩管理系统(管理员、教师、学生)

开发工具：eclipse/idea/myeclipse/sts等均可配置运行

适用

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

				+ score.getStuName()
				+ "%' and score.stu_class like '%"
				+ score.getStuClass()
				+ "%' and score.stu_num like '%"
				+ score.getStuNum()
				+ "'";
		ResultSet rs = dbCon.find(sql);
		try {
			while (rs.next()) {
				int scoreID = rs.getInt("score_id");
				String stuNum = rs.getString("stu_num");
				String stuName = rs.getString("stu_name");
				String stuClass = rs.getString("stu_class");
				String courseName = rs.getString("course_name");
				double scoreGrade = rs.getDouble("score_grade");
				String major = rs.getString("major");
				score = new Score(scoreID, stuNum, stuName, stuClass,
						courseName, scoreGrade, major);
				list.add(score);
			}
			rs = dbCon.find(sqlCount);
			while (rs.next()) {
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22

				xmlHttpRequest.send();
				xmlHttpRequest.onreadystatechange=function(){
					if(xmlHttpRequest.readyState==4 && xmlHttpRequest.status==200){
						var text = xmlHttpRequest.responseText;
						//alert(text);
						document.getElementById("stuNumcheck").innerHTML = text;
					}
				};
			}
		}
	}
	
	function namecheck(){
		var stuName=document.getElementById("stuName").value;
		var rename=/^[\u4e00-\u9fa5]+$/gi;          //中文判断
		if(stuName==""){
			document.getElementById("stuNamecheck").innerHTML = "用户名不能为空";
		}
		else if (!rename.test(stuName))
		{
			document.getElementById("stuNamecheck").innerHTML = "请输入中文名，如：王文军";
		}else{
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22

					// 4、使用ServletFileUpload解析器解析上传数据，解析结果返回的是一个List<FileItem>集合，
					// 每一个FileItem对应一个Form表单的输入项

				
					List<FileItem> list = upLoad.parseRequest(request);
					// List<FileItem> list=upLoad.parseRequest(request);
					// 如果fileitem中封装的是普通输入项的数据
					for (FileItem item : list) {
						if (item.isFormField()) {
							String name = item.getFieldName();
							/*// 解决普通输入项的数据中文乱码
							String value = item.getString("utf-8");
							System.out.println(name + "=" + value);*/
						} else {
							// 吐过fileitem中封装的是上传文件
							// 得到上传的文件名称
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16

import model.Course;
import model.PageBean;
import dao.CourseDao;
import db.DBCon;

public class CourseDaoImpl implements CourseDao {

	private DBCon dbCon = new DBCon();
	private Course course;
	private PageBean pageBean;

	public int addCos(Course course, String courseDate) {
		System.out.println(courseDate);
		// Date courseDate=(Date) course.getCourseDate();
		// DateFormat
		// data=DateFormat.getDateTimeInstance(DateFormat.MEDIUM,DateFormat.MEDIUM);
		String sql = "insert into course(course_name,course_credit,course_hours,course_teacher,coursedate) values('"
				+ course.getCourseName()
				+ "',"
				+ course.getCourseCredit()
				+ ","
				+ course.getCourseHours()
				+ ",'"
				+ course.getCourseTeacher() + "',DATE('" + courseDate + "'))";
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24

			while (rs.next()) {
				int scoreid = rs.getInt("score_id");
				String stuNum = rs.getString("stu_num");
				String stuName = rs.getString("stu_name");
				String stuClass = rs.getString("stu_class");
				String courseName = rs.getString("course_name");
				double scoreGrade = rs.getDouble("score_grade");
				String major = rs.getString("major");
				Score score = new Score(scoreid, stuNum, stuName, stuClass,
						courseName, scoreGrade, major);
				list.add(score);
			}
		} catch (SQLException e) {

			e.printStackTrace();
		}
		return list;
	}
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18

			margin-left: 15px;
			margin-right: 15px;
			background: #ccc;
		}
		.btn1{
			background: #afc5d6;
		}
		font{
			font-size: .7rem;
			float: left;
		}
	</style>


<link rel="stylesheet" href="https://cdn.bootcss.com/bootstrap/4.0.0/css/bootstrap.min.css" integrity="sha384-Gn5384xqQ1aoWXA+058RXPxPg6fy4IWvTNh0E263XmFcJlSAwiGgFAW/dAiS6JXm" crossorigin="anonymous">
<script src="js/jquery-3.3.1.min.js"></script>
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16

<%
	String path = request.getContextPath();
	String basePath = request.getScheme() + "://"
			+ request.getServerName() + ":" + request.getServerPort()
			+ path + "/";
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">

<title>教师界面</title>

<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<link rel="stylesheet" href="css/bootstrap.min.css">
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19

<p>Severity: Notice</p>
<p>Message:  Trying to get property of non-object</p>
<p>Filename: views/demo.php</p>
<p>Line Number: 40</p>

</div>" class="btn btn-primary btn-small"><span class="iconfa-shopping-cart"></span> Purchase Theme</a>
            <a href="_div style="border:1px solid #990000;padding-left:20px;margin:0 0 10px 0;">

<h4>A PHP Error was encountered</h4>

<p>Severity: Notice</p>
<p>Message:  Trying to get property of non-object</p>
<p>Filename: views/demo.php</p>
<p>Line Number: 41</p>

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16

						teaCourse, major, department);
				list.add(teacher);
			}
			rs=dbCon.find(sqlCount);
			while(rs.next()){
				totalCount=rs.getInt(1);
			}
		} catch (SQLException e) {
			dbCon.close();
			e.printStackTrace();
		}
		pageBean=new PageBean(list,totalCount,pageNo,pageCount);
		return pageBean;
	}

}
package servlet;

import java.io.File;
import java.io.FileInputStream;
import java.io.IOException;
import java.io.OutputStream;
import java.net.URLEncoder;

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24

		} catch (SQLException e) {

			e.printStackTrace();
		}
		return course;
	}

	public PageBean courseListPage(int pageNo, int pageCount) {
		int totalCount=0;
		List<Course> list = new ArrayList<Course>();
		String sql = "select * from course limit "+((pageNo-1)*pageCount)+","+pageCount;
		String sqlCount="select count(*) from course";
1
2
3
4
5
6
7
8
9
10
11
12
13

				user = new User(userID, userNum, userName, pwd, phone, roleID);
			}

		} catch (SQLException e) {

			e.printStackTrace();
		}
		return user;
	}

	public int editPwd(User user) {
		String sql = "update user set password='" + user.getPassword()
				+ "' where user_num='" + user.getUserNum() + "'";
		int rs = dbCon.query(sql);
		return rs;
	}

	public int addUser(User user) {
		String sql = "insert into user(user_num,user_name,password,phone,role_id) values('"
				+ user.getUserNum()
				+ "','"
				+ user.getUserName()
				+ "','"
				+ user.getPassword()
				+ "',"
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

---

运行环境

Java≥8、Tomcat≥8.0、MySQL≥5.7

开发工具

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

技术框架

JSP Servlet MySQL JDBC Tomcat CSS JavaScript bootstrap jquery

适用

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

功能说明

管理员：个人信息、课程管理、成绩管理、教师管理、学生管理

教师：个人信息、课程管理、成绩管理、学生信息查看

学生：人个信息管理、成绩查询

管理员

教师

学生

---