——————————DescriptionStart——————————
运行环境
Java≥8、MySQL≥5.7、Tomcat≥8
开发工具
eclipse/idea/myeclipse/sts等均可配置运行
适用
课程设计，大作业，毕业设计，项目练习，学习演示等
功能说明
基于javaweb的JSP+Servlet教务处学生成绩管理系统(java+jsp+bootstrap+servlet+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.数据库：MySql 5.7版本； 6.是否Maven项目：否；
技术栈
JSP+CSS+JavaScript+jquery+bootstrap+servlet+mysql
使用说明
- 使用Navicat或者其它工具，在mysql中创建对应名称的数据库，并导入项目的sql文件； 2. 使用IDEA/Eclipse/MyEclipse导入项目，Eclipse/MyEclipse导入时，若为maven项目请选择maven; 若为maven项目，导入成功后请执行maven clean;maven install命令，然后运行； 3. 将项目中dbconfig.properties配置文件中的数据库配置改为自己的配置; 4. 运行项目，输入http://localhost:8080/ 登录 管理员账号/密码：admin/admin 教师账号/密码： 20194101/123456 学生账号/密码： 202041404237/123456
——————————CodeStart——————————
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
| String pageNum = request.getParameter("pageNum");
Page page = service.findStudentsRecords(pageNum);
request.setAttribute("page", page);
request.getRequestDispatcher("/WEB-INF/admin_main.jsp")
.forward(request, response);
return;
}
String sno = request.getParameter("sno");
session.setAttribute("CONTROL_REFRESH", tokenStr);
boolean flag = service.deleteStudent(sno);
if (flag) {
request.setAttribute("message",
} else {
request.setAttribute("message",
}
String pageNum = request.getParameter("pageNum");
Page page = service.findStudentsRecords(pageNum);
request.setAttribute("page", page);
page.setUrl("/LoginServlet");
request.getRequestDispatcher("/WEB-INF/admin_main.jsp").forward(request,
response);
}
}
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
doGet(request, response);
}
}
package com.dgut.sc.controler;
|
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
|
public class AddTeaServlet extends HttpServlet {
private BusinessService service = new BusinessServiceImpl();
private static final long serialVersionUID = 1L;
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
request.setCharacterEncoding("utf-8");
response.setContentType("text/jsp;charset=utf-8");
response.setCharacterEncoding("utf-8");
Admin admin = (Admin) request.getSession().getAttribute("admin");
if (admin == null) {
request.setAttribute("message",
request.getRequestDispatcher("/index.jsp").forward(request,
response);
return;
} else {
String timeStamp = String.valueOf(new java.util.Date().getTime());
HttpSession session = request.getSession();
String tokenStr = session.getId() + timeStamp;
session.setAttribute("CONTROL_REFRESH", tokenStr);
String tno = request.getParameter("tno");
String tname = request.getParameter("tname");
String sex = request.getParameter("sex");
String password = request.getParameter("password");
String degree = request.getParameter("degree");
String department = request.getParameter("department");
String title = request.getParameter("title");
Teacher teacher = new Teacher(tno, tname, password, sex, department, degree, title);
boolean flag = false;
if (tname != null && tno != null && sex != null && password != null
&& department != null && degree != null && title != null) {
flag = service.addTeacher(teacher);
if (flag) {
request.setAttribute("message",
}else{
request.setAttribute("message",
}
|
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
| return;
}
request.getSession().setAttribute("admin", admin);
String timeStamp = String.valueOf(new java.util.Date().getTime());
HttpSession session = request.getSession();
String tokenStr = session.getId() + timeStamp;
session.setAttribute("CONTROL_REFRESH", tokenStr);
String pageNum = request.getParameter("pageNum");
Page page = service.findStudentsRecords(pageNum);
page.setUrl("/LoginServlet");
request.setAttribute("page", page);
request.getRequestDispatcher("/WEB-INF/admin_main.jsp")
.forward(request, response);
} else if ("教师".equals(type)) {
String username = request.getParameter("username");
String password = request.getParameter("password");
teacher = service.queryTeacher(username);
if (teacher == null) {
request.setAttribute("message",
request.getRequestDispatcher("/index.jsp").forward(request,
response);
return;
}
teacher = service.queryTeacher(username,password);
if (teacher == null) {
request.setAttribute("message",
request.getRequestDispatcher("/index.jsp").forward(request,
response);
return;
}
request.getSession().setAttribute("teacher", teacher);
String timeStamp = String.valueOf(new java.util.Date().getTime());
HttpSession session = request.getSession();
String tokenStr = session.getId() + timeStamp;
|
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
|
public class AddCourseServlet extends HttpServlet {
private BusinessService service = new BusinessServiceImpl();
private static final long serialVersionUID = 1L;
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
request.setCharacterEncoding("utf-8");
response.setContentType("text/jsp;charset=utf-8");
response.setCharacterEncoding("utf-8");
Admin admin = (Admin) request.getSession().getAttribute("admin");
if (admin == null) {
request.setAttribute("message",
request.getRequestDispatcher("/index.jsp").forward(request,
response);
return;
} else {
String timeStamp = String.valueOf(new java.util.Date().getTime());
HttpSession session = request.getSession();
String tokenStr = session.getId() + timeStamp;
session.setAttribute("CONTROL_REFRESH", tokenStr);
String tno = request.getParameter("tno");
String tname = request.getParameter("tname");
String cno = request.getParameter("cno");
String cname = request.getParameter("cname");
String credit = request.getParameter("credit");
boolean flag = false;
if (tname != null && tno != null && cno != null && cname != null
&& credit != null) {
Course course = new Course(cno, cname, tno, tname, credit);
flag = service.addCourse(course);
if (flag) {
request.setAttribute("message",
} else {
request.setAttribute("message",
|
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
| String GPA = request.getParameter("GPA");
String credit_GPA = request.getParameter("credit_GPA");
if (sno != null && grade != null && cno != null
&& get_credit != null && GPA != null && credit_GPA != null) {
boolean flag = service.updateScore(sno, cno, grade, get_credit,
GPA, credit_GPA);
if (flag) {
request.setAttribute("message",
} else {
request.setAttribute("message",
}
String pageNum = request.getParameter("pageNum");
Page page = service.findScoresRecordsByTno(teacher.getTno(),
pageNum);
page.setUrl("/LoginServlet");
request.setAttribute("page", page);
request.getRequestDispatcher("/WEB-INF/teacher_main.jsp")
.forward(request, response);
}
}
}
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
doGet(request, response);
}
}
package com.dgut.sc.controler;
public class UpdateStuServlet extends HttpServlet {
|
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
| if (!newPwd.equals(newPwdAgain)) {
request.setAttribute("message",
request.getRequestDispatcher("/update_stu_pwd.jsp")
.forward(request, response);
} else {
boolean flag = service.updateStudentPwd(student.getSno(), newPwd);
if (flag) {
request.setAttribute("message",
request.getSession().invalidate();
request.getRequestDispatcher("/index.jsp").forward(
request, response);
}
}
}
}
}
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
doGet(request, response);
}
}
package com.dgut.sc.controler;
public class UpdateTeaPwdServlet extends HttpServlet {
private BusinessService service = new BusinessServiceImpl();
private static final long serialVersionUID = 1L;
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
request.setCharacterEncoding("utf-8");
response.setContentType("text/jsp;charset=utf-8");
response.setCharacterEncoding("utf-8");
Teacher teacher = (Teacher) request.getSession().getAttribute("teacher");
if (teacher == null) {
|
——————————PayStart——————————
项目链接：
https://javayms.github.io?id=571122522008200pn
https://javayms.pages.dev?id=571122522008200pn