CN103426095A - Agricultural product source-tracing query method based on android platform - Google Patents

Agricultural product source-tracing query method based on android platform Download PDF

Info

Publication number
CN103426095A
CN103426095A CN2013103886575A CN201310388657A CN103426095A CN 103426095 A CN103426095 A CN 103426095A CN 2013103886575 A CN2013103886575 A CN 2013103886575A CN 201310388657 A CN201310388657 A CN 201310388657A CN 103426095 A CN103426095 A CN 103426095A
Authority
CN
China
Prior art keywords
verification code
material product
agricultural material
unique verification
android
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CN2013103886575A
Other languages
Chinese (zh)
Inventor
马超
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Jiangsu IoT Research and Development Center
Original Assignee
Jiangsu IoT Research and Development Center
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Jiangsu IoT Research and Development Center filed Critical Jiangsu IoT Research and Development Center
Priority to CN2013103886575A priority Critical patent/CN103426095A/en
Publication of CN103426095A publication Critical patent/CN103426095A/en
Pending legal-status Critical Current

Links

Images

Landscapes

  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The invention provides an agricultural product source-tracing query method based on an android platform. The agricultural product source-tracing query method comprises the following steps that an unique verification code of an agricultural product is input to an android terminal; whether a record corresponding to the unique verification code exists in an S1lite database which is arranged in the android terminal or not is queried; whether the android terminal has an access to the internet or nor is detected; the android terminal sends a query request to a target server and the server queries whether the record corresponding to the unique verification code exists in an agricultural database or not according to the query request; the verification code and corresponding data information are added into the SQlite database which is arranged in the android terminal; and the data information corresponding to the unique verification code is displayed on the android terminal. By means of the agricultural product source-tracing query method based on the android platform, the data information of the agricultural product can be queried conveniently, quickly and effectively, user experience is good, and an off-line query method is provided.

Description

