A method and system for updating and querying dynamic business data

Abstract

The present application discloses a method and system for updating and querying dynamic business data, the method comprising: receiving a business data update request generated by a user trigger, displaying a first business data update interface; receiving a table name and a single number filled in by a user in the first business data update interface and sending them to a backend server, receiving the first business data returned by the backend server; dynamically generating a business data modification text box according to the first business data, filling in the first business data correspondingly in the business data modification text box, adding the business data modification text box to the first business data update interface, generating and displaying a second interface data update interface; receiving business update data corresponding to the first business data filled in by a user in the second business data update interface, sending it together with the corresponding first business data to the backend server, receiving and displaying prompt information on whether the update is successful or not returned by the backend server. The present application can realize the rapid update of dynamic business data.

Description

Technical Field

[0001] The present application relates to the field of information processing technology, and in particular to a method and system for updating and querying dynamic business data. Background Art

[0002] With the rapid development of informatization, more and more manufacturers and suppliers use computer systems for informatization office. When certain orders change, it is necessary to go to a specific interface to update the business data. The process of finding the interface in several tables stored in the database will be a waste of time, and the original data will be replaced after the update, and the data before the update cannot be found, which is not conducive to the user's review of the update content. Therefore, it is necessary to provide a method to realize the rapid update and update record query of all data in the system, without going to a specific update interface to update data, providing users with a more convenient and quick way.

[0003] In addition, while achieving convenient updates of dynamic business data, it is also necessary to consider and ensure the accuracy and security of data updates to avoid losses caused by erroneous data changes or malicious tampering with business data. Summary of the invention

[0004] In order to achieve rapid update of dynamic business data, the present application provides a method and system for updating and querying dynamic business data.

[0005] In a first aspect, the present application discloses a method for updating and querying dynamic business data, comprising:

[0006] Receiving a service data update request triggered by a user, and displaying a preset first service data update interface;

[0007] Receive the table name and order number filled in by the user in the first business data update interface, record them as the first table name and the first order number, and send them to the backend server, receive the first business data returned by the backend server, and the first business data is obtained by the backend server through querying the business data storage table stored in the backend server according to the first table name and the first order number;

[0008] Dynamically generate a business data modification text box according to the acquired first business data, fill the acquired first business data into the business data modification text box, add the business data modification text box to the first business data update interface, and generate and display the second interface data update interface;

[0009] Receive the business update data corresponding to the first business data filled in by the user in the second business data update interface, send it together with the corresponding first business data to the background server, receive and display the update success and save prompt information or the update failure and reason prompt information returned by the background server; the update success and save prompt information or the update failure and reason prompt information is generated by the background server based on whether the business update data corresponding to the first business data meets the attribute requirements and data range requirements of the corresponding storage location in the business data storage table;

[0010] After receiving the prompt information of successful update and saving, the business data update record request generated by the user trigger is received and sent to the background server, so that when the background server receives the business data update record request, it stores the first business data and the business update data corresponding to the first business data in the business data update record table created by itself.

[0011] By adopting the above solution, an independent business data update interface is designed on the front end, and it communicates with the back-end server so that users can obtain the original business data according to different query requirements. After dynamically generating a text box for filling in the corresponding update data, the updated data is stored in the back-end server accordingly. There is no need to obtain specific interface update data from the storage table, thereby realizing rapid update of business data; the back-end server is used to judge the attributes and range of the updated data to ensure the accuracy of the updated data; based on the successful update, the record of the updated content of the specific business data is completed to facilitate subsequent query and review by users.

[0012] Preferably, it also includes:

[0013] Receive a business data update record query request triggered by a user, and display a preset first business data update record query interface;

[0014] Receive the table name and order number filled in by the user in the first business data update record query interface, record them as the second table name and the second order number, and send them to the backend server, and receive the second business data and the business update data corresponding to the second business data returned by the backend server; the second business data and the business update data corresponding to the second business data are obtained by querying the backend server in the business data update record table according to the second table name and the second order number;

[0015] A business data update record text box is dynamically generated according to the acquired second business data and the business update data corresponding to the second business data, and after the acquired second business data and the business update data corresponding to the second business data are filled into the business data update record text box, the business data update record text box is added to the first business data update record query interface to generate and display the second business data update record query interface.

[0016] By adopting the above solution, a business data update record query interface is independently designed on the front end, and communicates with the back-end server, so that users can obtain business data before and after the update according to different query requirements, and dynamically generate a text box to display the business data before and after the update, so as to realize the query of business data update records, which is convenient for users to review or analyze.

[0017] Preferably, it also includes:

[0018] After receiving a business data update request triggered by a user, a preset user login interface is displayed in advance;

[0019] Receive the user login ID and password filled in by the user on the user login interface and send them to the backend server, and receive the prompt information of whether the login is legal or not returned by the backend server; the prompt information of whether the login is legal or not is generated by the backend server according to the stored user login permission table; the user login permission table includes: the user login ID and password of the user who is allowed to log in;

[0020] After receiving the login legal information, the preset first business data update interface is displayed, otherwise the preset first business data update interface is not displayed.

[0021] By adopting the above solution, a user login interface is set up, and the login users are reviewed to ensure that users with update permissions can enter the business data update interface, preventing unauthorized users from obtaining the original business data and causing losses.

[0022] Preferably, it also includes:

