綜合信息管理系統(tǒng)的設(shè)計

全文40頁約26000字 設(shè)計獨到 程序語言精準(zhǔn)

摘 要
數(shù)據(jù)庫技術(shù)是計算機應(yīng)用技術(shù)中的一個重要組成部分，對于大量的數(shù)據(jù)，使用數(shù)據(jù)庫來存儲管理將比通過文件來存儲管理有更高的效率。幾乎所有管理方面的應(yīng)用程序都需要存放大量的數(shù)據(jù),并將其組織成易于讀取的格式。這種要求通常可以通過數(shù)據(jù)庫管理系統(tǒng)來實現(xiàn)。
本次設(shè)計的主要任務(wù)是完成院系信息綜合管理系統(tǒng)-科研信息管理子系統(tǒng)的設(shè)計與實現(xiàn)。開發(fā)科研信息管理子系統(tǒng)的目的是為了方便教師或?qū)W校進(jìn)行科研信息的查詢、管理和教師工作量的統(tǒng)計，以為教師的職稱評定、工作總結(jié)以及獎金發(fā)放提供依據(jù)。提高學(xué)校高層管理的透明度。設(shè)計是在管理信息系統(tǒng)的理論和方法指導(dǎo)下、數(shù)據(jù)庫技術(shù)支持下完成的。本次設(shè)計采用VB6.0和Access2000作為系統(tǒng)開發(fā)平臺。在完成設(shè)計基本任務(wù)的基礎(chǔ)上又進(jìn)一步擴展了系統(tǒng)功能。所開發(fā)的科研信息管理子系統(tǒng)可以完成校一級教師科研信息的錄入、單一查詢、混合查詢、數(shù)據(jù)維護(hù)（數(shù)據(jù)的添加、刪除、修改）以及生成報表等功能。超出了設(shè)計基本任務(wù)中“完成院系一級教師科研信息管理”的要求范圍。并且該系統(tǒng)可移植性強，只要做一些改動就可以用于類似的信息管理工作中。
本文首先講述了設(shè)計的背景、目的和意義，然后簡單介紹了一下設(shè)計平臺；文章的主體部分講述了系統(tǒng)開發(fā)的全過程，最后進(jìn)行設(shè)計總結(jié)，淺談設(shè)計感想。文后的附錄中記載了軟件的主要程序及程序說明。


關(guān)鍵字：數(shù)據(jù)庫, 管理信息系統(tǒng), 信息管理, 數(shù)據(jù)維護(hù)

Management System of Academic Synthesize Information
Abstract
The technology of the database is an important component in the application technology of the computer, as to a large number of data, use database to store management have high efficiency than use file management. Almost all of the application program which about managment needs depositing a large amount of data, and managing its organization into easy form for read. This kind of request can usually be realized through the data base management system.
The main task of this design is to design and realize the institute administrative system -Scientific Research subsystem . Developing the scientific research information management sub system is aim to carrying on the scientific research message inquiry for the sake of convenient tutor either educational institution 、Administration and tutor's amount of work statistics ，Consider that the job title of tutor evaluates 、Work summing-up along with money award are grantd suppling the foundation.Lift tall layer management of the educational institution transparency.
This design is guided by the theory and method of the management information system,and be supported by the technical of data base. It adopts VB6.0 and Access2000 as the systematic developing platform this time. Have expanded the systematic function further on the basis of finishing designing the basic task. Scientific research subsystem developed can finish whole school all scientific research input, single inquiry, mix inquiry, datum maintain of information, data maintence, ( addtion, deletion, revise) and produce functions, such as report form,etc.. System this portability strong, if do some change can used in similar information of the management.
This text has told the background designed and rudimentary knowledges involved at first, Expound the fact the whole course that system develops mainly , design summarizing finally. Appendix after being gentle record procedures and procedures of the software prove.
Key Word:Data Base,MIS,Information Management, Data maintence

目 錄
摘要…………………………………………………………………………Ⅰ
Abstract……………………………………………………………………Ⅱ
1前言…………………………………………………………………………1
2系統(tǒng)開發(fā)平臺簡介 ……………………………………………………… 3
2.1 數(shù)據(jù)庫平臺簡介 …………………………………………………… 3
2.2 開發(fā)平臺和技術(shù)簡介…………………………………………… 3
2.2.1 Visual basic 6.0簡介………………………………………3
2.2.2 ADO技術(shù)簡介…………………………………………………4
3系統(tǒng)的需求分析 ………………………………………………………… 6
4系統(tǒng)總體設(shè)計 …………………………………………………………… 8
4.1 軟件總體結(jié)構(gòu)設(shè)計 ………………………………………………… 8
4.2 系統(tǒng)公用模塊設(shè)計 ………………………………………………… 8
4.3 數(shù)據(jù)庫設(shè)計………………………………………………………… 10
4.3.1數(shù)據(jù)庫需求分析……………………………………………… 10
4.3.2數(shù)據(jù)庫的概念結(jié)構(gòu)設(shè)計……………………………………… 11
4.3.3數(shù)據(jù)庫結(jié)構(gòu)邏輯設(shè)計………………………………………… 12
4.4系統(tǒng)窗體的創(chuàng)建…………………………………………………… 15
4.4.1主窗體的創(chuàng)建………………………………………………… 15
4.4.1.1創(chuàng)建工程項目…………………………………………… 15
4.4.1.2主窗體的具體實現(xiàn)……………………………………… 15
4.4.2創(chuàng)建系統(tǒng)的功能模塊………………………………………… 16
4.4.3單一查詢窗體的設(shè)計………………………………………… 17
4.4.4數(shù)據(jù)維護(hù)窗體的建立………………………………………… 18
4.4.5報表窗體的建立……………………………………………… 21
4.4.6其它窗體的建立……………………………………………… 23
4.4.7用ADO方法連接數(shù)據(jù)庫……………………………………… 23
5設(shè)計中所遇問題與解決方法…………………………………………… 26
5.1如何用ADO方法與數(shù)據(jù)庫連接…………………………………… 26
5.2如何制作動態(tài)報表………………………………………………… 26
5.3引用控件庫………………………………………………………… 27
6結(jié)束語…………………………………………………………………… 28
致謝………………………………………………………………………… 29
附錄………………………………………………………………………… 30
參考文獻(xiàn)…………………………………………………………………… 35