CN113094367A

CN113094367A - Data processing method and device and server

Info

Publication number: CN113094367A
Application number: CN202110381035.4A
Authority: CN
Inventors: 万茂江; 李冬宝; 王轶凡; 陶川
Original assignee: Industrial and Commercial Bank of China Ltd ICBC
Current assignee: Industrial and Commercial Bank of China Ltd ICBC
Priority date: 2021-04-09
Filing date: 2021-04-09
Publication date: 2021-07-09
Anticipated expiration: 2041-04-09
Also published as: CN113094367B

Abstract

This specification provides a data processing method, device and server. In big data processing, based on this method, even if the user does not have professional programming knowledge, he can use the EXCEL-based operation logic associated with the preset database and on the EXCEL-based first interactive interface and the second interactive interface. A relatively intuitive and simple operation is used to accurately and efficiently realize the operation and processing of the table data of the target table in the preset database. Therefore, the operation process on the user side can be effectively simplified, the processing efficiency of the table data in the preset database by the user can be improved, and the user can obtain a better interactive experience.

Description

Data processing method and device and server

Technical Field

The specification belongs to the technical field of big data, and particularly relates to a data processing method, a data processing device and a server.

Background

In some data processing scenarios (e.g., testing of applications to be online), it is often necessary to perform operations such as adding, deleting, modifying, etc. on the source table data in the database used.

When the operation processing is performed based on the existing method, users are often required to have better professional programming knowledge, and are also required to use a host system responsible for database management or a server-carried SPUPI menu, and SQL statements are written one by one to perform operation processing on related table data in the database one by one. Therefore, the existing method has higher requirement on the threshold of the user and relatively lower data processing efficiency.

Further, program logic becomes more complex when the amount of data of table data to be manipulated involved in developing an online or batch program is relatively large. In this case, based on the above method, it is necessary for the user to spend a lot of time and effort to manually write a large number of DML statements, and the user is also required to repeatedly execute the DML statements, so as to finally complete the operation processing on the source table data in the database. This results in more cumbersome operations on the user side and a poorer user interaction experience.

In view of the above problems, no effective solution has been proposed.

Disclosure of Invention

The specification provides a data processing method, a data processing device and a server, so that the operation flow of a user side is effectively simplified, the processing efficiency of the user on table data in a preset database is improved, and the user obtains better interactive experience.

The present specification provides a data processing method, and an application terminal device, including:

displaying a first interactive interface based on EXCEL; the first interactive interface is associated with a preset database; the preset database stores a plurality of DB2 table data;

acquiring a table structure generating instruction of a user aiming at a target table and table parameters related to the target table through the first interactive interface; wherein the table parameters at least comprise a table name of the target table;

responding to the table structure generating instruction, and interacting with a server to obtain a table structure file of the target table; the server is used for managing DB2 table data in the preset database;

generating and displaying a second interactive interface based on the EXCEL according to the table structure file of the target table; the second interactive interface is associated with a preset database; the second interactive interface displays table structure data of the target table;

acquiring an operation instruction of a user for a target table through the second interactive interface; generating a first instruction file and a second instruction file corresponding to the operation instruction; wherein the first instruction file comprises a DML statement; the second instruction file comprises a JCL statement;

according to a preset communication rule, the first instruction file and the second instruction file are sent to a target directory corresponding to a table name of a target table on a server; the server performs operation processing on a target table according to the first instruction file and the second instruction file to obtain and feed back a result indication parameter;

and displaying an operation processing result related to the target table in the second interactive interface according to the result indication parameter.

In one embodiment, the first interactive interface and the second interactive interface are associated with the preset database based on a preset VBA program.

In one embodiment, the table structure data of the target table includes at least one of: table name of the target table, column name of the target table, table data identification in the target table.

In one embodiment, the second interactive interface further includes a plurality of preset operation instruction trigger keys.

In one embodiment, the obtaining, through the second interactive interface, an operation instruction of a user for a target table includes:

receiving and determining a data identifier of the table data to be operated in the target table according to the table data identifier selected by the user in the second interactive interface;

receiving and triggering a key according to a preset operation instruction selected by a user in a second interactive interface, and determining an operation instruction aiming at the table data to be operated;

and determining an operation instruction of a user for the target table according to the data identifier of the table data to be operated and the operation instruction for the table data to be operated.

In one embodiment, the preset operation instruction triggering keys include: clearing an insertion instruction trigger key, adding an insertion instruction trigger key, updating a recording instruction trigger key, deleting a recording instruction trigger key and acquiring a recording instruction trigger key.

In one embodiment, after receiving and determining an operation instruction for the table data to be operated according to a preset operation instruction trigger key selected by a user in the second interactive interface, the method further includes:

detecting whether an operation instruction aiming at the table data to be operated contains an additional insertion instruction and/or an update record instruction;

under the condition that the operation instruction for the table data to be operated contains an additional insertion instruction and/or an update record instruction, displaying a modified data input interface for the table data to be operated on the second interactive interface;

receiving modification data set by a user for table data to be operated through the modification data input interface;

correspondingly, the operation instruction of the user for the target table is determined according to the data identifier of the table data to be operated, the operation instruction for the table data to be operated and the modification data for the table data to be operated.

In one embodiment, sending the first instruction file and the second instruction file to a target directory corresponding to a table name of a target table on a server according to a preset communication rule includes:

and sending the first instruction file and the second instruction file to a target directory corresponding to the table name of a target table on a server according to a preset FTP protocol.

In one embodiment, according to the result indication parameter, exhibiting an operation processing result related to the target table in the second interactive interface includes:

detecting whether the result indicating parameter is smaller than a preset parameter threshold value;

determining that the operation processing for the target table is successful if it is determined that the result indication parameter is less than the preset parameter threshold; acquiring the table data of the target table after operation processing;

and displaying a matched operation processing result in the second interactive interface according to the table data of the target table after the operation processing and the operation instruction of the user for the target table.

In one embodiment, after detecting whether the result indicates that the parameter is less than a preset parameter threshold, the method further comprises:

determining that the operation processing for the target table fails if it is determined that the result indication parameter is greater than or equal to the preset parameter threshold;

and displaying prompt information about processing failure of the target table operation in the second interactive interface.

This specification also provides a data processing apparatus including:

the first display module is used for displaying a first interactive interface based on EXCEL; the first interactive interface is associated with a preset database; the preset database stores a plurality of DB2 table data;

the first acquisition module is used for acquiring a table structure generation instruction of a user aiming at the target table and table parameters related to the target table through the first interactive interface; wherein the table parameters at least comprise a table name of the target table;

the second acquisition module is used for responding to the table structure generation instruction and interacting with the server to acquire the table structure file of the target table; the server is used for managing DB2 table data in the preset database;

the second display module is used for generating and displaying a second interactive interface based on the EXCEL according to the table structure file of the target table; the second interactive interface is associated with a preset database; the second interactive interface displays table structure data of the target table;

