Data query method and device, computer equipment and storage medium

Abstract

The invention relates to the technical field of data processing, and discloses a data query method and device, computer equipment and a storage medium. The method comprises the following steps: receiving text content input to a platform front-end page to obtain a target text; when it is determined that the target text comprises the screening parameters, the screening parameters are transmitted to the target mapping file through the annotations. And in the target mapping file, constructing a fuzzy query statement, and performing fuzzy query to obtain a first standard file information list. When revocation operation is carried out, the standard numbers of the standard files in the revocation state are received, after the operation is repeatedly executed to obtain the first standard file information list, the state of the first standard file information list is modified into a doubt state, and the revocation operation is used for uniformly modifying the states of the standard files quoting the revocation state into the doubt state. According to the method and the device, the quick retrieval and query of the terms and the normative reference file and the function of associating the standard state with the normative reference file are realized, and the retrieval efficiency and accuracy are improved.

Description

Technical Field

[0001] The present invention relates to the field of data processing technology, and in particular to a data query method, device, computer equipment and storage medium. Background Art

[0002] With the development of society and the advancement of technology, standardization work plays an increasingly important role in various fields. As a normative document, standard texts provide unified technical specifications and operational guidance for all walks of life, and are the key to ensuring product quality, safety and efficiency. In the field of meteorology, China Meteorological Standardization Network, as the most authoritative standard query platform, provides a wealth of standard text resources, which is of great significance to the standardized management of the meteorological industry.

[0003] At present, the domestic standard query platform mainly provides two query methods: query by standard number or query by standard name. Users can quickly locate the required standard text through these methods. However, the queried standards are usually in PDF format, and users need to download or open the document online to view the specific content, including the scope of the standard, normative references, terms and definitions, technical content, etc. This query and consultation method meets the user's query needs for standard texts to a certain extent.

[0004] However, a term may be defined in multiple standard texts, but these definitions may not be reflected in the standard name. This results in users not being able to find the standard text containing the definition of a specific term when searching by the standard name, reducing query efficiency and query accuracy.

[0005] Therefore, there is an urgent need for a query method that can improve query efficiency and accuracy. Summary of the invention

[0006] Therefore, the technical problem to be solved by the present invention is to overcome the problems of low query efficiency and accuracy in the related art.

[0007] In order to solve the above technical problems, the present invention provides a data query method, which is applied to a meteorological standardization information service platform. The data query method comprises: The text content input into the front-end page of the meteorological standardization information service platform is received through a preset transfer type to obtain a target text; the target text is a text of the preset transfer type; the text content includes terms, standard numbers, standard names, normative reference documents, release time, implementation time, standard categories or standard status in the standard document; Determining whether the target text includes a screening parameter; When it is determined that the target text includes the screening parameter, the screening parameter is transferred to the target mapping file by annotating the screening parameter; In the target mapping file, construct a fuzzy query statement according to the passed screening parameters; The fuzzy query statement is executed by an executor to perform a fuzzy query in a file database to obtain a first standard file information list; the first standard file information list includes at least one standard file information, the file database stores multiple standard file information, each standard file information corresponds to a standard file, and a single standard file information includes a serial number, a standard number, a standard name, a standard type, a standard status, a release time and an implementation time corresponding to a single standard file; the status includes an abolished status, a questionable status or an active status; Wherein, when the text content is a normative reference document, an abolition operation is performed, and the abolition operation is used to query a standard document that references a target document, and the target document is a standard document in an abolition state. When the abolition operation is performed, the text content input to the front-end page of the meteorological standardization information service platform is received through a preset transfer type to obtain the target text, including: receiving the standard number of the target document input to the front-end page of the meteorological standardization information service platform through a preset transfer type; When performing an abolition operation, after executing the fuzzy query statement through the executor to perform a fuzzy query in the file database to obtain a first standard file information list, the method also includes: modifying the status of the standard files in the first standard file information list to a questionable state to obtain a second standard file information list; when performing the abolition operation, the standard files in the first standard file information list are standard files that reference the target file.

[0008] In an optional implementation, in the target mapping file, constructing a fuzzy query statement according to the transmitted screening parameters includes: In the target mapping file, it is determined through logical judgment whether the transmitted screening parameters are received, and when it is determined that the transmitted screening parameters are received, a fuzzy query statement is constructed according to the transmitted screening parameters.

[0009] In an optional implementation, when the preset transfer type is a string type, the text content input to the front-end page of the meteorological standardization information service platform is received through the preset transfer type to obtain the target text, including: The text content input into the front-end page of the meteorological standardization information service platform is received through a character string type to obtain a target character string.

[0010] In an optional implementation, the determining whether the target text includes a screening parameter includes: Determine whether the target character string satisfies a preset non-empty condition; Among them, the preset non-empty condition includes a non-empty and non-blank character string. When the target character string meets the preset non-empty condition, it is determined that the target text includes the screening parameter; when the target character string does not meet the preset non-empty condition, it is determined that the target text does not include the screening parameter.

[0011] In an optional implementation, when the target mapping file is an XML mapping file, the transferring the screening parameter to the target mapping file by annotating the screening parameter includes: By annotating the screening parameters, specifying the parameter names corresponding to the screening parameters; The parameter name corresponding to the screening parameter is passed to the XML mapping file.

[0012] In an optional implementation, before receiving the text content input into the front-end page of the meteorological standardization information service platform through a preset transmission type and obtaining the target text, the method further includes: The text content input into the front-end page of the meteorological standardization information service platform is transmitted to the back-end service according to the preset naming rules through the preset network request technology; the back-end service is used to receive the text content input into the front-end page of the meteorological standardization information service platform through the preset transmission type to obtain the target text.

[0013] In an optional implementation, after executing the fuzzy query statement through the executor to perform a fuzzy query in the file database to obtain the first standard file information list, the method further includes: Returning the first standard file information list to the front-end page for visual display; After modifying the status of the standard file in the first standard file information list to a questionable status to obtain a second standard file information list, the method further includes: The second standard file information list is returned to the front-end page for visual display.

