Method and device for generating SQL statement based on visual page, server and medium

A statement and page technology, applied in the computer field, can solve problems such as high background knowledge requirements, inability to generate SQL statements, unfriendly visualization pages, etc., to achieve the effect of optimizing interactive experience and easy generation

Active Publication Date: 2019-07-09
四川省启迪数勘科技有限公司
View PDF12 Cites 18 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

This method requires relatively high background knowledge for users who write SQL statements. Ordinary users without professional knowledge background cannot generate the SQL statements they need.
In addition, there are currently a few methods for generating SQL statements based on the visual page, but the visual page is not friendly, and the user can only set it by clicking and selecting, and then generate SQL.

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 for generating SQL statement based on visual page, server and medium
  • Method and device for generating SQL statement based on visual page, server and medium
  • Method and device for generating SQL statement based on visual page, server and medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0034] Figure 1A It is a flowchart of a method for generating SQL statements based on a visual page provided by Embodiment 1 of the present invention. This embodiment is applicable to the situation of generating SQL statements, especially applicable to how to simplify the complex process of generating SQL statements, so that no database professional Users with knowledge background can also generate their own required SQL statement scenarios. In this embodiment, the visualization page is implemented based on the VUE framework, and the VUE framework is integrated with a desktop component library and a draggable component library. The method can be executed by the device for generating SQL statements based on the visualized page provided by the embodiment of the present invention. The device can be implemented in the form of hardware and / or software, and the device can be integrated in a server (the server is configured with a VUE framework system) . see Figure 1A , the method...

Embodiment 2

[0058] figure 2 It is a flowchart of a method for generating SQL statements based on a visual page provided by Embodiment 2 of the present invention. This embodiment is further optimized on the basis of Embodiment 1 above. see figure 2 , the method may specifically include:

[0059] S210, acquire the target data source selected by the user, and display the attribute information of the target data source in the first preset area of ​​the current page, wherein the attribute information includes fields in each database table in the target data source.

[0060] S220, in response to the second drag instruction, determine a second target field, and drag the second target field from the first preset area to the filter area in the second preset area.

[0061] In this embodiment, the second drag instruction is generated by the user dragging a field in the first preset area to a filter area in the second preset area. Correspondingly, the second target field is the field dragged by ...

Embodiment 3

[0077] image 3 It is a flow chart of a method for generating SQL statements based on a visual page provided by Embodiment 3 of the present invention. On the basis of the above embodiments, this embodiment further detects an SQL statement generation event, according to the first target field and The first operation configuration information of the first target field is generated and saved for explaining the SQL statement. see image 3 , the method may specifically include:

[0078] S310. Obtain the target data source selected by the user, and display the attribute information of the target data source in the first preset area of ​​the current page, wherein the attribute information includes fields in each database table in the target data source.

[0079] S320, in response to the first drag instruction, determine a first target field, and drag the first target field from the first preset area to the output field area in the second preset area of ​​the current page.

[0080]...

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 embodiment of the invention discloses a method and device for generating SQL statements based on a visual page, a server and a medium. A visual page is realized based on a VUE framework, and a desktop end component library and a draggable component library are integrated in the VUE framework. The method comprises the steps of acquiring a target data source selected by a user, displaying attribute information of the target data source in a first preset area of a current page, wherein the attribute information comprises fields in database tables in the target data source; responding to the dragging instruction, determining a target field, and dragging the target field from the first preset area to an output field area in a second preset area of the current page; obtaining operation configuration information of a user on the target field in the output field area; and if the SQL statement generation event is detected, generating and storing the SQL statement according to the targetfield and the operation configuration information of the target field. According to the technical scheme provided by the embodiment of the invention, a new thinking for simply and conveniently generating the SQL statements is provided for a user.

Description

technical field [0001] The embodiment of the present invention relates to the field of computer technology, and in particular to a method, device, server and storage medium for generating SQL statements based on a visual page. Background technique [0002] In recent years, with the development of computers and databases, SQL (Structure Query Language, Structured Query Language), a database-specific computer programming language, has been widely used and has become the most important and most commonly used relational database operating language. [0003] However, in the current method for generating SQL statements, the SQL statements are generated by writing in the back end by users with relevant professional knowledge such as databases. This method requires relatively high background knowledge for users who write SQL statements, and ordinary users without professional knowledge background cannot generate the SQL statements they need. In addition, there are currently a few m...

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/242G06F3/0486
CPCG06F3/0486
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