摘 要

随着教育体制的改革，学生可以根据自己的喜好选择课程。一方面，学生可以重点发展自己的兴趣爱好，以及根据自己的专业特长去选修自己想要学习的课程；另一方面，大量学生进行选课活动也带来了一系列的问题。课程的预设、学生选课结果的统计，以及如何协调课程开班的人数等等。人工选课无疑将消耗大量的时间与精力，并且不能保证选课结果的准确性。是以，建立一个高效、稳固的网上选课系统是我们的不二选择。

网上选课系统应该实现学生对于课程的选择、查询、删除以及查看个人信息等操作；教师对于课程的增加、删除、查询、修改、学生课程的评分以及查看个人信息等操作；管理员对于学生、老师、课程的管理，以及管理员的增删改查等操作。系统采用B/S模式，方便用户的使用；采用mybatis加springMVC的框架，使系统具有更好的安全性和可扩展性；使用mySQL作为数据库。本系统的实现将提高选课的效率，保证选课结果的准确性，简化选课的流程，减轻教务人员的负担。

关键词：网上选课；MySQL；springMVC；B/S

The design and implementation of online course selection system

ABSTRACT

As the reform of education system, students can choose courses according to his be fond of. On the one hand, students can focus on developing their own interests and hobbies, and according to their own expertise to courses you want to learn the course; On the other hand, a large number of students choose courses activity brings a series of problems. Course of presupposition, student course selection results of statistics, and how to coordinate the number of course class and so on. Artificial selection will consume large amounts of time and effort, and can't guarantee the course selection on the accuracy of the results. 窗体顶端

窗体底端

Is, to establish a highly efficient and stable online course selection system is our choice.

Students online course selection system should be implemented for course selection, query, delete and view personal information such as operation; Teachers for the curriculum of the increase, delete, query, modify, student course ratings and view personal information such as operation; Administrators for students, teachers, curriculum management, and administrators to add and delete operations. System adopts B/S mode, easy of use; The mybatis for springMVC framework, security and scalability of the system has better; Using mySQL as the database. The implementation of this system will improve the efficiency of course selection, ensure the accuracy of the course selection result, simplify the process of course selection, reduce the burden of educational administration personnel.

Key words：online course selection；MySQL；springMVC；B/S

目 录

1 绪论………………………………………………………………………………………………………1

1.1 项目开发背景……………………………………………………………………………………1

1.2 项目开发的目标…………………………………………………………………………………1

1.3 项目提出的意义…………………………………………………………………………………1

1.4 系统开发所用的技术准备………………………………………………………………………2

1.4.1 数据库技术的现状与发展………………………………………………………………2

1.4.2 JAVA语言的概述…………………………………………………………………………2

1.4.3 编码………………………………………………………………………………………3

2 系统需求…………………………………………………………………………………………………4

2.1 系统调查…………………………………………………………………………………………4

2.2 系统构架…………………………………………………………………………………………4

2.3 用户需求…………………………………………………………………………………………4

2.2.1 学生的需求………………………………………………………………………………4

2.2.2 老师的需求………………………………………………………………………………5

2.2.3 管理员的需求……………………………………………………………………………5

2.4 系统方框图………………………………………………………………………………………5

2.5 系统设计思想……………………………………………………………………………………6

2.6 系统设计分析……………………………………………………………………………………6

3 数据库设计………………………………………………………………………………………………7

3.1 数据库表的设计…………………………………………………………………………………7

3.1.1 学生表………………………………………………………………………………………7

3.1.2 老师表………………………………………………………………………………………7

3.1.3 课程表……………………………………………………………………………………8

3.1.4 管理员表…………………………………………………………………………………9

3.1.5 班级表…………………………………………………………………………………9

3.1.6 学生-课程………………………………………………………………………………10

3.2 数据库所使用的技术……………………………………………………………………………10

4 功能介绍…………………………………………………………………………………………………14

4.1 登录………………………………………………………………………………………………14

4.2 管理员模块………………………………………………………………………………………16

4.2.1 学生页面…………………………………………………………………………………17

4.2.2 老师页面…………………………………………………………………………………22

4.2.3 课程页面…………………………………………………………………………………24

4.2.4 管理员页面………………………………………………………………………………25

4.3 老师模块…………………………………………………………………………………………27

4.3.1 课程查询页面……………………………………………………………………………27

4.3.2 分数录入页面……………………………………………………………………………28

4.4 学生模块…………………………………………………………………………………………29

4.4.1 选择课程页面……………………………………………………………………………29

4.4.2 成绩查询页面……………………………………………………………………………30

5 测试…………………………………………………………………………………………………34

5.1 测试目的…………………………………………………………………………………………34

5.2 测试环境的搭建………...............………………………………………………………………34

5.3 测试方法…………………………………………………………………………………………35

5.4 测试项目……...…………………………………………………………………………………35

5.5 测试结果………………........……………………………………………………………………35