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

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

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


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