Dynamic query method and system

A dynamic query and dynamic technology, applied in special data processing applications, instruments, electrical and digital data processing, etc., can solve problems such as tediousness and inability to respond quickly to customer needs

Active Publication Date: 2020-06-09
智业软件股份有限公司
View PDF6 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

According to the previous practice, when the customer puts forward a new demand, it is necessary to configure the SQL statement first, then write the interface, and finally call the interface to return the data, which cannot quickly respond to the customer's demand, and the system needs to be re-released if the back-end code update is involved, which is more cumbersome

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
  • Dynamic query method and system
  • Dynamic query method and system
  • Dynamic query method and system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0085] The following will clearly and completely describe the technical solutions in the embodiments of the present invention with reference to the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are only some, not all, embodiments of the present invention. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts belong to the protection scope of the present invention.

[0086] see Figure 1-Figure 6 As shown, the present invention provides a kind of technical scheme:

[0087] The present invention provides a kind of dynamic inquiry method, and its method comprises the following steps:

[0088] S1. Dynamic SQL configuration. Based on OGNL expressions, MyBatis 3 uses dynamic SQL elements such as if, choose, trim, and foreach in Mapper.xml to write SQL statements containing logical judgments. During execution, according to the ...

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 relates to the technical field of software development, in particular to a dynamic query method and system. The method comprises the following steps that dynamic SQL configuration is carried out, wherein MyBatis 3 compiles SQL statements containing logic judgment by using if, coose, trim and form dynamic SQL elements in Mapper.xml on the basis of an OGNL expression; configuring a Groova dynamic script, realizing a dynamic script execution tool class based on the Groova, executing the dynamic script and returning a query result; wherein the engine is used for executing the SQL scripts; returning results. According to the dynamic query method and system, repeated interfaces are prevented from being written, the development flexibility is improved in a configuration mode, the development efficiency is improved, and the development time is shortened. Most requirements can be directly configured and processed on line by the system, and function development and system release operation are omitted.

Description

technical field [0001] The invention relates to the technical field of software development, in particular to a dynamic query method and system. Background technique [0002] In the small and medium platform system, there are many functions that require data query and Excel export, and the needs of customers are many and change rapidly. The previous approach was to store related query SQL statements in the database, and then write related interfaces to call the SQL statements configured in the database and return the execution results after execution. According to the previous practice, when a customer puts forward a new requirement, it is necessary to configure the SQL statement first, then write the interface, and finally call the interface to return the data, which cannot quickly respond to the customer's demand, and the system needs to be re-released if the back-end code update is involved, which is cumbersome. Contents of the invention [0003] The purpose of the pre...

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 Applications(China)
IPC IPC(8): G06F16/2453G06F16/242
CPCG06F16/2433G06F16/2453
Inventor 蔡志聪丘斌江智明
Owner 智业软件股份有限公司
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap