CN116069848A

CN116069848A - Method, device, equipment, storage medium and product for generating data reporting interface

Info

Publication number: CN116069848A
Application number: CN202310179492.4A
Authority: CN
Inventors: 洪耀辉; 彭薇雯; 王雪凝; 王雪峰; 胡雪惠
Original assignee: China Construction Bank Corp; CCB Finetech Co Ltd
Current assignee: China Construction Bank Corp; CCB Finetech Co Ltd
Priority date: 2023-02-28
Filing date: 2023-02-28
Publication date: 2023-05-05

Abstract

The invention discloses a method, a device, equipment, a storage medium and a product for generating a datagram sending interface. The invention relates to the technical field of big data. The method comprises the following steps: under the condition of receiving a data report request sent by first terminal equipment, acquiring an information table of a first service system and an information table of a second service system; comparing the information table of the first service system with the information table of the second service system, and generating an interface table structure change record table based on a comparison result; generating an interface table based on the interface table structure change record table; the interface table is used for writing the report data of the first terminal equipment; and sending the report data in the interface table to third terminal equipment corresponding to the first service system. According to the technical scheme, the automatic generation of the data reporting interface is realized, and the technical effect of improving the interface generation efficiency can be achieved.

Description

Method, device, equipment, storage medium and product for generating data reporting interface

Technical Field

The embodiment of the invention relates to the technical field of big data, in particular to a method, a device, equipment, a storage medium, a product and a data reporting system for generating a data reporting interface.

Background

With the continuous development of digital technology, data acquisition and access are increasingly used in various fields.

In the parallel list management, the collection and access of data can be realized through data interfaces, in the prior art, the data interfaces are more, manual intervention is needed in the adjustment process, the operations of compiling files, version online and the like are performed, and the problem of low generation efficiency of the data interfaces exists.

Disclosure of Invention

The embodiment of the invention provides a method, a device, equipment, a storage medium, a product and a data reporting system for generating a data reporting interface, which are used for solving the problem of low interface generation efficiency.

In a first aspect, an embodiment of the present invention provides a method for generating a datagram interface, which is applied to a second terminal device, including:

under the condition of receiving a data report request sent by first terminal equipment, acquiring an information table of a first service system and an information table of a second service system;

comparing the information table of the first service system with the information table of the second service system, and generating an interface table structure change record table based on a comparison result;

generating an interface table based on the interface table structure change record table; the interface table is used for writing the report data of the first terminal equipment;

And sending the report data in the interface table to third terminal equipment corresponding to the first service system.

In a second aspect, an embodiment of the present invention further provides a method for generating a datagram interface, which is applied to a first terminal device, including:

acquiring report data and sending a data report request to the second terminal equipment; the second terminal equipment is used for acquiring an information table of a first service system and an information table of a second service system under the condition of receiving a data report request sent by the first terminal equipment, comparing the information table of the first service system with the information table of the second service system, and generating an interface table structure change record table based on a comparison result; generating an interface table based on the interface table structure change record table;

sending the report data to the second terminal equipment; the second terminal device is configured to write the sending data into the interface table, and send the sending data in the interface table to a third terminal device corresponding to the first service system.

In a third aspect, an embodiment of the present invention further provides a method for generating a datagram interface, which is applied to a third terminal device, including:

Receiving report data in an interface table sent by second terminal equipment; the second terminal equipment is used for acquiring an information table of a first service system and an information table of a second service system under the condition of receiving a data report request sent by the first terminal equipment, comparing the information table of the first service system with the information table of the second service system, and generating an interface table structure change record table based on a comparison result; and generating an interface table based on the interface table structure change record table, writing the report data of the first terminal equipment into the interface table, and sending the report data in the interface table to a third terminal equipment corresponding to the first service system.

In a fourth aspect, an embodiment of the present invention further provides a device for generating a datagram interface, which is applied to a second terminal device, including:

the information table acquisition module is used for acquiring an information table of the first service system and an information table of the second service system under the condition of receiving a data report request sent by the first terminal equipment;

the information table comparison module is used for comparing the information table of the first service system with the information table of the second service system and generating an interface table structure change record table based on a comparison result;

The interface table generating module is used for generating an interface table based on the interface table structure change record table; the interface table is used for writing the report data of the first terminal equipment;

and the report data sending module is used for sending the report data in the interface table to third terminal equipment corresponding to the first service system.

In a fifth aspect, an embodiment of the present invention further provides a device for generating a datagram interface, which is applied to a first terminal device, including:

the data report request sending module is used for obtaining report data and sending a data report request to the second terminal equipment; the second terminal equipment is used for acquiring an information table of a first service system and an information table of a second service system under the condition of receiving a data report request sent by the first terminal equipment, comparing the information table of the first service system with the information table of the second service system, and generating an interface table structure change record table based on a comparison result; generating an interface table based on the interface table structure change record table;

the sending module of the report data, is used for sending the said report data to the said second terminal equipment; the second terminal device is configured to write the sending data into the interface table, and send the sending data in the interface table to a third terminal device corresponding to the first service system.