[0023] Receive the table name and order number filled in by the user on the first business data update interface, record them as the first table name and the first order number, and send them to the backend server, and receive the first business data or the prompt information of exceeding the update authority returned by the backend server;

[0024] The prompt information of exceeding update authority is generated by the background server when it is determined that the table name and order number filled in by the user in the first business data update interface exceed the update authority based on the stored user update authority table; the update authority information includes: user login ID, the table name and order number allowed to be updated corresponding to the user login ID, and the specific fields in the table name and order number allowed to be updated corresponding to the user login ID.

[0025] By adopting the above solution, the user's update permissions are taken into consideration, and it is determined whether the table name and order number entered exceed the permissions according to the user's update query requirements. A prompt indicating that the first business data to be updated or the update permissions are exceeded is returned accordingly, thereby avoiding malicious tampering of business data.

[0026] Preferably, it also includes:

[0027] Receive the business data update authorization request and user login ID triggered by the user, and send them to the backend server;

[0028] Receive prompt information on whether the business data update authorization request is confirmed returned by the backend server; the prompt information on whether the business data update authorization request is confirmed is determined by the backend server when receiving the business data update authorization request, judging whether the update authority information corresponding to the user login ID has administrator authority according to the stored user update authority table, and generating business data update authorization request confirmation prompt information if the judgment result is that the user has administrator authority, otherwise, generating business data update authorization request non-confirmation prompt information; the update authority information also includes: whether the user has administrator authority information corresponding to the user login ID;

[0029] When receiving the confirmation prompt message of the business data update authorization request returned by the backend server, display the preset first business data update authorization interface; receive the user ID, table name and order number entered by the user in the first business data update authorization interface, record them as the third table name and the third order number and send them to the backend server, receive the specific fields in the corresponding table and order number queried in the business data storage table according to the third table name and the third order number returned by the backend server; generate a field selection text box according to the obtained field, and add it to the first business data update authorization interface, generate and display the second business data update authorization interface;

[0030] The fields selected by the user in the second business data update right authorization interface are received and sent to the background server, so that the background server modifies the records of the user update authority table according to the selected fields and the corresponding user ID.

[0031] By adopting the above solution, taking into account the problem that business data update permissions may need to be adjusted during the dynamic update of business data, on the basis of judging that the user is an administrator, a business data update authorization interface is designed for administrators to select and update the update permissions of each user, so as to better guarantee the user's needs for business data update.

[0032] Preferably, the update success and save prompt information or the update failure and reason prompt information is generated by the backend server based on whether the business update data corresponding to the first business data meets the attribute requirements and data range requirements of the corresponding storage location in the business data storage table, and specifically includes:

[0033] Determine the data type of the specific field in the corresponding table name and order number in which the business update data corresponding to the first business data is stored, and judge whether the business update data conforms to the data type of the specific field; if so, determine that it conforms to the attribute requirements of the corresponding storage location; otherwise, determine that it does not conform to the attribute requirements of the corresponding storage location;

[0034] Determine that the business update data corresponding to the first business data is stored in a data range of a specific field in the corresponding table name and order number, and judge whether the business update data is within the data range; if it is within the data range, it is determined to meet the data range requirements of the corresponding storage location; otherwise, it is determined not to meet the data range requirements of the corresponding storage location; the data range of the specific field in the corresponding table name and order number is the data range specified by the business data type corresponding to the queried first business data;

[0035] When it is determined that the property requirements of the corresponding storage location are met and the data range requirements of the corresponding storage location are met, the update is successful and the prompt information is saved; otherwise, the corresponding update failure and the reason prompt information are generated.

[0036] By adopting the above scheme, the data type of the storage location where the business update data is located and the data range specified by the data type are specifically selected to determine whether the attribute requirements and data range requirements of the storage location are met, thereby completing the determination of whether to update or not.

[0037] Preferably, the dynamically generating a business data modification text box based on the acquired first business data includes: generating an original business data text box and a business update data text box for each field of the first business data, and sequentially displaying an original business data text box and a business update data text box for each field of the first business data in accordance with the storage sorting of each field in the first business data stored in the corresponding table name and order number.

[0038] By adopting the above solution, for each field of the first business data obtained, the corresponding generated original business data text box and business update data text box are displayed in sequence according to the original storage order, so that the user can update the data in sequence.

[0039] In a second aspect, the present application provides a system for dynamic business data update and query, including: a backend server;

[0040] A first business data update interface display module, used to receive a business data update request generated by a user trigger, and display a preset first business data update interface;

[0041] The second business data update interface display module is used to receive the table name and order number filled in by the user in the first business data update interface, record them as the first table name and the first order number and send them to the background server, receive the first business data returned by the background server, the first business data is obtained by the background server in the business data storage table stored in the backend server according to the first table name and the first order number; dynamically generate a business data modification text box according to the obtained first business data, fill the obtained first business data into the business data modification text box, add the business data modification text box to the first business data update interface, and generate and display the second interface data update interface;

[0042] The update success or failure prompt information generation module is used to receive the business update data corresponding to the first business data filled in by the user in the second business data update interface, send it together with the corresponding first business data to the background server, receive and display the update success and save prompt information or the update failure and reason prompt information returned by the background server; the update success and save prompt information or the update failure and reason prompt information is generated by the background server based on whether the business update data corresponding to the first business data meets the attribute requirements and data range requirements of the corresponding storage location in the business data storage table;

