CN110837500A - Data screening method and device based on local embedded window and computer equipment - Google Patents
Data screening method and device based on local embedded window and computer equipment Download PDFInfo
- Publication number
- CN110837500A CN110837500A CN201910969966.9A CN201910969966A CN110837500A CN 110837500 A CN110837500 A CN 110837500A CN 201910969966 A CN201910969966 A CN 201910969966A CN 110837500 A CN110837500 A CN 110837500A
- Authority
- CN
- China
- Prior art keywords
- screening
- condition
- script
- data
- script command
- 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.)
- Granted
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR 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
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR 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/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
- Y02D10/00—Energy efficient computing, e.g. low power processors, power management or thermal management
Abstract
The invention discloses a data screening method based on a local embedded window, which comprises the following steps: acquiring instruction content of a script command frame when the query button is touched or clicked, judging whether the instruction content conforms to a preset script instruction format, and popping up a condition screening window when the instruction content does not conform to the preset script instruction format; then, receiving the screening conditions clicked by the user through the condition screening window and corresponding necessary parameters, and generating a corresponding script command by combining a preset screening condition and an association table of the script command; and finally, filling the script command into a script command box of the service database, and executing query. The invention also provides a data screening device, a server and a computer readable storage medium based on the local embedded window. The invention automatically generates the corresponding script command by providing a mode of clicking the screening condition, thereby facilitating users who are not familiar with the script command to more accurately and efficiently screen and query data.
Description
Technical Field
The invention relates to the technical field of data screening, in particular to a data screening method and device based on a local embedded window, computer equipment and a computer readable storage medium.
Background
In the prior art, for many service databases, a manner for a user to input a script command is generally provided for data query or data screening. However, in the case where the amount of data included in the service database is large and the number of elements included in each piece of data is also large, when data is simply searched or filtered from the service database based on the script command, an executor needs to be skilled in mastering different script commands. In practical applications, the query or screening of business data is a work which is most frequently used, and for new employees or employees who are not familiar with script commands, the script command query mode provided by the existing business database is difficult to accurately query or screen target data, and the efficiency of data query or screening is very low.
Disclosure of Invention
In view of the above, the invention provides a data screening method, device, computer equipment and computer-readable storage medium based on a local embedded window, which can acquire the instruction content of a script command frame when an inquiry button is touched or clicked, then judge whether the instruction content conforms to the format of a preset script instruction, and pop up a condition screening window when the instruction content does not conform to the format of the preset script instruction; then, receiving the screening conditions clicked by the user through the condition screening window and corresponding necessary parameters, and generating a corresponding script command by combining a preset screening condition and an association table of the script command; and finally, filling the script command into a script command box of the service database, and executing query. Through the method, the corresponding script command is automatically generated in a mode of clicking the screening condition, so that users who are not familiar with the script command can more accurately and efficiently screen and query data.
Firstly, in order to achieve the above object, the present invention provides a data screening method based on a loca embedded window, the method comprising:
monitoring a query button of a data query interface of a service database, and acquiring instruction content of a script command frame of the data query interface when the query button is touched or clicked; judging whether the instruction content conforms to a preset format of a script instruction or not, and popping up a condition screening window when the instruction content does not conform to the preset format of the script instruction; receiving a screening condition clicked by a user through the condition screening window and input necessary parameters corresponding to the screening condition; generating a corresponding script command according to the screening condition, the necessary parameters corresponding to the screening condition and a preset association table of the screening condition and the script command; and filling the script command into a script command box of the service database, and executing query.
Optionally, the query button of the monitoring service database data query interface includes: calling an API of the service database; monitoring the state value of the query button of a query interface of the business database through the API; and judging whether the query button is in a touched or clicked state or not according to the state value of the query button.
Optionally, the determining whether the instruction content conforms to a preset format of a script instruction includes: comparing the instruction content with standard instruction content in a preset standard format instruction library in a text format; and when the instruction content is completely matched with the standard instruction content, judging that the instruction content conforms to the format of a preset script instruction.
Optionally, the condition screening window includes at least one preset screening condition check bar and an essential parameter filling bar corresponding to the screening condition, and the receiving of the screening condition clicked by the user through the condition screening window and the input essential parameter corresponding to the screening condition includes: obtaining the screening conditions clicked by the user through the screening condition check bar; and acquiring the necessary parameters filled in the necessary parameter filling column.
Optionally, the condition filtering window is set by being embedded into the service database through an API of the service database according to a local language script.
Optionally, the step of generating a corresponding script command according to the screening condition, the necessary parameters corresponding to the screening condition, and a preset association table of the screening condition and the script command includes: calling a script command template from the association table of the screening conditions and the script commands according to the screening conditions; and filling the necessary parameters corresponding to the screening conditions into the script command template to generate a script command.
In addition, in order to achieve the above object, the present invention further provides a data filtering apparatus based on a local embedded window, the apparatus comprising:
the acquisition module is used for monitoring a query button of a data query interface of a service database and acquiring the instruction content of a script command frame of the data query interface when the query button is touched or clicked; the judging module is used for judging whether the instruction content conforms to the format of a preset script instruction or not, and popping up a condition screening window when the instruction content does not conform to the format of the preset script instruction; the receiving module is used for receiving the screening conditions clicked by the user through the condition screening window and the input necessary parameters corresponding to the screening conditions; the generating module is used for generating a corresponding script command according to the screening condition, the necessary parameters corresponding to the screening condition and a preset association table of the screening condition and the script command; and the execution module is used for filling the script command into a script command box of the service database and executing the query.
Optionally, the generating module is further configured to: calling a script command template from the association table of the screening conditions and the script commands according to the screening conditions; and filling the necessary parameters corresponding to the screening conditions into the script command template to generate a script command.
Further, the present invention also provides a computer device, which includes a memory and a processor, wherein the memory stores a computer program that can run on the processor, and the computer program, when executed by the processor, implements the steps of the data screening method based on the loca embedded window.
Further, to achieve the above object, the present invention also provides a computer-readable storage medium storing a computer program, which is executable by at least one processor to cause the at least one processor to perform the steps of the data filtering method based on the loca embedded window as described above.
Compared with the prior art, the data screening method, the data screening device, the computer equipment and the computer readable storage medium based on the local embedded window can acquire the instruction content of the script command frame when the query button is touched or clicked, judge whether the instruction content conforms to the format of the preset script instruction or not, and pop up the condition screening window when the instruction content does not conform to the format of the preset script instruction; then, receiving the screening conditions clicked by the user through the condition screening window and corresponding necessary parameters, and generating a corresponding script command by combining a preset screening condition and an association table of the script command; and finally, filling the script command into a script command box of the service database, and executing query. Through the method, the corresponding script command is automatically generated in a mode of clicking the screening condition, so that users who are not familiar with the script command can more accurately and efficiently screen and query data.
Drawings
FIG. 1 is a diagram of an alternative hardware architecture for a computer device of the present invention;
FIG. 2 is a schematic diagram of a program module of an embodiment of the data filtering apparatus based on a local embedded window according to the present invention;
FIG. 3 is a schematic flow chart of an embodiment of the data screening method based on the local embedded window.
Reference numerals:
the objects, features and advantages of the present invention will be further explained with reference to the accompanying drawings.
Detailed Description
In order to make the objects, technical solutions and advantages of the present invention more apparent, the present invention is described in further detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are merely illustrative of the invention and are not intended to limit the invention. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
It should be noted that the description relating to "first", "second", etc. in the present invention is for descriptive purposes only and is not to be construed as indicating or implying relative importance or implicitly indicating the number of technical features indicated. Thus, a feature defined as "first" or "second" may explicitly or implicitly include at least one such feature. In addition, technical solutions between various embodiments may be combined with each other, but must be realized by a person skilled in the art, and when the technical solutions are contradictory or cannot be realized, such a combination should not be considered to exist, and is not within the protection scope of the present invention.
Fig. 1 is a schematic diagram of an alternative hardware architecture of the computer device 1 according to the present invention.
In this embodiment, the computer device 1 may include, but is not limited to, a memory 11, a processor 12, and a network interface 13, which may be communicatively connected to each other through a system bus.
The computer device 1 is connected to a network (not shown in fig. 1) through a network interface 13, and is connected to other terminal devices such as a mobile terminal and a PC terminal through the network. The network may be a wireless or wired network such as an Intranet (Intranet), the Internet (Internet), a Global System of Mobile communication (GSM), Wideband Code Division Multiple Access (WCDMA), a 4G network, a 5G network, Bluetooth (Bluetooth), Wi-Fi, or a communication network.
It is noted that fig. 1 only shows a computer device 1 with components 11-13, but it is to be understood that not all shown components are required to be implemented, and that more or less components may be implemented instead.
The memory 11 includes at least one type of readable storage medium, which includes a flash memory, a hard disk, a multimedia card, a card-type memory (e.g., SD or DX memory, etc.), a Random Access Memory (RAM), a Static Random Access Memory (SRAM), a Read Only Memory (ROM), an Electrically Erasable Programmable Read Only Memory (EEPROM), a Programmable Read Only Memory (PROM), a magnetic memory, a magnetic disk, an optical disk, etc. In some embodiments, the storage 11 may be an internal storage unit of the computer device 1, such as a hard disk or a memory of the computer device 1. In other embodiments, the memory 11 may also be an external storage device of the computer device 1, such as a plug-in hard disk, a Smart Media Card (SMC), a Secure Digital (SD) Card, a Flash memory Card (Flash Card), and the like provided in the computer device 1. Of course, the memory 11 may also comprise both an internal storage unit of the computer device 1 and an external storage device thereof. In this embodiment, the memory 11 is generally used for storing an operating system installed in the computer device 1 and various application software, such as program codes of the data filtering apparatus 200 based on the local embedded window. Furthermore, the memory 11 may also be used to temporarily store various types of data that have been output or are to be output.
The processor 12 may be a Central Processing Unit (CPU), controller, microcontroller, microprocessor, or other data Processing chip in some embodiments. The processor 12 is generally used for controlling the overall operation of the computer device 1, such as performing data interaction or communication related control and processing. In this embodiment, the processor 12 is configured to run the program code stored in the memory 11 or process data, for example, run the data filtering apparatus 200 based on the local embedded window.
The network interface 13 may comprise a wireless network interface or a wired network interface, and the network interface 13 is generally used for establishing a communication connection between the computer device 1 and other terminal devices such as a mobile terminal and a PC terminal.
In this embodiment, when the data screening apparatus 200 based on the local embedded window is installed and operated in the computer device 1, when the data screening apparatus 200 based on the local embedded window is operated, the instruction content of the script command frame when the query button is touched or clicked can be obtained, and then whether the instruction content conforms to the format of the preset script instruction is judged, and when the instruction content does not conform to the format of the preset script instruction, a condition screening window is popped up; then, receiving the screening conditions clicked by the user through the condition screening window and corresponding necessary parameters, and generating a corresponding script command by combining a preset screening condition and an association table of the script command; and finally, filling the script command into a script command box of the service database, and executing query. Through the method, the corresponding script command is automatically generated in a mode of clicking the screening condition, so that users who are not familiar with the script command can more accurately and efficiently screen and query data.
The application environment and the hardware structure and function of the related devices of the various embodiments of the present invention have been described in detail so far. Hereinafter, various embodiments of the present invention will be proposed based on the above-described application environment and related devices.
First, the present invention provides a data filtering apparatus 200 based on a local embedded window.
Referring to FIG. 2, a block diagram of a data filtering apparatus 200 based on a local embedded window according to an embodiment of the present invention is shown.
In this embodiment, the data filtering apparatus 200 based on the loca embedded window includes a series of computer program instructions stored in the memory 11, and when the computer program instructions are executed by the processor 12, the data filtering function based on the loca embedded window according to the embodiments of the present invention can be implemented. In some embodiments, the local inline window-based data screening apparatus 200 may be divided into one or more modules based on the specific operations implemented by the portions of the computer program instructions. For example, in fig. 2, the data filtering apparatus 200 based on the loca embedded window may be divided into an acquisition module 201, a determination module 202, a receiving module 203, a generation module 204, and an execution module 205. Wherein:
the obtaining module 201 is configured to monitor a query button of a data query interface of a service database, and obtain instruction content of a script command box of the data query interface when the query button is touched or clicked.
Specifically, the computer device 1 is connected to an API (Application programming interface) of a service database, and can perform a certain data screening operation on the service database after obtaining authorization of the service database. In this embodiment, the service database provides a data query interface, and the data query interface includes a script command box and a query button. The script command box provides instruction contents for a user to input data query, and the query button is used for executing the instruction contents for data query in the script command box. The service database provides a user to compile data screening instructions by using a local scripting language, and then screens corresponding data according to the data screening instructions. In this embodiment, the computer device 1 calls an API of the service database, monitors a state value of the query button on a query interface of the service database through the API, and then determines whether the query button is in a touched or clicked state according to the state value of the query button. Therefore, the obtaining module 201 can monitor the query button of the data query interface of the service database in real time, and when the query button is touched or clicked, the data screening system further obtains the instruction content in the script command box of the data query interface.
Of course, in other embodiments, the data filtering apparatus 200 based on the local embedded window may also coexist with the service database in the computer device 1, and then the data filtering apparatus 200 based on the local embedded window directly performs data interaction with the service database after obtaining the authorization of the service database, including data filtering and query.
The judging module 202 is configured to judge whether the instruction content conforms to a preset format of a script instruction, and pop up a condition screening window when the instruction content does not conform to the preset format of the script instruction.
Specifically, after the instruction content in the script command box is acquired, the acquiring module 201 determines whether the instruction content is correct according to a format of a preset script instruction. In this embodiment, the service database defines corresponding script instructions in advance for data screening functions for querying different data types, and stores the script instructions in a standard format instruction library, and only when instruction contents conforming to the format of the script instructions of the service database are input, corresponding data can be screened from the service database after the query is executed. Therefore, after the instruction content in the script command box is obtained, the obtaining module 201 can compare the instruction content with a text format of a standard instruction content in a preset standard format instruction library, and when the instruction content is completely matched with the standard instruction content, determine that the instruction content conforms to a format of a preset script command. Therefore, the obtaining module 201 can determine whether the instruction content in the script command box is correct according to the format of the script instruction of the service data system, and then pop up a preset condition screening window when it is determined that the instruction content in the script command box of the service database has a format error or the instruction content is empty. In this embodiment, since the local script language has good compatibility, the condition filtering window is set by embedding the local script language into the service database through the API of the service database. The condition screening window comprises a plurality of preset screening conditions and corresponding necessary parameter filling columns. The condition screening window comprises at least one preset screening condition checking column and a necessary parameter filling column corresponding to the screening conditions. The screening conditions displayed in the condition screening window comprise data types and corresponding necessary parameters required for screening data in the service database. When the user clicks the check box before the name of a screening condition, the screening condition is selected. And then, the necessary parameter filling field after the condition name is screened is converted from a gray non-fillable state into a fillable state, and is provided for the user to fill. Of course, in other embodiments, the programming may be performed by other programming languages compatible with the local scripting language.
The receiving module 203 is configured to receive the filtering condition clicked by the user through the condition filtering window and the input necessary parameter corresponding to the filtering condition.
The generating module 204 is configured to generate a corresponding script command according to the screening condition, the necessary parameters corresponding to the screening condition, and a preset association table between the screening condition and the script command.
Specifically, after the determining module 202 pops up the condition filtering window, the user may then check the filtering condition in the condition filtering window and fill in the corresponding necessary parameters. Then, the receiving module 203 receives the filtering condition clicked by the user through the condition filtering window and the input necessary parameter corresponding to the filtering condition, specifically, the filtering condition clicked by the user is obtained through the filtering condition check bar, and then the necessary parameter filled in the necessary parameter filling bar is obtained. Then, the generating module 204 invokes a corresponding script command template for querying the screening condition from a preset association table of the screening condition and the script command according to the screening condition and the corresponding necessary parameter in the condition screening window, and fills the necessary parameter corresponding to the screening condition into a default portion of the script command template to generate the script command corresponding to the screening condition.
Wherein, the computer device 1 provides a user with a pre-established association table of the screening conditions and the script commands in advance. In this embodiment, the computer device 1 provides a filtering condition setting page, and then receives the filtering conditions set on the filtering condition setting page by the user and the corresponding script command template. Therefore, the association table of the screening conditions and the script commands comprises the commonly used data screening conditions and script command templates corresponding to the data screening conditions one by one, and each script command template comprises a corresponding instruction description. For example: the user often needs to query the service database for data in the aspect a, and then, the data in the aspect a may be used as one of the screening conditions in the association table of the screening conditions and the script commands, for example, set as: "A: x-y" corresponds to "CX: A: x-y//" data of A in the query range x-y ". The former part, a, is the screening condition, and x and y are necessary parameters (referred to as the screening range) corresponding to the screening condition filled by the user. The back part is the corresponding script instruction "CX: a: x-y", and the instruction description "//" data of a of the query range x-y ".
Therefore, after the receiving module 203 receives the filtering condition clicked by the user and the corresponding necessary parameter, such as "a: 10-100", through the popped condition filtering window, the generating module 204 further generates the script command "CX: a: x-y//" data of a in the query range x-y "according to the association table of the filtering condition and the script command.
The executing module 205 is configured to fill the script command into a script command box of the service database, and execute a query.
Specifically, after the generating module 204 generates the script command of the data screening corresponding to the screening condition and the necessary parameter according to the screening condition and the necessary parameter clicked by the user and the association table of the screening condition and the script command, the executing module 205 fills the script command into the script command frame of the data query interface provided by the service database, and then executes the query. That is, the execution module 205 converts the filtering conditions and necessary parameters clicked by the user into the script commands of the corresponding data query, and then fills in the script command library, thereby performing the data query.
As can be seen from the above, the computer device 1 can obtain the instruction content of the script command box when the query button is touched or clicked, then judge whether the instruction content conforms to the format of the preset script instruction, and pop up a condition screening window when the instruction content does not conform to the format of the preset script instruction; then, receiving the screening conditions clicked by the user through the condition screening window and corresponding necessary parameters, and generating a corresponding script command by combining a preset screening condition and an association table of the script command; and finally, filling the script command into a script command box of the service database, and executing query. Through the method, the corresponding script command is automatically generated in a mode of clicking the screening condition, so that users who are not familiar with the script command can more accurately and efficiently screen and query data.
In addition, the invention also provides a data screening method based on the local embedded window, and the method is applied to computer equipment.
Fig. 3 is a schematic flow chart showing an embodiment of the data screening method based on the local embedded window according to the present invention. In this embodiment, the execution order of the steps in the flowchart shown in fig. 3 may be changed and some steps may be omitted according to different requirements.
Step S500, a query button of a data query interface of a service database is monitored, and instruction content of a script command box of the data query interface is obtained when the query button is touched or clicked.
Specifically, the computer device is connected to an API (Application programming interface) of a service database, and can perform a certain data screening operation on the service database after obtaining authorization of the service database. In this embodiment, the service database provides a data query interface, and the data query interface includes a script command box and a query button. The script command box provides instruction contents for a user to input data query, and the query button is used for executing the instruction contents for data query in the script command box. The service database provides a user to compile data screening instructions by using a local scripting language, and then screens corresponding data according to the data screening instructions. In this embodiment, the computer device calls an API of the service database, monitors a state value of the query button on a query interface of the service database through the API, and then determines whether the query button is in a touched or clicked state according to the state value of the query button. Therefore, the computer device can monitor the query button of the data query interface of the service database in real time, and when the query button is touched or clicked, the data screening system further acquires the instruction content in the script command box of the data query interface.
Of course, in other embodiments, the data filtering apparatus 200 based on the loca embedded window may also coexist with the service database in the computer device, and then the computer device directly performs data interaction with the service database after obtaining authorization of the service database, including data filtering and query.
Step S502, judging whether the instruction content conforms to the format of a preset script instruction or not, and popping up a condition screening window when the instruction content does not conform to the format of the preset script instruction.
Specifically, after the instruction content in the script command box is obtained, the computer device judges whether the instruction content is correct according to a preset format of a script instruction. In this embodiment, the service database defines corresponding script instructions in advance for data screening functions for querying different data types, and stores the script instructions in a standard format instruction library, and only when instruction contents conforming to the format of the script instructions of the service database are input, corresponding data can be screened from the service database after the query is executed. Therefore, after the instruction content in the script command box is obtained, the computer device can compare the instruction content with a text format of a standard instruction content in a preset standard format instruction library, and when the instruction content is completely matched with the standard instruction content, the computer device judges that the instruction content conforms to a preset format of a script instruction. Therefore, the computer device can judge whether the instruction content in the script command box is correct according to the format of the script instruction of the service data system, and then pop up a preset condition screening window when judging that the instruction content in the script command box of the service database has a format error or the instruction content is empty. In this embodiment, since the local script language has good compatibility, the condition filtering window is set by embedding the local script language into the service database through the API of the service database. The condition screening window comprises a plurality of preset screening conditions and corresponding necessary parameter filling columns. The condition screening window comprises at least one preset screening condition checking column and a necessary parameter filling column corresponding to the screening conditions. The screening conditions displayed in the condition screening window comprise data types and corresponding necessary parameters required for screening data in the service database. When the user clicks the check box before the name of a screening condition, the screening condition is selected. And then, the necessary parameter filling field after the condition name is screened is converted from a gray non-fillable state into a fillable state, and is provided for the user to fill. Of course, in other embodiments, the programming may be performed by other programming languages compatible with the local scripting language.
Step S504, receiving the screening condition clicked by the user through the condition screening window and the input necessary parameters corresponding to the screening condition.
Step S506, generating a corresponding script command according to the screening condition, the necessary parameters corresponding to the screening condition and a preset association table of the screening condition and the script command.
Specifically, after the computer device pops up a condition filtering window, the user may then check the filtering conditions in the condition filtering window and fill in the corresponding necessary parameters. Then, the computer device receives the screening condition clicked by the user through the condition screening window and the input necessary parameters corresponding to the screening condition, specifically, the screening condition clicked by the user is obtained through the screening condition check bar, and then the necessary parameters filled in the necessary parameter filling bar are obtained. Then, the computer device calls a corresponding script command template for inquiring the screening condition from a preset association table of the screening condition and the script command according to the screening condition and the corresponding necessary parameter in the condition screening window, and then fills the necessary parameter corresponding to the screening condition into a default part in the script command template so as to generate the script command corresponding to the screening condition.
Wherein, the computer device can provide a user with a pre-established association table of the screening conditions and the script commands in advance. In this embodiment, the computer device provides a filtering condition setting page, and then receives the filtering conditions set on the filtering condition setting page by the user and the corresponding script command template. Therefore, the association table of the screening conditions and the script commands comprises the commonly used data screening conditions and script command templates corresponding to the data screening conditions one by one, and each script command template comprises a corresponding instruction description. For example: the user often needs to query the service database for data in the aspect a, and then, the data in the aspect a may be used as one of the screening conditions in the association table of the screening conditions and the script commands, for example, set as: "A: x-y" corresponds to "CX: A: x-y//" data of A in the query range x-y ". The former part, a, is the screening condition, and x and y are necessary parameters (referred to as the screening range) corresponding to the screening condition filled by the user. The back part is the corresponding script instruction "CX: a: x-y", and the instruction description "//" data of a of the query range x-y ".
Therefore, after the computer device receives the screening conditions clicked by the user and the corresponding necessary parameters, such as "a: 10-100", through the popped condition screening window, the computer device further generates the script command of "CX: a: x-y//" data of a query range x-y "according to the association table of the screening conditions and the script command.
Step S508, the script command is filled into the script command box of the service database, and the query is executed.
Specifically, after the computer device generates a script command of data screening corresponding to the screening condition and the necessary parameter according to the screening condition and the necessary parameter clicked by the user and the association table of the screening condition and the script command, the computer device fills the script command into the script command frame of the data query interface provided by the service database, and then executes the query. That is, the computer device converts the filtering conditions and necessary parameters clicked by the user into script commands of the corresponding data query, and then fills in the script command library, thereby performing the data query.
The data screening method based on the local embedded window can acquire the instruction content of the script command frame when the query button is touched or clicked, judge whether the instruction content conforms to the format of a preset script instruction, and pop up a condition screening window when the instruction content does not conform to the format of the preset script instruction; then, receiving the screening conditions clicked by the user through the condition screening window and corresponding necessary parameters, and generating a corresponding script command by combining a preset screening condition and an association table of the script command; and finally, filling the script command into a script command box of the service database, and executing query. Through the method, the corresponding script command is automatically generated in a mode of clicking the screening condition, so that users who are not familiar with the script command can more accurately and efficiently screen and query data.
The above-mentioned serial numbers of the embodiments of the present invention are merely for description and do not represent the merits of the embodiments.
Through the above description of the embodiments, those skilled in the art will clearly understand that the method of the above embodiments can be implemented by software plus a necessary general hardware platform, and certainly can also be implemented by hardware, but in many cases, the former is a better implementation manner. Based on such understanding, the technical solutions of the present invention may be embodied in the form of a software product, which is stored in a storage medium (such as ROM/RAM, magnetic disk, optical disk) and includes instructions for enabling a terminal device (such as a mobile phone, a computer, a server, an air conditioner, or a network device) to execute the method according to the embodiments of the present invention.
The above description is only a preferred embodiment of the present invention, and not intended to limit the scope of the present invention, and all modifications of equivalent structures and equivalent processes, which are made by using the contents of the present specification and the accompanying drawings, or directly or indirectly applied to other related technical fields, are included in the scope of the present invention.
Claims (10)
1. A data screening method based on a loca embedded window is characterized by comprising the following steps:
monitoring a query button of a data query interface of a service database, and acquiring instruction content of a script command frame of the data query interface when the query button is touched or clicked;
judging whether the instruction content conforms to a preset format of a script instruction or not, and popping up a condition screening window when the instruction content does not conform to the preset format of the script instruction;
receiving a screening condition clicked by a user through the condition screening window and input necessary parameters corresponding to the screening condition;
generating a corresponding script command according to the screening condition, the necessary parameters corresponding to the screening condition and a preset association table of the screening condition and the script command;
and filling the script command into a script command box of the service database, and executing query.
2. The data screening method based on the loca embedded window as claimed in claim 1, wherein the query button of the monitoring business database data query interface comprises:
calling an API of the service database;
monitoring the state value of the query button of a query interface of the business database through the API;
and judging whether the query button is in a touched or clicked state or not according to the state value of the query button.
3. The method for screening data based on the loca embedded window as claimed in claim 1, wherein the judging whether the instruction content conforms to a preset script instruction format comprises:
comparing the instruction content with standard instruction content in a preset standard format instruction library in a text format;
and when the instruction content is completely matched with the standard instruction content, judging that the instruction content conforms to the format of a preset script instruction.
4. The data screening method based on the loca embedded window as claimed in claim 1, wherein the condition screening window includes at least one screening condition check column preset and an essential parameter filling column corresponding to the screening condition, and the receiving of the screening condition clicked by the user through the condition screening window and the input essential parameter corresponding to the screening condition includes:
obtaining the screening conditions clicked by the user through the screening condition check bar;
and acquiring the necessary parameters filled in the necessary parameter filling column.
5. The method for screening data based on the loca embedded window as claimed in claim 1, wherein the conditional screening window is set by being embedded into the business database through API of the business database according to the loca language script.
6. The method for screening data based on the loca embedded window as claimed in claim 1, wherein the step of generating the corresponding script command according to the screening condition, the necessary parameters corresponding to the screening condition and a preset association table of the screening condition and the script command comprises:
calling a script command template from the association table of the screening conditions and the script commands according to the screening conditions;
and filling the necessary parameters corresponding to the screening conditions into the script command template to generate a script command.
7. A data screening device based on a loca embedded window is characterized by comprising:
the acquisition module is used for monitoring a query button of a data query interface of a service database and acquiring the instruction content of a script command frame of the data query interface when the query button is touched or clicked;
the judging module is used for judging whether the instruction content conforms to the format of a preset script instruction or not, and popping up a condition screening window when the instruction content does not conform to the format of the preset script instruction;
the receiving module is used for receiving the screening conditions clicked by the user through the condition screening window and the input necessary parameters corresponding to the screening conditions;
the generating module is used for generating a corresponding script command according to the screening condition, the necessary parameters corresponding to the screening condition and a preset association table of the screening condition and the script command;
and the execution module is used for filling the script command into a script command box of the service database and executing the query.
8. The data screening apparatus based on loca embedded window according to claim 7, wherein the generating module is further configured to:
calling a script command template from the association table of the screening conditions and the script commands according to the screening conditions;
and filling the necessary parameters corresponding to the screening conditions into the script command template to generate a script command.
9. A computer device, characterized in that it comprises a memory, a processor, said memory having stored thereon a computer program executable on said processor, said computer program, when executed by said processor, implementing the steps of the method for data filtering based on a loca embedded window according to any one of claims 1-4.
10. A computer-readable storage medium, characterized in that it stores a computer program which is executable by at least one processor to cause the at least one processor to perform the steps of the method for data filtering based on a local embedded window according to any one of claims 1-4.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910969966.9A CN110837500B (en) | 2019-10-12 | 2019-10-12 | Data screening method and device based on socal embedded window and computer equipment |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910969966.9A CN110837500B (en) | 2019-10-12 | 2019-10-12 | Data screening method and device based on socal embedded window and computer equipment |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN110837500A true CN110837500A (en) | 2020-02-25 |
| CN110837500B CN110837500B (en) | 2023-07-14 |
Family
ID=69575307
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910969966.9A Active CN110837500B (en) | 2019-10-12 | 2019-10-12 | Data screening method and device based on socal embedded window and computer equipment |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110837500B (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112199591A (en) * | 2020-10-10 | 2021-01-08 | 何波昌 | Air ticket checking and booking method, server and medium based on social software chat window |
| CN115857890A (en) * | 2022-11-11 | 2023-03-28 | 芯华章科技(北京)有限公司 | Method, apparatus and storage medium for generating script command |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20040093344A1 (en) * | 2001-05-25 | 2004-05-13 | Ben Berger | Method and system for mapping enterprise data assets to a semantic information model |
| US20080178162A1 (en) * | 2007-01-18 | 2008-07-24 | Aol Llc | Server evaluation of client-side script |
| US20120221954A1 (en) * | 2011-02-28 | 2012-08-30 | Ricoh Company, Ltd. | Display filtering device management system |
| US20130174120A1 (en) * | 2009-04-30 | 2013-07-04 | Adobe Systems Incorporated | Context sensitive script editing for form design |
| CN109857791A (en) * | 2018-11-20 | 2019-06-07 | 成都材智科技有限公司 | A kind of batch data processing method and device |
-
2019
- 2019-10-12 CN CN201910969966.9A patent/CN110837500B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20040093344A1 (en) * | 2001-05-25 | 2004-05-13 | Ben Berger | Method and system for mapping enterprise data assets to a semantic information model |
| US20080178162A1 (en) * | 2007-01-18 | 2008-07-24 | Aol Llc | Server evaluation of client-side script |
| US20130174120A1 (en) * | 2009-04-30 | 2013-07-04 | Adobe Systems Incorporated | Context sensitive script editing for form design |
| US20120221954A1 (en) * | 2011-02-28 | 2012-08-30 | Ricoh Company, Ltd. | Display filtering device management system |
| CN109857791A (en) * | 2018-11-20 | 2019-06-07 | 成都材智科技有限公司 | A kind of batch data processing method and device |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112199591A (en) * | 2020-10-10 | 2021-01-08 | 何波昌 | Air ticket checking and booking method, server and medium based on social software chat window |
| CN112199591B (en) * | 2020-10-10 | 2023-09-26 | 何波昌 | Air ticket checking and booking method, server and medium based on social software chat window |
| CN115857890A (en) * | 2022-11-11 | 2023-03-28 | 芯华章科技(北京)有限公司 | Method, apparatus and storage medium for generating script command |
Also Published As
| Publication number | Publication date |
|---|---|
| CN110837500B (en) | 2023-07-14 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108427705B (en) | Electronic device, distributed system log query method and storage medium | |
| CN109358851B (en) | Chart component creating method and device and computer-readable storage medium | |
| CN107844634B (en) | Modeling method of multivariate general model platform, electronic equipment and computer readable storage medium | |
| CN110647471B (en) | Interface test case generation method, electronic device and storage medium | |
| CN112765023B (en) | Test case generation method and device | |
| CN110704521A (en) | Interface data access method and system | |
| CN105808701B (en) | Realize the method and system communicated between list automatic Verification and multisystem | |
| CN108415925B (en) | Electronic device, data call log generation and query method and storage medium | |
| CN111400380A (en) | Method for checking table data, electronic device and storage medium | |
| CN110837500B (en) | Data screening method and device based on socal embedded window and computer equipment | |
| CN111475401A (en) | Test method and related equipment | |
| CN113448862A (en) | Software version testing method and device and computer equipment | |
| CN113296752A (en) | Method, system, device and storage medium for generating API document | |
| CN112001707A (en) | Business workflow generation method and system based on business data | |
| CN112181836A (en) | Test case generation method, system, device and storage medium | |
| CN112527286A (en) | Service code generation method and device, computer equipment and storage medium | |
| CN110166530B (en) | Processing method based on micro-service return value, electronic device and computer equipment | |
| CN111552712A (en) | Report data extraction method and device and computer equipment | |
| CN115617780A (en) | Data import method, device, equipment and storage medium | |
| CN115657899A (en) | Icon processing method and device, electronic equipment and storage medium | |
| CN112148597B (en) | Method for eliminating iOS device authorization dialog box, test method and storage medium | |
| CN112306473B (en) | Program interface parameter transmission method, system and related equipment | |
| CN110825795B (en) | Method, apparatus, device and computer readable storage medium for accessing database | |
| CN113761005A (en) | Metadata configuration method and device, electronic equipment and storage medium | |
| CN108415922B (en) | Database modification method and application server |
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 |