In a sixth aspect, an embodiment of the present invention further provides a device for generating a datagram interface, which is applied to a third terminal device, including:

the sending data receiving module is used for receiving sending data in the interface table sent by the second terminal equipment; the second terminal equipment is used for acquiring an information table of a first service system and an information table of a second service system under the condition of receiving a data report request sent by the first terminal equipment, comparing the information table of the first service system with the information table of the second service system, and generating an interface table structure change record table based on a comparison result; and generating an interface table based on the interface table structure change record table, writing the report data of the first terminal equipment into the interface table, and sending the report data in the interface table to a third terminal equipment corresponding to the first service system.

In a seventh aspect, an embodiment of the present invention further provides a data reporting system, including: the system comprises a first terminal device, a second terminal device and a third terminal device, wherein the second terminal device is respectively in communication connection with the first terminal device and the third terminal device;

The first terminal equipment is used for acquiring the report data and sending a data report request to the second terminal equipment;

the second terminal device is configured to obtain an information table of a first service system and an information table of a second service system when receiving a data report request sent by the first terminal device, compare the information table of the first service system with the information table of the second service system, and generate an interface table structure change record table based on a comparison result; generating an interface table based on the interface table structure change record table;

the first terminal device is further configured to send the report data to the second terminal device;

the second terminal device is further configured to write the sending data into the interface table, and send the sending data in the interface table to a third terminal device corresponding to the first service system;

and the third terminal equipment is used for receiving the report data in the interface table sent by the second terminal equipment.

In an eighth aspect, an embodiment of the present invention further provides an electronic device, including a memory, a processor, and a computer program stored in the memory and capable of running on the processor, where the processor implements a method for generating a datagram interface according to any one of the embodiments of the present invention when the processor executes the program.

In a ninth aspect, an embodiment of the present invention further provides a computer readable storage medium, where a computer program is stored, where the program when executed by a processor implements a method for generating a datagram interface according to any of the embodiments of the present invention.

In a tenth aspect, embodiments of the present invention further provide a computer program product comprising a computer program which, when executed by a processor, implements a method for generating a datagram interface according to any of the embodiments of the present invention.

In the embodiment of the invention, under the condition that the second terminal equipment receives the data report request sent by the first terminal equipment, the second terminal equipment acquires the information table of the first service system and the information table of the second service system, and further compares the information table of the first service system with the information table of the second service system, and generates an interface table structure change record table based on the comparison result, thereby realizing the record of difference information; and then, an interface table is generated based on the interface table structure change record table, so that the automatic generation of a data reporting interface is realized, reporting data of the first terminal equipment are written into the interface table, the reporting data in the interface table are sent to a third terminal equipment corresponding to the first service system, the data transmission is completed, manual intervention is not required in the process, and when the information table of the first service system is adjusted, the interface table is also automatically adjusted, so that the interface generation efficiency is improved.

Drawings

In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the drawings that are needed in the embodiments will be briefly described below, it being understood that the following drawings only illustrate some embodiments of the present invention and therefore should not be considered as limiting the scope, and other related drawings may be obtained according to these drawings without inventive effort for a person skilled in the art.

Fig. 1 is a flowchart of a method for generating a datagram interface according to an embodiment of the present invention;

fig. 2 is a flowchart of a method for generating a datagram interface according to an embodiment of the present invention;

fig. 3 is a flowchart of a method for generating a datagram interface according to an embodiment of the present invention;

fig. 4 is a flowchart of a method for generating a datagram interface according to an embodiment of the present invention;

fig. 5 is a flowchart of a method for generating a datagram interface according to an embodiment of the present invention;

fig. 6 is a flowchart of a method for generating a datagram interface according to an embodiment of the present invention;

fig. 7 is a schematic structural diagram of a generating device of a datagram interface according to an embodiment of the present invention;

Fig. 8 is a schematic structural diagram of a generating device of a datagram interface according to an embodiment of the present invention;

fig. 9 is a schematic structural diagram of a generating device of a datagram interface according to an embodiment of the present invention;

fig. 10 is a schematic structural diagram of a data reporting system according to an embodiment of the present invention;

FIG. 11 is a flowchart of a datagram sending process according to an embodiment of the present invention;

fig. 12 is a schematic structural diagram of an electronic device according to an embodiment of the present invention.

Detailed Description

The invention is described in further detail below with reference to the drawings and examples. It is to be understood that the specific embodiments described herein are merely illustrative of the invention and are not limiting thereof. It should be further noted that, for convenience of description, only some, but not all of the structures related to the present invention are shown in the drawings.

It should be noted that: like reference numerals and letters denote like items in the following figures, and thus once an item is defined in one figure, no further definition or explanation thereof is necessary in the following figures. Meanwhile, in the description of the present invention, the terms "first", "second", and the like are used only to distinguish the description, and are not to be construed as indicating or implying relative importance. The data acquisition, storage, use, processing and the like in the technical scheme meet the relevant regulations of national laws and regulations.

Fig. 1 is a flowchart of a method for generating a data reporting interface according to an embodiment of the present invention, where the method may be performed by a device for generating a data reporting interface, the device for generating a data reporting interface may be implemented in hardware and/or software, and the device for generating a data reporting interface may be configured in a second terminal device. As shown in fig. 1, the method includes:

