网上选课系统的数据库和动态网页制作技术 毕业论文.doc

摘要 关键词：ABSTRACT There are many public elective courses during university period, and always we should goto classroom to enroll. Although this method directly, but result in blindness of the course enrollment. Some classrooms overcrowding during course choosing period, on the contrary some classrooms desolate. The reason of this situation is that the traditional method of course choosing lack prescience, and there are no prior coordination. With the help of public elective courses online course elect system, every students’ courses can be determined before the beginning of the term, saving physical force and reasonably distributing teaching resources.This B/S structure system is developed under VS.NET platform in Windows XP operating system, using C# as ASP.NET development language and SQL Server 2000 as the database. This system is of higher security and better performance. The character string, which is used to connecting to the database, can be modified at any time in the file “ web.config”. The string is encoded and encrypted, increasing flexibility of the system and security of the database. In code, through using the Session in process, making use of stored procedure and minimizing the database opening time to improve performance of the system.This paper gives the basic design idea of the B/S—based online course elect system by analyzing the characteristic of the B/S structure and combining with the actual public elective courses conditions of our school．It introduces the function module and database design briefly，followed by a discussion on database accessing technology and the active page technology of the course elect system based on ASP.NET and SQL Server 2000．By using this system，students can elect courses online efficiently． Keywords: online course elect; B/S structure; DBMS; stored procedure 目 录 绪 论 1 课题背景 1 课题研究的目的和意义 1 国内外概况 1 Browser／Server结构 2 ASP.NET和ADO.NET 2 本文的工作 4 第一章 需求分析 5 1.1 系统简介 5 1.2 系统运行环境 5 1.2.1 硬件平台 5 1.2.2 操作系统 5 1.2.3 应用软