網(wǎng)上選課系統(tǒng)（ASP）
1.6萬字 34頁


摘要：隨著在校大學生人數(shù)的不斷增加，教務系統(tǒng)的數(shù)據(jù)量也不斷的上漲。針對學生選課這一環(huán)節(jié)，本系統(tǒng)從學生網(wǎng)上自主選課以及教師的課程發(fā)布兩個大方面進行了設計，基本實現(xiàn)了學生的在線信息查詢、選課功能以及教師對課程信息發(fā)布的管理等功能，另外也初步解決了教師在課程信息發(fā)布管理上的權限問題。本程序前臺采用Dreamweaver 4.03進行頁面制作，后臺由SQL Server數(shù)據(jù)庫支持，通過使用ASP語言實現(xiàn)動態(tài)網(wǎng)頁的效果，達到對數(shù)據(jù)庫的操作以完成使用者的要求。本文中除了有對程序的總體設計、詳細設計、功能實現(xiàn)等主體部分外，在這之前還介紹了與網(wǎng)上選課系統(tǒng)相關的信息管理系統(tǒng)、網(wǎng)絡編程技術、ASP編程語言、SQL Server數(shù)據(jù)庫服務器等的基本內(nèi)容及發(fā)展情況。

關鍵字：選課、課程信息發(fā)布、權限、SQL Server、ASP



Abstract：with the development of the enrolling number, the data for daily education is increasing, too. 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 system is basically used for the on-line information searching, the course choosing and the announcing course managing. Besides, the power of the teacher has been well controlled. The form is made by Dreamweaver 4.03 , the data base is built by SQL Server and the active website is made by using the ASP language .This paper includes the main designing , the detail designing, the function designing and , before this , some basic knowledge and present development of the programs mentioned above.

Keywords：course choosing , announcing the course information , power , SQL Server , ASP


目 錄
摘要（中文）------------------------------------------------------------------------------------2
摘要（英文）---------------------------------------------------------------------------------------2
概述------------------------------------------------------------------------------------------------5
第一章：設計的可行性-------------------------------------------------------------------------7
1.1 MIS系統(tǒng)的產(chǎn)生和發(fā)展情況--------------------------------------------------------7
1.2 網(wǎng)上選課系統(tǒng)的產(chǎn)生和可行性分析-----------------------------------------------7
第二章：相關軟件及技術介紹----------------------------------------------------------------9
2.1Dreamweave-----------------------------------------------------------------------------9
2.2 SQL Server------------------------------------------------------------------------------9
2.3 ASP(Active Server Page) -------------------------------------------------------------9
2.4 HTML(Hyper Text Markup Language) -------------------------------------------10
第三章：系統(tǒng)概述------------------------------------------------------------------------------11
3.1 項目范圍------------------------------------------------------------------------------11
3.2 設計策略------------------------------------------------------------------------------11
第四章：系統(tǒng)總體設計------------------------------------------------------------------------12
4.1 系統(tǒng)結構設計------------------------------------------------------------------------12
4.1.1 各模塊功能-------------------------------------------------------------------12
4.1.2 模塊間的調用關系----------------------------------------------------------12
4.1.3 模塊間的接口----------------------------------------------------------------14
4.2數(shù)據(jù)庫設計----------------------------------------------------------------------------14
第五章：詳細設計------------------------------------------------------------------------------17
5.1 教師/學生登錄功能-----------------------------------------------------------------17
5.2 教師/學生密碼管理功能-----------------------------------------------------------18
5.3 學生的信息瀏覽/查詢功能--------------------------------------------------------20
5.3.1 選課信息查詢----------------------------------------------------------------20
5.3.2 查詢開課信息----------------------------------------------------------------21
5.3.3 查詢公告信息----------------------------------------------------------------22
5.3.4 查詢課程信息----------------------------------------------------------------22
5.3.5 查詢教師信息----------------------------------------------------------------23
5.3.6 查詢選課名單----------------------------------------------------------------23
5.4 教師的信息瀏覽/發(fā)布/修改/刪除功能------------------------------------------23
5.4.1 瀏覽已發(fā)布信息-------------------------------------------------------------23
5.4.2 信息發(fā)布----------------------------------------------------------------------24
5.4.3 課程信息修改----------------------------------------------------------------25
5.4.4 課程信息刪除----------------------------------------------------------------25
5.4.5 查詢公告信息----------------------------------------------------------------27
5.5修改教師信息功能-------------------------------------------------------------------27
5.6添加教師信息功能-------------------------------------------------------------------27
5.7刪除教師信息功能-------------------------------------------------------------------28
5.8修改學生信息功能-------------------------------------------------------------------29
5.9添加學生信息功能-------------------------------------------------------------------29
5.10刪除學生信息功能------------------------------------------------------------------29
5.11刪除公告信息功能------------------------------------------------------------------30
第六章：設計過程中的問題及解決---------------------------------------------------------31
6.1 數(shù)據(jù)庫的連接------------------------------------------------------------------------31
6.2 參數(shù)的傳遞---------------------------------------------------------------------------31
6.3 公共數(shù)據(jù)------------------------------------------------------------------------------31
第七章：總結------------------------------------------------------------------------------------32
謝辭---------------------------------------------------------------33
參考文獻-----------------------------------------------------------34
附錄----------------------------------------------------------------------------------------------35