SQL executing method and device based on multiple database types

Abstract

The invention provides an SQL executing method and device based on multiple database types. The method comprises the steps of calling a global function or a global method, and inputting the current SQL statement according with the grammar of a front universal database to the global function or global method through a first parameter; inputting the current target database type to the global function or global method through a second parameter; executing the global function or global method, and obtaining the SQL statement according with the grammar of the current target database type output by the global function or global method. By the adoption of the SQL executing method and device based on multiple database types, encoding efficiency can be improved.

Description

technical field [0001] The present invention relates to the field of computer technology, in particular to an SQL execution method and device based on multiple database types. Background technique [0002] In the software project of informatization application, it is essential to interact with the database, and there are various types of database management systems. Customers generally choose one of these database systems when using them. Standard application software products generally support multi-database applications, which requires that multi-database applications should be considered when designing and developing software. However, different The grammatical structure of the database system is different, which causes developers to write a large number of grammatical conversions of different database systems when coding. For example: if the software product to be developed supports three mainstream databases, one SQL statement needs to be executed according to three di...

AI Technical Summary

Problems solved by technology

Customers generally choose one of these database systems when using them. Standard application software products generally support multi-database applications, which requires that multi-database applications should be considered when designing and developing software. However, different The grammatical structure of the database system is different, which causes developers to write a large number of different database system grammatical conversions when coding

For example: if the software product to be developed supports three mainstream databases, one SQL statement needs to be executed according to three different grammars, and three SQL statements with different grammars must be written respectively. This work includes a lot of repetitive work, thus Coding efficiency of developers that has a great impact on the program

Images