CN107370786A - A kind of general information management system based on micro services framework - Google Patents

Abstract

The invention discloses a general information management system based on a microservice architecture, including a display layer, a platform layer, an application layer and a resource layer; the display layer receives user instructions to display data or submit data; the platform layer is used to receive instructions from the display According to the user instruction submitted by the user instruction layer, the corresponding system underlying service is provided according to the user instruction or the request instruction sent to the application layer is generated according to the user instruction; the application layer receives the user instruction submitted by the presentation layer, Call the corresponding service function according to the user instruction to process the business corresponding to the user instruction; wherein, the application layer includes at least the business application layer and the service application layer; the resource layer is used to obtain the data request instruction sent by the service application layer, and according to the data request instruction Provide the service application layer with the data required to process business services, thereby quickly responding to business needs, improving production efficiency, and comprehensively utilizing server resources.

Description

A general information management system based on microservice architecture

technical field

The present invention relates to the field of electronic information, in particular to a general information management system based on microservice architecture.

Background technique

Traditional enterprise software OA, ERP, CRM, etc. usually contain hundreds or thousands of function points because they need to meet various complex and changing business requirements, and these function points are used as a complete single architecture The application is packaged and deployed. All module functions are deployed on one server as a whole. On the one hand, excessive redundant resources may be wasted for the availability of several hotspot functions, and it is very difficult to horizontally expand the application in the face of hotspot functions; on the other hand On the one hand, with the continuous expansion of the company or organization's business, the demand continues to increase, more and more people join the development team, and the code base is also expanding rapidly. In this case, the maintainability and flexibility of the monolithic architecture are decreasing, while the testing cost, construction cost and maintenance cost are significantly increasing.

Complex business requirements will lead to a larger and larger system code size, and finally no one in the development team can fully understand it, and adding new functions and fixing errors is based on the understanding of the existing system. This will lead to the difficulty and time-consuming of adding new functions and correcting errors; if the system cannot be compiled and deployed quickly, developers will spend most of their time restarting and deploying during the development process, resulting in reduced production efficiency; The defects of traditional enterprise software are very difficult for software development, testing, deployment, troubleshooting, expansion and upgrading with extremely complex business functions, and require huge manpower and material resources.

Contents of the invention

In view of the above problems, the purpose of the present invention is to provide a general information management system based on micro-service architecture, integrate the micro-service architecture and traditional enterprise software to obtain a general information management system, quickly respond to business needs, improve production efficiency, comprehensive Utilize server resources.

The present invention provides a general information management system based on microservice architecture, including a display layer, a platform layer, an application layer and a resource layer; the display layer is used to receive user instructions to display data or submit data;

The platform layer is configured to receive the user instruction submitted by the presentation layer, provide corresponding system underlying services according to the user instruction, and generate a request instruction sent to the application layer according to the user instruction;

The application layer is configured to receive the request instruction submitted by the platform layer, and call the corresponding service function according to the request instruction to process the service corresponding to the user request; wherein the application layer includes at least a service application layer and system application layer,

The business application layer is configured to parse the request instruction to obtain a service request instruction corresponding to itself, and send the service request instruction to the system application layer;

The system application layer is used to provide corresponding business services in response to the service request instruction, and generate a data request instruction sent to the resource layer according to the business service;

The resource layer is configured to obtain a data request instruction issued by the system application layer, and provide data required by the system application layer to process the business service according to the data request instruction.

Preferably,

The resource layer includes at least a NoSQL non-relational database and a SQL relational database; the resource layer is specifically used for:

Obtaining a data request instruction issued by the system core service module of the application layer, and parsing the data request instruction;

When the data request instruction is a write operation and it is recognized that the data request instruction contains request parameters for caching, first write the data contained in the data request instruction into the NoSQL non-relational database, and then write The SQL relational master database is synchronized to the SQL relational slave database;

When the data request instruction is a write operation and it is recognized that the data request instruction contains request parameters that are not cached, the data contained in the data request instruction is written into the SQL relational master database and synchronized to the SQL relational type from the database;

When the data request instruction is a read operation and it is recognized that the data request instruction includes cached request parameters, read data from the NoSQL non-relational database;

When the data is not read from the NoSQL non-relational database, read the data from the SQL relational database;

When the data is not read from the database from the SQL relational type, return a null value;

When the data request instruction is a read operation and it is recognized that the data request instruction includes request parameters that are not cached, read the data from the SQL relational database;

