CN109542425B

CN109542425B - Automatic application method and system of retail supply chain

Info

Publication number: CN109542425B
Application number: CN201811357691.5A
Authority: CN
Inventors: 潘崇堤
Original assignee: Xiamen Shangji Network Technology Co ltd
Current assignee: Xiamen Shangji Network Technology Co ltd
Priority date: 2018-11-15
Filing date: 2018-11-15
Publication date: 2023-02-07
Anticipated expiration: 2038-11-15
Also published as: CN109542425A

Abstract

The invention provides a retail supply chain automatic application method and a retail supply chain automatic application system, provides a unified controller entry, a unified application service entry and unified abstract CRUD operation, utilizes a Spring annotation and a Java reflection mechanism to shield multiple access entries, encapsulates general service actions, effectively extends and encapsulates a Spring MVC framework, can effectively optimize a large amount of basic function maintenance with high similarity, reduces code redundancy, reduces maintenance cost and improves research and development efficiency. And the service layer can be expanded, and more service document scenes are supported. The method effectively overcomes the defect that a plurality of application functions are respectively administrative, reduces the maintenance cost, improves the research and development efficiency, and simultaneously improves the product quality.

Description

Automatic application method and system of retail supply chain

Technical Field

The invention relates to an automatic application method and system, in particular to an automatic application method and system suitable for a retail supply chain.

Background

Supply chain management is a life line of retail enterprises, various problems, information delay, excessive handover work, miscellaneous goods and supplier information and other problems can occur in the supply chain management process, and potential development opportunities and quick response capability of the whole supply chain are hindered. The advent of information technology has provided good conditions for solving these problems. Many different functional and architected information systems are currently emerging in the retail supply chain management area, such as ERP, CRM, spring MVC, and so on. The Spring MVC is a lightweight Web framework which is based on Java and realizes a request-driven type of an MVC design mode, namely, the idea of an MVC architecture mode is used, and Web layer responsibility is decoupled. As shown in fig. 1, firstly, a user initiates an HTTP request through a browser, a Controller (Controller) on a presentation layer receives the request of the user and delegates a Model to process the request, a Model (Model) on a service layer processes service logic and returns Model data required for View display, the Controller receives the Model data and pushes the Model data to a View (View) on the presentation layer, and finally, the View display Model data is responded to the user.

As shown in fig. 2, when 1 Service function is added, firstly, 1 Controller (Controller), 1 or more Service entities (VOs), and 1 Service are added, and each Service operation logic, such as query, addition, editing, deletion, import, export, and the like, is added in the Service; in the retail supply chain application, a large amount of similar basic function maintenance exists, such as enterprises, departments, personnel, commodity categories, commodities, brands, categories, supplier categories, suppliers, regions and the like, which causes the disadvantages of code bloat, one-position adjustment, position adjustment and the like, and has high maintenance cost and low research and development efficiency.

Disclosure of Invention

Therefore, the technical problems to be solved by the invention are that the automatic system of the retail supply chain in the prior art is too large, the operation steps are complex, the system code is overstaffed and the maintenance cost is high.

In order to solve the technical problem, the invention adopts the following technical scheme:

the first technical scheme is as follows:

a method for automated application of a retail supply chain, comprising the steps of:

s1: a scene application request is input.

S2, the unified controller receives the scene application request and obtains entity model resources of the retail supply chain, wherein the entity model resources comprise: the unified controller is constructed at a control layer of a Spring MVC framework, and utilizes the @ RequestParam request address mapping annotation of Spring to realize unified distribution and address steering through Param parameters.

And S3, calling a definition command to convert the entity model resource into corresponding service entity data, and storing the service entity data in the model layer of the SpringMVC framework.

And S4, calling service entity data in the model layer of the SpringMVC framework according to the input scene application request, executing a reflection command of Java, and automatically creating an entity object through a resource name as an input parameter of S5.

And S5, receiving the entity object parameters in the step S4 by the unified framework service, calling data through a MyBatis dynamic SQL analysis engine according to a scene application instruction sent by the unified controller, executing a dynamic SQL statement of the corresponding automatic sub-service, and generating an SQL execution result, wherein the unified framework service is constructed in a service layer of a SpringMVC framework.

And S6, the business layer and the control layer sequentially receive the SQL execution result, process the data and transmit the data to the view layer for visual display.

In step S5, the automated sub-service further includes:

and the automatic query service analyzes the entity object parameters, generates a Select dynamic query SQL statement, contains association, conditions, sequencing and permission, and supports linkage query of the main and sub tables.