the third acquisition module is used for acquiring an operation instruction of a user for the target table through the second interactive interface; generating a first instruction file and a second instruction file corresponding to the operation instruction; wherein the first instruction file comprises a DML statement; the second instruction file comprises a JCL statement;

the sending module is used for sending the first instruction file and the second instruction file to a target directory corresponding to the table name of a target table on a server according to a preset communication rule; the server performs operation processing on a target table according to the first instruction file and the second instruction file to obtain and feed back a result indication parameter;

and the third display module is used for displaying the operation processing result related to the target table in the second interactive interface according to the result indication parameter.

The present specification also provides a terminal device comprising a processor and a memory for storing processor-executable instructions, which when executed by the processor implement the relevant steps of the data processing method.

The present specification also provides a computer readable storage medium having stored thereon computer instructions which, when executed, implement the relevant steps of the data processing method.

According to the data processing method, the data processing device and the data processing server, a first interactive interface and a second interactive interface based on EXCEL can be associated with a preset database storing a plurality of DB2 table data through a preset VBA program in advance; when a user needs to perform corresponding processing on table data in a preset database, the triggering operation of the user can be responded firstly, the first interactive interface is displayed to the user, and a table structure generation instruction of a target table to be processed by the user in terms of operation and table parameters related to the target table are acquired through the interface; responding to the table structure generation instruction, acquiring a table structure file of the target table from the server, and generating and displaying a corresponding second interactive interface to the user; acquiring an operation instruction of a user for the target table through the interface, and generating a corresponding first instruction file and a corresponding second instruction file; then according to a preset communication rule, the two instruction files are sent to a target directory of the server, so that the server can perform specific operation processing on a target table by executing a DML statement in the first instruction file according to the first instruction file and the second instruction file; finally, the operation processing result about the target table can be received and displayed to the user in the second interactive interface according to the result indication parameter fed back by the server. Therefore, even if professional programming knowledge is not provided, a user can perform intuitive and simple operation on the first interactive interface and the second interactive interface which are based on the EXCEL and are associated with the preset database, and the various and complex operation processing of the table data of the target table in the preset database can be accurately and efficiently realized. Therefore, the operation flow of the user side can be effectively simplified, the operation processing efficiency of the user on the table data in the preset database is improved, and the user can obtain better interactive experience.

Drawings

In order to more clearly illustrate the embodiments of the present specification, the drawings needed to be used in the embodiments will be briefly described below, and the drawings in the following description are only some of the embodiments described in the present specification, and it is obvious to those skilled in the art that other drawings can be obtained according to the drawings without any creative effort.

Fig. 1 is a schematic diagram of an embodiment of a structural component of a system to which a data processing method provided by an embodiment of the present specification is applied;

FIG. 2 is a diagram illustrating an embodiment of a data processing method according to an embodiment of the present disclosure;

FIG. 3 is a diagram illustrating an embodiment of a data processing method according to an embodiment of the present disclosure;

FIG. 4 is a flow diagram of a data processing method provided by one embodiment of the present description;

fig. 5 is a schematic structural component diagram of a terminal device provided in an embodiment of the present specification;

fig. 6 is a schematic structural component diagram of a data processing apparatus provided in an embodiment of the present specification;

fig. 7 is a schematic diagram of an embodiment of a data processing method provided by an embodiment of the present specification, in an example scenario.

Detailed Description

In order to make those skilled in the art better understand the technical solutions in the present specification, the technical solutions in the embodiments of the present specification will be clearly and completely described below with reference to the drawings in the embodiments of the present specification, and it is obvious that the described embodiments are only a part of the embodiments of the present specification, and not all of the embodiments. All other embodiments obtained by a person skilled in the art based on the embodiments in the present specification without any inventive step should fall within the scope of protection of the present specification.

The embodiment of the specification provides a data processing method, which can be particularly applied to a system comprising a server and terminal equipment. Specifically, as shown in fig. 1, the server and the terminal device may be connected in a wired or wireless manner to perform specific data interaction.

In this embodiment, the server may specifically include a background server that is applied to a network platform side and is capable of implementing functions such as data transmission and data processing. Specifically, the server may be, for example, an electronic device having data operation, storage function and network interaction function. Alternatively, the server may be a software program running in the electronic device and providing support for data processing, storage and network interaction. In this embodiment, the number of servers included in the server is not particularly limited. The server may specifically be one server, or may also be several servers, or a server cluster formed by several servers. The server is specifically used for maintaining and managing a preset database. The predetermined database stores therein a large amount of table data in the form of a data table, for example, DB2 table data.

In this embodiment, the terminal device may specifically include a front-end device that is applied to a user side and can implement functions such as data acquisition and data transmission. Specifically, the terminal device may be, for example, a desktop computer, a tablet computer, a notebook computer, a smart phone, and the like. Alternatively, the terminal device may be a software application capable of running in the electronic device. For example, it may be some APP running on a smartphone, etc. The terminal device may specifically have a commonly used EXCEL program installed thereon.

Before the specific implementation, the relevant data connection can be established by using the preset VBA program, so as to associate the EXCEL program installed on the terminal device with the preset database.

In specific implementation, when a user needs to perform operation processing on table data of a target table in a preset database, a trigger operation such as clicking a preset EXCEL icon may be performed on the terminal device to start an EXCEL program associated with the preset database.

Accordingly, the terminal device presents the first interactive interface based on EXCEL in response to the above-mentioned trigger operation of the user, for example, the sheet1 in the EXCEL form: a worksheet. In particular, reference may be made to FIG. 2.

And the first interactive interface is associated with a preset database. Specifically, the first interactive interface further displays a table structure generating key of the target table, for example, a trigger button identified as "copy book file generating table structure of selection table" in the table. Further, a parameter input interface, for example, a "host related parameter setting" list, is also displayed on the first interactive interface.

The user can set and input table parameters related to the target table, including at least the table name of the target table, and the like, through the parameter input interface while initiating a table structure generation instruction for the target table by clicking the table structure generation key of the target table.

In addition, for more complex processing scenarios, the user can also input other types of parameters besides table parameters through the parameter input interface, for example, account parameters of the user (including a user name, a user password, etc.), port parameters of the server (including a port address, temporary directory information, etc.), etc., so as to meet the requirements of more complex scenarios.

Correspondingly, the terminal equipment can acquire a table structure generating instruction of the user aiming at the target table and table parameters set by the user through the first interactive interface.

Further, the terminal device may respond to the table structure generation instruction, and perform related interaction with the server by using a data connection established based on a preset VBA program according to the table parameters, so as to obtain a table structure file of the target table. The table structure file of the target table may be specifically generated when the server establishes the target table in a preset database, and the table structure file of the target table corresponds to the table name of the target table.

Then, the terminal device parses the structure file of the target table, and generates and displays a second interactive interface based on EXCEL according to the structure file of the target table, for example, a sheet2 in the EXCEL form: a currency pair. As can be seen in particular in fig. 3.