[0014] In a second aspect, the present invention provides a data query device, which is applied to a meteorological standardization information service platform, and the data query device comprises: The first processing module is used to receive the text content input into the front-end page of the meteorological standardization information service platform through a preset transfer type to obtain a target text; the target text is the text of the preset transfer type; the text content includes terms, standard numbers, standard names, normative reference documents, release time, implementation time, standard categories or standard status in the standard document; A second processing module is used to determine whether the target text includes a screening parameter; A third processing module is used for transferring the screening parameter to a target mapping file by annotating the screening parameter when it is determined that the target text includes the screening parameter; A fourth processing module, configured to construct a fuzzy query statement in the target mapping file according to the transmitted screening parameters; a fifth processing module, configured to execute the fuzzy query statement through an executor to perform a fuzzy query in a file database to obtain a first standard file information list; the first standard file information list includes at least one standard file information, the file database stores multiple standard file information, each standard file information corresponds to a standard file, and a single standard file information includes a serial number, a standard number, a standard name, a standard type, a standard status, a release time and an implementation time corresponding to a single standard file; the status includes an abolished status, a questionable status or an active status; Wherein, when the text content is a normative reference file, an abolition operation is performed, and the abolition operation is used to query the standard file that references the target file, and the target file is a standard file in an abolition state. When the abolition operation is performed, the first processing module is specifically used to receive the standard number of the target file input to the front-end page of the meteorological standardization information service platform through a preset transfer type; The data query device also includes: a status modification module, which is used to modify the status of the standard files in the first standard file information list to a questionable state when performing an abolition operation, and obtain a second standard file information list; wherein, when performing an abolition operation, the standard files in the first standard file information list are standard files that reference the target files.

[0015] In a third aspect, the present invention provides a computer device, comprising: a memory and a processor, the memory and the processor being communicatively connected to each other, the memory storing computer instructions, and the processor executing the data query method of the first aspect or any corresponding embodiment thereof by executing the computer instructions.

[0016] In a fourth aspect, the present invention provides a computer-readable storage medium, on which a single computer-readable storage medium stores computer instructions, and the computer instructions are used to enable a computer to execute the data query method of the first aspect or any corresponding embodiment thereof.

[0017] In a fifth aspect, the present invention provides a computer program product, comprising computer instructions for causing a computer to execute the data query method of the first aspect or any corresponding embodiment thereof.

[0018] The technical solution provided by the present invention has the following technical effects: The technical solution of the embodiment of the present invention receives the text content input by the user through the front-end page, and the text content includes terms, which can realize the query according to the terms in the standard file, thereby improving the query efficiency and accuracy. The preset transfer type allows flexible processing of inputs in various formats, ensuring the consistency and accuracy of the data. By checking whether the target text contains the screening parameters, it is determined whether to execute the subsequent scheme, thereby improving the flexibility and efficiency of the retrieval query. In the target mapping file, a fuzzy query statement is constructed according to the transmitted screening parameters, and the query logic can be dynamically adjusted according to the user input to realize the fuzzy search function. The executor executes the fuzzy query statement, and can quickly query the standard file information that meets the conditions in the database, thereby improving the efficiency and accuracy of data query. When performing the abolition operation, the abolition operation is used to query the standard file that references the target file (the standard file in the abolition state), and the state of the above-mentioned standard file that references this abolition state is modified to a questionable state. The standard number of the target file input into the front-end page of the meteorological standardization information service platform can be received through a preset transfer type. After a fuzzy query is performed in the file database to obtain the first standard file information list (all standard files that reference the target file), the status of all standard files in the first standard file information list is modified to a questionable state, thereby realizing a status change. BRIEF DESCRIPTION OF THE DRAWINGS

[0019] In order to more clearly illustrate the specific implementation methods of the present invention or the technical solutions in the prior art, the drawings required for use in the specific implementation methods or the description of the prior art will be briefly introduced below. Obviously, the drawings described below are some implementation methods of the present invention. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying creative work.

[0020] Figure 1 is a flow chart of a data query method according to an embodiment of the present invention; Figure 2 is a schematic diagram of a meteorological standardization information service platform according to an embodiment of the present invention; Figure 3 is a schematic diagram of a standard doubt notification in an embodiment of the present invention; Figure 4 It is a schematic diagram of the overall flow of the data query method according to an embodiment of the present invention; Figure 5 is a structural diagram of a data query device according to an embodiment of the present invention; Figure 6 It is a schematic diagram of the hardware structure of a computer device according to an embodiment of the present invention. DETAILED DESCRIPTION

[0021] In order to make the purpose, technical solution and advantages of the embodiments of the present invention clearer, the technical solution in the embodiments of the present invention will be clearly and completely described below in conjunction with the drawings in the embodiments of the present invention. Obviously, the described embodiments are part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by those skilled in the art without creative work are within the scope of protection of the present invention.

[0022] At present, there are limitations in the related technologies to search by standard number or by standard name. Searching by standard number or by standard name may not find the standard text containing the definition of specific terms, which increases the time cost and error probability of standardization staff. There is a problem of delayed updating of normative reference documents: the normative reference documents in the standard text are an important basis for the compilation of the standard. Some clauses need to be implemented according to the clauses in the normative reference documents. If a normative reference document has been abolished, then the standard content that cites the normative reference document may be inapplicable. Since the relevant standard query platforms do not have the function of computer screening, and there are many standard texts, manual screening is labor-intensive and difficult, resulting in many standards being inapplicable. However, since they have not been discovered in time by the management department, they are still in the current state. As a result, the abolished normative reference documents have not been removed or updated from the relevant standards in time, affecting the applicability and accuracy of the standards. Standards are normative documents for public use in society, especially mandatory standards, which are important supplements to laws and regulations in many aspects. If the content of the standards is inapplicable, it will affect the progress of standardization work to a certain extent.

[0023] To this end, the embodiments of the present invention provide a data query method, apparatus, computer equipment and storage medium to solve the above problems.

[0024] According to an embodiment of the present invention, a data query method embodiment is provided. It should be noted that the steps shown in the flowchart of the accompanying drawings can be executed in a computer device such as a set of computer executable instructions, and although a logical order is shown in the flowchart, in some cases, the steps shown or described can be executed in an order different from that shown here.

[0025] Figure 1 It is a flowchart of a data query method according to an embodiment of the present invention.

[0026] like Figure 1 As shown, the present invention provides a data query method in an embodiment, which is applied to a meteorological standardization information service platform. Figure 2As shown in the figure, the meteorological standardization information service platform can query and filter based on the standard number, standard name, terminology, normative reference documents, release time, implementation time, standard type (national standard, meteorological, landmark, icon), standard status (abolished status, current status, adopted status, questionable status, referenced status), and can view, modify, add references, delete references, download, delete, etc. for each standard file information. It can upload standard files, add new standard files, and turn pages to view, etc.

[0027] The data query method includes: S101: receiving text content input into a front-end page of a meteorological standardization information service platform through a preset transmission type to obtain a target text.

[0028] In this embodiment, the target text is a text of a preset transfer type. The text content includes terms, standard numbers, standard names, normative references, release time, implementation time, standard categories or standard status in the standard document. The backend service receives the text content input to the front-end page of the meteorological standardization information service platform through the preset transfer type to obtain the target text.