Agricultural material product based on the android platform querying method of tracing to the source
Technical field
The present invention relates to a kind of source tracing method, especially a kind of agricultural material product based on android platform querying method of tracing to the source.
Background technology
But traceability system can be applicable to all trades and professions at present.Soon, before, due to the appearance of some counterfeit money, but People's Bank of China also announces the message that the traceability system about Renminbi also will start, and can inquire about at any time the production current intelligence of Renminbi.And bread is the staff of life, no matter be government or the public, for food security, always attach great importance to.Because no matter be external rabid ox disease, aftosa, or the melamine of domestic outburst, the safety problems such as the microbiotic in the food safety affair such as tonyred and agricultural product and hormone residues event have all caused global extensive concern.
And the source of agricultural product is agricultural material products, as seed, chemical fertilizer, feed etc., the quality safety of these agricultural material products is the most important thing especially.But the traceability system for agricultural material product has just become a very urgent global task.
Due to the consumer need to want anywhere or anytime to understand agricultural material product from producing to a series of situation of selling, but the traceability system of traditional B/S framework must obtain necessary supplementing due to characteristics such as laptop computer poor mobility.
And, along with intelligent terminal, the particularly development of China's smart mobile phone and universal, make intelligent terminal can inquire about anywhere or anytime and become possibility in the agricultural material product traceability system.Due to smart mobile phone, particularly the special circumstances of the smart mobile phone based on the android platform, be inappropriate so the content on the website of B/S framework is transplanted to mobile phone terminal fully.Must be according to the characteristic of mobile phone terminal oneself, redesign.
Summary of the invention
The object of the present invention is to provide a kind of agricultural material product based on android platform querying method of tracing to the source, can convenient and swift and effectively be inquired about the data message (comprising the place of production, current intelligence and point of sale etc.) of agricultural material product.The technical solution used in the present invention is:
A kind of agricultural material product based on android platform querying method of tracing to the source comprises the following steps:
A. to the unique verification code of input agricultural material product in the android terminal;
B. inquire about in the built-in SQlite database of android terminal whether have record corresponding to this unique verification code, if exist, directly inquire about and show the data message that this unique verification code is corresponding; If do not exist, enter step c;
Whether can accessing Internet, if can't access, prompting can't be inquired about if c. detecting the android terminal; If can access, enter steps d;
The d.android terminal sends inquiry request to destination server, comprises the agricultural material product unique verification code in this inquiry request; Server goes means of agricultural production data base querying whether to have record corresponding to this unique verification code according to inquiry request, if do not exist, returning to this agricultural material product may be the information of personation; If exist and to the android terminal, return data message corresponding to this unique verification code, and enter step e;
E. this identifying code and corresponding data message are added in the built-in SQlite database of android terminal;
F. by this unique verification code, corresponding data message shows in the android terminal.
Further, in described step a, to the unique verification code of input agricultural material product in the android terminal, the method for input comprises following three kinds:
A-1, by the Quick Response Code on the scanning agricultural material product, and resolve by the input parsing module unique verification code that above-mentioned Quick Response Code obtains this agricultural material product;
A-2, read the unique verification code on agricultural material product by voice, and identify the unique verification code of this agricultural material product by speech recognition software in the android terminal;
A-3 directly inputs the unique verification code on agricultural material product in the android terminal.
Further, in described step b and step f, while in data message corresponding to described this unique verification code, comprising geography information, in conjunction with electronic chart, graphically show.
Further, describedly in conjunction with electronic chart, graphically show, the content of demonstration comprises the place of production of agricultural material product, current intelligence and point of sale.
Described android terminal adopts the mobile phone of the above system of android2.3.
The present invention has following advantage:
1). while having avoided the long identifying code of traditional approach input, poor user experiences, and has proposed the inquiry input of diversification, can be Quick Response Code scanning input, phonetic entry or directly input.
2). avoided in the situation that the unstable even suspension of cell phone network, the situation that the user can't inquire about, proposed the offline search method, allows the user under off-line state, the historical record of looking into before still can inquiring about.
3). on bandwagon effect, in conjunction with the convenience of android platform, use built-in electronic chart, make the user can on Google Map, with patterned pattern, check the information such as the place of production, current intelligence and point of sale of the agricultural material product of being inquired about.
The accompanying drawing explanation
Fig. 1 is that structure of the present invention forms schematic diagram.
Fig. 2 is the embodiments of the invention process flow diagram.
Embodiment
Below in conjunction with concrete drawings and Examples, the invention will be further described.
This agricultural material product querying method of tracing to the source utilizes the android mobile phone as the android client.
As shown in Figure 1, the android cell-phone customer terminal comprises the input media for input, as the microphone for phonetic entry, camera for scanning Quick Response Code, keyboard (or the dummy keyboard on touch-screen) etc.For the Quick Response Code of scanning input, the android mobile phone obtains unique verification code by the input parsing module to resolve Quick Response Code.Display module is for showing various data and the information of android mobile phone.Built-in SQlite database in the android mobile phone, the advantage such as the SQlite database is lightweight, Embedded, relevant database, and it has portable good, easily uses, and takies resource seldom, efficient and reliable.In the android mobile phone at present common configuration GPS module and electronic chart (as Google MAP etc.).
Carry out the agricultural material product inquiry of tracing to the source, also need to set up server end and corresponding means of agricultural production database as shown in Figure 1.Store all agricultural material product of inquiry and unique verification code of each agricultural material product of needing in means of agricultural production database.
Below in conjunction with Fig. 1 and Fig. 2, the agricultural material product based on the android platform proposed by the invention querying method of tracing to the source is done and illustrated.
The first step: face the external packing of the agricultural material product (as agricultural chemicals, chemical fertilizer etc.) that posts (or being printed on) Quick Response Code and unique verification code, open the android mobile phone, direct input validation code, but the identifying code figure place is more usually, inputs cumbersome and easily inputs by mistake.If speech recognition software is housed in mobile phone, can reads the unique verification code on agricultural material product by voice, and identify the unique verification code of this agricultural material product by speech recognition software in the android mobile phone.Another mode is the scanning Quick Response Code, and resolves by the input parsing module unique verification code that above-mentioned Quick Response Code obtains this agricultural material product.
Second step: in the SQlite database of inquiry android embedded in mobile phone, whether have record corresponding to this unique verification code, if exist, directly inquire about and show the data message that this unique verification code is corresponding, while in this data message, comprising geography information, can graphically show in conjunction with Google Map; If there be not record corresponding to unique verification code in the SQlite database, enter the 3rd step.
The 3rd step: whether can accessing Internet, if can't access, prompting can't be inquired about if detecting the android mobile phone; If can access, enter the 4th step.
The 4th step: the android mobile phone sends the HTTP inquiry request to destination server, comprises the agricultural material product unique verification code in this inquiry request; Server goes means of agricultural production data base querying whether to have record corresponding to this unique verification code according to inquiry request, if do not exist, returning to this agricultural material product may be the information of personation; If exist and to the android mobile phone, return data message corresponding to this unique verification code, and enter the 5th step.
The 5th step: this identifying code and corresponding data message are added in the SQlite database of android embedded in mobile phone; This also is to provide the important step of offline search.
The 6th step: the data message that this unique verification code is corresponding shows on the android mobile phone, and while in this data message, comprising geography information, in conjunction with Google Map, graphically shows.
Carry out in conjunction with Google Map the place of production, current intelligence and the point of sale etc. that the graphical content shown comprises agricultural material product.