And the second interactive interface is associated with a preset database. Specifically, the second interactive interface may display structural data of the target table. For example, the table name of the target table, the column name of the target table, the table data identifier in the target table, etc. The name of the second interactive interface may also use a representation of the table name of the target table. Furthermore, the second interactive interface also comprises a plurality of preset operation instruction trigger keys. For example, a clear insert instruction trigger key, an add insert instruction trigger key, an update record instruction trigger key, a delete record instruction trigger key, and an acquire record instruction trigger key, and the like.

In specific implementation, a user can select a data identifier of table data to be operated in a table structure of a target table displayed on a second interactive interface in a manner of checking and the like based on a simpler and intuitive EXCEL operation logic; and selecting a preset operation instruction trigger key from the plurality of preset operation instruction trigger keys through clicking operation.

Correspondingly, the terminal equipment can receive and determine the data identifier of the table data to be operated in the target table according to the table data identifier selected by the user in the second interactive interface through the second interactive interface; and receiving and triggering a key according to a preset operation instruction selected by a user in the second interactive interface, and determining an operation instruction aiming at the table data to be operated. And then, an operation instruction of a user for the target table can be determined according to the data identifier of the table data to be operated and the operation instruction for the table data to be operated.

Further, the terminal device may automatically generate a first instruction file and a second instruction file corresponding to the operation instruction according to the operation instruction of the target table. The first command file may be an cbl file containing DML statements, and the second command file may be a JCL file containing JCL statements. Further, the name of the first instruction file may be a combination of a table name and a suffix name cbl of the target table, for example, "sheet2. cbl", and the name of the second instruction file may be a combination of a table name and a suffix name jcl of the target table, for example, "sheet2. jcl".

Based on a preset VBA program, the terminal device can send the first instruction file and the second instruction file to a target directory corresponding to the table name of the target table on the server in a submitting mode through a preset FTP protocol.

Correspondingly, based on a preset VBA program, the server can acquire the first instruction file and the second instruction file from the target directory; and according to the two instruction files, executing the DML statement in the first instruction file, and performing corresponding operation processing on the target table. Then, the server can generate and feed back corresponding result indication parameters to the terminal device according to the operation processing condition.

And the terminal equipment receives the result indicating parameter and displays the operation processing result related to the target table to the user in the second interactive interface according to the result indicating parameter.

Specifically, the terminal device may compare the result indication parameter with a preset parameter threshold to detect whether the result indication parameter is smaller than the preset parameter threshold.

In a case where the determination result indicates that the parameter is smaller than the preset parameter threshold, the terminal device may determine that the operation processing of the server with respect to the target table is successful. The terminal server can further interact with the server based on a preset VBA program to acquire the table data of the target table after operation processing; and displaying matched result data to the user in the second interactive interface according to the table data of the target table after operation processing.

In contrast, in a case where the determination result indicates that the parameter is greater than or equal to the preset parameter threshold, the terminal device may determine that the operation processing of the server with respect to the target table has failed. And the terminal equipment can show prompt information about the failure of the target form operation processing in the second interactive interface. The user can repeat the operation in the second interactive interface according to the prompt message so as to reinitiate the operation processing aiming at the target table.

Based on the system, even if the user does not have professional programming knowledge, the user can perform corresponding operation processing on the table data in the preset database more intuitively and simply based on the operation logic of the EXCEL, so that the data processing efficiency of the table data in the preset database can be improved, and the interaction experience of the user is improved.

Referring to fig. 4, an embodiment of the present disclosure provides a data processing method. The method is particularly applied to the side of the terminal equipment. In particular implementations, the method may include the following.

S401: displaying a first interactive interface based on EXCEL; the first interactive interface is associated with a preset database; the preset database stores a plurality of DB2 table data;

s402: acquiring a table structure generating instruction of a user aiming at a target table and table parameters related to the target table through the first interactive interface; wherein the table parameters at least comprise a table name of the target table;

s403: responding to the table structure generating instruction, and interacting with a server to obtain a table structure file of the target table; the server is used for managing DB2 table data in the preset database;

s404: generating and displaying a second interactive interface based on the EXCEL according to the table structure file of the target table; the second interactive interface is associated with a preset database; the second interactive interface displays table structure data of the target table;

s405: acquiring an operation instruction of a user for a target table through the second interactive interface; generating a first instruction file and a second instruction file corresponding to the operation instruction; wherein the first instruction file comprises a DML statement; the second instruction file comprises a JCL statement;

s406: according to a preset communication rule, the first instruction file and the second instruction file are sent to a target directory corresponding to a table name of a target table on a server; the server performs operation processing on a target table according to the first instruction file and the second instruction file to obtain and feed back a result indication parameter;

s407: and displaying the operation processing result related to the target table in the second interactive interface according to the result indication parameter.

Through the embodiment, even if the user does not have professional programming knowledge, the user can utilize simpler and visual EXCEL-based operation logic to perform relatively complex and various operation processing on the table data in the preset database by performing corresponding operations on the first interactive interface and the second interactive interface which are based on the EXCEL and are associated with the preset database, so that the operation flow of the user side can be effectively simplified, the processing efficiency of the user on the table data in the preset database is improved, and the user can obtain better interactive experience.

In some embodiments, the preset database may be specifically a DB2 database. Specifically, a plurality of data tables may be stored in the preset database, and each data table includes a plurality of DB2 table data.

The DB2 table database may be a large relational database platform developed by IBM. Multiple users or multiple applications can be supported to query data in different databases and even different DBMSs in the same SQL statement.

The DB2 database may specifically include one of a plurality of versions listed below: DB2 for Unix, DB2 for Windows, DB2 for AS/400, DB2 for OS/390, etc. In the present embodiment, DB2 for OS/390 is taken as an example of a preset database, and the specific description is given.

In some embodiments, the first interactive interface may specifically be an EXCEL-based interactive page, for example, a sheet1 of EXCEL, and supports a user to perform corresponding operations based on EXCEL operation logic. Similarly, the second interactive interface may specifically be an EXCEL-based interactive page, for example, a sheet2 in EXCEL, and supports the user to perform corresponding operations based on the EXCEL operation logic.

In some embodiments, the first interactive interface and the second interactive interface may be respectively associated with the preset database based on a preset VBA program.

Through the embodiment, the preset VBA program can be used to associate the EXCEL (application) on the terminal device side with the preset database on the server side by establishing a relevant data connection in advance between the terminal device on the user side and the server (e.g., IBM host, etc.) responsible for managing and maintaining the preset database, so that the user can subsequently perform corresponding operation processing on the table data in the preset database on the server side by performing relatively simple and intuitive operation on the EXCEL-based interactive interface displayed on the terminal device based on the EXCEL operation logic.

