Unlock instant, AI-driven research and patent intelligence for your innovation.

A data query method and system

A data query and query parameter technology, applied in the field of data processing, can solve problems such as low efficiency and difficult data query, and achieve the effect of convenient use and high query efficiency

Active Publication Date: 2017-10-10
DATANG SOFTWARE TECH
View PDF3 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0007] The invention provides a data query method and system to solve the problem of difficult and low efficiency in existing data query

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • A data query method and system
  • A data query method and system
  • A data query method and system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0040] refer to figure 1 , a flow chart of the data query method provided by Embodiment 1 of the present invention is given.

[0041] Step 101, receiving a data query request.

[0042] When the user performs data query, the query-related information can be displayed dynamically on the report running page. The user can enter the relevant information to be queried, such as which parameters to be queried, and the parameter value of the parameter to perform conditional query, and then click to query .

[0043]The report running page will generate a data query request based on the information input by the user. The data query request carries query parameters, and conditional queries can be performed through the query parameters. Then the report running page sends the data query request to the data query system, and the data query system obtains query parameters from the data query request.

[0044] Step 102, matching a preset SQL statement according to the query parameters.

[...

Embodiment 2

[0054] On the basis of the above embodiments, this embodiment further discusses the data query method in detail.

[0055] refer to figure 2 , a flow chart of the data query method provided by Embodiment 2 of the present invention is given.

[0056] Step 201, receiving a data query request, and obtaining query parameters from the query request.

[0057] In this embodiment, the above step 101 further includes step 202 and step 203 according to the query parameter matching preset SQL statement.

[0058] Step 202, obtaining at least one statement parameter from the query parameters.

[0059] Step 203, matching each of the statement parameters, and determining the SQL statement for querying the parameter name in the query parameters.

[0060] In the embodiment of the present invention, the query parameters include a parameter name, a parameter value, and a statement parameter, wherein the statement parameter is used to obtain an SQL statement for querying the parameter name and...

Embodiment 3

[0102] On the basis of the above embodiments, this embodiment also provides a data query system.

[0103] refer to Figure 4 , which shows the structure diagram of the data query system provided by the third embodiment of the present invention.

[0104] The data query system includes: a receiving module 401 , a matching module 402 , a replacement module 403 and a query module 404 .

[0105] Wherein, the receiving module 401 is used to receive a data query request, and the data query request carries a query parameter; the matching module 402 is used to match a preset SQL statement according to the query parameter; the replacement module 403 is used to adopt regular The expression replaces the SQL statement to generate an engine parameter for querying the query parameter; the query module 404 is configured to send the engine parameter to the report engine to obtain the query data result.

[0106] To sum up, match the preset SQL statement according to the query parameters in th...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The invention provides a method and system for data query to solve the problem of difficulty and low efficiency in existing data query. The method comprises the steps of receiving data query requirements, and enabling the data query requirements to carry query parameters; matching a preset structured query language (SQL) according to the query parameters; adopting a regular expressions to replace the structured query language (SQL), and generating an engine parameter for inquiring the query parameters; and sending the engine parameter to a report engine so as to obtain query data results. The engine parameter can be automatically generated for all query conditions of the requirements to perform query, and the method and system for data query are convenient to use and high in query efficiency.

Description

technical field [0001] The invention relates to the technical field of data processing, in particular to a data query method and system. Background technique [0002] JasperReport is a powerful and flexible report generation tool that can display rich page content and convert it into Portable Document Format (PDF), Hyper Text Mark-up Language (HTML) format, or Extensible Markup Language (XML) format. The library is completely written in Java and can be used to generate dynamic content in various Java applications, including Java2 Platform Enterprise Edition (J2EE), Internet (Web) applications. [0003] JasperReport is open source, and there is also a related open source project IReport, which is a graphical auxiliary tool, because JasperReport only provides usable class libraries but does not provide better development tools. The emergence of IReport solves this problem . Using them together will increase efficiency to a greater extent. [0004] JasperReport can be used ...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Patents(China)
IPC IPC(8): G06F17/30
CPCG06F16/2433
Inventor 赵守来赵雨佳
Owner DATANG SOFTWARE TECH