Data verification method, system and equipment based on web system and storage medium

Abstract

The invention discloses a data verification method and device based on a web system, equipment and a storage medium, relates to the technical field of Internet, and can realize one-button data verification operation. The method comprises the steps that when a web application detects that a user triggers a data verification function based on an imitated bookmark entry, specified content is marked; the web application determines a target key field clicked by a user in the specified content, determines at least one to-be-identified field associated with the target key field, and transmits a to-be-identified field value corresponding to each to-be-identified field to the data verification interface; the data verification interface requests an actual field value of each to-be-identified field from the target database, and performs data missing verification on the to-be-identified field value corresponding to the to-be-identified field according to the actual field value to obtain a verification result corresponding to each to-be-identified field; and the web application receives the at least one verification result transmitted by the data verification interface, and displays the at least one verification result on the front-end display page.

Description

Technical Field

[0001] The present application relates to the field of Internet technology, and in particular to a data verification method, system, computer device and computer-readable storage medium based on a web system. Background Art

[0002] With the continuous development and transformation of the education industry, the demand for student services is increasing, and digital student services have become an important means to improve education quality and management efficiency. The use of advanced student service management systems can not only achieve efficient digital management of teaching information, but also optimize resource allocation and enhance service quality. At present, the student service system is in the process of rapid iteration, and the number of fields displayed on the system access page is gradually increasing. When a field display is inconsistent with the data counted by the teacher, it is impossible to determine where the abnormal data is in time.

[0003] In the related art, in order to determine the location of abnormal data in a timely manner, relevant personnel are required to log in to a designated tool platform and access the database through the tool platform to perform data query.

[0004] In the process of implementing this application, the applicant found that the related technology has at least the following problems:

[0005] Although the designated tool platform can support access to the database for data query, relevant personnel often need to configure the HOST (host) and visit the corresponding login website to log in to the designated tool platform. After logging in to the designated data platform, they need to enter the corresponding parameters to request data return, which leads to a long data verification link and low verification efficiency. Summary of the invention

[0006] In view of this, the present application provides a data verification method, system, device and storage medium based on a web system. The main purpose is to solve the problem that although the designated tool platform can support access to the database for data query, relevant personnel often need to configure the HOST (host) and access the corresponding login website to log in to the designated tool platform, and after logging in to the designated data platform, they need to enter the corresponding parameters to request data return, which leads to the problem of long data verification link and low verification efficiency.

[0007] According to the first aspect of the present application, a data verification method based on a web system is provided. The method is applied to a web platform. The web platform provides a web application and is configured with a data verification interface, including:

[0008] When the web application detects that the user triggers the data verification function based on the imitation bookmark entry, the specified content in the front-end display page is marked, and the specified content is the key field of the data table to be verified displayed in the front-end display page;

[0009] The web application determines the target key field clicked by the user in the specified content, and determines at least one to-be-identified field associated with the target key field, and transmits the to-be-identified field value corresponding to each to-be-identified field to the data verification interface;

[0010] The data verification interface requests the actual field value of each field to be identified from the target database, and performs data missing verification on the field value to be identified corresponding to the field to be identified based on the actual field value, to obtain the verification result corresponding to each field to be identified;

[0011] The web application receives at least one verification result transmitted by the data verification interface, and displays the at least one verification result on a front-end display page.

[0012] Optionally, when the web application detects that the user triggers the data verification function based on the simulated bookmark entry, marking the specified content in the front-end display page includes:

[0013] The web application sets a click event listener for the simulated bookmark entry;

[0014] When the web application listens to the event of clicking the simulated bookmark entry based on the event listener, the specified page element corresponding to the specified content is determined by checking the page element of the front-end display page;

[0015] The web application modifies the element attributes of the specified page element to make the specified content clickable, thereby completing the marking operation on the specified content.

[0016] Optionally, before the web application sets a click event listener for the simulated bookmark entry, the method further includes:

[0017] The web application reads the page URL of the front-end display page and identifies the secondary directory of the page URL based on the regular expression;

[0018] If the web application recognizes a fixed keyword preset in the secondary directory of the URL, it generates a reminder message indicating that the verification function is effective and sends it to the designated terminal for display, and sets a click event listener for the imitation bookmark entry;

[0019] If the web application does not recognize the fixed keywords preset in the secondary directory of the website, a reminder message indicating that the verification function is not effective is generated and sent to the designated terminal for display.

[0020] Optionally, the web application determines the target key field clicked by the user in the specified content, determines at least one to-be-identified field associated with the target key field, and transmits the to-be-identified field value corresponding to each to-be-identified field to the data verification interface, including:

[0021] The web application adds a click event listener to each key field of the data table to be verified;

[0022] When the web application listens to a key field click event, the field identifier of the target key field clicked by the user is obtained based on the click event listener;

[0023] The web application queries at least one to-be-identified field associated with the field identifier in the data storage space, obtains the to-be-identified field value corresponding to each to-be-identified field, and passes the to-be-identified field value corresponding to each to-be-identified field to the data verification interface.

[0024] Optionally, the data verification interface requests the target database for the actual field value of each field to be identified, and performs data missing verification on the field value to be identified corresponding to the field to be identified according to the actual field value, to obtain a verification result corresponding to each field to be identified, including:

[0025] The data verification interface calls the data query service to send the field identifier of each field to be identified to the target database, so that the target database searches the data table for the field value corresponding to the field to be identified according to the field identifier, and sends the field value as the actual field value corresponding to the field to be identified to the data verification interface;

[0026] For each to-be-identified field in the at least one to-be-identified field, the data verification interface receives an actual field value corresponding to the to-be-identified field, and performs a data missing verification on the to-be-identified field value corresponding to the to-be-identified field according to the actual field value to obtain a verification result;

[0027] The data verification interface performs data missing verification on the to-be-identified field value corresponding to each to-be-identified field in at least one to-be-identified field to obtain a verification result corresponding to each to-be-identified field.