In some embodiments, the predetermined VBA program may be specifically understood as a code program written based on a VBA programming language (Visual Basic for Applications, a macro language of Visual Basic), and including related processing rules, communication rules, and connection rules.

In some embodiments, the terminal device may present the first EXCEL-based interactive interface to the user in response to a trigger by the user. Specifically, the first interactive interface may include a table structure generation key of the target table. Further, the first interactive interface may further include a parameter input interface.

In specific implementation, the terminal device can receive and respond to the triggering operation of the table structure generation key of the target table by the user through the first interactive interface, and acquire a table structure generation instruction of the target table by the user; meanwhile, the terminal equipment can also receive the table parameters which are input by the user and are related to the target table through the parameter input interface in the first interactive interface.

The table parameters at least include a table name of the target table. Further, the table parameters may also include other parameter data related to the target table, such as a storage address of the target table, identification information of the target table, and a directory where the target table is located.

In addition, other types of parameter data besides table parameters, such as account parameters of the user (including a user name, a user password, etc.), port parameters of the server (including a port address, temporary directory information, etc.), system parameters of the server, operating environment parameters, etc., which are input by the user, can also be received through the parameter input interface in the first interactive interface. Therefore, the terminal equipment can acquire richer and more diversified parameter data so as to be suitable for more complicated data processing scenes and meet more diversified data processing requirements of users.

In some embodiments, the terminal device may respond to the table structure generation instruction, and perform data interaction with the server based on a preset VBA program to obtain the table structure file of the target table. Specifically, the terminal device may send the table parameters to the server. The server can search the table structure files of the held data tables according to the table parameters to find the table structure file of the data table corresponding to the table name of the target table in the table parameters as the table structure file of the target table; and feeding back the table structure file of the target table to the terminal equipment.

When the server specifically manages a preset database, the server can generate and store a table structure file of a data table when the data table is established in the preset database; meanwhile, the corresponding relation between the table structure file of the data table and the table name of the data table is also stored.

In some embodiments, the terminal device may receive the table structure file of the target table fed back by the server, and generate and display a corresponding second interactive interface based on the EXCEL based on the table structure file of the target table. The second interactive interface at least comprises table structure data of the target table.

In some embodiments, the table structure data of the target table may specifically include at least one of: table name of the target table, column name of the target table, table data identifier in the target table, and the like.

Through the embodiment, the table structure data of the target table can be displayed to the user by utilizing the second interactive interface, so that the user can conveniently know the table structure of the target table, and further, the user can carry out corresponding operation processing on the table data in the target table more efficiently and conveniently based on the table structure of the target table.

In some embodiments, the table structure data of the target table may further include: the data type (e.g., COBOL type, etc.) of the table data in the target table, the data length, and other configuration data.

In some embodiments, the second interactive interface may further include a plurality of preset operation instruction trigger keys.

In this way, the user can perform trigger operations such as clicking on a plurality of preset operation instruction trigger keys displayed on the second interactive interface, so as to efficiently and conveniently initiate corresponding operation instructions on the second interactive interface.

In some embodiments, the preset operation instruction triggering keys may specifically include: clearing an insertion instruction trigger key, adding an insertion instruction trigger key, updating a recording instruction trigger key, deleting a recording instruction trigger key, acquiring a recording instruction trigger key and the like.

The clearing and inserting instruction trigger key corresponds to a clearing and inserting instruction and is used for indicating clearing operation on the table data inserted into the target table; the additional insertion instruction trigger key corresponds to an additional insertion instruction and is used for indicating the insertion operation of newly added table data to the target table; the update record instruction trigger key corresponds to an update record trigger instruction and is used for indicating the modification and update operations of the table data in the target table; the record deleting instruction trigger key corresponds to a record deleting instruction and is used for indicating the deletion operation of the table data in the target table; the acquisition record instruction trigger key corresponds to an acquisition record instruction and is used for indicating to retrieve and acquire corresponding table data from the target table.

Through the embodiment, the second interactive interface can be utilized to provide multiple practical preset operation trigger instruction keys for the user so as to meet diversified operation processing requirements of the user in multiple different data processing scenes.

Further, for the convenience of the user, batch operation can be performed on a plurality of table data more conveniently and efficiently, and the plurality of preset operation instruction trigger keys may further include: a batch insert instruction trigger key, a batch delete instruction trigger key, etc.

In some embodiments, the obtaining, through the second interactive interface, an operation instruction of the user for the target table may include the following steps in specific implementation:

s1: receiving and determining a data identifier of the table data to be operated in the target table according to the table data identifier selected by the user in the second interactive interface;

s2: receiving and triggering a key according to a preset operation instruction selected by a user in a second interactive interface, and determining an operation instruction aiming at the table data to be operated;

s3: and determining an operation instruction of a user for the target table according to the data identifier of the table data to be operated and the operation instruction for the table data to be operated.

By the embodiment, the user can be supported to perform simpler and more intuitive operation on the second interactive interface based on the EXCEL operation logic to describe the operation requirement of the user for the target table; correspondingly, the terminal equipment can receive and automatically and accurately determine the operation instruction meeting the operation requirement of the user according to the operation of the user.

In some embodiments, a user may select a data identifier of a plurality of table data in the second interactive interface as a data identifier of the table data to be operated, so that the user may be supported to perform batch operation on the plurality of table data in the target table at the same time.

In some embodiments, further, the user may also trigger the table structure generation instruction for the plurality of target tables simultaneously in the first interactive interface. Correspondingly, the table structure data of a plurality of target tables can be displayed simultaneously in the second interactive interface; the user can select the data identifications of the plurality of table data in the plurality of target tables in the second interactive interface at the same time, so as to perform batch operation on the plurality of table data in the plurality of different target tables at the same time.

In some embodiments, after receiving and determining an operation instruction for the table data to be operated according to a preset operation instruction trigger key selected by a user in the second interactive interface, the method may further include the following steps: detecting whether an operation instruction aiming at the table data to be operated contains an additional insertion instruction and/or an update record instruction; under the condition that the operation instruction for the table data to be operated contains an additional insertion instruction and/or an update record instruction, displaying a modified data input interface for the table data to be operated on the second interactive interface; receiving modification data set by a user for table data to be operated through the modification data input interface; correspondingly, the operation instruction of the user for the target table is determined according to the data identifier of the table data to be operated, the operation instruction for the table data to be operated and the modification data for the table data to be operated.

By the embodiment, aiming at the operation instruction related to adding the table data or modifying the table data, the modification data input interface displayed in the second interactive interface can be used for receiving the modification data set by the user aiming at the table data to be operated, and then the operation instruction capable of meeting the relatively more complex and more diversified operation requirements of the user can be obtained by combining the modification data set by the user.

In some embodiments, in specific implementation, the terminal device may automatically generate, based on a processing rule in a preset VBA program, a first instruction file and a second instruction file corresponding to the operation instruction according to the obtained operation instruction for the target table.

