Data processing method, device and server

Abstract

The present 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, the user can accurately and efficiently implement the operation processing of the table data of the target table in the preset database by performing relatively intuitive and simple operations based on the operation logic of EXCEL on the first interactive interface and the second interactive interface associated with the preset database and based on EXCEL. This can effectively simplify the operation process on the user side, improve the user's processing efficiency of the table data in the preset database, and enable the user to obtain a better interactive experience.

Description

Technical Field

[0001] This specification belongs to the field of big data technology, and in particular, relates to data processing methods, devices and servers. Background Art

[0002] In some data processing scenarios (for example, testing of applications to be launched), it is often necessary to perform operations such as adding, deleting, and modifying source table data in the database being used.

[0003] When performing the above operations based on the existing methods, users are often required to have good professional programming knowledge, and are also required to use the SPUFI menu of the host system or server responsible for database management to write SQL statements one by one to operate the relevant table data in the database one by one. It can be seen that the existing methods have high threshold requirements for users and relatively low data processing efficiency.

[0004] Furthermore, when the amount of table data to be operated involved in developing online or batch programs is relatively large, the program logic will become more complicated. At this time, based on the above method, users will inevitably need to spend a lot of time and energy to manually write a large number of DML statements, and users will also need to repeatedly execute the above DML statements to finally complete the operation of the source table data in the database. This will make the operation on the user side more cumbersome and the user's interactive experience worse.

[0005] To address the above problems, no effective solution has been proposed yet. Summary of the invention

[0006] This specification provides a data processing method, device and server to effectively simplify the operation process on the user side, improve the user's processing efficiency of table data in a preset database, and enable the user to obtain a better interactive experience.

[0007] This specification provides a data processing method, using a terminal device, including:

[0008] Displaying a 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;

[0009] Obtaining, 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 include a table name of the target table;

[0010] 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;

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

[0012] Obtaining, through the second interactive interface, an operation instruction of the user for the target table; and generating a first instruction file and a second instruction file corresponding to the operation instruction; wherein the first instruction file includes a DML statement; and the second instruction file includes a JCL statement;

[0013] According to a preset communication rule, the first instruction file and the second instruction file are sent to a target directory corresponding to the table name of the target table on the server; wherein the server operates the target table according to the first instruction file and the second instruction file, obtains and feeds back a result indication parameter;

[0014] According to the result indication parameter, the operation processing result on the target table is displayed in the second interactive interface.

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

[0016] In one embodiment, the table structure data of the target table includes 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.

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

[0018] In one embodiment, obtaining the user's operation instruction for the target table through the second interactive interface includes:

[0019] Receiving and determining 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;

[0020] Receiving and determining an operation instruction for the table data to be operated according to a preset operation instruction trigger key selected by the user in the second interactive interface;

[0021] The operation instruction of the user for the target table is determined according to the data identifier of the table data to be operated and the operation instruction for the table data to be operated.

[0022] In one embodiment, the plurality of preset operation instruction trigger keys include: a clear insert instruction trigger key, an append insert instruction trigger key, an update record instruction trigger key, a delete record instruction trigger key, and a get record instruction trigger key.

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

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

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

[0026] Receiving modification data set by a user for table data to be operated through the modification data input interface;

[0027] 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.

[0028] In one embodiment, according to a preset communication rule, sending 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 includes:

[0029] 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.

[0030] In one embodiment, according to the result indication parameter, displaying the operation processing result on the target table in the second interactive interface includes:

[0031] Detecting whether the result indicates that the parameter is less than a preset parameter threshold;

[0032] In the case where it is determined that the result indication parameter is less than the preset parameter threshold, determining that the operation processing on the target table is successful; and obtaining table data of the target table after the operation processing;

[0033] According to the table data of the target table after the operation processing and the user's operation instructions for the target table, the matching operation processing results are displayed in the second interactive interface.

[0034] In one embodiment, after detecting whether the result indication parameter is less than a preset parameter threshold, the method further includes:

[0035] In the case where it is determined that the result indication parameter is greater than or equal to the preset parameter threshold, determining that the operation processing on the target table fails;

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

[0037] This specification also provides a data processing device, including:

[0038] A first display module, used to display a first interactive interface based on EXCEL; wherein the first interactive interface is associated with a preset database; the preset database stores a plurality of DB2 table data;

[0039] A first acquisition module, configured to acquire, 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 include a table name of the target table;

[0040] A second acquisition module, used to respond to the table structure generation instruction and 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;

[0041] A second display module is used to generate and display a second interactive interface based on EXCEL according to the table structure file of the target table; wherein the second interactive interface is associated with a preset database; and the second interactive interface displays the table structure data of the target table;

[0042] A third acquisition module is used to acquire the user's operation instructions for the target table through the second interactive interface; and generate a first instruction file and a second instruction file corresponding to the operation instructions; wherein the first instruction file includes DML statements; and the second instruction file includes JCL statements;

[0043] A sending module, used for sending 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 according to a preset communication rule; wherein the server operates the target table according to the first instruction file and the second instruction file, obtains and feeds back a result indication parameter;

[0044] The third display module is used to display the operation processing result on the target table in the second interactive interface according to the result indication parameter.

[0045] This specification also provides a terminal device, including a processor and a memory for storing processor executable instructions, and the processor implements the relevant steps of the data processing method when executing the instructions.

[0046] The present specification also provides a computer-readable storage medium on which computer instructions are stored, and when the instructions are executed, the relevant steps of the data processing method are implemented.

