摘要
为构建一套适用于中小规模企业的操作简便、界面友好的轻简型农产品安全生产溯源系统,采用浏览器/服务器(B/S)架构,以C#和Java作为开发语言,以MySQL和SQLite为数据库进行系统开发。利用手机照片EXIF数据、UCC/EAN-128编码、批次管理及二维码技术,设计溯源系统采集功能。结果表明,该系统包括账号管理、场地管理、农资管理、农事管理、加工管理、溯源档案管理6个功能模块,实现了农产品种植过程中土壤基础肥力及重金属含量查询,施肥、灌溉、喷药管理记录,生长过程追溯等功能。与同类系统相比,本系统为通用型溯源系统,具有溯源档案自动生成、操作简便、功能齐全和界面友好等特点,适用于蔬菜、瓜果、粮食作物、茶叶等应用对象。该系统在兰考蜜瓜、三门峡苹果、信阳茶叶等河南特色农产品上取得较好的应用效果。150多家企业入驻溯源平台,并建立较完善的溯源管理体系,实现了标准化种植管理和批次化管理。
In order to provide more convenient and effective traceability services for small and medium-sized enterprises,a simplified traceability system had been developed based on the browser/server architecture.The C#and Java were used as the development languages,and the MySQL and SQLite were used as the databases.The collection functions of the traceability system were designed by using EXIF data,UCC/EAN-128 coding,batch management and QR code technology.It had six modules used in the management of account,site,agricultural material,farmaing,processing and traceability document.It could be used for inquiring soil fertility and heavy metal content,recording fertilization,irrigation and spraying control,tracing growth process and so on.Compared with similar systems,the simplified traceability system which was a universal system suitable for vegetables,fruits,food crops,tea and so on,had the characteristics of automatic generation of traceability files,simple operation and friendly interface.This system had an excellent application in the Henan characteristic agricultural products,such as Lankao honeydew melon,Sanmenxia apple and Xinyang tea.More than 150 enterprises had used the traceability system and established a perfect management system of agricultural products,achieving standardized planting and batch management.
作者
李国强
陈丹丹
赵丰华
秦一浪
赵晴
臧贺藏
辛银平
于亚楠
郑国清
LI Guoqiang;CHEN Dandan;ZHAO Fenghua;QIN Yilang;ZHAO Qing;ZANG Hecang;XIN Yinping;YU Ya’nan;ZHENG Guoqing(Institute of Agricultural Economics and Information,Henan Academy of Agricultural Sciences,Zhengzhou 450002,China;Henan Engineering and Technology Research Center for Intelligent Agriculture,Zhengzhou 450002,China;Xinyang Academy of Agricultural Sciences,Xinyang 464000,China;Puyang Vocational and Technical College,Puyang 457000,China)
出处
《河南农业科学》
北大核心
2021年第2期173-180,共8页
Journal of Henan Agricultural Sciences
基金
河南省重点研发与推广专项(科技攻关)(192102110048,21210211038)
河南省农科院“四优四化”科技支撑行动计划项目
河南省农科院2017年“院县共建现代农业综合示范县”项目
河南省2018年财政预算示范推广项目(YCY20188111)
河南省农科院农经信息所科研助理专项(njxxsjj201905)。
关键词
农产品
安全生产
溯源系统
二维码
轻简型
智能终端
Agricultural products
Safety production
Traceability system
QR code
Simplified system
Intelligent terminal