[0043] The business data update request saving module is used to receive the business data update record request triggered by the user and send it to the background server after receiving the update success and saving prompt information, so that when the background server receives the business data update record request, it stores the first business data and the business update data corresponding to the first business data in the business data update record table created by itself.

[0044] By adopting the above method, using the business data update interface that communicates with the background server, users can obtain original business data according to different query requirements, input updated data and correspondingly replace the original business data stored in the background server. There is no need to update data in a specific interface in the storage table, thereby realizing rapid update of business data.

[0045] In a third aspect, the present application provides a computer-readable storage medium, wherein the computer-readable storage medium includes a stored computer program, wherein when the computer program is executed, the device where the computer-readable storage medium is located is controlled to execute the method as described above.

[0046] In a fourth aspect, the present application provides a computer device, comprising a memory, a processor, and a program stored and executable on the memory, wherein the program implements the steps of the above method when executed by the processor.

[0047] In summary, this application has the following beneficial effects:

[0048] 1. Design an independent business data update interface on the front end and communicate with the backend server to allow users to obtain original business data according to different query requirements. After dynamically generating a text box for filling in the corresponding update data, the updated data is stored in the backend server to achieve rapid update of business data; during the update process, complete the judgment of the attributes and scope of the updated business data to ensure the accuracy of the updated data; based on the successful update, complete the record of the updated content of specific business data to facilitate subsequent query and review by users;

[0049] 2. The business data update record query interface is independently designed on the front end and communicates with the back-end server, so that users can obtain the business data before and after the update according to different query requirements, dynamically generate a text box to display the business data before and after the update, and realize the query of business data update records, which is convenient for users to review or analyze;

[0050] 3. Taking into account the possible malicious updates, updates beyond the authority, and the need to adjust the business data update authority during the dynamic update of business data, set up a user login interface and combine it with the update authority table to determine whether the update is allowed, and generate prompt information for situations where the update is not allowed; set up an update authorization interface, and allow the user's update authority to be modified based on the judgment that the logged-in user has administrator authority. BRIEF DESCRIPTION OF THE DRAWINGS

[0051] Figure 1 It is a flowchart of business data updating in the method for dynamic business data updating and querying described in a specific embodiment;

[0052] Figure 2 It is a flowchart of business data query in the method for dynamic business data update and query described in a specific embodiment;

[0053] Figure 3 It is the basic interface for updating and viewing data in the method for updating and querying dynamic business data described in the specific embodiment;

[0054] Figure 4 It is the first business data update interface in the method for dynamic business data update and query described in the specific embodiment;

[0055] Figure 5 It is the second business data update interface in the method for dynamic business data update and query described in the specific embodiment;

[0056] Figure 6 It is the second business data update record query interface in the method for dynamic business data update and query described in the specific embodiment;

[0057] Figure 7 Update the authorization interface in the method for updating and querying dynamic business data described in the specific embodiment;

[0058] Figure 8 It is the second business data update right authorization interface in the method for dynamic business data update and query described in the specific embodiment;

[0059] Fig. 9 It is a structural diagram of the system for dynamic business data update and query described in a specific embodiment. DETAILED DESCRIPTION

[0060] In order to make the purpose, technical solution and advantages of the present application more clearly understood, the present application is further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are only used to explain the present application and are not used to limit the present application.

[0061] like Figure 1 As shown, the embodiment of the present application discloses a method for updating and querying dynamic business data, including:

[0062] S11. Receive a service data update request triggered by a user, and display a preset first service data update interface.

[0063] Specifically, the front end is used to design the business data update and view related basic interface, and the business data update and view related basic interface includes a data update and view basic interface, a first business data update interface and a first business data update record query interface.

[0064] like Figure 3 As shown, the data update and view basic interface is provided with "Update" and "View" buttons, and the user can choose to click the "Update" specific button to trigger the generated business data update request. When receiving the business data update request generated by the user trigger, the first business data update interface is displayed, such as Figure 4 As shown, the first business data update interface includes: a table name identifier, a single number identifier, and content display text boxes corresponding to the two identifiers.

[0065] S12: receiving the table name and order number filled in by the user in the first business data update interface, and sending them to the backend server.

[0066] Specifically, the user can fill in the table name and order number to be updated in the first business data update interface according to the business data update requirements, which are recorded as the first table name and the first order number. When the enter trigger event or the enter trigger event in JavaScript occurs, the table name and order number filled in by the user in the first business data update interface are sent to the background server.

[0067] S13: Receive the first service data returned by the background server.

[0068] Specifically, when the background server receives the first table name and the first order number, it will query and obtain the corresponding first business data in the business data storage table stored in itself according to the first table name and the first order number, and return the first business data obtained to the front-end interface, thereby receiving the first business data returned by the background server; the business data storage table stores several business data forms, and each data form stores the business data corresponding to the table name and the order number.

[0069] S14. Dynamically generate a business data modification text box according to the acquired first business data, fill in the business data and add it to the first business data update interface, and generate and display a second interface data update interface.

[0070] Specifically, each piece of business data generally has multiple fields, such as age, gender, name, etc. Different types of business data may have different fields. A business update data text box is dynamically generated for multiple fields of the acquired first business data, such as Figure 5 As shown, the business data modification text box includes a business data field identifier, an original business data identifier, a business update data identifier, an original business data text box and a business update data text box; wherein, an original business data text box and a business update data text box are generated corresponding to each field, and according to the storage order of each field in the first business data stored in the corresponding table name and order number, an original business data text box and a business update data text box are generated corresponding to each field of the first business data, which is displayed in sequence.

