I电子选课系统摘要近年来,随着Internet的发展,网络已成为我们生活中不可分割的一部分。现在人们的工作也越来越依靠网络,教育办公也是如此。当前学校的学生数量不断增多,现在学校普遍实行学分制,学生可以任意选课,使得教学信息量几十倍地增加,传统的人工选课系统已经不能适应这种要求。为了提高对教学信息的管理效率,建立一种公平、快速、高效的、符合学分制度的管理平台已经刻不容缓,因此,实行选课系统的网络化势在必行。本文介绍了电子选课系统的体系结构、关键技术和数据库设计。本系统利用.NET结合数据库的技术(ODBC)实现电子选课系统的网络化。系统架构采用现在主流的B/S,即Browser/Server架构,它的三层结构为:应用层(客户端浏览器)-业务逻辑层(WebServer)-数据层(数据库服务器)。这种结构不仅能更好地支持动态网页技术,而且也易于扩展和维护。本系统简单易用,可以方便老师和学生的选课。它可以实现教师和学生的信息查询、修改,网上选课的功能,可以增加或删除各种教学信息,以及教师和学生帐户。同时,本系统也增加了许多专门应付用户的误操作的代码,对用户的操作进行引导,以提高系统的安全性和健壮性。由于本系统采用DTO和DAO技术,使得对数据库的操作更加方便,系统层次更加清晰,便于以后对各层代码的修改和添加,增强了系统的可扩展性。关键词:选课;B/S;DTO;DAO;教学;数据库;业务逻辑IIELETRONICELECTIVESYSTEMABSTRACTIONGInrecentyears,withthepopularizationofInternet,networkhasbecomeanindispensableparttoourlife.Owingtothereal-time,sharingandinteractionoftheInternet,thedailywoksaremoreandmoredependentonthenetincludingtheeducationofficebusinesswork.Becauseoftheamountofstudentsincreases,CreditHourSystemCarriesoutincolleges,andtheacademiciancanselectcourseatwill,teachinginformationcontentincreasesasseveraltimesandthetraditionalelectivesystemcan’tmeetit.Toimprovethemanagementoftheteachinginformation,wehavenotimetodelaytoestablishakindofelectivesystemthatisequitable,speedy,fitforcredithoursystem.Thispaperintroducesthearchitecture,keytechnologyanddatabasedesignoftheelectronicelectivesystem.Thissystemisanetworkelectronicelectivesystemwith.Netintegratingdatabasetechnology.Thesystem’sarchitectureistheB/S,whichisalsocalledasBrowser/Serverthatisthemainstreamnowadays.Itstriplexlayersare:ApplicationLayer(ClientBrowser),OperationLogicLayer(WebServer),andDataLayer(DatabaseLayer).ThistechnologycanalsosupporttheActivePagesTechnology,butpronetoexpandandmaintenance.Thissystemissimplicityandeasytouseandconvenienttoelectivesforteachersandstudents.Itcanimplementtheteachersandstudentsinformationsearching,alteringandelectiveonnetfunctions,andaddordeleteallkindsofteachinginformationandaccountsforteachersandstudents.Thissystemalsoincludesmanycodesthatarespeciallyusedtodealwiththeuser’sdisoperationandtoguidetheusersoperations.Thesecodeshaveboostedthesystem’ssafenessandhaleness.BecauseofadaptingtheDAO(DataAccessObject)andDTO(DataTransferObject)technology,itisconvenienttooperateonthedatabaseandthesystemarrangementismoreinfocus.Itisconvenienttoaltercodelatter,andthesystem’sextensibilityhasbeenenhanced.KEYWORD:elective;DAO;DTO;teaching;database;operationlogicIII目录摘要..................................................................IABSTRACTIONG.........................................................II目录................................................................III1前言................................................................11.1电子选课系统概述................................................11.1.1传统的选课模式和现在的电子选课系统..........................11.2电子选课系统的一般需求..........................................21.2.1功能需求....................................................21.2.2性能需求....................................................31.3本课题目标......................................................31.4系统的优点......................................................32可行性分析..........................................................42.1课题调研........................................................42.2可行性分析......................................................43系统需求分析........................................................53.1系统的模型......................................................53.1.1功能分析....................................................53.1.2系统架构....................................................63.2集成开发环境....................................................63.2.1硬件.........................................................63.2.2软件........................................................73.2.3开发工具分析................................................73.2.4数据库的选择................................................84系统设计............................................................84.1功能模块设计....................................................84.1.1登陆模块设计...............................................114.1.2学生管理模块...............................................11IV4.1.3教师管理模块...............................................114.1.4管理员管理模块.............................................124.1.5选课信息管理模块...........................................124.2数据库设计.....................................................134.2.1对象关系图..................................................134.2.2数据库设计.................................................154.3开发方法.......................................................174.3.1数据库访问.................................................174.3.2界面友好性.................................................204.3.3系统安全性.................................................205系统实现...........................................................205.1开发环境搭建...................................................205.1.1软件安装...................................................205.1.2IIS5.1配置................................................205.1.3数据库的设计...............................................