[0047] The present specification provides a data processing method, device and server. Based on this method, a first interactive interface and a second interactive interface based on EXCEL can be pre-associated with a preset database storing multiple DB2 table data through a preset VBA program. When a user needs to perform corresponding processing on the table data in the preset database, the method can first respond to the user's trigger operation, display the above-mentioned first interactive interface to the user, and obtain the user's table structure generation instruction for the target table to be processed and the table parameters related to the target table through the interface; then respond to the table structure generation instruction, obtain from the server and generate and display the corresponding second interactive interface according to the table structure file of the target table; obtain the user's operation instruction for the target table through the interface, and generate the corresponding first instruction file and second instruction file; then send the above-mentioned two instruction files to the target directory of the server according to the preset communication rules, so that the server can perform specific operation processing on the target table according to the above-mentioned first instruction file and second instruction file by executing the DML statement in the first instruction file; finally, the result indication parameter fed back by the server can be received and displayed to the user in the second interactive interface. In this way, even if the user does not have professional programming knowledge, the user can accurately and efficiently implement various and complex operations on the table data of the target table in the preset database by performing relatively intuitive and simple operations based on the operation logic of EXCEL on the first interaction interface and the second interaction interface based on EXCEL and associated with the preset database. This can effectively simplify the operation process on the user side, improve the user's operation processing efficiency on the table data in the preset database, and enable the user to obtain a better interactive experience. BRIEF DESCRIPTION OF THE DRAWINGS

[0048] In order to more clearly illustrate the embodiments of this specification, the drawings required for use in the embodiments will be briefly introduced below. The drawings described below are only some embodiments recorded in this specification. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying creative labor.

[0049] Figure 1 It is a schematic diagram of an embodiment of the structure of a system using the data processing method provided in the embodiments of this specification;

[0050] Figure 2 is a schematic diagram of an embodiment of applying the data processing method provided by the embodiments of this specification in a scenario example;

[0051] Figure 3 is a schematic diagram of an embodiment of applying the data processing method provided by the embodiments of this specification in a scenario example;

[0052] Figure 4 is a flowchart of a data processing method provided by an embodiment of this specification;

[0053] Figure 5 is a schematic diagram of the structure of a terminal device provided by an embodiment of this specification;

[0054] Figure 6 is a schematic diagram of the structure of a data processing device provided by an embodiment of this specification;

[0055] Figure 7 It is a schematic diagram of an embodiment of applying the data processing method provided by the embodiments of this specification in a scenario example. DETAILED DESCRIPTION

[0056] In order to enable those skilled in the art to better understand the technical solutions in this specification, the technical solutions in the embodiments of this specification will be clearly and completely described below in conjunction with the drawings in the embodiments of this specification. Obviously, the described embodiments are only part of the embodiments of this specification, not all of the embodiments. Based on the embodiments in this specification, all other embodiments obtained by ordinary technicians in this field without creative work should fall within the scope of protection of this specification.

[0057] The present specification provides a data processing method, which can be applied to a system including a server and a terminal device. Figure 1 As shown, the server and the terminal device can be connected via wired or wireless means to perform specific data interaction.

[0058] In this embodiment, the server may specifically include a background server applied to one side of the network platform, which can realize functions such as data transmission and data processing. Specifically, the server may be, for example, an electronic device with data calculation, storage and network interaction functions. Alternatively, the server may also be a software program running in the electronic device to provide support for data processing, storage and network interaction. In this embodiment, the number of servers included in the server is not specifically limited. The server may specifically be one server, or several servers, or a server cluster formed by several servers. Among them, the server is specifically responsible for maintaining and managing a preset database. A large amount of table data is stored in the preset database in the form of a data table, for example, DB2 table data.

[0059] In this embodiment, the terminal device may specifically include a front-end device applied to the user side and capable of realizing functions such as data collection and data transmission. Specifically, the terminal device may be, for example, a desktop computer, a tablet computer, a laptop computer, a smart phone, etc. Alternatively, the terminal device may also be a software application that can be run in the above electronic devices. For example, it may be an APP running on a smart phone, etc. Among them, the terminal device may specifically be installed with a commonly used EXCEL program.

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

[0061] In specific implementation, when the user needs to operate the table data of the target table in the preset database, a trigger operation such as clicking a preset EXCEL icon can be performed on the terminal device to start the EXCEL program associated with the preset database.

[0062] Correspondingly, the terminal device responds to the above triggering operation of the user and displays the first interactive interface based on EXCEL, for example, sheet 1 in the EXCEL table: worksheet. Figure 2 shown.

[0063] The first interactive interface is associated with a preset database. Specifically, the first interactive interface also displays a table structure generation key for the target table, for example, a trigger button marked as "Generate table structure from COPYBOOK file of the selected table" in the table. Furthermore, the first interactive interface also displays a parameter input interface, for example, a list of "host related parameter settings" and the like.

[0064] When the user initiates a table structure generation instruction for the target table by clicking the table structure generation key of the target table, the user can also set and input table parameters related to the target table including at least the table name of the target table through the parameter input interface.

[0065] In addition, for more complex processing scenarios, users can also input other types of parameters in addition to table parameters through the above parameter input interface, such as user account parameters (including: user name, user password, etc.), server port parameters (including: port address, temporary directory information, etc.), etc., to meet more complex scenario requirements.

[0066] Correspondingly, the terminal device can obtain the table structure generation instruction for the target table and the table parameters set by the user through the above-mentioned first interactive interface.

[0067] Furthermore, the terminal device may respond to the table structure generation instruction and, according to the table parameters, interact with the server using a data connection established based on a preset VBA program to obtain a table structure file of the target table. The table structure file of the target table may be 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.

[0068] Next, 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, Sheet 2 in the EXCEL table: currency pairs. Figure 3 shown.

[0069] Among them, the above-mentioned second interactive interface is associated with a preset database. Specifically, the above-mentioned second interactive interface can display the 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 can also be represented by the table name of the target table. Furthermore, the second interactive interface also includes a plurality of preset operation instruction trigger keys. For example, a clear insert instruction trigger key, an append insert instruction trigger key, an update record instruction trigger key, a delete record instruction trigger key, and a get record instruction trigger key, etc.

