CN116414833A - Report data query method, device, equipment and medium - Google Patents

Report data query method, device, equipment and medium Download PDF

Info

Publication number
CN116414833A
CN116414833A CN202310258487.2A CN202310258487A CN116414833A CN 116414833 A CN116414833 A CN 116414833A CN 202310258487 A CN202310258487 A CN 202310258487A CN 116414833 A CN116414833 A CN 116414833A
Authority
CN
China
Prior art keywords
report
query
queried
database
information
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CN202310258487.2A
Other languages
Chinese (zh)
Inventor
王浩楠
焦洋
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Agricultural Bank of China
Original Assignee
Agricultural Bank of China
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Agricultural Bank of China filed Critical Agricultural Bank of China
Priority to CN202310258487.2A priority Critical patent/CN116414833A/en
Publication of CN116414833A publication Critical patent/CN116414833A/en
Pending legal-status Critical Current

Links

Images

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/22—Indexing; Data structures therefor; Storage structures
    • G06F16/2282—Tablespace storage structures; Management thereof
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24—Querying
    • G06F16/245—Query processing
    • G06F16/2455—Query execution
    • Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
    • Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
    • Y02D10/00—Energy efficient computing, e.g. low power processors, power management or thermal management

Abstract

The embodiment of the invention discloses a report data query method, a report data query device, report data query equipment and report data query media. Wherein the method comprises the following steps: responding to a report query request, and determining a database to be queried and the type of the database to be queried according to the report query request; the report query request comprises report query reference information, and the report query reference information is determined based on preset query configuration information; determining target query information according to the report query reference information and the type of the database to be queried; and carrying out report data query in the database to be queried according to the target query information to obtain a target query result. According to the technical scheme, the report data can be quickly and accurately inquired according to the report inquiry request determined based on the preset inquiry configuration information, the development workload and redundancy of report inquiry codes are reduced, and the inquiry efficiency and the expandability of the inquiry function of the report data are improved.

Description

