基于B/S模式下的學(xué)生成績管理系統(tǒng)
——學(xué)生資料管理、課程管理
1.8萬字 71頁
包括中英文翻譯，程序代碼


摘 要
隨著網(wǎng)絡(luò)發(fā)展的日益完善，無紙化辦公正成為企業(yè)發(fā)展的新趨向。學(xué)校是一個擁有幾千人乃至上萬人的學(xué)習(xí)、工作場合，信息流量的巨大是可想而知的，尤其是對學(xué)生的管理，數(shù)據(jù)量非常龐大。通過網(wǎng)絡(luò)對學(xué)生成績進行管理，可以有效的減輕學(xué)生管理的工作負(fù)擔(dān)。
本論文首先介紹了學(xué)生成績管理系統(tǒng)的設(shè)計思想，論述了系統(tǒng)的需求、分析及編碼的實現(xiàn)過程，給出了系統(tǒng)的數(shù)據(jù)流圖和E-R圖，并對系統(tǒng)界面與數(shù)據(jù)庫的鏈接方法進行了詳細(xì)描述，然后介紹了通過遠(yuǎn)程操作對數(shù)據(jù)庫進行添加、修改、刪除和瀏覽功能的實現(xiàn)過程，最后對系統(tǒng)進行了簡單測試，并將其發(fā)布在網(wǎng)上。
本系統(tǒng)基于B/S模式，利用Dreamweaver MX工具，應(yīng)用ASP技術(shù)結(jié)合VBscript語言對學(xué)生成績管理系統(tǒng)進行了設(shè)計，將用戶分為管理員、教師和學(xué)生，由管理員管理所有用戶，教師管理課程、學(xué)生資料和成績，學(xué)生查詢成績。實現(xiàn)了課程和學(xué)生資料的添加、修改、刪除和查詢功能。通過測試表明，本系統(tǒng)基本能滿足用戶對課程和學(xué)生資料的管理。

關(guān)鍵詞： ASP，B/S模式，VBScript，課程管理，學(xué)生管理



The Management of Students Score Based on B/S
——Students Information Management and Curriculum Management
Author: PengJia Tutor: YanWang
Abstract
With the network developing perfect day and day, it is a new tend to handle official business with no paper at all in enterprise's development. School is a place holding hundreds and thousands of people, the flow of information is enormous, the data amount of management to students is especially huge. It can lighten the burden effectively to manage students’ achievement by the network.
Firstly, the design idea of the system is introduced in this paper. The realizing process of system request, analysis and code is described. System data flow diagram and E-R diagram is given. At the same time the method of linking system interface with database is depicted in detail. Secondly, the realizing process of adding, modifying, deleting and browsing database by operating distantly is introduced. At last the system is tested simply and is sent to Internet.
The system is based on B/S model. The tool of Dreamweaver MX is using. The technology of ASP combined with VBScript language is utilized to design system. There are three kind of user: administer, teacher and student. Administer manages all the users. Teacher manages curriculum, student information and score while student inquires score. The function of adding, modifying, deleting and inquiring of curriculum and student information is realized. The test shows that the system can meet the user’s request to the management of curriculum and student information basically.

Key words: ASP, B/S Mode, VBScript, Curriculum Management, Student Information Management


目 錄
第一章 系統(tǒng)概述........................................................................................................ 1
1.1 開發(fā)背景及意義.............................................................................................. 1
1.2 項目分工 ....................................................................................................... 1
1.3 運行環(huán)境......................................................................................................... 1
第二章 工具及技術(shù)簡介........................................................................................ 2
2.1 ASP簡介.......................................................................................................... 2
2.2 Dreamweaver的特點 ............................................................................... 2
2.3 ACCESS特點介紹.............................................................................................. 3
第三章 需求分析 ....................................................................................................... 6
3.1 可行性分析......................................................................................................... 6
3.1.1 設(shè)計思想.........................................................................................6
3.1.2 技術(shù)可行性.....................................................................................6
3.1.3 環(huán)境可行性.....................................................................................6
3.2 系統(tǒng)要求..............................................................................................................6
3.2.1 功能要求.........................................................................................6
3.2.2 性能要求.........................................................................................7
3.2.3 系統(tǒng)環(huán)境要求.................................................................................7
3.3 系統(tǒng)的可移植性..................................................................................................7
3.4 開發(fā)條件..............................................................................................................7
3.5 數(shù)據(jù)流程圖..........................................................................................................8
3.6 E—R圖................................................................................................................9
第四章 總體分析與設(shè)計............................................................................................... 10
4.1 課程管理模塊設(shè)計............................................................................................... 10
4.2 學(xué)生資料管理模塊............................................................................................... 10
4.3 數(shù)據(jù)庫設(shè)計思路...................................................................................................10
4.3.1 總體數(shù)據(jù)庫設(shè)計..............................................................................11
4.3.2 相關(guān)模塊數(shù)據(jù)庫設(shè)計..................................................................... 11
第五章 系統(tǒng)詳細(xì)設(shè)計................................................................................................14
5.1 ASP功能詳解.....................................................................................................14
5.2 各主要頁面功能介紹..........................................................................................14
5.2.1 課程管理.........................................................................................14
5.2.2 學(xué)生資料管理.................................................................................22
5.3 數(shù)據(jù)庫鏈接..........................................................................................................28
5.4 網(wǎng)上發(fā)布..............................................................................................................28
5.4.1 域名申請.........................................................................................28
5.4.2 所用空間.........................................................................................29
5.4.3 發(fā)布工具.........................................................................................29
第六章 測試....................................................................................................................30
結(jié)束語....................................................................................................................................32
致謝.........................................................................................................................................33
附錄1 英文原文及翻譯................................................................................................34
附錄2 程序源代碼..........................................................................................................43
參考文獻...............................................................................................................................71


參考文獻
[12] Cnbruce，《ASP編程入門進階》，5D多媒體
[13]白尚旺，《數(shù)據(jù)庫建模技術(shù)》，西安，西安電子科技大學(xué)出版社，1999.12。
[14] 薩師煊，《數(shù)據(jù)庫系統(tǒng)概論》，北京，高等教育出版社，2002.2。
[15] 楊開英，《數(shù)據(jù)庫系統(tǒng)概論》，武漢，武漢理工大學(xué)出版社，2003.11。
[16] 曾建潮，《軟件工程》，武漢，武漢大學(xué)出版社，2003.8。
[17] Richard Anderson Chris Blexrud， 《Professional Active Server Pages 3.0》，北京，機械工業(yè)出版社