人事工资管理系统

哈尔滨工业大学高等教育毕业设计（论文）－－I摘要由于计算机技术的飞速发展,数据库技术作为数据管理的一个有效的手段,在各行各业中得到越来越广泛的应用。因此,本文围绕一个”人事管理系统”程序的设计和应用系统的开发课题为背景,详细介绍了以VB和SQLSERVER为语言编写管理信息系统的过程。该程序通过VB的ADO数据对象来实现VB前台与后台SQLSERVER数据库的连接,并具有典型的数据库应用系统的特征,完成了系统结构与现实生活的紧密结合。管理系统的开发不仅是一个应用程序编写的过程,更重要的是在系统分析和设计阶段所做的工作。该程序在设计过程中严格遵循软件工程学的方法,用分阶段的生命周期计划严格管理,并主要讲述了程序的总体设计、详细设计阶段,对程序进行需求迭代,不断修正和改进,利用SQLSERVER的强大数据库功能,直到形成一个完善的可行性系统.优美、秀丽的界面,方便实用的查询与维护功能共同构成了“人事工资管理系统”。关键词：VB，SQLSERVER，数据库，软件工程，管理信息系统哈尔滨工业大学高等教育毕业设计（论文）－－IIAbstractBecauseoftherapiddevelopmentofcomputertechnology,databasetechnologyasaneffectivemeansofdatamanagement,inallwalksoflifeareincreasinglywideapplication.Therefore,thisarticleonapersonnelmanagementsystemdesignandproceduresforapplicationsdevelopmenttopicsbackground,detailsandSQLServertoaddlanguagetotheprocessofpreparingmanagementinformationsystems.TheprocedureadoptedtoachievethetargetdataaddtheadowithVBprospectsbackgroundSQLServerdatabasesanddatabaseapplicationswithtypicalcharacteristics,andcompletedthestructureandsystemcombiningreallife.Managementsystemapplicationsdevelopmentisnotonlyapreparationprocess,butmoreimportantlyintheanalysisanddesignphasework.Theprocedurestrictlyfollowedinthedesignprocesssoftwareengineeringmethods,anduseaphasedplantomanagethelifecycleandonthemainproceduresdesigned,detaileddesignstage,thedemandforcomputationprocedures,andconstantlyrevisedandimproved,theuseofSQLServerpowerfuldatabasefunctions,Untilthefeasibilityofformingaperfectsystem.beautifulandattractiveinterfaceforpracticalinformationandthemaintenanceofthecommonfunctionsconstituteaPersonnelwagemanagementsystem.Keyword:VB，SQLSERVER，Database,SoftwareEngineering,ManagementInformationSystems哈尔滨工业大学高等教育毕业设计（论文）目录摘要................................................................................................................IAbstract..............................................................................................................II第1章绪论.......................................................................................................1第2章相关工具的基本理论...........................................................................32.1关于VB的说明.................................................................................................32.2关于管理信息系统............................................................................................32.3数据库系统概述................................................................................................42.4ADO与SQLSERVER2000...........................................................................52.4.1AxtiveX数据对象--ADO........................................................................52.4.2关于SQLSERVER2000.........................................................................5第3章系统需求分析与总体设计....................................................................63.1需求分析............................................................................................................63.2系统设计..............................................................................................................63.2.1系统功能分析.........................................................................................63.2.2数据流程图.............................................................................................83.3数据库设计........................................................................................................93.3.1数据库需求分析.....................................................................................93.3.2实体之间的E–R模型.............................................................................93.3.3数据库逻辑结构设计............................................................................103.4本章小结..........................................................................................................13第4章系统详细设计.....................................................................................144.1系统模块的具体实现......................................................................................144.1.1系统的主界面.......................................................................................144.1.2员工基本信息模块................................................................................164.1.3员工考勤模块.......................................................................................204.1.4员工评价模块.......................................................................................244.1.5员工工资管理模块................................................................................244.1.7部门管理模块.......................................................................................274.1.8系统其它功能简介................................................................................28哈尔滨工业大学高等教育毕业设计（论文）4.2本章小结..........................................................................................................29第5章系统运行与测试.................................................................................30结论..............................................................................................................31致谢..................................