Report data query method, device, equipment and medium
Technical Field
The present invention relates to the field of data query technologies, and in particular, to a report data query method, apparatus, device, and medium.
Background
With the continuous deep and big data age of banking information construction, business personnel have more and more demands on report data query. In a traditional report query function implementation manner, a set of independent data processing programs are usually written for each report at a server side, and the code structures and logic processes are basically consistent. However, with the rapid increase of the number and types of reports, the conventional report query method can cause problems of large system development workload, repeated redundancy of codes and poor report query expandability. Therefore, how to reduce the development workload and redundancy of report query codes, thereby improving the query efficiency and the expandability of the query function of report data is one of the problems to be solved in the current data technology.
Disclosure of Invention
The invention provides a report data query method, a device, equipment and a medium, which can realize rapid and accurate query of report data according to a report query request determined based on preset query configuration information, reduce development workload and redundancy of report query codes, and are beneficial to improving query efficiency and query function expandability of the report data.
According to an aspect of the present invention, there is provided a report data query method, the method including:
responding to a report query request, and determining a database to be queried and the type of the database to be queried according to the report query request; the report query request comprises report query reference information, and the report query reference information is determined based on preset query configuration information;
determining target query information according to the report query reference information and the type of the database to be queried;
and carrying out report data query in the database to be queried according to the target query information to obtain a target query result.
According to another aspect of the present invention, there is provided a report data query apparatus, including:
the database information determining module is used for responding to a report query request and determining a database to be queried and the type of the database to be queried according to the report query request; the report query request comprises report query reference information, and the report query reference information is determined based on preset query configuration information;
the target query information determining module is used for determining target query information according to the report query reference information and the type of the database to be queried;
And the target query result determining module is used for carrying out report data query in the database to be queried according to the target query information to obtain a target query result.
According to another aspect of the present invention, there is provided an electronic apparatus including:
at least one processor; and
a memory communicatively coupled to the at least one processor; wherein, the liquid crystal display device comprises a liquid crystal display device,
the memory stores a computer program executable by the at least one processor to enable the at least one processor to perform the report data querying method according to any of the embodiments of the present invention.
According to another aspect of the present invention, there is provided a computer readable storage medium storing computer instructions for causing a processor to implement the report data query method according to any one of the embodiments of the present invention when executed.
According to the technical scheme, the database to be queried and the type of the database to be queried are determined according to the report query request in response to the report query request; the report query request comprises report query reference information, and the report query reference information is determined based on preset query configuration information; determining target query information according to the report query reference information and the type of the database to be queried; and carrying out report data query in the database to be queried according to the target query information to obtain a target query result. According to the technical scheme, the report data can be quickly and accurately inquired according to the report inquiry request determined based on the preset inquiry configuration information, the development workload and redundancy of report inquiry codes are reduced, and the inquiry efficiency and the expandability of the inquiry function of the report data are improved.
It should be understood that the description in this section is not intended to identify key or critical features of the embodiments of the invention or to delineate the scope of the invention. Other features of the present invention will become apparent from the description that follows.
Drawings
In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the drawings required for the description of the embodiments will be briefly described below, and it is apparent that the drawings in the following description are only some embodiments of the present invention, and other drawings may be obtained according to these drawings without inventive effort for a person skilled in the art.
FIG. 1 is a flowchart of a report data query method according to a first embodiment of the present invention;
FIG. 2 is a flowchart of a report data query method according to a second embodiment of the present invention;
fig. 3 is a schematic structural diagram of a report data query device according to a third embodiment of the present invention;
fig. 4 is a schematic structural diagram of an electronic device for implementing a report data query method according to an embodiment of the present invention.
Detailed Description
In order that those skilled in the art will better understand the present invention, a technical solution in the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings in which it is apparent that the described embodiments are only some embodiments of the present invention, not all embodiments. All other embodiments, which can be made by those skilled in the art based on the embodiments of the present invention without making any inventive effort, shall fall within the scope of the present invention.
It should be noted that the terms "first," "second," "target," and the like in the description and claims of the present invention and in the above figures are used for distinguishing between similar objects and not necessarily for describing a particular sequential or chronological order. It is to be understood that the data so used may be interchanged where appropriate such that the embodiments of the invention described herein may be implemented in sequences other than those illustrated or otherwise described herein. Furthermore, the terms "comprises," "comprising," and "having," and any variations thereof, are intended to cover a non-exclusive inclusion, such that a process, method, system, article, or apparatus that comprises a list of steps or elements is not necessarily limited to those steps or elements expressly listed but may include other steps or elements not expressly listed or inherent to such process, method, article, or apparatus.
Example 1
Fig. 1 is a flowchart of a report data query method according to a first embodiment of the present invention, where the method may be applied to a case of quickly and accurately querying report data, and the method may be performed by a report data query device, where the report data query device may be implemented in a form of hardware and/or software, and the report data query device may be configured in an electronic device having data processing capability. As shown in fig. 1, the method includes:
S110, responding to a report query request, and determining a database to be queried and the type of the database to be queried according to the report query request; the report query request comprises report query reference information, and the report query reference information is determined based on preset query configuration information.
The report query request may refer to an operation instruction that requests report query. Illustratively, the report query request may employ SQL (Structured Query Language ) statements. Specifically, the report query request includes report query reference information, and the report query reference information is determined based on preset query configuration information. The report query reference information may refer to basic parameter information for describing report query, and may be used as a reference basis for report query. By way of example, the report query reference information may include report names, query conditions, and data presentation information. For example, the query conditions may include the date of generation of report data, the institution to which the report data belongs, and the like. The data presentation information may be used to describe the manner in which report data is presented. By way of example, the data presentation information may include data paging information and data ordering information. The data paging information may include paging flag information (for describing whether paging presentation is required for data) and paging number information (for describing data in pages and several pieces of data per page) and the like. The data sort information may include sort flag information (for describing whether the data needs to be sorted) and sort field information (for describing which fields and in what order the data is sorted), etc.
The preset query configuration information may refer to preset configuration information related to report query. Specifically, the preset query configuration information may be preset at the server side by a background administrator and stored in a preset database at the server side. The preset database is used for storing preset query configuration information. For example, the preset query configuration information may include candidate report names, candidate query conditions, and candidate data presentation information. The candidate report names may refer to report names that the server side supports query, and may provide a queriable report name for the client side. The candidate query conditions may include a mandatory query condition and an optional query condition, and may provide a client with rich candidate query conditions. The candidate data presentation information may include candidate data paging information and candidate data ordering information. The candidate data paging information and the candidate data sorting information can respectively provide a plurality of selectable paging modes and sorting modes for the client. The database to be queried may refer to a database to be queried. It should be noted that, the database to be queried stores the related data of the report to be queried in advance, so that the report to be queried and the specific data of the report to be queried can be obtained by searching from the database to be queried. The report to be queried may refer to a report waiting to be queried. The type of the database to be queried may refer to a type of the database corresponding to the database to be queried.
In this embodiment, when the user needs to perform report data query, the report query reference information may be set through the client. The client can adopt a WEB application program based on a Spring Boot architecture. The Spring Boot is an open-source J2EE application framework, and the initial building and developing process is simplified on the basis of Spring. The WEB application is an application which can be accessed through a WEB browser, adopts a mode of combining a browser end and a server end, processes data through the server end and realizes data display through the browser end. Specifically, firstly, selecting a report name to be queried from candidate report names provided by a client, selecting or inputting query conditions from candidate query conditions provided by the client, simultaneously selecting or inputting desired data paging information and data sorting information from candidate data display information provided by the client, determining report query reference information according to the report name, the query conditions, the data paging information and the data sorting information set by a user, further generating a report query request comprising the query reference information, and sending the report query request to a server. After receiving the report query request sent by the client, the server needs to determine the corresponding database to be queried and the type of the database to be queried according to the report query request. The report query request comprises report query reference information, wherein the report query reference information comprises report names, query conditions and data display information.
In this embodiment, optionally, determining the database to be queried and the type of the database to be queried according to the report query request includes: determining the name of a report to be queried according to report query reference information in a report query request; determining a database to be queried and the type of the database to be queried according to the name of the report to be queried and a preset association relation; the preset association relation is used for describing the mapping relation among the report names, the report database and the report database types.
The report name to be queried may refer to the report name to be queried. The preset association relationship may be a preset mapping relationship for describing the report name, the report database and the report database type.
In this embodiment, after receiving a report query request sent by a client, a server may first determine a report name to be queried from report query reference information in the report query request, then determine a report database and a report database type that match the report name to be queried according to a preset association relationship, and determine the report database and the report database type as a database to be queried and a database type to be queried respectively.
By the arrangement, the database to be queried and the type of the database to be queried corresponding to the report query request can be rapidly and accurately determined based on the preset association relation.
S120, determining target query information according to the report query reference information and the type of the database to be queried.
The target query information can be used as a final basis for report query. The information can be spliced between the report query reference information and the database type to be queried based on a preset splicing mode, so that target query information required by report query is obtained. The splicing mode can comprise splicing sequence, splicing format and the like, and can be specifically set according to actual requirements.
S130, carrying out report data query in the database to be queried according to the target query information to obtain a target query result.
The target query result may refer to a report data query result obtained through query. In this embodiment, after determining the target query information, the report to be queried may be searched in the database to be queried according to the target query information, so as to obtain report data corresponding to the report to be queried, thereby obtaining the target query result. It should be noted that, if the report data query fails, the server side immediately returns a query error prompt message to the client side for reminding the user of the report data query failure. The query error prompt information may include a query error node (e.g., database to be queried) and a query error cause (e.g., no report to be queried exists in the database to be queried), etc. If the report data query is successful, the server side immediately sends the target query result to the client side after obtaining the target query result. After receiving the target query result from the server, the client can dynamically render the header style and the report data according to header information in the target query result, thereby realizing dynamic display of the report data.
According to the technical scheme, the database to be queried and the type of the database to be queried are determined according to the report query request in response to the report query request; the report query request comprises report query reference information, and the report query reference information is determined based on preset query configuration information; determining target query information according to the report query reference information and the type of the database to be queried; and carrying out report data query in the database to be queried according to the target query information to obtain a target query result. According to the technical scheme, the report data can be quickly and accurately inquired according to the report inquiry request determined based on the preset inquiry configuration information, the development workload and redundancy of report inquiry codes are reduced, and the inquiry efficiency and the expandability of the inquiry function of the report data are improved.
Example two
Fig. 2 is a flowchart of a report data query method according to a second embodiment of the present invention, where the report data query method is optimized based on the foregoing embodiment. The concrete optimization is as follows: before determining the database to be queried and the type of the database to be queried according to the report query request, the method further comprises the following steps: parameter verification is carried out on report query reference information in the report query request; correspondingly, determining the database to be queried and the type of the database to be queried according to the report query request comprises the following steps: if the parameter verification is successful, determining a database to be queried and the type of the database to be queried according to the report query reference information; if the parameter verification fails, returning a verification failure prompt message.
As shown in fig. 2, the method of this embodiment specifically includes the following steps:
s210, responding to the report query request, and carrying out parameter verification on report query reference information in the report query request.
It should be noted that when a user inputs report query reference information through a client, malicious injection of information may occur, which easily causes problems of database information leakage, report data leakage or server attack, and at this time, the safe operation of the server and the database will be seriously affected. For example, the WEB application program does not judge or filter the validity of the data input by the user, and an attacker can add an additional SQL sentence (namely SQL injection) to the end of the query sentence which is defined in advance in the WEB application program, and can realize illegal operation under the condition that an administrator does not know, so that the database server is deceived to execute unauthorized random query, and further corresponding report data information is obtained.
In this embodiment, in order to avoid a malicious information injection phenomenon that may occur when a user inputs report query reference information, after receiving a report query request sent by a client, a server may first perform parameter verification on the report query reference information in the report query request, and then take corresponding processing measures for the report query request according to a parameter verification result. The parameter verification may include a parameter format verification and/or a parameter validity verification, among others. The parameter format verification can be used for performing format verification on various parameter information in the report query reference information, so that whether the format of the report query reference information selected or input by a user meets the regulations is determined. The parameter validity check can be used for carrying out validity check on each item of parameter information in the report query reference information so as to determine whether the report query reference information selected or input by a user is valid or not. For example, if the name or the data sorting field information of the report to be queried in the report query reference information exceeds the query range supported by the database to be queried, the report query reference information can be determined to be invalid.
S220, if the parameter verification is successful, determining the database to be queried and the type of the database to be queried according to the report query reference information.
In this embodiment, if the parameter verification is determined to be successful, the server may further determine the database to be queried and the type of the database to be queried according to the report query reference information in the report query request. The determination manner of the database to be queried and the type of the database to be queried may be referred to the detailed description in S110, and will not be described herein.
And S230, if the parameter verification fails, returning verification failure prompt information.
In this embodiment, if it is determined that the parameter verification fails, the server directly returns verification failure prompt information to the client. Wherein, the liquid crystal display device comprises a liquid crystal display device, the verification failure prompt information may include a parameter verification failure reason, a correct manner of inputting parameters by the user, and the like. The user can timely know the parameter verification failure condition (such as the parameter verification failure reason) through the verification failure prompt information displayed by the client, and can modify the report query reference information according to the related guide information in the verification failure prompt information so as to quickly pass the parameter verification.
S240, determining target query information according to the report query reference information and the type of the database to be queried.
S250, carrying out report data query in the database to be queried according to the target query information to obtain a target query result.
The specific implementation of S240-S250 may be referred to in the detailed description of S120-S130, and will not be described herein. If the parameter verification is successful, executing S240-S250 after executing S220; if the parameter verification fails, the execution is finished after S230, that is, S240-S250 are not executed.
In this embodiment, optionally, performing parameter verification on report query reference information in the report query request includes: performing parameter format verification on report query reference information in the report query request; if the parameter format verification is successful, carrying out parameter validity verification on the report query reference information; and if the parameter validity check is successful, determining that the report query reference information check is successful.
In this embodiment, when parameter verification is performed on report query reference information in a report query request, parameter format verification may be performed on report query reference information in the report query request first. If the parameter format check fails, the parameter check failure can be directly determined; if the parameter format check is successful, the parameter validity check needs to be continuously carried out on the report query reference information. If the parameter validity check fails, the parameter check failure can be directly determined; if the parameter validity check is successful, the report query reference information check is determined to be successful.
By means of the setting, parameter format verification and parameter validity verification are sequentially conducted on the report query reference information in the report query request, and the parameter verification result can be rapidly and accurately determined.
In this embodiment, optionally, the report query reference information includes a report name to be queried, paging information of report data to be queried, and sorting information of report data to be queried; correspondingly, the parameter format verification for the report query reference information in the report query request comprises the following steps: performing first format verification on the name of the report to be queried based on first preset format requirements; if the first format check is successful, performing a second format check on the paging information of the report data to be queried based on a second preset format requirement; if the second format verification is successful, third format verification is carried out on the report data ordering information to be queried based on the second preset format requirement; if the third format check is successful, the parameter format check is determined to be successful.
The data paging information of the report to be queried may refer to data paging information corresponding to the report to be queried. The report data sorting information to be queried may refer to data sorting information corresponding to the report to be queried. The first preset format requirement may refer to a preset report name format requirement. The first format verification may refer to performing format verification on the report name to be queried in the report query reference information. The second preset format requirement may refer to a preset data paging information format requirement. The second format check may refer to performing format check on the paging information of the report data to be queried in the report query reference information. The second preset format requirement may refer to a preset data ordering information format requirement. The third format check may refer to performing format check on the report data sorting information to be queried in the report query reference information. It should be noted that the first preset format requirement, the second preset format requirement and the third preset format requirement may be set according to actual application requirements, which is not limited in this embodiment.
For example, the first preset format requirement may be set such that only arabic numerals, english letters, and underlines can be included in the report name. When the report name to be queried meets the first preset format requirement, namely the report name to be queried only comprises Arabic numerals, english letters and underlines, the first format verification can be determined to be successful, otherwise, the first format verification fails. The second default format requirement may be set to a boolean value for the page flag, and the number of pages and the number of pieces of data per page in the data page information are numerical values when the page flag is yes. And when the paging information of the report data to be queried meets the second preset format requirement, determining that the second format check is successful, otherwise, determining that the second format check is failed. The third preset format requirement may be set to a boolean value for the ordering flag, and when the ordering flag is "yes", there may be a plurality of ordering fields, each of which may only contain arabic numerals, english letters and underlining. And when the report data sorting information to be queried meets the requirement of a third preset format, determining that the third format check is successful, otherwise, determining that the third format check is failed. It should be noted that, only when the report query reference information meets all the requirements of the preset formats (the first requirement of the preset format, the second requirement of the preset format and the third requirement of the preset format) at the same time, the report query reference information is judged to be successfully checked.
By means of the setting, parameter format verification is conducted on the name of the report to be queried, paging information of the report data to be queried and sorting information of the report data to be queried in sequence in the report query reference information, and whether the parameter format verification is successful or not can be rapidly and accurately determined.
In this embodiment, optionally, performing parameter validity verification on the report query reference information includes: checking the validity of parameters of the report name to be queried and the report data sorting information to be queried in the report query reference information based on a preset database; the preset database stores preset query configuration information, and the preset query configuration information comprises report names and report data ordering information.
The preset database may be a preset database for storing preset query configuration information. The preset query configuration information comprises report names and report data ordering information.
In this embodiment, the parameter validity check may be performed on the report name to be queried and the report data ordering information to be queried in the report query reference information based on the preset query configuration information (report name and report data ordering information) in the preset database. Specifically, whether the name of the report to be queried and the ordering information of the report data to be queried exist in preset query configuration information or not can be respectively judged, if the name of the report to be queried and the ordering information of the report data to be queried exist at the same time, the parameter validity check is successful, otherwise, the parameter validity check fails.
By the arrangement, the parameter validity of the report name to be queried and the report data ordering information to be queried in the report query reference information can be rapidly and accurately checked based on the preset query configuration information in the preset database.
In this embodiment, optionally, performing parameter validity verification on the report name to be queried and the report data ordering information to be queried in the report query reference information based on a preset database includes: determining whether a report name to be queried exists in preset query configuration information; if the report name to be queried exists, determining whether report data ordering information to be queried exists in preset query configuration information; if the report data ordering information to be queried exists, the parameter validity check is determined to be successful.
In this embodiment, when checking the validity of parameters of the report name to be queried and the report data ordering information to be queried in the report query reference information, it may be determined whether the report name to be queried exists in the preset query configuration information. If the report name to be queried does not exist, the failure of parameter validity check can be directly determined; if the report name to be queried exists, whether the report data ordering information to be queried exists in the preset query configuration information is further determined. If the report data ordering information to be queried does not exist, determining that the parameter validity check fails; if the report data ordering information to be queried exists, the success of the parameter validity check can be determined.
By means of the arrangement, the parameter validity of the report name to be queried and the report data ordering information to be queried in the report query reference information can be checked rapidly and accurately based on the preset query configuration information in the preset database, and the parameter validity checking efficiency is further improved.
According to the technical scheme, before the database to be queried and the type of the database to be queried are determined according to the report query request, parameter verification is carried out on report query reference information in the report query request; if the parameter verification is successful, determining a database to be queried and the type of the database to be queried according to the report query reference information; if the parameter verification fails, returning a verification failure prompt message. According to the technical scheme, the report data can be quickly and accurately queried according to the report query request determined based on the preset query configuration information, the development workload and redundancy of report query codes are reduced, the query efficiency and the query function expandability of the report data are improved, and the problems of database information leakage, report data leakage or server attack can be effectively avoided through parameters when the client side is subjected to malicious information injection, so that the safe operation of the server and the database is ensured.
Example III
Fig. 3 is a schematic structural diagram of a report data query device according to a third embodiment of the present invention, where the report data query device may execute the report data query method according to any embodiment of the present invention, and has functional modules and beneficial effects corresponding to the execution method. As shown in fig. 3, the apparatus includes:
the database information determining module 310 is configured to determine a database to be queried and a type of the database to be queried according to a report query request in response to the report query request; the report query request comprises report query reference information, and the report query reference information is determined based on preset query configuration information;
the target query information determining module 320 is configured to determine target query information according to the report query reference information and the type of the database to be queried;
and the target query result determining module 330 is configured to perform report data query in the database to be queried according to the target query information to obtain a target query result.
Optionally, the database information determining module 310 is configured to:
determining the name of the report to be queried according to the report query reference information in the report query request;
determining a database to be queried and the type of the database to be queried according to the name of the report to be queried and a preset association relation; the preset association relation is used for describing the mapping relation among the report names, the report database and the report database types.
Optionally, the apparatus further includes:
the parameter checking module is used for performing parameter checking on report query reference information in the report query request before determining a database to be queried and the type of the database to be queried according to the report query request;
accordingly, the database information determining module 310 is configured to:
if the parameter verification is successful, determining a database to be queried and the type of the database to be queried according to the report query reference information;
if the parameter verification fails, returning a verification failure prompt message.
Optionally, the parameter verification module includes:
the parameter format verification unit is used for performing parameter format verification on the report query reference information in the report query request;
the parameter validity checking unit is used for checking the parameter validity of the report form query reference information if the parameter format check is successful;
and the parameter verification success determining unit is used for determining that the report query reference information verification is successful if the parameter validity verification is successful.
Optionally, the report query reference information includes a report name to be queried, paging information of report data to be queried, and sorting information of report data to be queried;
Correspondingly, the parameter format checking unit is configured to:
performing first format verification on the report name to be queried based on a first preset format requirement;
if the first format check is successful, performing a second format check on the paging information of the report data to be queried based on a second preset format requirement;
if the second format verification is successful, third format verification is carried out on the report data ordering information to be queried based on a second preset format requirement;
if the third format check is successful, the parameter format check is determined to be successful.
Optionally, the parameter validity checking unit includes:
the parameter validity checking subunit is used for checking the parameter validity of the report name to be queried and the report data ordering information to be queried in the report query reference information based on a preset database;
the preset database stores preset query configuration information, and the preset query configuration information comprises report names and report data ordering information.
Optionally, the parameter validity checking subunit is configured to:
determining whether the report name to be queried exists in the preset query configuration information;
if the report name to be queried exists, determining whether the report data ordering information to be queried exists in the preset query configuration information;
And if the report data ordering information to be queried exists, determining that the parameter validity check is successful.
The report data query device provided by the embodiment of the invention can execute the report data query method provided by any embodiment of the invention, and has the corresponding functional modules and beneficial effects of the execution method.
Example IV
Fig. 4 shows a schematic diagram of the structure of an electronic device 10 that may be used to implement an embodiment of the invention. Electronic devices are intended to represent various forms of digital computers, such as laptops, desktops, workstations, personal digital assistants, servers, blade servers, mainframes, and other appropriate computers. Electronic equipment may also represent various forms of mobile devices, such as personal digital processing, cellular telephones, smartphones, wearable devices (e.g., helmets, glasses, watches, etc.), and other similar computing devices. The components shown herein, their connections and relationships, and their functions, are meant to be exemplary only, and are not meant to limit implementations of the inventions described and/or claimed herein.
As shown in fig. 4, the electronic device 10 includes at least one processor 11, and a memory, such as a Read Only Memory (ROM) 12, a Random Access Memory (RAM) 13, etc., communicatively connected to the at least one processor 11, in which the memory stores a computer program executable by the at least one processor, and the processor 11 may perform various appropriate actions and processes according to the computer program stored in the Read Only Memory (ROM) 12 or the computer program loaded from the storage unit 18 into the Random Access Memory (RAM) 13. In the RAM 13, various programs and data required for the operation of the electronic device 10 may also be stored. The processor 11, the ROM 12 and the RAM 13 are connected to each other via a bus 14. An input/output (I/O) interface 15 is also connected to bus 14.
Various components in the electronic device 10 are connected to the I/O interface 15, including: an input unit 16 such as a keyboard, a mouse, etc.; an output unit 17 such as various types of displays, speakers, and the like; a storage unit 18 such as a magnetic disk, an optical disk, or the like; and a communication unit 19 such as a network card, modem, wireless communication transceiver, etc. The communication unit 19 allows the electronic device 10 to exchange information/data with other devices via a computer network, such as the internet, and/or various telecommunication networks.
The processor 11 may be a variety of general and/or special purpose processing components having processing and computing capabilities. Some examples of processor 11 include, but are not limited to, a Central Processing Unit (CPU), a Graphics Processing Unit (GPU), various specialized Artificial Intelligence (AI) computing chips, various processors running machine learning model algorithms, digital Signal Processors (DSPs), and any suitable processor, controller, microcontroller, etc. The processor 11 performs the various methods and processes described above, such as the report data query method.
In some embodiments, the report data querying method may be implemented as a computer program tangibly embodied on a computer-readable storage medium, such as the storage unit 18. In some embodiments, part or all of the computer program may be loaded and/or installed onto the electronic device 10 via the ROM 12 and/or the communication unit 19. When the computer program is loaded into RAM 13 and executed by processor 11, one or more of the steps of the report data querying method described above may be performed. Alternatively, in other embodiments, the processor 11 may be configured to perform the report data query method in any other suitable manner (e.g., by means of firmware).
Various implementations of the systems and techniques described here above may be implemented in digital electronic circuitry, integrated circuitry, field Programmable Gate Arrays (FPGAs), application Specific Integrated Circuits (ASICs), application Specific Standard Products (ASSPs), systems-on-chips (SOCs), load programmable logic devices (CPLDs), computer hardware, firmware, software, and/or combinations thereof. These various embodiments may include: implemented in one or more computer programs, the one or more computer programs may be executed and/or interpreted on a programmable system including at least one programmable processor, which may be a special purpose or general-purpose programmable processor, that may receive data and instructions from, and transmit data and instructions to, a storage system, at least one input device, and at least one output device.
A computer program for carrying out methods of the present invention may be written in any combination of one or more programming languages. These computer programs may be provided to a processor of a general purpose computer, special purpose computer, or other programmable data processing apparatus, such that the computer programs, when executed by the processor, cause the functions/acts specified in the flowchart and/or block diagram block or blocks to be implemented. The computer program may execute entirely on the machine, partly on the machine, as a stand-alone software package, partly on the machine and partly on a remote machine or entirely on the remote machine or server.
In the context of the present invention, a computer-readable storage medium may be a tangible medium that can contain, or store a computer program for use by or in connection with an instruction execution system, apparatus, or device. The computer readable storage medium may include, but is not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any suitable combination of the foregoing. Alternatively, the computer readable storage medium may be a machine readable signal medium. More specific examples of a machine-readable storage medium would include an electrical connection based on one or more wires, a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing.
To provide for interaction with a user, the systems and techniques described here can be implemented on an electronic device having: a display device (e.g., a CRT (cathode ray tube) or LCD (liquid crystal display) monitor) for displaying information to a user; and a keyboard and a pointing device (e.g., a mouse or a trackball) through which a user can provide input to the electronic device. Other kinds of devices may also be used to provide for interaction with a user; for example, feedback provided to the user may be any form of sensory feedback (e.g., visual feedback, auditory feedback, or tactile feedback); and input from the user may be received in any form, including acoustic input, speech input, or tactile input.
The systems and techniques described here can be implemented in a computing system that includes a background component (e.g., as a data server), or that includes a middleware component (e.g., an application server), or that includes a front-end component (e.g., a user computer having a graphical user interface or a web browser through which a user can interact with an implementation of the systems and techniques described here), or any combination of such background, middleware, or front-end components. The components of the system can be interconnected by any form or medium of digital data communication (e.g., a communication network). Examples of communication networks include: local Area Networks (LANs), wide Area Networks (WANs), blockchain networks, and the internet.
The computing system may include clients and servers. The client and server are typically remote from each other and typically interact through a communication network. The relationship of client and server arises by virtue of computer programs running on the respective computers and having a client-server relationship to each other. The server can be a cloud server, also called a cloud computing server or a cloud host, and is a host product in a cloud computing service system, so that the defects of high management difficulty and weak service expansibility in the traditional physical hosts and VPS service are overcome.
It should be appreciated that various forms of the flows shown above may be used to reorder, add, or delete steps. For example, the steps described in the present invention may be performed in parallel, sequentially, or in a different order, so long as the desired results of the technical solution of the present invention are achieved, and the present invention is not limited herein.
The above embodiments do not limit the scope of the present invention. It will be apparent to those skilled in the art that various modifications, combinations, sub-combinations and alternatives are possible, depending on design requirements and other factors. Any modifications, equivalent substitutions and improvements made within the spirit and principles of the present invention should be included in the scope of the present invention.