And (4) automatically adding new services, analyzing the parameters of the entity object, generating an Insert dynamic Insert SQL statement, containing conditions, and supporting linkage Insert storage of the main and sub tables.

And the automatic updating service analyzes the entity object parameters, generates an Update dynamic updating SQL statement, contains conditions and supports linkage updating and storage of the main and sub tables.

And the automatic deleting service analyzes the entity object parameters, generates a Delete dynamic deleting SQL statement, contains conditions and supports linkage deleting and storing of the main and sub tables.

In step S5, data call is performed through the DAO service interface.

According to the needs of business scenes, the automatic sub-services further comprise auditing service, printing service and document exporting service.

The second technical scheme is as follows:

an automated system for a retail supply chain, comprising a processor adapted to implement instructions; the SpringMVC framework is used for storing business data and various service modules, wherein the business layer and the control layer are used for processing the data, and the view layer is used for displaying a visual picture of a client; and a storage device adapted to store a plurality of instructions, the instructions adapted to be loaded and executed by the processor to:

a scene application request is input.

The unified controller receives a scene application request, and obtains entity model resources of a retail supply chain, wherein the entity model resources comprise: the unified controller is constructed at a control layer of a Spring MVC framework, and utilizes the @ RequestParam request address mapping annotation of Spring to realize unified distribution and address steering through Param parameters.

And calling a definition command to convert the entity model resource into corresponding service entity data, and storing the service entity data in the model layer of the SpringMVC framework.

And calling service entity data in the model layer of the springMVC frame according to the input scene application request, executing a Java reflection command, automatically creating an entity object through a resource name, and using the entity object as an input parameter of the unified frame service.

The unified framework service receives the entity object parameters, carries out data calling through a MyBatis dynamic SQL analysis engine according to a scene application instruction sent by the unified controller, executes the dynamic SQL sentences of the corresponding automatic sub-services and generates an SQL execution result, and the unified framework service is constructed in a service layer of a spring MVC framework.

And the business layer and the control layer sequentially receive the SQL execution result, process data and transmit the data to the view layer for visual display.

The automation sub-services are further divided into:

And (4) automatically adding new services, analyzing the parameters of the entity object, generating an Insert dynamic insertion SQL statement, containing conditions, and supporting linkage insertion and storage of the main and sub tables.

And automatically executing the data task according to the transmitted entity model resources and the newly added and changed data of the view layer.

The automatic sub-service also comprises an auditing service, a printing service and a document exporting service.

Compared with the prior art, the technical scheme of the invention has the advantages that:

1. according to the automatic application method and system of the retail supply chain, the unified controller entry, the unified application service entry and the unified abstract CRUD operation are constructed, the automatic sub-service operation module shields the multiple access entries by using a Spring annotation and Java reflection mechanism, encapsulates general service actions, effectively extends and encapsulates a Spring MVC framework, effectively overcomes the defect that multiple application functions are in different administrative roles, reduces maintenance cost, improves research and development efficiency, and simultaneously improves system stability.

2. According to the automatic application method and system of the retail supply chain, the business layer can be expanded according to different business scene requirements, more business document scenes are supported, a large number of basic function maintenance with high similarity can be effectively optimized, code redundancy is reduced, maintenance cost is reduced, and research and development efficiency is improved.

3. According to the automatic application method and system of the retail supply chain, disclosed by the invention, the Spring MVC is utilized to effectively call the MyBatis dynamic SQL analysis engine, so that the rapid automatic service is realized.

Drawings

In order that the manner in which the disclosure of the present invention is attained and can be more readily understood, a more particular description of the invention briefly described above will be rendered by reference to specific embodiments thereof which are illustrated in the appended drawings, wherein,

FIG. 1 is a schematic diagram of a prior art Spring MVC framework;

fig. 2 is a schematic view of a scene application based on a Spring MVC technical framework in the prior art;

FIG. 3 is a method of automated application of a retail supply chain of the present invention;

FIG. 4 is an illustration of an automated application instance of a retail supply chain of the present invention.

Detailed Description

Example 1

As shown in fig. 3, an automated method of applying a retail supply chain includes the steps of:

s1: a scene application request is input.

The input scene application request can be to inquire all products under a certain enterprise name, change the discount of all milk powder products in the export sales department, newly add a certain brand of commodity and the like. The input scene request is operated by an operator through a window interface, and the system automatically converts the input scene request into an executable instruction.