[0071] Fill the acquired first business data into the business data modification text box, that is, fill the business data of a specific field in the first business data into the original business data text box, such as: fill Li Si into the original business data text box of the name field;

[0072] Continue to add the business data modification text box filled with the first business data to the first business data update interface to generate and display the second interface data update interface.

[0073] S15, receiving the business update data corresponding to the first business data entered by the user in the second business data update interface, and sending the business update data together with the corresponding first business data to the background server.

[0074] Specifically, the user can fill in the business update data according to the display content of the second interface data update interface, such as: filling in the business update data "Wang Wu" corresponding to "Li Si" in the name field in the first business data; the second interface data update interface also has a save button, and when a save trigger event or other trigger event occurs, the first business data and the business update data corresponding to the first business data are sent to the background server.

[0075] S16, receiving and displaying the prompt information of successful update and saving or the prompt information of failed update and reason returned by the background server.

[0076] Specifically, when the background server receives the first business data and the business update data corresponding to the first business data, it determines the storage location of the business update data corresponding to the first business data according to the storage location of the first business data, such as: the storage location of the business change data "Wang Wu" corresponding to the first business data "Li Si" is the storage location of the original "Li Si" field;

[0077] Determine the data type of the specific field in the corresponding table name and order number in which the business update data corresponding to the first business data is stored, and judge whether the business update data conforms to the data type of the specific field. If it conforms to the data type, it is determined to conform to the attribute requirements of the corresponding storage location, otherwise it is determined not to conform to the attribute requirements of the corresponding storage location; for example: the data type of the age field in the corresponding table name and order number of the business update data "20" is INT, and the output business data is "20" which conforms to the attribute requirements;

[0078] Determine the data range of the specific field in the corresponding table name and order number where the business update data corresponding to the first business data is stored, and judge whether the business update data is within the data range. If it is within the data range, it is determined to meet the data range requirements of the corresponding storage location, otherwise it is determined not to meet the data range requirements of the corresponding storage location; the data range of the specific field in the corresponding table name and order number is the data range specified by the corresponding data type of the queried first business data, such as the data range specified by the data type of the field age is less than 200. Once the business update data is greater than 200, it is determined not to meet the data range requirements of the corresponding storage location. Alternatively, considering that the data range of the same field stored in the same table is not much different, the data range of the specific field in the corresponding table name and order number can be used as the data range of the same field stored in the current table.

[0079] Taking into account that the data types corresponding to some fields have attribute and data range requirements, an update success and save prompt message is generated only when it is determined that the attribute requirements of the corresponding storage location are met and the data range requirements of the corresponding storage location are met; when it is determined that the attribute requirements of the corresponding storage location are met but the data range requirements of the corresponding storage location are not met, an update failure prompt message is generated and the reason for the update failure is that the data range requirements are not met; when it is determined that the attribute requirements of the corresponding storage location are not met but the data range requirements of the corresponding storage location are met, an update failure prompt message is generated and the reason for the update failure is that the attribute requirements are not met; when it is determined that the attribute requirements of the corresponding storage location are not met and the data range requirements of the corresponding storage location are not met, an update failure prompt message is generated and the reason for the update failure is that the attribute requirements are not met.

[0080] When the background server determines that the business update data corresponding to the first business data meets the attribute requirements and data range requirements of the corresponding storage location in the business data storage table, it will replace the first business data with the business update data corresponding to the first business data and store it in the determined storage location. At the same time, the generated update success and save prompt information or update failure and reason prompt information is returned to the front-end interface, thereby receiving the update success and save prompt information or update failure and reason prompt information returned by the background server.

[0081] S17. After receiving the prompt information of successful update and saving, receive the record business data update request generated by the user and send it to the background server, so that when the background server receives the record business data update request, it stores the first business data and the business update data corresponding to the first business data in the business data update record table created by itself.

[0082] Specifically, the second interface data update interface is further provided with a record button, and when the user clicks the record button, a record business data update request is triggered to generate, and the first business data and the business update data corresponding to the first business data are sent to the background server.

[0083] Each time an update is successfully completed and a request to update the business data is triggered, the backend server will create a new record in the business data update record table it created through SQL to save the business data before and after the update and record the update time; and the business data before and after the update are concatenated into a long string in the format of "field=value,...,field=value" and saved.

[0084] In a specific embodiment, in addition to completing the update of the business data, in order to facilitate the user to review and query the updated business data, such as Figure 2 As shown, the method also includes:

[0085] S21. Receive a business data update record query request generated by a user trigger, and display a preset first business data update record query interface.

[0086] Specifically, Figure 3 As shown, the basic interface for data updating and viewing is provided with "Update" and "View" buttons, and the user can choose to click the specific "Query" button to trigger the generated business data update record query request. When receiving the business data update record query request triggered by the user, the first business data update record query interface is displayed, and the first business data update record query interface includes: a table name identifier, a single number identifier, and content display text boxes corresponding to the two identifiers.

[0087] S22. Receive the table name and order number filled in by the user in the first business data update record query interface, and send them to the backend server.