s110, under the condition that a datagram sending request sent by the first terminal equipment is received, an information table of the first service system and an information table of the second service system are obtained.

In this embodiment, the first terminal device refers to an electronic device capable of sending report data. The second terminal device refers to an electronic device that can generate an interface table. The third terminal device refers to an electronic device that can receive the report data. The second terminal device is respectively connected with the first terminal device and the third terminal device in a communication manner, which may include a wired communication manner and a wireless communication manner, and is not limited herein. The report data refers to data to be reported to a downstream device, for example, may be monthly or quarterly report data of a bank. The datagram request refers to a request for sending the report data, and may be used to trigger the second terminal device to execute the interface generation job.

In an exemplary embodiment, the second terminal device may acquire the information table of the first service system from the first service system and acquire the information table of the second service system from the second service system when receiving the datagram request sent by the first terminal device. The first service system refers to a service system with a requirement for reporting data, and can be configured in the third terminal device. The second service system refers to a service system for implementing the parallel table operation, and can be configured in the second terminal device. The information table of the first service system may be a table sample information table, as shown in table 1, and may include, but is not limited to, report number, report name, table sample column number, field english name, field content, field type, field length, integer bit length, precision, and the like. The information table of the second service system may be a structural information table, and may include, but is not limited to, report number, serial number, table sample column number, field english name, field content, field type, field length, integer bit length, and precision, where the serial number is used for arranging the field sequence.

TABLE 1

TABLE 2

S120, comparing the information table of the first service system with the information table of the second service system, and generating an interface table structure change record table based on the comparison result.

In this embodiment, the comparison result may include difference information of the information table of the first service system and the information table of the second service system, in other words, the interface table structure change record table may be used to record difference information of the information table of the first service system and the information of the second service system.

For example, the information table of the first service system may be compared with the information table of the second service system to obtain the difference information of the information table of the first service system and the information table of the second service system, and then the difference information of the information table of the first service system and the information of the second service system may be written into the interface table structure change record table. As can be seen from table 1 and table 2, the difference information between the information table of the first service system and the information table of the second service system is that the fields of "transaction user" and the field length of "transaction number" are different; further, an interface table structure change record table is obtained according to the difference information, as shown in table 3.

TABLE 3 Table 3

S130, generating an interface table based on the interface table structure change record table; the interface table is used for writing the report data of the first terminal equipment.

Specifically, the interface table may be generated according to the change information or the difference information in the interface table structure change record table, so that the report data of the first terminal device may be loaded into the interface table, and the number of the interface tables may be one or more, which is not limited herein.

In some embodiments, the interface table structure change log table may also be converted to a database language, and the interface table is obtained by executing the database language.

In some embodiments, the number of the first terminal devices may be plural, specifically, the second terminal device may combine the reported data of each first terminal device in the interface table at the same time, so as to be used by the third terminal device at the downstream

And S140, sending the report data in the interface table to third terminal equipment corresponding to the first service system.

Specifically, after the report data of the first terminal device is loaded into the interface table, the second terminal device may send the report data in the interface table to the third terminal device corresponding to the first service system, so that no human intervention is required in the data transmission process, and the data transmission efficiency is improved.

In this embodiment, under the condition that the second terminal device receives the datagram sending request sent by the first terminal device, the second terminal device obtains the information table of the first service system and the information table of the second service system, and further compares the information table of the first service system with the information table of the second service system, and generates an interface table structure change record table based on the comparison result, so as to realize the record of difference information; and then, an interface table is generated based on the interface table structure change record table, so that the automatic generation of a data reporting interface is realized, reporting data of the first terminal equipment are written into the interface table, the reporting data in the interface table are sent to a third terminal equipment corresponding to the first service system, the data transmission is completed, manual intervention is not required in the process, and when the information table of the first service system is adjusted, the interface table is also automatically adjusted, so that the interface generation efficiency is improved.

Fig. 2 is a flowchart of a method for generating a datagram interface according to an embodiment of the present invention, where the method of this embodiment may be combined with each alternative scheme in the method for generating a datagram interface provided in the foregoing embodiment. The generation method of the datagram interface provided by the embodiment is further optimized. Optionally, the information table of the first service system includes a table sample information table of the downstream usage number system, and the information table of the second service system includes an interface structure information table of the parallel table system.

As shown in fig. 2, the method includes:

s210, under the condition that a datagram sending request sent by the first terminal equipment is received, a table sample information table of a downstream number system and an interface structure information table of a parallel table system are obtained.

S220, comparing the table sample information table of the downstream number system with the interface structure information table of the parallel table system, and generating an interface table structure change record table based on the comparison result.

S230, generating an interface table based on the interface table structure change record table; the interface table is used for writing the report data of the first terminal equipment.

S240, sending the report data in the interface table to a third terminal device corresponding to the downstream data system.

In this embodiment, the downstream data system refers to a downstream system having data usage requirements. The parallel list system refers to a system for completing the parallel list operation.

