出口食品现代化管理系统的开发及应用研究
摘要
近年来,由于食品安全质量事件不断发生,每个国家为了维护自己的利益,保障进口食品的安全,对进口食品的质量要求有所提高。我国作为食品农产品出口大国,食品农产品质量问题受到出口贸易国的高度关注,逐渐加大了对我国出口食品的检测力度,对我国出口食品的质量提出了严格要求,在检测的过程中也发现了食品中存在的一些质量问题。问题的发生反映出目前我国食品农产品检验检疫管理系统的不足和存在的缺陷,为全面提升出口食品农产品质量管理水平,适应出口食品农产品对外贸易发展的新形势的需要,迫切需要建立新的出口食品农产品质量安全现代化监管体系。
本文是关于出口食品安全现代化管理系统的需求分析及开发过程。开发过程中该课题首次综合运用移动电脑终端(PDA)、全球定位系统(GPS)、网络电子地图(GIS)、网络模型库等先进科技手段,建立了检验检疫监管、检务放行、企业管理、海外客户查询四个端口,设置了基地管理、追溯管理、预警管理、统计分析等24个管理模块,实现了出口食品从种植(养殖)、加工、检验、追溯、储运到国外销售的全过程质量安全检验,解决了对基地不能有效监控、产品质量追溯不到位、监管缺失等出口食品质量安全管理多年来未能解决的一系列难题,提高了监管有效性、有效打击“涉检”违法违规行为、对残留监控、预警情况实时通报、还有完善的统计分析为领导决策提供支持。
针对系统用户的需求,本文从出口食品安全监管的实际需求出发对系统的总体设计及实现进行了描述。在系统的架构设计过程中我们采用MVC分层结构分别对功能及技术架构进行了描述,根据系统的架构设计对系统数据库进行了设计,并对系统各功能模块进行了模块化设计,文章最后详细描述了系统各功能模块的实现过程并给出了关键代码。在系统的具体实现中,我们采用集主机终端和客户端浏览器/web Server/数据库服务器方式为一体的新的应用模式进行设计,联合使用DAO模式和业务代理模式,从而提高数据持久化层、模型层和Web应用层之间的相互独立性,使得系统的维护和扩展更加方便,在安全方面,采用身份验证、权限等技术来保护网络与系统的安全。
该系统是在以Windows7为系统平台,以Myeclipse为开发平台的开发环境中进行开发的,开发过程中采用先进的JSP技术,Struts框架,并基于B/S架构实现,数据库使用SQLServer2005,系统使用方便、可伸缩性好、与相关软件集成程度高。
In recent years, the quality problems of food occur frequently, and many countries raise the access threshold for imports food and agricultural products gradually in order to safeguard national interests and food safety. China is a major exporter of food and agricultural products, and the quality of food was agreat concern in the country exports. They gradually increased the intensity of inspection about our export food, so we need to improve the quality of exporting products. In the process of test we found some existing quality problems of food. The occurrence of the problem of food reflects the current management system of food inspection and quarantine has deficiencies and defects. For the comprehensive enhance the export of food quality management and adapt to the new situation of exporting food, we need to create a new modern regulatory system about exporting food quality and safety.
This paper is the process of demand analysis and development about export food safety management system. In the developing process, this article first makes comprehensive use of PDA, GPS, GIS, network model database, and other advanced technology. We establish inspection and quarantine supervision, prosecution release, enterprise management, overseas customer queries four ports, and set the base management, traceability management, early warning management, statistical analysis altogether 24 management modules. And we achieve the whole process of quality and safety inspection about export food cultivation (farming), processing, testing, tracing, storage and transportation to the foreign and sales, and it solved problems about export food quality and safety management failed to resolve over the years, such as cannot effectively control the base, tracing product quality not in place, and lack of supervision, etc. It improves the effectiveness of supervision, real-time notification the residue monitoring and early warning situation, and there is sound statistical analysis to provide for leadership's decision-making.
According to the needs of system users, this paper describes the process of system design and implementation from the actual needs of enterprise management. We use MVC hierarchy to design functional architecture and technical architecture, and we complete the design of database tables, and analysis and model the function models. Finally, this paper describes the implementation of the system function modules. In the implementation of the system, we build a new applications model of host computer and client browser/ web server/database server, and uses DAO and business agent pattern to improve the independence of data persistence layer, model layer and Web application layer making system maintenance and expansion easier. In the security terms, we use authentication and permissions to protect the network and system.
The system is developed based on windows7, and the development platform we use Myeclipse, and in the development process we use JSP technologies, and the Struts framework as the development frame, and B/S multi-layer architecture. We use SQLServer2005 as the system database, which is easy to use and better integration with software.
本文是关于出口食品安全现代化管理系统的需求分析及开发过程。开发过程中该课题首次综合运用移动电脑终端(PDA)、全球定位系统(GPS)、网络电子地图(GIS)、网络模型库等先进科技手段,建立了检验检疫监管、检务放行、企业管理、海外客户查询四个端口,设置了基地管理、追溯管理、预警管理、统计分析等24个管理模块,实现了出口食品从种植(养殖)、加工、检验、追溯、储运到国外销售的全过程质量安全检验,解决了对基地不能有效监控、产品质量追溯不到位、监管缺失等出口食品质量安全管理多年来未能解决的一系列难题,提高了监管有效性、有效打击“涉检”违法违规行为、对残留监控、预警情况实时通报、还有完善的统计分析为领导决策提供支持。
针对系统用户的需求,本文从出口食品安全监管的实际需求出发对系统的总体设计及实现进行了描述。在系统的架构设计过程中我们采用MVC分层结构分别对功能及技术架构进行了描述,根据系统的架构设计对系统数据库进行了设计,并对系统各功能模块进行了模块化设计,文章最后详细描述了系统各功能模块的实现过程并给出了关键代码。在系统的具体实现中,我们采用集主机终端和客户端浏览器/web Server/数据库服务器方式为一体的新的应用模式进行设计,联合使用DAO模式和业务代理模式,从而提高数据持久化层、模型层和Web应用层之间的相互独立性,使得系统的维护和扩展更加方便,在安全方面,采用身份验证、权限等技术来保护网络与系统的安全。
该系统是在以Windows7为系统平台,以Myeclipse为开发平台的开发环境中进行开发的,开发过程中采用先进的JSP技术,Struts框架,并基于B/S架构实现,数据库使用SQLServer2005,系统使用方便、可伸缩性好、与相关软件集成程度高。
In recent years, the quality problems of food occur frequently, and many countries raise the access threshold for imports food and agricultural products gradually in order to safeguard national interests and food safety. China is a major exporter of food and agricultural products, and the quality of food was agreat concern in the country exports. They gradually increased the intensity of inspection about our export food, so we need to improve the quality of exporting products. In the process of test we found some existing quality problems of food. The occurrence of the problem of food reflects the current management system of food inspection and quarantine has deficiencies and defects. For the comprehensive enhance the export of food quality management and adapt to the new situation of exporting food, we need to create a new modern regulatory system about exporting food quality and safety.
This paper is the process of demand analysis and development about export food safety management system. In the developing process, this article first makes comprehensive use of PDA, GPS, GIS, network model database, and other advanced technology. We establish inspection and quarantine supervision, prosecution release, enterprise management, overseas customer queries four ports, and set the base management, traceability management, early warning management, statistical analysis altogether 24 management modules. And we achieve the whole process of quality and safety inspection about export food cultivation (farming), processing, testing, tracing, storage and transportation to the foreign and sales, and it solved problems about export food quality and safety management failed to resolve over the years, such as cannot effectively control the base, tracing product quality not in place, and lack of supervision, etc. It improves the effectiveness of supervision, real-time notification the residue monitoring and early warning situation, and there is sound statistical analysis to provide for leadership's decision-making.
According to the needs of system users, this paper describes the process of system design and implementation from the actual needs of enterprise management. We use MVC hierarchy to design functional architecture and technical architecture, and we complete the design of database tables, and analysis and model the function models. Finally, this paper describes the implementation of the system function modules. In the implementation of the system, we build a new applications model of host computer and client browser/ web server/database server, and uses DAO and business agent pattern to improve the independence of data persistence layer, model layer and Web application layer making system maintenance and expansion easier. In the security terms, we use authentication and permissions to protect the network and system.
The system is developed based on windows7, and the development platform we use Myeclipse, and in the development process we use JSP technologies, and the Struts framework as the development frame, and B/S multi-layer architecture. We use SQLServer2005 as the system database, which is easy to use and better integration with software.
引文
[1]马泽斌.GIS技术在河北省无公害农产品信息管理中的应用,河北遥感.2006卷1期
[2]赵波谢如鹤.基于GIS的仿真技术在食品物流安全管理中的应用框架研究,农业网络信息.2007卷5期
[3]采用国际管理标准增强食品出口产品竞争力,上海标准化.2002卷4期
[4]蔡衍山.西峡标准化香菇生产基地管理和产品可追溯体系,国际农产品贸易.2007卷2期
[5]陈天河,《Eclipse, Struts, Hibernate, Spring集成开发宝典》,北京-电子工业出版社
[6]Paul R. Reed, Jr.,《JAVA与UML协同应用开发》,清华大学出版社
[7]Elliotte Rusty Harold, 《JAVA网络编程》,中国电力出版社
[8]Wendy Boggs, Michael Boggs.,《UML与Rational Rose2002从入门到精通》,北京：电子工业出版社
[9]孙卫琴,《精通Struts:基于MVC的Java Web设计与开发》,电子工业出版社
[10]Martin Fowler.,王怀民,周斌译,《企业应用架构模式》,北京：机械工业出版社
[11]夏昕,曹晓刚,唐勇,《深入浅出Hibernate》,北京：电子工业出版社
[12]孙卫琴,李洪成,《TOMCAT与JAVA WEB开发技术详解》,电子科技出版社
[13]武延军,《精通JSP编程技术》,人民邮电出版社
[14]雨阳隆春,《深入JSP网络编程》,清华大学出版社
[15]杨珏,卢银娟,赵昊彤,《JSP网络开发技术》,人民邮电出版社
[16]吴其庆,《JSP编程思想与实践》,冶金工业出版社
[17]Murray Cantor使用UML进行面向对象的项目管理,人民邮电出版社
[18]王诚梅,袁然,王艳,JSP案例开发集锦,电子工业出版社
[19]Evelyn Stiller Cathie LeBlanc,基于项目的软件工程,机械工业出版社
[20]Paul C Jorgensen.软件测试.北京：机械工业出版社,2004：145-150
[21]陆新年,陆新宇等.XML揭秘--入门应用精通.北京：清华大学出版社,2001：74-90
[22]郑淑芬.电子商务整合方案实战.北京：北京科海,2002：5-14,24-33
[23]陈佳.信息系统开发方法教程.北京：清华大学出版社,1995：105-107
[24]Sami Zahran著.软件过程改进.北京：机械工业出版社,2002：19-39
[25]段念软件性能测试过程详解与案例剖析北京：清华大学出版社,2006。
[26]《系统分析与设计》,John W. Satzinger, Robert B. Jackson, Stephen D. Burd
[27]《软件需求管理统一方法》,Dean Leffingwell, Don Widrig
[28]He Yong; Deng Xunfei; Shao Yongni; Fang Hui Study on farmland information management model integrated with GSM and a web-based GIS,Proceedings of the World Congress on Intelligent Control and Automation(WCICA) Abbreviated
[29]Dick Puurveen; Jeff Thurston.GPS and GIS Applications in Research,Station Management.
[30]U.S.Food Exports:Five Countries' Standards and Procedures for Testing Pesticide Residues
[31]Okello J.J; Swinton,S.M.; Compliance with internationl food safety standards in Kenya's green bean industry:comparison of a small-and a large-scale farm producing for export.Review of Agricultural Economics.2007,29(2) 269-285.
[32]Henchion,M.; O'Reilly,P.;ect.Increasing the logistics efficiency of Irish food exports.1999,18pp
[33]Scheuplein R J,An analysis of the safety of Indian food exports:the quest for international food safety equivalence;Indian Food Industry (November-December), 1999,18(6),364-381
[34]Food import and export inspection and certification systems;Codex Alimentarius Commission.2007
[35]HANSFORD,PETER;GROWING GREAT GUNS.(food exports among Asian countries)(Brief Article)(Statistical Data Included);Business Aisa,June,2000
[2]赵波谢如鹤.基于GIS的仿真技术在食品物流安全管理中的应用框架研究,农业网络信息.2007卷5期
[3]采用国际管理标准增强食品出口产品竞争力,上海标准化.2002卷4期
[4]蔡衍山.西峡标准化香菇生产基地管理和产品可追溯体系,国际农产品贸易.2007卷2期
[5]陈天河,《Eclipse, Struts, Hibernate, Spring集成开发宝典》,北京-电子工业出版社
[6]Paul R. Reed, Jr.,《JAVA与UML协同应用开发》,清华大学出版社
[7]Elliotte Rusty Harold, 《JAVA网络编程》,中国电力出版社
[8]Wendy Boggs, Michael Boggs.,《UML与Rational Rose2002从入门到精通》,北京：电子工业出版社
[9]孙卫琴,《精通Struts:基于MVC的Java Web设计与开发》,电子工业出版社
[10]Martin Fowler.,王怀民,周斌译,《企业应用架构模式》,北京：机械工业出版社
[11]夏昕,曹晓刚,唐勇,《深入浅出Hibernate》,北京：电子工业出版社
[12]孙卫琴,李洪成,《TOMCAT与JAVA WEB开发技术详解》,电子科技出版社
[13]武延军,《精通JSP编程技术》,人民邮电出版社
[14]雨阳隆春,《深入JSP网络编程》,清华大学出版社
[15]杨珏,卢银娟,赵昊彤,《JSP网络开发技术》,人民邮电出版社
[16]吴其庆,《JSP编程思想与实践》,冶金工业出版社
[17]Murray Cantor使用UML进行面向对象的项目管理,人民邮电出版社
[18]王诚梅,袁然,王艳,JSP案例开发集锦,电子工业出版社
[19]Evelyn Stiller Cathie LeBlanc,基于项目的软件工程,机械工业出版社
[20]Paul C Jorgensen.软件测试.北京：机械工业出版社,2004：145-150
[21]陆新年,陆新宇等.XML揭秘--入门应用精通.北京：清华大学出版社,2001：74-90
[22]郑淑芬.电子商务整合方案实战.北京：北京科海,2002：5-14,24-33
[23]陈佳.信息系统开发方法教程.北京：清华大学出版社,1995：105-107
[24]Sami Zahran著.软件过程改进.北京：机械工业出版社,2002：19-39
[25]段念软件性能测试过程详解与案例剖析北京：清华大学出版社,2006。
[26]《系统分析与设计》,John W. Satzinger, Robert B. Jackson, Stephen D. Burd
[27]《软件需求管理统一方法》,Dean Leffingwell, Don Widrig
[28]He Yong; Deng Xunfei; Shao Yongni; Fang Hui Study on farmland information management model integrated with GSM and a web-based GIS,Proceedings of the World Congress on Intelligent Control and Automation(WCICA) Abbreviated
[29]Dick Puurveen; Jeff Thurston.GPS and GIS Applications in Research,Station Management.
[30]U.S.Food Exports:Five Countries' Standards and Procedures for Testing Pesticide Residues
[31]Okello J.J; Swinton,S.M.; Compliance with internationl food safety standards in Kenya's green bean industry:comparison of a small-and a large-scale farm producing for export.Review of Agricultural Economics.2007,29(2) 269-285.
[32]Henchion,M.; O'Reilly,P.;ect.Increasing the logistics efficiency of Irish food exports.1999,18pp
[33]Scheuplein R J,An analysis of the safety of Indian food exports:the quest for international food safety equivalence;Indian Food Industry (November-December), 1999,18(6),364-381
[34]Food import and export inspection and certification systems;Codex Alimentarius Commission.2007
[35]HANSFORD,PETER;GROWING GREAT GUNS.(food exports among Asian countries)(Brief Article)(Statistical Data Included);Business Aisa,June,2000