Method and system based on browser for visually dragging and querying data

Abstract

The invention discloses a method and system based on a browser for visually dragging and querying data. The method comprises the following steps: step one, an operational database and structure information of the same are extracted; step two, the database and the structure information of the same are obtained in the browser and rendered in WEB pages; step three, graphic components and canvases of query operation are rendered in the browser; step four, users arrange procedures of the query operation in graphical interfaces by dragging configuration; step five, a graphical query flow-process diagram is resolved for SQL statements; step six, the SQL query statements are carried out in the back-end; step seven, query results are output in the browser. The method and system based on the browser for visually dragging and querying the data has the advantages that querying the data in the WEB system is more flexible, and SQL query statement writing is simplified; the current situation that the database query is only carried out by inputting the SQL statement is changed; the use threshold of the system can be lowered, and the query process is arranged in a graphical mode; then the description of establishing the query process becomes clearer and more intuitive, and the learning threshold can be lowered.

Description

technical field [0001] The present invention relates to a method and system for querying data, in particular to a method and system for querying data by visual dragging and dropping based on a browser. Background technique [0002] Existing browser-based database query methods or systems usually use preset fixed data query methods for data query, but this method is not very flexible, and a large number of data query methods need to be defined during system development; in order to To make database query more flexible, usually standard or optimized SQL expressions can also be used in the system, allowing users to input self-written SQL statements to query data, and then send them to the system backend to execute queries, but using this method requires users to be very familiar with SQL statements and their syntax, users without SQL and database foundation may not be able to use this function. Contents of the invention [0003] The technical problem to be solved by the pres...

AI Technical Summary

Problems solved by technology

[0002] Existing browser-based database query methods or systems usually use preset fixed data query methods for data query, but this method is not very flexible, and a large number of data query methods need to be defined during system development; in order to To make database query more flexible, usually standard or optimized SQL expressions can also be used in the system, allowing users to input self-written SQL statements to query data, and then send them to the system backend to execute queries, but using this method requires users to be very familiar with SQL statements and their syntax, users without SQL and database foundation may not be able to use this function

Images