The first terminal device may be an upstream subsidiary device, the second terminal device may be a group transfer device, and the third terminal device may be a downstream parent device, specifically, when the group transfer device receives a data report request sent by the upstream subsidiary device, the group transfer device obtains a sample information table of the downstream data system and an interface structure information table of the parallel table system, further compares the sample information table of the downstream data system with the interface structure information table of the parallel table system to obtain difference information of the sample information table of the downstream data system and the interface structure information table of the parallel table system, further writes the difference information of the sample information table of the downstream data system and the interface structure information table of the parallel table system into the interface table structure change record table, further generates the interface table according to the interface table structure change record table, writes the report data of the upstream subsidiary device into the interface table, and sends the report data in the interface table to the downstream parent device corresponding to the downstream data system.

In this embodiment, under the condition that the second terminal device receives the datagram sending request sent by the first terminal device, the second terminal device obtains a table sample information table of the downstream number system and an interface structure information table of the parallel table system; comparing the table sample information table of the downstream use number system with the interface structure information table of the parallel table system, generating an interface table structure change record table based on the comparison result, and realizing the record of the difference information; the interface table is generated based on the interface table structure change record table, so that the automatic generation of the data reporting interface is realized, the reporting data of the first terminal equipment are written into the interface table, the reporting data in the interface table are transmitted to the third terminal equipment corresponding to the downstream number system, manual intervention is not needed in the process, and the interface table is automatically adjusted when the table sample information table of the downstream number system is adjusted, so that the interface generation efficiency is improved.

Fig. 3 is a flowchart of a method for generating a datagram interface according to an embodiment of the present invention, where the method of this embodiment may be combined with each alternative scheme in the method for generating a datagram interface provided in the foregoing embodiment. The generation method of the datagram interface provided by the embodiment is further optimized. Optionally, the generating the interface table based on the interface table structure change record table includes: generating a data definition statement based on the interface table structure change record table; and executing the data definition statement to obtain at least one interface table.

As shown in fig. 3, the method includes:

s310, under the condition that a datagram sending request sent by the first terminal equipment is received, an information table of the first service system and an information table of the second service system are obtained.

S320, comparing the information table of the first service system with the information table of the second service system, and generating an interface table structure change record table based on the comparison result.

S330, generating a data definition statement based on the interface table structure change record table, and executing the data definition statement to obtain at least one interface table; the interface table is used for writing the report data of the first terminal equipment.

And S340, sending the report data in the interface table to third terminal equipment corresponding to the first service system.

In this embodiment, the data definition statement (Data Definition Language, DDL) is a statement generated according to the change information in the interface table structure change record table, and after the data definition statement corresponding to the interface table structure change record table is generated, the data definition statement corresponding to the interface table structure change record table may be automatically executed, so as to obtain at least one interface table, where the number of interface tables may be determined according to the change information. Illustratively, the interface table may be as shown in table 4.

TABLE 4 Table 4

ORG_TXN_ID	BUY_NETPRC	CNTPR_NM

Where org_txn_id represents the transaction number, BUY _netprc represents the purchase amount, cntpr_nm represents the transaction user.

Based on the above embodiments, optionally, generating the interface table structure change record table based on the comparison result includes: and if the comparison result is the newly added field, generating an interface table structure change record table based on the content of the newly added field in the information table of the first service system.

For example, if a new field is added to the information table of the first service system compared to the information table of the second service system, the relevant information of the field may be written into the interface table structure change record table.

Based on the above embodiments, optionally, generating the interface table structure change record table based on the comparison result includes: and if the comparison result is the modified field length, generating an interface table structure change record table based on the field length in the information table of the first service system.

For example, if the information table of the first service system modifies the field length compared to the information table of the second service system, the field length in the information table of the first service system and the related information may be written into the interface table structure change record table.

According to the embodiment, the data definition statement can be generated according to the interface table structure change record table, and the data definition statement is executed to obtain at least one interface table, so that the automatic generation of the interface table is realized, and the interface generation efficiency is improved.

Fig. 4 is a flowchart of a method for generating a datagram interface according to an embodiment of the present invention, where the method of this embodiment may be combined with each alternative scheme in the method for generating a datagram interface provided in the foregoing embodiment. The generation method of the datagram interface provided by the embodiment is further optimized. Optionally, after comparing the information table of the first service system with the information table of the second service system, generating an interface table structure change record table based on the comparison result, the method further includes: and updating the information table of the second service system based on the interface table structure change record table to obtain an updated information table of the second service system.

As shown in fig. 4, the method includes:

s410, under the condition that a datagram sending request sent by the first terminal equipment is received, an information table of the first service system and an information table of the second service system are obtained.

S420, comparing the information table of the first service system with the information table of the second service system, and generating an interface table structure change record table based on the comparison result.

S430, generating an interface table based on the interface table structure change record table; the interface table is used for writing the report data of the first terminal equipment.

S440, updating the information table of the second service system based on the interface table structure change record table to obtain the updated information table of the second service system.

S450, sending the report data in the interface table to a third terminal device corresponding to the first service system.