When the data is not read from the SQL relational database, a null value is returned.

Preferably,

The system application layer includes at least a list service module, a form service module, a remote report service module and a data engine service module;

The list service module is used to display data in a list form;

The form service module is used to obtain user edit data, including at least form fields, change order labels and form buttons;

The remote report service module is used to perform asynchronous calls according to the message queue method to obtain data and generate reports;

The data engine service module is configured to execute the configured data rule set and save the edited data into the database of the resource layer.

Preferably,

The configuration of the list service module specifically includes adding a list unit, adding a field unit, adding an operation unit, a report template unit and a permission setting unit;

The newly added list unit is used to set core parameters including at least list number, template type and query SQL statement;

The adding field unit is used to set attributes for each field at least including data type, input type and data source type;

The adding operation unit is used to define buttons for operating list data;

The report template unit is used to parse the uploaded report template;

The authority setting unit is configured to set the preset role to have corresponding operation authority on the list.

Preferably,

The configuration of the form service module specifically includes a form configuration unit, a field configuration unit, a layout unit, an operation configuration unit, a document template unit and a permission unit;

The form configuration unit is used to set core parameters including at least form number, template type and SQL statement;

The field configuration unit is used to set attributes for each field at least including data type, input type and data source type;

The layout unit is configured to set a layout style so that the form label, the form field and the form button are laid out on the page according to a preset style;

The operation configuration unit is used to define buttons for operating form data;

The document template unit is used to parse the uploaded document template;

The authority unit is used to set the preset role to have corresponding operation authority on the form.

Preferably,

The configuration of the remote report service module specifically includes a report configuration unit, a field attribute unit and a report template generation unit;

The report configuration unit is used to set the core parameters including at least the report number and the writing of the SQL statement;

The field attribute unit is used to set at least attributes including data type and data source type for each field to be exported;

The report template generating unit is used to automatically generate a report template or analyze an uploaded report template.

Preferably,

The configuration of the data engine service sub-module specifically includes a rule set configuration unit, a rule variable unit and an operation rule unit;

The rule set configuration unit is used to set core parameters including at least rule set number, global verification function, custom class and method;

The rule variable unit is used to set global variables in the operation process;

The operation rule unit is used to select a database table for operation, set rule type, execution condition and verification function, and add rule parameters.

Preferably, the list service module is specifically used for:

Preprocessing the request parameters in the list service instruction, adding constant parameters, sending a data request instruction to the resource layer according to the parsed list number in the request parameter so that the resource layer provides corresponding list configuration information, Get the list data according to the response type of the list configuration;

When the response type is a general SQL query, by analyzing and constructing query parameter statements, adding data permission configuration, analyzing and constructing sorting statements, and executing SQL statements to obtain the list data;

When the response type is a self-defined extension function, the name of the extended function class and method is obtained by parsing, and the list data is obtained by calling the extended function class and method using reflection;

The form service module is specifically used for:

Preprocessing the request parameters in the form service instruction, adding constant parameters, sending a data request instruction to the resource layer according to the parsed form number in the request parameter so that the resource layer provides corresponding form configuration information, The form data is obtained according to the SQL configured in the form, the operation analysis is performed according to the SQL operation type and the preset authority, the document template is loaded, and the form data is exported in the form of the document template.

Preferably, the remote report service module is specifically used for:

Receive the report remote export command, pack the data including at least the report number and request parameters into a message and add it to the export message queue;

The remote report service submodule monitors the export message queue, and executes an export operation when a new message is read and the remote report service submodule is in an idle phase;

Sending a data request instruction to the resource layer according to the report number so that the resource layer provides corresponding report configuration information and report templates;

Obtain report data according to the SQL of the report configuration, write the report data into the report template and perform an export operation;

Preferably, the data engine service module is specifically used for:

Preprocessing the request parameters in the data engine service instruction, adding constant parameters;

sending a data request instruction to the resource layer according to the parsed rule set number in the request parameter so that the resource layer provides corresponding rule set configuration information;

Check the legality of the rule set, preprocess the rule set, analyze the rule variable and obtain the actual value of the rule variable;

Execute the global verification function to verify the validity of the submitted form data;

Analyzing attribute parameter fields to construct attribute SQL statements, parsing condition parameter fields to construct conditional SQL statements, obtaining current operation data tables to assemble target SQL statements, executing local verification functions to verify the legality of data in the data tables, Execution target SQL statements that pass the test.

