阅读说明：本技术 表格动态处理方法、设备及介质 (Form dynamic processing method, equipment and medium ) 是由 王睿 于 2020-06-23 设计创作，主要内容包括：本发明公开了一种表格动态处理方法、设备及介质。本发明无需采用POI,即可生成与变化后的excel对应的动态类,使现有的excel处理方式例如easypoi或者easyexcel能够通过该动态类处理变化后的excel,即实现了在excel处理过程中支持excel的动态变化,降低excel动态表头的处理复杂度,提升动态excel的处理效率；并且,通过在动态类更新的版本数量触发更换类加载器的条件时,创建新的类加载器,通过新的类加载器重新生成所有节点新的动态类,从而使旧的类加载器能够被卸载,继而释放内存,避免一直使用同一个类加载器来生成动态类所导致的内存溢出问题。(The invention discloses a method, equipment and a medium for dynamically processing a table. According to the invention, the dynamic class corresponding to the changed excel can be generated without adopting POI, so that the existing excel processing mode such as easy poii or easy excel can process the changed excel through the dynamic class, namely, the dynamic change of the excel is supported in the excel processing process, the processing complexity of the dynamic header of the excel is reduced, and the processing efficiency of the dynamic excel is improved; and when the condition of replacing the class loader is triggered by the updated version number of the dynamic class, a new class loader is created, and the new dynamic classes of all nodes are regenerated by the new class loader, so that the old class loader can be unloaded, the memory is released, and the problem of memory overflow caused by the fact that the same class loader is used for generating the dynamic classes all the time is solved.)

1. A dynamic processing method for a table is characterized by comprising the following steps:

obtaining meta-information of a current excel, and determining whether the current excel is changed or not according to the meta-information of the current excel and a preset class level model;

if the current excel is determined to be changed, determining new meta-information of a dynamic class of the current excel in a target node corresponding to the preset class hierarchical model according to the meta-information of the current excel;

when the sum of the number of all dynamic class versions of each node in the preset class hierarchical model meets a preset condition, generating a new dynamic class of the target node through a first class loader based on new meta-information of the dynamic class in the target node;

and when the sum of the number of all the dynamic class versions of each node in the preset class hierarchical model does not meet a preset condition, creating a second class loader, and generating a new dynamic class of each node in the preset class hierarchical model through the second class loader based on the new meta-information of the dynamic class in the target node and the meta-information of the dynamic class in other nodes except the target node in the preset class hierarchical model.

2. The form dynamic processing method according to claim 1, wherein the step of obtaining the meta-information of the current excel and determining whether the current excel has changed according to the meta-information of the current excel and a preset class hierarchy model comprises:

determining whether a target node corresponding to the current excel exists in the preset class hierarchical model or not according to global index information and a name identifier in the meta-information of the current excel, wherein the global index information comprises a mapping relation between each excel after the latest change and each node in the preset class hierarchical model;

and if the target node corresponding to the current excel does not exist in the preset class hierarchical model, determining that the current excel is changed.

3. The method for dynamically processing forms according to claim 2, wherein after the step of determining whether a target node corresponding to the current excel exists in the preset class hierarchical model, the method further comprises:

if a target node corresponding to the current excel exists in the preset class hierarchical model, comparing column name information in meta information of dynamic classes in the target node with column name information in meta information of the current excel, or comparing column type information in meta information of dynamic classes in the target node with column type information in meta information of the current excel;

if the column name information in the meta information of the dynamic class in the target node is different from the column name information in the meta information of the current excel, or the column type information in the meta information of the dynamic class in the target node is different from the column type information in the meta information of the current excel, determining that the current excel is changed;

and if the column name information in the meta information of the dynamic class in the target node is the same as the column name information in the meta information of the current excel, and the column type information in the meta information of the dynamic class in the target node is the same as the column type information in the meta information of the current excel, determining that the current excel is not changed.

4. The form dynamic processing method according to claim 2, wherein the step of determining new meta-information of a dynamic class of the current excel in a target node corresponding to the current excel in the preset class hierarchical model according to the meta-information of the current excel, if it is determined that the current excel has changed, comprises:

if the current excel is determined to be changed, creating a node corresponding to the current excel in the preset class hierarchical model according to the parent-child reference relation of the current excel, and using the node as a target node;

and determining new meta-information of the dynamic class in the target node according to the meta-information of the current excel.

5. The method for dynamically processing forms according to claim 2, wherein before the step of determining new meta-information of the dynamic class of the current excel in the target node corresponding to the preset class hierarchical model according to the meta-information of the current excel, the method further comprises:

determining whether the current excel comprises sub excels according to column type information in the meta information of the current excel;

if the current excel does not comprise the sub excel, executing the following steps: and determining new meta-information of a dynamic class of the current excel in a corresponding target node in the preset class hierarchical model according to the meta-information of the current excel.

6. The dynamic form processing method as claimed in claim 5, wherein after the step of determining whether the current excel includes a sub excel according to the column type information in the meta information of the current excel, the method further comprises:

if the current excel comprises sub excels, acquiring meta-information of the sub excels, and determining whether the sub excels are changed according to the meta-information of the sub excels and a preset class level model;

if the sub excel is determined to be changed, determining new meta-information of a dynamic class of the sub excel in sub target nodes corresponding to the sub excel in the preset class hierarchical model according to the meta-information of the sub excel;

when the sum of the number of all the dynamic class versions of each node in the preset class hierarchical model meets a preset condition, generating a new dynamic class of the sub-target node through a first class loader based on new meta-information of the dynamic class in the sub-target node;

after the generation of the new dynamic class of the sub-target node is finished, regenerating the new dynamic class of the target node through the first class loader based on the meta-information of the dynamic class in the target node;

and when the sum of the number of all the dynamic class versions of each node in the preset class hierarchical model does not meet a preset condition, creating a second class loader, and generating a new dynamic class of each node in the preset class hierarchical model through the second class loader based on the new meta-information of the dynamic class in the sub-target node and the meta-information of the dynamic class in other nodes except the sub-target node in the preset class hierarchical model.

7. The method for dynamic processing of forms as claimed in claim 1, wherein said step of generating a new dynamic class for said target node by a first class loader based on new meta-information for dynamic classes in said target node comprises:

determining whether the dynamic class in the target node comprises a class corresponding to the static field or not based on the new meta-information of the dynamic class in the target node;

determining the type of a byte code generator according to whether the dynamic class in the target node comprises a class corresponding to the static field;