[0028] Optionally, the data verification interface receives an actual field value corresponding to the field to be identified, and performs data missing verification on the field value to be identified corresponding to the field to be identified according to the actual field value, to obtain a verification result, including:

[0029] The data verification interface receives the actual field value corresponding to the field to be identified, and uses the actual field value to perform missing verification on the field value to be identified corresponding to the field to be identified;

[0030] If the data verification interface detects that the actual field value corresponding to the to-be-identified field exists and the to-be-identified field value corresponding to the to-be-identified field is a null value, a prompt message is generated to indicate that the field value is missing, and a verification result is generated based on the prompt message and the actual field value;

[0031] If the data verification interface detects that the actual field value corresponding to the to-be-identified field exists and the to-be-identified field value corresponding to the to-be-identified field exists, a prompt message is generated to indicate that the field value is not missing, and a verification result is generated according to the prompt message;

[0032] If the data verification interface detects that the actual field value corresponding to the field to be identified is a null value and the field value to be identified of the field to be identified is a null value, a prompt message is generated to indicate that the field value is not missing, and a verification result is generated according to the prompt message.

[0033] Optionally, the web application receives at least one verification result transmitted by the data verification interface, and displays at least one verification result on a front-end display page, including:

[0034] The web application receives at least one verification result transmitted by the data verification interface;

[0035] For each verification result in the at least one verification result, the web application reads prompt information in the verification result, and adds a floating window on the field to be identified corresponding to the verification result;

[0036] If the prompt information indicates that the field value is not missing, the web application setting prompt information is displayed in the floating window;

[0037] If the prompt information indicates that the field value is missing, the web application reads the actual field value in the verification result, and sets the prompt information and the actual field value to be displayed in the floating window.

[0038] According to a second aspect of the present application, a web system is provided, wherein the web system provides a web application and is configured with a data verification interface;

[0039] The web application is used to mark the specified content in the front-end display page when detecting that the user triggers the data verification function based on the imitation bookmark entry, and the specified content is the key field of the to-be-verified data table displayed in the front-end display page;

[0040] The web application is used to determine the target key field clicked by the user in the specified content, and determine at least one to-be-identified field associated with the target key field, and pass the to-be-identified field value corresponding to each to-be-identified field to the data verification interface;

[0041] The data verification interface is used to request the actual field value of each of the to-be-identified fields from the target database, and perform data missing verification on the to-be-identified field value corresponding to the to-be-identified field according to the actual field value, to obtain the verification result corresponding to each of the to-be-identified fields;

[0042] The web application is used to receive at least one verification result transmitted by the data verification interface, and display at least one of the verification results on the front-end display page.

[0043] Optionally, the web application is used to set a click event listener for the simulated bookmark entry; when the event listener detects an event of clicking the simulated bookmark entry, the designated page element corresponding to the designated content is determined by checking the page elements of the front-end display page; the element attributes of the designated page element are modified to make the designated content clickable, thereby completing the marking operation on the designated content.

[0044] Optionally, the web application is further used to read the page URL of the front-end display page, and identify the URL secondary directory of the page URL based on a regular expression; if a fixed keyword preset in the URL secondary directory is identified, a reminder message indicating that the verification function is effective is generated and sent to a designated terminal for display, and a click event listener is set for the imitation bookmark entry; if the fixed keyword preset in the URL secondary directory is not identified, a reminder message indicating that the verification function is not effective is generated and sent to a designated terminal for display.

[0045] Optionally, the web application is used to add a click event listener to each key field of the data table to be verified; when a key field click event is listened to, the field identifier of the target key field clicked by the user is obtained based on the click event listener; in the data storage space, at least one to-be-identified field associated with the field identifier is queried, and the to-be-identified field value corresponding to each to-be-identified field is obtained, and the to-be-identified field value corresponding to each to-be-identified field is passed to the data verification interface.

[0046] Optionally, the data verification interface is used to call the data query service to send the field identifier of each of the to-be-identified fields to the target database, so that the target database queries the field value corresponding to the to-be-identified field in the data table according to the field identifier, and sends the field value as the actual field value corresponding to the to-be-identified field to the data verification interface; for each to-be-identified field in the at least one to-be-identified field, the data verification interface receives the actual field value corresponding to the to-be-identified field, and performs a data missing check on the to-be-identified field value corresponding to the to-be-identified field according to the actual field value to obtain a check result; and performs a data missing check on the to-be-identified field value corresponding to each to-be-identified field in the at least one to-be-identified field to obtain a check result corresponding to each to-be-identified field.

[0047] Optionally, the data verification interface is used to receive the actual field value corresponding to the field to be identified, and use the actual field value to perform missing check on the field value to be identified corresponding to the field to be identified; if it is detected that the actual field value corresponding to the field to be identified exists and the field value to be identified corresponding to the field to be identified is a null value, then a prompt message is generated to indicate that the field value is missing, and the verification result is generated according to the prompt message and the actual field value; if it is detected that the actual field value corresponding to the field to be identified exists and the field value to be identified corresponding to the field to be identified exists, then a prompt message is generated to indicate that the field value is not missing, and the verification result is generated according to the prompt message; if it is detected that the actual field value corresponding to the field to be identified is a null value and the field value to be identified of the field to be identified is a null value, then a prompt message is generated to indicate that the field value is not missing, and the verification result is generated according to the prompt message.

[0048] Optionally, the web application is used to receive at least one verification result transmitted by the data verification interface; for each of the at least one verification result, the web application reads the prompt information in the verification result, and adds a floating window on the field to be identified corresponding to the verification result; if the prompt information indicates that the field value is not missing, the prompt information is set to be displayed on the floating window; if the prompt information indicates that the field value is missing, the actual field value is read in the verification result, and the prompt information and the actual field value are displayed on the floating window.

[0049] According to a third aspect of the present application, a device is provided, including a memory and a processor, wherein the memory stores a computer program, and the processor implements the steps of any one of the methods described in the first aspect when executing the computer program.