Claims (10)

1. A report data query method, the method comprising:
responding to a report query request, and determining a database to be queried and the type of the database to be queried according to the report query request; the report query request comprises report query reference information, and the report query reference information is determined based on preset query configuration information;
determining target query information according to the report query reference information and the type of the database to be queried;
And carrying out report data query in the database to be queried according to the target query information to obtain a target query result.
2. The method of claim 1, wherein determining the database to be queried and the type of database to be queried from the report query request comprises:
determining the name of the report to be queried according to the report query reference information in the report query request;
determining a database to be queried and the type of the database to be queried according to the name of the report to be queried and a preset association relation; the preset association relation is used for describing the mapping relation among the report names, the report database and the report database types.
3. The method of claim 1, wherein prior to determining the database to be queried and the type of database to be queried from the report query request, the method further comprises:
performing parameter verification on report query reference information in the report query request;
correspondingly, determining the database to be queried and the type of the database to be queried according to the report query request comprises the following steps:
if the parameter verification is successful, determining a database to be queried and the type of the database to be queried according to the report query reference information;
If the parameter verification fails, returning a verification failure prompt message.
4. The method of claim 3, wherein performing parameter verification on report query reference information in the report query request comprises:
performing parameter format verification on report query reference information in the report query request;
if the parameter format verification is successful, carrying out parameter validity verification on the report query reference information;
and if the parameter validity check is successful, determining that the report query reference information check is successful.
5. The method of claim 4, wherein the report query reference information includes a report name to be queried, report data paging information to be queried, and report data ordering information to be queried;
correspondingly, performing parameter format verification on the report query reference information in the report query request comprises the following steps:
performing first format verification on the report name to be queried based on a first preset format requirement;
if the first format check is successful, performing a second format check on the paging information of the report data to be queried based on a second preset format requirement;
if the second format verification is successful, third format verification is carried out on the report data ordering information to be queried based on a second preset format requirement;
If the third format check is successful, the parameter format check is determined to be successful.
6. The method according to claim 4 or 5, wherein performing parameter validity verification on the report query reference information comprises:
checking the validity of parameters of the report name to be queried and the report data ordering information to be queried in the report query reference information based on a preset database;
the preset database stores preset query configuration information, and the preset query configuration information comprises report names and report data ordering information.
7. The method of claim 6, wherein verifying the validity of parameters for the report name to be queried and the report data ordering information to be queried in the report query reference information based on a preset database, comprises:
determining whether the report name to be queried exists in the preset query configuration information;
if the report name to be queried exists, determining whether the report data ordering information to be queried exists in the preset query configuration information;
and if the report data ordering information to be queried exists, determining that the parameter validity check is successful.
8. A report data querying device, the device comprising:
The database information determining module is used for responding to a report query request and determining a database to be queried and the type of the database to be queried according to the report query request; the report query request comprises report query reference information, and the report query reference information is determined based on preset query configuration information;
the target query information determining module is used for determining target query information according to the report query reference information and the type of the database to be queried;
and the target query result determining module is used for carrying out report data query in the database to be queried according to the target query information to obtain a target query result.
9. An electronic device, the electronic device comprising:
at least one processor; and
a memory communicatively coupled to the at least one processor; wherein, the liquid crystal display device comprises a liquid crystal display device,
the memory stores a computer program executable by the at least one processor to enable the at least one processor to perform the report data querying method of any of claims 1-7.
10. A computer readable storage medium storing computer instructions for causing a processor to perform the report data querying method of any of claims 1-7.
CN202310258487.2A 2023-03-16 2023-03-16 Report data query method, device, equipment and medium Pending CN116414833A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202310258487.2A CN116414833A (en) 2023-03-16 2023-03-16 Report data query method, device, equipment and medium

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202310258487.2A CN116414833A (en) 2023-03-16 2023-03-16 Report data query method, device, equipment and medium