The present invention provides a general information management system based on micro-service architecture. The display layer receives user instructions to display data or submit data; the platform layer receives the user instructions and provides corresponding system bottom-level services or services according to the user instructions. Generate a request instruction sent to the application layer; the business application layer parses the request instruction to obtain a service request instruction corresponding to itself, and sends the service request instruction to the system application layer to respond to the service request instructions to provide corresponding business services, and the resource layer parses the data request instructions sent by the system application layer and provides the required data. Each module of the general information management system is a separate application service, and developers only need to pay attention to and understand the code process of one or more application services during the compilation and deployment process without mastering the entire system, which greatly improves production efficiency; If an error is found in the programming environment, due to the independence of each module of the system, it can be quickly located and repaired to improve system availability; at the same time, it is also convenient to horizontally expand the hotspot function of the system, increase server resources, and comprehensively utilize server computing resources. So that the system can adapt to changing business needs and facilitate upgrades and expansions.

Description of drawings

In order to illustrate the technical solution of the present invention more clearly, the accompanying drawings used in the implementation will be briefly introduced below. Obviously, the accompanying drawings in the following description are only some implementations of the present invention. As far as the skilled person is concerned, other drawings can also be obtained based on these drawings on the premise of not paying creative work.

FIG. 1 is a schematic structural diagram of a general information management system based on a microservice architecture provided by an embodiment of the present invention.

FIG. 2 is an overall architecture diagram of a general information management system based on a microservice architecture provided by an embodiment of the present invention.

Fig. 3 is a schematic structural diagram of an application layer of a general information management system based on a microservice architecture provided by an embodiment of the present invention.

FIG. 4 is a schematic structural diagram of a resource layer of a general information management system based on a microservice architecture provided by an embodiment of the present invention.

Fig. 5 is a schematic diagram of permission setting of the list service module in the system application layer provided by the embodiment of the present invention.

detailed description

The following will clearly and completely describe the technical solutions in the embodiments of the present invention with reference to the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are only some, not all, embodiments of the present invention. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts belong to the protection scope of the present invention.

Referring to Fig. 1, the present invention provides a general information management system based on microservice architecture, including a display layer 100, a platform layer 200, an application layer 300 and a resource layer 400;

In the embodiment of the present invention, the general information management system adopts a microservice architecture in the system architecture, for example, using the technical framework of Spring Cloud, which is an ordered collection of a series of frameworks. It uses the development convenience of SpringBoot to subtly simplify the development of distributed system infrastructure, such as service discovery registration, configuration center, message bus, load balancing, circuit breaker, data monitoring, etc., can all be done with the development style of Spring Boot One-click launch and deployment.

The presentation layer 100 is configured to receive user instructions to display data or submit data. In the embodiment of the present invention, the presentation layer is responsible for the interaction between the system and the users on the web and mobile terminals. Users perform related operations through the page information displayed on the presentation layer, such as querying data or adding data information. The presentation layer will User operations are encapsulated into user instructions and sent to the platform layer for related processing, and finally display the data information required by the user. The presentation layer communicates with the platform layer through JWT, and the full name of JWT is JSON Web Token, which is a very lightweight specification. This specification allows us to use JWT to pass secure and reliable information between the user and the server.

The platform layer 200 is configured to receive the user instruction submitted by the presentation layer, provide corresponding system bottom layer services according to the user instructions, and generate request instructions sent to the application layer according to the system bottom layer services.

Please refer to Fig. 2, in the embodiment of the present invention, described platform layer comprises load balancing module, API gateway module, registration center module and configuration center module, and described API gateway module is responsible for service request routing, combination and protocol conversion, it It is the only entrance to the entire system. All requests from the client must first pass through the API gateway, and then it will route the request to the appropriate microservice; the core point of the API gateway module is that all clients and consumers pass through the unified The gateway accesses microservices and handles all non-business functions at the gateway layer. The biggest advantage of using an API Gateway is that it encapsulates the internal structure of the application. Clients only need to interact with the gateway without invoking specific services. The API gateway provides specific APIs for each type of client. This reduces the number of interactions between the client and the application and simplifies the client code. The registration center module is responsible for judging the user name and password input by the user who logs in for the first time, to see whether it is consistent with the user name and password of the user stored in the system, to judge whether the user identity is correct, and to judge through legality verification Whether it has the right to access the current request, if it is correct, make a subsequent service request, otherwise, the service is unavailable, and the process ends, and the unified authentication service module ensures the security of the user's own account and information.

