Abstract

The course management of the students is an important part of the teaching management, it is the organization and management of the daily teaching work, and it is the basic work of the educational administration department to carry out the teaching management. In general terms, the administration of the educational administration mainly includes the management of the examination affairs, the management of the students’ nationality, the grade of the course, the course selection on the internet, etc. The course management system, as a sub-system of the educational administration management system, is mainly to provide related operations such as students, teachers or visitors, so that the information management of the students can be standardized. The corresponding operations of the functional blocks are implemented by their respective sub-modules, respectively. The student information of the whole school is collected through the education network or the Internet and is a school The competent education department shall provide comprehensive and timely information for students and convenient management, and can also extend all kinds of information applications through the campus network, and share the information of the students. Through a simplified curriculum management system, the school can systematize, standardize and automate the course management, so as to achieve the purpose of improving the management efficiency of the course.

This paper is based on the design and implementation of the web-based curriculum management system, which is developed in order to meet the demand management of the school information. The platform is the B/ S mode, the application of web as the development technology, and the application of SQL Server 2008 to develop the student module of the student’s course management system; the paper first expounds the development of the student’s course management system, The system needs to be analyzed in detail, then the design scheme of the system needs to be realized, including the following functions: to apply for elective courses, to abandon the optional courses, to view optional courses and letters, to view the selected courses, to check out the non-selected courses, and to give up No courses are selected, personal information is modified, and functional modules such as the scores of the teachers are viewed.

Keywords: student’s course; student module; JSP; database

目  录

摘  要 I

Abstract II

1 绪论 1

1.1 课题背景 1

1.2 本课题研究的意义 2

1.3 主要研究内容 3

2 开发环境与相关技术 4

2.1 JSP技术 4

2.1.1 JAVA简介 4

2.1.2 JSP简介 4

2.1.3 SSH2框架介绍 5

2.2 Myeclipse介绍 6

2.3 SQL2008 数据库 7

2.4 Browser/Server（B/S）结构 7

2.5系统开发平台及运行环境 8

2.5.1系统开发平台 8

2.5.2运行环境 8

3 系统需求分析及设计 9

3.1 需求分析 9

3.1.1学生功能分析 9

3.1.2老师功能分析 10

3.1.3管理员功能分析 10

3.2 系统设计 12

3.2.1 系统功能 12

3.2.2 系统结构 12

3.3 数据库设计 13

3.3.1数据库需求分析及E-R图 13

3.3.2数据库物理表结构设计 14

4 系统实现 16

4.1学生板块功能实现 16

4.1.1登录界面 16

4.1.2 学生登录主界面 16

4..3 我的选修课 17

4.1.4 课程申请 17

4.1.5对教师评分 18

4.2老师板块的实现 18

4.2.1 教师模块主界面 18

4.2.2 课程管理 19

4.2.3课程添加 19

4.2.4学生选修课 20

4.2.5成绩录入 20

4.3管理员板块的实现 21

4.3.1登录界面 21

4.3.2主界面 21

4.3.3用户管理 22

4.3.4学生管理 22

4.3.5用户添加 23

5 系统测试 24

5.1 前台测试 24

5.2 后台测试 24

5.3测试分析 25

结  论 26

参考文献 27

致  谢 28