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

Database access statement generation method, device and equipment

A database and statement technology, applied in the database field, can solve problems such as low efficiency of SQL statement generation and low efficiency of database access

Active Publication Date: 2021-06-01
TENCENT TECH (SHENZHEN) CO LTD
View PDF4 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

At present, the writing of SQL statements is all done manually, and the efficiency of SQL statement generation is low, which leads to low efficiency of database access

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
  • Database access statement generation method, device and equipment
  • Database access statement generation method, device and equipment
  • Database access statement generation method, device and equipment

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

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

[0039] There are many types of database access statements, and SQL statements are a specific form of database access statements. For ease of understanding, this application uses generating SQL statements as an example for illustration. At present, the writing of SQL statements is all done manually, and the efficiency of SQL statement generation is low. This problem becomes particularly prominent when using batch SQL statements to access the database.

[0040] Batch SQL statements re...

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 present application provides a method for generating a database access statement. The method receives a database access template statement input by a user, which contains a variable value to be substituted, and responds to an input box generation instruction triggered by the user, and displays at least one set of variable value input boxes for the user. , and then receive the variable value input by the user in the variable value input box, respond to the statement generation instruction triggered by the user, and replace the variable value to be substituted in the database access template statement with the variable value to generate a database access standard statement, wherein, a set of variables The value input box corresponds to generate a database access standard statement. It can be seen that this method only needs the user to input database access template statements and variable values ​​to generate batches of database access standard statements, and the efficiency of statement writing and database access is also high. In addition, the present application also provides a database access statement generating device and equipment to ensure the practical application and realization of the above method.

Description

technical field [0001] The present application relates to the technical field of databases, more specifically, a database access statement generation method, device and equipment. Background technique [0002] SQL (Structured Query Language, Structured Query Language) statement is a computer language used to access databases. When you want to access the database, you need to write and execute corresponding SQL statements according to the access requirements. At present, the writing of SQL statements is all done manually, and the generation efficiency of SQL statements is low, which in turn leads to low efficiency of database access. Contents of the invention [0003] In view of this, the present application provides a method for generating database access statements, which is used to improve the efficiency of generating database access statements, and further improve the efficiency of database access. [0004] In a first aspect, the application provides a method for gene...

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): G06F8/30
CPCG06F8/31
Inventor 何瑞曾凡阮华史晓茸万志颖李家昌
Owner TENCENT TECH (SHENZHEN) CO LTD