[0050] According to a fourth aspect of the present application, a storage medium is provided, on which a computer program is stored. When the computer program is executed by a processor, the steps of any one of the methods described in the first aspect are implemented.

[0051] By means of the above technical scheme, the present application provides a data verification method, system, device and storage medium based on a web system, and the present application is applied to a web system, wherein the web system is provided with a web application and is configured with a data verification interface. When the web application detects that a user triggers a data verification function based on a simulated bookmark entry, the specified content in the front-end display page is marked, wherein the specified content is a key field of a data table to be verified displayed in the front-end display page. Next, the web application determines the target key field clicked by the user in the specified content, and determines at least one field to be identified associated with the target key field, and passes the field value to be identified corresponding to each field to be identified to the data verification interface. Subsequently, the data verification interface requests the actual field value of each field to be identified from the target database, and performs data missing verification on the field value to be identified corresponding to the field to be identified according to the actual field value, and obtains the verification result corresponding to each field to be identified. Finally, the web application receives at least one verification result transmitted by the data verification interface, and displays at least one verification result on the front-end display page. In an embodiment of the present application, through the web application provided by the web system, users can implement one-click data verification operations without logging into other tool platforms or configuring complex parameters. They only need to trigger the data verification function in the front-end display page, and then access the database through the pre-configured data verification interface to obtain data for data missing verification, thereby simplifying the data verification operation steps and improving data verification efficiency.

[0052] The above description is only an overview of the technical solution of the present application. In order to more clearly understand the technical means of the present application, it can be implemented in accordance with the contents of the specification. In order to make the above and other purposes, features and advantages of the present application more obvious and easy to understand, the specific implementation methods of the present application are listed below. BRIEF DESCRIPTION OF THE DRAWINGS

[0053] Various other advantages and benefits will become apparent to those of ordinary skill in the art by reading the detailed description of the preferred embodiments below. The accompanying drawings are only for the purpose of illustrating the preferred embodiments and are not to be considered as limiting the present application. Also, the same reference symbols are used throughout the accompanying drawings to represent the same components. In the accompanying drawings:

[0054] Figure 1 A schematic diagram of a data verification method based on a web system provided in an embodiment of the present application is shown;

[0055] Figure 2 A schematic diagram of a data verification method based on a web system provided in an embodiment of the present application is shown;

[0056] Figure 3 A schematic diagram of a pseudo bookmark entry of a data verification method based on a web system provided in an embodiment of the present application is shown;

[0057] Figure 4 A schematic diagram of a data verification method based on a web system provided in an embodiment of the present application is shown;

[0058] Figure 5 A schematic diagram of the structure of a web system provided in an embodiment of the present application is shown;

[0059] Figure 6 A schematic diagram of the device structure of a computer device provided in an embodiment of the present application is shown. DETAILED DESCRIPTION

[0060] The exemplary embodiments of the present application will be described in more detail below with reference to the accompanying drawings. Although the exemplary embodiments of the present application are shown in the accompanying drawings, it should be understood that the present application can be implemented in various forms and should not be limited by the embodiments set forth herein. On the contrary, these embodiments are provided in order to enable a more thorough understanding of the present application and to fully convey the scope of the present application to those skilled in the art.

[0061] The present application embodiment provides a data verification method based on a web system, such as Figure 1 As shown, the method is applied to a web system, the web system provides a web application and is configured with a data verification interface, including:

[0062] 101. When the web application detects that the user triggers the data verification function based on the simulated bookmark entry, the specified content in the front-end display page is marked, and the specified content is a key field of the data table to be verified displayed in the front-end display page.

[0063] Among them, the web system is each service system in the student service direction, and the front-end display page is the display page provided by each service system. In the embodiment of the present application, the front-end display page is a data statistics page for displaying a data table. The web system provides a web service, and the web service provides an entry in the form of a bookmark. The user (data verification personnel) can trigger the data verification function through the entry in the form of a bookmark, so that the web application and the data verification interface perform the corresponding data verification operation, without having to log in to other data verification tool platforms, shortening the data verification link and improving the data verification efficiency.

[0064] Specifically, first, the web application will monitor the user's imitation bookmark entry operation, and when it monitors that the user clicks the imitation bookmark entry to trigger the data verification function, the web application will identify the key fields that need to be verified. Furthermore, by marking these key fields, users can clearly understand the data that can be verified.

[0065] 102. The web application determines the target key field clicked by the user in the specified content, determines at least one to-be-identified field associated with the target key field, and transmits the to-be-identified field value corresponding to each to-be-identified field to the data verification interface.

[0066] The designated content is the data table displayed on the front-end display page. The data table can be a student information table, a student course information table, a teacher course information table, etc. The target key field is the field clicked by the user, and is the field that the user believes needs data verification. The field to be identified is other fields that are associated with the target key field. This application does not specifically limit the content of the data table, the content of the target key field, and the content of the field to be identified.

[0067] During the actual operation, the web application will monitor the user's click event, capture the target key field clicked by the user, and determine the associated field to be identified by identifying the preset association relationship to ensure the accuracy of the verification. Next, the web application will organize the collected field values ​​to be identified into structured request data, and pass each field to be identified and its corresponding field value to the data verification interface to support the data verification interface to perform subsequent data verification operations.

[0068] 103. The data verification interface requests the target database for the actual field value of each field to be identified, and performs data missing verification on the field value to be identified corresponding to the field to be identified according to the actual field value, to obtain the verification result corresponding to each field to be identified.

[0069] Specifically, the data verification interface will construct an SQL query statement or other suitable request method to send a data request to the target database. The target database has multiple data tables. After the target database receives the data request, it can first obtain the header of the data table to be verified corresponding to the field to be identified in the data request, and then find the data table used to store the data in the table according to the header, and finally read the value corresponding to the field identifier of the field to be identified in the data table, and return the value corresponding to the field identifier as the actual field value of the field to be identified to the data verification interface, so that the data verification interface performs data missing verification according to the actual field value of the field to be identified and the field value to be identified, and obtains the verification result corresponding to the field to be identified.

