Method and system for realizing SQL query condition based on tree structure

Abstract

The invention discloses a method and a system for realizing an SQL query condition based on a tree structure. The method for realizing the SQL query condition comprises the steps of obtaining a hierarchical structure of data elements from a database on the premise of providing data element selection in a tree structure manner, and displaying and checking the data elements through an asynchronous condition tree method; and adding the checked data elements to a candidate list in a custom query condition, and generating a query condition in a custom condition tree structure. The custom condition tree structure performs statistics on all indexes in a scheme during scheme establishment, and determines that the definition of the SQL query condition can be finished through operations of dragging, extraction and the like in the scheme, so that the data elements are intuitively provided; condition editing and combination are performed, so that the SQL query condition is directly realized; and a user can completely autonomously perform SQL query condition editing according to own needs on the premise of not having database structure knowledge, so that the working equality and the working efficiency are improved.

Description

Technical field [0001] The invention belongs to the technical field of database query, and specifically relates to a method and system for realizing SQL query conditions based on a tree structure. Background technique [0002] With the rapid development of computer technology, business systems in various industries tend to be improved, and a large amount of business data has been accumulated to form a database with a certain scale. Such as tax system database. The standard data query language in the database, usually structured query language (Structured Query Language, SQL), is used to control and use the database through various SQL commands. [0003] For tax databases, tax bureau staff often need to edit SQL conditional statements to query taxpayers and their corresponding risks in the database. For personnel with a certain computer database foundation, editing a correct SQL statement requires a certain amount of thinking process; for front-line operators who are only familiar...

AI Technical Summary

Problems solved by technology

[0004] In the prior art, in order to use the SQL query statement in the corresponding database, the fixed conditions are written in the system, and the operators who are familiar with the database technology are specially responsible for modification and other management. When using it, the user can only call the written SQL statements that are dead in the system, but you cannot edit SQL statements according to your own needs

In this way, general business personnel cannot easily modify the query conditions according to their own needs, and modifying or generating a statement also requires a complicated process, resulting in low work efficiency

Although some systems currently provide the function of text input query statements, and the query conditions can be modified in the text state, these operations have high requirements for business personnel, and at the same time require technicians who write SQL codes to store a large amount of pointable text in the system. The SQL command of the language has a great dependence on the SQL statement in the database, and the flexibility of its query depends on the original database, and it cannot realize the complete autonomy of the user; and it is very likely to write all the SQL statements at once. Small, still requires a lot of post-editing

[0005] The Chinese patent titled "Method for Automatically Generating SQL Statements" with application number 201110391988.5 discloses a method that can automatically generate required SQL statements in real time based on generated function call instructions, conditional parameters, and table definition classes. However, in the In the above technology, general business personnel who are not familiar with database and SQL language still cannot operate conveniently

For example, in the actual application of the tax database, it is still difficult for the business operators of the tax bureau to directly use the tax database through this method

Images