generating a new dynamic class for the target node by the first class loader and the determined bytecode generator;

correspondingly, the step of generating a new dynamic class of each node in the preset class hierarchical model through the second class loader based on the new meta-information of the dynamic class in the target node and the meta-information of the dynamic class in other nodes except the target node in the preset class hierarchical model includes:

determining whether the dynamic class in each node comprises a class corresponding to the static field or not based on the meta-information of the dynamic class in each node;

determining the type of the byte code generator corresponding to each node according to whether the dynamic class of each node comprises the class corresponding to the static field;

generating a new dynamic class for the respective node through the second class loader and the determined bytecode generator.

8. The dynamic form processing method of claim 7 wherein said step of determining the type of bytecode generator based on whether the dynamic class in the target node includes a class corresponding to a static field includes;

if the dynamic class in the target node comprises a class corresponding to the static field, determining the type of the byte code generator as a first byte code generator, and generating a new byte code file by the first byte code generator through a combination mode and an inheritance mode;

if the dynamic class in the target node does not comprise the class corresponding to the static field, determining the type of the byte code generator as a second byte code generator, and generating a new byte code file by the second byte code generator through a combination mode;

correspondingly, the step of determining the type of the bytecode generator corresponding to each node according to whether the dynamic class of each node includes a class corresponding to the static field or not includes;

if the dynamic class in the node comprises a class corresponding to the static field, determining the type of the byte code generator as a first byte code generator, and generating a new byte code file by the first byte code generator through a combination mode and an inheritance mode;

and if the dynamic class in the node does not comprise the class corresponding to the static field, determining the type of the byte code generator as a second byte code generator, and generating a new byte code file by the second byte code generator through a combination mode.

9. The method for dynamically processing tables according to claim 1, wherein said step of generating a new dynamic class for said target node by a first class loader based on new meta information for dynamic classes in said target node, further comprises:

and if the fact that the target node has a parent node in the preset class hierarchical model is determined according to the parent-child reference relation of the dynamic class in the target node, regenerating a new dynamic class of the parent node through the first class loader based on the meta-information of the dynamic class in the parent node.

10. The dynamic table processing method according to any one of claims 1 to 9, wherein the preset condition is that a sum of numbers of all dynamic class versions of each node in the preset class hierarchy model is smaller than a preset number threshold, or that a ratio of a sum of numbers of latest dynamic class versions of each node in the preset class hierarchy model to a sum of numbers of all dynamic class versions of each node is greater than a preset ratio threshold.

11. A form dynamic processing device, characterized in that the form dynamic processing device comprises: memory, processor and a table dynamic processing program stored on the memory and executable on the processor, which when executed by the processor implements the steps of the table dynamic processing method according to any one of claims 1 to 10.

12. A computer-readable storage medium, wherein the computer-readable storage medium has stored thereon a table dynamic processing program, and when the table dynamic processing program is executed by a processor, the steps of the table dynamic processing method according to any one of claims 1 to 10 are implemented.

Technical Field

The invention relates to the technical field of financial technology (Fintech), in particular to a form dynamic processing method, equipment and medium.

Background

With the development of computer technology, more and more technologies are applied in the financial field, and the traditional financial industry is gradually changing to financial technology (Fintech), but higher requirements are also put forward on the technologies due to the requirements of the financial industry on safety and real-time performance.

In the case that the excel header is determined and then does not change, most systems choose to use easypoi (Microsoft excel processing Java Class library based on Apache POI) or easypexi (advanced excel processing Class library based on Apache POI of Alababa open source) for processing, but in the case that the excel changes dynamically, because the mechanism of the easypoi or easypexi describes the table structure of one excel through a Class (Class) facing to an object, the header of the excel is abstracted into the Class during encoding, the header of the excel is already decided during encoding, therefore, the excel can be well supported in the case that the excel header is determined and does not change any more, but if the header of the excel is modified or the excel header is dynamic (the change of the structure occurs along with operation) at runtime, most of the product of the Microsoft Office processing Java Class library (POI open source) cannot be used for processing documents by using the Microsoft Office object, however, the use of POI often does not support complex dynamic header processing, and the direct use of API interface provided by POI will greatly increase the complexity of excel operation, and the excel operation through POI is just like the step of simulating manual excel operation by way of computer programming, which is complex and inefficient.

Disclosure of Invention

The invention mainly aims to provide a table dynamic processing method, table dynamic processing equipment and a computer readable storage medium, and aims to solve the technical problem that the existing excel processing mode cannot well support dynamic change of excel.

In order to achieve the above object, the present invention provides a table dynamic processing method, including:

obtaining meta-information of a current excel, and determining whether the current excel is changed or not according to the meta-information of the current excel and a preset class level model;

if the current excel is determined to be changed, determining new meta-information of a dynamic class of the current excel in a target node corresponding to the preset class hierarchical model according to the meta-information of the current excel;

when the sum of the number of all dynamic class versions of each node in the preset class hierarchical model meets a preset condition, generating a new dynamic class of the target node through a first class loader based on new meta-information of the dynamic class in the target node;

and when the sum of the number of all the dynamic class versions of each node in the preset class hierarchical model does not meet a preset condition, creating a second class loader, and generating a new dynamic class of each node in the preset class hierarchical model through the second class loader based on the new meta-information of the dynamic class in the target node and the meta-information of the dynamic class in other nodes except the target node in the preset class hierarchical model.

Optionally, the step of obtaining the meta-information of the current excel, and determining whether the current excel changes according to the meta-information of the current excel and a preset class hierarchy model includes:

determining whether a target node corresponding to the current excel exists in the preset class hierarchical model or not according to global index information and a name identifier in the meta-information of the current excel, wherein the global index information comprises a mapping relation between each excel after the latest change and each node in the preset class hierarchical model;

and if the target node corresponding to the current excel does not exist in the preset class hierarchical model, determining that the current excel is changed.

Optionally, after the step of determining whether a target node corresponding to the current excel exists in the preset class hierarchical model, the method further includes:

if a target node corresponding to the current excel exists in the preset class hierarchical model, comparing column name information in meta information of dynamic classes in the target node with column name information in meta information of the current excel, or comparing column type information in meta information of dynamic classes in the target node with column type information in meta information of the current excel;

if the column name information in the meta information of the dynamic class in the target node is different from the column name information in the meta information of the current excel, or the column type information in the meta information of the dynamic class in the target node is different from the column type information in the meta information of the current excel, determining that the current excel is changed;