The first instruction file may be specifically an cbl file containing DML statements. The above-mentioned DML (Data management Language) can be specifically understood as an operation processing Language specifically for table Data in a preset database. Based on the DML statement, the server may perform specific operation processing on a certain target table in a preset database.

The second instruction file may be an JCL file containing JCL sentences. The jcl (job Control language) is specifically understood as a language for controlling server operations. Based on the JCL statement, the server can determine and find a target table to be operated and processed.

In some embodiments, the name of the first instruction file may be a combination of a table name and a suffix name cbl of the target table, such as "SHEET 2. cbl", and the name of the second instruction file may be a combination of a table name and a suffix name jcl of the target table, such as "SHEET 2. jcl".

In some embodiments, the sending the first instruction file and the second instruction file to a target directory corresponding to a table name of a target table on a server according to a preset communication rule may include the following steps: and sending the first instruction file and the second instruction file to a target directory corresponding to the table name of a target table on a server according to a preset FTP protocol.

Through the embodiment, the terminal device can efficiently and reliably send the first instruction file and the second instruction file to the corresponding target directories on the server, so that the server can efficiently and accurately acquire and execute the corresponding instruction sentences according to the two instruction files, and corresponding operation processing is automatically performed on the target tables in the preset database.

In some embodiments, in specific implementation, based on a preset VBA program, the terminal device and the server may perform interaction between the first instruction File and the second instruction File by using a preset FTP (File Transfer Protocol).

Specifically, the terminal device may send the first instruction file and the second instruction file through a put instruction according to a preset FTP protocol; correspondingly, the server can receive the first instruction file and the second instruction file through a get instruction according to a preset FTP protocol, and store the first instruction file and the second instruction file in a target directory.

In some embodiments, the server may obtain the first instruction file and the second instruction file from the target directory, and perform specific operation processing on the target table by executing the DML statement in the first instruction file according to the two instruction files.

Specifically, the server may first find the target table in the preset database by executing the JCL statement in the second instruction file according to the second instruction file. Then, the server may perform specific operation processing on the target table by executing the DML statement in the first instruction file according to the first instruction file.

In some embodiments, after completing the operation processing on the target table, the server may generate and feed back a corresponding result indication parameter to the terminal device according to the operation processing condition. Wherein the result indication parameter is used for characterizing whether the operation processing result aiming at the target table is successful or failed.

Specifically, the server may generate and feed back a parameter MAXCC (i.e., ReturnCode) as the result indication parameter according to the operation processing condition.

In some embodiments, when the operation processing result related to the target table is displayed in the second interactive interface according to the result indication parameter, the specific implementation may include the following:

s1: detecting whether the result indicating parameter is smaller than a preset parameter threshold value;

s2: determining that the operation processing for the target table is successful if it is determined that the result indication parameter is less than the preset parameter threshold; acquiring the table data of the target table after operation processing;

s3: and displaying a matched operation processing result in the second interactive interface according to the table data of the target table after the operation processing and the operation instruction of the user for the target table.

Through the embodiment, under the condition that the terminal equipment determines that the operation processing of the server side aiming at the target table is successful according to the result indication parameter, the matched operation processing result can be obtained according to the operation instruction of the user aiming at the target table, and then the operation processing result is displayed to the user in the second interactive interface, so that data linkage is realized, and the user obtains relatively good interactive experience.

In some embodiments, the value of the preset parameter threshold may be set to 4. If the result indicates that the parameter is less than 4, it may be determined that the operation processing on the server side is successful.

In some embodiments, in a case that it is determined that the operation processing is successful, the terminal device may specifically obtain a matching operation processing result by using the get instruction based on a preset VBA program.

In some embodiments, in a case that the operation instruction of the user for the target table includes an instruction related to table data modification, such as an additional insertion instruction, an update record instruction, and the like, the terminal device may specifically acquire, based on a preset VBA program, table data in the target table that has been modified as a corresponding matched operation processing result, and present the table data to the user.

In contrast, in the case that the operation instruction of the user for the target table includes an instruction that does not involve table data modification, such as an acquire record instruction, the terminal device may directly acquire corresponding unmodified table data in the target table based on the preset VBA program as a matched operation processing result, and display the result to the user.

In some embodiments, after detecting whether the result indicates that the parameter is smaller than the preset parameter threshold, the method may further include, when implemented, the following: determining that the operation processing for the target table fails if it is determined that the result indication parameter is greater than or equal to the preset parameter threshold; and displaying prompt information about processing failure of the target table operation in the second interactive interface.

Through the embodiment, the terminal equipment can prompt the user of the operation processing failure of the target table in time by displaying the prompt information of the corresponding operation processing failure under the condition that the operation processing failure of the server side is determined.

At this time, the user may choose to repeat the above operations on the second interactive interface to re-initiate the operation process for the target table. Meanwhile, the terminal equipment also sends the prompt information to the server so that the server can recycle the prompt information about the operation processing failure, and correspondingly adjusts and modifies the preset VBA program and the like based on the prompt information about the operation processing failure, so that the operation processing success rate is improved, and the use experience of a user is improved.

In some embodiments, the data processing method may be specifically applied to a test process of a transaction application in a banking scenario. Specifically, the user may prepare the DB2 table data for testing in advance, and construct a preset database based on the DB2 table data. Then, the DB2 table data in the preset database can be used to perform operation testing on the transaction application to be tested, and the table data in the preset database is subjected to targeted operation processing according to the test data, so that the table data in the preset database more fits the real banking scene, and has higher reference value and better testing effect. And then, running test is carried out on the transaction application to be tested by using the table data in the preset database after operation processing. And repeating the process for multiple times to finally finish the operation test, thereby obtaining the transaction application with better effect and stable operation.

As can be seen from the above, according to the data processing method provided in the embodiments of the present specification, the first interactive interface and the second interactive interface based on EXCEL may be associated with a preset database storing a plurality of DB2 table data through a preset VBA program in advance; when a user needs to perform corresponding processing on table data in a preset database, the first interactive interface can be displayed to the user firstly, and a table structure generation instruction and table parameters of a target table to be operated and processed by the user are acquired through the interface; responding to the table structure generation instruction, acquiring and displaying a corresponding second interactive interface to the user according to the table structure file of the target table; acquiring an operation instruction of a user for the target table through the interface, and generating a corresponding first instruction file and a corresponding second instruction file; then according to a preset communication rule, the two instruction files are sent to corresponding target directories of the server, so that the server can perform operation processing on a target table by executing a DML statement in the first instruction file according to the first instruction file and the second instruction file; and finally, receiving and displaying an operation processing result related to the target table in the second interactive interface according to the result indication parameter fed back by the server. Therefore, even if professional programming knowledge is not provided, a user can accurately and efficiently perform various and complex operation processing on the table data of the target table in the preset database by performing intuitive and simple EXCEL-based operation on the first interactive interface and the second interactive interface based on the EXCEL. Therefore, the operation flow of the user side can be effectively simplified, the processing efficiency of the user on the table data in the preset database is improved, and the user can obtain better interactive experience.