It should be noted that, according to the change record table of the interface table structure, the information table of the second service system is updated, so that the information table of the second service system can be ensured to be kept up to date for the next comparison of the information tables. The updated information table of the second service system is shown in table 5.

TABLE 5

Optionally, on the basis of the foregoing embodiments, after generating the interface table based on the interface table structure change record table, the method further includes: and loading the report data of the first terminal equipment into an interface table for the first service system to use.

For example, after obtaining the interface table, the reporting data of the subsidiary device may be loaded into the interface table for use by the downstream consumption system.

According to the embodiment, the record table can be changed according to the interface table structure, the information table of the second service system is updated, and the information table of the second service system can be ensured to be kept up to date for next information table comparison.

Fig. 5 is a flowchart of a method for generating a data reporting interface according to an embodiment of the present invention, where the method may be performed by a device for generating a data reporting interface, the device for generating a data reporting interface may be implemented in hardware and/or software, and the device for generating a data reporting interface may be configured in a first terminal device. As shown in fig. 5, the method includes:

s510, acquiring report data and sending a data report request to the second terminal equipment; the second terminal equipment is used for acquiring an information table of a first service system and an information table of a second service system under the condition of receiving a data report request sent by the first terminal equipment, comparing the information table of the first service system with the information table of the second service system, and generating an interface table structure change record table based on a comparison result; and generating an interface table based on the interface table structure change record table.

S520, the report data is sent to the second terminal equipment; the second terminal device is configured to write the sending data into the interface table, and send the sending data in the interface table to a third terminal device corresponding to the first service system.

Fig. 6 is a flowchart of a method for generating a data reporting interface according to an embodiment of the present invention, where the method may be performed by a device for generating a data reporting interface, the device for generating a data reporting interface may be implemented in hardware and/or software, and the device for generating a data reporting interface may be configured in a third terminal device. As shown in fig. 6, the method includes:

S610, receiving report data in an interface table sent by the second terminal equipment; the second terminal equipment is used for acquiring an information table of a first service system and an information table of a second service system under the condition of receiving a data report request sent by the first terminal equipment, comparing the information table of the first service system with the information table of the second service system, and generating an interface table structure change record table based on a comparison result; and generating an interface table based on the interface table structure change record table, writing the report data of the first terminal equipment into the interface table, and sending the report data in the interface table to a third terminal equipment corresponding to the first service system.

Fig. 7 is a schematic structural diagram of a generating device of a datagram interface according to an embodiment of the present invention.

As shown in fig. 7, the generating device of the datagram interface is applied to a second terminal device, and includes:

an information table obtaining module 710, configured to obtain an information table of a first service system and an information table of a second service system when receiving a datagram request sent by a first terminal device;

an information table comparison module 720, configured to compare the information table of the first service system with the information table of the second service system, and generate an interface table structure change record table based on the comparison result;

an interface table generating module 730, configured to generate an interface table based on the interface table structure change record table; the interface table is used for writing the report data of the first terminal equipment;

and the sending module 740 is configured to send the sending data in the interface table to a third terminal device corresponding to the first service system.

In some alternative embodiments, the information table of the first service system includes a table-like information table of a downstream usage system, and the second service system includes an interface structure information table of a parallel table system.

In some alternative embodiments, the information table comparison module 720 is further configured to:

and if the comparison result is the newly added field, generating an interface table structure change record table based on the content of the newly added field in the information table of the first service system.

and if the comparison result is the modified field length, generating an interface table structure change record table based on the field length in the information table of the first service system.

In some alternative embodiments, the interface table generation module 730 is further configured to:

generating a data definition statement based on the interface table structure change record table;

and executing the data definition statement to obtain at least one interface table.

In some alternative embodiments, the apparatus further comprises:

and the information table updating module is used for updating the information table of the second service system based on the interface table structure change record table to obtain an updated information table of the second service system.

In some alternative embodiments, the apparatus further comprises:

and the report data loading module is used for loading the report data of the first terminal equipment into an interface table for the first service system to use.

The generation device of the data reporting interface provided by the embodiment of the invention can execute the generation method of the data reporting interface provided by any embodiment of the second terminal equipment, and has the corresponding functional modules and beneficial effects of the execution method.

Fig. 8 is a schematic structural diagram of a generating device of a datagram interface according to an embodiment of the present invention.

As shown in fig. 8, the generating device of the datagram interface is applied to a first terminal device, and includes:

a data report request sending module 810, configured to obtain report data and send a data report request to the second terminal device; the second terminal equipment is used for acquiring an information table of a first service system and an information table of a second service system under the condition of receiving a data report request sent by the first terminal equipment, comparing the information table of the first service system with the information table of the second service system, and generating an interface table structure change record table based on a comparison result; generating an interface table based on the interface table structure change record table;

A sending module 820, configured to send the sending data to the second terminal device; the second terminal device is configured to write the sending data into the interface table, and send the sending data in the interface table to a third terminal device corresponding to the first service system.

The generation device of the data reporting interface provided by the embodiment of the invention can be used for executing the generation method of the data reporting interface provided by any embodiment of the first terminal equipment, and has the corresponding functional modules and beneficial effects of the execution method.

