基于RFID的教室智能考勤系统设计与实现
目 录
摘要................................................................................................................................. 4 Abstract ............................................................................................................................ 5 第一章 绪论 .................................................................................................................... 7
1.1论文的背景与意义 ............................................................................................... 7
1.2论文的目标与范围 ............................................................................................... 7 1.3论文的组织结构 ................................................................................................... 8 第二章 系统实现的相关理论基础 ................................................................................... 10
2.1 RFID技术简介................................................................................................... 10
2.1.1 系统采用 IC S50非接触式IC智能射频卡特点 .........................................11 2.1.3 射频卡读写操作关键技术及概念 .............................................................. 15 2.2 短信猫 .............................................................................................................. 18
2.2.1 MSCOMM控件介绍................................................................................. 18 2.2.2. AT指令介绍 ............................................................................................ 20 2.3 数据库知识 ....................................................................................................... 21 2.3.1 数据库系统应用 ...................................................................................... 21 2.3.2 sql server2000简介 ................................................................................... 22 2.4 系统开发工具 ................................................................................................... 23 第三章 教室智能考勤系统需求分析 ............................................................................... 25
3.1理解需求分析 .................................................................................................... 25 3.2系统概述 ........................................................................................................... 25 3.3系统用例分析 .................................................................................................... 27 3.4系统其他设计原则 ............................................................................................. 28 第四章 教室智能考勤系统概要设计 ............................................................................... 30
4.1 硬件设计 .......................................................................................................... 30
4.1.1 读卡器电路的设计 ................................................................................... 30 4.1.2 串口通信设计 .......................................................................................... 32 4.2 软件设计 .......................................................................................................... 33
4.2.1 发送信息模块的窗体结构 ........................................................................ 33 4.2.2 报表查询的窗体结构 ............................................................................... 34 4.3 数据库设计 ....................................................................................................... 34
4.3.1 数据表的建立 .......................................................................................... 34 4.3.2部分表的实体关系.................................................................................... 38
第五章 智能教室考勤系统实现及关键技术 ..................................................................... 40
5.1刷卡端程序设计 ................................................................................................. 40
5.1.1 IC卡初始化 ............................................................................................. 40
5.1.2 射频卡相关操作 ...................................................................................... 41 5.1.3 刷卡记录流程 .......................................................................................... 42 5.1.4 刷卡流水记录实现 ................................................................................... 44 5.2短信发送和接收 ................................................................................................. 45
5.2.1 短信息发送规则 ...................................................................................... 45
5.2.2 短信的解码和读取 ................................................................................... 48 5.2.3 短信发送 ................................................................................................. 50 5.2.4 短信接收 ................................................................................................. 52
5.3 系统通信程序设计 ............................................................................................ 54 5.3.1 数据通信格式 .......................................................................................... 55 5.3.2 部分通信子程序实现 ............................................................................... 56 5.4管理端程序设计 ................................................................................................. 59
5.4.1 刷卡端管理 ............................................................................................. 60
5.4.2 工作人员设置 .......................................................................................... 61 5.4.3 射频卡批量解除锁定 ............................................................................... 63 5.4.4 相关报表打印 .......................................................................................... 65 5.4.5 数据库管理 ............................................................................................. 68
第六章 总结与展望 ........................................................................................................ 70
6.1 总结 ................................................................................................................. 70 6.2 展望 ................................................................................................................. 70 参考文献........................................................................................................................ 72 致谢............................................................................................................................... 75 作者简介........................................................................................................................ 76
摘要
现今大学课堂教学考勤管理大多采用人工考勤方法，这种考勤方法耗时多，影响上课质量，信息量太少，而且考勤统计结果不易，针对缺勤结果不能第一时间发给相关责任人，存在管理盲区。因此迫切需要先进的考勤方法来解决这些问题。随着信息技术，无线识别技术、数据库技术、大规模集成电路技术的发展，在教室考勤管理中采用先进管理方式的软硬件技术条件已经成熟,结合大学教室考勤管理工作中遇到的具体情况，、在分析了当今射频IC卡技术发展及应用和移动无线通信的基础上，设计了一套教室智能考勤系统---基于RFID和GSM技术的智能教室考勤系统。
论文详细介绍了基于RFID和短信猫技术的教室智能考勤系统的设计、实现过程。系统采用C/S结构进行实施，由四部分组成：RFID刷卡模块、信息系统管理模块、短信通知预警模块、报表统计打印模块四部分组成。每个刷卡模块包括一台上位机和一台读卡器,上位机利用MSCOMM控件通过串口（RS232）和读卡器进行通信。读卡器读卡芯片选用MFRC500芯片，微处理器选用Atmel89S51。卡片初始化由发卡机完成，主要包括设置射频卡密码、控制字及初始化卡号等。信息系统管理模块设置刷卡模块运行参数，设置的参数包括：进门刷卡标志、出门刷卡标志、记录进出门时间等。短信通知预警模块，主要设置相关学生管理人员信息，提高学工管理的效率，对考勤的结果进行设置，如课程的缺席人数，姓名及时发送给相关学生管理人员，消除管理盲区；同时可以发布一些教务通知。报表统计打印模块用于教务、学工部门的日常学生考勤统计，可按教室，班级，课程，年级输出报表。系统的安全性由局域网硬件防火墙、操作系统、数据库管理系统、数据库对象四个部分组成。后台数据库采用Microsoft SQL SERVER 2000,软件部分采用Delphi 7.0开发，硬件部分采用PROTEL99SE进行设计。
论文首先介绍选题的意义，提出研究背景和研究目的；在介绍系统相关硬、软件理论基础；然后完成系统的需求分析；完成系统功能设计和硬件设计，如系统功能框架、流程图等；完成数据库的设计分析；包括数据库创建逻辑结构设计等。重点介绍系统实现的相关技术，最后对论文进行总结，提出对未来工作的展望。
关键字: RFID、短信猫、Delphi7、智能教室考勤
Abstract
Nowadays, Artificially Attendance Method is widely used in the college
classroom teaching as a kind of Attendance Management. However, it takes much time and not easy to figure out statistical results in this method which results in influencing class quality. Artificially Attendance couldn’t report to relevant principals instantly and it lacks information when fulfilling its duty. Due to manage bind on this method, new advanced method should be invented to solve these problems.With the rapid development of Information Technology, Wireless recognition technology, Database technology, large scare integrated circuit technology, employing advanced management method’s software and hardware technology in teaching management is more mature now. And now I am showing you a set of intelligent classroom system after I analyzed the development and employment of today’s frequency IC card technology and Mobile communication which is called Intelligent Classroom Attendance System based on RFID and GSM MODEM. I have combined with my research direction when doing this work and I created this system because of all kinds of problems that teachers met doing attendance management job.
This paper introduces detailed procedure of the design and implementation of Intelligent Classroom Attendance System based on RFID and GSM MODEM. This system using C/S structure for implementation and contains four modules: RFID swiping card module, information system management module, SMS notification warning module, statement statistics print module. Each swiping card module includes a set of upper computer and a reader. Upper computer communicates with reader using MSCOMM label via serial (RS232). The reader’s reading card chip chooses MFRC500 and its Microprocessor chooses Atmel89S51. Card initialization finished by hairpin machine, it mainly includes setting Radio Frequency Card password, control word and initialization card number. Information system management module sets swiping card module operation parameter which includes Door card logo,