[0070] 104. The web application receives at least one verification result transmitted by the data verification interface, and displays the at least one verification result on a front-end display page.

[0071] Specifically, the web application will parse the verification results received from the data verification interface and display the corresponding verification status and results, such as "data complete" and "data missing". These results will be presented on the front-end display page in an easy-to-understand form, including icons, color tags or pop-up windows, to ensure that users can quickly identify the status of data verification and make corresponding processing in a timely manner.

[0072] The method provided in the embodiment of the present application can mark the specified content in the front-end display page when the web application detects that the user triggers the data verification function based on the imitation bookmark entrance, wherein the specified content is the key field of the data table to be verified displayed in the front-end display page. Next, the web application determines the target key field clicked by the user in the specified content, and determines at least one field to be identified associated with the target key field, and passes the field value to be identified corresponding to each field to be identified to the data verification interface. Subsequently, the data verification interface requests the actual field value of each field to be identified from the target database, and performs data missing verification on the field value to be identified corresponding to the field to be identified according to the actual field value, and obtains the verification result corresponding to each field to be identified. Finally, the web application receives at least one verification result transmitted by the data verification interface, and displays at least one verification result on the front-end display page. In the embodiment of the present application, through the web application provided by the web system, the user can implement a one-click data verification operation, without logging in to other tool platforms or configuring complex parameters, and only needs to trigger the data verification function in the front-end display page, and can access the database through the pre-configured data verification interface to obtain data for data missing verification, thereby simplifying the operation steps of data verification and improving data verification efficiency.

[0073] The present application embodiment provides a data verification method based on a web system, such as Figure 2 As shown, the method includes:

[0074] 201. Verify whether the data verification function of the web application is effective.

[0075] With the continuous development and change of the education industry, the demand for student services is increasing, and digital student services have become an important means to improve the quality of education and management efficiency. The use of advanced student service management systems can not only achieve efficient digital management of teaching information, but also optimize resource allocation and enhance service quality. At present, the student service direction system is in the process of high-speed iteration, and the fields displayed in the system access page are gradually increasing. When there are fields that display inconsistent data with the teacher's statistics, it is impossible to determine where the abnormal data is in time. In the related art, in order to determine the location of abnormal data in time, relevant personnel need to log in to the designated tool platform and access the database through the tool platform for data query. However, the applicant recognizes that although the designated tool platform can support access to the database for data query, the relevant personnel often need to configure the HOST (host) and access the corresponding login website to log in to the designated tool platform, and after logging in to the designated data platform, the corresponding parameters need to be entered to request data return, resulting in a long data verification link and low verification efficiency. Therefore, the embodiment of the present application provides a data verification method based on a web system, which is applied to a web system, and the web system is provided with a web application and is configured with a data verification interface. When the web application detects that the user triggers the data verification function based on the imitation bookmark entry, the specified content in the front-end display page is marked, wherein the specified content is the key field of the data table to be verified displayed in the front-end display page. Next, the web application determines the target key field clicked by the user in the specified content, and determines at least one field to be identified associated with the target key field, and passes the field value to be identified corresponding to each field to be identified to the data verification interface. Subsequently, the data verification interface requests the actual field value of each field to be identified from the target database, and performs data missing verification on the field value to be identified corresponding to the field to be identified according to the actual field value, and obtains the verification result corresponding to each field to be identified. Finally, the web application receives at least one verification result transmitted by the data verification interface, and displays at least one verification result on the front-end display page. In the embodiment of the present application, through the web application provided by the web system, the user can implement a one-click data verification operation, without logging in to other tool platforms or configuring complex parameters. It only needs to trigger the data verification function in the front-end display page, and can access the database through the pre-configured data verification interface to obtain data for data missing verification, thereby simplifying the operation steps of data verification and improving data verification efficiency.

[0076] In the embodiment of the present application, firstly, a web application is added to the web system, and the imitation bookmark entry of the web application is added to the bookmark list. Further, in order to support the subsequent data verification process, it is necessary to verify whether the data verification function of the web application is effective. Specifically, the web application needs to first read the page URL of the front-end display page, identify the URL secondary directory of the page URL, and detect whether it contains preset fixed keywords. In the actual operation process, a regular expression can be used to identify the URL secondary directory. If the web application identifies the fixed keywords preset in the URL secondary directory, a reminder message indicating that "the verification function is effective" is generated, sent to the designated terminal for display to prompt the technician that the web application is running normally, the data verification function has been effective, and the following step 202 is executed. If the web application does not identify the fixed keywords preset in the URL secondary directory, a reminder message indicating that "the verification function is not effective" is generated and sent to the designated terminal for display to prompt the technician that the web application is abnormal, the data verification function has not been effective, and needs to be repaired. In this step, the data verification function of the web application is verified to be effective by identifying fixed keywords in the secondary directory of the URL, providing a basis for the subsequent data verification process. The preset feedback mechanism can help technicians quickly locate problems, reduce troubleshooting time, and improve overall maintenance efficiency.

[0077] 202. When the web application detects that the user triggers a data verification function based on the simulated bookmark entry, the web application marks the designated content in the front-end display page.

[0078] In the embodiment of the present application, in order to facilitate users to clearly understand the content that can be verified, the web application will mark the specified content in the front-end display page when detecting that the user triggers the data verification function. In this way, it is more convenient for users to select the data that needs to be verified, thereby improving operation efficiency and user experience.