Fig. 9 is a schematic structural diagram of a generating device of a datagram interface according to an embodiment of the present invention.

As shown in fig. 9, the generating device of the datagram interface is applied to a third terminal device, and includes:

a sending data receiving module 910, configured to receive sending data in an interface table sent by the second terminal device; the second terminal equipment is used for acquiring an information table of a first service system and an information table of a second service system under the condition of receiving a data report request sent by the first terminal equipment, comparing the information table of the first service system with the information table of the second service system, and generating an interface table structure change record table based on a comparison result; and generating an interface table based on the interface table structure change record table, writing the report data of the first terminal equipment into the interface table, and sending the report data in the interface table to a third terminal equipment corresponding to the first service system.

The generation device of the data reporting interface provided by the embodiment of the invention can execute the generation method of the data reporting interface provided by any embodiment of the third terminal equipment, and has the corresponding functional modules and beneficial effects of the execution method.

Fig. 10 is a schematic structural diagram of a data reporting system according to an embodiment of the present invention. As shown in fig. 10, the system includes: a first terminal device 1010, a second terminal device 1020 and a third terminal device 1030, the second terminal device 1020 being communicatively connected to the first terminal device 1010 and the third terminal device 1030, respectively;

A first terminal device 1010, configured to obtain report data, and send a data report request to a second terminal device 1020;

the second terminal device 1020 is configured to, when receiving the datagram request sent by the first terminal device 1010, obtain an information table of the first service system and an information table of the second service system, compare the information table of the first service system with the information table of the second service system, and generate an interface table structure change record table based on the comparison result; generating an interface table based on the interface table structure change record table;

the first terminal device 1010 is further configured to send the report data to the second terminal device 1020;

the second terminal device 1020 is further configured to write the report data into the interface table, and send the report data in the interface table to the third terminal device 1030 corresponding to the first service system;

and the third terminal device 1030 is configured to receive the report data in the interface table sent by the second terminal device 1020.

Fig. 11 is a schematic flow chart of data processing according to an embodiment of the present invention. The first terminal device 1010 may be an upstream subsidiary device, the second terminal device 1020 may be a group transfer device, and the third terminal device 1030 may be a downstream parent device, specifically, when the group transfer device receives a data report request sent by the upstream subsidiary device, generates a job scheduling event, obtains a sample information table of the downstream data system and an interface structure information table of the parallel table system, further compares the sample information table of the downstream data system with the interface structure information table of the parallel table system, obtains difference information of the sample information table of the downstream data system and the interface structure information table of the parallel table system, further writes difference information of the sample information table of the downstream data system and the interface structure information table of the parallel table system into an interface table structure change record table, further generates an interface table according to the interface table structure change record table, writes report data of the upstream subsidiary device into the interface table, and sends report data in the interface table to the downstream parent device corresponding to the downstream data system.

In the embodiment of the invention, under the condition that the second terminal equipment receives a data report request sent by the first terminal equipment, a table sample information table of a downstream number system and an interface structure information table of a parallel table system are obtained; comparing the table sample information table of the downstream use number system with the interface structure information table of the parallel table system, generating an interface table structure change record table based on the comparison result, and realizing the record of the difference information; the interface table is generated based on the interface table structure change record table, so that the automatic generation of the data reporting interface is realized, the reporting data of the first terminal equipment are written into the interface table, the reporting data in the interface table are transmitted to the third terminal equipment corresponding to the downstream number system, manual intervention is not needed in the process, and when the table sample information table of the downstream number system is adjusted, the interface table is also automatically adjusted, the interface generation efficiency is improved, the maintenance workload can be reduced, and the consistency of the interface and the table structure of the downstream number system can be ensured.

Fig. 12 is a schematic structural diagram of an electronic device according to an embodiment of the disclosure. Referring now to fig. 12, a schematic diagram of an electronic device (e.g., a terminal device or server in fig. 12) 500 suitable for use in implementing embodiments of the present disclosure is shown. The terminal devices in the embodiments of the present disclosure may include, but are not limited to, mobile terminals such as mobile phones, notebook computers, digital broadcast receivers, PDAs (personal digital assistants), PADs (tablet computers), PMPs (portable multimedia players), in-vehicle terminals (e.g., in-vehicle navigation terminals), and the like, and stationary terminals such as digital TVs, desktop computers, and the like. The electronic device shown in fig. 12 is merely an example and should not be construed to limit the functionality and scope of use of the disclosed embodiments.

As shown in fig. 12, the electronic device 500 may include a processing means (e.g., a central processing unit, a graphics processor, etc.) 501, which may perform various appropriate actions and processes according to a program stored in a Read Only Memory (ROM) 502 or a program loaded from a storage means 508 into a Random Access Memory (RAM) 503. In the RAM 503, various programs and data required for the operation of the electronic apparatus 500 are also stored. The processing device 501, the ROM 502, and the RAM 503 are connected to each other via a bus 504. An edit/output (I/O) interface 505 is also connected to bus 504.