In the embodiment of the present invention, the platform layer is responsible for receiving the user instruction submitted by the presentation layer, parsing the specific service request in the user instruction and providing corresponding services according to the service request, such as the registration center module To solve problems related to service governance such as account verification, the platform layer is responsible for providing underlying system services such as load balancing, intelligent routing, service governance, and configuration management. When the service request is a non-bottom system service such as a data request, the API gateway module sends a request instruction to the application layer to process the service request.

The application layer 300 is configured to receive the request instruction submitted by the platform layer, and call the corresponding service function according to the request instruction to process the service corresponding to the request instruction; wherein, the application layer includes at least Business application layer 310 and system application layer 320 .

In the embodiment of the present invention, the application layer is responsible for receiving the request instruction submitted by the platform layer, parsing and processing the request instruction, calling different services to process corresponding business logic according to the request instruction, for example, the If the request instruction is to modify data, the form service and data engine service are invoked according to the request instruction to modify the data and save it in the database.

In the embodiment of the present invention, please refer to FIG. 3, the application layer includes at least a business application layer 310 and a system application layer 320, and the business application layer 310 is used to parse the request instruction to obtain the corresponding Service request instruction, and send the service request instruction to the system application layer 320.

In the embodiment of the present invention, the business application layer 310 is responsible for processing the actual business needs of users, such as specific business function points such as task management, procurement management, inspection and survey, etc. The principle of realizing each function is through different configurations, single or Combination calls system core services to handle different business needs. By exposing the RSET interface for the API gateway to call. REST defines how to properly use web standards such as HTTP and URI, which is very different from how most people actually use it. Using the RSET interface enables the system to have a better, stable and high-quality web architecture, and improves the comprehensive utilization level of the system.

The system application layer 320 is configured to provide a corresponding business service in response to the service request instruction, and generate a data request instruction sent to the resource layer according to the business service.

In the embodiment of the present invention, the system application layer 320 is responsible for responding to the service request instruction, parsing and processing various business configurations to provide corresponding business services, decomposing each user request into basic additions, deletions, checks and modifications, and resource The corresponding operations are performed on the data of the layer, and the API gateway is called by exposing the REST interface.

The resource layer 400 is configured to obtain a data request instruction issued by the system application layer, and provide data required by the system application layer for processing the business service according to the data request instruction.

In the embodiment of the present invention, the resource layer 400 obtains the data request instruction issued by the system application layer of the application layer, parses the data request instruction, and provides the system application layer to process the data request instruction according to the data request instruction. Data required by business services, such as providing data records.

In the embodiment of the present invention, referring to FIG. 4, the resource layer 400 includes at least a NoSQL non-relational database and a SQL relational database; the resource layer is specifically used for:

Obtain the data request instruction sent by the system core service module of the application layer, and parse the data request instruction; when the data request instruction is a write operation and it is recognized that the data request instruction contains a request parameter for caching, first Write the data contained in the data request instruction into the NoSQL non-relational database, then write it into the SQL relational master database and synchronize it to the SQL relational slave database; when the data request instruction is a write operation and recognizes When the data request instruction includes a request parameter not to be cached, the data contained in the data request instruction is written into the SQL relational master database and synchronized to the SQL relational slave database; when the data request instruction is read When operating and recognizing that the data request instruction includes cached request parameters, read data from the NoSQL non-relational database; when the data is not read from the NoSQL non-relational database, Read the data from the database from the SQL relational type; when the data is not read from the database from the SQL relational type, return a null value; when the data request instruction is a read operation and recognizes When the data request instruction includes a request parameter not to be cached, read the data from the SQL relational database; when the data is not read from the SQL relational database, return null value. Wherein, the NoSQL non-relational database can be a Redis database, the SQL relational database can be a MySQL database, and the redis database is a log-type and Key-Value database that supports the network, can be based on memory or can be persisted. The MySQL database is a small and medium network database with good concurrency capability.

