摘  要
隨著近幾年來(lái)微機(jī)技術(shù)、網(wǎng)絡(luò)技術(shù)及相應(yīng)軟件技術(shù)的迅猛發(fā)展，學(xué)校的教學(xué)、管理等工作已越來(lái)越離不開(kāi)計(jì)算機(jī)了。本系統(tǒng)—綜合教務(wù)管理系統(tǒng)是針對(duì)現(xiàn)今教學(xué)模式復(fù)雜，管理繁瑣這一問(wèn)題開(kāi)發(fā)、研制出來(lái)的
本文通過(guò)分析瀏覽器/服務(wù)器結(jié)構(gòu)的特點(diǎn)并結(jié)合選課的實(shí)際情況，提出了基于瀏覽器/服務(wù)器結(jié)構(gòu)網(wǎng)上選課系統(tǒng)的基本設(shè)計(jì)思想，簡(jiǎn)要介紹了系統(tǒng)各功能模塊及數(shù)據(jù)庫(kù)的設(shè)計(jì)，著重討論了用 ASP.NET技術(shù)和SQL Server 2005開(kāi)發(fā)網(wǎng)上選課系統(tǒng)時(shí)的數(shù)據(jù)庫(kù)訪問(wèn)技術(shù)和動(dòng)態(tài)網(wǎng)頁(yè)制作技術(shù),并給出了部分實(shí)現(xiàn)代碼。通過(guò)該系統(tǒng)，使學(xué)生可以方便地在校園網(wǎng)上進(jìn)行網(wǎng)上選課。該B/S結(jié)構(gòu)的系統(tǒng)在Windows XP系統(tǒng)和VS.NET平臺(tái)下開(kāi)發(fā)完成，使用C＃作為ASP.NET的開(kāi)發(fā)語(yǔ)言，SQL Server 2005作為數(shù)據(jù)庫(kù)。系統(tǒng)有較高安全性和較好的性能。其中連接數(shù)據(jù)庫(kù)的字符串可以隨時(shí)在Web.config里修改，并經(jīng)過(guò)編碼加密，增加了靈活性，保護(hù)了數(shù)據(jù)庫(kù)的安全。代碼盡量使用存儲(chǔ)過(guò)程和盡量減少數(shù)據(jù)庫(kù)連接的打開(kāi)時(shí)間等手段來(lái)提高性能。
本文中除了有對(duì)程序的系統(tǒng)分析、總體設(shè)計(jì)、數(shù)據(jù)庫(kù)設(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開(kāi)發(fā)背景 1
1.2 項(xiàng)目提出的意義 2
1.3 系統(tǒng)的開(kāi)發(fā)方法 3
1.4 系統(tǒng)開(kāi)發(fā)工具 4
1.4.1 C#簡(jiǎn)介 4
1.4.2 ASP.NET簡(jiǎn)介 4
1.4.3 數(shù)據(jù)庫(kù)簡(jiǎn)介 6
2 需求分析 7
2.1可行性分析 7
2.2 系統(tǒng)設(shè)計(jì)的要求 7
2.3 系統(tǒng)功能需求分析 8
2.4 數(shù)據(jù)庫(kù)需求分析 9
3 系統(tǒng)總體設(shè)計(jì) 11
3.1系統(tǒng)總體設(shè)計(jì) 11
3.2 系統(tǒng)功能總體設(shè)計(jì) 11
3.2.1 管理員角色 11
3.2.2 教師角色 11
3.3 數(shù)據(jù)庫(kù)結(jié)構(gòu)設(shè)計(jì) 12
3.3.1 概念結(jié)構(gòu)設(shè)計(jì) 12
3.3.2 概念結(jié)構(gòu)設(shè)計(jì)的方法選擇 13
3.3.3 系統(tǒng)的E-R圖 13
3.4 數(shù)據(jù)庫(kù)表的設(shè)計(jì) 14
4 系統(tǒng)實(shí)現(xiàn) 19
4.1 運(yùn)行環(huán)境 19
4.2 系統(tǒng)主界面 19
4.3 管理員角色主要實(shí)現(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 教師角色主要實(shí)現(xiàn)功能 28
4.4.1 教師個(gè)人資料 28
4.4.2 擔(dān)當(dāng)課程 29
4.5 學(xué)生角色主要實(shí)現(xiàn)功能 32
4.5.1 個(gè)人信息維護(hù) 32
4.5.2 選課 34
4.5.3 選課信息管理 36
5 軟件測(cè)試 38
5.1 軟件測(cè)試的意義 38
5.2 軟件測(cè)試的重要性 38
5.3 軟件測(cè)試的范圍 39
5.4 軟件測(cè)試的方法 39
5.5 軟件測(cè)試的目的和原則 39
總   結(jié) 41
參 考 文 獻(xiàn) 42
致   謝 44
1