[0070] In specific implementation, the user can, based on the relatively simple and intuitive EXCEL operation logic, select the data identifier of the table data to be operated in the table structure of the target table displayed in the second interactive interface by checking or other methods; and then select the preset operation instruction trigger key from multiple preset operation instruction trigger keys by clicking.

[0071] Accordingly, the terminal device 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 above second interactive interface; receive and determine the operation instruction for the table data to be operated according to the preset operation instruction trigger key selected by the user in the second interactive interface. Further, the user's operation instruction 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.

[0072] Furthermore, the terminal device can 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 instruction file can be a cbl file containing DML statements, and the second instruction file can be a jcl file containing JCL statements. Furthermore, the name of the first instruction file can be a combination of the table name of the target table and the suffix cbl, such as "SHEET2.cbl", and the name of the second instruction file can be a combination of the table name of the target table and the suffix jcl, such as "SHEET2.jcl".

[0073] Based on the preset VBA program, the terminal device can 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 by submitting them through the preset FTP protocol.

[0074] Accordingly, based on the preset VBA program, the server can obtain the first instruction file and the second instruction file from the target directory; and according to the two instruction files, execute the DML statements in the first instruction file to perform corresponding operations 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 situation.

[0075] The terminal device receives the result indication parameter and displays the operation processing result on the target table to the user in the second interactive interface according to the result indication parameter.

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

[0077] When the result indicating parameter is less than the preset parameter threshold, the terminal device can determine that the server successfully processes the target table. The terminal server can then further interact with the server based on the preset VBA program to obtain the table data of the target table after the operation; and then display the matching result data to the user in the second interactive interface based on the table data of the target table after the operation.

[0078] On the contrary, if the determination result indicates that the parameter is greater than or equal to the preset parameter threshold, the terminal device can determine that the server has failed to process the operation of the target table. Then the terminal device can display prompt information about the failure of the operation of the target table in the second interactive interface. The user can repeat the above operation in the second interactive interface according to the prompt information to re-initiate the operation of the target table.

[0079] Based on the above system, even if the user does not have professional programming knowledge, he can perform corresponding operations on the table data in the preset database more intuitively and simply based on the operation logic of EXCEL, thereby improving the data processing efficiency of the table data in the preset database and improving the user's interactive experience.

[0080] See also Figure 4 As shown, the embodiment of this specification provides a data processing method. Among them, the method is specifically applied to the terminal device side. When implemented specifically, the method may include the following contents.

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

[0082] S402: obtaining, 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 include a table name of the target table;

[0083] S403: responding to the table structure generation instruction, interacting with the server to obtain a table structure file of the target table; wherein the server is used to manage the DB2 table data in the preset database;

[0084] S404: Generate and display a second interactive interface based on EXCEL according to the table structure file of the target table; wherein the second interactive interface is associated with a preset database; and the second interactive interface displays the table structure data of the target table;

[0085] S405: Obtaining, through the second interactive interface, an operation instruction of the user for the target table; and generating a first instruction file and a second instruction file corresponding to the operation instruction; wherein the first instruction file includes a DML statement; and the second instruction file includes a JCL statement;

[0086] S406: According to a preset communication rule, the first instruction file and the second instruction file are sent to a target directory corresponding to the table name of the target table on the server; wherein the server operates the target table according to the first instruction file and the second instruction file, obtains and feeds back a result indication parameter;

[0087] S407: Displaying the operation processing result on the target table in the second interactive interface according to the result indication parameter.

[0088] Through the above-mentioned embodiments, even if the user does not have professional programming knowledge, he can use the relatively simple and intuitive EXCEL-based operation logic to perform corresponding operations on the first interactive interface and the second interactive interface based on EXCEL and associated with the preset database, so as to perform relatively complex and diverse operations on the table data in the preset database, thereby effectively simplifying the operation process on the user side, improving the user's processing efficiency of the table data in the preset database, and enabling the user to obtain a better interactive experience.

[0089] In some embodiments, the preset database may be a DB2 database. Specifically, a plurality of data tables may be stored in the preset database, and each data table may contain a plurality of DB2 table data.

[0090] The DB2 table database may be a large relational database platform developed by IBM, which can support multiple users or multiple applications to query data in different databases or even different DBMSs in the same SQL statement.

[0091] The DB2 database may specifically include one of the following versions: DB2 for Unix, DB2 for Windows, DB2 for AS / 400, DB2 for OS / 390, etc. In this embodiment, DB2 for OS / 390 is taken as the preset database for example for specific description.

[0092] In some embodiments, the first interactive interface may be an interactive page based on EXCEL, for example, sheet1 in EXCEL, which supports users to perform corresponding operations based on the operating logic of EXCEL. Similarly, the second interactive interface may also be an interactive page based on EXCEL, for example, sheet2 in EXCEL, which supports users to perform corresponding operations based on the operating logic of EXCEL.

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

[0094] Through the above embodiment, the preset VBA program can be used to pre-establish relevant data connections between the terminal device on the user side and the server (for example, IBM mainframe, etc.) responsible for managing and maintaining the preset database, so as to associate the EXCEL (application) on the terminal device side with the preset database on the server side, so that the user can subsequently perform corresponding operations on the table data in the preset database on the server side by performing relatively simple and intuitive operations based on the EXCEL operation logic on the EXCEL-based interactive interface displayed on the terminal device.

[0095] In some embodiments, the above-mentioned preset VBA program can be specifically understood as a code program written based on VBA programming language (Visual Basic for Applications, a macro language of Visual Basic), which includes relevant processing rules, communication rules, and connection rules.

[0096] In some embodiments, the terminal device can respond to the user's trigger operation and display a first interactive interface based on EXCEL to the user. Specifically, the first interactive interface can include a table structure generation key for the target table. Furthermore, the first interactive interface can also include a parameter input interface.

[0097] In specific implementation, the terminal device can receive and respond to the user's trigger operation of generating a table structure key for the target table through the first interactive interface, and obtain the user's table structure generation instruction for the target table; at the same time, the terminal device can also receive the table parameters related to the target table input by the user through the parameter input interface in the first interactive interface.