In summary, the present invention provides a general information management system based on a microservice architecture, including a display layer that receives user instructions to display data or submit data; for receiving the user instructions submitted by the display layer, The platform layer that provides the corresponding system bottom layer service according to the user instruction or generates the request instruction sent to the application layer according to the user instruction; at least includes a service request corresponding to itself by parsing the request instruction instructions, and send the service request instructions to the business application layer of the system application layer and provide corresponding business services in response to the service request instructions, and generate data requests sent to the resource layer according to the business services The application layer of the system application layer of the instruction and the resource layer for obtaining the data request instruction issued by the system application layer and providing the data required by the system application layer for processing the business service according to the data request instruction. Each module of the general information management system is a separate application service, and developers only need to pay attention to and understand the code process of one or more application services during the compilation and deployment process without mastering the entire system, which greatly improves production efficiency; If an error is found in the programming environment, due to the independence of each module of the system, it can be quickly located and repaired to improve system availability; at the same time, it is also convenient to horizontally expand the hotspot function of the system, increase server resources, and comprehensively utilize server computing resources. So that the system can adapt to changing business needs and facilitate upgrades and expansions.

In order to facilitate the understanding of the present invention, some preferred embodiments of the present invention will be further described below.

First preferred embodiment:

Referring to FIG. 2 , the system application layer 320 includes at least a list service module 321 , a form service module 322 , a remote report service module 323 and a data engine service module 324 .

The list service submodule 321 is used for displaying data in a list form.

The form service sub-module 322 is used to acquire user edit data, including at least form fields, change order labels and form buttons.

The remote report service sub-module 323 is used to perform asynchronous calls according to the message queue method to obtain data and generate reports.

The data engine service sub-module 324 is configured to execute the configured data rule set and save the edited data into the database of the resource layer.

In a preferred embodiment of the present invention, the list service module 321 displays multiple records (data sets) in the form of a list, and provides functions such as query, import and export, and hyperlinks. The list is a common page display in the system Effect. The configuration of the list service module 321 specifically includes adding a list unit, adding a field unit, adding an operation unit, a report template unit and a permission setting unit. The newly added list unit is used to set the core parameters including at least list number, template type and query SQL statement; the added field unit is used to at least include data type, input type and data source for each field Type attribute setting; the adding operation unit is used to define buttons for operating the list data, such as adding, importing, exporting and other operation buttons; the report template unit is used to analyze the uploaded report template, when needed When importing or exporting the list data, you can upload a report template such as Excel to make the system analyze the report template to perform related import or export operations; the authority setting unit, please refer to Figure 5, is used to set the default roles for the list. The corresponding operation authority, such as the system administrator has all the authority, and the person in charge of the prefecture and city only has the relevant authority of the place where he belongs.

In a preferred embodiment of the present invention, the form service module 322 is used to obtain user's editing data, and is responsible for the data collection function, including at least form fields, change order labels and form buttons. The configuration of the form service module 322 specifically includes a form configuration unit, a field configuration unit, a layout unit, an operation configuration unit, a document template unit and a permission unit; the form configuration unit is used to set at least a form number, a template type and an SQL The core parameters of the writing of the statement; the field configuration unit is used to set each field at least including the attribute of data type, input type and data source type, such as data type is int, char, and the input type is limited to male or female ; The layout unit is used to set the layout style so that the form label, the form field and the form button are laid out on the page according to the preset style; the operation configuration unit is used to define the form data to be operated Buttons, such as operation buttons such as adding, importing, and exporting; the document template unit is used to analyze the uploaded document template. When the form data needs to be imported or exported, it can be uploaded as described in the Word report template to enable the system to analyze The document template performs related import or export operations; the authority unit is used to set the preset role to have corresponding operation authority on the form, for example, the system administrator has all the authority, and the basic user only has the query authority.

In the preferred embodiment of the present invention, the remote report service module 323 is to meet the needs of multiple users to concurrently export reports with complex styles and large amounts of data. Asynchronous calls are made in queue mode. The configuration of the remote report service module 323 specifically includes a report configuration unit, a field attribute unit and a report template generation unit; the report configuration unit is used to set at least the core parameters that include report numbering and SQL statements; the field attributes The unit is used to set at least the attributes of data type and data source type for each field to be exported; the report template generation unit is used to automatically generate report templates or analyze uploaded report templates, for reports with simple styles Templates can be generated automatically by the system. For reports with complex styles, users need to design and upload report templates for the system to analyze.

In a preferred embodiment of the present invention, the data engine service module 324 is used to execute the configured data DML rule set, so as to persist the data collected by the form service to the database. The DML is a data manipulation language, SQL In one category, commands are computer languages that enable users to query databases and manipulate data in existing databases. DML includes: INSERT insert, UPDATE update, DELETE delete.