Claims (5)

1. the agricultural material product based on the android platform querying method of tracing to the source, is characterized in that, comprises the following steps:
A. to the unique verification code of input agricultural material product in the android terminal;
B. inquire about in the built-in SQlite database of android terminal whether have record corresponding to this unique verification code, if exist, directly inquire about and show the data message that this unique verification code is corresponding; If do not exist, enter step c;
Whether can accessing Internet, if can't access, prompting can't be inquired about if c. detecting the android terminal; If can access, enter steps d;
The d.android terminal sends inquiry request to destination server, comprises the agricultural material product unique verification code in this inquiry request; Server goes means of agricultural production data base querying whether to have record corresponding to this unique verification code according to inquiry request, if do not exist, returning to this agricultural material product may be the information of personation; If exist and to the android terminal, return data message corresponding to this unique verification code, and enter step e;
E. this identifying code and corresponding data message are added in the built-in SQlite database of android terminal;
F. by this unique verification code, corresponding data message shows in the android terminal.
2. the agricultural material product based on the android platform as claimed in claim 1 querying method of tracing to the source is characterized in that: in described step a, to the unique verification code of input agricultural material product in the android terminal, the method for input comprises following three kinds:
A-1, by the Quick Response Code on the scanning agricultural material product, and resolve by the input parsing module unique verification code that above-mentioned Quick Response Code obtains this agricultural material product;
A-2, read the unique verification code on agricultural material product by voice, and identify the unique verification code of this agricultural material product by speech recognition software in the android terminal;
A-3 directly inputs the unique verification code on agricultural material product in the android terminal.
3. the agricultural material product based on the android platform as claimed in claim 1 querying method of tracing to the source, it is characterized in that: in described step b and step f, while in data message corresponding to described this unique verification code, comprising geography information, in conjunction with electronic chart, graphically show.
4. the agricultural material product based on the android platform as claimed in claim 3 querying method of tracing to the source is characterized in that: describedly in conjunction with electronic chart, graphically show, the content of demonstration comprises the place of production of agricultural material product, current intelligence and point of sale.
5. the agricultural material product based on the android platform as claimed in claim 1 or 2 querying method of tracing to the source, it is characterized in that: described android terminal adopts the mobile phone of the above system of android2.3.
CN2013103886575A 2013-08-30 2013-08-30 Agricultural product source-tracing query method based on android platform Pending CN103426095A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN2013103886575A CN103426095A (en) 2013-08-30 2013-08-30 Agricultural product source-tracing query method based on android platform

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN2013103886575A CN103426095A (en) 2013-08-30 2013-08-30 Agricultural product source-tracing query method based on android platform

Publications (1)

Publication Number Publication Date
CN103426095A true CN103426095A (en) 2013-12-04

Family

ID=49650797

Family Applications (1)

Application Number Title Priority Date Filing Date
CN2013103886575A Pending CN103426095A (en) 2013-08-30 2013-08-30 Agricultural product source-tracing query method based on android platform

Country Status (1)

Country Link
CN (1) CN103426095A (en)