[0098] The table parameters may at least include the name of the target table. Furthermore, the table parameters may also include the storage address of the target table, identification information of the target table, the directory where the target table is located, and other parameter data related to the target table.

[0099] In addition, the parameter input interface in the first interactive interface can also receive other types of parameter data input by the user in addition to the table parameters, such as the user's account parameters (including: user name, user password, etc.), the server's port parameters (including: port address, temporary directory information, etc.), the server's system parameters, operating environment parameters, etc. In this way, the terminal device can obtain richer and more diverse parameter data, so that it can be applied to more complex data processing scenarios and meet the user's more diverse data processing needs.

[0100] In some embodiments, the terminal device may respond to the table structure generation instruction and interact with the server based on a preset VBA program to obtain a table structure file of the target table. Specifically, the terminal device may send the table parameters to the server. The server may retrieve the table structure files of the multiple data tables it holds based on 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 feed back the table structure file of the target table to the terminal device.

[0101] When the server specifically manages the preset database, each time a data table is established in the preset database, it can generate and store a table structure file of the data table; at the same time, it also stores the correspondence between the table structure file of the data table and the table name of the data table.

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

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

[0104] Through the above embodiment, the second interactive interface can be used to display the table structure data of the target table to the user, so as to facilitate the user to understand the table structure of the target table, and then enable the user to perform corresponding operations on the table data in the target table more efficiently and conveniently based on the table structure of the target table.

[0105] In some embodiments, the table structure data of the target table may further specifically include: data type (eg, COBOL type, etc.), data length, and other structure data of the table data in the target table.

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

[0107] In this way, the user can initiate corresponding operation instructions on the second interactive interface efficiently and conveniently by performing trigger operations such as clicking on multiple preset operation instruction trigger keys displayed on the second interactive interface.

[0108] In some embodiments, the multiple preset operation instruction trigger keys may specifically include: a clear insert instruction trigger key, an append insert instruction trigger key, an update record instruction trigger key, a delete record instruction trigger key, and a get record instruction trigger key, etc.

[0109] Among them, the above-mentioned clear insert instruction trigger key corresponds to the clear insert instruction, which is used to instruct the clear operation of the table data inserted in the target table; the above-mentioned append insert instruction trigger key corresponds to the append insert instruction, which is used to instruct the insertion operation of the newly added table data in the target table; the above-mentioned update record instruction trigger key corresponds to the update record trigger instruction, which is used to instruct the modification and update operation of the table data in the target table; the above-mentioned delete record instruction trigger key corresponds to the delete record instruction, which is used to instruct the deletion operation of the table data in the target table; the above-mentioned obtain record instruction trigger key corresponds to the obtain record instruction, which is used to instruct the retrieval and acquisition of the corresponding table data from the target table.

[0110] Through the above-mentioned embodiments, the second interactive interface can be used to provide users with a variety of practical preset operation trigger command keys to meet the user's diverse operation processing needs in a variety of different data processing scenarios.

[0111] Furthermore, in order to facilitate users to perform batch operations on multiple table data more conveniently and efficiently, the above-mentioned multiple preset operation instruction trigger keys may also include: a batch insert instruction trigger key, a batch delete instruction trigger key, etc.

[0112] In some embodiments, the above-mentioned obtaining the user's operation instruction for the target table through the second interactive interface may include the following contents during specific implementation:

[0113] S1: receiving and determining 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;

[0114] S2: receiving and determining an operation instruction for the table data to be operated according to a preset operation instruction trigger key selected by the user in the second interactive interface;

[0115] S3: Determine the user's operation instruction 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.

[0116] Through the above embodiment, the user can be supported to perform relatively simple and intuitive operations on the second interactive interface based on the operating logic of EXCEL to describe the user's operating requirements for the target table; accordingly, the terminal device can receive and automatically and accurately determine the operating instructions that meet the user's operating requirements based on the user's above operations.

[0117] In some embodiments, the user can select data identifiers of multiple table data in the second interactive interface as the data identifiers of the table data to be operated, thereby supporting the user to perform batch operations on multiple table data in the target table at the same time.

[0118] In some embodiments, further, the user can also trigger table structure generation instructions for multiple target tables in the first interactive interface at the same time. Correspondingly, the table structure data of multiple target tables can be displayed at the same time in the second interactive interface; the user can select data identifiers of multiple table data in multiple target tables at the same time in the second interactive interface to perform batch operations on multiple table data in multiple different target tables at the same time.

[0119] In some embodiments, after receiving and determining the operation instructions for the table data to be operated according to the preset operation instruction trigger key selected by the user in the second interactive interface, the method may also include the following contents when implemented: detecting whether the operation instructions for the table data to be operated include append insert instructions and / or update record instructions; when it is determined that the operation instructions for the table data to be operated include append insert instructions and / or update record instructions, displaying a modification data input interface for the table data to be operated on the second interactive interface; receiving modification data for the table data to be operated set by the user through the modification data input interface; accordingly, determining the user's operation instructions for the target table according to the data identifier of the table data to be operated, the operation instructions for the table data to be operated, and the modification data for the table data to be operated.

[0120] Through the above embodiments, for the above-mentioned operation instructions involving adding table data or modifying table data, the modification data input interface displayed in the second interactive interface can be used to receive the modification data set by the user for the table data to be operated, and then the modification data set by the user can be combined and utilized to obtain operation instructions that can meet the user's relatively more complex and more diverse operation needs.

[0121] In some embodiments, during specific implementation, the terminal device can automatically generate a first instruction file and a second instruction file corresponding to the operation instruction based on the processing rules in the preset VBA program and according to the acquired operation instruction for the target table.

[0122] The first instruction file may be a cbl file containing DML statements. The DML (Data Manipulation Language) may be understood as an operation processing language specifically for table data in a preset database. Based on the DML statements, the server may perform specific operation processing on a target table in a preset database.