[0079] Specifically, Figure 3 As shown, the web service provides an entry in the form of a bookmark. When the user finds that there is a data table to be verified that needs to be verified on the front-end display page, Figure 4As shown, the data verification function can be triggered by clicking on the imitation bookmark entry. It should be noted that in order to be able to promptly discover that the user has clicked on the imitation bookmark entry, the web application often adds a click event listener to the imitation bookmark entry. Then, the user's click event is monitored through the click event listener. When the event of clicking on the imitation bookmark entry is monitored, the page element of the front-end display page is checked to determine the specified page element corresponding to the specified content. In the actual operation process, the DOM selector in JavaScript can be used to determine the specified page element related to the data table to be verified. Finally, the web application can modify the element attributes of the specified page element by modifying the element attributes of the specified page element in the JS file and the CSS file, so that the specified content is in a clickable state, and the specified content is marked by highlighting, changing the text color, adding a line break, etc. It should be noted that the specified content is the key field of the data table to be verified displayed in the front-end display page, wherein the key field is a specified column in the data table to be verified, and the specified column can be the first column in the data table to be verified, or it can be a default column of the data table to be verified that can indicate the ownership of each row of data. For example, the data table to be verified is a student course information table, in which the first column records the student name, and the second, third, and fourth columns record the course IDs filled in by the student. The web application sets the content in the first column to the specified content, changes the element attributes of the content in the first column, sets the content in the first column from a non-clickable state to a clickable state, and highlights the content in the first column.

[0080] In this step, the user can trigger the data verification function through the bookmark-like entry to enable the web application and the data verification interface to perform the corresponding data verification operation, without having to encapsulate the http interface at the bottom layer, deploy the service, and request the POST interface according to the system input parameters logged in by the front-end user, and extract the required numerical assembly parameters from the response to perform data verification, thereby shortening the data verification link and improving the data verification efficiency. At the same time, by marking the specified content, the user's interactive experience is improved, and the intuitiveness of the data verification function is enhanced, so that the user can more easily identify the data items that need to be verified. This intuitive visual feedback allows users to make quick judgments during use, improving the accuracy and efficiency of operations.

[0081] 203. The web application adds a click event listener to each key field of the to-be-verified data table, monitors the key field click event based on the click event listener, and obtains the field identifier of the target key field clicked by the user.

[0082] In this step, in order to determine the field to be identified that the user needs to verify, it is necessary to first determine the field identifier of the target key field clicked by the user, so as to facilitate the subsequent determination of the field to be identified based on the field identifier. Specifically, the web application monitors the user's click behavior on the key field in real time by adding a click event listener on each key field. Once the user clicks on a key field, the web application will immediately respond and trigger the corresponding event listener. Based on the click event listener, the web application can accurately determine the target key field clicked by the user and obtain the unique identifier of the target key field, that is, the field identifier. Continuing to use the above-mentioned student course information table as an example for explanation, the first column in the table records the student's name, and the second, third and fourth columns record the course identifier filled in by the student. When the user clicks "Xiao Ming" in the fourth row of the first column, "Xiao Ming" is the field identifier of the target key field. In this step, by adding a click event listener, the web application can handle the user's click behavior more intelligently, improving user experience and operation efficiency.

[0083] 204. The web application queries at least one to-be-identified field associated with the field identifier in the data storage space, obtains a to-be-identified field value corresponding to each to-be-identified field, and passes the to-be-identified field value corresponding to each to-be-identified field to the data verification interface.

[0084] In this step, the web application will perform an identification operation in the data storage space to determine at least one field to be identified that is associated with the field identifier previously obtained. In an embodiment of the present application, at least one field to be identified that is associated with the field identifier is a field in the same row as the target key field. Continuing to use the above-mentioned student course information table as an example, the first column of the student course information table records the student's name, and the second, third and fourth columns record the course identifier filled in by the student. When the user clicks on "Xiao Ming" in the fourth row of the first column, the content in the second, third and fourth columns of the row where "Xiao Ming" is located is the field to be identified, and "Course a" in the second column, the empty value in the third column, and the empty value in the fourth column are the field values ​​to be identified. Next, the web application will obtain the field values ​​to be identified corresponding to each field to be identified to capture the information to be identified. After obtaining these field values ​​to be identified, the web application will organize the collected field values ​​to be identified into structured request data, such as Figure 4 As shown, the web application will pass each field to be identified and its corresponding field value to be identified to the data verification interface to support the data verification interface to perform subsequent data verification operations.

[0085] 205. The data verification interface requests the target database for the actual field value of each field to be identified, and performs data missing verification on the field value to be identified corresponding to the field to be identified according to the actual field value, to obtain the verification result corresponding to each field to be identified.

[0086] In the embodiment of the present application, in order to accurately determine whether there is data missing in each field to be identified and generate corresponding verification results for subsequent processing and optimization, the data verification interface needs to request the actual field value of each field to be identified from the target database, and then perform data missing verification on the field value to be identified according to the actual field value. The specific data missing verification process is as follows:

[0087] First, the data verification interface sends a data request to the target database by calling the data query service, such as Figure 4 As shown, there are multiple data tables in the target database. After the target database receives a data request, it can first obtain the header of the data table to be verified corresponding to the field to be identified in the data request, and then find the data table used to store the data in the table according to the header, and finally read the value corresponding to the field identifier of the field to be identified in the data table, and return the value corresponding to the field identifier as the actual field value of the field to be identified to the data verification interface to support the data verification interface to perform subsequent data verification operations.

[0088] Further, the data verification interface analyzes the actual field value corresponding to each of the at least one field to be identified received. In the actual operation process, for each of the at least one field to be identified, the data verification interface receives the actual field value corresponding to the field to be identified, and performs data missing verification on the field value to be identified corresponding to the field to be identified according to the actual field value, to obtain a verification result. Specifically, the data verification interface receives the actual field value corresponding to the field to be identified, and uses the actual field value to perform data missing verification on the field value to be identified corresponding to the field to be identified. If the data verification interface detects that the actual field value corresponding to the field to be identified exists and the field value to be identified corresponding to the field to be identified is a null value, prompt information for indicating that the field value is missing is generated, and a verification result is generated according to the prompt information and the actual field value. If the data verification interface detects that the actual field value corresponding to the field to be identified exists and the field value to be identified corresponding to the field to be identified exists, prompt information for indicating that the field value is not missing is generated, and a verification result is generated according to the prompt information. If the data verification interface detects that the actual field value corresponding to the field to be identified is a null value and the field value to be identified of the field to be identified is a null value, prompt information for indicating that the field value is not missing is generated, and a verification result is generated according to the prompt information.

