基于混合移动开发模式的监考自动提醒系统设计

Automatic Reminder System Development Model Based on the Hybrid Mobile

本文针对以Excel等文本格式存储的监考安排不便于教师实时查询及自动提醒等问题,设计实现了基于混合移动开发模式的监考自动提醒系统。该设计的基本思想是:将文本数据转存入数据库,然后利用Linux的自动处理事务功能定期读取数据库,实现对监考老师的当天监考自动提醒功能。系统采用JQuery+HTML5+Think PHP实现。首先编写脚本程序对文本数据进行逐行扫描和空值处理,统一数据结构;根据文本结构设计数据库,将数据转入数据库中,构建视图和存储过程实现有效数据的选取;然后配置Linux系统的Crontab任务定时扫描数据库,对当天有监考任务的教师通过阿里云SDK和SMTP协议分别实现短信和电子邮件提醒。系统设计可以较好的实现不同存储格式的文本数据在数据库的有效融合和统一,系统同时提供用户自定义监考信息的输入和查询,可用于学校的监考信息管理和定时信息提醒。

In order to solve the problems that the invigilation arrangements stored in text formats like excel cannot allow query in real time and automatic reminder,an automatic examination system is designed and implemented in this paper. The basic idea of the design is to transfer the text data into the database,and then use the Linux to automatically deal with the function of the transaction to read the database on a regular basis. The system uses JQuery＋HTML5＋Think PHP to realize. Firstly,script is written to achieve the progressive scanning and null processing of text data; the data is transfered into database according to the unified data structure; views and stored procedures are constructed to achieve selection of valid data; then the Linux system Crontab task timing scan database is configured,thus teachers charged with the invigilation task will be informed respectively with SMS and email through Ali cloud SDK and SMTP protocol. The system design can be achieved in different storage format of text data in effective integration and unity. The system also provides input and query of user-defined monitoring information,which can be used for school supervision information management and regular information reminder.