搜索
FoshanUniversity本科生毕业设计（论文）“一卡通”系统建设与规划——数据库设计与实现及考勤系统学院：机电与信息工程学院专业：网络工程学号：2007394139学生姓名：袁艺康指导教师：朱玉玺（职称）二〇一一年六月I摘要随着信息时代的高速发展，越来越多的高校在积极探索着建立数字化校园，实现无纸化办公。现代化的学校离不开信息智能化的管理，学校的收费管理、教学服务、后勤服务等，也面临一次改革，基于此，我们开发了校园一卡通系统。本系统——校园一卡通系统，使用VisualBasic6.0开发，采用客户端/服务器的模型构架。数据库采用SQLServer2000来实现。本系统主要包括四种角色用户,管理员、商品销售人员、考勤管理人员、图书管理人员等，在设计过程中最大限度满足用户的要求，该系统具有较强的实用性和针对性。具有界面友好，操作简单，可维护性强等特点。本系统基本遵循了软件工程方法论进行需求分析、系统总体设计和详细设计。实现了管理员对一卡通的管理；学生用此卡可以在学校的食堂、商店进行消费，运用此卡还可以记录考勤信息以及在图书馆的借阅等。关键词：校园一卡通系统;VisualBasic6.0;SQLServer2000IICampusCardSystemConstructionandPlanningYUANYi-kangAbstractWiththerapiddevelopmentoftheinformationage,moreandmoreuniversitiesareactivelyexploringtheestablishmentofcampus,paperlessoffice.Schoolscannotdowithoutmodernintelligentinformationmanagement,managementoftheschoolfees,teachingservices,logisticsservices,isalsofacingareform,basedonthis,wedevelopedacampuscardsystem.Thesystem-thecampuscardsystem,developedusingVisualBasic6.0,theclient/serverarchitecturemodel.DatabaseusingSQLServer2000toachieve.Thissystemconsistsoffourkindsofrolestheuser,administrator,merchandisesales,attendancemanagement,librarymanagement,etc.,duringthedesignprocessaspossibletomeettheuser'srequest,thesystemhasstrongpracticalandrelevant.Hasfriendlyinterface,simpleoperation,maintainabilityandsoon.Thesystembasicallyfollowedthemethodologyofsoftwareengineering,requirementsanalysis,systemdesignanddetaileddesign.Administratorsrealizedthecardmanagement;studentscanusethiscardintheschoolcafeteria,shopforconsumption,useofthiscardcanalsorecordattendanceinformation,andborrowinthelibrary,etc..Keywords:CampusCardSystem;VisualBasic6.0;SQLServer2000III目录1.系统概述........................................................................................................................................11.1系统开发背景.........................................................................................................................11.2系统开发的目的与意义.........................................................................................................11.3国内校园卡应用情况及现状分析.........................................................................................21.4设计定义.................................................................................................................................21.5开发工具简介.........................................................................................................................22.需求分析........................................................................................................................................32.1可行性分析.............................................................................................................................32.2系统开发所面临和需要解决的主要问题.............................................................................42.3系统应该具备的基本功能.....................................................................................................52.3.1一卡通服务器..................................................................................................................52.3.2一卡通客户机..................................................................................................................53.系统总体设计................................................................................................................................53.1系统设计的原则.....................................................................................................................53.2系统设计结构图.....................................................................................................................63.3运行环境.................................................................................................................................63.4详细设计.................................................................................................................................83.4.1用户个人信息设计..........................................................................................................83.4.2数据库中表的设计..........................................................................................................84.数据库系统的实现......................................................................................................................174.1数据库服务器.......................................................................................................................174.1.1登陆界面........................................................................................................................174.1.2系统主界面....................................................................................................................174.1.3用卡管理........................................................................................................................184.1.4系统用户........................................................................................................................184.1.5卡充值............................................................................................................................204.2考勤系统的实现....................