Design And Implementation Of Merchandise Anti-counterfeiting Traceability And Query System

Fake and inferior products not only destroy the reputation, disrupt the marketorder, but also harm the interests, physical health and life security of consumers andproducers, further, have very bad consequences for the society as a whole. In view ofthis，Yitong company proposed comprehensive anti-counterfeiting traceability andquery system. It provides the whole flow of anti-counterfeiting trace service and avariety of query mode in order to provide consumers with more convenient querychannel, in turn, effective againsts fake and inferior products to protect the interestsof the consumers and producers.The paper analyzes the status quo of the current anti-counterfeiting traceabilitysystem and anti-counterfeiting technology development, based on the developmentof the current security traceability system. According to the application scenarios andrequirements of anti-counterfeiting traceability and query system, this paperdetermines the solution and technical measures. This system provides traceabilityand anti-counterfeiting services based on "SaaS" mode. We choose SCDP3.0as thedevelopment framework of this system, at the same time, select Tomcat and Oracleas the application server and the database server of this system. It implementsinternal data interaction with the ETL tool named Kettle, and external datainteraction with WebService based on the pattern of Rest.This merchandise anti-counterfeiting traceability and query system is developedwith JAVA language in a J2EE environment through the SCDP3.0framework. Itsdesign is divided into six modules: definition of trace process, basic informationmanagement, label management, query display, external data interface, systemmanagement. This system defines the order of the relationship between each link inthe process of commodity circulation and data format, with the method of thedatabase table control. It establishes a flexible perfect workflow system throughcreating and configuring workflow. The system makes sure with external systems orclient applications for seamless interactions and provides unified anti-counterfeitquery service by the interface.Finally, corresponding test cases are designed for the various modules of thissystem to ensure the correctness of the system. The results show each module of themerchandise anti-counterfeiting traceability and query system act correctly.