Cited By (7)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN104036354A (en) * 2014-06-12 2014-09-10 江苏农牧科技职业学院 Agricultural product quality safety supervision system and method for APP
CN104091185A (en) * 2014-06-30 2014-10-08 珠海格力电器股份有限公司 Equipment data acquisition method and system
CN104537330A (en) * 2014-12-08 2015-04-22 深圳市民德科创科技有限公司 Image type bar code reader with lightweight database arranged inside
CN104915739A (en) * 2014-03-11 2015-09-16 遵义市亿易通科技网络有限责任公司 Agriculture committee electronic account management system
CN105046506A (en) * 2015-07-14 2015-11-11 哈尔滨德邦鼎立生物科技有限公司 Feed additive self-service querying and tracing system and method
WO2016107155A1 (en) * 2014-12-31 2016-07-07 中兴通讯股份有限公司 Asset management method and system
CN105809564A (en) * 2016-05-27 2016-07-27 许昌学院 Agricultural internet node

Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101645081A (en) * 2009-08-19 2010-02-10 上海孙桥现代农业联合发展有限公司 Method and system for tracing farm product information through two-dimension code
CN103065251A (en) * 2013-01-17 2013-04-24 江苏省农业科学院 Agricultural product quality safety traceability system

Patent Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101645081A (en) * 2009-08-19 2010-02-10 上海孙桥现代农业联合发展有限公司 Method and system for tracing farm product information through two-dimension code
CN103065251A (en) * 2013-01-17 2013-04-24 江苏省农业科学院 Agricultural product quality safety traceability system

Non-Patent Citations (2)

* Cited by examiner, † Cited by third party
Title
彭艳 等: "Android平台的数据存储技术", 《计算机系统应用》 *
程涛 等: "农产品质量安全追溯智能终端系统的构建与实现", 《江苏农业科学》 *

Cited By (8)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN104915739A (en) * 2014-03-11 2015-09-16 遵义市亿易通科技网络有限责任公司 Agriculture committee electronic account management system
CN104036354A (en) * 2014-06-12 2014-09-10 江苏农牧科技职业学院 Agricultural product quality safety supervision system and method for APP
CN104091185A (en) * 2014-06-30 2014-10-08 珠海格力电器股份有限公司 Equipment data acquisition method and system
CN104537330A (en) * 2014-12-08 2015-04-22 深圳市民德科创科技有限公司 Image type bar code reader with lightweight database arranged inside
WO2016107155A1 (en) * 2014-12-31 2016-07-07 中兴通讯股份有限公司 Asset management method and system
CN105809314A (en) * 2014-12-31 2016-07-27 中兴通讯股份有限公司 Method and system for asset management
CN105046506A (en) * 2015-07-14 2015-11-11 哈尔滨德邦鼎立生物科技有限公司 Feed additive self-service querying and tracing system and method
CN105809564A (en) * 2016-05-27 2016-07-27 许昌学院 Agricultural internet node

Similar Documents

Publication Publication Date Title
CN103426095A (en) Agricultural product source-tracing query method based on android platform
US9471714B2 (en) Method for increasing the security level of a user device that is searching and browsing web pages on the internet
JP6285010B2 (en) Method and apparatus for managing applications using semantic modeling and tagging
US9910870B2 (en) System and method for creating data models from complex raw log files
CN106165463A (en) Select the user related to geography fence
CN105701254A (en) Information processing method and device and device for processing information
CN102663105A (en) Establishing method and system of number information database
CN109636582B (en) Credit information management method, apparatus, device and storage medium
US9344518B2 (en) Facilitation of social interactions
TW201339863A (en) Device and method for recognizing and searching image
CN105630813A (en) Keyword recommendation method and system based on user-defined template
CN106960667B (en) Position reminding method, device and system
CN104346466A (en) Method and device of adding new attribute data in database
CN104778538A (en) Agricultural product cellphone tracing method based on NFC
CN103678624A (en) Searching method, searching server, and searching request executing method and terminal
CN106682146B (en) Method and system for retrieving scenic spot evaluation according to keywords
CN105335466A (en) Audio data retrieval method and apparatus
CN110502716A (en) A kind of methods of exhibiting of information of vehicles, server, terminal device
US20180025359A1 (en) Customer journey optimized pre-fetching
JP5476571B2 (en) Comment evaluation apparatus, comment evaluation method, and program
Woo et al. Internet of Things Platform and Services for Connected Cars.
CN106663112A (en) Presenting information cards for events associated with entities
WO2016004050A2 (en) A method and program products for search and retrieval of lost objects
CN104182446A (en) Method for searching data and method for planning itinerary
US20120129504A1 (en) Apparatus and method for providing semantic context

Legal Events

Date Code Title Description
C06 Publication
PB01 Publication
C10 Entry into substantive examination
SE01 Entry into force of request for substantive examination
C12 Rejection of a patent application after its publication
RJ01 Rejection of invention patent application after publication

Application publication date: 20131204