[0089] Finally, the data verification interface performs data missing verification on the to-be-identified field value corresponding to each to-be-identified field in at least one to-be-identified field to obtain a verification result corresponding to each to-be-identified field.

[0090] Continuing to use the above student course information table as an example, the first column of the student course information table records the student's name, and the second, third and fourth columns record the course ID filled in by the student. When the user clicks "Xiao Ming" in the fourth row of the first column, the contents in the second, third and fourth columns of the row where "Xiao Ming" is located are the fields to be identified, and "Course a" in the second column, the empty value in the third column and the empty value in the fourth column are the values ​​of the fields to be identified. The data verification interface receives the actual field values ​​corresponding to the fields to be identified sent by the target database, which are "Course a", "Course b", and null values. Among them, the actual field value of the 4th row and 2nd column of the field to be verified is "Course a", and the corresponding field value to be verified is "Course a", indicating that the data in the 4th row and 2nd column of the field to be verified is complete, and a prompt message is generated to indicate that the field value is not missing, and a verification result is generated according to the prompt message; the actual field value of the 4th row and 3rd column of the field to be verified is "Course b", and the corresponding field value to be verified is null, indicating that the data in the 4th row and 3rd column of the field to be verified is missing, and a prompt message is generated to indicate that the field value is missing, and a verification result is generated according to the prompt message and the actual field value "Course b"; the actual field value of the 4th row and 4th column of the field to be verified is null, and the corresponding field value to be verified is null, indicating that the data in the 4th row and 4th column of the field to be verified is complete, and a prompt message is generated to indicate that the field value is not missing, and a verification result is generated according to the prompt message.

[0091] In the embodiment of the present application, by requesting the actual field value of the field to be identified from the target database for data missing verification, the problem of data missing can be discovered in time. In addition, in the embodiment of the present application, the data processing process is optimized through the cooperation between the web application and the data verification interface, so that the user can complete the data missing verification without logging into other data verification tool platforms for manual query, thereby shortening the data verification link and improving the data verification efficiency.

[0092] 206. The web application receives at least one verification result transmitted by the data verification interface, and displays the at least one verification result on a front-end display page.

[0093] In an embodiment of the present application, the web application receives at least one verification result transmitted by the data verification interface. For each of the at least one verification result, the web application reads prompt information in the verification result, and displays the at least one verification result on the front-end display page according to the prompt information.

[0094] Specifically, a floating window can be added to the field to be identified corresponding to the verification result so that the user can quickly understand the data verification result through the floating window. In the actual operation process, if the prompt information indicates that the field value is not missing, the web application sets the prompt information to be displayed on the floating window. If the prompt information indicates that the field value is missing, the web application reads the actual field value in the verification result, sets the prompt information and the actual field value to be displayed on the floating window. In addition, each verification result can also be displayed in a way of changing the font color. Specifically, for the verification result of any field to be identified, if the prompt information in the verification result indicates that the field value is not missing, the font color of the field to be identified is changed to green. If the prompt information in the verification result indicates that the field value is missing, the font color of the field to be identified is changed to red, and a floating window is added to the field to be identified, and the actual field value of the field to be identified is displayed on the floating window. In actual operation, other display methods can also be used to display at least one verification result in the front-end display page. In this way, the display of the data verification result becomes more intuitive and clear, enabling users to obtain data verification results more quickly, significantly enhancing the user experience.

[0095] The method provided in the embodiment of the present application is applied to a web system, and the web system is provided with a web application and is configured with a data verification interface. When the web application detects that a user triggers a data verification function based on a simulated bookmark entry, the specified content in the front-end display page is marked, wherein the specified content is a key field of the data table to be verified displayed in the front-end display page. Next, the web application determines the target key field clicked by the user in the specified content, and determines at least one field to be identified associated with the target key field, and passes the field value to be identified corresponding to each field to be identified to the data verification interface. Subsequently, the data verification interface requests the actual field value of each field to be identified from the target database, and performs a data missing check on the field value to be identified corresponding to the field to be identified according to the actual field value, and obtains the verification result corresponding to each field to be identified. Finally, the web application receives at least one verification result transmitted by the data verification interface, and displays at least one verification result on the front-end display page. In an embodiment of the present application, through the web application provided by the web system, users can implement one-click data verification operations without logging into other tool platforms or configuring complex parameters. They only need to trigger the data verification function in the front-end display page, and then access the database through the pre-configured data verification interface to obtain data for data missing verification, thereby simplifying the data verification operation steps and improving data verification efficiency.

[0096] Further, as Figure 1 The specific implementation of the method, the embodiment of the present application provides a data verification system based on a web system, such as Figure 5As shown, a web system is provided, wherein the web system is provided with a web application 501 and is configured with a data verification interface 502;

[0097] The web application 501 is used to mark the specified content in the front-end display page when it is detected that the user triggers the data verification function based on the imitation bookmark entry, and the specified content is the key field of the to-be-verified data table displayed in the front-end display page;

[0098] The web application 501 is used to determine the target key field clicked by the user in the specified content, determine at least one to-be-identified field associated with the target key field, and pass the to-be-identified field value corresponding to each to-be-identified field to the data verification interface;

[0099] The data verification interface 502 is used to request the actual field value of each field to be identified from the target database, and perform data missing verification on the field value to be identified corresponding to the field to be identified according to the actual field value, to obtain the verification result corresponding to each field to be identified;

[0100] The web application 501 is used to receive at least one verification result transmitted by the data verification interface, and display at least one verification result on the front-end display page.

[0101] In a specific application scenario, the web application 501 is used to set a click event listener for the simulated bookmark entry; when the event of clicking the simulated bookmark entry is listened to by the event listener, the designated page element corresponding to the designated content is determined by checking the page elements of the front-end display page; the element attributes of the designated page element are modified to make the designated content in a clickable state, thereby completing the marking operation on the designated content.

