Dynamic SQL query method

A query method and dynamic technology, which is applied in the fields of instruments, calculations, electrical digital data processing, etc., and can solve problems such as the inability to cope with the dynamic adjustment of SQL statements

Pending Publication Date: 2021-02-02
天元大数据信用管理有限公司
View PDF10 Cites 3 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, these mapped SQL information cannot be dynamically modified, so it cannot cope with the situation that some SQL statements need to be dynamically adjusted.

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 SQL query method

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0030] In order to enable those skilled in the art to better understand the technical solutions in the present invention, the technical solutions in the embodiments of the present invention will be clearly and completely described below in conjunction with the embodiments of the present invention. Apparently, the described embodiments are only some of the embodiments of the present invention, but not all of them. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts shall fall within the protection scope of the present invention.

[0031] The dynamic SQL query method includes the following steps:

[0032] The first step is to use the verification module to verify the input parameters;

[0033] The second step is to cache the dynamic SQL information that has been executed through the cache module;

[0034] The third step is to use the update module to update the configuration o...

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 particularly relates to a dynamic SQL query method. The dynamic SQL query method includes: verifying input parameters by a verification module; caching executed dynamic SQL information through a caching module; updating configuration of the dynamic SQL information by utilizing an updating module; and finally, utilizing an execution module to realize specific execution of the dynamicSQL information. According to the dynamic SQL query method, the problem that when Mybatis in a Java Web project executes SQL statements, xml files corresponding to the SQL statements need to be written in advance, and dynamic modification cannot be achieved is solved.

Description

technical field [0001] The invention relates to the technical field of Java Web, in particular to a dynamic SQL query method. Background technique [0002] Java Web is the sum of technologies that use Java technology to solve related web and Internet fields. Although Java's web frameworks are different, they basically follow a specific path: use Servlet or Filter to intercept requests, use MVC to design architecture, use conventions, XML or Annotation to implement configuration, and use Java's object-oriented features , oriented towards the abstract implementation of the request and response process, supports Jsp, Freemarker, Velocity and other views. [0003] The execution of SQL (Structured Query Language, Structured Query Language) statements in Java Web projects is often implemented through Spring and Mybatis. Among them, Spring is an open-source design-level framework, which solves the problem of loose coupling between the business logic layer and other layers, so it ...

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
IPC IPC(8): G06F16/2455G06F16/242G06F16/248G06F16/23
CPCG06F16/24553G06F16/2433G06F16/24552G06F16/248G06F16/23
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