and if the column name information in the meta information of the dynamic class in the target node is the same as the column name information in the meta information of the current excel, and the column type information in the meta information of the dynamic class in the target node is the same as the column type information in the meta information of the current excel, determining that the current excel is not changed.

Optionally, if it is determined that the current excel is changed, the step of determining new meta-information of the dynamic class of the current excel in the target node corresponding to the preset class hierarchical model according to the meta-information of the current excel includes:

if the current excel is determined to be changed, creating a node corresponding to the current excel in the preset class hierarchical model according to the parent-child reference relation of the current excel, and using the node as a target node;

and determining new meta-information of the dynamic class in the target node according to the meta-information of the current excel.

Optionally, before the step of determining new meta-information of a dynamic class of the current excel in a target node corresponding to the preset class hierarchical model according to the meta-information of the current excel, the method further includes:

determining whether the current excel comprises sub excels according to column type information in the meta information of the current excel;

if the current excel does not comprise the sub excel, executing the following steps: and determining new meta-information of a dynamic class of the current excel in a corresponding target node in the preset class hierarchical model according to the meta-information of the current excel.

Optionally, after the step of determining whether the current excel includes a sub excel according to the column type information in the meta information of the current excel, the method further includes:

if the current excel comprises sub excels, acquiring meta-information of the sub excels, and determining whether the sub excels are changed according to the meta-information of the sub excels and a preset class level model;

if the sub excel is determined to be changed, determining new meta-information of a dynamic class of the sub excel in sub target nodes corresponding to the sub excel in the preset class hierarchical model according to the meta-information of the sub excel;

when the sum of the number of all the dynamic class versions of each node in the preset class hierarchical model meets a preset condition, generating a new dynamic class of the sub-target node through a first class loader based on new meta-information of the dynamic class in the sub-target node;

and after the generation of the new dynamic class of the sub-target node is finished, regenerating the new dynamic class of the target node through the first class loader based on the meta-information of the dynamic class in the target node.

And when the sum of the number of all the dynamic class versions of each node in the preset class hierarchical model does not meet a preset condition, creating a second class loader, and generating a new dynamic class of each node in the preset class hierarchical model through the second class loader based on the new meta-information of the dynamic class in the sub-target node and the meta-information of the dynamic class in other nodes except the sub-target node in the preset class hierarchical model.

Optionally, the step of generating, by the first class loader, a new dynamic class of the target node based on the new meta information of the dynamic class in the target node includes:

determining whether the dynamic class in the target node comprises a class corresponding to the static field or not based on the new meta-information of the dynamic class in the target node;

determining the type of a byte code generator according to whether the dynamic class in the target node comprises a class corresponding to the static field;

generating a new dynamic class for the target node by the first class loader and the determined bytecode generator;

correspondingly, the step of generating a new dynamic class of each node in the preset class hierarchical model through the second class loader based on the new meta-information of the dynamic class in the target node and the meta-information of the dynamic class in other nodes except the target node in the preset class hierarchical model includes:

determining whether the dynamic class in each node comprises a class corresponding to the static field or not based on the meta-information of the dynamic class in each node;

determining the type of the byte code generator corresponding to each node according to whether the dynamic class of each node comprises the class corresponding to the static field;

generating a new dynamic class for the respective node through the second class loader and the determined bytecode generator.

Optionally, the step of determining the type of the bytecode generator according to whether the dynamic class in the target node includes a class corresponding to the static field includes;

if the dynamic class in the target node comprises a class corresponding to the static field, determining the type of the byte code generator as a first byte code generator, and generating a new byte code file by the first byte code generator through a combination mode and an inheritance mode;

if the dynamic class in the target node does not comprise the class corresponding to the static field, determining the type of the byte code generator as a second byte code generator, and generating a new byte code file by the second byte code generator through a combination mode;

correspondingly, the step of determining the type of the bytecode generator corresponding to each node according to whether the dynamic class of each node includes a class corresponding to the static field or not includes;

if the dynamic class in the node comprises a class corresponding to the static field, determining the type of the byte code generator as a first byte code generator, and generating a new byte code file by the first byte code generator through a combination mode and an inheritance mode;

and if the dynamic class in the node does not comprise the class corresponding to the static field, determining the type of the byte code generator as a second byte code generator, and generating a new byte code file by the second byte code generator through a combination mode.

Optionally, after the step of generating, by the first class loader, a new dynamic class of the target node based on the new meta information of the dynamic class in the target node, the method further includes:

and if the fact that the target node has a parent node in the preset class hierarchical model is determined according to the parent-child reference relation of the dynamic class in the target node, regenerating a new dynamic class of the parent node through the first class loader based on the meta-information of the dynamic class in the parent node.

In addition, to achieve the above object, the present invention provides a form dynamic processing apparatus, including:

the change determining module is used for acquiring the meta-information of the current excel and determining whether the current excel changes or not according to the meta-information of the current excel and a preset class level model;

the meta-information determining module is used for determining new meta-information of a dynamic class of the current excel in a target node corresponding to the preset class hierarchical model according to the meta-information of the current excel if the current excel is determined to be changed;

a first generation module, configured to generate a new dynamic class of the target node through a first class loader based on new meta information of the dynamic class in the target node when a sum of numbers of all dynamic class versions of each node in the preset class hierarchical model meets a preset condition;

and a second generation module, configured to create a second class loader when a sum of numbers of all dynamic class versions of each node in the preset class hierarchical model does not satisfy a preset condition, and generate, by using the second class loader, a new dynamic class of each node in the preset class hierarchical model based on new meta information of a dynamic class in the target node and meta information of dynamic classes in other nodes except the target node in the preset class hierarchical model.

Further, to achieve the above object, the present invention also provides a form dynamic processing apparatus including: the dynamic table processing method comprises a memory, a processor and a dynamic table processing program which is stored on the memory and can run on the processor, wherein the dynamic table processing program realizes the steps of the dynamic table processing method when being executed by the processor.

In addition, to achieve the above object, the present invention further provides a computer readable storage medium, having a table dynamic processing program stored thereon, which, when being executed by a processor, implements the steps of the table dynamic processing method as described above.