[0029] In this embodiment, when the preset transfer type is a string type, S101 receives the text content input to the front-end page of the meteorological standardization information service platform through the preset transfer type to obtain the target text, specifically including: receiving the text content input to the front-end page of the meteorological standardization information service platform through the string type to obtain the target string. In this embodiment, the background service receives the text content input to the front-end page of the meteorological standardization information service platform through the string type to obtain the target string.

[0030] In this embodiment, before receiving the text content of the front-end page of the meteorological standardization information service platform through the preset transfer type and obtaining the target text, the data query method also includes: transferring the text content of the front-end page of the meteorological standardization information service platform to the background service according to the preset naming rule through the preset network request technology. The background service is used to receive the text content of the front-end page of the meteorological standardization information service platform through the preset transfer type and obtain the target text. As an example, the preset network request technology is the AJAX network request technology, the front-end page is the WEB front-end page, and the preset naming rule is the camel case naming rule.

[0031] The text content input into the WEB front-end page of the meteorological standardization information service platform is transmitted through the AJAX network request technology according to the preset transmission type and preset naming rules. For example, the parameter name is defined using the camel case naming rule. This naming method is used for variable and method names. The first letter of the first word is lowercase, and the first letter of each subsequent word is uppercase. No separators are used between words. For example, the term transmission name is releaseStartTime, and the preset transmission type is String. When the background service receives the text content of the WEB front-end page of the meteorological standardization information service platform, it processes the field name according to the camel case naming rule to ensure the consistency and correctness of the front-end and back-end data. The camel case naming rule has the advantages of readability, maintainability, compliance with programming language specifications, and close to human language habits.

[0032] S102: Determine whether the target text includes a screening parameter.

[0033] In this embodiment, when the preset transfer type is a string type and the target text is a target string, S102 determines whether the target text includes a screening parameter, specifically including: determining whether the target string satisfies a preset non-empty condition.

[0034] In this embodiment, the preset non-empty condition includes a non-empty and non-blank character string, and when the target character string meets the preset non-empty condition, it is determined that the target text includes the screening parameter. When the target character string does not meet the preset non-empty condition, it is determined that the target text does not include the screening parameter.

[0035] As an example, the API method StringUtils.isBlank(define) can be used to determine whether to pass the filtering parameters, and StringUtils.isBlank(define) can be used to determine whether the target text includes the filtering parameters and return the result. Determine whether to continue to execute the following S103-S105 technical solution based on the returned result. If the returned result is false, it is determined to continue to execute the following S103-S105 technical solution, and if the returned result is true, it is determined to stop executing the following S103-S105 technical solution.

[0036] As an example, in Java, the StringUtils.isBlank(define) method is used to determine whether the filter parameters are passed and return the judgment result. Usually there are the following situations: The filter parameter is passed: If the define parameter is not empty and does not contain only whitespace characters (space, tab, newline, etc.), then the filter parameter is passed. In this case, StringUtils.isBlank(define) will return false.

[0037] No filter parameters were passed: If the define parameter is null or a blank string (containing only whitespace characters and no actual content), it means that no filter parameters were passed. In this case, StringUtils.isBlank(define) will return true.

[0038] The filter parameter is not passed: Even if define is not null, if its value is a blank string (containing only whitespace characters such as spaces), this is considered as not passing the filter parameter. StringUtils.isBlank(define) will also return true.

[0039] Based on the return result of StringUtils.isBlank(define), the program can determine the subsequent logical processing: If false is returned: the program will continue to execute the screening logic, such as the technical solutions of S103-S105.

[0040] If true is returned: the application can decide to skip the filtering logic, execute a default query, or prompt the user to re-enter the text.

[0041] In this embodiment, using the StringUtils.isBlank() method can effectively reduce resource waste caused by invalid parameters, such as avoiding unnecessary database queries, while also improving user experience by ensuring that corresponding processing is performed only when the user provides valid screening parameters.

[0042] S103: When it is determined that the target text includes the screening parameter, the screening parameter is transferred to the target mapping file by annotating the screening parameter.

[0043] In this embodiment, when the target mapping file is an XML mapping file, the filtering parameters are transferred to the target mapping file by annotating the filtering parameters in S103, which specifically includes: By annotating the filter parameter, specify the parameter name corresponding to the filter parameter.

[0044] Pass the parameter name corresponding to the filter parameter to the XML mapping file.

[0045] As an example, you can annotate the filter parameters through the @Param annotation, specify the parameter name corresponding to the filter parameters, and pass the parameter name corresponding to the filter parameters to the XML mapping file of the MyBatis-Plus framework. The @Param annotation is used to specify the parameter name passed to the XML mapping file in the method of the Mapper interface. Annotating the filter parameters can explicitly specify the parameter name in the SQL mapping file (that is, the XML mapping file, a file in XML format that defines the mapping relationship between SQL statements and Java objects) or dynamic SQL statements (allowing SQL statements to be dynamically constructed based on the values ​​of the passed parameters). When there are multiple filter parameters, they can be passed to params at the same time, such as number, name, and other parameters. params: In the MyBatis-Plus framework, params is a Map object containing multiple key-value pairs, which is passed to the XML mapping file through the @Param annotation. In the XML mapping file, these parameters can be referenced in the form of #{params.key}, where key is the key in the Map.

[0046] Passing multiple filter parameters: When the Mapper interface method needs to pass multiple filter parameters, these filter parameters can be encapsulated into a Map object and passed to the XML mapping file through the @Param("params") annotation. In the Mapper interface, you can define a method that receives a parameter of type Map. This method is a mature method in the relevant technology. In this way, multiple filter parameters can be handled flexibly, and SQL statements can be dynamically constructed based on the filter parameters, making the query more powerful and flexible. At the same time, using the Map object to encapsulate the filter parameters can avoid parameter order dependence and improve the readability and maintainability of the code.

[0047] S104: In the target mapping file, a fuzzy query statement is constructed according to the transmitted screening parameters.

[0048] In this embodiment, S104 constructs a fuzzy query statement in the target mapping file according to the transmitted screening parameters, specifically including: in the target mapping file, determining whether the transmitted screening parameters are received through logical judgment, and when it is determined that the transmitted screening parameters are received, constructing a fuzzy query statement according to the transmitted screening parameters. The belonging fields and parameter values ​​can be determined according to the transmitted screening parameters, and the fuzzy query statement can be constructed according to the belonging fields and parameter values ​​determined by the transmitted screening parameters. The belonging fields can be determined according to the parameter names corresponding to the screening parameters.

