【正文】 畢 業(yè) 論 文 姓 名： 班 級 ： 系 部： 專 業(yè)： 論文題目： 基于 WEB 的選課系統(tǒng)設(shè)計與實現(xiàn) 指導(dǎo)教師： 職 稱 ： 2020 年 7 月 2 摘要 本論文主要論述的是基于 web 的選課系統(tǒng)的系統(tǒng)維護(hù)模塊的設(shè)計和實現(xiàn)設(shè)計學(xué)生選課系統(tǒng)維護(hù)模塊系統(tǒng)的目的是對選課信息進(jìn)行管理。學(xué)生選課系統(tǒng)維護(hù)模塊主要完成的是系統(tǒng)管理與維護(hù)功能。課題研究過程中，首先對系統(tǒng)管理模塊進(jìn)行了詳細(xì)的需求分析，經(jīng)分析得到系統(tǒng)管理模塊主要完成如下的功能：用戶基本信息，選課信息錄入，查看，修改，刪除，從而實現(xiàn)能夠在線選課，在線添加課程，在線查詢課程等功能。系統(tǒng)管理模塊是整個系統(tǒng)的指揮中心，保證整個系統(tǒng)在校園網(wǎng)上安全有效的運作。之后跟進(jìn)需求提出了系統(tǒng)管理模塊的總體 設(shè)計方案。并進(jìn)行了詳細(xì)設(shè)計和編碼實現(xiàn)，系統(tǒng)使用 ASP。 NET 作為開發(fā)語言， SQL Server 2020 作為數(shù)據(jù)庫。代碼中通過使用進(jìn)行中的 Session，盡量使用存儲過程和盡量減少數(shù)據(jù)庫連接的打開時間等手段來提高性能。 論文中對課題的設(shè)計和開發(fā)進(jìn)行了完整地論述。系統(tǒng)開發(fā)完成后，對課題要求的功能設(shè)計出測試用例，進(jìn)行功能測試，測試結(jié)果證明學(xué)生選課系統(tǒng)的維護(hù)模塊實現(xiàn)了對該模塊的功能需求，完成了課題的主要任務(wù)。 關(guān)鍵詞 ：自動化；性能； SQL 3 Summary This thesis investigates the elective system of the webbased system maintenance module design and design student elective system maintenance module system is elective information management. Student elective system maintenance module of the pletion of system management and maintenance functions. The research process, the system management module, a detailed needs analysis, analysis of system management module mainly performs the following functions: basic user information, course selection information input, view, modify, delete in order to achieve that online elective add courses online, online query features such as curriculum. The system management module is the mand center of the whole system, to ensure the safe and effective operation of the entire system in the campus work. After followup demand for the overall design of the system management module. And detailed design and coding system to use ASP. NET as a development language, the SQL Server 2020 as database. By using the code in the Session, to make use of stored procedures and to minimize the database connection open time means to improve performance. The paper integrity of the design and development of the subject. System development is pleted, the subject of the functional design requirements of the test cases for functional testing, test results prove that the class selection system maintenance module to achieve the functional requirements of the module, pleting the main task of the subject. Keywords: automation。 performance。 SQL 4 目錄 1引言 ...............................................................................................................................................................4 C/S結(jié)構(gòu) ..............................................................................................................................................4 B/S結(jié)構(gòu) ..............................................................................................................................................5 B/S結(jié)構(gòu)與 C/S 結(jié)構(gòu)的分析比較 ....................................................................................................6 .................................................................................................................................6 ..........................................................................................................................................6 處理模式不同 .................................................................................................................................6 構(gòu)件重用不同 .................................................................................................................................6 系統(tǒng)維護(hù)不同 .................................................................................................................................7 2開發(fā)工具介紹 ..............................................................................................................................................8 簡介 ......................................................................................................................................8 SQLSQRVER簡介 ..................................................................................................................................9 3系統(tǒng)概述 ................................................................................................................................................... 10 系統(tǒng)開發(fā)的目標(biāo) .............................................................................................................................. 10 系統(tǒng)需求 ........................................................................................................................................... 10 .................................................................................................................................. 10 數(shù)據(jù)庫的設(shè)計 ...................................................................................................................................11 ...........................................................................................................................11 .......................................................................................................................... 15 .......................................................................................................................... 16 系統(tǒng)的實現(xiàn) ....................................................................................................................................... 18 ....................................................................................................................................... 19 .......................................................................................................................... 19 系統(tǒng)總體設(shè)計 .............................................................................................................................. 20 系統(tǒng)說明書 ....................................................................