The invention provides a table dynamic processing method, equipment and a computer readable storage medium, which are used for acquiring meta-information of a current excel and determining whether the current excel changes or not according to the meta-information of the current excel and a preset class level model; if the current excel is determined to be changed, determining new meta-information of a dynamic class of the current excel in a target node corresponding to the preset class hierarchical model according to the meta-information of the current excel; when the sum of the number of all dynamic class versions of each node in the preset class hierarchical model meets a preset condition, generating a new dynamic class of the target node through a first class loader based on new meta-information of the dynamic class in the target node; and when the sum of the number of all the dynamic class versions of each node in the preset class hierarchical model does not meet a preset condition, creating a second class loader, and generating a new dynamic class of each node in the preset class hierarchical model through the second class loader based on the new meta-information of the dynamic class in the target node and the meta-information of the dynamic class in other nodes except the target node in the preset class hierarchical model.

By the method, the dynamic class corresponding to the changed excel can be generated without POI, so that the existing excel processing mode such as easy poii or easy excel can process the changed excel through the dynamic class, namely, the dynamic change of the excel is supported in the excel processing process, the processing complexity of the dynamic header of the excel is reduced, and the processing efficiency of the dynamic excel is improved; and when the condition of replacing the class loader is triggered by the updated version number of the dynamic class, a new class loader is created, and the new dynamic classes of all nodes are regenerated by the new class loader, so that the old class loader can be unloaded, the memory is released, and the problem of memory overflow caused by the fact that the same class loader is used for generating the dynamic classes all the time is solved.

Drawings

FIG. 1 is a schematic diagram of an apparatus architecture of a hardware operating environment according to an embodiment of the present invention;

FIG. 2 is a flowchart illustrating a table dynamic processing method according to a first embodiment of the present invention;

FIG. 3 is a schematic diagram of a global excel according to the dynamic table processing method of the present invention;

FIG. 4 is a schematic diagram of a class hierarchy model obtained by class modeling of the global excel in FIG. 3;

FIG. 5 is a schematic diagram of different versions of dynamic classes generated by different class loaders;

FIG. 6 is a diagram of global index information;

FIG. 7 is a functional block diagram of a table dynamic processing apparatus according to a first embodiment of the present invention.

The implementation, functional features and advantages of the objects of the present invention will be further explained with reference to the accompanying drawings.

Detailed Description

It should be understood that the specific embodiments described herein are merely illustrative of the invention and are not intended to limit the invention.

Referring to fig. 1, fig. 1 is a schematic device structure diagram of a hardware operating environment according to an embodiment of the present invention.

The dynamic table processing device in the embodiment of the present invention may be a smart phone, or may be a terminal device such as a PC (personal computer), a tablet computer, or a portable computer.

As shown in fig. 1, the table dynamic processing device may include: a processor 1001, such as a CPU, a communication bus 1002, a user interface 1003, a network interface 1004, and a memory 1005. Wherein a communication bus 1002 is used to enable connective communication between these components. The user interface 1003 may include a Display screen (Display), an input unit such as a Keyboard (Keyboard), and the optional user interface 1003 may also include a standard wired interface, a wireless interface. The network interface 1004 may optionally include a standard wired interface, a wireless interface (e.g., a Wi-Fi interface). The memory 1005 may be a high-speed RAM memory or a non-volatile memory (e.g., a magnetic disk memory). The memory 1005 may alternatively be a storage device separate from the processor 1001.

Those skilled in the art will appreciate that the table dynamic processing device configuration shown in FIG. 1 does not constitute a limitation of the table dynamic processing device and may include more or fewer components than shown, or some components may be combined, or a different arrangement of components.

As shown in fig. 1, a memory 1005, which is a kind of computer storage medium, may include an operating system, a network communication module, and a table dynamic processing program therein.

In the terminal shown in fig. 1, the network interface 1004 is mainly used for connecting to a backend server and performing data communication with the backend server; the user interface 1003 is mainly used for connecting a client and performing data communication with the client; and the processor 1001 may be configured to call the table dynamic handler stored in the memory 1005 and perform the following operations:

obtaining meta-information of a current excel, and determining whether the current excel is changed or not according to the meta-information of the current excel and a preset class level model;

if the current excel is determined to be changed, determining new meta-information of a dynamic class of the current excel in a target node corresponding to the preset class hierarchical model according to the meta-information of the current excel;

when the sum of the number of all dynamic class versions of each node in the preset class hierarchical model meets a preset condition, generating a new dynamic class of the target node through a first class loader based on new meta-information of the dynamic class in the target node;

and when the sum of the number of all the dynamic class versions of each node in the preset class hierarchical model does not meet a preset condition, creating a second class loader, and generating a new dynamic class of each node in the preset class hierarchical model through the second class loader based on the new meta-information of the dynamic class in the target node and the meta-information of the dynamic class in other nodes except the target node in the preset class hierarchical model.

Further, the processor 1001 may call the table dynamic handler stored in the memory 1005, and further perform the following operations:

determining whether a target node corresponding to the current excel exists in the preset class hierarchical model or not according to global index information and a name identifier in the meta-information of the current excel, wherein the global index information comprises a mapping relation between each excel after the latest change and each node in the preset class hierarchical model;

and if the target node corresponding to the current excel does not exist in the preset class hierarchical model, determining that the current excel is changed.

Further, the processor 1001 may call the table dynamic handler stored in the memory 1005, and further perform the following operations:

after the step of obtaining the meta-information of the dynamic header in the excel and determining whether a target node corresponding to the dynamic header in the excel exists in a preset class hierarchical model according to the name identifier in the meta-information, the method further comprises the following steps:

if a target node corresponding to the current excel exists in the preset class hierarchical model, comparing column name information in meta information of dynamic classes in the target node with column name information in meta information of the current excel, or comparing column type information in meta information of dynamic classes in the target node with column type information in meta information of the current excel;

if the column name information in the meta information of the dynamic class in the target node is different from the column name information in the meta information of the current excel, or the column type information in the meta information of the dynamic class in the target node is different from the column type information in the meta information of the current excel, determining that the current excel is changed;

and if the column name information in the meta information of the dynamic class in the target node is the same as the column name information in the meta information of the current excel, and the column type information in the meta information of the dynamic class in the target node is the same as the column type information in the meta information of the current excel, determining that the current excel is not changed.

Further, the processor 1001 may call the table dynamic handler stored in the memory 1005, and further perform the following operations:

if the current excel is determined to be changed, creating a node corresponding to the current excel in the preset class hierarchical model according to the parent-child reference relation of the current excel, and using the node as a target node;

and determining new meta-information of the dynamic class in the target node according to the meta-information of the current excel.

Further, the processor 1001 may call the table dynamic handler stored in the memory 1005, and further perform the following operations:

determining whether the current excel comprises sub excels according to column type information in the meta information of the current excel;

