CN110109941B - Data query method, device, computer device and storage medium - Google Patents
Data query method, device, computer device and storage medium Download PDFInfo
- Publication number
- CN110109941B CN110109941B CN201910190297.5A CN201910190297A CN110109941B CN 110109941 B CN110109941 B CN 110109941B CN 201910190297 A CN201910190297 A CN 201910190297A CN 110109941 B CN110109941 B CN 110109941B
- Authority
- CN
- China
- Prior art keywords
- query
- data
- window
- user interface
- sql
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/242—Query formulation
- G06F16/2428—Query predicate definition using graphical user interfaces, including menus and forms
-
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Human Computer Interaction (AREA)
- Mathematical Physics (AREA)
- Computational Linguistics (AREA)
- User Interface Of Digital Computer (AREA)
Abstract
The invention provides a data query method, which comprises the steps of generating a user interface comprising a first query window, and displaying the user interface on a display screen, wherein the first query window is used for receiving a first SQL query request; adding a second query window on the user interface, wherein the second query window is used for receiving a second SQL query request; acquiring corresponding first query data from a specified first database according to the first SQL query request, and acquiring corresponding second query data from a specified second database according to the second SQL query request; displaying the acquired first query data and second query data on the user interface; and deriving the first query data and the second query data. The invention also provides a device, a computer device and a storage medium for realizing the data query method. The invention solves the technical problem that a plurality of SQL script queries are not supported.
Description
Technical Field
The present invention relates to the field of computer technologies, and in particular, to a data query method, a data query device, a computer device, and a storage medium.
Background
Databases are currently in common use by various industries. In one aspect, the database may store a large amount of information. On the other hand, the use of databases facilitates the management and control of information. The concept of simplicity and convenience in database query is also being appreciated by more and more people because various data stored in the database are more and more complex. Currently, in-industry SQL queries only support single SQL script execution and export, and do not meet increasingly complex data query requirements.
Disclosure of Invention
In view of the foregoing, there is a need for a data query method, apparatus, computer device and storage medium, which are used for solving the technical problem of not supporting multiple SQL script queries.
A first aspect of the present invention provides a data query method, the method comprising:
Generating a user interface, and displaying the user interface on a display screen of a computer device, wherein the user interface comprises a first query window, and the first query window is used for receiving a first SQL query request input by a user;
when the first input signal is received, a second query window is added to the user interface, and the second query window is used for receiving a second SQL query request input by a user;
when a second input signal is received, acquiring corresponding first query data from a specified first database according to the first SQL query request, and acquiring corresponding second query data from a specified second database according to the second SQL query request;
Displaying the acquired first query data and second query data on the user interface; and
When a third input signal is received, the first query data and the second query data are derived.
Preferably, the first query window and the second query window are text input boxes having a specified shape and size, respectively.
Preferably, the first query window is located at a first position of the user interface, and the second query window is located at a second position of the user interface, the second position being different from the first position and not overlapping the first position.
Preferably, the first query window and the second query window are respectively floating windows, and the method further comprises:
when a signal generated by a drag operation is received, moving the first query window from the first position to other positions of the user interface; and
And when receiving a signal generated by a drag operation, moving the second query window from the second position to other positions of the user interface.
Preferably, the method further comprises: deleting one or more second query windows according to the input operation of the user, including:
Recording a corresponding newly-added time for each second query window when each second query window is added to the user interface, wherein the newly-added time is the current system time of the computer device; and
And when a signal generated by clicking/pressing/touching a preset deleting button by a user is received, deleting the second query window which is added earliest or added latest according to the new time corresponding to each second query window.
Preferably, the displaying the acquired first query data and the second query data on the user interface includes:
The first query data is presented at a third location of the user interface and the second query data is presented at a fourth location of the user interface.
Wherein the third position is located at a position below the first query window, and the fourth position is located at a position below the second query window.
Preferably, the deriving the first query data and the second query data includes:
and importing the first query data and the second query data into a CSV or Excel table.
A second aspect of the present invention provides a computer apparatus comprising a processor and a memory, the memory for storing at least one instruction, the processor for executing the at least one instruction to implement the data querying method.
A third aspect of the invention provides a computer readable storage medium storing at least one instruction that when executed by a processor implements the data query method.
A fourth aspect of the present invention provides a data query apparatus, the apparatus comprising:
the generation module is used for generating a user interface and displaying the user interface on a display screen of the computer device, wherein the user interface comprises a first query window, and the first query window is used for receiving a first SQL query request input by a user;
the execution module is used for adding a second query window on the user interface when the first input signal is received, and the second query window is used for receiving a second SQL query request input by a user;
the execution module is further configured to obtain corresponding first query data from a specified first database according to the first SQL query request and obtain corresponding second query data from a specified second database according to the second SQL query request when receiving a second input signal;
the execution module is further configured to display the acquired first query data and second query data on the user interface; and
The execution module is further configured to derive the first query data and the second query data when a third input signal is received.
The data query method, the data query device, the computer device and the storage medium in the embodiment of the invention are characterized in that a user interface is generated and displayed on a display screen of the computer device, wherein the user interface comprises a first query window, and the first query window is used for receiving a first SQL query request input by a user; when the first input signal is received, a second query window is added to the user interface, and the second query window is used for receiving a second SQL query request input by a user; when a second input signal is received, acquiring corresponding first query data from a specified first database according to the first SQL query request, and acquiring corresponding second query data from a specified second database according to the second SQL query request; displaying the acquired first query data and second query data on the user interface; and when a third input signal is received, the first query data and the second query data are derived, so that the SQL query page supports a plurality of query windows after improvement and supports respectively deriving query results, and the user operation is facilitated.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings that are required to be used in the embodiments or the description of the prior art will be briefly described below, and it is obvious that the drawings in the following description are only embodiments of the present invention, and that other drawings can be obtained according to the provided drawings without inventive effort for a person skilled in the art.
Fig. 1 is a flowchart of a data query method according to an embodiment of the present invention.
Fig. 2 is a block diagram of a data query device according to a second embodiment of the present invention.
Fig. 3 is a schematic diagram of a computer device according to a third embodiment of the present invention.
The invention will be further described in the following detailed description in conjunction with the above-described figures.
Detailed Description
In order that the above-recited objects, features and advantages of the present invention will be more clearly understood, a more particular description of the invention will be rendered by reference to specific embodiments thereof which are illustrated in the appended drawings. It should be noted that, without conflict, the embodiments of the present invention and features in the embodiments may be combined with each other.
In the following description, numerous specific details are set forth in order to provide a thorough understanding of the present invention, and the described embodiments are merely some, rather than all, embodiments of the present invention. All other embodiments, which can be made by those skilled in the art based on the embodiments of the invention without making any inventive effort, are intended to be within the scope of the invention.
Unless defined otherwise, all technical and scientific terms used herein have the same meaning as commonly understood by one of ordinary skill in the art to which this invention belongs. The terminology used herein in the description of the invention is for the purpose of describing particular embodiments only and is not intended to be limiting of the invention.
Example 1
Fig. 1 is a flowchart of a data query method according to an embodiment of the present invention.
In this embodiment, the data query method may be applied to a computer device, and for a computer device that needs to perform data query, the function for data query provided by the method of the present invention may be directly integrated on the computer device, or may be run on the computer device in the form of a software development kit (Software Development Kit, SDK).
As shown in fig. 1, the data query method specifically includes the following steps, the order of the steps in the flowchart may be changed according to different needs, and some steps may be omitted.
Step S1, a computer device generates a user interface and displays the user interface on a display screen of the computer device. The user interface comprises a first query window, wherein the first query window is used for receiving a first SQL query request input by a user.
In this embodiment, the computer device may be a personal computer, a server, or other devices.
In one embodiment, the user interface is a WEB page.
In one embodiment, the first query window is a text entry box having a specified shape and size, located at a first location of the user interface. The first location may be any location on the user interface that facilitates a user to input the first SQL query request, and is preferably a central location of the user interface.
And S2, when the computer device receives the first input signal, adding a second query window on the user interface, wherein the second query window is used for receiving a second SQL query request input by a user.
In one embodiment, the second SQL query request may be the same as or different from the first SQL request.
In one embodiment, the first input signal may be a signal generated when the user clicks/presses/touches a preset first button. In one embodiment, the first button may be a virtual button pre-presented on the user interface or a physical key of the computer device. In other embodiments, the first input signal may also refer to a signal generated by simultaneously pressing two or more different physical keys of the computer device.
In the first embodiment, the second query window may be a text input box having the same shape and size as the first query window. In other embodiments, the second query window may have a different shape and size than the first query window.
In a first embodiment, the second query window is also displayed at the first location, overlaying the first query window. And taking the input of the user at the first position as the second SQL query request.
In a second embodiment, the second query window may be located at a second location of the user interface, the second location being different from the first location and not overlapping the first location.
In one embodiment, the first query window is a floating window, and when the computer device receives a signal generated by a drag operation, the computer device may change the position of the first query window on the user interface, that is, move the first query window from the first position to other positions on the user interface. In one embodiment, the second query window may also be a floating window, and when the computer device receives a signal generated by a drag operation, the position of the second query window on the user interface is changed, that is, the second query window is moved from the first position or the second position to other positions on the user interface.
In one embodiment, step S2 is repeatedly performed, and the computer device may newly add a plurality of the second query windows.
In one embodiment, the computer device may further delete one or more of the second query windows according to an input operation of the user.
In a first embodiment, deleting one or more of the second query windows according to an input operation of a user includes:
(a1) As each second query window is added to the user interface, a corresponding time (referred to as "new time" for ease of description) is recorded for each second query window. The new time may be a current system time of the computer device.
(A2) When a signal generated by clicking/pressing/touching a preset deleting button by a user is received, deleting the latest added second query window according to the new time corresponding to each second query window; or deleting the earliest added second query window.
Thus, each time the preset delete button is clicked/pressed/touched, the computer device deletes the earliest or latest added second query window in all second query windows currently.
In one embodiment, the latest increment may be defined as the latest increment time. For example, suppose that the user interface currently includes three second query windows, query windows "B1", "B2", "B3", respectively. The new time corresponding to the query window "B1" is earliest (e.g. 2018-07-02-09: 05 am), the new time corresponding to the query window "B3" is latest (e.g. 2018-07-02-09: 10 am), and the new time corresponding to the query window "B2" (e.g. 2018-07-02-09: 06 am) is between the query windows "B1" and "B3". Then when the user clicks/presses/touches the preset delete button for the first time, the window "B3" is deleted. When the user hits/presses/touches the preset delete button again, the window "B2" is deleted. When the user clicks/presses/touches the preset delete button again, the window "B1" is deleted. Of course, in other embodiments, when the user clicks/presses/touches the preset delete button, the second query window that is added earliest may be deleted. Therefore, every time the preset deleting button is clicked/pressed/touched, the earliest added second query window in all the second query windows at present can be deleted. In one embodiment, the earliest increase may be defined as the earliest new increase in time.
In a second embodiment, deleting one or more of the second query windows according to the input operation of the user includes:
(b1) And recording a corresponding newly added time for each second query window when each second query window is added to the user interface. The new time may be a current system time of the computer device.
(B2) When a designation signal (e.g., a double click signal) is received from a certain second query window of the one or more second query windows, the certain second query window is deleted.
In a third implementation, deleting one or more of the second query windows according to the input operation of the user includes:
(c1) And recording a corresponding newly added time for each second query window when each second query window is added to the user interface. The new time may be a current system time of the computer device.
(C2) And deleting a certain second query window when a signal generated by clicking/pressing/touching a preset button by a user is also received after a specified signal (such as a double click signal) is received from the certain second query window in the one or more second query windows.
And step S3, when the computer device receives a second input signal, the computer device acquires corresponding first query data from a specified first database according to the first SQL query request, and acquires corresponding second query data from a specified second database according to the second SQL query request.
In one embodiment, the second input signal may be a signal generated when the user clicks/presses/touches a preset second button. In one embodiment, the second button may be a virtual button pre-displayed on the user interface or a physical button of the computer device. In other embodiments, the second input signal may also refer to a signal generated by simultaneously pressing two or more different physical keys of the computer device.
In one embodiment, the first database and the second database may be the same database or different databases.
Step S4, the computer device displays the acquired first query data and the acquired second query data on the user interface.
In one embodiment, the presenting the acquired first query data and second query data at the user interface includes:
The first query data is presented at a third location of the user interface and the second query data is presented at a fourth location of the user interface.
In one embodiment, the third location is located at the periphery of the first query window, preferably at a location below the first query window. The fourth location is located at the periphery of the second query window, preferably at a location below the second query window.
And S5, when the computer device receives a third input signal, the first query data and the second query data are derived.
In one embodiment, the third input signal may be a signal generated when the user clicks/presses/touches a preset third button. In one embodiment, the third button may be a virtual button pre-displayed on the user interface or a physical button of the computer device. In other embodiments, the third input signal may also refer to a signal generated by pressing two or more different physical keys of the computer device at the same time.
In one embodiment, the deriving the first query data and the second query data comprises:
And importing the first query data and the second query data into a CSV or Excel table, namely outputting the first query data and the second query data in a CSV file or an Excel file.
Preferably, the first query data and the second query data are imported into different worksheets (sheets) of the same CSV file or Excel file.
For example, the first query data is imported into sheet1 of an Excel file, while the second query data is imported into sheet2 of the Excel file.
In summary, in the data query method according to the embodiment of the present invention, a user interface is generated, and the user interface is displayed on a display screen of a computer device, where the user interface includes a first query window, and the first query window is configured to receive a first SQL query request input by a user; when the first input signal is received, a second query window is added to the user interface, and the second query window is used for receiving a second SQL query request input by a user; when a second input signal is received, acquiring corresponding first query data from a specified first database according to the first SQL query request, and acquiring corresponding second query data from a specified second database according to the second SQL query request; displaying the acquired first query data and second query data on the user interface; and when a third input signal is received, the first query data and the second query data are derived, so that the SQL query page supports a plurality of query windows after improvement and supports respectively deriving query results, and the user operation is facilitated.
The foregoing fig. 1 describes the data query method of the present invention in detail, and the following describes, with reference to fig. 2 and fig. 3, a functional module of a software device implementing the data query method and a hardware device architecture implementing the data query method.
It should be understood that the embodiments described are for illustrative purposes only and are not limited to this configuration in the scope of the patent application.
Example two
Referring to fig. 2, a block diagram of a data query device according to a second embodiment of the present invention is shown.
In some embodiments, the data querying device 30 is running in a computer device. The data querying device 30 may comprise a plurality of functional modules consisting of program code segments. Program code for each program segment in the data querying device 30 may be stored in a memory of a computer device and executed by at least one processor of the computer device to implement (see fig. 1 for details) the data querying function.
In this embodiment, the data query device 30 may be divided into a plurality of functional modules according to the functions performed by the data query device. The functional module may include: a generation module 301 and an execution module 302. The module referred to in the present invention refers to a series of computer program segments capable of being executed by at least one processor and of performing a fixed function, stored in a memory. In the present embodiment, the functions of the respective modules will be described in detail in the following embodiments.
The generation module 301 generates a user interface that is displayed on the display screen of the computer device. The user interface comprises a first query window, wherein the first query window is used for receiving a first SQL query request input by a user.
In this embodiment, the computer device may be a personal computer, a server, or other devices.
In one embodiment, the user interface is a WEB page.
In one embodiment, the first query window is a text entry box having a specified shape and size, located at a first location of the user interface. The first location may be any location on the user interface that facilitates a user to input the first SQL query request, and is preferably a central location of the user interface.
And when the first input signal is received, adding a second query window on the user interface, wherein the second query window is used for receiving a second SQL query request input by a user.
In one embodiment, the second SQL query request may be the same as or different from the first SQL request.
In one embodiment, the first input signal may be a signal generated when the user clicks/presses/touches a preset first button. In one embodiment, the first button may be a virtual button pre-presented on the user interface or a physical key of the computer device. In other embodiments, the first input signal may also refer to a signal generated by simultaneously pressing two or more different physical keys of the computer device.
In the first embodiment, the second query window may be a text input box having the same shape and size as the first query window. In other embodiments, the second query window may have a different shape and size than the first query window.
In a first embodiment, the second query window is also displayed at the first location, overlaying the first query window. And taking the input of the user at the first position as the second SQL query request.
In a second embodiment, the second query window may be located at a second location of the user interface, the second location being different from the first location and not overlapping the first location.
In one embodiment, the first query window is a floating window, and the execution module 302 may change the position of the first query window on the user interface when receiving the signal generated by the drag operation, that is, move the first query window from the first position to other positions on the user interface. In one embodiment, the second query window may also be a floating window, and the execution module 302 may change the position of the second query window on the user interface when receiving the signal generated by the drag operation, that is, move the second query window from the first position or the second position to other positions on the user interface.
In one embodiment, the execution module 302 may add a plurality of the second query windows when receiving a plurality of the first input signals. I.e. a second query window is added each time a first input signal is received.
In one embodiment, the executing module 302 may further delete one or more of the second query windows according to an input operation of the user.
In a first embodiment, deleting one or more of the second query windows according to an input operation of a user includes:
(a1) As each second query window is added to the user interface, a corresponding time (referred to as "new time" for ease of description) is recorded for each second query window. The new time may be a current system time of the computer device.
(A2) When a signal generated by clicking/pressing/touching a preset deleting button by a user is received, deleting the latest added second query window according to the new time corresponding to each second query window; or deleting the earliest added second query window.
Thus, each time the preset delete button is clicked/pressed/touched, the computer device deletes the earliest or latest added second query window in all second query windows currently.
In one embodiment, the latest increment may be defined as the latest increment time. For example, suppose that the user interface currently includes three second query windows, query windows "B1", "B2", "B3", respectively. The new time corresponding to the query window "B1" is earliest (e.g. 2018-07-02-09: 05 am), the new time corresponding to the query window "B3" is latest (e.g. 2018-07-02-09: 10 am), and the new time corresponding to the query window "B2" (e.g. 2018-07-02-09: 06 am) is between the query windows "B1" and "B3". Then when the user clicks/presses/touches the preset delete button for the first time, the window "B3" is deleted. When the user hits/presses/touches the preset delete button again, the window "B2" is deleted. When the user clicks/presses/touches the preset delete button again, the window "B1" is deleted. Of course, in other embodiments, when the user clicks/presses/touches the preset delete button, the second query window that is added earliest may be deleted. Therefore, every time the preset deleting button is clicked/pressed/touched, the earliest added second query window in all the second query windows at present can be deleted. In one embodiment, the earliest increase may be defined as the earliest new increase in time.
In a second embodiment, deleting one or more of the second query windows according to the input operation of the user includes:
(b1) And recording a corresponding newly added time for each second query window when each second query window is added to the user interface. The new time may be a current system time of the computer device.
(B2) When a designation signal (e.g., a double click signal) is received from a certain second query window of the one or more second query windows, the certain second query window is deleted.
In a third implementation, deleting one or more of the second query windows according to the input operation of the user includes:
(c1) And recording a corresponding newly added time for each second query window when each second query window is added to the user interface. The new time may be a current system time of the computer device.
(C2) And deleting a certain second query window when a signal generated by clicking/pressing/touching a preset button by a user is also received after a specified signal (such as a double click signal) is received from the certain second query window in the one or more second query windows.
The execution module 302 obtains corresponding first query data from the specified first database according to the first SQL query request and obtains corresponding second query data from the specified second database according to the second SQL query request when receiving the second input signal.
In one embodiment, the second input signal may be a signal generated when the user clicks/presses/touches a preset second button. In one embodiment, the second button may be a virtual button pre-displayed on the user interface or a physical button of the computer device. In other embodiments, the second input signal may also refer to a signal generated by simultaneously pressing two or more different physical keys of the computer device.
In one embodiment, the first database and the second database may be the same database or different databases.
The execution module 302 presents the acquired first query data and the second query data on the user interface.
In one embodiment, the presenting the acquired first query data and second query data at the user interface includes:
The first query data is presented at a third location of the user interface and the second query data is presented at a fourth location of the user interface.
In one embodiment, the third location is located at the periphery of the first query window, preferably at a location below the first query window. The fourth location is located at the periphery of the second query window, preferably at a location below the second query window.
The execution module 302 derives the first query data and the second query data when receiving the third input signal.
In one embodiment, the third input signal may be a signal generated when the user clicks/presses/touches a preset third button. In one embodiment, the third button may be a virtual button pre-displayed on the user interface or a physical button of the computer device. In other embodiments, the third input signal may also refer to a signal generated by pressing two or more different physical keys of the computer device at the same time.
In one embodiment, the deriving the first query data and the second query data comprises:
And importing the first query data and the second query data into a CSV or Excel table, namely outputting the first query data and the second query data in a CSV file or an Excel file.
Preferably, the first query data and the second query data are imported into different worksheets (sheets) of the same CSV file or Excel file.
For example, the first query data is imported into sheet1 of an Excel file, while the second query data is imported into sheet2 of the Excel file.
In summary, in the data query device according to the embodiment of the present invention, a user interface is generated, and the user interface is displayed on a display screen of a computer device, where the user interface includes a first query window, and the first query window is configured to receive a first SQL query request input by a user; when the first input signal is received, a second query window is added to the user interface, and the second query window is used for receiving a second SQL query request input by a user; when a second input signal is received, acquiring corresponding first query data from a specified first database according to the first SQL query request, and acquiring corresponding second query data from a specified second database according to the second SQL query request; displaying the acquired first query data and second query data on the user interface; and when a third input signal is received, the first query data and the second query data are derived, so that the SQL query page supports a plurality of query windows after improvement and supports respectively deriving query results, and the user operation is facilitated.
Example III
Fig. 3 is a schematic structural diagram of a computer device according to a third embodiment of the present invention. In the preferred embodiment of the invention, the computer device 3 includes a memory 31, at least one processor 32, at least one communication bus 33. It will be appreciated by those skilled in the art that the configuration of the computer device shown in fig. 3 is not limiting of the embodiments of the present invention, and that either a bus-type configuration or a star-type configuration is possible, and that the computer device 3 may also include more or less other hardware or software than that shown, or a different arrangement of components.
In some embodiments, the computer device 3 includes a terminal capable of automatically performing numerical calculation and/or information processing according to a preset or stored instruction, and its hardware includes, but is not limited to, a microprocessor, an application specific integrated circuit, a programmable gate array, a digital processor, an embedded device, and the like.
It should be noted that the computer device 3 is only used as an example, and other electronic products that may be present in the present invention or may be present in the future are also included in the scope of the present invention by way of reference.
In some embodiments, the memory 31 is used to store program codes and various data, such as a data query device 30 installed in the computer device 3, and to enable high-speed, automatic access to programs or data during operation of the computer device 3. The Memory 31 includes Read-Only Memory (ROM), random-access Memory (Random Access Memory, RAM), programmable Read-Only Memory (Programmable Read-Only Memory, PROM), erasable programmable Read-Only Memory (Erasable Programmable Read-Only Memory, EPROM), one-time programmable Read-Only Memory (OTPROM), electrically erasable rewritable Read-Only Memory (EEPROM), compact disc Read-Only Memory (Compact Disc Read-Only Memory, CD-ROM) or other optical disc Memory, magnetic tape Memory, or any other medium that can be used for carrying or storing data, which is readable by a computer.
In some embodiments, the at least one processor 32 may be comprised of an integrated circuit, such as a single packaged integrated circuit, or may be comprised of multiple integrated circuits packaged with the same or different functionality, including one or more central processing units (Central Processing unit, CPU), microprocessors, digital processing chips, graphics processors, combinations of various control chips, and the like. The at least one processor 32 is a Control Unit (Control Unit) of the computer apparatus 3, connects the respective components of the entire computer apparatus 3 using various interfaces and lines, and executes various functions of the computer apparatus 3 and processes data, such as a function of performing data query, by running or executing programs or modules stored in the memory 31, and calling data stored in the memory 31.
In some embodiments, the at least one communication bus 33 is arranged to enable connected communication between the memory 31 and the at least one processor 32 or the like.
Although not shown, the computer device 3 may further include a power source (such as a battery) for powering the various components, and preferably the power source may be logically connected to the at least one processor 32 via a power management device, such that functions of managing charging, discharging, and power consumption are performed by the power management device. The power supply may also include one or more of any of a direct current or alternating current power supply, recharging device, power failure detection circuit, power converter or inverter, power status indicator, etc. The computer device 3 may further include various sensors, bluetooth modules, wi-Fi modules, etc., which will not be described in detail herein.
It should be understood that the embodiments described are for illustrative purposes only and are not limited to this configuration in the scope of the patent application.
The integrated units implemented in the form of software functional modules described above may be stored in a computer readable storage medium. The software functional modules described above are stored in a storage medium and include instructions for causing a computer device (which may be a server, a personal computer, etc.) or a processor (processor) to perform portions of the methods described in the various embodiments of the invention.
In a further embodiment, in connection with fig. 2, the at least one processor 32 may execute the operating means of the computer device 3 as well as various installed applications (such as the data query device 30), program code, etc., e.g., the various modules described above.
The memory 31 has program code stored therein, and the at least one processor 32 can invoke the program code stored in the memory 31 to perform related functions. For example, each of the modules depicted in fig. 2 is a program code stored in the memory 31 and executed by the at least one processor 32 to perform the functions of the respective module for data querying purposes.
In one embodiment of the present invention, the memory 31 stores one or more instructions, i.e., at least one instruction, that is executed by the at least one processor 32 for the purpose of data querying.
Specifically, the specific implementation method of the at least one instruction by the at least one processor 32 may refer to the description of the relevant steps in the corresponding embodiment of fig. 1, which is not repeated herein.
In the several embodiments provided by the present invention, it should be understood that the disclosed apparatus and method may be implemented in other manners. For example, the above-described apparatus embodiments are merely illustrative, and for example, the division of the modules is merely a logical function division, and there may be other manners of division when actually implemented.
The modules described as separate components may or may not be physically separate, and components shown as modules may or may not be physical units, may be located in one place, or may be distributed over multiple network units. Some or all of the modules may be selected according to actual needs to achieve the purpose of the solution of this embodiment.
In addition, each functional module in the embodiments of the present invention may be integrated in one processing unit, or each unit may exist alone physically, or two or more units may be integrated in one unit. The integrated units can be realized in a form of hardware or a form of hardware and a form of software functional modules.
It will be evident to those skilled in the art that the invention is not limited to the details of the foregoing illustrative embodiments, and that the present invention may be embodied in other specific forms without departing from the spirit or essential characteristics thereof. The present embodiments are, therefore, to be considered in all respects as illustrative and not restrictive, the scope of the invention being indicated by the appended claims rather than by the foregoing description, and all changes which come within the meaning and range of equivalency of the claims are therefore intended to be embraced therein. Any reference sign in a claim should not be construed as limiting the claim concerned. Furthermore, it will be obvious that the term "comprising" does not exclude other elements or that the singular does not exclude a plurality. A plurality of units or means recited in the apparatus claims can also be implemented by means of one unit or means in software or hardware. The terms first, second, etc. are used to denote a name, but not any particular order.
Finally, it should be noted that the above-mentioned embodiments are merely for illustrating the technical solution of the present invention and not for limiting the same, and although the present invention has been described in detail with reference to the preferred embodiments, it should be understood by those skilled in the art that modifications and equivalents may be made to the technical solution of the present invention without departing from the spirit and scope of the technical solution of the present invention.
Claims (9)
1. A method of querying data, the method comprising:
Generating a user interface, and displaying the user interface on a display screen of a computer device, wherein the user interface comprises a first query window, and the first query window is used for receiving a first SQL query request input by a user;
A plurality of second query windows are added, including: when a first input signal is received, adding a second query window at a second position of the user interface, and responding to a signal generated by a dragging operation to change the position of the second query window on the user interface, wherein each second query window is a floating window and is used for receiving a second SQL query request input by a user;
when a second input signal is received, acquiring corresponding first query data from a specified first database according to the first SQL query request, and acquiring corresponding second query data from a specified second database according to the second SQL query request;
Displaying the acquired first query data and second query data on the user interface;
when a third input signal is received, the first query data and the second query data are derived; and
Deleting one or more second query windows according to the input operation of the user, including: recording a corresponding newly-added time for each second query window when each second query window is added to the user interface, wherein the newly-added time is the current system time of the computer device; and deleting the second query window which is added earliest or added latest according to the new time corresponding to each second query window when a signal is received from one deletion button.
2. The data query method of claim 1, wherein the first query window and the second query window are text entry boxes having a specified shape and size, respectively.
3. The data query method of claim 1, wherein the first query window is located at a first location of the user interface, and the second location is different from the first location and does not overlap with the first location.
4. The data query method of claim 3, wherein the first query window is a floating window, the method further comprising:
When a signal generated by a drag operation is received, the first query window is moved from the first position to other positions of the user interface.
5. The data query method of claim 1, wherein the presenting the acquired first query data and second query data at the user interface comprises:
Displaying the first query data at a third location of the user interface and displaying the second query data at a fourth location of the user interface;
Wherein the third position is located at a position below the first query window, and the fourth position is located at a position below the second query window.
6. The data query method of claim 1, wherein the deriving the first query data and the second query data comprises:
and importing the first query data and the second query data into a CSV or Excel table.
7. A computer device comprising a processor and a memory, the memory for storing at least one instruction, the processor for executing the at least one instruction to implement the data query method of any of claims 1 to 6.
8. A computer readable storage medium storing at least one instruction which when executed by a processor implements a data query method as claimed in any one of claims 1 to 6.
9. A data querying device, the device comprising:
the generation module is used for generating a user interface and displaying the user interface on a display screen of the computer device, wherein the user interface comprises a first query window, and the first query window is used for receiving a first SQL query request input by a user;
the execution module is configured to add a plurality of second query windows, including: when a first input signal is received, adding a second query window at a second position of the user interface, and responding to a signal generated by a dragging operation to change the position of the second query window on the user interface, wherein each second query window is used for receiving a second SQL query request input by a user;
the execution module is further configured to obtain corresponding first query data from a specified first database according to the first SQL query request and obtain corresponding second query data from a specified second database according to the second SQL query request when receiving a second input signal;
the execution module is further configured to display the acquired first query data and second query data on the user interface; and
The execution module is further configured to derive the first query data and the second query data when receiving a third input signal; and deleting one or more second query windows according to the input operation of the user, including: recording a corresponding newly-added time for each second query window when each second query window is added to the user interface, wherein the newly-added time is the current system time of the computer device; and deleting the second query window which is added earliest or added latest according to the new time corresponding to each second query window when a signal is received from one deletion button.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910190297.5A CN110109941B (en) | 2019-03-13 | 2019-03-13 | Data query method, device, computer device and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910190297.5A CN110109941B (en) | 2019-03-13 | 2019-03-13 | Data query method, device, computer device and storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN110109941A CN110109941A (en) | 2019-08-09 |
| CN110109941B true CN110109941B (en) | 2024-08-23 |
Family
ID=67484329
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910190297.5A Active CN110109941B (en) | 2019-03-13 | 2019-03-13 | Data query method, device, computer device and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110109941B (en) |
Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105095341A (en) * | 2014-05-23 | 2015-11-25 | 三星电子株式会社 | Search methods and devices |
Family Cites Families (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7370040B1 (en) * | 2000-11-21 | 2008-05-06 | Microsoft Corporation | Searching with adaptively configurable user interface and extensible query language |
| CN1641639A (en) * | 2004-01-12 | 2005-07-20 | 英业达股份有限公司 | System and method for querying various databases |
| CN109150641B (en) * | 2017-06-15 | 2020-04-17 | 北京国双科技有限公司 | Data acquisition and query method, device, storage medium and processor |
| CN109299129A (en) * | 2018-09-05 | 2019-02-01 | 深圳壹账通智能科技有限公司 | Data query method, apparatus, computer equipment and the storage medium of natural language |
-
2019
- 2019-03-13 CN CN201910190297.5A patent/CN110109941B/en active Active
Patent Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105095341A (en) * | 2014-05-23 | 2015-11-25 | 三星电子株式会社 | Search methods and devices |
Also Published As
| Publication number | Publication date |
|---|---|
| CN110109941A (en) | 2019-08-09 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109086409B (en) | Microservice data processing method and device, electronic equipment and computer readable medium | |
| CN113282795B (en) | Data structure diagram generation and updating method and device, electronic equipment and storage medium | |
| CN111190882B (en) | Target template creation method and device, electronic equipment and storage medium | |
| CN108073688B (en) | Data migration method and device | |
| US11755293B2 (en) | Code execution and data processing pipeline | |
| CN109902255B (en) | Page mixed browsing record generation method, device, equipment and storage medium | |
| CN109582418B (en) | User behavior data collection method, device, computer device, and storage medium | |
| CN107357593A (en) | Source code file construction method, device, electric terminal and readable storage medium storing program for executing | |
| CN110427232A (en) | Page management method, device, computer equipment and storage medium | |
| CN111666328A (en) | Method and device for displaying visual chart in real time, computer equipment and storage medium | |
| CN110543306A (en) | interactive data visualization method, application system and storage medium | |
| WO2017143996A1 (en) | Data presentation method and device | |
| CN112486491A (en) | Page generation method and device, computer equipment and storage medium | |
| CN109947832A (en) | EXCEL tables of data is generated to method, apparatus, terminal and the storage medium of SQL file | |
| CN109460234B (en) | Application slimming method and device, terminal and storage medium | |
| CN114169303A (en) | Form editing method, device, equipment and medium based on vue.js | |
| CN111221817B (en) | Service information data storage method, device, computer equipment and storage medium | |
| CN108809770A (en) | A kind of resource monitoring method and system | |
| CN111651158A (en) | Form page generation method, device, terminal and storage medium | |
| CN113434585B (en) | Resource preservation method and equipment | |
| CN113515265B (en) | Site configuration method, device, equipment and computer readable storage medium | |
| CN110955718A (en) | Data visualization configuration method, server, system and medium | |
| CN110309062A (en) | Use case generation method, device, electronic device and storage medium | |
| CN110109941B (en) | Data query method, device, computer device and storage medium | |
| CN113724808A (en) | Medical survey questionnaire generation method and device, electronic equipment and storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |