毕业论文 基于net架构的再就业培训管理系统.doc

摘 要
再就业培训工程信息管理系统属于管理信息系统(MIS),其系统开发主要包括数据库的规划设计与维护、客户端应用程序的开发两个方面。对于前者要求建立起的数据库具有完整性和一致性，且具有一定的数据安全性；而对于后者则要求程序界面友好、功能完备，容易使用，具有流行软件的操作习惯等特点。根据毕业设计的要求，选用Visual Basic 6.0作为前端开发工具，利用其提供的集成开发环境及支持面向对象的各种标准化的控件，尤其是对ADO的支持完成对数据库的各种操作，达到对培训信息管理的目的。设计时首先在短时间内先建立系统应用原型，然后对初始原型系统进行需求迭代，不断修正和改进，直至达到满意的实际可行系统。该管理系统收集了所有参加政府就业及再就业免费培训工程的省直属企业下岗失业人员、全省国有企业下岗失业人员、农民工及未就业大学生的基本信息、培训情况、考核状况、就业及就业去向等资料，并进行统一管理，以实现以上四项政府就业和再就业免费培训工程的年度工作相关统计。在设计该系统时，充分运用VB中一些常用的控件来实现相应的功能。而且，利用ADO的支持，在数据库中，进行更新、查询等一系列数据库操作。最终，通过对VB中控件代码的编写从而实现了预期的功能。利用与数据库的连接实现了一切与再就业相关的信息的管理和统计。这两方面的完成使得该软件成为一个可行的管理系统软件，通过它，可以对再就业免费培训的一些资料进行统计和管理。从而，使管理者对所有培训情况一目了然，更加方便进行决策和安排。


【关键词】再就业培训；管理；数据库；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用户调查 2
1.2 数据库需求分析 2
1.3确定目标系统的功能 3
第二章 系统设计 5
2.1系统功能分析 5
2.2系统功能模块设计 5
2.3 数据库的设计 6
2.4主程序流程图 8
第三章 实现数据库结构和程序 10
3.1 SQL SERVER 2000设置 10
3.2 VISUAL BASIC设置 10
3.3 创建数据库 11
3.4 创建ODBC 11
第四章 系统的实现与调试 13
4.1登录窗体的设计 13
4.2系统主窗体的设计 15
4.3 文件系统管理模块的设计 17
4.4 系统用户管理模块的设计 18
4.5 培训管理模块的设计 22
4.6 培训班管理模块的设计 25
4.7 培训课程管理模块的设计 26
4.8 培训学员管理模块的设计 27
4.9 培训成绩管理模块的设计 28
4.10 综合信息查询模块的设计 31
4.11 系统模块的设计 35
第五章 总结 39
谢辞 40
参考文献 41
附录 42
附录A 外文翻译－原文部分 42
附录B 外文翻译－译文部分 47