if the current excel does not comprise the sub excel, executing the following steps: and determining new meta-information of a dynamic class of the current excel in a corresponding target node in the preset class hierarchical model according to the meta-information of the current excel.

Further, the processor 1001 may call the table dynamic handler stored in the memory 1005, and further perform the following operations:

if the current excel comprises sub excels, acquiring meta-information of the sub excels, and determining whether the sub excels are changed according to the meta-information of the sub excels and a preset class level model;

if the sub excel is determined to be changed, determining new meta-information of a dynamic class of the sub excel in sub target nodes corresponding to the sub excel in the preset class hierarchical model according to the meta-information of the sub excel;

when the sum of the number of all the dynamic class versions of each node in the preset class hierarchical model meets a preset condition, generating a new dynamic class of the sub-target node through a first class loader based on new meta-information of the dynamic class in the sub-target node;

and after the generation of the new dynamic class of the sub-target node is finished, regenerating the new dynamic class of the target node through the first class loader based on the meta-information of the dynamic class in the target node.

And when the sum of the number of all the dynamic class versions of each node in the preset class hierarchical model does not meet a preset condition, creating a second class loader, and generating a new dynamic class of each node in the preset class hierarchical model through the second class loader based on the new meta-information of the dynamic class in the sub-target node and the meta-information of the dynamic class in other nodes except the sub-target node in the preset class hierarchical model.

Further, the processor 1001 may call the table dynamic handler stored in the memory 1005, and further perform the following operations:

determining whether the dynamic class in the target node comprises a class corresponding to the static field or not based on the new meta-information of the dynamic class in the target node;

determining the type of a byte code generator according to whether the dynamic class in the target node comprises a class corresponding to the static field;

generating a new dynamic class for the target node by the first class loader and the determined bytecode generator;

correspondingly, the processor 1001 may call the table dynamic processing program stored in the memory 1005, and further perform the following operations:

determining whether the dynamic class in each node comprises a class corresponding to the static field or not based on the meta-information of the dynamic class in each node;

determining the type of the byte code generator corresponding to each node according to whether the dynamic class of each node comprises the class corresponding to the static field;

generating a new dynamic class for the respective node through the second class loader and the determined bytecode generator.

Further, the processor 1001 may call the table dynamic handler stored in the memory 1005, and further perform the following operations:

if the dynamic class in the target node comprises a class corresponding to the static field, determining the type of the byte code generator as a first byte code generator, and generating a new byte code file by the first byte code generator through a combination mode and an inheritance mode;

if the dynamic class in the target node does not comprise the class corresponding to the static field, determining the type of the byte code generator as a second byte code generator, and generating a new byte code file by the second byte code generator through a combination mode;

correspondingly, the processor 1001 may call the table dynamic processing program stored in the memory 1005, and further perform the following operations:

if the dynamic class in the node comprises a class corresponding to the static field, determining the type of the byte code generator as a first byte code generator, and generating a new byte code file by the first byte code generator through a combination mode and an inheritance mode;

and if the dynamic class in the node does not comprise the class corresponding to the static field, determining the type of the byte code generator as a second byte code generator, and generating a new byte code file by the second byte code generator through a combination mode.

Further, the processor 1001 may call the table dynamic handler stored in the memory 1005, and further perform the following operations:

and if the fact that the target node has a parent node in the preset class hierarchical model is determined according to the parent-child reference relation of the dynamic class in the target node, regenerating a new dynamic class of the parent node through the first class loader based on the meta-information of the dynamic class in the parent node.

Based on the above hardware structure, embodiments of the table dynamic processing method of the present invention are provided.

The invention provides a table dynamic processing method.

Referring to fig. 2, fig. 2 is a flowchart illustrating a table dynamic processing method according to a first embodiment of the present invention.

In this embodiment, the dynamic table processing method includes:

step S10, acquiring meta-information of the current excel, and determining whether the current excel is changed or not according to the meta-information of the current excel and a preset class level model;

the form dynamic processing method of the embodiment is realized by form dynamic processing equipment, a preset class hierarchical model is loaded in the equipment, and any complex excel can be decomposed into a corresponding class hierarchical model. The preset class hierarchical model is a hierarchical relationship among nodes obtained by performing recursive class modeling on excel from an uppermost layer header to a lower layer header layer by layer, and each node comprises class, class meta-information and a reference relationship between a father node and a son node pointed by the node, namely a father-son reference relationship, so that the preset class hierarchical model is called as a class hierarchical model. Specifically, the table headers of the top layer of the excel are split from the top layer to the bottom layer line by line, each table header in the excel can be abstracted into a class, each class corresponds to one node in a preset class level model, and the relation between the top layer table header and the bottom layer table header in the excel corresponds to the parent-child reference relation in the preset class level model.

The meta information of the class describes structure information of the class, which includes, but is not limited to, a name identifier (excelname), column name information (columnamemap), column type information (columnTypeMap), and the like.

Referring to fig. 3 and 4, fig. 3 is a global excel table, fig. 4 is a class hierarchical model obtained by class modeling of the global excel table shown in fig. 3, each header in the global excel shown in fig. 3 is equivalent to a small excel, each small excel has a node corresponding thereto in the class hierarchical model, in this embodiment, the current excel may be any small excel, an ExcelA node in fig. 4 corresponds to a header a in fig. 3, an ExcelB node corresponds to a header b in fig. 3, an ExcelA1 node corresponds to a header a1 in fig. 3, and an ExcelB32 node corresponds to a header b32 in fig. 3.

In this embodiment, the dynamic table processing device may obtain the meta-information of the current excel according to a certain frequency, in real time, or when a trigger condition is met, so as to determine whether the current excel changes according to the meta-information of the current excel and a preset hierarchy model, where the current excel change is generally divided into two types, namely, newly-added excel and originally-updated excel. The content included in the excel meta-information corresponds to the class meta-information, and includes, but is not limited to, a name identifier (excelname), column name information (columnamemap), column type information (columnTypeMap), and the like.

Step S20, if the current excel is determined to be changed, determining new meta-information of a dynamic class of the current excel in a target node corresponding to the preset class hierarchical model according to the meta-information of the current excel;

and if the current excel is determined to be changed, determining new meta-information of the dynamic class of the current excel in the corresponding target node in the preset class hierarchical model according to the meta-information of the current excel.

Step S30, when the sum of the number of all the dynamic class versions of each node in the preset class hierarchical model meets a preset condition, generating a new dynamic class of the target node through a first class loader based on new meta-information of the dynamic class in the target node;