[0123] The second instruction file may be a jcl file including JCL statements. The JCL (Job Control Language) may be understood as a server operation control language. Based on the JCL statements, the server may determine and find the target table to be processed.

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

[0125] In some embodiments, the above-mentioned method of sending 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 rules may include the following contents: according to the preset FTP protocol, sending 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.

[0126] Through the above embodiment, the terminal device can more efficiently and reliably send the above-mentioned first instruction file and the second instruction file to the corresponding target directory on the server, so that the server can more efficiently and accurately obtain and execute corresponding instruction statements according to the above-mentioned two instruction files to automatically perform corresponding operations on the target table in the preset database.

[0127] In some embodiments, during specific implementation, based on a preset VBA program, the terminal device and the server may utilize a preset FTP (File Transfer Protocol) to perform interaction regarding the first instruction file and the second instruction file.

[0128] Specifically, the terminal device can send the above-mentioned first instruction file and the second instruction file through the put instruction according to the preset FTP protocol; correspondingly, the server can receive the above-mentioned first instruction file and the second instruction file through the get instruction according to the preset FTP protocol, and store the above-mentioned first instruction file and the second instruction file in the target directory.

[0129] In some embodiments, the server may obtain the first instruction file and the second instruction file from the target directory, and perform specific operations on the target table by executing the DML statements in the first instruction file according to the two instruction files.

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

[0131] In some embodiments, after completing the operation processing on the target table, the server may generate and feed back corresponding result indication parameters to the terminal device according to the operation processing situation, wherein the above result indication parameters are used to indicate whether the operation processing result on the target table is successful or failed.

[0132] Specifically, the server may generate and feed back a parameter MAXCC (ie, ReturnCode) as the above result indication parameter according to the operation processing situation.

[0133] In some embodiments, the above-mentioned displaying the operation processing result on the target table in the second interactive interface according to the result indication parameter may include the following contents during specific implementation:

[0134] S1: Detecting whether the result indication parameter is less than a preset parameter threshold;

[0135] S2: when it is determined that the result indication parameter is less than the preset parameter threshold, determining that the operation processing on the target table is successful; and obtaining table data of the target table after the operation processing;

[0136] S3: According to the table data of the target table after the operation processing and the user's operation instruction for the target table, the matching operation processing result is displayed in the second interactive interface.

[0137] Through the above embodiment, when the terminal device determines that the operation processing on the target table on the server side is successful based on the result indication parameters, it can obtain the matching operation processing results based on the user's operation instructions on the target table, and then display them to the user in the second interactive interface to achieve data linkage, so that the user can obtain a relatively good interactive experience.

[0138] 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.

[0139] In some embodiments, when it is determined that the operation processing is successful, the terminal device can specifically obtain the matching operation processing result using the get instruction based on a preset VBA program.

[0140] In some embodiments, when the user's operation instructions for the target table include instructions involving table data modification, such as append insert instructions and update record instructions, the terminal device can, based on a preset VBA program, specifically obtain the modified table data in the target table as the corresponding matching operation processing results, and display them to the user.

[0141] Conversely, when the user's operation instructions for the target table include instructions that do not involve modification of table data, such as obtaining record instructions, the terminal device can directly obtain the corresponding unmodified table data in the target table as a matching operation processing result based on a preset VBA program, and display it to the user.

[0142] In some embodiments, after detecting whether the result indication parameter is less than a preset parameter threshold, the method may also include the following contents when implemented: when it is determined that the result indication parameter is greater than or equal to the preset parameter threshold, determining that the operation processing for the target table has failed; and displaying prompt information about the failure of the operation processing of the target table in the second interactive interface.

[0143] Through the above embodiment, when the terminal device determines that the operation processing on the server side has failed, it can also promptly prompt the user that the operation processing on the target table has failed by displaying corresponding prompt information of the operation processing failure.

[0144] At this time, the user can choose to repeat the above operation on the second interactive interface to re-initiate the operation processing for the target table. At the same time, the terminal device will also send the above prompt information to the server so that the server can recover the prompt information about the operation processing failure and make corresponding adjustments and modifications to the preset VBA program based on the prompt information about the operation processing failure to improve the success rate of the operation processing and improve the user experience.

[0145] In some embodiments, the above data processing method can be specifically applied to the test processing of transaction applications in banking business scenarios. Specifically, the user can prepare DB2 table data for testing in advance, and build a preset database based on the above DB2 table data. Then, the DB2 table data in the above preset database can be used to perform a run test on the transaction application to be tested, and the table data in the preset database can be targeted for operation processing based on the test data, so that the table data in the preset database is more in line with the real banking business scenario, with higher reference value and better test results. Then, the table data in the preset database after the operation processing is used to perform a run test on the transaction application to be tested. Repeat the above process many times, and finally complete the run test to obtain a transaction application with good effect and stable operation.

[0146] As can be seen from the above, based on the data processing method provided in the embodiment of this specification, the first interactive interface and the second interactive interface based on EXCEL can be pre-associated with a preset database storing multiple DB2 table data through a preset VBA program; when the user needs to perform corresponding processing on the table data in the preset database, the above-mentioned first interactive interface can be first displayed to the user, and the table structure generation instruction and table parameters of the target table to be operated and processed are obtained from the user through the interface; then, in response to the table structure generation instruction, the corresponding second interactive interface is obtained and generated and displayed to the user based on the table structure file of the target table; and the user's operation instruction for the target table is obtained through the interface, and the corresponding first instruction file and second instruction file are generated; then, according to the preset communication rules, the above-mentioned two instruction files are sent to the corresponding target directory of the server, so that the server can operate the target table according to the above-mentioned first instruction file and the second instruction file by executing the DML statement in the first instruction file; finally, the result indication parameter fed back by the server is received and displayed in the second interactive interface. The operation processing result of the target table. In this way, even if the user does not have professional programming knowledge, the user can accurately and efficiently perform various and complex operations on the table data of the target table in the preset database by performing relatively intuitive and simple operations based on EXCEL on the first interactive interface and the second interactive interface based on EXCEL. This can effectively simplify the operation process on the user side, improve the user's processing efficiency of the table data in the preset database, and enable the user to obtain a better interactive experience.