An embodiment of the present specification further provides a terminal device, including a processor and a memory for storing processor-executable instructions, where the processor, when implemented specifically, may perform the following steps according to the instructions: displaying a first interactive interface based on EXCEL; the first interactive interface is associated with a preset database; the preset database stores a plurality of DB2 table data; acquiring a table structure generating instruction of a user aiming at a target table and table parameters related to the target table through the first interactive interface; wherein the table parameters at least comprise a table name of the target table; responding to the table structure generating instruction, and interacting with a server to obtain a table structure file of the target table; the server is used for managing DB2 table data in the preset database; generating and displaying a second interactive interface based on the EXCEL according to the table structure file of the target table; the second interactive interface is associated with a preset database; the second interactive interface displays table structure data of the target table; acquiring an operation instruction of a user for a target table through the second interactive interface; generating a first instruction file and a second instruction file corresponding to the operation instruction; wherein the first instruction file comprises a DML statement; the second instruction file comprises a JCL statement; according to a preset communication rule, the first instruction file and the second instruction file are sent to a target directory corresponding to a table name of a target table on a server; the server performs operation processing on a target table according to the first instruction file and the second instruction file to obtain and feed back a result indication parameter; and displaying an operation processing result related to the target table in the second interactive interface according to the result indication parameter.

In order to more accurately complete the above instructions, referring to fig. 5, another specific terminal device is provided in the embodiments of the present specification, where the terminal device includes a network communication port 501, a processor 502, and a memory 503, and the above structures are connected by an internal cable, so that the structures may perform specific data interaction.

The processor 502 may be specifically configured to display a first interactive interface based on EXCEL; the first interactive interface is associated with a preset database; the preset database stores a plurality of DB2 table data; acquiring a table structure generating instruction of a user aiming at a target table and table parameters related to the target table through the first interactive interface; wherein the table parameters at least include a table name of the target table.

The network communication port 501 may be specifically configured to respond to the table structure generation instruction and interact with a server to obtain a table structure file of a target table; wherein, the server is used for managing DB2 table data in the preset database.

Next, the processor 502 may be specifically configured to generate and display a second interactive interface based on EXCEL according to the table structure file of the target table; the second interactive interface is associated with a preset database; the second interactive interface displays table structure data of the target table; acquiring an operation instruction of a user for a target table through the second interactive interface; generating a first instruction file and a second instruction file corresponding to the operation instruction; wherein the first instruction file comprises a DML statement; the second instruction file includes a JCL statement.

The network communication port 501 may be specifically configured to send the first instruction file and the second instruction file to a target directory corresponding to a table name of a target table on a server according to a preset communication rule; and the server performs operation processing on the target table according to the first instruction file and the second instruction file to obtain and feed back a result indication parameter.

The processor 502 may be further configured to display an operation processing result related to the target table in the second interactive interface according to the result indication parameter.

The memory 503 may be specifically configured to store a corresponding instruction program.

In this embodiment, the network communication port 501 may be a virtual port that is bound to different communication protocols, so that different data can be sent or received. For example, the network communication port may be a port responsible for web data communication, a port responsible for FTP data communication, or a port responsible for mail data communication. In addition, the network communication port can also be a communication interface or a communication chip of an entity. For example, it may be a wireless mobile network communication chip, such as GSM, CDMA, etc.; it can also be a Wifi chip; it may also be a bluetooth chip.

In this embodiment, the processor 502 may be implemented in any suitable manner. For example, the processor may take the form of, for example, a microprocessor or processor and a computer-readable medium that stores computer-readable program code (e.g., software or firmware) executable by the (micro) processor, logic gates, switches, an Application Specific Integrated Circuit (ASIC), a programmable logic controller, an embedded microcontroller, and so forth. The description is not intended to be limiting.

In this embodiment, the memory 503 may include multiple layers, and in a digital system, the memory may be any memory as long as binary data can be stored; in an integrated circuit, a circuit without a physical form and with a storage function is also called a memory, such as a RAM, a FIFO and the like; in the system, the storage device in physical form is also called a memory, such as a memory bank.

The present specification further provides a computer storage medium based on the above data processing method, where the computer storage medium stores computer program instructions, and when the computer program instructions are executed, the computer storage medium implements: displaying a first interactive interface based on EXCEL; the first interactive interface is associated with a preset database; the preset database stores a plurality of DB2 table data; acquiring a table structure generating instruction of a user aiming at a target table and table parameters related to the target table through the first interactive interface; wherein the table parameters at least comprise a table name of the target table; responding to the table structure generating instruction, and interacting with a server to obtain a table structure file of the target table; the server is used for managing DB2 table data in the preset database; generating and displaying a second interactive interface based on the EXCEL according to the table structure file of the target table; the second interactive interface is associated with a preset database; the second interactive interface displays table structure data of the target table; acquiring an operation instruction of a user for a target table through the second interactive interface; generating a first instruction file and a second instruction file corresponding to the operation instruction; wherein the first instruction file comprises a DML statement; the second instruction file comprises a JCL statement; according to a preset communication rule, the first instruction file and the second instruction file are sent to a target directory corresponding to a table name of a target table on a server; the server performs operation processing on a target table according to the first instruction file and the second instruction file to obtain and feed back a result indication parameter; and displaying an operation processing result related to the target table in the second interactive interface according to the result indication parameter.

In this embodiment, the storage medium includes, but is not limited to, a Random Access Memory (RAM), a Read-Only Memory (ROM), a Cache (Cache), a Hard Disk Drive (HDD), or a Memory Card (Memory Card). The memory may be used to store computer program instructions. The network communication unit may be an interface for performing network connection communication, which is set in accordance with a standard prescribed by a communication protocol.

In this embodiment, the functions and effects specifically realized by the program instructions stored in the computer storage medium can be explained by comparing with other embodiments, and are not described herein again.

Referring to fig. 6, in a software level, an embodiment of the present specification further provides a data processing apparatus, which may specifically include the following structural modules:

the first display module 601, which may be specifically configured to display a first interactive interface based on EXCEL; the first interactive interface is associated with a preset database; the preset database stores a plurality of DB2 table data;

the first obtaining module 602 may be specifically configured to obtain, through the first interactive interface, a table structure generation instruction of a user for a target table and table parameters related to the target table; wherein the table parameters at least comprise a table name of the target table;

the second obtaining module 603 may be specifically configured to respond to the table structure generating instruction, and interact with the server to obtain a table structure file of the target table; the server is used for managing DB2 table data in the preset database;

the second presentation module 604 may be specifically configured to generate and present a second interactive interface based on EXCEL according to the table structure file of the target table; the second interactive interface is associated with a preset database; the second interactive interface displays table structure data of the target table;