after determining the new meta information of the dynamic class in the target node, before performing step S30, it is determined whether the sum of the numbers of all dynamic class versions of each node in the preset class hierarchical model satisfies the preset condition, and if so, step S30 is performed, that is, a new dynamic class of the target node is generated through the first class loader based on the new meta information of the dynamic class in the target node. The first class loader is a class loader used when a new dynamic class is generated according to the changed global excel after the global excel is changed for the last time.

Further, the preset condition is that the sum of the numbers of all dynamic class versions of each node in the preset class hierarchical model is smaller than a preset number threshold, or the ratio of the sum of the numbers of the latest dynamic class versions of each node in the preset class hierarchical model to the sum of the numbers of all dynamic class versions of each node is larger than a preset ratio threshold.

In this embodiment, referring to fig. 5, after the update of the dynamic class in the node is completed each time, that is, after a new version of the dynamic class is generated, the version number corresponding to the updated dynamic class is updated. The table dynamic processing equipment counts the total number of the versions of the dynamic class updates in all the nodes in the preset class hierarchical model, and if the total number of all the dynamic class versions of all the nodes in the preset class hierarchical model is smaller than a preset number threshold, or the ratio of the total number of the latest dynamic class versions of all the nodes in the preset class hierarchical model to the total number of all the dynamic class versions of all the nodes in the preset class hierarchical model is larger than a preset ratio threshold. The preset number threshold and the preset ratio threshold are set by operation and maintenance personnel according to the requirement of memory release.

For example, the class level model shown in the upper diagram in fig. 5 includes six nodes, i.e., an ExcelNode1, an ExcelNode2, an ExcelNode3, an ExcelNode4, an ExcelNode5, and an ExcelNode6, where the number of times of dynamic class update of the ExcelNode1 is 3, and the version number of the latest version of the ExcelNode1 is V3; the dynamic class updating times of the ExcelNode2 are 2, and the version number of the latest version of the ExcelNode2 is V2; the dynamic class updating times of the ExcelNode3 are 1, and the version number of the latest version of the ExcelNode3 is V1; the dynamic class updating times of the ExcelNode4 are 2, and the version number of the latest version of the ExcelNode4 is V2; the number of times of updating the dynamic class of the ExcelNode5 is 1, the version number of the latest version of the ExcelNode5 is V1, and the dynamic classes of the versions of the above nodes are all generated by an old class loader classloader (old), i.e. the first class loader.

Step S40, when the sum of the numbers of all the dynamic class versions of each node in the preset class hierarchical model does not satisfy a preset condition, creating a second class loader, and generating a new dynamic class of each node in the preset class hierarchical model through the second class loader based on the new meta information of the dynamic class in the target node and the meta information of the dynamic class in other nodes except the target node in the preset class hierarchical model.

The dynamic class is updated by the scheme, the class loaders used before and after the update are the same, and as the class loaders are not changed, the old classes loaded by the class loaders cannot be unloaded, so that the memory of a JVM (Java virtual machine) is always increased and cannot be released, and the problem of time is only caused when the memory overflows with the increase of the updating times.

In order to solve the problem that the memory cannot be released, this embodiment provides a solution, with reference to fig. 5, on the basis of the foregoing embodiment, if the sum of the numbers of all the dynamic class versions in each node in a preset class hierarchy model does not satisfy a preset condition, that is, when the sum of the numbers of all the dynamic class versions of each node in the preset class hierarchy model is greater than or equal to a preset number threshold, or when the ratio of the sum of the numbers of the latest versions of each node in the preset class hierarchy model to the sum of the numbers of all the dynamic class versions of each node is less than or equal to a preset ratio threshold, step S40 is executed to create a new class loader classloader (new), that is, a second class loader, and a new dynamic class of each node is generated by the second class loader based on meta information of the dynamic class of the latest version in all the nodes in the preset class hierarchy model, this process naturally also includes generating new dynamic classes for the target node.

Further, after a new dynamic class of each node is generated by the second class loader, the version number corresponding to the dynamic class of each node is also updated.

The embodiment of the invention provides a form dynamic processing method, which comprises the steps of acquiring meta-information of a current excel in an excel processing process, and determining whether the current excel changes or not according to the meta-information of the current excel and a preset class level model; if the current excel is determined to be changed, determining new meta-information of a dynamic class of the current excel in a target node corresponding to the preset class hierarchical model according to the meta-information of the current excel; when the sum of the number of all dynamic class versions of each node in the preset class hierarchical model meets a preset condition, generating a new dynamic class of the target node through a first class loader based on new meta-information of the dynamic class in the target node; and when the sum of the number of all the dynamic class versions of each node in the preset class hierarchical model does not meet a preset condition, creating a second class loader, and generating a new dynamic class of each node in the preset class hierarchical model through the second class loader based on the new meta-information of the dynamic class in the target node and the meta-information of the dynamic class in other nodes except the target node in the preset class hierarchical model.

By the method, the dynamic class corresponding to the changed excel can be generated without POI, so that the existing excel processing mode such as easy poii or easy excel can process the changed excel through the dynamic class, namely, the dynamic change of the excel is supported in the excel processing process, the processing complexity of the dynamic header of the excel is reduced, and the processing efficiency of the dynamic excel is improved; and when the condition of replacing the class loader is triggered by the updated version number of the dynamic class, a new class loader is created, and the new dynamic classes of all nodes are regenerated by the new class loader, so that the old class loader can be unloaded, the memory is released, and the problem of memory overflow caused by the fact that the same class loader is used for generating the dynamic classes all the time is solved.

Further, based on the first embodiment shown in fig. 2, a second embodiment of the table dynamic processing method of the present invention is provided.

In this embodiment, the step of determining whether the current excel has changed according to the meta information of the current excel and the preset class hierarchy model in step S10 specifically includes:

step S11, determining whether a target node corresponding to the current excel exists in the preset class hierarchical model or not according to global index information and name identification in the meta-information of the current excel, wherein the global index information comprises the mapping relation between each excel after the latest change and each node in the preset class hierarchical model;

step S12, if there is no target node corresponding to the current excel in the preset class hierarchical model, determining that the current excel has changed.

Referring to fig. 6, in this embodiment, the dynamic table processing device maintains global index information, where the global index information reflects a mapping relationship between a name identifier (excelname) of each excel in the global excel that has changed last time and each node in the preset hierarchy model, and to determine whether the current excel has changed, it is first determined whether the current excel is a newly added excel. Specifically, whether the name identifier of the current excel is included in the global index information (ExcelNameMap) is determined, if not, it is indicated that a target node corresponding to the current excel does not exist in the preset class hierarchical model, and then it is indicated that the current excel is a newly added excel, and it can be determined that the current excel is changed. Wherein the global index information (excelNameMap) may be a hash table facilitating efficient retrieval and privacy.

According to the method and the device, whether the current excel changes or not is determined through the global index information, and the efficiency of the determination process can be improved.

Further, if there is no target node corresponding to the current excel in the preset class hierarchical model, the step S20 includes:

step S21, if the current excel is determined to be changed, creating a node corresponding to the current excel in the preset class hierarchical model according to the parent-child reference relation of the current excel, and using the node as a target node;

step S22, determining new meta-information of the dynamic class in the target node according to the meta-information of the current excel.

In this embodiment, each excel or node has a corresponding parent-child reference relationship, and for an excel, the parent-child reference relationship represents a structural relationship between the current excel and other excels, for example, in fig. 3, excel a1 is a child excel of excel a, and excel b3 is a parent excel of excel b31 and excel b 32; for a node, the parent-child reference relationship represents the structural relationship between the current node and other nodes, for example, in fig. 4, an Excel a4 node is a child node of an Excel a node, and an Excel B3 node is a parent Excel of an Excel B31 node and an Excel B32 node.

If the current excel is the newly added excel, a new node corresponding to the current excel is created in the preset class hierarchical model according to the parent-child reference relation of the current excel and serves as a target node, and then new meta-information of a dynamic class in the target node is determined according to the meta-information of the current excel.

Further, if the global index information includes the name identifier of the current excel, although it can be described that a target node corresponding to the current excel exists in the preset class hierarchical model, it cannot be determined whether the current excel is updated, and therefore, it is necessary to further compare the meta information of the current excel with the meta information of the target node to determine whether the current excel is changed.

Specifically, after the step S11, the method further includes:

step S13, if a target node corresponding to the current excel exists in the preset class hierarchical model, comparing the column name information in the meta information of the dynamic class in the target node with the column name information in the meta information of the current excel, or comparing the column type information in the meta information of the dynamic class in the target node with the column type information in the meta information of the current excel;

step S14, if the column name information in the meta information of the dynamic class in the target node is different from the column name information in the meta information of the current excel, or the column type information in the meta information of the dynamic class in the target node is different from the column type information in the meta information of the current excel, determining that the current excel has changed;

step S15, if the column name information in the meta information of the dynamic class in the target node is the same as the column name information in the meta information of the current excel, and the column type information in the meta information of the dynamic class in the target node is the same as the column type information in the meta information of the current excel, determining that the current excel has not changed.

In this embodiment, a specific process of determining whether the current excel is updated or not is performed, and column name information (columnNameMap) in the meta information of the dynamic class in the target node is compared with column name information in the meta information of the current excel, or column type information (columnTypeMap) in the meta information of the dynamic class in the target node is compared with column type information in the meta information of the current excel; determining that the current excel is changed as long as one of the column name information and the column type information of the current excel is inconsistent with the target node; and if one of the column name information and the column type information of the current excel is completely the same as the target node, determining that the current excel is unchanged, and not needing to update the dynamic class.

Further, if a target node corresponding to the current excel exists in the preset class hierarchical model and the current excel is changed, before step S20, the method further includes:

step S201, determining whether the current excel comprises a sub excel according to column type information in the meta information of the current excel;

if the current excel does not comprise the sub excel, executing the following steps: and determining new meta-information of a dynamic class of the current excel in a corresponding target node in the preset class hierarchical model according to the meta-information of the current excel.

In this embodiment, if a target node corresponding to the current excel exists in the preset class hierarchical model and the current excel is changed, whether to update meta information of the dynamic class in the target node needs to be determined according to whether the current excel includes a sub excel. Specifically, the column type information in the meta-information of the current excel can reflect the type of each header in the excel, whether the current excel includes a sub-excel can be determined according to the column type information, and if the current excel does not include a sub-excel, step S20 is executed; and if the current excel comprises the sub excel, executing a step of updating the sub target node corresponding to the sub excel.

Further, if the column type information in the meta-information of the current excel includes a preset sub-excel identifier, the current excel is considered to include the sub-excel, and if the column type information in the meta-information of the current excel does not include the preset sub-excel identifier, the current excel is considered not to include the sub-excel.

Further, if the current excel includes a child excel, the step of updating the child target node corresponding to the child excel specifically includes:

step A, if the current excel comprises a sub excel, acquiring meta-information of the sub excel, and determining whether the sub excel is changed according to the meta-information of the sub excel and a preset class level model;

step B, if the sub excel is determined to be changed, determining new meta-information of the dynamic class of the sub excel in the sub target nodes corresponding to the sub excel in the preset class hierarchical model according to the meta-information of the sub excel;

step C, when the sum of the number of all the dynamic class versions of each node in the preset class hierarchical model meets a preset condition, generating a new dynamic class of the sub-target nodes through a first class loader based on new meta-information of the dynamic class in the sub-target nodes;

step D, after the generation of the new dynamic class of the sub-target node is finished, the new dynamic class of the target node is regenerated through the first class loader based on the meta-information of the dynamic class in the target node;

in this embodiment, the order of updating the dynamic class is performed according to the preset class hierarchical model from bottom to top, and the order of updating the child node and then updating the parent node, and the process of updating the child target node is similar to that of the target node.

If the current excel comprises the sub excel, acquiring meta-information of the sub excel, and determining whether the sub excel is changed according to the meta-information of the sub excel and a preset class level model; if yes, determining new meta-information of a dynamic class of the sub-excel in sub-target nodes corresponding to the sub-excel in a preset class hierarchical model according to the meta-information of the sub-excel, similar to the target node, before the step B, determining whether the sub-excel further comprises the sub-excel according to column type information in the meta-information of the sub-excel, namely the sub-excel, if not, executing the step B, if yes, executing a step of updating the sub-target nodes corresponding to the sub-excel, and the step of updating the sub-excel, the sub-excel and the corresponding nodes is a recursive process.

After determining the new meta information of the dynamic class in the sub-target node and before executing the step D or E, counting the total number of all dynamic class versions of each node in the preset class hierarchical model, determining whether the total number of all dynamic class versions in each node in the preset class hierarchical model meets a preset condition, if so, executing the step D, and if not, executing the step E.

And E, when the sum of the number of all the dynamic class versions of each node in the preset class hierarchical model does not meet a preset condition, creating a second class loader, and generating a new dynamic class of each node in the preset class hierarchical model through the second class loader based on the new meta-information of the dynamic classes in the sub-target nodes and the meta-information of the dynamic classes in other nodes except the sub-target nodes in the preset class hierarchical model.

If the sum of the number of all the versions of the dynamic class in each node in the preset class hierarchical model does not meet the preset condition, a new class loader, namely a second class loader is created, and based on the meta-information of the dynamic class of the latest version in all the nodes in the preset class hierarchical model, the second class loader is used for generating the new dynamic class of each node, wherein the process naturally also comprises the generation of the new dynamic class of the target node and the new dynamic class of the sub-target node.

It should be noted that the meta-information in the sub-target node and the dynamic class update process may be reused.

Further, based on the first and second embodiments, a third embodiment of the table dynamic processing method of the present invention is provided.

In this embodiment, the step S30 of generating a new dynamic class of the target node through the first class loader based on the new meta information of the dynamic class in the target node includes:

step S31, determining whether the dynamic class in the target node includes a class corresponding to the static field based on the new meta-information of the dynamic class in the target node;

step S32, determining the type of the byte code generator according to whether the dynamic class in the target node comprises the class corresponding to the static field;

step S33, generating a new dynamic class of the target node through the first class loader and the determined bytecode generator.

Correspondingly, in step S40, the step of generating, by the second class loader, a new dynamic class of each node in the preset class hierarchical model based on the new meta information of the dynamic class in the target node and the meta information of the dynamic class in the other nodes except the target node in the preset class hierarchical model includes:

step S41, based on the meta-information of the dynamic class in each node, determining whether the dynamic class in each node includes a class corresponding to the static field;

step S42, determining the type of the byte code generator corresponding to each node according to whether the dynamic class of each node includes the class corresponding to the static field;

and step S43, generating a new dynamic class of each node through the second class loader and the determined byte code generator.

In this embodiment, the process of generating a new dynamic class is to generate a bytecode file through a bytecode generator based on the meta information, then load the bytecode file through a class loader, and generate a dynamic class after the loading is successful. Therefore, a bytecode generator is needed in the process of generating a new dynamic class, and the bytecode generator comprises a first bytecode generator and a second bytecode generator, wherein the first bytecode generator generates a new bytecode file through a combination mode and an inheritance mode, and the second bytecode generator generates a new bytecode file through a combination mode.

Determining which bytecode generator generates the bytecode file needs to determine whether the dynamic class in the target node includes the class corresponding to the static field according to the new meta-information of the dynamic class in the target node, if so, determining the type of the bytecode generator as a first bytecode generator, if not, determining the type of the bytecode generator as a second bytecode generator, and after determining the type of the bytecode generator, generating the new dynamic class of the target node by combining with the corresponding class loader. It will be appreciated that the bytecode generators employed for the generation of new dynamic classes in different nodes may be the same or different.

Further, step S30 is followed by:

and if the fact that the target node has a parent node in the preset class hierarchical model is determined according to the parent-child reference relation of the dynamic class in the target node, regenerating a new dynamic class of the parent node through the first class loader based on the meta-information of the dynamic class in the parent node.

In this embodiment, the logic of the dynamic class in the update node is from child to parent from bottom to top, and therefore, if it is determined that the target node includes a parent according to the parent-child reference relationship of the dynamic class in the target node, after the new dynamic class of the target node is generated, the parent of the target node needs to be notified to regenerate the new dynamic class of the parent through the first class loader based on the meta-information of the parent, and so on, from step to step upwards until all the parent of the target node complete the update of the dynamic class.

In this embodiment, updating is performed in the order of child class first and parent class second, so that the hierarchy and stability of dynamic class updating can be ensured.

The invention also provides a form dynamic processing device.

Referring to fig. 7, fig. 7 is a functional module diagram of the table dynamic processing device according to the first embodiment of the present invention.

As shown in fig. 7, the table dynamic processing device includes:

the change determining module 10 is configured to obtain meta-information of a current excel, and determine whether the current excel changes according to the meta-information of the current excel and a preset class hierarchy model;

a meta-information determining module 20, configured to determine, according to the meta-information of the current excel, new meta-information of a dynamic class in a target node corresponding to the current excel in the preset class hierarchical model if it is determined that the current excel has changed;

a first generating module 30, configured to generate, by a first class loader, a new dynamic class of the target node based on new meta information of the dynamic class in the target node when a sum of numbers of all dynamic class versions of each node in the preset class hierarchical model satisfies a preset condition;

a second generating module 40, configured to create a second class loader when a sum of numbers of all dynamic class versions of each node in the preset class hierarchical model does not satisfy a preset condition, and generate a new dynamic class of each node in the preset class hierarchical model through the second class loader based on new meta information of a dynamic class in the target node and meta information of dynamic classes in other nodes except the target node in the preset class hierarchical model.

The function implementation of each module in the table dynamic processing apparatus corresponds to each step in the table dynamic processing method embodiment, and the function and implementation process thereof are not described in detail here.

The present invention further provides a computer-readable storage medium, which stores a table dynamic processing program, and when the table dynamic processing program is executed by a processor, the computer-readable storage medium implements the steps of the table dynamic processing method according to any one of the above embodiments.

The specific embodiment of the computer-readable storage medium of the present invention is substantially the same as the embodiments of the table dynamic processing method described above, and is not repeated herein.

It should be noted that, in this document, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or system that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or system. Without further limitation, an element defined by the phrase "comprising an … …" does not exclude the presence of other like elements in a process, method, article, or system that comprises the element.

The above-mentioned serial numbers of the embodiments of the present invention are merely for description and do not represent the merits of the embodiments.

Through the above description of the embodiments, those skilled in the art will clearly understand that the method of the above embodiments can be implemented by software plus a necessary general hardware platform, and certainly can also be implemented by hardware, but in many cases, the former is a better implementation manner. Based on such understanding, the technical solution of the present invention may be embodied in the form of a software product, which is stored in a storage medium (e.g., ROM/RAM, magnetic disk, optical disk) as described above and includes instructions for enabling a terminal device (e.g., a mobile phone, a computer, a server, an air conditioner, or a network device) to execute the method according to the embodiments of the present invention.

The above description is only a preferred embodiment of the present invention, and not intended to limit the scope of the present invention, and all modifications of equivalent structures and equivalent processes, which are made by using the contents of the present specification and the accompanying drawings, or directly or indirectly applied to other related technical fields, are included in the scope of the present invention.