河南农业科学 ›› 2021, Vol. 50 ›› Issue (2): 173-180.DOI: 10.15933/j.cnki.1004-3268.2021.02.022

• 农业信息与工程·农产品加工 • 上一篇    

基于智能终端的轻简型农产品安全生产溯源系统构建与应用

李国强1,2,陈丹丹1,赵丰华3,秦一浪1,赵晴1,臧贺藏1,辛银平1,于亚楠4,郑国清1,2   

  1. (1.河南省农业科学院 农业经济与信息研究所,河南 郑州 450002;2.河南省智慧农业工程技术研究中心,河南 郑州 450002;3.信阳市农业科学院,河南 信阳 464000;4.濮阳职业技术学院,河南 濮阳 457000)
  • 收稿日期:2020-05-20 出版日期:2021-02-15 发布日期:2021-02-15
  • 通讯作者: 郑国清(1964-),男,河南淅川人,研究员,博士,主要从事农业信息技术研究。E-mail:zgqzx@hnagri.org.cn
  • 作者简介:李国强(1984-),男,河南林州人,副研究员,博士,主要从事农业信息技术研究。E-mail:hnagri@qq.com
  • 基金资助:
    河南省重点研发与推广专项(科技攻关)(192102110048,21210211038);河南省农科院“四优四化”科技支撑行动计划项目;河南省农科院2017年“院县共建现代农业综合示范县”项目;河南省2018年财政预算示范推广项目(YCY20188111);河南省农科院农经信息所科研助理专项(njxxsjj201905)

Construction and Application of Simplified Traceability System for Production Safety of Agricultural Products Based on Intelligent Terminal

LI Guoqiang1,2,CHEN Dandan1,ZHAO Fenghua3,QIN Yilang1,ZHAO Qing1,ZANG Hecang1,XIN Yinping1,YU Ya’nan4,ZHENG Guoqing1,2   

  1. (1.Institute of Agricultural Economics and Information,Henan Academy of Agricultural Sciences,Zhengzhou 450002,China;2.Henan Engineering and Technology Research Center for Intelligent Agriculture,Zhengzhou 450002,China;3.Xinyang Academy of Agricultural Sciences,Xinyang 464000,China;4.Puyang Vocational and Technical College,Puyang 457000,China)
  • Received:2020-05-20 Published:2021-02-15 Online:2021-02-15

摘要: 为构建一套适用于中小规模企业的操作简便、界面友好的轻简型农产品安全生产溯源系统,采用浏览器/服务器(B/S)架构,以C#和Java作为开发语言,以MySQL和SQLite为数据库进行系统开发。利用手机照片EXIF数据、UCC/EAN-128编码、批次管理及二维码技术,设计溯源系统采集功能。结果表明,该系统包括账号管理、场地管理、农资管理、农事管理、加工管理、溯源档案管理6个功能模块,实现了农产品种植过程中土壤基础肥力及重金属含量查询,施肥、灌溉、喷药管理记录,生长过程追溯等功能。与同类系统相比,本系统为通用型溯源系统,具有溯源档案自动生成、操作简便、功能齐全和界面友好等特点,适用于蔬菜、瓜果、粮食作物、茶叶等应用对象。该系统在兰考蜜瓜、三门峡苹果、信阳茶叶等河南特色农产品上取得较好的应用效果。150多家企业入驻溯源平台,并建立较完善的溯源管理体系,实现了标准化种植管理和批次化管理。

关键词: 农产品, 安全生产, 溯源系统, 二维码, 轻简型, 智能终端

Abstract: 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.

Key words: Agricultural products, Safety production, Traceability system, QR code, Simplified system, Intelligent terminal

中图分类号: