Online verification method and verification system for SQL query of multiple database types
A verification method and database technology, applied in database management systems, structured data retrieval, electronic digital data processing, etc., can solve the problem of strong data dependence, strong tool dependence, and the inability to intuitively obtain database query results on the front-end page, etc. problems, to achieve the effect of improving query efficiency, reducing labor costs, avoiding dependencies and restrictions on database types
Active Publication Date: 2021-02-26
BEIJING JINGDONG SHANGKE INFORMATION TECH CO LTD +1
View PDF8 Cites 0 Cited by
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
[0004] In addition, basically all existing database queries are completed in the offline test environment. In the online environment, the query results of the database cannot be obtained intuitively through the front-end page, and the database still needs to be directly operated in the background.
Therefore, the existing database query does not support online verification, it can only be done offline or in a test environment, and it is difficult to use it uniformly with other web services
[0005] Therefore, the traditional database query has the following disadvantages: strong tool dependence; query between different databases needs to be processed separately; cumbersome storage and strong dependence on data; online verification cannot be performed; poor interactivity
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 moreImage
Smart Image Click on the blue labels to locate them in the text.
Smart ImageViewing Examples
Examples
Experimental program
Comparison scheme
Effect test
Embodiment Construction
[0020] The present invention will be described in further detail below in conjunction with the accompanying drawings and specific embodiments, but not as a limitation of the present invention.
[0021] like figure 1 as shown, figure 1 A system architecture diagram for performing SQL query and verification is shown. exist figure 1 shows a 3-layer architecture, including Web service layer, data interface layer and database driver layer, where the Web service layer is used to provide standard HTTP requests; the data interface layer is used to issue query calls and unify the returned results Packaging processing, where, initiating a call refers to a direct call, that is, calling the initialized database connection object to query, and data processing is for normally executed SQL queries, packaging the query results and returning the results; each database The driver layer is used to introduce third-party database drivers, execute SQL statements to use third-party databases, for...
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
Login to View More Abstract
The invention discloses an online checking method and system for SQL query of multiple database types. The checking method comprises the following steps of initiating an HTTP calling request; screening to select a connection database according to the HTTP calling request, wherein the HTTP calling request comprises a database type, database connection information and an SQL statement; carrying outSQL query on the connected database by utilizing a corresponding database and returning a query result; and sending an HTTP response, and checking the query result. According to the method and the system, the manual cost of database query can be reduced, the connection does not need to be reestablished for each query, the convenience is provided for direct query of the online system, and meanwhile, the dependence of a tool and the limitation of the database type are avoided.
Description
technical field [0001] The invention relates to the field of database query, in particular to an online verification method and a verification system for multi-database type SQL (Structured Query Language: Structured Query Language) query. Background technique [0002] In traditional software testing, it is necessary to check the results by querying the database. The current database query uses a query tool to connect to the database through a third-party client, and then query the required results according to the database SQL query statement. For different database queries, different third-party tools are used to separately perform query processing for each type of database. [0003] In this case, database query needs to manually write a large number of database query statements, and may need to switch between different databases. [0004] In addition, basically all existing database queries are completed in the offline test environment. In the online environment, the qu...
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
Login to View More Patent Type & Authority Patents(China)
IPC IPC(8): G06F16/245G06F16/25
Inventor 刘爱慧
Owner BEIJING JINGDONG SHANGKE INFORMATION TECH CO LTD