The configuration of the data engine service module 324 specifically includes a rule set configuration unit, a rule variable unit and an operation rule unit; the rule set configuration unit is used to set at least a rule set number, a global verification function, a custom class and a method The core parameter; the rule variable unit is used to set the global variable in the operation process; the operation rule unit is used to select the database table for operation, set the rule type, execution condition and verification function, add rule parameters, The check function is, for example, a CRC check function, a parity check function, and the like.

Second preferred embodiment:

The list service module 321 is specifically used for:

Preprocessing the request parameters in the list service instruction, adding constant parameters, sending a data request instruction to the resource layer according to the parsed list number in the request parameter so that the resource layer provides corresponding list configuration information, Get the list data according to the response type of the list configuration.

When the response type is a general SQL query, the list data is obtained by analyzing and constructing query parameter statements, adding data permission configuration, analyzing and constructing sorting statements, and executing SQL statements.

When the response type is a self-defined extension function, the name of the extension function class and method is obtained by parsing, and the list data is obtained by calling the extension function class and method using reflection.

In a preferred embodiment of the present invention, the response process of the list service module 321 is:

Preprocess the request parameters and add constant parameters; check whether there is corresponding list configuration information in the cache according to the list number, read if there is one, and load it from the database and add it to the cache if there is no; according to the response type of the list configuration (general SQL query, Custom extension function) to get the query data result set (usually with multiple records).

The processing steps when the response type is a general SQL query are as follows:

Analyzing and constructing query parameter statements; adding data permission configuration; parsing and constructing sorting statements; executing SQL statements to obtain result sets.

The processing steps when the response type is a custom extension function are as follows:

Parsing and obtaining the call extension function class and method name; use reflection to call the above class and method to obtain the result set.

The third preferred embodiment:

The form service module 322 is specifically used for:

Preprocessing the request parameters in the form service instruction, adding constant parameters, sending a data request instruction to the resource layer according to the parsed form number in the request parameter so that the resource layer provides corresponding form configuration information, The form data is obtained according to the SQL configured in the form, the operation analysis is performed according to the SQL operation type and the preset authority, the document template is loaded, and the form data is exported in the form of the document template.

In a preferred embodiment of the present invention, the response process of the form service module 322 is:

Preprocess request parameters and add constant parameters.

Check whether there is corresponding form configuration information in the cache according to the form number, if there is, read it, if not, load it from the database and add it to the cache.

Get the data result set (usually only one record) according to the SQL configured by the form.

Perform operations according to different operation types (add, view, edit) and configured permission conditions, and perform permission control initialization operations on form fields and form buttons.

Load the corresponding query template, and output the data result set to the response stream to present to the user.

The fourth preferred embodiment:

The remote report service module 323 is specifically used for:

Receive the report remote export command, pack the data including at least the report number and request parameters into a message, and add it to the export message queue.

The remote report service submodule monitors the export message queue, and executes an export operation when a new message is read and the remote report service submodule is in an idle phase.

Sending a data request instruction to the resource layer according to the report number to enable the resource layer to provide corresponding report configuration information and report templates.

Obtain report data according to the SQL of the report configuration, write the report data into the report template and perform an export operation.

In a preferred embodiment of the present invention, the response process of the table remote report service module 323 is:

After the user clicks the report remote export button, the system will add data including the report number and request parameters as a message to the export message queue.

The remote report service continuously monitors the export message queue, and starts to execute the export operation if a new message is read and the current service is idle.

Read the corresponding report configuration information and report template according to the report number.

Get the paged data result set according to the SQL configured in the report and load it into the memory.

Traverse the above data result set and write it to the report template, and persist the generated report temporary file to the hard disk after writing.

Repeat steps S4 and S5 above until all data result sets are processed.

Merge all temporary report files generated in step S6 into a formal report file.

After the export is completed, the system will also push a processed message. After receiving the message, the user can click the download button to download the report.

The fifth preferred embodiment:

The data engine service module 324 is specifically used for:

Preprocess the request parameters in the data engine service instruction, and add constant parameters.

Sending a data request instruction to the resource layer according to the parsed rule set number in the request parameter to enable the resource layer to provide corresponding rule set configuration information.

Check the legality of the rule set, preprocess the rule set, analyze the rule variable and obtain the actual value of the rule variable.

Execute the global validation function to verify the validity of the submitted form data.

Analyzing attribute parameter fields to construct attribute SQL statements, parsing condition parameter fields to construct conditional SQL statements, obtaining current operation data tables to assemble target SQL statements, executing local verification functions to verify the legality of data in the data tables, Execution target SQL statements that pass the test.