[0147] The embodiment of the present specification also provides a terminal device, including a processor and a memory for storing processor executable instructions. When the processor is implemented, it can perform the following steps according to the instructions: display a 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 a table structure generation instruction for a target table and table parameters related to the target table from a user through the first interactive interface; wherein the table parameters at least include the table name of the target table; respond to the table structure generation instruction, interact with a server to obtain a table structure file of the target table; wherein the server is used to manage the DB2 table data in the preset database; generate and display a first interactive interface based on EXCEL according to the table structure file of the target table. Two interactive interfaces; 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 instructions for the target table are obtained; and a first instruction file and a second instruction file corresponding to the operation instructions are generated; wherein the first instruction file includes DML statements; the second instruction file includes JCL statements; according to preset communication rules, the first instruction file and the second instruction file are sent to a target directory corresponding to the table name of the target table on the server; wherein the server operates the target table according to the first instruction file and the second instruction file, obtains and feeds back result indication parameters; according to the result indication parameters, the operation processing results on the target table are displayed in the second interactive interface.

[0148] In order to complete the above instructions more accurately, refer to Figure 5 As shown, the embodiment of this specification also provides another specific terminal device, wherein the terminal device includes a network communication port 501, a processor 502 and a memory 503, and the above structures are connected through internal cables so that each structure can perform specific data interaction.

[0149] Among them, the processor 502 can be specifically used to display a 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; through the first interactive interface, the user's table structure generation instructions for the target table and table parameters related to the target table are obtained; wherein, the table parameters include at least the table name of the target table.

[0150] The network communication port 501 can be specifically used to respond to the table structure generation instruction and 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.

[0151] Next, the processor 502 can be specifically used to generate and display a second interactive interface based on EXCEL 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 the table structure data of the target table; through the second interactive interface, the user's operation instructions for the target table are obtained; and a first instruction file and a second instruction file corresponding to the operation instructions are generated; wherein the first instruction file includes DML statements; and the second instruction file includes JCL statements.

[0152] The network communication port 501 can be specifically used 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 preset communication rules; wherein the server operates the target table according to the first instruction file and the second instruction file, obtains and feeds back the result indication parameters.

[0153] The processor 502 may be further configured to display the operation processing result on the target table in the second interactive interface according to the result indication parameter.

[0154] The memory 503 may be specifically used to store corresponding instruction programs.

[0155] In this embodiment, the network communication port 501 can 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 can be a port responsible for web data communication, a port responsible for FTP data communication, or a port responsible for email data communication. In addition, the network communication port can also be a physical communication interface or communication chip. For example, it can be a wireless mobile network communication chip, such as GSM, CDMA, etc.; it can also be a Wifi chip; it can also be a Bluetooth chip.

[0156] In this embodiment, the processor 502 may be implemented in any appropriate manner. For example, the processor may take the form of a microprocessor or processor and a computer-readable medium storing a computer-readable program code (such as software or firmware) executable by the (micro)processor, a logic gate, a switch, an application specific integrated circuit (ASIC), a programmable logic controller, and an embedded microcontroller, etc. This specification does not limit this.

[0157] In this embodiment, the memory 503 may include multiple levels. In a digital system, anything that can store binary data can be a memory; in an integrated circuit, a circuit with a storage function that has no physical form is also called a memory, such as RAM, FIFO, etc.; in a system, a storage device with a physical form is also called a memory, such as a memory stick, etc.

[0158] The embodiment of the present specification also provides a computer storage medium based on the above data processing method, wherein the computer storage medium stores computer program instructions, and when the computer program instructions are executed, the following are achieved: displaying a 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; obtaining a table structure generation instruction for a target table and table parameters related to the target table from a user through the first interactive interface; wherein the table parameters at least include the table name of the target table; responding to the table structure generation instruction, interacting with a server to obtain a table structure file of the target table; wherein the server is used to manage the DB2 table data in the preset database; generating and displaying a table structure file based on EXCEL according to the table structure file of the target table; L's second interactive interface; 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 instructions for the target table are obtained; and a first instruction file and a second instruction file corresponding to the operation instructions are generated; wherein, the first instruction file includes DML statements; the second instruction file includes JCL statements; according to 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 operates the target table according to the first instruction file and the second instruction file, obtains and feeds back result indication parameters; according to the result indication parameters, the operation processing results on the target table are displayed in the second interactive interface.

[0159] In this embodiment, the storage medium includes, but is not limited to, a random access memory (RAM), a read-only memory (ROM), a cache, a hard disk (HDD), or a memory card. The memory may be used to store computer program instructions. The network communication unit may be an interface for network connection communication set in accordance with the standard specified by the communication protocol.

[0160] In this embodiment, the functions and effects specifically implemented by the program instructions stored in the computer storage medium can be explained in comparison with other implementations and will not be described in detail here.

[0161] See also Figure 6 As shown, at the software level, the embodiment of this specification also provides a data processing device, which may specifically include the following structural modules:

[0162] The first display module 601 may be specifically used to display a first interactive interface based on EXCEL; wherein the first interactive interface is associated with a preset database; the preset database stores a plurality of DB2 table data;

[0163] The first acquisition module 602 may be specifically configured to acquire, 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 include a table name of the target table;

[0164] The second acquisition module 603 may be specifically used to respond to the table structure generation instruction and 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;

[0165] The second display module 604 may be specifically used to generate and display a second interactive interface based on EXCEL according to the table structure file of the target table; wherein the second interactive interface is associated with a preset database; and the second interactive interface displays the table structure data of the target table;

