武汉科技大学本科毕业论文摘要随着计算机技术的飞速发展,作为数据管理的一个有效的手段的数据库技术,在各行各业中得到越来越广泛的应用。因此,本文围绕一个“餐厅工资管理系统”的程序设计和应用开发课题为背景,详细介绍了VB和SQLSERVER编写管理信息系统的过程。该程序使用ADO数据对象访问技术来实现对数据库的访问,具有典型的数据库应用系统的特征。本系统实现了人事管理人员对员工工资自动生成信息的浏览、添加、修改和查询功能，能够完成对餐厅员工当月工资的结算，节省了大量的人工操作的工作量，自动完成众多的信息处理，减少了数据出现错误的概率，增强了工资记录的安全性和完整性。关键词:VB；SQLSERVER；数据库；工资管理系统；自动生成1武汉科技大学本科毕业论文AbstractWiththerapiddevelopmentofcomputertechnology,datamanagementasaneffectivemeansofdatabasetechnology,inallwalksoflifetobemoreandmorewidely.Therefore,thisarticlecenteredarounddesignandapplicationdevelopmentof“Restaurantwagemanagementsystem”astopicsbackground,detailstheprocessofpreparinginformationmanagementsystemwithVBandSQLServer.TheprogramusesADOdataaccesstechnologytoachievethetargetofdatabaseaccess,withthetypicalcharacteristicsofadatabaseapplicationsystem.Thesystemcanview,add,modify,andqueryinformationonstaffsalaryautomaticallygeneratedforpersonnelmanagers.Itcanbecompletedmonthofwagestoemployeesoftheclearing,savealotoftheworkloadofmanual,automaticcompletionofalargenumberofinformationprocessing,reduceddataerrorschancetostrengthenthepayrollrecordsofthesecurityandintegrity.Keywords：VB;SQLSERVER;Database;SalaryManagementSystem;Automaticallygenerated2武汉科技大学本科毕业论文目录目录.................................................................................................................................3第一章系统开发概述...................................................................................................41.1开发背景..........................................................................................................41.2本系统的目标..................................................................................................5第二章系统开发平台...................................................................................................62.1VisualBasic开发工具.................................................................................62.2关系数据库操作语言SQL简介......................................................................82.2.1SQL的语句............................................................................................92.2.2SQL中的数据操作................................................................................92.3VisualBasic访问SQLServer数据库........................................................102.3.1ADO数据访问技术简介..........................................................................102.3.2ADO提供执行的操作..............................................................................112.3.3ADO连接数据库的基本流程.............................................................12第三章系统设计.........................................................................................................133.1系统功能描述................................................................................................133.2功能模块划分................................................................................................153.3系统流程分析.......................................................