[0102] In a specific application scenario, the web application 501 is also used to read the page URL of the front-end display page, and identify the URL secondary directory of the page URL based on a regular expression; if a fixed keyword preset in the URL secondary directory is identified, a reminder message indicating that the verification function is effective is generated and sent to a designated terminal for display, and a click event listener is set for the bookmark-like entry; if a fixed keyword preset in the URL secondary directory is not identified, a reminder message indicating that the verification function is not effective is generated and sent to a designated terminal for display.

[0103] In a specific application scenario, the web application 501 is used to add a click event listener to each key field of the data table to be verified; when a key field click event is listened to, the field identifier of the target key field clicked by the user is obtained based on the click event listener; in the data storage space, at least one to-be-identified field associated with the field identifier is queried, and the to-be-identified field value corresponding to each to-be-identified field is obtained, and the to-be-identified field value corresponding to each to-be-identified field is passed to the data verification interface.

[0104] In a specific application scenario, the data verification interface 502 is used to call the data query service to send the field identifier of each of the to-be-identified fields to the target database, so that the target database queries the field value corresponding to the to-be-identified field in the data table according to the field identifier, and sends the field value as the actual field value corresponding to the to-be-identified field to the data verification interface; for each to-be-identified field in the at least one to-be-identified field, the data verification interface receives the actual field value corresponding to the to-be-identified field, and performs a data missing check on the to-be-identified field value corresponding to the to-be-identified field according to the actual field value to obtain a check result; and performs a data missing check on the to-be-identified field value corresponding to each to-be-identified field in the at least one to-be-identified field to obtain a check result corresponding to each to-be-identified field.

[0105] In a specific application scenario, the data verification interface 502 is used to receive the actual field value corresponding to the field to be identified, and use the actual field value to perform missing verification on the field to be identified corresponding to the field to be identified; if it is detected that the actual field value corresponding to the field to be identified exists and the field value to be identified corresponding to the field to be identified is a null value, a prompt message is generated to indicate that the field value is missing, and the verification result is generated based on the prompt message and the actual field value; if it is detected that the actual field value corresponding to the field to be identified exists and the field value to be identified corresponding to the field to be identified exists, a prompt message is generated to indicate that the field value is not missing, and the verification result is generated based on the prompt message; if it is detected that the actual field value corresponding to the field to be identified is a null value and the field value to be identified of the field to be identified is a null value, a prompt message is generated to indicate that the field value is not missing, and the verification result is generated based on the prompt message.

[0106] In a specific application scenario, the web application 501 is used to receive at least one verification result transmitted by the data verification interface; for each of the at least one verification result, the web application reads the prompt information in the verification result, and adds a floating window on the field to be identified corresponding to the verification result; if the prompt information indicates that the field value is not missing, the prompt information is set to be displayed on the floating window; if the prompt information indicates that the field value is missing, the actual field value is read in the verification result, and the prompt information and the actual field value are displayed on the floating window.

[0107] The device provided in the embodiment of the present application, when the web application detects that the user triggers the data verification function based on the imitation bookmark entry, marks the specified content in the front-end display page, wherein the specified content is the key field of the data table to be verified displayed in the front-end display page. Next, the web application determines the target key field clicked by the user in the specified content, and determines at least one field to be identified associated with the target key field, and passes the field value to be identified corresponding to each field to be identified to the data verification interface. Subsequently, the data verification interface requests the actual field value of each field to be identified from the target database, and performs data missing verification on the field value to be identified corresponding to the field to be identified according to the actual field value, and obtains the verification result corresponding to each field to be identified. Finally, the web application receives at least one verification result transmitted by the data verification interface, and displays at least one verification result on the front-end display page. In the embodiment of the present application, through the web application provided by the web system, the user can implement a one-click data verification operation, without logging in to other tool platforms or configuring complex parameters, and only needs to trigger the data verification function in the front-end display page, and can access the database through the pre-configured data verification interface to obtain data for data missing verification, thereby simplifying the operation steps of data verification and improving data verification efficiency.

[0108] In an exemplary embodiment, see Figure 6 , and also provides a device, which includes a communication bus, a processor, a memory and a communication interface, and may also include an input and output interface and a display device, wherein each functional unit can communicate with each other through the bus. The memory stores a computer program, and the processor is used to execute the program stored in the memory and execute the data verification method based on the web system in the above embodiment.

[0109] A computer-readable storage medium stores a computer program, which implements the steps of the data verification method based on a web system when executed by a processor.

[0110] Through the description of the above implementation methods, those skilled in the art can clearly understand that the present application can be implemented by hardware, or by means of software plus a necessary general hardware platform. Based on such an understanding, the technical solution of the present application can be embodied in the form of a software product, which can be stored in a non-volatile storage medium (which can be a CD-ROM, a USB flash drive, a mobile hard disk, etc.), including a number of instructions for enabling a computer device (which can be a personal computer, a server, or a network device, etc.) to execute the methods described in each implementation scenario of the present application.

[0111] Those skilled in the art will appreciate that the accompanying drawings are merely schematic diagrams of a preferred implementation scenario, and the modules or processes in the accompanying drawings are not necessarily required for implementing the present application.

[0112] Those skilled in the art will appreciate that the modules in the device in the implementation scenario can be distributed in the device in the implementation scenario according to the implementation scenario description, or can be changed accordingly and located in one or more devices different from the implementation scenario. The modules in the above implementation scenario can be combined into one module, or can be further split into multiple sub-modules.

[0113] The above application serial numbers are for description only and do not represent the advantages or disadvantages of the implementation scenarios.

[0114] The above disclosure only discloses several specific implementation scenarios of the present application. However, the present application is not limited thereto, and any changes that can be conceived by technicians in this field should fall within the scope of protection of the present application.

Claims