In a preferred embodiment of the present invention, the response process of the table remote report service module 324 is:

Preprocess request parameters and add constant parameters.

Check whether there is corresponding rule set configuration information in the cache according to the rule set number, if there is, read it, if not, load it from the database and add it to the cache.

Check the validity of the rule set to see if the current user has permission to request the rule set.

Preprocess the rule set, process the rule variable, and obtain the actual value of the variable.

Execute the global verification function to verify the validity of the submitted data.

Execute the pre-advice method before the rule set is invoked.

Start executing the rules (pass as one or more).

Execution target SQL statement that passes the test, otherwise throws an exception.

The post notification method is executed before the rule set is invoked.

The specific steps of the execution rules are as follows:

Parse the attribute parameter field and construct the attribute SQL statement.

Parse the conditional parameter field and construct a conditional SQL statement.

Obtain the current operation data table and assemble the target SQL statement.

Execute the local verification function to verify the validity of the submitted data.

What is disclosed above is only a preferred embodiment of the present invention, and of course it cannot limit the scope of rights of the present invention. Those of ordinary skill in the art can understand all or part of the process for realizing the above embodiments, and according to the rights of the present invention The equivalent changes required still belong to the scope covered by the invention.

Those of ordinary skill in the art can understand that all or part of the processes in the methods of the above embodiments can be implemented through computer programs to instruct related hardware, and the programs can be stored in a computer-readable storage medium. During execution, it may include the processes of the embodiments of the above-mentioned methods. Wherein, the storage medium may be a magnetic disk, an optical disk, a read-only memory (Read-Only Memory, ROM) or a random access memory (Random Access Memory, RAM) and the like.

Claims (10)

1. a kind of general information management system based on micro services framework, it is characterised in that including presentation layer, podium level, application Layer and resource layer；

The presentation layer, for receiving user instruction with display data or submitting data；

The podium level, for receiving the user instruction submitted by the presentation layer, according to user instruction offer pair Answer system bottom service and sent according to user instruction generation to the request instruction of the application layer；

The application layer, for receiving the request instruction submitted by the podium level, according to request instruction calling pair The service function answered is to handle business corresponding with the request instruction；Wherein, the application layer comprises at least service application layer And system application layer,

The service application layer, the request instructions corresponding with itself are obtained for being parsed from the request instruction, and The request instructions are sent to the system application layer；

The system application layer, for responding the request instructions to provide corresponding business service, and according to the business Service creation is sent to the data requesting instructions of the resource layer；

The resource layer, the data requesting instructions sent for obtaining the system application layer, and referred to according to the request of data Order provides the data needed for business service described in the system application layer process.

2. general information management system according to claim 1, it is characterised in that the resource layer comprises at least NoSQL Non-relational database and SQL relevant databases；The resource layer is specifically used for：

The data requesting instructions that the system core service module of the application layer is sent are obtained, parse the data requesting instructions；

When the data requesting instructions are write operation and are recognized in the data requesting instructions comprising the request ginseng cached During number, the data included in the data requesting instructions are first write into the NoSQL non-relational databases, then write SQL passes It is type primary database and is synchronized to SQL relationship types from database；

When the data requesting instructions are write operation and recognize the request included in the data requesting instructions without caching During parameter, by the data included in the data requesting instructions write SQL relationship types primary database and be synchronized to SQL relationship types from In database；

When the data requesting instructions are read operation and are recognized in the data requesting instructions comprising the request ginseng cached During number, data are read from the NoSQL non-relational databases；

When not reading the data from the NoSQL non-relational databases, from the SQL relationship types from database It is middle to read the data；

When not reading the data from database from the SQL relationship types, null value is returned；

When the data requesting instructions are read operation and recognize the request included in the data requesting instructions without caching During parameter, the data are read from database from the SQL relationship types；

When not reading the data from database from the SQL relationship types, null value is returned.

3. general information management system according to claim 1, it is characterised in that the system application layer comprises at least row Table service module, list service module, long-range Report Forms Service module and data engine service module；

The list service module, for tabular form display data；

The list service module, for obtaining editor's data of user, pressed including at least form fields, the single label of change and list Button；

The long-range Report Forms Service module, reported for carrying out asynchronous call according to message queue mode to obtain data and generation Table；

Editor's data are saved in the money by the data engine service module, the data rule set for performing configuration In the database of active layer.

