Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Method and device of generating SQL statement automatically

An automatic generation and statement technology, applied in special data processing applications, instruments, electrical and digital data processing, etc., can solve the problems of low development efficiency, manual writing, cumbersome steps, etc., to facilitate adjustment and optimization, reduce the amount of coding, The effect of improving work efficiency

Active Publication Date: 2018-11-20
艾普阳科技(深圳)有限公司
View PDF5 Cites 3 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] However, this method requires developers to manually write SQL statements in a standard format and bind the results to the data model after running. The steps are cumbersome and the development efficiency is low.

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
  • Method and device of generating SQL statement automatically
  • Method and device of generating SQL statement automatically
  • Method and device of generating SQL statement automatically

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0049] 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.

[0050] The embodiments of the present invention are mainly applied in the technical field of database programming, and mainly relate to reducing the workload of developers during the development process of relational data.

[0051] In the embodiment of the present invention, a method for automatically generating SQL statements by adding specific annotations on the data model is provided, which can realize database development and programming without directly us...

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 belongs to the technical field of software development, and discloses a method and a device of generating an SQL statement automatically. The method comprises the steps of determining adata model corresponding to a target data table in a database according to a preset programming interface instruction input by a user, wherein the data model comprises specific annotations, the specific annotations are used for determining a correspondence between the data model and the target data table and representing necessary parameters generating standard format of SQL statements; and then invoking a preset programming interface to produce specific labels in the data model into standard format of SQL statements by using a preset generation rule, wherein each part of the standard format of SQL statement is corresponding to the specific annotation. In the method, specific annotation can be produced into standard format of SQL statement automatically according to preset generation rulesby invoking the preset programming interface only, and developers do not need to program standard format of SQL statements manually, so that the programming amount is reduced, and the working efficiency is improved.

Description

technical field [0001] The invention relates to the technical field of software development, in particular to a method and a device for automatically generating SQL statements. Background technique [0002] In the existing database application development, the MVC architecture is usually used for development. Among them, MVC is composed of the first letters of the three words model (model), view (view), and controller (controller). It is a widely popular application architecture, and its purpose is to realize the functional division of programming systems. [0003] see figure 1 , figure 1 It is a schematic diagram of the MVC architecture relationship. The user interacts with the controller by inputting instructions and parameters, the controller passes the instructions and parameters input by the user to the data model, the data model executes business logic judgment, database access, selects different views according to the business logic, and the view feeds back the re...

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): G06F17/30
Inventor 詹奇
Owner 艾普阳科技(深圳)有限公司
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com