[0088] Specifically, the user can fill in the table name and order number to be updated in the first business data update record query interface according to the business data update query requirements, and record them as the second table name and the second order number. When the enter trigger event or the enter trigger event in JavaScript occurs, the table name and order number filled in by the user in the first business data update record query interface are sent to the background server.

[0089] S23: Receive the second business data and business update data corresponding to the second business data returned by the background server.

[0090] Specifically, when the background server receives the second table name and the second order number, it will query and obtain the corresponding business data, the corresponding business change data and the update time in the business data update record table according to the second table name and the second order number, and record them as the second business data and the business update data corresponding to the second business data, and return the queried data to the front-end interface, thereby receiving the second business data, the business update data corresponding to the second business data and the update time returned by the background server.

[0091] S24. Dynamically generate a business data update record text box according to the acquired second business data and the business update data corresponding to the second business data, fill in the business data update record text box accordingly, add the business data update record text box to the first business data update record query interface, and generate and display the second business data update record query interface.

[0092] Specifically, Figure 6 As shown, the business data update record text box includes the original business data text box and the business update data text box; after filling the acquired second business data and the business update data corresponding to the second business data into the business data update record text box, the business data update record text box is added to the first business data update record query interface, and the second business data update record query interface is generated and displayed.

[0093] In a specific embodiment, considering the security guarantee of business data update, preventing unauthorized users from obtaining business data and maliciously modifying dynamic data, the method further includes:

[0094] After receiving a service data update request triggered by a user, a preset user login interface is displayed in advance; the user login interface includes a user login ID text box, a password text box and a login confirmation button.

[0095] Receive the user login ID and password filled in by the user on the user login interface, and send the user login ID and password to the backend server when the user triggers the login confirmation button.

[0096] Receive the prompt information of whether the login is legal or not returned by the backend server; specifically, when the backend server receives the login request, it determines whether the user login ID and password are consistent with the user login authority table stored in itself, and if they are consistent, it generates a prompt information of legal login, otherwise, it generates a prompt information of illegal login; the user login authority table includes: the user login ID that is allowed to log in, and the password that matches the user login ID that is allowed to log in;

[0097] After receiving the login legal information, the preset first business data update interface is displayed, otherwise the preset first business data update interface is not displayed.

[0098] In a specific embodiment, considering the accuracy and security of business data update, to prevent authorized users from updating dynamic data beyond their own authority, the method further includes:

[0099] Taking into account the user's change authority, receiving the table name and order number filled in by the user on the first business data update interface, recording them as the first table name and the first order number and sending them to the backend server, and receiving the first business data returned by the backend server or a prompt message indicating that the update authority has been exceeded;

[0100] The prompt information of exceeding update authority is generated by the background server querying the update authority information corresponding to the user login ID according to the stored user update authority table, that is, obtaining the table name and order number allowed to be updated corresponding to the current user login ID and the specific fields in the table name and order number allowed to be updated; when the table name and order number filled in by the user in the first business data update interface exceed the update authority corresponding to the user login ID, the prompt information of exceeding update authority is generated; the update authority information includes: user login ID, the table name and order number allowed to be updated corresponding to the user login ID, and the specific fields in the table name and order number allowed to be updated corresponding to the user login ID.

[0101] In a specific embodiment, considering that the service data update range of some users needs to be adjusted in real time, it is necessary to authorize the service data range of some users, and the method further includes:

[0102] Receive the business data update authorization request and user login ID generated by the user trigger and send them to the backend server; specifically, Figure 7 As shown, the business data update and viewing related basic interface also includes: an update authorization interface, the update authorization interface is provided with a "New" button, the user can choose to click the "New" specific button to trigger the generated business data update authorization request, when receiving the business data update request triggered by the user, the preset login interface is displayed, and the user's preset user login interface is obtained; the user login ID filled in by the user in the user login interface is received, and the user login ID and the business data update request are sent to the background server together.

[0103] Receive prompt information on whether the business data update authorization request is confirmed returned by the background server; specifically, when receiving the business data update authorization request, the background server determines whether the update permission information corresponding to the user login ID has administrator authority based on the stored user update authority table. If the judgment result is that the user has administrator authority, a business data update authorization request confirmation prompt information is generated; otherwise, a business data update authorization request unconfirmed prompt information is generated; the update authority information also includes: whether the administrator authority information corresponding to the user login ID; after generating the prompt information on whether the business data update authorization request is confirmed, the background server returns the prompt information on whether the business data update authorization request is confirmed to the front-end interface.

[0104] When the business data update authorization request confirmation prompt information returned by the background server is received, the preset first business data update authorization interface is displayed. The first business data update authorization interface includes: user ID identification, table name identification, order number identification and content display text boxes corresponding to each identification. In this embodiment, only the user ID identification, table name identification and content display text boxes corresponding to each identification are set; the user ID, table name and order number entered by the user in the first business data update authorization interface are received and recorded as the third table name and the third order number; when the user clicks the set get field button to trigger the get field event, the input user ID, third table name and third order number are sent to the background server.

[0105] Receive the corresponding table and the fields in the order number queried in the business data storage table according to the third table name and the third order number returned by the backend server; generate a field selection text box according to the obtained field, and add it to the first business data update right authorization interface, generate and display the second business data update right authorization interface; Figure 8 As shown, the field selection text box includes all field names and field text descriptions of the current table name and order number, as well as a selection box corresponding to each field name and field text description.

