Java源码社

基于javaweb的JSP+Servlet学生在线选课系统(管理员、教师、学生)(java+jsp+servlet+mysql)

更新于

运行环境

Java≥8、MySQL≥5.7、Tomcat≥8

开发工具

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

适用

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

功能说明

1
2
3
4
5
6
7
8
内容：源码+数据库脚本+word报告文档


管理员：个人信息、学生、老师、学生、课程等管理

教师：个人信息、成绩、选课管理、教室查看

学生：个人信息、成绩查看、选课和查看

220123102502

210123102502

eclipse或MyEclipse或idea

200123102502

190123102502

管理员

130123102502

140123102502

150123102502

160123102502

170123102502

180123102502

学生

590123092502

000123102502

020123102502

030123102502

040123102502

050123102502

060123102502

教师

070123102502

080123102502

090123102502

100123102502

110123102502

技术框架

CSS JavaScript JSP Servlet JDBC MySQL

基于javaweb的JSP+Servlet学生在线选课系统(管理员、教师、学生)(java+jsp+servlet+mysql)

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
package com.demo.servlet;




/**
 * Servlet implementation class AllStuQueryServlet
 */
@WebServlet("/AllStuQueryServlet")
public class AllStuQueryServlet extends HttpServlet {
	private static final long serialVersionUID = 1L;
       
    /**
     * @see HttpServlet#HttpServlet()
     */
    public AllStuQueryServlet() {
        super();
        // TODO Auto-generated constructor stub
    }

	/**
	 * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
	 */
	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		AdminService adminService=new AdminService();
		List<Student> students=adminService.allstudentQuery();
		request.setAttribute("students", students);
		request.getRequestDispatcher("selstudent.jsp").forward(request, response);
	}

	/**
	 * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
	 */
	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		doGet(request, response);
	}

}
package com.demo.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
		Teacher teacher=new Teacher(tId,tName,tPass,dId,tSex,tAge,tEdu,tTitle,tSch,tHealth);	//封装到实体类
		AdminService adminService=new AdminService();
		boolean result=adminService.addTeacher(teacher);
		//PrintWriter out=response.getWriter();
		/*if(result) {			
			out.println("注册成功！");
			response.sendRedirect("StudentQueryAllServlet");
		}
		else {
			out.println("注册失败，该学生已存在，请检查学号是否正确！");
		}*/
		if(!result) {	//注册失败
			request.setAttribute("error", "addError");
		}
		else {	//注册成功
			request.setAttribute("error", "addSuccess");
		}
		request.getRequestDispatcher("addteacher.jsp").forward(request, response);	//StudentQueryAllServlet直接转发给StudentInfoList.jsp,不需要进行处理
	}

	/**
	 * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
	 */
	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		doGet(request, response);
	}

}
package com.demo.servlet;



/**
 * Servlet implementation class CourseAddServlet
 */
@WebServlet("/CourseAddServlet")
public class CourseAddServlet extends HttpServlet {
	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		String cId=request.getParameter("cId");
		String cName=request.getParameter("cName");
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


@WebServlet("/StuCourseDelServlet")
public class StuCourseDelServlet extends HttpServlet {

	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		String sid=request.getParameter("sid");
		String cid=request.getParameter("cid");
		request.setAttribute("sid", sid);	//转发时使用
		StudentService studentService=new StudentService();
		boolean result=studentService.courseDelete(sid,cid);
		if(!result) {	//删除失败
			request.setAttribute("error", "deleteError");
		}
		else {	//删除成功
			request.setAttribute("error", "deleteSuccess");
		}
		request.getRequestDispatcher("StuCourseQueryServlet").forward(request, response);
	}

	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		doGet(request, response);
	}

}
package com.demo.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
		else {	//添加成功
			request.setAttribute("error", "addSuccess");
		}
		request.getRequestDispatcher("StuCourseQueryServlet").forward(request, response);	
	}

	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		doGet(request, response);
	}

}
package com.demo.servlet;




@WebServlet("/StuCourseDelServlet")
public class StuCourseDelServlet extends HttpServlet {

	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		String sid=request.getParameter("sid");
		String cid=request.getParameter("cid");
		request.setAttribute("sid", sid);	//转发时使用
		StudentService studentService=new StudentService();
		boolean result=studentService.courseDelete(sid,cid);
		if(!result) {	//删除失败
			request.setAttribute("error", "deleteError");
		}
		else {	//删除成功
			request.setAttribute("error", "deleteSuccess");
		}
		request.getRequestDispatcher("StuCourseQueryServlet").forward(request, response);
	}

	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		doGet(request, response);
	}

}
package com.demo.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
		}
		else {
			out.println("注册失败，该学生已存在，请检查学号是否正确！");
		}*/
		if(!result) {	//注册失败
			request.setAttribute("error", "addError");
		}
		else {	//注册成功
			request.setAttribute("error", "addSuccess");
		}
		request.getRequestDispatcher("addteacher.jsp").forward(request, response);	//StudentQueryAllServlet直接转发给StudentInfoList.jsp,不需要进行处理
	}

	/**
	 * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
	 */
	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		doGet(request, response);
	}

}
package com.demo.servlet;



/**
 * Servlet implementation class CourseAddServlet
 */
@WebServlet("/CourseAddServlet")
public class CourseAddServlet extends HttpServlet {
	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		String cId=request.getParameter("cId");
		String cName=request.getParameter("cName");
		String tId=request.getParameter("tId");
		String credit=request.getParameter("credit");
		
		String period=request.getParameter("period");
		String cPlace=request.getParameter("cPlace");

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