课程设计（论文）-Delphi 7.0学校餐饮IC系统.doc

湖南农业大学课程设计报告学校餐饮IC卡系统UNIVERSITYCANTEENICCARDSESTEM学生姓名:年级专业:指导老师:学院:提交日期：2007年6月1目录前言21.需求分析····································································································31.1数据需求分析···········································································31.1.1数据字典··················································································31.1.2系统数据流图············································································51.2应用系统功能分析····································································52概要结构设计·····························································································53逻辑结构设计·····························································································74详细设计与实现··························································································74.1建立数据库和表·······································································74.2系统主窗体··············································································94.3管理员登录窗口······································································124.4办理新卡窗口··········································································154.5IC卡注销窗口·········································································204.6充值窗口··············································································2344.7管理员权限窗口······································································264.8关于系统窗口········································································3115总结·······································································································311参考文献···································································································311致谢322学校餐饮IC卡系统作者：指导老师：（湖南农业大学信息科学技术学院2005级计算机科学与技术专业3班，长沙410128）摘要：随着高校招生规模的不断扩大，学校的后勤管理变得越来越复杂，一个重要的方面就是解决学生的用餐问题。一直延续的餐票制度已经不能适应庞大的信息管理需要。引进一个信息管理系统就成为解决这一问题的迫切要求。餐饮IC卡系统是根据学生的学籍信息来发放一张IC智能卡，学生在卡上充入一定金额，就餐时进行刷卡，无现金交易，避免了工作人员找零而耽误时间。该系统具有办理新卡、IC卡挂失、IC卡充值、消费查询等功能，为工作人员和学生就餐提供了方便。关键字：餐饮IC卡、SQL2000数据库、Delphi7CANTEENICCARDSESTEMFORCAMPUSAuthor:Tutor:(ComputerandInformationEngineeringcollege,ComputerScienceandTechnologyClass3,Grade2005,HunanAgriculturalUniversity,ChangSha410128)Abstract:Withenrollmentsincollegesanduniversitiescontinuestoexpand,schoolslogisticalmanagementhasbecomeincreasinglycomplex,Animportantaspectistosolvetheproblemofmeals.Ithasextendedthemealticketsystemcannotcopewithlarge-scaleinformationmanagementneeds.Theintroductionofaninformationmanagementsystemforsolvingtheproblemisanurgentrequirement.CanteenICcardsystemisbasedontheinformationofanypupiltoreleaseanICsmartcardsstudentsonacardfilledwithacertainamountofmealswhenSwipingcardswithoutcashtransactions,avoidstaffhavesoughtandthetimewasted.Thesystemisforthenewcard,reportthelossICcard,ICcardrecharging,consumerinquiriesandotherfunctions,forstaffandstudentstoprovideaconvenientmeals.Keywords:CanteenICCard,SQL2000Server,Delphi73前言随着高校招生规模的不断扩大，学校的后勤管理变得越来越复杂，一个重要的方面就是解决学生的用餐问题。一直延续的餐票制度已经不能适应庞大的信息管理需要。引进一个信息管理系统就成为解决这一问题的迫切要求。该系统应具有办理新卡、IC卡挂失、IC卡充值、消费查询、密码修改等功能。1.需求分析1.1数据需求分析学籍信息：记录学生的基本信息，以便于办理新卡调出档案之用。包括学生姓名、学号、性别、年级、班级、专业。卡信息：卡号、金额、密码、办卡时间。卡用户信息：卡号、学号、姓名、性别、年级、专业、班级、办卡时间管理员信息：姓名、性别、出生日期、编号、密码、权限1.1.1数据字典表1卡的各项数据描述卡=卡号、学号、金额、密码，存取方式：更新表2卡用户的各项数据描述卡用户=卡号、学号、姓名、性别、年级、专业班级、办卡日期，存取方式：更新表3学籍信息的各项数据描述4学籍=学号、姓名、性别、年级、班级、专业，存取方式：更新表4用户消费的各项数据描述用户消费=卡号、学号、消费日期、消费金额，存取方式：更新表5管理员信息的各项数据描述管理员=编号、性别、姓名、密码、出生年月、是否超级管理员，存取方式：更新数据流描述1=管理员登录请求，用户名、密码，数据来源：用户输入，数据流向：在管理员信息表中查找比对数据流描述2=办理新卡，学号、卡号、密码、金额，数据来源：学籍信息表中查询结果，数据流向：将新卡信息加入到卡信息表、卡用户信息表中数据流描述3=撤销卡，卡号、卡用户表信息，数据来源：在卡信息表和卡用户信息表中与对应卡号相关的信息，数据流向：去除学籍信息表以外的其他表中与被撤销卡卡号相对应的信息51.1.2系统数据流图1.2应用系统功能分析图2系统功能模块2概要结构设计图3学生信息实体E-R图办理新卡1帐号2检验3登录4系统使用者核对信息判断是否存在用户权限信息检验问题判断是否符合条件依据权限操作系统管理员普通用户图1系统数据流图姓名性别年级专业学号学生餐饮IC卡系统IC卡注销IC卡充值管理员权限6图4卡用户实体信息E-R图图5管理员实体信息E-R图图6IC卡实体信息E-R图金额学号密码IC卡卡号卡用户卡号姓名性别班级专业年级办卡日学号管理员编号姓名性别密码出生年月是否超级用户