[0106] The fields selected by the user in the second business data update right authorization interface are received and sent to the background server, so that the background server modifies the records of the user update authority table according to the selected fields and the corresponding user ID.

[0107] like Fig. 9 As shown, the embodiment of the present application discloses a dynamic business data update and query system, including: a front-end interface system 1 and a back-end service system 2;

[0108] The front-end interface system 1 comprises:

[0109] The first business data update interface display module 101 is used to receive a business data update request generated by a user trigger and display a preset first business data update interface;

[0110] The second business data update interface display module 102 is used to receive the table name and order number filled in by the user in the first business data update interface, record them as the first table name and the first order number and send them to the background server, receive the first business data returned by the background server, the first business data is obtained by the background server in the business data storage table stored in the backend server according to the first table name and the first order number; dynamically generate a business data modification text box according to the obtained first business data, fill the obtained first business data into the business data modification text box, add the business data modification text box to the first business data update interface, and generate and display the second interface data update interface;

[0111] The update success or failure prompt information generation module 103 is used to receive the business update data corresponding to the first business data filled in by the user in the second business data update interface, send it together with the corresponding first business data to the background server, receive and display the update success and save prompt information or the update failure and reason prompt information returned by the background server; the update success and save prompt information or the update failure and reason prompt information is generated by the background server based on whether the business update data corresponding to the first business data meets the attribute requirements and data range requirements of the corresponding storage location in the business data storage table;

[0112] The business data update request saving module 104 is used to receive the business data update record request triggered by the user and send it to the background server after receiving the update success and saving prompt information, so that when the background server receives the business data update record request, it stores the first business data and the business update data corresponding to the first business data in the business data update record table created by itself.

[0113] The backend service system 2 includes a backend server 201 for storing, querying, modifying and analyzing business data.

[0114] The system further comprises:

[0115] The first business data update record query interface display module 105 is used to receive a business data update record query request generated by a user trigger, and display a preset first business data update record query interface;

[0116] The second business data update record query interface display module 106 is used to receive the table name and order number filled in by the user in the first business data update record query interface, record them as the second table name and the second order number and send them to the background server, receive the second business data returned by the background server and the business update data corresponding to the second business data; the second business data and the business update data corresponding to the second business data are obtained by the background server through query in the business data update record table according to the second table name and the second order number; a business data update record text box is dynamically generated according to the obtained second business data and the business update data corresponding to the second business data, and after the obtained second business data and the business update data corresponding to the second business data are filled in the business data update record text box, the business data update record text box is added to the first business data update record query interface, and the second business data update record query interface is generated and displayed.

[0117] The system further comprises:

[0118] The first business data update interface display module 101 is also used to pre-display a preset user login interface after receiving a business data update request triggered by a user; receive a user login ID and password filled in by the user in the user login interface and send them to the background server, and receive a prompt message from the background server indicating whether the login is legal or not; the prompt message of whether the login is legal or not is generated by the background server based on the stored user login authority table; the user login authority table includes: user login ID and password allowed to log in; after receiving the login legality information, the preset first business data update interface is displayed, otherwise the preset first business data update interface is not displayed.

[0119] The second business data update interface display module 102 is also used to receive the table name and order number filled in by the user in the first business data update interface, record them as the first table name and the first order number and send them to the background server, and receive the first business data returned by the background server or the prompt information of exceeding the update authority; the prompt information of exceeding the update authority is generated by the background server according to the stored user update authority table to query the update authority information corresponding to the user login ID, and when it is determined that the table name and the order number filled in by the user in the first business data update interface exceed the update authority; the update authority information includes: the user login ID, the table name and the order number allowed to be updated corresponding to the user login ID, and the specific fields in the table name and the order number allowed to be updated corresponding to the user login ID.

[0120] The system further comprises:

[0121] The first business data update authorization interface display module 107 is used to receive the business data update authorization request and user login ID generated by user triggering, and send them to the background server; receive the prompt information of whether the business data update authorization request is confirmed returned by the background server; the prompt information of whether the business data update authorization request is confirmed is determined by the background server when receiving the business data update authorization request, and whether the update permission information corresponding to the user login ID has administrator authority according to the stored user update authority table; if the judgment result is that the user has administrator authority, a business data update authorization request confirmation prompt information is generated, otherwise, a business data update authorization request unconfirmed prompt information is generated; when the business data update authorization request confirmation prompt information returned by the background server is received, the preset first business data update authorization interface is displayed;

[0122] The second business data update right authorization interface display module 108 is used to receive the user ID, table name and order number input by the user in the first business data update right authorization interface, record them as the third table name and the third order number and send them to the background server, receive the corresponding table and order number fields queried in the business data storage table according to the third table name and the third order number returned by the background server; generate a field selection text box according to the obtained field, and add it to the first business data update right authorization interface, generate and display the second business data update right authorization interface;

[0123] The fields selected by the user in the second business data update right authorization interface are received and sent to the background server, so that the background server modifies the records of the user update authority table according to the selected fields and the corresponding user ID.

[0124] The embodiment of the present application also discloses a computer-readable storage medium.

[0125] Specifically, the computer-readable storage medium stores a computer program that can be loaded by a processor and execute the method of dynamic business data updating and querying as described above. The computer-readable storage medium includes, for example: a U disk, a mobile hard disk, a read-only memory (ROM), a random access memory (RAM), a magnetic disk or an optical disk, and other media that can store program codes.

[0126] The embodiment of the present application also discloses a computer device.

