网上选课系统论文.doc

摘 要 随着在校大学生人数的不断增加，教务系统的数据量也不断的上涨。以往的选课方法是随堂报名。这种方法虽然直接，但是造成选课的盲目性和教务处处理数据的繁重性。为了减轻教务处工作，以及每个学生更好的选择自己所喜欢的科目。针对学生选课这一环节，本系统从学生模块、教师模块以及管理员模块三个大方面进行了设计，基本实现了学生的在线信息查询、选课功能以及管理员对系统的整体管理和课程信息发布的管理等功能。 本文通过分析浏览器/服务器架构的特点并结合选课的实际情况，提出了基于浏览器/服务器架构网上选课系统的基本设计思想，简要介绍了系统各功能模块，着重讨论了数据库的设计及用 ASP.NET技术和SQL Server 2008开发网上选课系统时的数据库访问技术和动态网页制作技术,并给出了部分实现代码。通过该系统，使学生可以方便地在校园网上进行网上选课。该B/S架构的系统在Windows XP/Windows 7系统和VS.NET平台下开发完成，使用C＃作为ASP.NET的开发语言，SQL Server 2008作为数据库。系统有较高的安全性和较好的性能。其中连接数据库的字符串在web.config文件中参数化配置，增加了灵活性，并经过编码加密，，提高了数据库的安全性。代码尽量使用存储过程和尽量减少数据库连接的打开时间等手段来提高性能。 网上选课在全球高校已趋向普遍，网上选课系统也会在不断的实际应用中得到更多机会的发展和完善。相信系统以后会向着更加完善、更加高效、更加简洁和更加人性化的方向发展。 关键词：网上选课，浏览器/服务器，ASP.NET,数据库管理系统ABSTRACT With the increase of the enrolling number, the data for daily registry is increasing, too. As usual we should go to classroom to enroll. Although the method is simple, but result in blindness of the course enrollment and the heavy of registry data processing. In order to reduce the work of registry ,and for each student to choose their own favorite subjects better. The system included three modules : student module, teacher module as well as system manager module. It realized students on-line information inquiry, choose class function as well as systems whole management and curriculum information issue functions and so on. This paper showed the basic design ideas of the Browser/Server architecture based on online course selection system by analyzing the characteristic of the Browser/Server architecture and combining with the actual public elective courses conditions of our school．It introduced the function module and database design briefly，followed by a discussion on database accessing technology and the active page technology of the course select system based on ASP.NET and SQL Server 2008．By using this system，students could select courses online efficiently．This Browser/Server architecture system was developed in VS.NET platform in Windows XP ?operating system, using C# as