Supercharge Your Innovation With Domain-Expert AI Agents!

A method and system for generating and executing SQL statements

A statement and execution result technology, applied in the field of computer databases, can solve the problem that SQL statements cannot be used across databases, and achieve the effect of expanding the scope of application

Inactive Publication Date: 2017-04-19
PEKING UNIV FOUNDER GRP CO LTD +1
View PDF3 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0007] In view of this, this application provides a method for generating SQL statements to solve the problem in the prior art that SQL statements cannot be used across databases

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
  • A method and system for generating and executing SQL statements
  • A method and system for generating and executing SQL statements
  • A method and system for generating and executing SQL statements

Examples

Experimental program
Comparison scheme
Effect test

example 1

[0059]

[0060] driver = "oraclejdbc.driver.OracleDriver" language = "java"

[0061] resultsize="1000">orcl;

[0062] The address of the database in this label is 192.168.18.1, the database type is oracle, the driver is oracle.jdbc.driver.OracleDriver, and the language used is java;

[0063] The XML_SQL statement further includes: a result tag, which is used to describe the document format of the execution result obtained by the specific database through executing the executable SQL statement. Specifically, this label is an optional label. If it is a non-query statement, such as a statement such as delete, insert, update, etc., it is not necessary to consider using this label. The technical staff of this application can set such a statement according to the actual situation Whether to return result information, such as how many pieces of information have been deleted, how many pieces of information have been inserted, and so on.

[0...

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 discloses a method and a system used for generating and executing a structured query language (SQL) statement. The method used for generating and executing the SQL statement is applied to an extensive makeup language (XML)_SQL analyzer. The XML_SQL analyzer is connected with at least two data bases in different types. The method used for generating and executing the SQL statement comprises the steps of receiving an XML_SQL statement input by a user, wherein the XML_SQL statement at least comprises an XML control label and the control label at least comprises at least one data base address, a data base type, a data base drive, and a data base language of a specific data base of the two data bases; judging whether the XML_SQL statement is correct or not; and generating the SQL statement which can be executed by the specific data base at least based on the control label when the XML_SQL statement is correct for being executed by the specific data base. According to the method used for generating and executing the SQL statement, the problem that the SQL statement cannot be adapted to a plurality of data bases in different types at the same time is solved.

Description

technical field [0001] This application relates to the field of computer databases, in particular to a method and system for generating and executing SQL statements. Background technique [0002] With the acceleration of informatization in recent years, the application of databases has become more and more common. In the current database system, different databases support the standard sql language differently, and different databases often make some extensions to the standard sql language for some commercial purposes or performance requirements. [0003] During the process of implementing the embodiment of the present application, the applicant found that the prior art has the following technical problems: [0004] 1. When a user writes a sql statement, it is difficult to guarantee its cross-database compatibility. For example, in the processing of time, the oracle database and the sqlserver database are very different. In particular, if there is a piece of information in...

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): G06F17/30
Inventor 毕继安
Owner PEKING UNIV FOUNDER GRP CO LTD
Features
  • R&D
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More

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

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