[0127] Specifically, the computer device includes a memory and a processor, and the memory stores a computer program that can be loaded by the processor and execute the above-mentioned dynamic business data updating and querying method.

[0128] The above are all preferred embodiments of the present application, and are not intended to limit the protection scope of the present application. Any feature disclosed in this specification (including the abstract and drawings), unless otherwise stated, can be replaced by other equivalent or alternative features with similar purposes. That is, unless otherwise stated, each feature is only an example of a series of equivalent or similar features.

Claims

1. A method for updating and querying dynamic business data, characterized in that: include: Receiving a service data update request triggered by a user, and displaying a preset first service data update interface; Receive the table name and order number filled in by the user on the first business data update interface, record them as the first table name and the first order number, and send them to the backend server, and receive the first business data or the prompt information of exceeding the update authority returned by the backend server; The prompt message of exceeding the update authority is generated by the backend server when it is determined that the table name and order number filled in by the user in the first business data update interface exceed the update authority by querying the update authority information corresponding to the user login ID according to the stored user update authority table; The update permission information includes: user login ID, table name and order number allowed to be updated corresponding to the user login ID, and specific fields in the table name and order number allowed to be updated corresponding to the user login ID; the first business data is obtained by querying the business data storage table stored in the backend server according to the first table name and the first order number; Dynamically generate a business data modification text box according to the acquired first business data, fill the acquired first business data into the business data modification text box, add the business data modification text box to the first business data update interface, and generate and display the second business data update interface; Receive the business update data corresponding to the first business data filled in by the user in the second business data update interface, send it together with the corresponding first business data to the background server, receive and display the update success and save prompt information or the update failure and reason prompt information returned by the background server; the update success and save prompt information or the update failure and reason prompt information is generated by the background server based on whether the business update data corresponding to the first business data meets the attribute requirements and data range requirements of the corresponding storage location in the business data storage table; After receiving the prompt message of successful update and saving, receiving the record business data update request generated by the user trigger and sending it to the backend server, so that the backend server stores the first business data and the business update data corresponding to the first business data in the business data update record table created by itself when receiving the record business data update request; Also includes: After receiving a business data update request triggered by a user, a preset user login interface is displayed in advance; Receive the user login ID and password filled in by the user on the user login interface and send them to the backend server, and receive the prompt information of whether the login is legal or not returned by the backend server; the prompt information of whether the login is legal or not is generated by the backend server according to the stored user login permission table; the user login permission table includes: the user login ID and password of the user who is allowed to log in; After receiving the valid login information, the preset first business data update interface is displayed, otherwise the preset first business data update interface is not displayed; Also includes: Receive the business data update authorization request and user login ID triggered by the user, and send them to the backend server; Receive prompt information on whether the business data update authorization request is confirmed returned by the backend server; the prompt information on whether the business data update authorization request is confirmed is determined by the backend server when receiving the business data update authorization request, judging whether the update authority information corresponding to the user login ID has administrator authority according to the stored user update authority table, and generating business data update authorization request confirmation prompt information if the judgment result is that the user has administrator authority, otherwise, generating business data update authorization request non-confirmation prompt information; the update authority information also includes: whether the user has administrator authority information corresponding to the user login ID; When receiving the confirmation prompt message of the business data update authorization request returned by the backend server, display the preset first business data update authorization interface; receive the user ID, table name and order number entered by the user in the first business data update authorization interface, record them as the third table name and the third order number and send them to the backend server, receive the specific fields in the corresponding table and order number queried in the business data storage table according to the third table name and the third order number returned by the backend server; generate a field selection text box according to the obtained field, and add it to the first business data update authorization interface, generate and display the second business data update authorization interface; Receiving the field selected by the user in the second business data update right authorization interface and sending it to the backend server, so that the backend server modifies the record of the user update permission table according to the selected field and the user ID; and further comprising: Receive a business data update record query request triggered by a user, and display a preset first business data update record query interface; Receive the table name and order number filled in by the user in the first business data update record query interface, record them as the second table name and the second order number, and send them to the backend server, and receive the second business data and the business update data corresponding to the second business data returned by the backend server; the second business data and the business update data corresponding to the second business data are obtained by querying the backend server in the business data update record table according to the second table name and the second order number; A business data update record text box is dynamically generated according to the acquired second business data and the business update data corresponding to the second business data, and after the acquired second business data and the business update data corresponding to the second business data are filled into the business data update record text box, the business data update record text box is added to the first business data update record query interface to generate and display the second business data update record query interface.

2. The method for updating and querying dynamic business data according to claim 1, characterized in that: The prompt information of successful update and saving or the prompt information of failed update and reason is generated by the backend server based on whether the business update data corresponding to the first business data meets the attribute requirements and data range requirements of the corresponding storage location in the business data storage table, and specifically includes: Determine the data type of the specific field in the corresponding table name and order number in which the business update data corresponding to the first business data is stored, and judge whether the business update data conforms to the data type of the specific field; if so, determine that it conforms to the attribute requirements of the corresponding storage location; otherwise, determine that it does not conform to the attribute requirements of the corresponding storage location; Determine that the business update data corresponding to the first business data is stored in a data range of a specific field in the corresponding table name and order number, and judge whether the business update data is within the data range; if it is within the data range, it is determined to meet the data range requirements of the corresponding storage location; otherwise, it is determined not to meet the data range requirements of the corresponding storage location; the data range of the specific field in the corresponding table name and order number is the data range specified by the business data type corresponding to the queried first business data; When it is determined that the property requirements of the corresponding storage location are met and the data range requirements of the corresponding storage location are met, the update is successful and the prompt information is saved; otherwise, the corresponding update failure and the reason prompt information are generated.

