學(xué)籍管理系統(tǒng)設(shè)計(jì)與應(yīng)用

頁數(shù) 24 字?jǐn)?shù) 11866

摘 要
學(xué)籍管理系統(tǒng)是典型的信息管理系統(tǒng)(MIS),其開發(fā)主要包括后臺(tái)數(shù)據(jù)庫的建立和維護(hù)以及前端應(yīng)用程序的開發(fā)兩個(gè)方面。對(duì)于前者要求建立起數(shù)據(jù)一致性和完整性強(qiáng)、數(shù)據(jù)安全性好的庫。而對(duì)于后者則要求應(yīng)用程序功能完備,易使用等特點(diǎn)。
本系統(tǒng)主要完成對(duì)學(xué)生情況和學(xué)生成績(jī)的管理，包括數(shù)據(jù)庫中表的添加、修改、刪除等。系統(tǒng)還可以完成對(duì)各類信息的瀏覽、查詢、添加、刪除、修改、報(bào)表等功能。
系統(tǒng)的核心是數(shù)據(jù)庫中各個(gè)表聯(lián)系，每一個(gè)表的修改都將聯(lián)動(dòng)的影響其它的表，當(dāng)完成對(duì)數(shù)據(jù)的操作時(shí)系統(tǒng)會(huì)自動(dòng)地完成數(shù)據(jù)庫的修改。查詢功能也是系統(tǒng)的核心之一，在系統(tǒng)中即有單條件查詢和多條件查詢，也有精確查詢和模糊查詢，系統(tǒng)不僅有靜態(tài)的條件查詢，也有動(dòng)態(tài)生成的條件查詢，其目的都是為了方便用戶使用。系統(tǒng)有完整的用戶添加、刪除和密碼修改功能，并具備報(bào)表打印功能。
經(jīng)過分析,我們使用 MICROSOFT公司的 VISUAL BASIC開發(fā)工具,利用其提供的各種面向?qū)ο蟮拈_發(fā)工具,尤其是數(shù)據(jù)窗口這一能方便而簡(jiǎn)潔操縱數(shù)據(jù)庫的智能化對(duì)象,首先在短時(shí)間內(nèi)建立系統(tǒng)應(yīng)用原型,然后,對(duì)初始原型系統(tǒng)進(jìn)行需求迭代,不斷修正和改進(jìn),直到形成用戶滿意的可行系統(tǒng)。

關(guān)鍵字：控件,窗體,數(shù)據(jù)庫,vb6.0,access2000。

ABSTRACT

Student status management system is development two aspects that typical information management system, IMS( MIS), its development includes primarily the background database creates with support and the front end applies the procedure.Creates to rise to the former request the consistency of data is strong with the integrity, the library that the safeness of data like.But request the latter very much to apply the procedure function complete, easy usage etc. characteristics.
This system completes primarily to student's circumstance with the management of student's score, include the database the inside the watch increase, modify, delete etc..The system can also complete to the browsing of various information, search, increase, delete, modify, report etc. function.
System of nucleus is other table in an influence for of relation, each a modification of watch moving in a table in database that modification that operation hour system, be to complete the logarithms according to will complete the database of oneself.Search the function is also one of the nucleus of the system, having namely in system the single condition search to search with many conditions, also having the accurate search to search with blur, system not only contain static condition search, also have the dynamic born condition search, its purpose is all for the sake of the convenient consumer to use.System contain complete consumer increase, delete to modify the function with the password, the union has the report prints the function.
Through analysis, we use the MICROSOFT company VISUAL BASIC development tool, making use of its every kind of the tool of development that provide that face to the object, particularly is intelligence that the window of data this on canning be convenient but manipulate the database in brief to turn the object, create in the in a short time first system application prototype, then, start to the beginning the prototype system proceeds to require with the iteration, revising continuously with improve, until forming the consumer is satisfied can row system.


Keywords: Control piece,form, database, vb6.0, access2000.


目錄

前言 5
1 可行性研究及需求分析 5
1.1課題來源： 5
1.2 開發(fā)工具的選用 5
1.2.1 Visual Basic的使用 5
1.2.2 Microsoft Access的使用 6
1.3.系統(tǒng)的初步調(diào)查 6
1.4.系統(tǒng)的可行性研究 7
1.4.1技術(shù)上的可行性。 7
1.4.2管理上的可行性。 7
1.4.3安全上的可行性。 7
1.4.系統(tǒng)分析 7
1.5.1系統(tǒng)的安全性。 7
1.5.2系統(tǒng)的快捷性。 7
1.5.3系統(tǒng)的準(zhǔn)確性。 7
1.5.4系統(tǒng)的嚴(yán)謹(jǐn)性。 7
2 概要設(shè)計(jì) 7
2.1 系統(tǒng)設(shè)計(jì)思路分析 8
2.1.1界面。 8
2.2 設(shè)計(jì)簡(jiǎn)述 8
2.2.1 vb設(shè)計(jì)的界面簡(jiǎn)述。 8
2.2.2 access2000設(shè)計(jì)數(shù)據(jù)庫。 8
3 詳細(xì)設(shè)計(jì) 9
3.1 數(shù)據(jù)庫的實(shí)現(xiàn) 9
3.1.1班級(jí)情況表。 9
3.1.2學(xué)生情況表。 9
3.1.3教師情況表。 9
3.1.4教學(xué)計(jì)劃表。 10
3.1.5各班成績(jī)表。 10
3.2 界面的實(shí)現(xiàn) 10
3.2.1“漂亮界面”。 10
3.2.2“登陸界面”。 10
3.2.3“主界面”。 11
3.2.4 “新建班級(jí)”。 12
3.2.5 “數(shù)據(jù)輸入”。 14
3.2.6 “數(shù)據(jù)導(dǎo)入”。 16
3.2.7 “查找向?qū)А薄?17
3.2.8 “數(shù)據(jù)統(tǒng)計(jì)”。 18
3.2.9 “打印管理”。 19
3.2.10“幫助主題”。 21
4 數(shù)據(jù)測(cè)試 21
5 用戶手冊(cè) 22
5.1 歡迎界面 22
5.2 登陸界面 22
5.3 登陸界面 22
5.4 新建班級(jí) 22
5.5 輸入數(shù)據(jù) 22
5.6 導(dǎo)入數(shù)據(jù) 22
5.7 查找向?qū)?22
5.8 統(tǒng)計(jì)數(shù)據(jù) 22
5.9 打印管理 23
5.10 打印管理 23
6 心得體會(huì) 23
6.1 編程心得 23
6.2 感謝 23
7 參考文獻(xiàn) 23

參考文獻(xiàn)
[1] 薩師煊，王珊，<<數(shù)據(jù)庫系統(tǒng)概論>>,高等教育出版社,2001。

[2] 鄭榮貴、黃平、谷會(huì)東，《VB6.0數(shù)據(jù)庫開發(fā)與應(yīng)用》，中科多媒體電子出版社，2002 。

[3] 伍俊良，《VB6控件應(yīng)用實(shí)例教程》，北京希望電子出版社，2002。

[4] 盧國俊，《VB6數(shù)據(jù)庫開發(fā)》，電子工業(yè)出版社，2002。
[5] 邊萌，《VB編程起步》，機(jī)械工業(yè)出版社，2002。