摘要：随着计算机技术在教育行业的广泛应用，近年来，所有大学的校园网络都在飞速发展，办学模式的多元化，学校教师人数及学生人数不断增加，在线课程选课系统可以随时随地选择任何课程，还以提高教学管理的效率和质量。为了实现人数及课程的科学管理，学生利用信息和网络技术，建立安全高效的选课制度，学生们还可以根据自己的喜好和课程要求来选择自己喜欢的课程。

学生选课系统是为了改变学校传统的排课选课制度。因为Java是一种简单，面向对象，分布式，安全可靠，高性能，多线程的动态语言，因此根据这些特点使用Java语言编写学生选课系统的各种功能。主要使用JSP编写前台界面，用Java编写后台的功能代码，使用MySQL数据库完成数据的存储和记录，在编译过程中使用Tomcat完成服务器的操作，通过分析学校管理的需求，完成一个完整的选课系统。

在本文中，详细地解释了各功能模块接口系统的实现方法、每个界面各个模块与数据库设计，文末总结开发系统时遇到的困难以及解决方法。

关键词：选课系统；Java；JSP；MySQL；Tomcat

Abstract：With the wide spread of computer technology in the education industry, in recent years, the networks of all universities are developing rapidly. Hence, it leads to the perse patterns of running a school and the increasing number of teachers and students. Besides that, students can choose any course anytime by online course elective system. Moreover, it can improve the efficiency and quality of teaching management. In order to achieve scientific management of the number of students and curriculum, the students use information and network technology to build a safe and efficient elective system. Students can also choose their courses according to their own preferences and curriculum requirements.

The student elective system is to change the traditional school elective course system. Because Java is a simple, targeted, distributed, safe and reliable, high-performance, and multi-threaded dynamic language, students use the Java language to program the various functions of the elective system according to these features. Students prepared front office interface mainly using JSP and background functional code using Java. What’s more, the use of MySQL database is to complete storage and records of the data. In the process of compiling, students use Tomcat to complete the operation of server. Through the analysis of needs of university management, they finish a complete elective system.

In this paper, the author shows a detailed explanation of implementation methods of the various front functional modules interface system and the front interface of each module and the background database design. At the end of the paper, the author summaries the difficulties and solutions during the development of the system.

Keywords: subject system；Java；JSP；MySQL；Tomcat

目录

摘要 I

Abstract II

第一章绪论 1

1.1课题的研究背景与意义 1

1.2国内外现状 2

1.3选课系统目的 3

1.4论文各章介绍 3

1.5本章小结 4

第二章相关理论与关键技术 5

2.1开发语言 5

2.2开发工具 6

2.2.1Myeclipse10 6

2.2.2数据库MySQL+SQLyog 6

2.2.3Web服务器Tomcat 7

2.3本章小结 7

第三章系统需求及设计 8

3.1系统需求分析 8

3.1.1系统总体需求 8

3.1.2功能模块需求 8

3.2系统设计 8

3.2.1系统首页与登录模块 9

3.2.2个人信息管理模块 9

3.2.3课程管理及班级管理模块 10

3.2.4教师模块 10

3.2.5学生模块 10

3.3本章小结 10

第四章数据库设计与说明 11

4.1数据库的分析 11

4.2数据库概念结构设计 12

4.3数据库逻辑结构设计 13

4.4数据库中的表关系 15