In general, the following devices may be connected to the I/O interface 505: input devices 506 including, for example, a touch screen, touchpad, keyboard, mouse, camera, microphone, accelerometer, gyroscope, etc.; an output device 507 including, for example, a Liquid Crystal Display (LCD), a speaker, a vibrator, and the like; storage 508 including, for example, magnetic tape, hard disk, etc.; and communication means 509. The communication means 509 may allow the electronic device 500 to communicate with other devices wirelessly or by wire to exchange data. While fig. 12 shows an electronic device 500 having various means, it is to be understood that not all of the illustrated means are required to be implemented or provided. More or fewer devices may be implemented or provided instead.

In particular, according to embodiments of the present disclosure, the processes described above with reference to flowcharts may be implemented as computer software programs. For example, embodiments of the present disclosure include a computer program product comprising a computer program embodied on a non-transitory computer readable medium, the computer program comprising program code for performing the method shown in the flow chart. In such an embodiment, the computer program may be downloaded and installed from a network via the communication means 509, or from the storage means 508, or from the ROM 502. The above-described functions defined in the methods of the embodiments of the present disclosure are performed when the computer program is executed by the processing device 501.

The names of messages or information interacted between the various devices in the embodiments of the present disclosure are for illustrative purposes only and are not intended to limit the scope of such messages or information.

The electronic device provided by the embodiment of the present disclosure and the method for generating a datagram interface provided by the above embodiment belong to the same inventive concept, and technical details not described in detail in the present embodiment can be referred to the above embodiment, and the present embodiment has the same beneficial effects as the above embodiment.

The embodiment of the present disclosure provides a computer-readable storage medium having stored thereon a computer program which, when executed by a processor, implements the method for generating a datagram interface provided by the above embodiment.

It should be noted that the computer readable medium described in the present disclosure may be a computer readable signal medium or a computer readable storage medium, or any combination of the two. The computer readable storage medium can be, for example, but not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or a combination of any of the foregoing. More specific examples of the computer-readable storage medium may include, but are not limited to: an electrical connection having one or more wires, a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing. In the context of this disclosure, a computer-readable storage medium may be any tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device. In the present disclosure, however, the computer-readable signal medium may include a data signal propagated in baseband or as part of a carrier wave, with the computer-readable program code embodied therein. Such a propagated data signal may take any of a variety of forms, including, but not limited to, electro-magnetic, optical, or any suitable combination of the foregoing. A computer readable signal medium may also be any computer readable medium that is not a computer readable storage medium and that can communicate, propagate, or transport a program for use by or in connection with an instruction execution system, apparatus, or device. Program code embodied on a computer readable medium may be transmitted using any appropriate medium, including but not limited to: electrical wires, fiber optic cables, RF (radio frequency), and the like, or any suitable combination of the foregoing.

In some implementations, the clients, servers may communicate using any currently known or future developed network protocol, such as HTTP (HyperText Transfer Protocol ), and may be interconnected with any form or medium of digital data communication (e.g., a communication network). Examples of communication networks include a local area network ("LAN"), a wide area network ("WAN"), the internet (e.g., the internet), and peer-to-peer networks (e.g., ad hoc peer-to-peer networks), as well as any currently known or future developed networks.

The computer readable medium may be contained in the electronic device; or may exist alone without being incorporated into the electronic device.

The computer readable medium carries one or more programs which, when executed by the electronic device, cause the electronic device to:

sending the report data in the interface table to third terminal equipment corresponding to the first service system;

or, acquiring report data and sending a data report request to the second terminal equipment; the second terminal equipment is used for acquiring an information table of a first service system and an information table of a second service system under the condition of receiving a data report request sent by the first terminal equipment, comparing the information table of the first service system with the information table of the second service system, and generating an interface table structure change record table based on a comparison result; generating an interface table based on the interface table structure change record table;

sending the report data to the second terminal equipment; the second terminal device is configured to write the sending data into the interface table, and send the sending data in the interface table to a third terminal device corresponding to the first service system;

or receiving the report data in the interface table sent by the second terminal equipment; the second terminal equipment is used for acquiring an information table of a first service system and an information table of a second service system under the condition of receiving a data report request sent by the first terminal equipment, comparing the information table of the first service system with the information table of the second service system, and generating an interface table structure change record table based on a comparison result; and generating an interface table based on the interface table structure change record table, writing the report data of the first terminal equipment into the interface table, and sending the report data in the interface table to a third terminal equipment corresponding to the first service system.

Computer program code for carrying out operations of the present disclosure may be written in one or more programming languages, including, but not limited to, an object oriented programming language such as Java, smalltalk, C ++ and conventional procedural programming languages, such as the "C" programming language or similar programming languages. The program code may execute entirely on the user's computer, partly on the user's computer, as a stand-alone software package, partly on the user's computer and partly on a remote computer or entirely on the remote computer or server. In the case of a remote computer, the remote computer may be connected to the user's computer through any kind of network, including a Local Area Network (LAN) or a Wide Area Network (WAN), or may be connected to an external computer (for example, through the Internet using an Internet service provider).