3. The method for updating and querying dynamic business data according to claim 2, characterized in that: The method of dynamically generating a business data modification text box based on the acquired first business data includes: generating an original business data text box and a business update data text box for each field of the first business data, and sequentially displaying an original business data text box and a business update data text box for each field of the first business data according to the storage sorting of each field in the first business data stored in the corresponding table name and order number.

4. A dynamic business data update and query system, characterized in that: include: Front-end interface system and back-end service system; the back-end service system includes: back-end server; the front-end interface system includes: The first business data update interface display module is used to receive a business data update request generated by a user trigger, and display a preset first business data update interface; the first business data update interface display module is also used to display a preset user login interface in advance after receiving a business data update request generated by a user trigger; receive a user login ID and password filled in by the user on the user login interface and send them to the backend server, and receive a prompt message returned by the backend server indicating whether the login is legal or not; the prompt message indicating whether the login is legal or not is generated by the backend server according to a stored user login authority table; the user login authority table includes: a user login ID and password that is allowed to log in; after receiving the login legality information, the preset first business data update interface is displayed, otherwise the preset first business data update interface is not displayed; The second business data update interface display module is used to receive the table name and order number filled in by the user in the first business data update interface, record them as the first table name and the first order number and send them to the background server, and receive the first business data returned by the background server or the prompt information of exceeding the update authority; the prompt information of exceeding the update authority is generated by the background server when querying the update authority information corresponding to the user login ID according to the stored user update authority table and judging that the table name and the order number filled in by the user in the first business data update interface exceed the update authority; the update authority information includes: the user login ID, the table name and the order number allowed to be updated corresponding to the user login ID, and the specific fields in the table name and the order number allowed to be updated corresponding to the user login ID; the first business data is obtained by querying the business data storage table stored by the background server according to the first table name and the first order number; according to The first business data obtained dynamically generates a business data modification text box, and after the obtained first business data is filled into the business data modification text box, the business data modification text box is added to the first business data update interface, and the second business data update interface is generated and displayed; the update success or failure prompt information generation module is used to receive the business update data corresponding to the first business data filled in by the user in the second business data update interface, send it together with the corresponding first business data to the background server, receive and display the update success and save prompt information or the update failure and reason prompt information returned by the background server; the update success and save prompt information or the update failure and reason prompt information is generated by the background server based on whether the business update data corresponding to the first business data meets the attribute requirements and data range requirements of the corresponding storage position in the business data storage table; A business data update request saving module is used to receive a business data update record request triggered by a user and send it to a backend server after receiving a prompt message indicating that the update is successful and that the update is saved, so that the backend server stores the first business data and the business update data corresponding to the first business data in a business data update record table created by itself when receiving the business data update record request; The system further comprises: The first business data update authorization interface display module is used to receive the business data update authorization request and user login ID triggered by the user, and send them to the background server; receive the prompt information of whether the business data update authorization request is confirmed returned by the background server; the prompt information of whether the business data update authorization request is confirmed is determined by the background server when receiving the business data update authorization request, judging whether the update permission information corresponding to the user login ID has administrator authority according to the stored user update authority table, and if the judgment result is that the user has administrator authority, generating business data update authorization request confirmation prompt information, otherwise, generating business data update authorization request unconfirmed prompt information; when receiving the business data update authorization request confirmation prompt information returned by the background server, displaying the preset first business data update authorization interface; The second business data update right authorization interface display module is used to receive the user ID, table name and order number input by the user in the first business data update right authorization interface, record them as the third table name and the third order number and send them to the backend server, receive the corresponding table and order number fields queried in the business data storage table according to the third table name and the third order number returned by the backend server; generate a field selection text box according to the obtained field, and add it to the first business data update right authorization interface, generate and display the second business data update right authorization interface; receive the field selected by the user in the second business data update right authorization interface and send it to the backend server, so that the backend server modifies the record of the user update authority table according to the selected field and the user ID; The system further comprises: A first business data update record query interface display module, used to receive a business data update record query request triggered by a user, and display a preset first business data update record query interface; The second business data update record query interface display module is used to receive the table name and order number filled in by the user in the first business data update record query interface, record them as the second table name and the second order number and send them to the background server, receive the second business data returned by the background server and the business update data corresponding to the second business data; the second business data and the business update data corresponding to the second business data are obtained by the background server in the business data update record table according to the second table name and the second order number; dynamically generate a business data update record text box according to the obtained second business data and the business update data corresponding to the second business data, and after filling the obtained second business data and the business update data corresponding to the second business data into the business data update record text box, add the business data update record text box to the first business data update record query interface, and generate and display the second business data update record query interface.

5. A computer-readable storage medium, characterized in that: The computer-readable storage medium includes a stored computer program, wherein when the computer program is executed, the device where the computer-readable storage medium is located is controlled to execute the method according to any one of claims 1 to 3.

6. A computer device, characterized in that: The computer device comprises a memory, a processor and a program stored and executable on the memory, and the program implements the steps of the method according to any one of claims 1 to 3 when executed by the processor.

Images