摘  要
隨著近幾年來微機(jī)技術(shù)、網(wǎng)絡(luò)技術(shù)及相應(yīng)軟件技術(shù)的迅猛發(fā)展，學(xué)校的教學(xué)、管理等工作已越來越離不開計算機(jī)了。本系統(tǒng)—綜合教務(wù)管理系統(tǒng)是針對現(xiàn)今教學(xué)模式復(fù)雜，管理繁瑣這一問題開發(fā)、研制出來的
本文通過分析瀏覽器/服務(wù)器結(jié)構(gòu)的特點(diǎn)并結(jié)合選課的實際情況，提出了基于瀏覽器/服務(wù)器結(jié)構(gòu)網(wǎng)上選課系統(tǒng)的基本設(shè)計思想，簡要介紹了系統(tǒng)各功能模塊及數(shù)據(jù)庫的設(shè)計，著重討論了用 ASP.NET技術(shù)和SQL Server 2005開發(fā)網(wǎng)上選課系統(tǒng)時的數(shù)據(jù)庫訪問技術(shù)和動態(tài)網(wǎng)頁制作技術(shù),并給出了部分實現(xiàn)代碼。通過該系統(tǒng)，使學(xué)生可以方便地在校園網(wǎng)上進(jìn)行網(wǎng)上選課。該B/S結(jié)構(gòu)的系統(tǒng)在Windows XP系統(tǒng)和VS.NET平臺下開發(fā)完成，使用C＃作為ASP.NET的開發(fā)語言，SQL Server 2005作為數(shù)據(jù)庫。系統(tǒng)有較高安全性和較好的性能。其中連接數(shù)據(jù)庫的字符串可以隨時在Web.config里修改，并經(jīng)過編碼加密，增加了靈活性，保護(hù)了數(shù)據(jù)庫的安全。代碼盡量使用存儲過程和盡量減少數(shù)據(jù)庫連接的打開時間等手段來提高性能。
本文中除了有對程序的系統(tǒng)分析、總體設(shè)計、數(shù)據(jù)庫設(shè)計、功能實現(xiàn)等主體部分外，在這之前還介紹了與網(wǎng)上選課系統(tǒng)相關(guān)的信息、IIS介紹、IIS與ASP.NET的結(jié)合等的基本內(nèi)容及發(fā)展情況。
關(guān)鍵詞： SQL Server2005 ,瀏覽器/服務(wù)器結(jié)構(gòu)，ASP.NET,教務(wù)系統(tǒng)

 
ABSTRACT
With the rapid development of recent years computer technology, network technology and the corresponding software technology, teaching in schools, work has become increasingly inseparable from the computer. This system - Comprehensive Academic Management System for today's complex mode of teaching, management cumbersome to develop, developed out
Browser / server structure is characterized by analyzing the combination of the actual situation of the Course, the basic design idea of the online course selection system based on the browser / server architecture, a brief introduction of each functional module and database design, focused on the ASP.NET and SQL Server 2005 when developing an online course selection system database access technology and dynamic web page production technology, and part of the code. Through the system so that students on campus online Online Course. System of the B / S structure in the Windows XP system and VS.NET platform developed using C # as the development language of ASP.NET, SQL Server 2005 as database. The system has a higher security and better performance. String to connect to the database can be modified in the Web.config, and encrypted, to increase the flexibility to protect the security of the database. The code to make use of stored procedures and to minimize the database connection open time means to improve performance.
This article in addition to the main part of system analysis, overall design, database design, functional implementation of the program, in this also describes the information with the online course selection system, introduced the IIS, IIS with ASP.NET integration. The basic contents and development.
Key Words：SQL Server2005, browser / server structure, ASP.NET, Dean system
目  錄
1 概述 1
1.1開發(fā)背景 1
1.2 項目提出的意義 2
1.3 系統(tǒng)的開發(fā)方法 3
1.4 系統(tǒng)開發(fā)工具 4
1.4.1 C#簡介 4
1.4.2 ASP.NET簡介 4
1.4.3 數(shù)據(jù)庫簡介 6
2 需求分析 7
2.1可行性分析 7
2.2 系統(tǒng)設(shè)計的要求 7
2.3 系統(tǒng)功能需求分析 8
2.4 數(shù)據(jù)庫需求分析 9
3 系統(tǒng)總體設(shè)計 11
3.1系統(tǒng)總體設(shè)計 11
3.2 系統(tǒng)功能總體設(shè)計 11
3.2.1 管理員角色 11
3.2.2 教師角色 11
3.3 數(shù)據(jù)庫結(jié)構(gòu)設(shè)計 12
3.3.1 概念結(jié)構(gòu)設(shè)計 12
3.3.2 概念結(jié)構(gòu)設(shè)計的方法選擇 13
3.3.3 系統(tǒng)的E-R圖 13
3.4 數(shù)據(jù)庫表的設(shè)計 14
4 系統(tǒng)實現(xiàn) 19
4.1 運(yùn)行環(huán)境 19
4.2 系統(tǒng)主界面 19
4.3 管理員角色主要實現(xiàn)功能 21
4.3.1 院系信息維護(hù) 21
4.3.2 教師信息維護(hù) 22
4.3.3 學(xué)生信息維護(hù) 24
4.3.4課程列表 26
4.3.5 專業(yè)管理 28
4.4 教師角色主要實現(xiàn)功能 28
4.4.1 教師個人資料 28
4.4.2 擔(dān)當(dāng)課程 29
4.5 學(xué)生角色主要實現(xiàn)功能 32
4.5.1 個人信息維護(hù) 32
4.5.2 選課 34
4.5.3 選課信息管理 36
5 軟件測試 38
5.1 軟件測試的意義 38
5.2 軟件測試的重要性 38
5.3 軟件測試的范圍 39
5.4 軟件測試的方法 39
5.5 軟件測試的目的和原則 39
總   結(jié) 41
參 考 文 獻(xiàn) 42
致   謝 44
1