4. general information management system according to claim 3, it is characterised in that the configuration tool of the list service module Body includes newly-increased list cell, addition field unit, addition operating unit, report form template unit and priority assignation unit；

The newly-increased list cell, for setting the core write including at least numbering of table, template type and query SQL sentence Heart parameter；

The addition field unit, for carrying out comprising at least data type, input type and data source types to each field Attribute setting；

The addition operating unit, for defining the button operated to table data；

The report form template unit, for parsing the report form template uploaded；

The priority assignation unit, for setting default role to have corresponding operating right to list.

5. general information management system according to claim 3, it is characterised in that the configuration tool of the list service module Body includes list dispensing unit, field configuring unit, layout units, operative configuration unit, document template unit and permission unit；

The list dispensing unit, for setting the core the write ginseng including at least form number, template type and SQL statement Number；

The field configuring unit, for carrying out comprising at least data type, input type and data source types to each field Attribute setting；

The layout units, for setting layout pattern so that the form tags, the form fields and the list button are pressed According to the preset style layout on the page；

The operative configuration unit, for defining the button operated to form data；

The document template unit, for parsing the document template uploaded；

The permission unit, for setting default role to have corresponding operating right to list.

6. general information management system according to claim 3, it is characterised in that the long-range Report Forms Service module is matched somebody with somebody Put and specifically include form dispensing unit, field attribute unit and report form template generation unit；

The form dispensing unit, for setting the core parameter write including at least report number and SQL statement；

The field attribute unit, for carrying out comprising at least data type and data source types to field derived from each need The setting of attribute；

The report form template generation unit, the report form template uploaded for automatic report generation template or parsing.

7. general information management system according to claim 3, it is characterised in that the data engine service module is matched somebody with somebody Put and specifically include regular collection dispensing unit, rules variables unit and operation rule unit；

The regular collection dispensing unit, for set comprise at least regular collection numbering, global verification function, self defined class and The core parameter of method；

The rules variables unit, for setting the global variable in calculating process；

The operation rule unit, for the database table for selecting to be operated, rule type is set, perform condition and verifies letter Number, add parameter of regularity.

8. general information management system according to claim 3, it is characterised in that the list service module is specifically used In：

The required parameter in the list service instruction is pre-processed, constant parameter is added, according to the required parameter parsed In numbering of table send data requesting instructions to the resource layer so that the resource layer provide corresponding to list configuration information, Table data is obtained according to the respond style of list configuration；

When the respond style is general SQL query, by analytic construction query argument sentence, interpolation data authority configuration, Analytic construction an ordering statement, perform SQL statement and obtain the table data；

When the respond style is self-defined spread function, parsing, which obtains, calls spread function class and method name, uses reflection The spread function class and method is called to obtain the table data；

The list Attendant sub-module is specifically used for：

The required parameter in the list service order is pre-processed, constant parameter is added, according to the required parameter parsed In form number send data requesting instructions to the resource layer so that the resource layer provide corresponding to form configuration information, The SQL configured according to list obtains form data, and operational analysis, loading are carried out according to SQL action type and default authority The document template, the form data is exported in the form of the document template.

9. general information management system according to claim 3, it is characterised in that the long-range Report Forms Service module is specific For：

Receive form and remotely export instruction, the data including at least report number and required parameter are packaged into message be added to and lead In outbound message queue；

The long-range Report Forms Service submodule monitors the export message queue, when reading new information and the long-range form clothes Business submodule performs export operation when being in idle phase；

Data requesting instructions are sent to the resource layer according to report number so that form configuration corresponding to resource layer offer Information and report form template；

The SQL configured according to form obtains report data, and the report data is write into the report form template and carries out export behaviour Make.

10. general information management system according to claim 3, it is characterised in that the data engine service module tool Body is used for：

The required parameter in the data engine service order is pre-processed, adds constant parameter；

In the required parameter parsed regular collection numbering send data requesting instructions to the resource layer so that Regular collection configuration information corresponding to the resource layer offer；

Regular collection legitimacy is checked, pre-processes the regular collection, analysis rule variable simultaneously obtains the rules variables reality Value；

Perform the legitimacy of global verification function submission form data to verify；

Property parameters field is parsed to obtain with structural environment SQL statement with structure attribute SQL statement, analysis condition parameter field Current operation tables of data performs partial checksum function to verify the conjunction of the data in the tables of data to assemble target SQL statement Method, the performance objective SQL statement upchecked.