The unified Controller (AutoController) is a control layer that is constructed in the control layer (Controller) of the SpringMVC framework. @ RequestParam is used to map request parameter area data onto parameters of the function processing method. The @ RequestParam and @ PathVariable annotations are for receiving requests from requests, both of which may receive parameters, the key point being that @ RequestParam takes values from within a request, and @ PathVariable is populated from within a URI template.

According to different input data of the retail supply chain, the entity model resources further comprise commodity tax rate, discount bill, commodity unit and the like.

The business entity data is a data field, an enterprise data segment, a brand data segment and the like of the corresponding entity model resource after conversion.

The scene application may refer to an enterprise and a department, such as enterprise file maintenance and department file maintenance seen in an ERP system; an enterprise entity, a department entity and the like in the Model (Model) are VO entity classes (POJO classes) which are frequently spoken by people, are specific descriptions applied to scenes and comprise attributes and an attribute set/get method; the scene application is an actual trigger entrance or a trigger source; a unified Controller (AutoController), which is a Controller layer of SpringMVC, receives all requests of a scene application.

And S4, calling service entity data in the model layer of the springMVC frame according to the input scene application request, executing a Java reflection command, and automatically creating an entity object through a resource name as an input parameter of S5.

An entity Model resource, which is an actual service entity class, can be created in a Model layer (Model) of a spring MVC framework, an entity object, a control layer and a service layer of the spring MVC; the general use is at the service level.

The resources of enterprises, departments and the like can be regarded as an identifier of a corresponding business entity, and the identifier is a character string; for example, in enterprise scene application, a 'Corp' character string can be transmitted into the front end, in a unified service framework, a Corp entity class can be found through the character string and converted into an enterprise entity object through a Java reflection mechanism, and a corresponding service entity class (VO) is established in a service layer; transmitting the resource name (such as Corp) to a unified controller, and calling a model tool class in a framework to convert the resource name into a specific service entity class; finally, the business entity object can be created according to the business entity class.

MyBatis is a persistent layer framework that supports customized SQL, stored procedures, and advanced mapping. MyBatis can use simple XML or annotations to configure and map native information, mapping interfaces and Java's POJOs (Plain Old Java Objects) to records in the database.

Spring is an open source framework created to address the complexities of enterprise application development. Spring uses the basic JavaBean to do what was previously only possible by EJBs. The method is a container frame used for containing java objects, the middle layer frame can play a connecting role, and in brief, spring is a container frame with light-weight control reversal (IoC) and plane-oriented (AOP).

Spring annotation, construct IoC container with annotation, i.e., register Bean with Spring container with annotation.

Java is an object-oriented computer programming language and has the characteristics of simplicity, object orientation, distribution, robustness, safety, platform independence and portability, multithreading, dynamics and the like;

the Java reflection mechanism is used for dynamically acquiring information and dynamically calling the functions of object methods, namely, in the running state, all attributes and methods of any class can be known; any method and property can be called for any object.

In step S5, the automated sub-service further includes:

the automatic query service (AutoSelectService) analyzes the entity object parameters to generate a Select dynamic query SQL statement containing association, conditions, sequencing and permission and supporting linkage query of the main and sub-tables

The method comprises the following steps of (1) automatically adding a service (AutoInsertservice), analyzing entity object parameters, generating an Insert dynamic insertion SQL statement, including conditions, and supporting linkage insertion and storage of a main sub-table;

the automatic Update service (AutoUpdateservice) analyzes the entity object parameters, generates an Update dynamic Update SQL statement, contains conditions, and supports linkage Update and storage of the main and sub tables;

and (3) analyzing the entity object parameters by an automatic Delete service (AutoDeleteService), generating a Delete dynamic Delete SQL statement, including conditions, and supporting linkage Delete and storage of the main and sub tables.

And an automatic query service (autoselect service), wherein the system can automatically return data required by the display layer according to the transmitted entity model resources.

And an automatic adding service (AutoInsertservice), wherein the system can automatically add and store data to the database according to the added data of the transmitted entity model resource and display layer.

And an automatic update service (AutoUpdateservice), wherein the system can automatically update data to the database according to the transmitted change data of the entity model resource and the display layer.

Automatic deletion service (AutoDeleteService), the system can automatically delete data from the database according to the transmitted entity model resources.

In step S5, data call is performed through the DAO service interface. The DAO (Data Access Object) Data Access Object is an Object-oriented database interface that exposes the Microsoft Jet database engine (used by Microsoft Access) and allows Visual Basic developers to connect directly to the Access table via ODBC as if connecting directly to other databases. DAO is best suited for single system applications or small-scale local distributed usage.

