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


【關(guān)鍵詞】再就業(yè)培訓(xùn)；管理；數(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確定目標(biāo)系統(tǒng)的功能 3
第二章 系統(tǒng)設(shè)計 5
2.1系統(tǒng)功能分析 5
2.2系統(tǒng)功能模塊設(shè)計 5
2.3 數(shù)據(jù)庫的設(shè)計 6
2.4主程序流程圖 8
第三章 實(shí)現(xiàn)數(shù)據(jù)庫結(jié)構(gòu)和程序 10
3.1 SQL SERVER 2000設(shè)置 10
3.2 VISUAL BASIC設(shè)置 10
3.3 創(chuàng)建數(shù)據(jù)庫 11
3.4 創(chuàng)建ODBC 11
第四章 系統(tǒng)的實(shí)現(xiàn)與調(diào)試 13
4.1登錄窗體的設(shè)計 13
4.2系統(tǒng)主窗體的設(shè)計 15
4.3 文件系統(tǒng)管理模塊的設(shè)計 17
4.4 系統(tǒng)用戶管理模塊的設(shè)計 18
4.5 培訓(xùn)管理模塊的設(shè)計 22
4.6 培訓(xùn)班管理模塊的設(shè)計 25
4.7 培訓(xùn)課程管理模塊的設(shè)計 26
4.8 培訓(xùn)學(xué)員管理模塊的設(shè)計 27
4.9 培訓(xùn)成績管理模塊的設(shè)計 28
4.10 綜合信息查詢模塊的設(shè)計 31
4.11 系統(tǒng)模塊的設(shè)計 35
第五章 總結(jié) 39
謝辭 40
參考文獻(xiàn) 41
附錄 42
附錄A 外文翻譯－原文部分 42
附錄B 外文翻譯－譯文部分 47