The flowcharts and block diagrams in the figures illustrate the architecture, functionality, and operation of possible implementations of systems, methods and computer program products according to various embodiments of the present disclosure. In this regard, each block in the flowchart or block diagrams may represent a module, segment, or portion of code, which comprises one or more executable instructions for implementing the specified logical function(s). It should also be noted that, in some alternative implementations, the functions noted in the block may occur out of the order noted in the figures. For example, two blocks shown in succession may, in fact, be executed substantially concurrently, or the blocks may sometimes be executed in the reverse order, depending upon the functionality involved. It will also be noted that each block of the block diagrams and/or flowchart illustration, and combinations of blocks in the block diagrams and/or flowchart illustration, can be implemented by special purpose hardware-based systems which perform the specified functions or acts, or combinations of special purpose hardware and computer instructions.

The units involved in the embodiments of the present disclosure may be implemented by means of software, or may be implemented by means of hardware. Wherein the names of the units do not constitute a limitation of the units themselves in some cases.

The functions described above herein may be performed, at least in part, by one or more hardware logic components. For example, without limitation, exemplary types of hardware logic components that may be used include: a Field Programmable Gate Array (FPGA), an Application Specific Integrated Circuit (ASIC), an Application Specific Standard Product (ASSP), a system on a chip (SOC), a Complex Programmable Logic Device (CPLD), and the like.

In the context of this disclosure, a machine-readable medium may be a tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device. The machine-readable medium may be a machine-readable signal medium or a machine-readable storage medium. The machine-readable medium may include, but is not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any suitable combination of the foregoing. More specific examples of a machine-readable storage medium would include an electrical connection based on one or more wires, a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing.

The embodiments of the present invention also provide a computer program product comprising a computer program which, when executed by a processor, implements a method of generating a datagram interface as provided by any of the embodiments of the present application.

Computer program product in the implementation, the computer program code for carrying out operations of the present invention may be written in one or more programming languages, including an object oriented programming language such as Java, smalltalk, C ++ and conventional procedural programming languages, such as the "C" programming language or similar programming languages. The program code may execute entirely on the user's computer, partly on the user's computer, as a stand-alone software package, partly on the user's computer and partly on a remote computer or entirely on the remote computer or server. In the case of a remote computer, the remote computer may be connected to the user's computer through any kind of network, including a Local Area Network (LAN) or a Wide Area Network (WAN), or may be connected to an external computer (for example, through the Internet using an Internet service provider).

Note that the above is only a preferred embodiment of the present invention and the technical principle applied. It will be understood by those skilled in the art that the present invention is not limited to the particular embodiments described herein, but is capable of various obvious changes, rearrangements and substitutions as will now become apparent to those skilled in the art without departing from the scope of the invention. Therefore, while the invention has been described in connection with the above embodiments, the invention is not limited to the embodiments, but may be embodied in many other equivalent forms without departing from the spirit or scope of the invention, which is set forth in the following claims.

Claims

1. The method for generating the datagram interface is characterized by being applied to second terminal equipment and comprising the following steps:

2. The method of claim 1, wherein the information table of the first service system comprises a table-like information table of a downstream usage system, and the information table of the second service system comprises an interface structure information table of a parallel table system.

3. The method of claim 1, wherein generating the interface table structure change log table based on the comparison result comprises:

4. The method of claim 1, wherein generating the interface table structure change log table based on the comparison result comprises:

5. The method of claim 1, wherein generating an interface table based on the interface table structure change log table comprises:

6. The method of claim 1, wherein after comparing the information table of the first service system with the information table of the second service system, generating an interface table structure change record table based on the comparison result, the method further comprises:

and updating the information table of the second service system based on the interface table structure change record table to obtain an updated information table of the second service system.

7. The method of claim 1, wherein after the generating an interface table based on the interface table structure change log table, the method further comprises:

and loading the report data of the first terminal equipment into an interface table for the first service system to use.

8. The method for generating the datagram interface is characterized by being applied to first terminal equipment and comprising the following steps:

9. The method for generating the datagram interface is characterized by being applied to third terminal equipment and comprising the following steps:

10. The device for generating the datagram interface is characterized by being applied to second terminal equipment and comprising:

11. A device for generating a datagram interface, which is applied to a first terminal device, comprising:

12. A device for generating a datagram interface, which is applied to a third terminal device, comprising:

13. A datagram delivery system comprising: the system comprises a first terminal device, a second terminal device and a third terminal device, wherein the second terminal device is respectively in communication connection with the first terminal device and the third terminal device;

14. An electronic device comprising a memory, a processor and a computer program stored on the memory and executable by the processor, wherein the processor, when executing the computer program, implements a method for generating a datagram interface according to any of claims 1-7, a method for generating a datagram interface according to claim 8, or a method for generating a datagram interface according to claim 9.

15. A computer-readable storage medium, on which a computer program is stored, characterized in that the program, when executed by a processor, implements a method of generating a datagram interface according to any of claims 1-7, or a method of generating a datagram interface according to claim 8, or a method of generating a datagram interface according to claim 9.

16. A computer program product comprising a computer program, characterized in that the computer program, when executed by a processor, implements the method of generating a datagram interface according to any of claims 1-7, or the method of generating a datagram interface according to claim 8, or the method of generating a datagram interface according to claim 9.