CN108536342B - Data query method and device - Google Patents

Data query method and device Download PDF

Info

Publication number
CN108536342B
CN108536342B CN201710121740.4A CN201710121740A CN108536342B CN 108536342 B CN108536342 B CN 108536342B CN 201710121740 A CN201710121740 A CN 201710121740A CN 108536342 B CN108536342 B CN 108536342B
Authority
CN
China
Prior art keywords
operation object
target
query
data
event
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
Application number
CN201710121740.4A
Other languages
Chinese (zh)
Other versions
CN108536342A (en
Inventor
史晓茸
阮华
曾凡
万志颖
何瑞
李家昌
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Tencent Technology Shenzhen Co Ltd
Original Assignee
Tencent Technology Shenzhen Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Tencent Technology Shenzhen Co Ltd filed Critical Tencent Technology Shenzhen Co Ltd
Priority to CN201710121740.4A priority Critical patent/CN108536342B/en
Publication of CN108536342A publication Critical patent/CN108536342A/en
Application granted granted Critical
Publication of CN108536342B publication Critical patent/CN108536342B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F3/00Input arrangements for transferring data to be processed into a form capable of being handled by the computer; Output arrangements for transferring data from processing unit to output unit, e.g. interface arrangements
    • G06F3/01Input arrangements or combined input and output arrangements for interaction between user and computer
    • G06F3/048Interaction techniques based on graphical user interfaces [GUI]
    • G06F3/0481Interaction techniques based on graphical user interfaces [GUI] based on specific properties of the displayed interaction object or a metaphor-based environment, e.g. interaction with desktop elements like windows or icons, or assisted by a cursor's changing behaviour or appearance

Landscapes

  • Engineering & Computer Science (AREA)
  • General Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Human Computer Interaction (AREA)
  • Physics & Mathematics (AREA)
  • General Physics & Mathematics (AREA)
  • User Interface Of Digital Computer (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The embodiment of the invention discloses a data query method and a data query device. Wherein, the method comprises the following steps: the data query device monitors the specified operation event on the target interface in real time, determines an operation object of the specified operation event, and determines a target element based on the operation object, wherein the operation object is any element displayed on the target interface, so that a query instruction based on SQL is generated according to the operation object and the target element, and finally, data corresponding to the target element and the operation object are queried based on the query instruction. Through the embodiment of the invention, the data query device can automatically generate the query SQL based on the user operation to query the data in the database, thereby reducing the artificial workload during data query and improving the query efficiency.

Description

Data query method and device
Technical Field
The invention relates to the technical field of internet, in particular to a data query method and device.
Background
With the development of the internet, the data volume in each business system becomes huge, especially in the telecommunication and internet industries. In the prior art, query is generally performed through Structured Query Language (SQL) in the face of the requirement of querying the large data, but SQL can only be written manually at present, and if the amount of data to be queried is large, the workload is increased, and the Query efficiency is also reduced.
Disclosure of Invention
The embodiment of the invention discloses a data query method and a data query device, which can reduce the workload of data query and improve the query efficiency.
In a first aspect, an embodiment of the present invention discloses a data query method, which may include:
monitoring a specified operation event on a target interface;
determining an operation object of the specified operation event, and determining a target element based on the operation object, wherein the operation object is any element displayed on the target interface;
generating a query instruction based on SQL according to the operation object and the target element;
and querying data corresponding to the target element and the operation object based on the query instruction.
In a second aspect, an embodiment of the present invention discloses a data query apparatus, which may include:
the monitoring module is used for monitoring a specified operation event on a target interface;
the determining module is used for determining an operation object of the specified operation event and determining a target element based on the operation object, wherein the operation object is any element displayed on the target interface;
the generating module is used for generating a query instruction based on SQL according to the operation object and the target element;
and the query module is used for querying data corresponding to the target element and the operation object based on the query instruction.
The embodiment of the invention has the following beneficial effects:
in the embodiment of the invention, the data query device monitors the specified operation event on the target interface in real time, determines the operation object of the specified operation event, and determines the target element based on the operation object, wherein the operation object is any element displayed on the target interface, so that a query instruction based on SQL is generated according to the operation object and the target element, and finally, data corresponding to the target element and the operation object is queried based on the query instruction. By the embodiment of the invention, the data query device can automatically generate the query SQL based on user operation to query the data in the database, thereby reducing the artificial workload during data query and improving the query efficiency.
Drawings
In order to more clearly illustrate the technical solutions in the embodiments of the present invention, the drawings needed to be used in the description of the embodiments will be briefly introduced below, and it is obvious that the drawings in the following description are only some embodiments of the present invention, and it is obvious for those skilled in the art to obtain other drawings based on these drawings without creative efforts.
FIG. 1 is a schematic flowchart of a data query method according to an embodiment of the present invention;
FIG. 2 is an interface schematic of a target interface disclosed in an embodiment of the present invention;
FIG. 3 is a flow chart illustrating another data query method according to an embodiment of the present invention;
FIG. 4 is a schematic structural diagram of a data query device according to an embodiment of the present invention;
fig. 5 is a schematic structural diagram of a data query device according to an embodiment of the present invention.
Detailed Description
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be obtained by a person skilled in the art without inventive step based on the embodiments of the present invention, are within the scope of protection of the present invention.
The embodiment of the invention discloses a data query method and a data query device, which can reduce the workload of data query and improve the query efficiency. The following are detailed below.
Referring to fig. 1, fig. 1 is a schematic flow chart of a data query method according to an embodiment of the present invention. The method described in the embodiment of the invention can comprise the following steps:
101. the data query device listens for a specified operational event on the target interface.
In the embodiment of the present invention, the data query apparatus may be applied to a data query device, and the data query device may be a terminal device such as a notebook computer, a desktop computer, a mobile phone, a tablet computer, a vehicle-mounted terminal, and an intelligent wearable device.
The target interface may be any interface that can be used to query data, such as a web page, an application interface, a document interface, and the like, may be a display interface on the data query device, and may also be a display interface on other devices, which is not limited in the embodiment of the present invention. The specified operation event refers to an operation event for triggering query data, and may include, but is not limited to, dragging, long-pressing, double-clicking, sliding a specific symbol, and the like on the content displayed on the target interface.
102. The data query means determines an operation object specifying the operation event, and determines the target element based on the operation object.
In the embodiment of the invention, the data query device further determines the operation object of the specified operation event after monitoring that the specified operation event occurs on the target interface. For example, when the user double-clicks a certain data table by a mouse, the data query device thereby determines that the operation object of the double-click operation is the data table.
Further, after determining the operation object of the specified operation event, the data query apparatus may further determine the target element based on the operation object.
Various elements are shown on the target interface, which may be data tables, fields, symbols, data types, pictures, links, and the like, and the embodiments of the present invention are not limited. The operation object is any element displayed on the target interface.
It can be understood that, when the operation object is a data table, the target elements are all fields contained in the data table; when the operation object is a field, the target element is the data table to which the field belongs. One or more operation objects may be provided. Accordingly, there may be one or more target elements, and the embodiments of the present invention are not limited.
Further, when the operation object is a field, the field may be a field in a different data table.
103. And the data query device generates a query instruction based on SQL according to the operation object and the target element.
In the embodiment of the invention, the data query device can generate the query instruction based on SQL after determining the operation object and the target element, and the query instruction is written in SQL and is used for querying the data corresponding to the operation object and the target element. SQL is a special purpose programming language for standard data queries in databases.
Optionally, the data query device may list all the data tables and the fields in advance, and display the data tables and the fields on the target interface, so that when a user queries data of corresponding fields, the data query device may automatically generate a query SQL according to an operation of the user.
For example, assume that there are two tables of data, the data being as follows:
table 1: table1 (t 1_ field1, t1_ field2, t1_ field3, t1_ field 4);
table 2: table2 (t 2_ field1, t2_ field2, t2_ field3, t2_ field4, t2_ field5, t2_ field 6).
Then, the two data tables table1 and table2 may be displayed on the target interface, and specifically, refer to the interface schematic diagram of the target interface shown in fig. 2.
Based on the above example, further by way of example, assuming that the operation object determined by the data query apparatus is data table1, so that all fields in table1, i.e. t1_ field1, t1_ field2, t1_ field3, and t1_ field4, can be further determined, the automatically generated SQL may specifically be: select t1_ field1, t1_ field2, t1_ field3, t1_ field4from table1. Assuming that the operation object determined by the data query apparatus is the field t1_ field1, it may be determined that the data table to which a1 belongs is table1, and the automatically generated SQL may specifically be: select t1_ field1from table1.
Further, assuming that the operation objects determined by the data query apparatus are table1 and fields t2_ field3 and t2_ field5, and further, the data query apparatus may determine that t2_ field3 and t2_ field5 belong to data table2, then the automatically generated SQL may specifically be: select t1_ field1, t1_ field2, t1_ field3, t1_ field4from table1, select t2_ field3, t2_ field5from table2.
104. The data inquiry device inquires data corresponding to the target element and the operation object based on the inquiry instruction.
In the embodiment of the invention, the data query device automatically generates the query instruction based on the specified operation event, so that the data corresponding to the target element and the operation object can be queried based on the query instruction. Specifically, the data query device may specifically query data corresponding to the target element and the operation object from a database.
It can be understood that, when the operation object is a data table, the data query device specifically obtains the corresponding data table from the database, and queries data corresponding to all fields in the data table; when the operation object is a field, the data query device determines the data table to which the field belongs, and queries the data corresponding to the field from the corresponding data table in the database.
It can be seen that, in the method described in fig. 1, the data query device monitors a specified operation event on the target interface in real time, determines an operation object of the specified operation event, and determines a target element based on the operation object, where the operation object is any element displayed on the target interface, so as to generate a query instruction based on SQL according to the operation object and the target element, and finally query data corresponding to the target element and the operation object based on the query instruction. By the embodiment of the invention, the data query device can automatically generate the query SQL based on user operation to query the data in the database, thereby reducing the artificial workload during data query and improving the query efficiency.
Referring to fig. 3, fig. 3 is a schematic flow chart illustrating another data query method according to an embodiment of the present invention. The method described in the embodiment of the invention can comprise the following steps:
301. the data query device monitors a drag event on a target interface.
In the embodiment of the present invention, the specified operation event may be a drag event. The data query device can monitor whether a drag event occurs on the target interface in real time. It can be understood that the drag event specifically refers to dragging an element in the target interface to another position after the element is selected.
It should be noted that, in the embodiment of the present invention, a drag event may include moving an element in a target interface from one position to another position; the method also includes generating a second element having the same characteristics as the first element after the first element needing to be dragged is selected, and when the dragging action is implemented, the position of the first element is unchanged, the second element is dragged to other positions from the position of the first element, and when the dragging is stopped, the second element disappears, that is, the user is visually made to perceive that the first element is being dragged.
For example, after a user selects a certain data table by double-clicking with a mouse, the data query device generates the same data table on the target interface, and when the mouse moves on the target interface, the position of the generated data table on the target interface moves along with the movement of the mouse, so that the dragging operation of the data table is realized.
302. The data query device detects whether the dragging action of the dragging event is stopped or not, and if the dragging action is stopped, the position information when the dragging action is stopped is obtained.
In the embodiment of the invention, when the data query device monitors that the target interface has the drag event, whether the drag action of the drag event is stopped can be detected in real time. And if the dragging action is stopped, further acquiring the position information of the position of the dragging action when the dragging action is stopped, and if the dragging action is not stopped, continuously detecting the dragging event.
For example, the user may select an element by pressing the right button of the mouse for a long time and drag the element, and the data query device may determine whether the drag action is stopped by detecting whether the pressing force of the right button of the mouse is zero. And if the pressing force of the right mouse button cannot be detected, the dragging action is stopped, and the data query device can acquire the position information of the position of the cursor corresponding to the mouse on the target interface when the dragging is stopped.
The position information may be a coordinate position on the target interface, or may be a coordinate position on the target interface, where the target interface is divided into a plurality of regions, and the position information is a region to which the specific drag action currently belongs when the drag action is stopped.
303. And when the position indicated by the position information is located in the preset of the target interface, the data query device determines an operation object of the drag event and determines the target element based on the operation object.
In the embodiment of the present invention, the preset area is an area designated on the target interface, and may be any area designated by a user or a default area.
Therefore, after the data query device obtains the position information when the dragging action is stopped, whether the position indicated by the position information is located in the preset area of the target interface or not can be further judged, if the position indicated by the position information is located in the preset area, the operation is an operation for triggering query of data, so that the operation object of the dragging event is further determined, and the target element is determined based on the operation object. If the operation is not located in the preset area, the operation is possibly a misoperation or an operation triggering other instructions, the data query device does not further determine the operation object of the drag event, and the target element is determined based on the operation object.
Optionally, the data query device detects whether a dragging action of the dragging event is stopped, and if the dragging action is stopped, obtains position information when the dragging action is stopped, and determines whether a position indicated by the position information is located in a preset area of the target interface.
304. And the data query device generates a query instruction based on SQL according to the operation object and the target element.
305. The data inquiry device inquires data corresponding to the target element and the operation object based on the inquiry instruction.
The implementation of step 304 and step 305 may refer to step 103 and step 104 in the above embodiment, and the embodiment of the present invention is not described herein again.
Optionally, the data query device may also mark the operable element on the target interface.
Specifically, when each element can be displayed on the target interface, the data query device marks the element which can be operated (such as dragged) in a manner of changing color, amplifying display and the like; when a certain element is selected by a cursor or a finger corresponding to a mouse, if the element is operable, marking is performed by changing colors, enlarging display and the like, and if the element is not operable, marking is not performed, so that a user is indicated which elements can be used for automatically generating SQL (structured query language) to query data by dragging and the like.
It can be seen that, in the method described in fig. 3, a user can automatically generate SQL by dragging an element on a target interface, so as to query corresponding data. Specifically, the element can be dragged to a preset area of the target interface, so that misoperation of a user can be prevented. Further, the user operation can be facilitated by marking and displaying the operable elements, so that the query efficiency is further improved.
Based on the data query method in the above embodiment, the embodiment of the invention also discloses a data query device. Referring to fig. 4, fig. 4 is a schematic structural diagram of a data query device according to an embodiment of the present invention. The device described in the embodiment of the present invention may include the following modules:
and the monitoring module 401 is configured to monitor a specified operation event on the target interface.
A determining module 402, configured to determine an operation object of the specified operation event, and determine a target element based on the operation object, where the operation object is any element displayed on the target interface.
A generating module 403, configured to generate an SQL-based query instruction according to the operation object and the target element.
A query module 404, configured to query, based on the query instruction, data corresponding to the target element and the operation object.
The target interface may be any interface that can be used to query data, such as a web page, an application interface, a document interface, and the like, may be a display interface on the data query device, and may also be a display interface on other devices, which is not limited in the embodiment of the present invention. The designated operation event refers to an operation event for triggering query data, and may include, but is not limited to, dragging, long-pressing, double-clicking, sliding a specific symbol, and the like on the content presented on the target interface.
In some possible embodiments, when the operation object is a data table, the target element is all fields contained in the data table; or, when the operation object is a field, the target element is a data table to which the field belongs.
In some possible embodiments, the specified operation event includes a drag event, and the apparatus may further include:
a detecting module 405, configured to detect whether a drag action of the drag event is stopped.
An obtaining module 406, configured to obtain, when the drag action is stopped, position information when the drag action is stopped, and when a position indicated by the position information is located in a preset area of the target interface, trigger the determining module 402 to execute the operation object for determining the specified operation event, and determine an operation of the target element based on the operation object.
In the embodiment of the present invention, the preset area is an area designated on the target interface, and may be any area designated by a user or a default area.
In some possible embodiments, the apparatus may further include:
a marking module 407, configured to mark an operable element on the target interface.
It can be seen that in the apparatus described in fig. 4, the data query apparatus monitors the specified operation event on the target interface in real time, determines the operation object of the specified operation event, and determines the target element based on the operation object, where the operation object is any element displayed on the target interface, so as to generate a query instruction based on SQL according to the operation object and the target element, and finally queries data corresponding to the target element and the operation object based on the query instruction. By the embodiment of the invention, the data query device can automatically generate the query SQL based on user operation to query the data in the database, thereby reducing the artificial workload during data query and improving the query efficiency. The user can enable the data query device to automatically generate SQL by dragging elements on the target interface, so as to query corresponding data. Specifically, the element can be dragged to a preset area of the target interface, so that misoperation of a user can be prevented. Further, the user operation can be facilitated by marking the operable elements, so that the query efficiency is further improved.
Referring to fig. 5, fig. 5 is a schematic structural diagram of a data query device according to an embodiment of the present invention. The devices described in the embodiments of the present invention may include, but are not limited to: at least one input device 501; at least one output device 502; at least one processor 503, such as a CPU; and a memory 504, the input device 501, the output device 502, the processor 503, and the memory 504 being connected by a bus 505.
The output device 502 may be, for example, a screen/interface for outputting, such as a Display screen (Display), a touch screen, and specifically, a target interface, and the input device 501 may be, for example, a Keyboard (Keyboard) for inputting, a mouse, a camera for capturing an image, an earpiece and a speaker for playing a sound signal, a touch screen for detecting a touch operation, and the like. The memory 504 is used to store instructions and the processor 503 is used to execute programs stored by the memory 504. Wherein:
and the processor 503 is used for monitoring a specified operation event on the target interface.
The processor 503 is further configured to determine an operation object of the specified operation event, and determine a target element based on the operation object, where the operation object is any element displayed on the target interface.
The processor 503 is further configured to generate an SQL-based query instruction according to the operation object and the target element.
The processor 503 is further configured to query data corresponding to the target element and the operation object based on the query instruction.
The target interface may be any interface that can be used to query data, such as a web page, an application interface, a document interface, and the like, may be a display interface on the data query device, and may also be a display interface on other devices, which is not limited in the embodiment of the present invention. The designated operation event refers to an operation event for triggering query data, and may include, but is not limited to, dragging, long-pressing, double-clicking, sliding a specific symbol, and the like on the content presented on the target interface.
In some possible embodiments, when the operation object is a data table, the target element is all fields contained in the data table; or, when the operation object is a field, the target element is a data table to which the field belongs.
In some feasible embodiments, the specified operation event includes a drag event, and the processor 503 is further configured to detect whether a drag action of the drag event is stopped, obtain, when the drag action is stopped, position information when the drag action is stopped, and execute, when a position indicated by the position information is located in a preset area of the target interface, the operation object that determines the specified operation event, and determine an operation of the target element based on the operation object.
In the embodiment of the present invention, the preset area is an area designated on the target interface, and may be any area designated by a user or a default area.
In some possible embodiments, an output device 502 is used to mark the operable elements on the target interface.
As can be seen, in the device described in fig. 5, the data query device monitors the specified operation event on the target interface in real time, determines the operation object of the specified operation event, and determines the target element based on the operation object, where the operation object is any element displayed on the target interface, so as to generate a query instruction based on SQL according to the operation object and the target element, and finally query data corresponding to the target element and the operation object based on the query instruction. By the embodiment of the invention, the data query equipment can automatically generate the query SQL based on user operation to query the data in the database, thereby reducing the artificial workload during data query and improving the query efficiency. A user can enable the data query equipment to automatically generate SQL by dragging elements on the target interface, so that corresponding data can be queried. Specifically, the element can be dragged to a preset area of the target interface, so that misoperation of a user can be prevented. Further, the user operation can be facilitated by marking and displaying the operable elements, so that the query efficiency is further improved.
It will be understood by those skilled in the art that all or part of the processes of the methods of the embodiments described above can be implemented by a computer program, which can be stored in a computer-readable storage medium, and when executed, can include the processes of the embodiments of the methods described above. The storage medium may be a magnetic disk, an optical disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), or the like.
The above disclosure is only for the purpose of illustrating the preferred embodiments of the present invention, and it is therefore to be understood that the invention is not limited by the scope of the appended claims.

Claims (5)

1. A method of data query, the method comprising:
monitoring a designated operation event on a target interface, wherein the target interface is any interface used for inquiring data, and the designated operation event comprises a dragging event;
detecting whether the dragging action of the dragging event is stopped;
if the drag action is stopped, acquiring position information when the drag action is stopped;
when the position indicated by the position information is located in a preset area of the target interface, determining at least one operation object of the specified operation event, wherein the operation object is any element displayed on the target interface;
when the operation object is a data table, determining all fields contained in the data table as target elements; or when the operation object is a field, determining that a data table to which the field belongs is a target element;
generating a query instruction based on Structured Query Language (SQL) according to the operation object and the target element, wherein the query instruction comprises parameters corresponding to a SELECT part and parameters corresponding to a FROM part, when the operation object is a data table, the parameters corresponding to the SELECT part are the target element, and the parameters corresponding to the FROM part are the operation object; when the operation object is a field, the parameter corresponding to the SELECT part is the operation object, and the parameter corresponding to the FROM part is the target element;
and querying data corresponding to the target element and the operation object based on the query instruction.
2. The method of claim 1, wherein prior to listening for a specified operational event on a target interface, the method further comprises:
and marking the operable elements on the target interface.
3. A data query apparatus, characterized in that the apparatus comprises:
the monitoring module is used for monitoring a specified operation event on a target interface, wherein the target interface is any interface used for inquiring data, and the specified operation event comprises a dragging event;
the detection module is used for detecting whether the dragging action of the dragging event is stopped or not;
the determining module is used for determining at least one operation object of the specified operation event and determining a target element based on the operation object, wherein the operation object is any element displayed on the target interface;
an obtaining module, configured to obtain, when the drag action is stopped, position information when the drag action is stopped, and when a position indicated by the position information is located in a preset area of the target interface, trigger the determining module to execute the operation object for determining the specified operation event, and determine an operation of a target element based on the operation object;
a generating module, configured to generate an SQL-based query instruction according to the operation object and the target element, where the query instruction includes a parameter corresponding to a SELECT part and a parameter corresponding to a FROM part, where, when the operation object is a data table, the parameter corresponding to the SELECT part is the target element, and the parameter corresponding to the FROM part is the operation object; when the operation object is a field, the parameter corresponding to the SELECT part is the operation object, and the parameter corresponding to the FROM part is the target element;
the query module is used for querying data corresponding to the target element and the operation object based on the query instruction;
the determining module is specifically configured to determine all fields contained in the data table as target elements when determining the target elements based on the operation objects, and when the operation objects are the data table; or when the operation object is a field, determining that the data table to which the field belongs is a target element.
4. The apparatus of claim 3, further comprising:
and the marking module is used for marking the operable elements on the target interface.
5. A computer storage medium, characterized in that it stores a computer program comprising program instructions which, when executed by a processor, cause a computer device having the processor to carry out the method of claim 1 or 2.
CN201710121740.4A 2017-03-02 2017-03-02 Data query method and device Active CN108536342B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201710121740.4A CN108536342B (en) 2017-03-02 2017-03-02 Data query method and device

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201710121740.4A CN108536342B (en) 2017-03-02 2017-03-02 Data query method and device

Publications (2)

Publication Number Publication Date
CN108536342A CN108536342A (en) 2018-09-14
CN108536342B true CN108536342B (en) 2022-11-08

Family

ID=63489367

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201710121740.4A Active CN108536342B (en) 2017-03-02 2017-03-02 Data query method and device

Country Status (1)

Country Link
CN (1) CN108536342B (en)

Families Citing this family (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN112860725A (en) * 2021-02-02 2021-05-28 浙江大华技术股份有限公司 SQL automatic generation method and device, storage medium and electronic equipment

Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101464862A (en) * 2007-12-21 2009-06-24 英业达股份有限公司 SQL generating system and method
CN105843945A (en) * 2016-04-08 2016-08-10 联动优势科技有限公司 Report generation method and system

Family Cites Families (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN103093000A (en) * 2013-02-25 2013-05-08 用友软件股份有限公司 Database query modeling system and database query modeling method
US20140244680A1 (en) * 2013-02-28 2014-08-28 Lakshmy Chandran Sql query parsing and translation
CN104216607B (en) * 2013-09-05 2017-10-20 侯金涛 The icon dragging method and system of virtual opetrating system based on HTML5
CN105740333A (en) * 2016-01-23 2016-07-06 北京掌阔移动传媒科技有限公司 Visual advertisement management platform, and implementation method thereof

Patent Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101464862A (en) * 2007-12-21 2009-06-24 英业达股份有限公司 SQL generating system and method
CN105843945A (en) * 2016-04-08 2016-08-10 联动优势科技有限公司 Report generation method and system

Also Published As

Publication number Publication date
CN108536342A (en) 2018-09-14

Similar Documents

Publication Publication Date Title
CN106484266B (en) Text processing method and device
CN109062479B (en) Split screen application switching method and device, storage medium and electronic equipment
US20140049498A1 (en) Method and mobile terminal device for image operation
KR20160125401A (en) Inline and context aware query box
CN112099684A (en) Search display method and device and electronic equipment
CN112399006B (en) File sending method and device and electronic equipment
WO2023109525A1 (en) Quick setting method and apparatus for electronic device, and storage medium and electronic device
CN111338625B (en) Data processing method, system, terminal equipment and storage medium
CN108536342B (en) Data query method and device
CN112817582A (en) Code processing method and device, computer equipment and storage medium
CN111143731B (en) Display method and device for webpage interface zooming and terminal equipment
CN112596643A (en) Application icon management method and device
WO2016018682A1 (en) Processing image to identify object for insertion into document
CN112579753A (en) Information acquisition method, device, equipment, medium and product
CN108287643B (en) Page layout adjustment method and device
CN109144809B (en) Focus change monitoring method, storage medium, electronic device and system
CN107862728B (en) Picture label adding method and device and computer readable storage medium
CN105549837A (en) Method and device for displaying contact items of contact list based on touch-screen apparatus
CN112162689B (en) Input method and device and electronic equipment
CN106873866B (en) Content amplification display method and device
CN113900848A (en) Abnormal page processing method and device, electronic equipment and storage medium
CN107621903B (en) Double-touch-screen equipment and response control method thereof
CN109190097B (en) Method and apparatus for outputting information
US20180348946A1 (en) Information Input Method and Apparatus for Touch Screen
CN113190365A (en) Information processing method and device and electronic equipment

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