a third obtaining module 605, configured to obtain, through the second interactive interface, an operation instruction of the user for the target table; generating a first instruction file and a second instruction file corresponding to the operation instruction; wherein the first instruction file comprises a DML statement; the second instruction file comprises a JCL statement;

the sending module 606 may be specifically configured to send the first instruction file and the second instruction file to a target directory corresponding to a table name of a target table on a server according to a preset communication rule; the server performs operation processing on a target table according to the first instruction file and the second instruction file to obtain and feed back a result indication parameter;

the third presentation module 607 may be specifically configured to present, according to the result indication parameter, an operation processing result related to the target table in the second interactive interface.

It should be noted that, the units, devices, modules, etc. illustrated in the above embodiments may be implemented by a computer chip or an entity, or implemented by a product with certain functions. For convenience of description, the above devices are described as being divided into various modules by functions, and are described separately. It is to be understood that, in implementing the present specification, functions of each module may be implemented in one or more pieces of software and/or hardware, or a module that implements the same function may be implemented by a combination of a plurality of sub-modules or sub-units, or the like. The above-described embodiments of the apparatus are merely illustrative, and for example, the division of the units is only one logical division, and other divisions may be realized in practice, for example, a plurality of units or components may be combined or integrated into another system, or some features may be omitted, or not executed. In addition, the shown or discussed mutual coupling or direct coupling or communication connection may be an indirect coupling or communication connection through some interfaces, devices or units, and may be in an electrical, mechanical or other form.

Therefore, the data processing device provided by the embodiment of the specification can effectively simplify the operation flow of the user side, improve the processing efficiency of the user on the table data in the preset database, and enable the user to obtain better interactive experience.

In a specific scenario example, the data processing method provided in this specification may be applied to perform add/delete and modify operations on DB2 table data (e.g., table data of a target table) related to an IBM mainframe (e.g., a server). The following can be referred to as a specific implementation process.

In this scenario example, based on the data processing method provided in this specification, a method for operating data in a host DB2 table based on EXCEL is specifically proposed, where the method uses EXCEL to implement that each Sheet page (for example, the second interactive interface) corresponds to one DB2 table, so that test case data can be visually displayed on the Sheet page of EXCEL. Therefore, developers (such as users) can conveniently add, delete, modify and check the data on the Sheet table and synchronously link the data to the host DB2 table without writing DML sentences; meanwhile, the data items required by each table can be accurately selected according to the actual conditions of the use cases to be added and deleted, so that the working efficiency is improved. The database of different partitions on the host can be flexibly configured, and the table data operation of different partitions is realized.

Specifically, in the present scenario example, based on VBA programming of EXCEL (e.g., a preset VBA program), Sheet1 may be renamed as [ worksheet ], entries of host username, password, IP address, environment, and temporary directory are set, and a button of [ copy book file generation table structure of selection table ] is provided. Referring to fig. 2, the logic of the button [ copy book file generation table structure of selection table ] of the present page is: clicking the button to select the list structure file generated by the host computer, after selecting the list structure file, reading the list structure text and explaining the field and field type in the file by the VBA program, and generating the list structure SHEET according to the list name, as shown in figure 3, wherein the generated SHEET comprises the list name, Chinese and English column names, COBOL type and length, and an add-delete modify button. In fig. 2, the logic of the five buttons is basically the same, but the key used in the splicing is different. Taking fig. 2 as an example, firstly, data blocks [ B5: I5 ] are read into the memory through the Range object, B9 to B10 are record check options, o indicates a selected record, x indicates not selected, add/delete check SQL statements are generated according to the selected record and stored in the file [ secure 2.cbl ] in the same directory as the EXCEL, and at the same time, a JCL file secure 2.JCL of the same name is generated, after the two files are generated, the two files are uploaded to the host JES system (queue SITE FILETYPE: JES) through an FTP command, the host executes the SQL statements in the secure 2.cbl, and returns the executed MAXCC, i.e., ReturnCode. And acquiring a return result through a GET command and writing the return result back to the EXCEL.

During specific processing, data on an Excel page can be generated into JCL and SQL DML statements which can be executed by a host system according to a certain rule by imitating a redo log principle of a database, FTP is carried out to the host, after the host executes and operates data of a database table, a get return result is written back to the Excel, and linkage of the data in the Sheet2 and the data in the host database is realized.

In operation, as shown in fig. 7, the following steps are included.

Step 101, generating SQL DML statement and JCL statement generated by the buttons of empty insert, add insert, update record, delete record and get record.

In step 102, the SQLDML and JCL statements are submitted to the host JES2 subsystem for execution through a PUT command, and the execution result is waited for.

In step 103, the host JES2 subsystem acquires and executes the command, and returns the execution result to the master module.

And step 104, interpreting the return result of the host and writing the return result back to the function interface Sheet2.

Through the scene example, interaction with the host computer database can be realized based on VBA programming, developers can add, delete, change and check the host computer table data without writing any DML statement, and the updating conditions of the database table data before and after testing can be compared and displayed in an EXCEL form, so that the use is very convenient; compared with a host SPUFI menu, the test case data prepared by the method can be used for regression testing, and the operation is more convenient and faster; moreover, the database tables can be subjected to addition, deletion, modification and comparison without additionally compiling SQL sentences about the DB2 table by developers; in addition, the method can be realized only by installing Office/WPS and other applications, and has the advantages of wide application range and low realization cost.

Although the present specification provides method steps as described in the examples or flowcharts, additional or fewer steps may be included based on conventional or non-inventive means. The order of steps recited in the embodiments is merely one manner of performing the steps in a multitude of orders and does not represent the only order of execution. When an apparatus or client product in practice executes, it may execute sequentially or in parallel (e.g., in a parallel processor or multithreaded processing environment, or even in a distributed data processing environment) according to the embodiments or methods shown in the figures. The terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus 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 apparatus. Without further limitation, the presence of additional identical or equivalent elements in a process, method, article, or apparatus that comprises the recited elements is not excluded. The terms first, second, etc. are used to denote names, but not any particular order.

Those skilled in the art will also appreciate that, in addition to implementing the controller as pure computer readable program code, the same functionality can be implemented by logically programming method steps such that the controller is in the form of logic gates, switches, application specific integrated circuits, programmable logic controllers, embedded microcontrollers and the like. Such a controller may therefore be considered as a hardware component, and the means included therein for performing the various functions may also be considered as a structure within the hardware component. Or even means for performing the functions may be regarded as being both a software module for performing the method and a structure within a hardware component.

This description may be described in the general context of computer-executable instructions, such as program modules, being executed by a computer. Generally, program modules include routines, programs, objects, components, data structures, classes, etc. that perform particular tasks or implement particular abstract data types. The specification may also be practiced in distributed computing environments where tasks are performed by remote processing devices that are linked through a communications network. In a distributed computing environment, program modules may be located in both local and remote computer storage media including memory storage devices.

