学生网上选课系统毕业论文.doc

学生网上选课系统毕业论文

摘 要

随着在校大学生的不断增加，学生选课系统也是学校对学生管理中不可缺少的一部分。以往的选课方法是使用人工的方法管理文件档案，这种管理方式存在许多的缺点：效率低、保密差，另外时间一长，将产生大量的文件和数据，这对于查找、更新和维护都带来不少的困难。随着科学技术的不断提高，计算机已经进入人类社会的各个领域并发挥着越来越重要的作用。作为计算机应用的一部分，实用技术绝对选课信息进行管理，具有手工管理所无法比拟的优点。例如：查找方便、可靠性高、存储量大、保密性好、寿命长、成本低等。
本文通过分析浏览器/服务器结构的特点并结合选课的实际情况简单的介绍了系统各功能模块及数据库的设计，着重讨论了用ASP.NET技术和SQL Server 2005 开发选课系统的数据库的访问技术和动态网页制作技术，并给出了一些可以实现的核心代码。通过该系统，使学生可以很方便的在校园网上进行网上选课。该系统在Windows XP系统和VS2005平台下开发完成，使用C#作为ASP.NET的开发语言，SQL Server 2005作为数据库。系统有较高的安全性和较好的性能。其中连接数据库的字符串可以随时在web.config里修改。代码尽量使用了存储过程和尽量减少了数据库连接打开的时间来提高性能。
本文除了有对程序的系统分析、总体设计、数据库设计、功能实现等主体部分外，还介绍了ASP.NET和数据库的结合的基本内容。
关键词：学生选课、 浏览器/服务器、 ASP.NET、VS 2005、 SQL Server 2005数据管理系统

Abstract

With the continuous increase in college students, students in schools of students elective system is also an integral part of management. Previous elective method is to use artificial methods to manage file archives, this management approach has many disadvantages: low efficiency, poor security, while over time, will generate a large number of documents and data, which for finding, updating and maintenance of bring a lot of difficulties. With the continuous improvement of science and technology, the computer has access to all areas of human society, and play an increasingly important role. As a part of computer applications and practical management of information technology is absolutely elective, with manual management incomparable advantages. For example: to find convenient, high reliability, large memory capacity, security and good, long life and low cost.
This paper analyzes the browser / server structure is characterized by combining the actual situation of elective a brief introduction of the system of functional modules and database design, focused on using ASP.NET technology and SQL Server 2005 Developer elective system, access to the database technology and dynamic web production techniques, and give some of the core code can be achieved. Through the system so that students can easily online Online Course on campus. The system is Windows XP system and VS2005 platform is developed using C # as the ASP.NET development language, SQL Server 2005 as a database. System has a higher security and better performance. In which the database connection string in the web.config where you can change at any time. The code to make use of the stored procedure and to minimize the database connection open time to improve performance.
This addition to the program's system analysis, overall design, database design, function and so the main part of the implementation, but also describes the combination of ASP.NET and database elements.
Keywords: Student elective, browser / server, ASP.NET, VS 2005, SQL Server 2005 database management system

目 录
第一章  引言 4
1.1课题研究目的 4
1.2 课题研究的意义 4
第二章  系统分析与总体设计 5
2.1系统分析 5
2.2系统设计构架 5
第三章  数据库的设计和实现 6
3.1数据库需求分析 6
3.2数据库概念结构设计 7
3.3数据表的设计 8
第四章  公共类与公共页面设计 11
4.1 Web.config页面设计 11
4.2 数据库连接操作类—Db类 11
4.3 工具类MyUtility类 12
4.4 错误信息类和错误显示页面 13
第五章 系统说明书 13
5.1系统界面说明 13
5.1.1登录界面 13
5.1.2学生选课界面 14
5.1.3学生查看选课界面 15
5.2系统登录及浏览权限说明 16
第六章  总结 17
参考文献 18
致   谢 19