[0166] The third acquisition module 605 may be specifically used to acquire 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 file includes a DML statement; and the second instruction file includes a JCL statement;

[0167] 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 the table name of the target table on the server according to a preset communication rule; wherein the server operates the target table according to the first instruction file and the second instruction file, obtains and feeds back a result indication parameter;

[0168] The third display module 607 may be specifically configured to display the operation processing result on the target table in the second interactive interface according to the result indication parameter.

[0169] It should be noted that the units, devices or modules described in the above embodiments can be implemented by computer chips or entities, or by products with certain functions. For the convenience of description, the above devices are described separately by functions divided into various modules. Of course, when implementing this specification, the functions of each module can be implemented in the same or more software and / or hardware, or the modules that implement the same function can be implemented by a combination of multiple sub-modules or sub-units. The device embodiments described above are only schematic. For example, the division of the units is only a logical function division. There may be other division methods in actual implementation, such as multiple units or components can be combined or integrated into another system, or some features can be ignored or not executed. Another point is that the mutual coupling or direct coupling or communication connection shown or discussed can be through some interfaces, indirect coupling or communication connection of devices or units, which can be electrical, mechanical or other forms.

[0170] It can be seen from the above that the data processing device provided in the embodiments of this specification can effectively simplify the operation process on the user side, improve the user's processing efficiency of the table data in the preset database, and enable the user to obtain a better interactive experience.

[0171] In a specific scenario example, the data processing method provided in this specification can be applied to perform add, delete, modify and query operations on DB2 table data (eg, table data of a target table) based on an IBM mainframe (eg, a server). The specific implementation process can be found in the following content.

[0172] In this scenario example, based on the data processing method provided in this specification, a method for operating the host DB2 table data based on EXCEL is specifically proposed. The method is to use EXCEL to implement each Sheet page (for example, the second interactive interface) corresponding to a DB2 table, so that the test case data can be intuitively displayed on the Sheet page of EXCEL. In this way, developers (for example, users) can easily add, delete, modify, and query the table data on the Sheet without writing DML statements, and then synchronize them to the host DB2 table; at the same time, they can also accurately select the data entries required for each table to add, delete, and modify according to the actual situation of the use case, thereby improving work efficiency. The databases of different partitions on the host can be flexibly configured to implement table data operations of different partitions.

[0173] Specifically, in this scenario example, based on EXCEL VBA programming (for example, a preset VBA program), Sheet1 can be renamed as [Worksheet], and input items such as host user name, password, IP address, environment, and temporary directory can be set, and a button [Select the COPYBOOK file of the table to generate the table structure] is provided. Figure 2As shown, the logic of the button [Select COPYBOOK file of the table to generate table structure] on this page is: click the button to first select the table structure file generated by the host when the table is created. After the table structure file is selected, the VBA program reads the table structure file and interprets the fields and field types in the file, and generates a table structure SHEET based on the table name. See Figure 3 As shown in the generated SHEET, there are table name, Chinese and English column names, COBOL type and length, and add, delete, modify and query buttons. Figure 2 The logic of the five buttons is basically the same, but the keys used for splicing are different. Figure 2 For example, first, the entire [B5:I5] data block is read into the memory through the Range object. B9 to B10 are record check options, ○ indicates selected records, and × indicates unselected. SQL statements for adding, deleting, modifying, and checking are generated based on the selected records and stored in the file [SHEET2.cbl] in the same directory as EXCEL. At the same time, a JCL file SHEET2.jcl with the same name is generated. After the two files are generated, they are uploaded to the host JES system (QUOTE SITE FILETYPE=JES) through the FTP command. The host will execute the SQL statements in SHEET2.cbl and return the executed MAXCC, i.e. ReturnCode. The return results are obtained through the GET command and written back to EXCEL.

[0174] In specific processing, we can imitate the redo log principle of the database, generate JCL and SQL DML statements executable by the host system according to certain rules from the data on the Excel page, and FTP them to the host for execution. After the host executes and operates the database table data, get the returned results and write them back to Excel, so as to realize the linkage between the data in Sheet2 page and the data in the host database.

[0175] For specific operations, please refer to Figure 7 As shown, the following steps are included.

[0176] Step 101, generating SQL DML statements and JCL statements generated by the clear insert, append insert, update record, delete record and get record buttons.

[0177] Step 102: submit the SQLDML and JCL statements to the host JES2 subsystem for execution through the PUT command, and wait for the execution result.

[0178] Step 103, the host JES2 subsystem obtains and executes the instruction, and returns the execution result to the calling module.

[0179] Step 104, interpret the return result from the host and write it back to the function interface Sheet2.

[0180] Through the above scenario examples, the interaction with the host database can be realized based on VBA programming. The developer can add, delete, modify and query the host table data without writing any DML statements. The update of the database table data before and after the test can also be compared and presented in EXCEL format, which is very convenient to use. Compared with the host SPUFI menu, the test case data prepared by this method can be used for regression testing, and the operation is more convenient. And the developer does not need to write additional SQL statements about the DB2 table to add, delete, modify and compare the database table. In addition, this method can be implemented only by installing applications such as Office / WPS, which has the advantages of wide application range and low implementation cost.

[0181] Although the present specification provides method operation steps as described in the embodiments or flow charts, more or less operation steps may be included based on conventional or non-creative means. The order of steps listed in the embodiments is only one way of executing the order of many steps and does not represent the only order of execution. When the device or client product in practice is executed, it can be executed in sequence or in parallel according to the method shown in the embodiments or the drawings (for example, a parallel processor or a multi-threaded processing environment, or even a distributed data processing environment). The term "include", "include" or any other variant thereof is intended to cover non-exclusive inclusion, so that the process, method, product or device including a series of elements includes not only those elements, but also includes other elements that are not explicitly listed, or also includes elements inherent to such process, method, product or device. In the absence of more restrictions, it is not excluded that there are other identical or equivalent elements in the process, method, product or device including the elements. The first, second, etc. words are used to represent the name, and do not represent any particular order.

