“智能驿站”的数据库管理系统的搭建  

The Establishment of Database Management System of“Intelligent Post Station”

作　　者：魏意烽 曾令超 魏炆通 吴浩昌 潭鑫钥 詹富城 Wei Yifeng;Zeng Lingchao;Wei Wentong;Wu Haochang;Tan Xinyue;Zhan Fucheng(Guangdong Baiyun University,Guangdong Guangzhou 510450)

机构地区：[1]广东白云学院,广东广州510450

出　　处：《南方农机》2023年第4期142-146,共5页

基　　金：广东白云学院2021年度大学生创新创业训练计划项目资助“‘智能驿站’的出库快件信息系统”(S202110822012)。

摘　　要：目前,快递行业存在快递数据处理困难、快递数据更新不及时甚至出现错误等现象,从而造成了取件人无法顺利取件或者快递包裹被取错且无法找回的问题,如果包裹比较贵重,那么将会给取件人和驿站双方造成巨大的损失。基于此,课题组设计了一种基于QtCreater的SQLite3数据库系统,通过使用QtCreater中的各种组件搭建出驿站与用户之间联络的服务器与客户端,OpenCV配合树莓派读取摄像头进行人脸识别并保存照片在数据库中,并且在服务器后台加入SQLite3数据库,实现了对快递信息的储存与更新,通过服务器界面提供的各项功能,能够处理和分析快件数据。模拟客户端测试结果表明,该系统能快速解决一些在快递出站中遇到的各种问题,极大地提高了驿站的可靠性与驿站人员的工作效率,节省了时间和金钱成本,为传统驿站的创新提供了参考。At present,in the express industry,there are difficulties in processing the express data,delay in updating the express data,and even errors,which result in the problem that the pickup cannot pick up the package smoothly or the express package is taken wrongly and cannot be retrieved.If the package is expensive,it will cause huge losses to both the pickup and the courier station.Based on this,the research group designed a SQLite3 database system based on QtCreater.By using various components in QtCreater,the server and client for communication between the courier station and users were built.OpenCV cooperated with the Raspberry Pie reading camera to conduct face recognition and save photos in the database.In addition,the SQLite3 database was added to the server background to realize the storage and update of express information.It can process and analyze express data through various functions provided by the server interface.The simulation client test results show that the system can quickly solve some problems encountered in the express outbound,greatly improve the reliability of the post station and the work efficiency of the post station personnel,save time and money costs,and provide a reference for the innovation of traditional post stations.

关 键 词：数据库 Qt SQLite3 物流管理 

分 类 号：TP311.1[自动化与计算机技术—计算机软件与理论] TP391[自动化与计算机技术—计算机科学与技术]