[0049] As an example, the fuzzy query statement is an SQL statement for fuzzy search. When the target mapping file is an XML mapping file, in the target mapping file, determining whether the transmitted screening parameters are received through logical judgment, and when it is determined that the transmitted screening parameters are received, constructing the fuzzy query statement according to the transmitted screening parameters specifically includes: in the XML mapping file, <if>The tag determines whether the passed filter parameters are received, e.g. <if test="params.define !=null ">, the filter parameter params.define is not empty, indicating that the filter parameter params.define is passed. When it is determined that the passed filter parameter (params.define) is received, a fuzzy query statement definelike concat('%', #{params.define}, '%') is constructed according to the passed filter parameter. Among them, define is the field to which it belongs, and #{params.define} represents the parameter placeholder, which is used to reference the parameter value passed to the XML mapping file.

[0050] params is the name of a Map object, which is passed to the XML mapping file in the method of the Mapper interface through the @Param annotation. This Map contains multiple key-value pairs, each key corresponds to a parameter name, and each value corresponds to a parameter value.

[0051] define is a key in the Map that corresponds to a specific parameter value. This parameter value is passed to the XML mapping file through the @Param("params") annotation in the Mapper interface method.

[0052] #{} is the parameter placeholder syntax of MyBatis-Plus, which tells MyBatis-Plus that the placeholder should be replaced with the actual parameter value when executing the SQL statement.

[0053] Therefore, #{params.define} as a whole means: When executing the SQL statement, MyBatis-Plus will replace this placeholder with the value associated with the key define passed into the params Map. Method parameters can be used directly in SQL statements without hard-coding values.

[0054] As an example, in an XML mapping file, you can use <if>The tag dynamically builds SQL statements based on the key values ​​in the Map, for example: xml <select id="selectUsers" resulttype="User">SELECT * FROM usersAND number = #{params.number}

[0055] S105: Execute the fuzzy query statement through the executor to perform a fuzzy query in the file database to obtain the first standard file information list.

[0056] In this embodiment, the first standard file information list includes at least one standard file information. The file database stores multiple standard file information. Each standard file information corresponds to a standard file. A single standard file information includes a serial number, a standard number, a standard name, a standard type, a standard status, a release time and an implementation time corresponding to a single standard file. The status includes an abolished status, a questionable status or an active status. The screening condition of the fuzzy query is: a certain field contains a certain parameter value.

[0057] Execute the SQL statement of the fuzzy query through the executor to perform a fuzzy query in the file database to obtain the first standard file information list.

[0058] As an example, S105 executes a fuzzy query statement through an executor to perform a fuzzy query in the file database to obtain a first standard file information list, specifically including: calling the MySql executor through the MyBatis-Plus database persistence layer framework to query the content in the file database to find out the first standard file information list.

[0059] The query logic of the present invention can be summarized as follows: when the user enters the define (term) screening parameter, a fuzzy query is performed on the define field of the varchar type in the sys_standard_base_info table in the file database, and the MyBatis-Plus database persistence layer framework is called to query the content in the file database to find out the first standard file information list. As long as the define field in the MySql database (file database) contains the parameter value of the params.define screening parameter transmitted by the front end, it means that the standard file information meets the screening condition. In the development and testing phase, the correctness of the query result can be verified by directly outputting the SQL statement spliced ​​by MyBatis-Plus and querying it in the file database. The terms in the first standard file information list queried in the file database are compared with the terms (params.define) input by the user. When the terms in the first standard file information list queried contain the terms input by the user, it means that the first standard file information list can be accurately screened out.

[0060] In the development, the screening parameters transmitted by the @Param annotation mode can clearly specify the parameter name, which can make the SQL statement clearer and easier to read. If there are multiple parameters of the same type in the same SQL statement, when constructing a dynamic SQL statement, that is, when constructing a fuzzy query statement, the @Param annotation can be used to more flexibly control the transmission of the screening parameters.This is particularly friendly for building complex query conditions. The reasonable use of @Param annotations in the project can make the code more robust and easy to maintain.

[0061] The technical solution of the present invention realizes the rapid retrieval function of the main technical content of the standard (terminology and normative reference documents), reducing the time cost and missing probability of standardization staff opening the standard text one by one to find the required content. It can quickly discover the applicability problems of the standard, realize the management of standard documents with standard applicability problems, reduce the time cost of standard management personnel to sort out and review the applicability of the standard, and greatly improve the timeliness, scientificity and authority of the standard. The retrieval function of the standard technical content is realized. The function of associating the status of the standard with the normative reference documents in the standard document is realized.

[0062] In this embodiment, when the text content is a normative reference document, the revocation operation is performed, and the revocation operation is used to query the standard file that references the target file. The target file is a standard file with a revoked state. When performing the revocation operation, the text content input to the front-end page of the meteorological standardization information service platform is received through a preset transfer type to obtain the target text, including: receiving the standard number of the target file input to the front-end page of the meteorological standardization information service platform through a preset transfer type.

[0063] When performing the abolition operation, in S105, after the fuzzy query statement is executed by the executor to perform a fuzzy query in the file database to obtain the first standard file information list, the data query method also includes: S106: modifying the status of the standard file in the first standard file information list to a questionable state to obtain a second standard file information list.

[0064] In this embodiment, when performing the abolition operation, the standard file in the first standard file information list is a standard file that references the target file.

[0065] The MyBatis-Plus framework query method has high security and can effectively avoid SQL injection security vulnerabilities to improve system security. It can also greatly simplify the database operations of Java developers to improve development efficiency, and facilitate standardization staff to quickly find terms and normative reference files in standard texts. With the continuous development of meteorological science and technology, the improvement of observation methods, changes in business needs, etc., some old standards may not be able to adapt to the current actual situation of meteorological work, and the original standards may no longer be applicable and will be abolished. Therefore, when the platform detects that a certain standard file is being abolished, it is necessary to modify the status of the standard file that references the abolished state to a questionable state. Based on the above considerations, this platform implements the function of associating normative reference files with standard status, thereby realizing the status modification of normative reference files. For example, if the administrator modifies the standard status of Article 10 in Figure 2 to "abolished", the meteorological standardization information service platform will automatically retrieve the current standard files that reference the standard file in the file database, and modify the status of the current standard files that reference the standard file to "doubtful".

[0066] In this embodiment, the query method of the normative reference file adopts the technical solution of S101-S105 above. Specifically, when the text content is a normative reference file, an abolition operation is performed, and all standard files that reference the target file in the abolition state can be queried through the abolition operation, and the status of all standard files that reference this abolition state is modified to a questionable state. In this embodiment, when the standard number of the target file is input in the normative reference file in the interface shown in Figure 2, the abolition operation is performed.

[0067] When performing the abolition operation, the abolition operation is used to query the standard file that references the target file, and modify the status of the standard file that references the target file to a questionable state. The target file is a standard file in the abolition state. When performing the abolition operation, the corresponding S101 receives the text content input to the front-end page of the meteorological standardization information service platform through a preset transfer type to obtain the target text, which specifically includes: receiving the standard number of the target file input to the front-end page of the meteorological standardization information service platform through a preset transfer type. The standard number is a national standard number or a meteorological industry standard number (qid). When the number corresponding to the target file is the meteorological industry standard number (qid), the meteorological industry standard number (text content) input into the front-end page of the meteorological standardization information service platform is received through the Integer type (preset transfer type) to obtain the meteorological industry standard number (target text) of the Integer type.

[0068] When performing the abolition operation, the corresponding S102 determines whether the target text includes the filtering parameter, specifically including: judging whether the meteorological industry standard number (target text) of the Integer type is a NULL object to determine whether the target text includes the filtering parameter, and determining that the front end has transferred the filtering parameter when it is not empty.

[0069] When performing the abolition operation, the corresponding S103, when determining that the target text includes the filtering parameter, transfers the filtering parameter to the target mapping file by annotating the filtering parameter, specifically including: when determining that the meteorological industry standard number (target text) of the Integer type is not empty, annotating the params.qid parameter through @Param to transfer the params.qid parameter to the XML mapping file.

[0070] When performing the abolition operation, the corresponding S104 constructs a fuzzy query statement in the target mapping file according to the transmitted screening parameters, specifically including: in the XML mapping file, constructing a fuzzy query statement according to the params.qid parameter and idin (select sid from sys_standard_quote_info where qid = #{params.qid} GROUPBY sid).

[0071] When performing the abolition operation, the corresponding S105 executes a fuzzy query statement through the executor to perform a fuzzy query in the file database to obtain a first standard file information list, specifically including: calling the MySql executor through the MyBatis-Plus database persistence layer framework to execute the fuzzy query statement and id in (select sid from sys_standard_quote_info where qid = #{params.qid} GROUP BY sid), querying the content in the file database, and finding out all the standard files (first standard file information list) that have referenced this abolition state.

[0072] When performing the abolition operation, after executing the fuzzy query statement through the executor to perform a fuzzy query in the file database to obtain the first standard file information list, that is, after calling the MySql executor through the MyBatis-Plus database persistence layer framework to query the content in the file database to find out all the standard files (first standard file information list) that have referenced this abolition state, the data query method also includes: modifying the state of the standard files in the first standard file information list to a questionable state, and obtaining a second standard file information list. When performing the abolition operation, the standard files in the first standard file information list are standard files that reference the target file. The status of all standard files in the second standard file information list is modified to a questionable state, that is, the status of the standard files that reference the specified target file is modified to a questionable state to obtain the second standard file information list.

[0073] Specifically, when performing the abolition operation, in the XML mapping file, a fuzzy query statement and id in (select sid from sys_standard_quote_info where qid = #{params.qid} GROUP BY sid) is constructed according to the params.qid parameter, and a state modification statement updatesys_standard_notice set state='doubtful' and qid = #{params.qid} can also be constructed according to the passed screening parameters. After finding out all the standard files that reference this abolition state, the state modification statement is executed by the executor to modify the status of the standard files in the first standard file information list to a questionable state. Specifically, the MyBatis-Plus database persistence layer framework can be used to call the MySql executor to execute the status modification statement update sys_standard_notice set state='doubtful'and qid = #{params.qid} to change the status of all standard files that reference this abolished status to a doubtful status.

[0074] As an example, when the competent departments of the respective industries conduct a series of processes such as evaluation and recommendation, project establishment, revision, review, and approval on the content of the standard document and determine that the standard is "repealed", the final confirmation is carried out through the standard document "repealing" function in the meteorological standardization information service platform to realize the "repealing" process of the standard document. When performing the abolition operation, the platform uses the AJAX network request technology to pass the "abolition" content parameters filtered by the WEB front-end page to the background service according to the camel case naming rule. For example, the state transmission name is state, and the transmission type is String. It is passed to the background service according to this rule. The background service receives the transmitted text content through the String type, and determines whether the filtering parameters are passed through the API method StringUtils.isBlank(state). When it is determined that the filtering parameters are passed, the filtering parameters are passed to the MyBatis-Plus XML mapping file through the @Param annotation. In the XML mapping file, it is determined through logical judgment whether the transmitted filtering parameters are received. When it is determined that the transmitted filtering parameters are received, a fuzzy search SQL statement is constructed according to the transmitted filtering parameters. For example, if the params.state parameter is passed, the SQL statement is added with the splicing state in('params.state') SQL statement. The complete logic is that when the user enters the state (status) filtering condition, the varchar type state field in the sys_standard_base_info table in the file database is retrieved as the standard file information of the abolition state.

[0075] and state in #{item}, the meaning of the SQL statement is to query the standard file information in the file database with the specified state as the abolished state transmitted by the front end. After the SQL statement is spliced, MyBatis-Plus will call the MySql executor to automatically determine and retrieve the state field in the file database as the data of the content transmitted by the front end. After the query is completed, the state fields of the standard files queried by comparison are all abolished, indicating that the first standard file information list can be accurately screened out.

[0076] When performing the abolish operation, the platform uses the AJAX network request technology to transmit the standard number (for example, number ID) of the standard file to be "abolished" selected by the WEB front-end page to the background service according to the specified camel case naming rule. For example, the standard number transmission name is qid, and the transmission type is Integer. According to this rule, it is transmitted to the background service, and the background service receives the transmitted text content through the Integer type.

[0077] By judging whether qid is a NULL object, it is determined whether the target text includes a screening parameter. When it is non-empty, it is determined that the front end has transmitted the screening parameter. After judging that the standard number of the standard file in the abolished state has been transmitted, the screening parameter is transmitted to the XML mapping file of MyBatis-Plus through the @Param annotation. In the XML mapping file, it is determined by logical judgment whether the transmitted screening parameter is received. When it is determined that the transmitted screening parameter is received, a fuzzy search SQL statement is constructed according to the transmitted screening parameter, for example, it is indicated that the params.qid parameter is transmitted, and it is determined that the transmitted screening parameter is received. The background service splices out a complete standard file reference relationship SQL statement and id in (select sid from sys_standard_quote_info where qid=#{params.qid} GROUP BY sid) through the transmitted screening parameter, and the content in the file database is retrieved by the MyBatis-Plus database persistence layer framework, and the first standard file information list of all standard files that have quoted this abolished state is found. Execute SQL statement update sys_standard_noticeset state='doubtful' and qid=#{params.qid} through MyBatis-Plus database persistence layer framework, the state of all standard files that have quoted this abolished state is modified to doubtful, and the modification completion information is returned after the modification of the doubtful state is completed, and the modification completion information is a numerical value (for example, 1) greater than 0. When the state of the standard files in the first standard file information list is modified to a doubtful state, a second standard file information list is obtained, and specifically when the modification completion information is received, the second standard file information list is obtained, and the second standard file information list is returned to the front page for visual display. Specifically, you can execute standardNoticeService.lambdaQuery().eq(StandardNotice::getSid, info.getId()).eq(StandardNotice::getState, "1").eq(StandardNotice::getqid,baseInfo.getId()).list() to query the second standard file information list of all questionable states that reference this revoked state, and return the second standard file information list in JSON format to the WEB front-end page for visual interface display. The visual interface will pop up all the standard file information in question on the notification page in the form of text and charts, as shown in Figure 3, to remind the administrator to review and confirm.

[0079] As another example, when performing the revocation operation, querying and modification can also be carried out simultaneously. For example, when the platform detects that a certain standard document is being revoked, the system retrieves it in the system according to the national standard number or meteorological industry standard number (qid) of the revoked standard document, passes the standard number to the XML mapping file of MyBatis-Plus through the @Param annotation, and constructs query and modification statements in the XML mapping file according to the passed params.qid parameter. For example, the SQL statement update sys_standard_notice set state='doubtful' and qid = #{params.qid}. The query and modification statements are executed through the executor to perform a fuzzy query in the file database to obtain the first standard document information list, and the status of the standard documents in the first standard document information list is modified to the doubtful status. When the status of the standard documents in the first standard document information list is modified to the doubtful status to obtain the second standard document information list, specifically, when the modification completion information (return value greater than 0) is received, the second standard document information list (all standard documents modified to the doubtful status) is determined, and the second standard document information list is returned to the WEB front end in JSON format for visual interface display. The visual interface pops up all the standard document information in the doubtful status to the notification page in the form of text charts.

[0080] In addition, after receiving the modification completion information, all the standard information lists modified to the doubtful status can be immediately fed back to the management interface for the administrator to confirm again.

[0081] In this embodiment, when performing the revocation operation, it can be carried out in two steps. First, execute the fuzzy query statement, and then execute the status modification statement. First, all the standard documents that reference the target document (the standard document with the revocation status) are obtained through the fuzzy query statement, and then the status of all the standard documents that reference the target document is modified to doubtful through the status modification statement. It can also be carried out simultaneously, that is, in the target mapping file, a statement that can perform query and modification simultaneously is constructed, and the query and modification functions are implemented according to this query and modification statement. The generation methods of the query and modification statement and the status modification statement are similar to the generation method of the above-mentioned fuzzy query statement, and will not be elaborated here. Other detailed contents of the revocation operation refer to the technical solutions of S101-S105 above and will not be elaborated here.

[0082] In this embodiment, after executing the fuzzy query statement through the executor to perform a fuzzy query in the file database to obtain the first standard document information list, the data query method further includes: returning the first standard document information list to the front-end page for visual display. When the text content is a term, standard number, standard name, release time, implementation time, standard category, or standard status, only the first standard document information list is obtained. The standard document information that meets the screening conditions is displayed on the front-end page.

[0083] After the status of the standard file in the first standard file information list is modified to a questionable status and the second standard file information list is obtained, the data query method further includes: returning the second standard file information list to the front-end page for visual display. When the text content is a normative reference file (specifically the standard number of the target file), the first standard file information list and the second standard file information list can be obtained. The second standard file information list is displayed on the front-end page, which means that the standard file information in this abolished status and whose status is modified to a questionable status is referenced.

[0084] According to the above content, the overall process of the technical solution of the present invention is shown in Figure 4.

[0085] The technical solution of the present invention has the following advantages: Improve data consistency: define variable and method names through the camel case naming rule to ensure the consistency of the front-end and back-end data field names and reduce errors caused by inconsistent naming. The camel case naming rule conforms to the programming language specification and human language habits and is easy to read and maintain.

[0086] Enhance code readability and maintainability: use the @Param annotation to pass parameters, making SQL statements clearer and easier to read, especially when there are multiple parameters, the passing and naming of parameters can be flexibly controlled. By using parameters in the XML mapping file to perform logical judgment and construct dynamic SQL statements, the maintainability and extensibility of the code are improved.

[0087] Improve security: The MyBatis-plus framework query method has high security, which can effectively avoid SQL injection security vulnerabilities and improve platform security. By passing parameters instead of concatenating strings, the risk of SQL injection is further reduced.

[0088] Improve development efficiency: The MyBatis-plus framework simplifies the database operations of Java developers, reduces the amount of code, and improves development efficiency. Standardization staff can quickly find terms and normative reference files in standard texts, thereby improving work efficiency.

[0089] An automated process processing flow can be designed based on the technical solution of the present invention, and other standard files that reference the standard file (status is abolished) can be automatically retrieved through the platform, and the status of other standard files of the standard file (status is abolished) can be modified to "doubtful", reducing manual operations and improving accuracy. The function of associating normative reference files with standard status is realized. When a standard status is modified, the associated standard status can be automatically updated, thereby improving the consistency and accuracy of data processing.

[0090] Improve user experience: Through AJAX network request technology, seamless interaction between the front and back ends is achieved, which improves the fluency of user operations. The data pop-up notification page reminds the administrator to review and confirm, which improves the user experience.

[0091] Flexible filtering function: Through parameter passing and dynamic SQL construction, flexible filtering function is achieved, which can quickly retrieve data according to different filtering conditions. For example, by passing the "define" and "state" parameters, accurate filtering of terms and states can be achieved.

[0092] It should be noted that the contents not described in detail in the specification of the present invention belong to the common knowledge of those skilled in the art.

[0093] In the present embodiment, a data query device is also provided. A single device is used to implement the above-mentioned embodiment and optional implementation methods. The descriptions that have been made will not be repeated. As used below, the term "module" can be a combination of software and / or hardware that implements a predetermined function. Although the devices described in the following embodiments are preferably implemented in software, the implementation of hardware, or a combination of software and hardware, is also possible and conceivable.

[0094] FIG5 is a schematic diagram of the structure of a data query device according to an embodiment of the present invention.

[0095] The present invention provides a data query device, which is applied to a meteorological standardization information service platform. As shown in FIG5, the data query device includes: a first processing module 11, which is used to receive text content input to a front-end page of a meteorological standardization information service platform through a preset transmission type to obtain a target text. The target text is a text of a preset transmission type. The text content includes terms, standard numbers, standard names, normative reference documents, release time, implementation time, standard categories or standard status in standard documents.

[0096] A second processing module 12, which is used to determine whether the target text includes screening parameters.

[0097] A third processing module 13 is used to, when determining that the target text includes the screening parameter, pass the screening parameter to the target mapping file by annotating the screening parameter.

[0098] A fourth processing module 14 is used to construct a fuzzy query statement in the target mapping file according to the passed screening parameter.

[0099] A fifth processing module 15 is used to execute the fuzzy query statement through the executor to perform a fuzzy query in the file database to obtain a first standard file information list. The first standard file information list includes at least one standard file information, and the file database stores multiple standard file information, each standard file information corresponds to a standard file, and a single standard file information includes a serial number, a standard number, a standard name, a standard type, a standard status, a release time and an implementation time corresponding to a single standard file. The status includes an abolished status, a questionable status or an existing status.

[0100] Wherein, when the text content is a normative reference file, an abolition operation is performed, and the abolition operation is used to query the standard file that references the target file, and the target file is a standard file in an abolition state. When the abolition operation is performed, the first processing module is specifically used to receive the standard number of the target file input to the front-end page of the meteorological standardization information service platform through a preset transfer type.

[0101] The data query device also includes: a state modification module 16, and the state modification module 16 is used to modify the state of the standard file in the first standard file information list to a questionable state when performing the abolition operation, and obtain a second standard file information list. Wherein, when the abolition operation is performed, the standard file in the first standard file information list is the standard file that references the target file.

[0102] In an optional embodiment, the fourth processing module 14 is specifically used to determine whether the transmitted screening parameters are received in the target mapping file through logical judgment, and when it is determined that the transmitted screening parameters are received, construct a fuzzy query statement according to the transmitted screening parameters.

[0103] In an optional embodiment, when the preset transmission type is a string type, the first processing module 11 is specifically used to receive the text content input into the front-end page of the meteorological standardization information service platform through the string type to obtain the target string.

[0104] In an optional embodiment, when the preset transmission type is a string type, the second processing module 12 is specifically used to determine whether the target string meets the preset non-empty condition.

[0105] Wherein, the preset non-empty condition includes a non-empty and non-blank string, and when the target string meets the preset non-empty condition, it is determined that the target text includes the screening parameters. When the target string does not meet the preset non-empty condition, it is determined that the target text does not include the screening parameters.

[106] In an optional embodiment, when the target mapping file is an XML mapping file, the third processing module 13 is specifically used to specify the parameter name corresponding to the screening parameter by annotating the screening parameter. The parameter name corresponding to the screening parameter is passed to the XML mapping file.

[0107] In an optional embodiment, the data query device also includes: an input module.

[0108] The input module is used to receive the text content input to the front-end page of the meteorological standardization information service platform through a preset transfer type in the first processing module 11, and before obtaining the target text, the text content input to the front-end page of the meteorological standardization information service platform is passed to the background service according to the preset naming rules through a preset network request technology. The background service is used to receive the text content input to the front-end page of the meteorological standardization information service platform through a preset transfer type to obtain the target text.

[0109] In an optional embodiment, the data query device also includes: a visualization module.

[0110] The visualization module includes a first visualization unit and a second visualization unit.

[0111] The first visualization unit is used to return the first standard file information list to the front-end page for visual display after executing the fuzzy query statement through the executor to perform a fuzzy query in the file database to obtain the first standard file information list.

[0112] A first visualization unit is used to return the second standard file information list to the front-end page for visualization after modifying the state of the standard file in the first standard file information list to a questionable state and obtaining the second standard file information list.

[0113] The further functional description of each of the above modules and units is the same as that of the above corresponding embodiment, and will not be repeated here.

[0114] The data query device in this embodiment is presented in the form of a functional unit, where the unit refers to an ASIC (Application Specific Integrated Circuit) circuit, a processor and a memory that executes one or more software or fixed programs, and / or other devices that can provide the above functions.

[0115] The embodiment of the present invention also provides a computer device, which has the data query device shown in Figure 5 above.

[0116] Please refer to Figure 6, which is a schematic diagram of the hardware structure of the computer device in the embodiment of the present invention. As shown in Figure 6, the computer device includes: one or more processors 10, a memory 20, and an interface for connecting various components, including a high-speed interface and a low-speed interface. The various components communicate with each other using different buses and can be installed on a common motherboard or installed in other ways as needed. The processor can process instructions executed in the computer device, including instructions stored in or on the memory to display graphical information of the GUI on an external input / output device (such as a display device coupled to the interface). In an optional embodiment, if necessary, multiple processors and / or multiple buses can be used together with multiple memories and multiple memories. Similarly, multiple computer devices can be connected, and each device provides part of the necessary operations (for example, as a server array, a group of blade servers, or a multi-processor device). FIG6 takes a processor 10 as an example.

[0117] The processor 10 can be a central processing unit, a network processor, or a combination thereof. The processor 10 can further include a hardware chip. The hardware chip can be a dedicated integrated circuit, a programmable logic device, or a combination thereof. The programmable logic device can be a complex programmable logic device, a field programmable gate array, a general array logic, or any combination thereof.

[0118] The memory 20 stores instructions that can be executed by at least one processor 10, so that at least one processor 10 executes the method shown in the above embodiment.

[0119] The memory 20 can include a program storage area and a data storage area, wherein the program storage area can store the application required by the operating device and at least one function. The data storage area can store data created according to the use of the computer device, etc. In addition, the memory 20 can include a high-speed random access memory, and can also include a non-transient memory, such as at least one disk storage device, a flash memory device, or other non-transient solid-state storage device. In an optional embodiment, the memory 20 may include a memory remotely arranged relative to the processor 10, and these remote memories may be connected to the computer device via a network. Examples of the above-mentioned network include but are not limited to the Internet, an intranet, a local area network, a mobile communication network and a combination thereof.

[0120] The memory 20 may include a volatile memory, for example, a random access memory.The memory may also include a non-volatile memory, such as a flash memory, a hard disk or a solid state drive. The memory 20 may also include a combination of the above-mentioned types of memory.

[0121] The computer device also includes a communication interface 30 for the computer device to communicate with other devices or a communication network.

[0122] The embodiment of the present invention also provides a computer-readable storage medium, and the method according to the embodiment of the present invention described above may be implemented in hardware, firmware, or implemented as a computer code that can be recorded in a storage medium, or downloaded through a network and originally stored in a remote storage medium or a non-temporary machine-readable storage medium and will be stored in a local storage medium, so that the method described herein may be stored in such software processing on a storage medium using a general-purpose computer, a dedicated processor or programmable or dedicated hardware. Among them, the storage medium may be a magnetic disk, an optical disk, a read-only storage memory, a random access memory, a flash memory, a hard disk or a solid state drive, etc. Further, the storage medium may also include a combination of the above-mentioned types of memory. It can be understood that a computer, a processor, a microprocessor controller or programmable hardware includes a storage component that can store or receive software or computer code, and when the software or computer code is accessed and executed by a computer, a processor or hardware, the method shown in the above embodiment is implemented.

[0123] A part of the present invention can be applied as a computer program product, such as a computer program instruction. When it is executed by a computer, the method and / or technical solution according to the present invention can be called or provided through the operation of the computer. Those skilled in the art should understand that the existence of computer program instructions in computer-readable media includes but is not limited to source files, executable files, installation package files, etc., and accordingly, the way in which computer program instructions are executed by a computer includes but is not limited to: the computer directly executes the instruction, or the computer compiles the instruction and then executes the corresponding compiled program, or the computer reads and executes the instruction, or the computer reads and installs the instruction and then executes the corresponding installed program. Here, the computer-readable medium can be any available computer-readable storage medium or communication medium that can be accessed by the computer.

[0124] Although the embodiments of the present invention are described in conjunction with the accompanying drawings, those skilled in the art can make various modifications and variations without departing from the spirit and scope of the present invention, and such modifications and variations all fall within the scope defined by the appended claims.< / select> < / if> < / if> < / if>

Claims

1. A data query method, applied to a meteorological standardization information service platform, characterized in that: The method comprises: The text content input into the front-end page of the meteorological standardization information service platform is received through a preset transfer type to obtain a target text; the target text is a text of the preset transfer type; the text content includes terms, standard numbers, standard names, normative reference documents, release time, implementation time, standard categories or standard status in the standard document; Determining whether the target text includes a screening parameter; When it is determined that the target text includes the screening parameter, the screening parameter is transferred to the target mapping file by annotating the screening parameter; In the target mapping file, construct a fuzzy query statement according to the passed screening parameters; The fuzzy query statement is executed by an executor to perform a fuzzy query in a file database to obtain a first standard file information list; the first standard file information list includes at least one standard file information, the file database stores multiple standard file information, each standard file information corresponds to a standard file, and a single standard file information includes a serial number, a standard number, a standard name, a standard type, a standard status, a release time and an implementation time corresponding to a single standard file; the status includes an abolished status, a questionable status or an active status; Wherein, when the text content is a normative reference document, an abolition operation is performed, and the abolition operation is used to query a standard document that references a target document, and the target document is a standard document in an abolition state. When the abolition operation is performed, the text content input to the front-end page of the meteorological standardization information service platform is received through a preset transfer type to obtain the target text, including: receiving the standard number of the target document input to the front-end page of the meteorological standardization information service platform through a preset transfer type; When performing an abolition operation, after executing the fuzzy query statement through the executor to perform a fuzzy query in the file database to obtain a first standard file information list, the method also includes: modifying the status of the standard files in the first standard file information list to a questionable state to obtain a second standard file information list; when performing the abolition operation, the standard files in the first standard file information list are standard files that reference the target file.

2. The method according to claim 1, characterized in that: In the target mapping file, a fuzzy query statement is constructed according to the passed screening parameters, including: In the target mapping file, it is determined through logical judgment whether the transmitted screening parameters are received, and when it is determined that the transmitted screening parameters are received, a fuzzy query statement is constructed according to the transmitted screening parameters.

3. The method according to claim 1, characterized in that When the preset transfer type is a string type, the text content input to the front-end page of the meteorological standardization information service platform is received through the preset transfer type to obtain the target text, including: The text content input into the front-end page of the meteorological standardization information service platform is received through a character string type to obtain a target character string.

4. The method according to claim 3, characterized in that The step of determining whether the target text includes a screening parameter comprises: Determine whether the target character string satisfies a preset non-empty condition; Among them, the preset non-empty condition includes a non-empty and non-blank character string. When the target character string meets the preset non-empty condition, it is determined that the target text includes the screening parameter; when the target character string does not meet the preset non-empty condition, it is determined that the target text does not include the screening parameter.

5. The method according to claim 1, characterized in that When the target mapping file is an XML mapping file, the transferring of the screening parameter to the target mapping file by annotating the screening parameter comprises: By annotating the screening parameters, specifying the parameter names corresponding to the screening parameters; The parameter name corresponding to the screening parameter is passed to the XML mapping file.

6. The method according to claim 1, characterized in that Before receiving the text content input into the front-end page of the meteorological standardization information service platform through the preset transmission type and obtaining the target text, the method further includes: The text content input into the front-end page of the meteorological standardization information service platform is transmitted to the back-end service according to the preset naming rules through the preset network request technology; the back-end service is used to receive the text content input into the front-end page of the meteorological standardization information service platform through the preset transmission type to obtain the target text.

7. The method according to claim 1, characterized in that After the fuzzy query statement is executed by the executor to perform a fuzzy query in the file database to obtain a first standard file information list, the method further includes: Returning the first standard file information list to the front-end page for visual display; After modifying the status of the standard file in the first standard file information list to a questionable status to obtain a second standard file information list, the method further includes: The second standard file information list is returned to the front-end page for visual display.

8. A data query device, applied to a meteorological standardization information service platform, characterized in that: include: The first processing module is used to receive the text content input into the front-end page of the meteorological standardization information service platform through a preset transfer type to obtain a target text; the target text is the text of the preset transfer type; the text content includes terms, standard numbers, standard names, normative reference documents, release time, implementation time, standard categories or standard status in the standard document; A second processing module is used to determine whether the target text includes a screening parameter; A third processing module is used for transferring the screening parameter to a target mapping file by annotating the screening parameter when it is determined that the target text includes the screening parameter; A fourth processing module, configured to construct a fuzzy query statement in the target mapping file according to the transmitted screening parameters; a fifth processing module, configured to execute the fuzzy query statement through an executor to perform a fuzzy query in a file database to obtain a first standard file information list; the first standard file information list includes at least one standard file information, the file database stores multiple standard file information, each standard file information corresponds to a standard file, and a single standard file information includes a serial number, a standard number, a standard name, a standard type, a standard status, a release time and an implementation time corresponding to a single standard file; the status includes an abolished status, a questionable status or an active status; Wherein, when the text content is a normative reference file, an abolition operation is performed, and the abolition operation is used to query the standard file that references the target file, and the target file is a standard file in an abolition state. When the abolition operation is performed, the first processing module is specifically used to receive the standard number of the target file input to the front-end page of the meteorological standardization information service platform through a preset transfer type; The data query device also includes: a status modification module, which is used to modify the status of the standard files in the first standard file information list to a questionable state when performing an abolition operation, and obtain a second standard file information list; wherein, when performing an abolition operation, the standard files in the first standard file information list are standard files that reference the target files.

9. A computer device, characterized in that: include: A memory and a processor, wherein the memory and the processor are communicatively connected to each other, the memory stores computer instructions, and the processor executes the data query method according to any one of claims 1 to 7 by executing the computer instructions.

10. A computer-readable storage medium, characterized in that: The computer-readable storage medium stores computer instructions, and the computer instructions are used to enable a computer to execute the data query method according to any one of claims 1 to 7.

Images