[0182] Those skilled in the art also know that, in addition to implementing the controller in a purely computer-readable program code, the controller can be made to implement the same function in the form of logic gates, switches, application-specific integrated circuits, programmable logic controllers, and embedded microcontrollers by logically programming the method steps. Therefore, such a controller can be considered as a hardware component, and the devices for implementing various functions included therein can also be considered as structures within the hardware component. Or even, the devices for implementing various functions can be considered as both software modules for implementing the method and structures within the hardware component.

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

[0184] Through the description of the above embodiments, it can be known that those skilled in the art can clearly understand that the present specification can be implemented by means of software plus a necessary general hardware platform. Based on such an understanding, the technical solution of the present specification can essentially be embodied in the form of a software product, which can be stored in a storage medium such as ROM / RAM, a disk, an optical disk, etc., and includes a number of instructions for enabling a computer device (which can be a personal computer, a mobile terminal, a server, or a network device, etc.) to execute the methods described in each embodiment of the present specification or some parts of the embodiments.

[0185] The various embodiments in this specification are described in a progressive manner, and the same or similar parts between the various embodiments can be referred to each other, and each embodiment focuses on the differences from other embodiments. This specification can be used in many general or special computer system environments or configurations. For example: personal computers, server computers, handheld devices or portable devices, tablet devices, multi-processor systems, microprocessor-based systems, set-top boxes, programmable electronic devices, network PCs, minicomputers, mainframe computers, distributed computing environments including any of the above systems or devices, etc.

[0186] Although the present specification is described through embodiments, those skilled in the art will appreciate that there are many modifications and changes to the present specification without departing from the spirit of the present specification, and it is intended that the appended claims include these modifications and changes without departing from the spirit of the present specification.

Claims

1. A data processing method, characterized in that: Application terminal equipment, including: Displaying a 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; Obtaining, 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 include a 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, a second interactive interface based on EXCEL 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; the second interactive interface also includes a plurality of preset operation instruction trigger keys; Obtaining the user's operation instructions for the target table through the second interactive interface; and generating a first instruction file and a second instruction file corresponding to the operation instructions; wherein the first instruction file includes DML statements; the second instruction file includes JCL statements; the first instruction file and the second instruction file are cbl files and jcl files automatically generated by the terminal device according to the user's operation instructions for the target table; According to a preset communication rule, the first instruction file and the second instruction file are sent to a target directory corresponding to the table name of the target table on the server; wherein the server operates the target table according to the first instruction file and the second instruction file, obtains and feeds back a result indication parameter; According to the result indication parameter, the operation processing result on the target table is displayed in the second interactive interface.

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

3. The method according to claim 1, characterized in that The table structure data of the target table includes 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 1, characterized in that: Obtaining the user's operation instructions for the target table through the second interactive interface includes: Receiving and determining 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; Receiving and determining an operation instruction for the table data to be operated according to a preset operation instruction trigger key selected by the user in the second interactive interface; The operation instruction of the user for the target table is determined according to the data identifier of the table data to be operated and the operation instruction for the table data to be operated.

5. The method according to claim 4, characterized in that The plurality of preset operation instruction trigger keys include: 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 a get record instruction trigger key.

6. The method according to claim 5, characterized in that After receiving and determining the operation instruction for the table data to be operated according to the preset operation instruction trigger key selected by the user in the second interactive interface, the method further includes: Detecting whether the operation instruction for the table data to be operated includes 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 append insert instruction and / or an update record instruction, displaying a modification 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 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.

7. The method according to claim 1, characterized in that According to a preset communication rule, sending 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 includes: 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.

8. The method according to claim 1, characterized in that According to the result indication parameter, the operation processing result on the target table is displayed in the second interactive interface, including: Detecting whether the result indicates that the parameter is less than a preset parameter threshold; In the case where it is determined that the result indication parameter is less than the preset parameter threshold, determining that the operation processing on the target table is successful; and obtaining table data of the target table after the operation processing; According to the table data of the target table after the operation processing and the user's operation instructions for the target table, the matching operation processing results are displayed in the second interactive interface.

9. The method according to claim 8, characterized in that After detecting whether the result indicates that the parameter is less than a preset parameter threshold, the method further includes: In the case where it is determined that the result indication parameter is greater than or equal to the preset parameter threshold, determining that the operation processing on the target table fails; In the second interactive interface, prompt information about the failure of the target table operation processing is displayed.

10. A data processing device, characterized in that: include: A first display module, used to display a first interactive interface based on EXCEL; wherein the first interactive interface is associated with a preset database; the preset database stores a plurality of DB2 table data; A first acquisition module, configured to acquire, 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 include a table name of the target table; A second acquisition module, used to respond to the table structure generation instruction and 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; A second display module is used to generate and display a second interactive interface based on EXCEL 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 the table structure data of the target table; the second interactive interface also includes a plurality of preset operation instruction trigger keys; A third acquisition module is used to acquire the user's operation instructions for the target table through the second interactive interface; and generate a first instruction file and a second instruction file corresponding to the operation instructions; wherein the first instruction file includes DML statements; the second instruction file includes JCL statements; the first instruction file and the second instruction file are cbl files and jcl files automatically generated by the terminal device according to the user's operation instructions for the target table; A sending module, used for sending 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 according to a preset communication rule; wherein the server operates the target table according to the first instruction file and the second instruction file, obtains and feeds back a result indication parameter; The third display module is used to display the operation processing result on the target table in the second interactive interface according to the result indication parameter.

11. A terminal device, characterized in that: The method comprises a processor and a memory for storing processor-executable instructions, wherein the processor implements the steps of the method according to any one of claims 1 to 9 when executing the instructions.

12. A computer-readable storage medium, characterized in that: Computer instructions are stored thereon, and when the instructions are executed, the steps of the method according to any one of claims 1 to 9 are implemented.

Images