Publications (1)

Publication Number Publication Date
CN116414833A true CN116414833A (en) 2023-07-11

Family

ID=87052460

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202310258487.2A Pending CN116414833A (en) 2023-03-16 2023-03-16 Report data query method, device, equipment and medium

Country Status (1)

Country Link
CN (1) CN116414833A (en)

Similar Documents

Publication Publication Date Title
EP4099170B1 (en) Method and apparatus of auditing log, electronic device, and medium
CN111125496A (en) Price query method, device and system
CN113220710A (en) Data query method and device, electronic equipment and storage medium
CN111367934B (en) Data consistency checking method, device, server and medium
CN116611411A (en) Business system report generation method, device, equipment and storage medium
CN113157877A (en) Multi-semantic recognition method, device, equipment and medium
CN115600038A (en) Page rendering method, device, equipment and medium
CN114327802B (en) Method, apparatus, device and medium for block chain access to data outside chain
CN116414833A (en) Report data query method, device, equipment and medium
CN115328898A (en) Data processing method and device, electronic equipment and medium
CN114706774A (en) Interface test method, device, equipment and storage medium
CN116401410B (en) Method, device, storage medium and equipment for accessing map data to multi-scene graph database
CN114996557B (en) Service stability determination method, device, equipment and storage medium
US20230004989A1 (en) Customer recognition system
CN117971872A (en) Database query method, device, equipment and storage medium
CN116226867A (en) Script processing method, device, equipment and medium
CN116991825A (en) Database flashback method, device, equipment and storage medium
CN114428891A (en) Network resource processing method, device, system, equipment and storage medium
CN113821533A (en) Data query method, device, equipment and storage medium
CN116401269A (en) Data query method and device, electronic equipment and storage medium
CN116382640A (en) Method, device, equipment and storage medium for managing micro-service
CN116841982A (en) Database migration method, device, equipment, storage medium and program product
CN114860312A (en) Mobile terminal adaptation method, device, equipment and medium based on credit business
CN117670236A (en) Mobile-terminal-based to-be-handled flow approval method, device, equipment and medium
CN116932477A (en) Search matching method based on compressed storage, server and storage medium

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination