摘 要
隨著在校大學(xué)生人數(shù)的不斷增加，教務(wù)系統(tǒng)的數(shù)據(jù)量也不斷的上漲。以往的選課方法是隨堂報(bào)名。這種方法雖然直接，但是造成選課的盲目性和教務(wù)處處理數(shù)據(jù)的繁重性。為了減輕教務(wù)處工作，以及每個(gè)學(xué)生更好的選擇自己所喜歡的科目。針對(duì)學(xué)生選課這一環(huán)節(jié)，本系統(tǒng)從學(xué)生網(wǎng)上自主選課以及教師的課程發(fā)布兩個(gè)大方面進(jìn)行了設(shè)計(jì)，基本實(shí)現(xiàn)了學(xué)生的在線信息查詢、選課功能以及教師對(duì)課程信息發(fā)布的管理等功能。
本文通過分析瀏覽器/服務(wù)器結(jié)構(gòu)的特點(diǎn)并結(jié)合選課的實(shí)際情況，提出了基于瀏覽器/服務(wù)器結(jié)構(gòu)網(wǎng)上選課系統(tǒng)的基本設(shè)計(jì)思想，簡(jiǎn)要介紹了系統(tǒng)各功能模塊及數(shù)據(jù)庫的設(shè)計(jì)，著重討論了用 ASP.NET技術(shù)和SQL Server 2000開發(fā)網(wǎng)上選課系統(tǒng)時(shí)的數(shù)據(jù)庫訪問技術(shù)和動(dòng)態(tài)網(wǎng)頁制作技術(shù),并給出了部分實(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平臺(tái)下開發(fā)完成，使用C＃作為ASP.NET的開發(fā)語言，SQL Server 2000作為數(shù)據(jù)庫。系統(tǒng)有較高的安全性和較好的性能。其中連接數(shù)據(jù)庫的字符串可以隨時(shí)在web.config里修改，并經(jīng)過編碼加密，增加了靈活性，保護(hù)了數(shù)據(jù)庫的安全。代碼盡量使用存儲(chǔ)過程和盡量減少數(shù)據(jù)庫連接的打開時(shí)間等手段來提高性能。
本文中除了有對(duì)程序的系統(tǒng)分析、總體設(shè)計(jì)、數(shù)據(jù)庫設(shè)計(jì)、功能實(shí)現(xiàn)等主體部分外，在這之前還介紹了與網(wǎng)上選課系統(tǒng)相關(guān)的信息、IIS介紹、IIS與ASP.NET的結(jié)合等的基本內(nèi)容及發(fā)展情況。
關(guān)鍵詞：網(wǎng)上選課，瀏覽器/服務(wù)器結(jié)構(gòu)，ASP.NET,數(shù)據(jù)庫管理系統(tǒng)




















Abstract
With the development of the enrolling number, the data for daily registry is increasing, too. And always we should goto classroom to enroll. Although this method directly,but result in blindness of the course enrollment and registry data processing of the heavy .In order to reduce the work registry ,and better each student to choose their own favorite subjects .This system is special for the on-line course choosing to design both from the aspect of the student and the teacher. The student can choose the course independently and the teacher can manage the information of the announcing course, also.
This paper gives the basic design idea of the Browser/Server structure based online course elect system by analyzing the characteristic of the Browser/Server structure and combining with the actual public elective courses conditions of our school．It introduces the function module and database design briefly，followed by a discussion on database accessing technology and the active page technology of the course elect system based on ASP.NET and SQL Server 2000．By using this system，students can elect courses online efficiently．This Browser/Server structure system is developed under VS.NET platform in Windows XP operating system, using C# as ASP.NET development language and SQL Server 2000 as the database. This system is of higher security and better performance. The character string, which is used to connecting to the database, can be modified at any time in the file “ web.config”. The string is encoded and encrypted, increasing flexibility of the system and security of the database. In code, making use of stored procedure and minimizing the database opening time to improve performance of the system.
This paper includes the system analysis ,the main designing ,the database designing, the function designing and , before this , some basic knowledge and present development of the programs mentioned above.
Keywords: online course elect, Browser/Server structure,ASP.NET, DBMS















目錄

摘 要 1
ABSTRACT 2
第一章 引言 4
1.1課題研究的目的 4
1.2 課題研究的意義 4
1.3 課題的可行性分析 5
第二章 系統(tǒng)分析與總體設(shè)計(jì) 6
2．1系統(tǒng)分析 6
2.2 系統(tǒng)總體設(shè)計(jì) 7
第三章 數(shù)據(jù)庫設(shè)計(jì)與實(shí)現(xiàn) 9
3.1數(shù)據(jù)庫系統(tǒng)分析 9
3.2 數(shù)據(jù)庫邏輯設(shè)計(jì) 12
3.3數(shù)據(jù)庫物理實(shí)現(xiàn) 13
第四章 公共類與公共頁面設(shè)計(jì) 16
4.1 WEB.CONFIG頁面設(shè)計(jì) 16
4.2 數(shù)據(jù)庫連接操作類—DB類 19
4.3 工具類MYUTILITY類 20
4.4 錯(cuò)誤信息類和錯(cuò)誤顯示頁面 21
第五章 系統(tǒng)說明書 22
5．1系統(tǒng)界面說明 22
5.2 系統(tǒng)管理說明 27
5.2教師管理說明 30
第6章 總結(jié) 34
參考文獻(xiàn) 35
致 謝 36