From the above description of the embodiments, it is clear to those skilled in the art that the present specification can be implemented by software plus necessary general hardware platform. With this understanding, the technical solutions in the present specification may be essentially embodied in the form of a software product, which may be stored in a storage medium, such as a ROM/RAM, a magnetic disk, an optical disk, etc., and includes several instructions for enabling a computer device (which may be a personal computer, a mobile terminal, a server, or a network device, etc.) to execute the methods described in the embodiments or some parts of the embodiments in the present specification.

The embodiments in the present specification are described in a progressive manner, and the same or similar parts among the embodiments are referred to each other, and each embodiment focuses on the differences from the other embodiments. The description is operational with numerous general purpose or special purpose computing system environments or configurations. For example: personal computers, server computers, hand-held or portable devices, tablet-type devices, multiprocessor systems, microprocessor-based systems, set top boxes, programmable electronic devices, network PCs, minicomputers, mainframe computers, distributed computing environments that include any of the above systems or devices, and the like.

While the specification has been described with examples, those skilled in the art will appreciate that there are numerous variations and permutations of the specification that do not depart from the spirit of the specification, and it is intended that the appended claims include such variations and modifications that do not depart from the spirit of the specification.

Claims

1. a data processing method, is characterized in that, application terminal equipment, comprises:

Show the first interactive interface based on EXCEL; wherein, the first interactive interface is associated with a preset database; the preset database stores multiple DB2 table data;

Obtain, through the first interactive interface, the user's instruction for generating the table structure of the target table, and table parameters related to the target table; wherein, the table parameters at least include the table name of the target table;

In response to the table structure generation instruction, interact with the server to obtain the table structure file of the target table; wherein, the server is used to manage the DB2 table data in the preset database;

According to the table structure file of the target table, an EXCEL-based second interactive interface is generated and displayed; wherein, the second interactive interface is associated with a preset database; the second interactive interface displays the table structure data of the target table ;

Through the second interactive interface, the user's operation instruction for the target table is obtained; and a first instruction file and a second instruction file corresponding to the operation instruction are generated; wherein, the first instruction file includes a DML statement; the The second instruction file includes JCL statements;

According to the preset communication rules, the first instruction file and the second instruction file are sent to the target directory corresponding to the table name of the target table on the server; wherein, the server is based on the first instruction file and the second instruction file. Instruction file, operate the target table, get and feedback the result indicating parameters;

According to the result indication parameter, the operation processing result about the target table is displayed in the second interactive interface.

2 . The method according to claim 1 , wherein the first interactive interface and the second interactive interface are associated with the preset database based on a preset VBA program. 3 .

3. The method according to claim 1, wherein the table structure data of the target table comprises at least one of the following: a table name of the target table, a column name of the target table, and a table data identifier in the target table.

4 . The method according to claim 3 , wherein the second interactive interface further comprises a plurality of preset operation instruction trigger keys. 5 .

5. The method according to claim 4, wherein, through the second interactive interface, obtaining the user's operation instruction for the target table, comprising:

Receive and determine the data identifier of the table data to be operated in the target table according to the table data identifier selected by the user in the second interactive interface;

Receive and trigger keys according to the preset operation instruction selected by the user in the second interactive interface, and determine the operation instruction for the table data to be operated;

According to the data identifier of the to-be-operated table data and the operation instruction for the to-be-operated table data, the user's operation instruction for the target table is determined.

6. The method according to claim 5, wherein the plurality of preset operation instruction trigger keys include: empty insert instruction trigger key, additional insert instruction trigger key, update record instruction trigger key, delete record instruction trigger key key and get record command trigger key.

7. The method according to claim 6, wherein after receiving and triggering a key according to a preset operation instruction selected by the user in the second interactive interface, determining the operation instruction for the table data to be operated , the method also includes:

Detecting whether the operation instruction for the table data to be operated contains an additional insert instruction and/or an update record instruction;

In the case where it is determined that the operation instruction for the table data to be operated includes an additional insert instruction and/or an update record instruction, a modification data input interface for the table data to be operated is displayed on the second interactive interface;

Through the modification data input interface, receive modification data set by the user for the table data to be operated;

Correspondingly, the user's operation instruction for the target table is determined according to the data identifier of the table data to be operated, the operation instruction for the table data to be operated, and the modification data for the table data to be operated.

8. The method according to claim 1, wherein, according to a preset communication rule, the first instruction file and the second instruction file are sent to the target directory corresponding to the table name of the target table on the server, include:

According to the preset FTP protocol, the first instruction file and the second instruction file are sent to the target directory corresponding to the table name of the target table on the server.

9. The method according to claim 1, wherein, according to the result indication parameter, displaying the operation processing result about the target table in the second interactive interface, comprising:

Detecting whether the result indication parameter is less than a preset parameter threshold;

When it is determined that the result indication parameter is less than the preset parameter threshold, it is determined that the operation processing for the target table is successful; and the table data of the target table after the operation processing is obtained;

According to the table data of the target table after the operation processing and the user's operation instruction on the target table, a matching operation processing result is displayed in the second interactive interface.

10. The method according to claim 9, wherein after detecting whether the result indication parameter is less than a preset parameter threshold, the method further comprises:

If it is determined that the result indicates that the parameter is greater than or equal to the preset parameter threshold, determining that the operation processing for the target table fails;

In the second interactive interface, prompt information about the operation processing failure of the target table is displayed.

11. A data processing device, comprising:

The first display module is used to display the first interactive interface based on EXCEL; wherein, the first interactive interface is associated with a preset database; the preset database stores multiple DB2 table data;

a first obtaining module, configured to obtain, through the first interactive interface, a user's table structure generation instruction for the target table, and table parameters related to the target table; wherein, the table parameters at least include the table name of the target table;

The second obtaining module is used for interacting with the server in response to the table structure generation instruction to obtain the table structure file of the target table; wherein, the server is used for managing the DB2 table data in the preset database;

The second display module is configured to generate and display a second EXCEL-based interactive interface according to the table structure file of the target table; wherein, the second interactive interface is associated with a preset database; the second interactive interface displays Table structure data with target table;

The third obtaining module is used to obtain the user's operation instruction for the target table through the second interactive interface; and generate a first instruction file and a second instruction file corresponding to the operation instruction; wherein, the first instruction The file includes a DML statement; the second instruction file includes a JCL statement;

a sending module, configured to send the first instruction file and the second instruction file to the target directory corresponding to the table name of the target table on the server according to the preset communication rule; The instruction file and the second instruction file, perform operation processing on the target table, and obtain and feedback the result indicating parameters;

The third display module is configured to display the operation processing result about the target table in the second interactive interface according to the result indication parameter.

12. A terminal device, characterized by comprising a processor and a memory for storing instructions executable by the processor, when the processor executes the instructions, the steps of the method according to any one of claims 1 to 10 are implemented .

13. A computer-readable storage medium, characterized in that computer instructions are stored thereon, the instructions, when executed, implement the steps of the method of any one of claims 1 to 10.