1. A data verification method based on a web system, characterized in that: The method is applied to a web system, wherein the web system is provided with a web application and is configured with a data verification interface, including: When the web application detects that the user triggers the data verification function based on the simulated bookmark entry, the specified content in the front-end display page is marked, and the specified content is the key field of the to-be-verified data table displayed in the front-end display page; The web application determines the target key field clicked by the user in the specified content, determines at least one to-be-identified field associated with the target key field, and transmits the to-be-identified field value corresponding to each to-be-identified field to the data verification interface; The data verification interface requests the target database for the actual field value of each field to be identified, and performs data missing verification on the field value to be identified corresponding to the field to be identified according to the actual field value, to obtain a verification result corresponding to each field to be identified; The web application receives at least one verification result transmitted by the data verification interface, and displays at least one of the verification results on the front-end display page.

2. The method according to claim 1, characterized in that When the web application detects that the user triggers the data verification function based on the imitation bookmark entry, marking the specified content in the front-end display page includes: The web application sets a click event listener for the imitation bookmark entry; When the web application monitors the event of clicking the imitation bookmark entry based on the event listener, the specified page element corresponding to the specified content is determined by checking the page element of the front-end display page; The web application modifies the element attribute of the designated page element to make the designated content clickable, thereby completing the marking operation on the designated content.

3. The method according to claim 2, characterized in that Before the web application sets a click event listener for the imitation bookmark entry, the method further includes: The web application reads the page URL of the front-end display page, and identifies the URL secondary directory of the page URL based on a regular expression; If the web application recognizes a fixed keyword preset in the secondary directory of the website, it generates a reminder message indicating that the verification function is effective and sends it to a designated terminal for display, and sets a click event listener for the imitation bookmark entry; If the web application fails to identify the fixed keywords preset in the secondary directory of the website, a reminder message indicating that the verification function is not effective is generated and sent to a designated terminal for display.

4. The method according to claim 1, characterized in that: The web application determines the target key field clicked by the user in the specified content, determines at least one to-be-identified field associated with the target key field, and transmits the to-be-identified field value corresponding to each to-be-identified field to the data verification interface, including: The web application adds a click event listener to each key field of the to-be-verified data table; When the web application monitors a key field click event, obtaining a field identifier of the target key field clicked by the user based on the click event listener; The web application queries at least one to-be-identified field associated with the field identifier in the data storage space, obtains the to-be-identified field value corresponding to each to-be-identified field, and passes the to-be-identified field value corresponding to each to-be-identified field to the data verification interface.

5. The method according to claim 1, characterized in that The data verification interface requests the target database for the actual field value of each field to be identified, and performs data missing verification on the field value to be identified corresponding to the field to be identified according to the actual field value, to obtain a verification result corresponding to each field to be identified, including: The data verification interface calls the data query service to send the field identifier of each field to be identified to the target database, so that the target database queries the field value corresponding to the field to be identified in the data table according to the field identifier, and sends the field value as the actual field value corresponding to the field to be identified to the data verification interface; For each to-be-identified field in the at least one to-be-identified field, the data verification interface receives an actual field value corresponding to the to-be-identified field, and performs a data missing verification on the to-be-identified field value corresponding to the to-be-identified field according to the actual field value to obtain a verification result; The data verification interface performs data missing verification on the to-be-identified field value corresponding to each to-be-identified field in the at least one to-be-identified field to obtain a verification result corresponding to each to-be-identified field.

6. The method according to claim 5, characterized in that The data verification interface receives the actual field value corresponding to the field to be identified, and performs data missing verification on the field value to be identified corresponding to the field to be identified according to the actual field value, to obtain a verification result, including: The data verification interface receives the actual field value corresponding to the field to be identified, and uses the actual field value to perform a missing check on the field value to be identified corresponding to the field to be identified; If the data verification interface detects that the actual field value corresponding to the to-be-identified field exists and the to-be-identified field value corresponding to the to-be-identified field is a null value, a prompt message is generated to indicate that the field value is missing, and the verification result is generated according to the prompt message and the actual field value; If the data verification interface detects that the actual field value corresponding to the to-be-identified field exists and the to-be-identified field value corresponding to the to-be-identified field exists, a prompt message is generated to indicate that the field value is not missing, and the verification result is generated according to the prompt message; If the data verification interface detects that the actual field value corresponding to the field to be identified is a null value and the field value to be identified of the field to be identified is a null value, prompt information is generated to indicate that the field value is not missing, and the verification result is generated according to the prompt information.

7. The method according to claim 6, characterized in that The web application receives at least one verification result transmitted by the data verification interface, and displays at least one verification result on the front-end display page, including: The web application receives at least one verification result transmitted by the data verification interface; For each verification result of the at least one verification result, the web application reads prompt information in the verification result, and adds a floating window on the field to be identified corresponding to the verification result; If the prompt information indicates that the field value is not missing, the web application sets the prompt information to be displayed on the floating window; If the prompt information indicates that the field value is missing, the web application reads the actual field value in the verification result, and sets the prompt information and the actual field value to be displayed on the floating window.

8. A web system, characterized in that: The web system is provided with a web application and is configured with a data verification interface; The web application is used to mark the specified content in the front-end display page when it is detected that the user triggers the data verification function based on the imitation bookmark entry, and the specified content is the key field of the to-be-verified data table displayed in the front-end display page; The web application is used to determine the target key field clicked by the user in the specified content, and determine at least one to-be-identified field associated with the target key field, and pass the to-be-identified field value corresponding to each to-be-identified field to the data verification interface; The data verification interface is used to request the actual field value of each of the to-be-identified fields from the target database, and perform data missing verification on the to-be-identified field value corresponding to the to-be-identified field according to the actual field value, to obtain the verification result corresponding to each of the to-be-identified fields; The web application is used to receive at least one verification result transmitted by the data verification interface, and display at least one of the verification results on the front-end display page.

9. A device comprising a memory and a processor, wherein the memory stores a computer program, characterized in that: When the processor executes the computer program, the steps of the method according to any one of claims 1 to 7 are implemented.

10. A storage medium having a computer program stored thereon, characterized in that: When the computer program is executed by a processor, the steps of the method according to any one of claims 1 to 7 are implemented.

Images