According to the needs of the service scene, the automatic sub-services further comprise an auditing service, a printing service and a document exporting service, wherein the document comprises word, excel, txt and jpg pictures.

According to the scheme, a unified controller entry, a unified application service entry, unified abstract CRUD operation and an automatic sub-service operation module are constructed, a reflection mechanism of Spring annotation and Java is utilized, multiple access entries are shielded, universal business actions are packaged, a Spring MVC frame is effectively extended and packaged, the defect that multiple application functions are respectively managed is effectively overcome, the maintenance cost is reduced, the research and development efficiency is improved, and meanwhile the system stability is also improved. And the Spring MVC is utilized to effectively call a MyBatis dynamic SQL analysis engine, so that rapid automatic service is realized.

Example 2

a scene application request is input.

The unified framework service receives the entity object parameters, carries out data calling through a MyBatis dynamic SQL analysis engine according to a scene application instruction sent by the unified controller, executes the dynamic SQL sentences of the corresponding automatic sub-services, and generates an SQL execution result, wherein the unified framework service is constructed in a service layer of a SpringMVC framework.

The automation sub-services are further divided into:

Example 3

As shown in fig. 4, is an automated application instance demonstration of a retail supply chain of the present invention:

s1: an operator inputs a scene application request through an input port of the system, and in the embodiment, the scene application request is to query all commodities predetermined by an enterprise a and add office supplies named as C of a brand B.

The system visualization operation interface is provided with a preset filling window, an operator can respectively select command types to be executed, names of various entity model resources, common phrases preset by the system and menu selection can be pulled down in the filling window.

S2, the unified controller receives the scene application request and obtains entity model resources of the retail supply chain, wherein the entity model resources comprise: the unified controller is constructed at a control layer of a Spring MVC frame, and utilizes @ RequestParam request address mapping annotation of Spring to realize unified distribution and address steering through Param parameters.

In this embodiment, the entity model resources include various data of keywords of a company a, a brand B, and a product type C. An input interface of the system is connected with a retailer database, and the database stores entity model resources which are updated periodically.

In this embodiment, the mockup resources in the database are converted into data types that are readable by the SpringMVC framework of the system by defining commands.

In this example, it can be briefly stated that set Corp = a business, set Motion = Select, and set Target = all. set Brand = Brand B, set Motion = Insert, and set Target = commercial product C.

And S5, receiving the entity object parameters in the step S4 by the unified framework service, calling a MyBatis dynamic SQL analysis engine according to a scene application instruction sent by the unified controller, executing a dynamic SQL statement of the corresponding automatic sub-service, and generating an SQL execution result, wherein the unified framework service is constructed in a service layer of a SpringMVC framework.

In this embodiment, an automated query service is invoked, and according to command parameters set Corp = enterprise a, set Motion = Select, and set Target = all, SQL execution results are generated, that is, all the commodities of enterprise a, set Brand = Brand B, set Motion = Insert, and set Target = commodity C are obtained, and execution results are generated, that is, commodity C of Brand B is newly added.

In this embodiment, the service layer and the control layer sequentially receive the SQL execution result, perform visualization processing on the SQL execution result, transmit the SQL execution result to the view layer, and display all the commodity lists of the enterprise a on the user interface and the newly added commodity label red display of the commodity C in the brand commodity list B.

In this embodiment, a document export service may be further added, so that the system generates two PDF files in a folder while displaying the visualization result, and an operator may copy the document.

According to the scheme, a unified controller entry, a unified application service entry, unified abstract CRUD operation and an automatic sub-service operation module are constructed, a Spring note and Java reflection mechanism is utilized, multiple access entries are shielded, universal business actions are packaged, a Spring MVC framework is effectively extended and packaged, the defect that multiple application functions are respectively classified is effectively overcome, the maintenance cost is reduced, the research and development efficiency is improved, and meanwhile the system stability is also improved. The business layer can be expanded according to different business scene requirements, more business document scenes are supported, a large number of basic function maintenance with high similarity can be effectively optimized, code redundancy is reduced, maintenance cost is reduced, and research and development efficiency is improved. And the Spring MVC is utilized to effectively call the MyBatis dynamic SQL analysis engine, so that the rapid automatic service is realized.

It should be understood that the above examples are only for clarity of illustration and are not intended to limit the embodiments. Other variations and modifications will be apparent to persons skilled in the art in light of the above description. And are neither required nor exhaustive of all embodiments. And obvious variations or modifications therefrom are within the scope of the invention.

