基于Web的选课系统设计与实现--优秀毕业论文

1毕业论文姓名：班级：系部：专业：论文题目：基于WEB的选课系统设计与实现指导教师：职称：2013年7月学院毕业设计说明书2摘要本论文主要论述的是基于web的选课系统的系统维护模块的设计和实现设计学生选课系统维护模块系统的目的是对选课信息进行管理。学生选课系统维护模块主要完成的是系统管理与维护功能。课题研究过程中，首先对系统管理模块进行了详细的需求分析，经分析得到系统管理模块主要完成如下的功能：用户基本信息，选课信息录入，查看，修改，删除，从而实现能够在线选课，在线添加课程，在线查询课程等功能。系统管理模块是整个系统的指挥中心，保证整个系统在校园网上安全有效的运作。之后跟进需求提出了系统管理模块的总体设计方案。并进行了详细设计和编码实现，系统使用ASP。NET作为开发语言，SQLServer2000作为数据库。代码中通过使用进行中的Session，尽量使用存储过程和尽量减少数据库连接的打开时间等手段来提高性能。论文中对课题的设计和开发进行了完整地论述。系统开发完成后，对课题要求的功能设计出测试用例，进行功能测试，测试结果证明学生选课系统的维护模块实现了对该模块的功能需求，完成了课题的主要任务。关键词：自动化；性能；SQL学院毕业设计说明书3SummaryThisthesisinvestigatestheelectivesystemoftheweb-basedsystemmaintenancemoduledesignanddesignstudentelectivesystemmaintenancemodulesystemiselectiveinformationmanagement.Studentelectivesystemmaintenancemoduleofthecompletionofsystemmanagementandmaintenancefunctions.Theresearchprocess,thesystemmanagementmodule,adetailedneedsanalysis,analysisofsystemmanagementmodulemainlyperformsthefollowingfunctions:basicuserinformation,courseselectioninformationinput,view,modify,deleteinordertoachievethatonlineelectiveaddcoursesonline,onlinequeryfeaturessuchascurriculum.Thesystemmanagementmoduleisthecommandcenterofthewholesystem,toensurethesafeandeffectiveoperationoftheentiresysteminthecampusnetwork.Afterfollow-updemandfortheoveralldesignofthesystemmanagementmodule.AnddetaileddesignandcodingsystemtouseASP.NETasadevelopmentlanguage,theSQLServer2000asdatabase.ByusingthecodeintheSession,tomakeuseofstoredproceduresandtominimizethedatabaseconnectionopentimemeanstoimproveperformance.Thepaperintegrityofthedesignanddevelopmentofthesubject.Systemdevelopmentiscompleted,thesubjectofthefunctionaldesignrequirementsofthetestcasesforfunctionaltesting,testresultsprovethattheclassselectionsystemmaintenancemoduletoachievethefunctionalrequirementsofthemodule,completingthemaintaskofthesubject.Keywords:automation;performance;SQL学院毕业设计说明书4目录1引言.......................................................................................................................................................41.1C/S结构.......................................................................................................................................41.2B/S结构.......................................................................................................................................51.3B/S结构与C/S结构的分析比较................................................................................................61.3.1硬件环境不同...........................................................................................................................61.3.2结构不同...................................................................................................................................61.3.3处理模式不同..........................................................................................................................61.3.4构件重用不同..........................................................................................................................61.3.5系统维护不同..........................................................................................................................72开发工具介绍.......................................................................................................................................82.1ASP.NET简介...............................................................................................................................82.2SQLSQRVER简介...........................................................................................................................93系统概述.............................................................................................................................................103.1系统开发的目标.........................................................................................................................103.2系统需求.....................................................................................................................................103.2.1可行性分析.............................................................................................................................103.3数据库的设计.............................................................................................................................113.3.1数据库系统分析.....................................................................................................................113.3.2数据库逻辑设计.....................................................................................................................153.3.3数据库物理实现.....................................................................................................................163.4系统的实现.................................................................................................................................183.4.1通用操作.................................................................................................................................193.4.2用户所具有功能...........................................................................................................