摘 要
再就業(yè)培訓工程信息管理系統(tǒng)屬于管理信息系統(tǒng)(MIS),其系統(tǒng)開發(fā)主要包括數(shù)據(jù)庫的規(guī)劃設計與維護、客戶端應用程序的開發(fā)兩個方面。對于前者要求建立起的數(shù)據(jù)庫具有完整性和一致性，且具有一定的數(shù)據(jù)安全性；而對于后者則要求程序界面友好、功能完備，容易使用，具有流行軟件的操作習慣等特點。根據(jù)畢業(yè)設計的要求，選用Visual Basic 6.0作為前端開發(fā)工具，利用其提供的集成開發(fā)環(huán)境及支持面向對象的各種標準化的控件，尤其是對ADO的支持完成對數(shù)據(jù)庫的各種操作，達到對培訓信息管理的目的。設計時首先在短時間內(nèi)先建立系統(tǒng)應用原型，然后對初始原型系統(tǒng)進行需求迭代，不斷修正和改進，直至達到滿意的實際可行系統(tǒng)。該管理系統(tǒng)收集了所有參加政府就業(yè)及再就業(yè)免費培訓工程的省直屬企業(yè)下崗失業(yè)人員、全省國有企業(yè)下崗失業(yè)人員、農(nóng)民工及未就業(yè)大學生的基本信息、培訓情況、考核狀況、就業(yè)及就業(yè)去向等資料，并進行統(tǒng)一管理，以實現(xiàn)以上四項政府就業(yè)和再就業(yè)免費培訓工程的年度工作相關統(tǒng)計。在設計該系統(tǒng)時，充分運用VB中一些常用的控件來實現(xiàn)相應的功能。而且，利用ADO的支持，在數(shù)據(jù)庫中，進行更新、查詢等一系列數(shù)據(jù)庫操作。最終，通過對VB中控件代碼的編寫從而實現(xiàn)了預期的功能。利用與數(shù)據(jù)庫的連接實現(xiàn)了一切與再就業(yè)相關的信息的管理和統(tǒng)計。這兩方面的完成使得該軟件成為一個可行的管理系統(tǒng)軟件，通過它，可以對再就業(yè)免費培訓的一些資料進行統(tǒng)計和管理。從而，使管理者對所有培訓情況一目了然，更加方便進行決策和安排。


【關鍵詞】再就業(yè)培訓；管理；數(shù)據(jù)庫；ADO





















Re-employment Training Management System
Abstract
The re-employment free-training management information system is one kind of the Management Information System(MIS), which includes two parts of aspects in programming, they are planning designs and maintenance for the database and programming for the client application. It requires a integrated and consistent database for the previous, and the characteristics for the latter, which include friendly interface,perfect function,easy using and popular operational habit. According to the demand of the thesis, It’s good to choose Visual Basic 6.0 as the programming tool for the foreground application, and utilize its characteristics to reach the perpurse of managing training-information,which include the integrated-design-environment and supporting Object Oriented , normative ActiveX, especially the supporting of ADO. At the beginning of the programming-design, It requies to build a system antetype in a short of time, then It should be interated the requirement of the system,modifed and amended, untill the system is feasible and perfect. The management system to collect all participate in government employment and re-employment training projects in free enterprise directly under the laid-off workers, the province's state-owned enterprises laid-off workers, migrant workers and college students is not the basic employment information, training, assessment status, employment and employment Where such information, and unified management to achieve more than four government employment and reemployment
training project free of the annual work-related statistics. In designing the system, make full use of some commonly used in VB controls to achieve the corresponding function. Moreover, the use of ADO support in the database, updated, such as a database for operation. Eventual
ly, through the controls in VB code prepared to achieve the desired function. And use the connection to the database and re-employment of all information relevant to the management and statistics. The completion of these two aspects make this software into a workable management system software, through it, can be free to re-employment training to some statistics and information management. Thus, the managers of all training at a glance, the decision-makin
g and more convenient arrangement.





【Key Words】Reemploymeny free training;Management; Database； ADO








目錄
引言 1
第一章 需求分析 2
1.1用戶調(diào)查 2
1.2 數(shù)據(jù)庫需求分析 2
1.3確定目標系統(tǒng)的功能 3
第二章 系統(tǒng)設計 5
2.1系統(tǒng)功能分析 5
2.2系統(tǒng)功能模塊設計 5
2.3 數(shù)據(jù)庫的設計 6
2.4主程序流程圖 8
第三章 實現(xiàn)數(shù)據(jù)庫結構和程序 10
3.1 SQL SERVER 2000設置 10
3.2 VISUAL BASIC設置 10
3.3 創(chuàng)建數(shù)據(jù)庫 11
3.4 創(chuàng)建ODBC 11
第四章 系統(tǒng)的實現(xiàn)與調(diào)試 13
4.1登錄窗體的設計 13
4.2系統(tǒng)主窗體的設計 15
4.3 文件系統(tǒng)管理模塊的設計 17
4.4 系統(tǒng)用戶管理模塊的設計 18
4.5 培訓管理模塊的設計 22
4.6 培訓班管理模塊的設計 25
4.7 培訓課程管理模塊的設計 26
4.8 培訓學員管理模塊的設計 27
4.9 培訓成績管理模塊的設計 28
4.10 綜合信息查詢模塊的設計 31
4.11 系統(tǒng)模塊的設計 35
第五章 總結 39
謝辭 40
參考文獻 41
附錄 42
附錄A 外文翻譯－原文部分 42
附錄B 外文翻譯－譯文部分 47