Claims

1. A method for automated application of a retail supply chain, comprising the steps of:

s1, inputting a scene application request;

s2, the unified controller receives the scene application request and obtains entity model resources of the retail supply chain, wherein the entity model resources comprise: the unified controller is constructed at a control layer of a Spring MVC frame, and utilizes the @ RequestParam request address mapping annotation of Spring to realize unified distribution and address steering through Param parameters;

s3, calling a definition command to convert the entity model resource into corresponding service entity data, and storing the service entity data in a model layer of a SpringMVC framework;

s4, calling service entity data in the model layer of the springMVC frame according to the input scene application request, executing a Java reflection command, automatically creating an entity object through a resource name, and using the entity object as an input parameter in the step S5;

s5, receiving the entity object parameters in the step S4 by the unified framework service, calling data through a MyBatis dynamic SQL analysis engine according to a scene application instruction sent by the unified controller, executing a dynamic SQL statement of a corresponding automatic sub-service, and generating an SQL execution result, wherein the unified framework service is constructed in a service layer of a SpringMVC framework; wherein the automation sub-service comprises: the automatic query service analyzes the entity object parameters, generates a Select dynamic query SQL statement containing association, conditions, sequencing and authority, and supports linkage query of the main and sub tables; the method comprises the steps of automatically adding new services, analyzing entity object parameters, generating Insert dynamic Insert SQL statements containing conditions, and supporting linkage Insert storage of a main sub-table; the automatic updating service analyzes the entity object parameters, generates an Update dynamic updating SQL statement, contains conditions and supports linkage updating and storage of the main and sub tables; the automatic deletion service analyzes the parameters of the entity object, generates a Delete dynamic deletion SQL statement, contains conditions and supports linkage deletion and storage of the main and sub tables;

2. The automated method for applying to a retail supply chain of claim 1, wherein in step S5, the data call is made through a DAO service interface.

3. The automated application method of the retail supply chain according to claim 2, wherein the automated sub-services further comprise auditing service, printing service, and exporting document service according to the needs of a business scenario.

4. An automated system for a retail supply chain, comprising a processor adapted to implement instructions; the SpringMVC framework is used for storing business data and various service modules, wherein the business layer and the control layer are used for processing the data, and the view layer is used for displaying a visual picture of a client; and a storage device adapted to store a plurality of instructions, the instructions adapted to be loaded and executed by a processor to: inputting a scene application request; the unified controller receives a scene application request, and obtains entity model resources of a retail supply chain, wherein the entity model resources comprise: the unified controller is constructed at a control layer of a Spring MVC frame, and utilizes the @ RequestParam request address mapping annotation of Spring to realize unified distribution and address steering through Param parameters; calling a definition command to convert the entity model resource into corresponding service entity data, and storing the service entity data in a model layer of a springMVC framework; calling service entity data in a model layer of a springMVC frame according to an input scene application request, executing a Java reflection command, automatically creating an entity object through a resource name, and using the entity object as an input parameter of unified frame service; the unified framework service receives the entity object parameters, performs data calling through a MyBatis dynamic SQL analysis engine according to a scene application instruction sent by a unified controller, executes the dynamic SQL statements of the corresponding automatic sub-services and generates an SQL execution result, and the unified framework service is constructed in a service layer of a spring MVC framework; wherein the automation sub-service comprises: the automatic query service analyzes the entity object parameters, generates a Select dynamic query SQL statement, contains correlation, conditions, sorting and permission, and supports linkage query of the main and sub tables; the method comprises the steps of automatically adding new services, analyzing entity object parameters, generating Insert dynamic Insert SQL statements containing conditions, and supporting linkage Insert storage of a main sub-table; the automatic updating service analyzes the entity object parameters, generates an Update dynamic updating SQL statement, contains conditions and supports linkage updating and storage of the main and sub tables; the automatic deletion service analyzes the parameters of the entity object, generates a Delete dynamic deletion SQL statement, contains conditions and supports linkage deletion and storage of the main and sub tables; and the business layer and the control layer sequentially receive the SQL execution result, process data and transmit the data to the view layer for visual display.

5. An automated system for retail supply chain according to claim 4, wherein data tasks are performed automatically based on incoming mockup resources and new and modified data for the view layer.

6. An automated system for a retail supply chain according to claim 5, wherein the automated sub-services further include auditing services, printing services, export documentation services.