CN107908628B - Electronic device, information inquiry control method, and computer-readable storage medium - Google Patents

Electronic device, information inquiry control method, and computer-readable storage medium Download PDF

Info

Publication number
CN107908628B
CN107908628B CN201710440290.5A CN201710440290A CN107908628B CN 107908628 B CN107908628 B CN 107908628B CN 201710440290 A CN201710440290 A CN 201710440290A CN 107908628 B CN107908628 B CN 107908628B
Authority
CN
China
Prior art keywords
information
input
query
displayed
batch
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
CN201710440290.5A
Other languages
Chinese (zh)
Other versions
CN107908628A (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.)
OneConnect Smart Technology Co Ltd
Original Assignee
OneConnect Financial Technology Co Ltd Shanghai
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 OneConnect Financial Technology Co Ltd Shanghai filed Critical OneConnect Financial Technology Co Ltd Shanghai
Priority to CN201710440290.5A priority Critical patent/CN107908628B/en
Publication of CN107908628A publication Critical patent/CN107908628A/en
Application granted granted Critical
Publication of CN107908628B publication Critical patent/CN107908628B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/90Details of database functions independent of the retrieved data types
    • G06F16/903Querying
    • G06F16/9038Presentation of query results
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/90Details of database functions independent of the retrieved data types
    • G06F16/903Querying
    • G06F16/90335Query processing
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/90Details of database functions independent of the retrieved data types
    • G06F16/904Browsing; Visualisation therefor

Landscapes

  • Engineering & Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Theoretical Computer Science (AREA)
  • Data Mining & Analysis (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Computational Linguistics (AREA)
  • User Interface Of Digital Computer (AREA)

Abstract

The invention discloses an electronic device, an information query control method and a computer readable storage medium, wherein the method comprises the following steps: when a batch query instruction is received, generating a user operation interface comprising preset items to be queried; after receiving the items to be inquired selected by the user, respectively determining the input information names corresponding to the selected items to be inquired; determining input information names to be displayed in a form, generating a batch information input form template according to each determined input information name to be displayed in the form and a preset rule; after receiving batch query information input by a user, splitting the received batch query information into one or more single query information; and acquiring query result data corresponding to each single piece of query information from a predetermined database, and generating a query result report of each single piece of query information corresponding to each selected item to be queried. The scheme of the invention realizes the quick query of a large number of data products of a plurality of objects.

Description

Electronic device, information inquiry control method, and computer-readable storage medium
Technical Field
The present invention relates to the field of information query technologies, and in particular, to an electronic device, an information query control method, and a computer-readable storage medium.
Background
At present, data products in the market can only be inquired in a one-to-one targeted manner, one data product can only be inquired for one object at a time, when a large number of data products of a large number of inquired objects need to be inquired, a large number of times of inquiry is needed, and related information needs to be input again in each inquiry, so that the inquiry workload is very large, a large amount of time is spent, and the condition of information input error is easy to occur; therefore, it is urgently needed to provide a scheme for rapidly querying a large amount of data products of a plurality of objects.
Disclosure of Invention
The invention mainly aims to provide an information query control method, aiming at realizing the quick information query of a large number of data products aiming at a plurality of objects.
In order to achieve the above object, the electronic device provided in the present invention includes a memory, a processor, and an information query control system stored in the memory and capable of running on the processor, wherein the information query control system, when executed by the processor, implements the following steps:
a1, when receiving a batch query instruction, the information query control system generates a user operation interface including preset items to be queried, wherein the user operation interface includes selection items corresponding to the items to be queried;
a2, after receiving the items to be queried selected by the user based on the user operation interface, the information query control system respectively determines the input information names corresponding to the selected items to be queried according to the predetermined mapping relation between the items to be queried and the input information names;
a3, the information query control system determines the input information name to be displayed in a form in each determined input information name, and the information query control system generates a batch information input form template according to each determined input information name to be displayed in the form and a preset rule;
a4, after receiving batch query information input by a user based on the batch information input form template, splitting the received batch query information into one or more single query information by the information query control system;
a5, obtaining the query result data corresponding to each single query message from the predetermined database, and generating the query result report of each single query message corresponding to each selected item to be queried according to the query result data corresponding to each single query message.
Preferably, the step a3 includes:
the information query control system analyzes whether repeated input information names exist in the determined input information names;
if the repeated input information names exist, the information query control system reserves one repeated input information name, deletes other repeated input information names, and uses the reserved input information name and the input information name which does not exist in a repeated way as the input information name to be displayed in the form, or if the repeated input information name does not exist, the information query control system uses each determined input information name as the input information name to be displayed in the form;
and the information query control system generates a batch information input form template according to each determined input information name to be displayed in a form and a preset rule.
Preferably, between the step a4 and the step a5, the processor is further configured to execute the information query control system to implement the steps of:
the information query control system analyzes whether repeated single query information exists in all the single query information obtained by splitting;
and when the repeated single query information exists, one repeated single query information is reserved, and other repeated single query information is deleted.
Preferably, the preset rule is:
displaying the input information names to be displayed in the same row or column in the batch information input form template according to a random sequence, or finding out the sequencing priority corresponding to the input information names to be displayed in the form according to a mapping relation between the input information names and the sequencing priority, and displaying the input information names to be displayed in the form in the same column or the same row in the batch information input form template according to the corresponding sequencing priority sequence;
the table items corresponding to the input information names displayed in the batch information input table template comprise a plurality of blank table items to be input with information;
if the input information names to be displayed in the forms are displayed in the same column in the batch information input form template, each blank form item included under the form item corresponding to the input information name to be displayed in the forms is in the same row as the form item corresponding to the input information name to be displayed in the forms;
if the input information names to be displayed in the form are displayed in the same row in the batch information input form template, each blank form item included under the form item corresponding to the input information name to be displayed in the form is in the same column as the form item corresponding to the input information name to be displayed in the form.
Preferably, the step a4 includes:
after receiving batch query information input by a user based on the batch information input form template, if the input information names to be displayed in each form are displayed in the same column in the batch information input form template, the information query control system divides the query information input in the blank form items in the same column as a single piece of query information, and divides the query information input in the blank form items in different columns as different single pieces of query information;
after receiving batch query information input by a user based on the batch information input form template, if the input information names to be displayed in each form are displayed in the same row in the batch information input form template, the information query control system divides the query information input in the blank form items in the same row as a single piece of query information, and divides the query information input in the blank form items in different rows as different single pieces of query information.
The invention also provides an information query control method, which comprises the following steps:
a1, when receiving a batch query instruction, the information query control system generates a user operation interface including preset items to be queried, wherein the user operation interface includes selection items corresponding to the items to be queried;
a2, after receiving the items to be queried selected by the user based on the user operation interface, the information query control system respectively determines the input information names corresponding to the selected items to be queried according to the predetermined mapping relation between the items to be queried and the input information names;
a3, the information query control system determines the input information name to be displayed in a form in each determined input information name, and the information query control system generates a batch information input form template according to each determined input information name to be displayed in the form and a preset rule;
a4, after receiving batch query information input by a user based on the batch information input form template, splitting the received batch query information into one or more single query information by the information query control system;
a5, obtaining the query result data corresponding to each single query message from the predetermined database, and generating the query result report of each single query message corresponding to each selected item to be queried according to the query result data corresponding to each single query message.
Preferably, the step a3 includes:
the information query control system analyzes whether repeated input information names exist in the determined input information names;
if the repeated input information names exist, the information query control system reserves one repeated input information name, deletes other repeated input information names, and uses the reserved input information name and the input information name which does not exist in a repeated way as the input information name to be displayed in the form, or if the repeated input information name does not exist, the information query control system uses each determined input information name as the input information name to be displayed in the form;
and the information query control system generates a batch information input form template according to each determined input information name to be displayed in a form and a preset rule.
Preferably, the preset rule is:
displaying the input information names to be displayed in the same row or column in the batch information input form template according to a random sequence, or finding out the sequencing priority corresponding to the input information names to be displayed in the form according to a mapping relation between the input information names and the sequencing priority, and displaying the input information names to be displayed in the form in the same column or the same row in the batch information input form template according to the corresponding sequencing priority sequence;
the table items corresponding to the input information names displayed in the batch information input table template comprise a plurality of blank table items to be input with information;
if the input information names to be displayed in the forms are displayed in the same column in the batch information input form template, each blank form item included under the form item corresponding to the input information name to be displayed in the forms is in the same row as the form item corresponding to the input information name to be displayed in the forms;
if the input information names to be displayed in the form are displayed in the same row in the batch information input form template, each blank form item included under the form item corresponding to the input information name to be displayed in the form is in the same column as the form item corresponding to the input information name to be displayed in the form.
Preferably, the step a4 includes:
after receiving batch query information input by a user based on the batch information input form template, if the input information names to be displayed in each form are displayed in the same column in the batch information input form template, the information query control system divides the query information input in the blank form items in the same column as a single piece of query information, and divides the query information input in the blank form items in different columns as different single pieces of query information;
after receiving batch query information input by a user based on the batch information input form template, if the input information names to be displayed in each form are displayed in the same row in the batch information input form template, the information query control system divides the query information input in the blank form items in the same row as a single piece of query information, and divides the query information input in the blank form items in different rows as different single pieces of query information.
The present invention also provides a computer-readable storage medium storing an information query control system, which is executable by at least one processor, so that the at least one processor executes any one of the above information query control methods.
The technical scheme of the invention can select a plurality of items to be inquired (such as data products) at one time, and the user fills in the inquiry information of a plurality of inquiry objects by generating the batch information input form template, then the user acquires the inquiry result data according to each single inquiry information split from the batch information input form template, and generates the inquiry result report according to the inquiry result data acquired by each single inquiry information, namely the inquiry result report of each inquiry object about each selected item to be inquired is respectively obtained, so that the user completes the inquiry result report of a plurality of selected items to be inquired (equivalent to a plurality of types of data products) of a plurality of objects by one-time inquiry. Compared with the prior art, the technical scheme of the invention can complete the query of multiple data products of multiple query objects by only one query, and the user only needs to complete the input of one query message, thereby greatly improving the query speed and convenience.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, it is obvious that the drawings in the following description are only some embodiments of the present invention, and for those skilled in the art, other drawings can be obtained according to the structures shown in the drawings without creative efforts.
FIG. 1 is a flowchart illustrating an information query control method according to an embodiment of the present invention;
FIG. 2 is a flowchart illustrating a second embodiment of an information query control method according to the present invention;
FIG. 3 is a schematic diagram of an operating environment of an embodiment of an information query control system according to the present invention;
FIG. 4 is a schematic structural diagram of an embodiment of an information query control system according to the present invention;
FIG. 5 is a schematic structural diagram of a second generation module in FIG. 4;
FIG. 6 is a schematic structural diagram of the splitting module in FIG. 4;
FIG. 7 is a diagram illustrating an embodiment of a UI including a predetermined item to be queried.
The implementation, functional features and advantages of the objects of the present invention will be further explained with reference to the accompanying drawings.
Detailed Description
The principles and features of this invention are described below in conjunction with the following drawings, which are set forth by way of illustration only and are not intended to limit the scope of the invention.
As shown in fig. 1, fig. 1 is a schematic flow chart of an information query control method according to an embodiment of the present invention.
In this embodiment, the information query control method includes:
step S10, when the information inquiry control system receives the batch inquiry command, generating a user operation interface including preset items to be inquired, wherein the user operation interface includes a selection item corresponding to each item to be inquired;
after the user selects the batch query function, the information query control system enters a flow of the batch query function to generate a user operation interface, where the user operation interface includes preset items to be queried (e.g., good credibility 21, good communication address 22, mobile phone query 23, good communication bank score 24, etc. in the user operation interface shown in fig. 7), the user operation interface includes an item selection area to be queried, the item selection area to be queried includes each item to be queried and a corresponding selection item 25 (refer to fig. 7) thereof, and is used for the user to select, and the user can select one or more items to be queried at a time.
Step S20, after receiving the items to be inquired selected by the user based on the user operation interface, the information inquiry control system respectively determines the input information name corresponding to each selected item to be inquired according to the predetermined mapping relation between the items to be inquired and the input information names;
the information query control system queries the information data of each item to be queried according to query information input by a user, wherein the input information name is an attribute name of corresponding query information, namely the input information name indicates which query information needs to be input by the user; for example, the input information name of the query information "zhang san" is a name, the input information name of the query information "465312 × 3254" is a certificate number, the input information name of the query information "3845I 6NE712SU 2C" is an authorization code, and so on. The information query control system is provided with a mapping relation table of items to be queried and input information names, when a user selects an item to be queried on the user operation interface, the information query control system receives the item to be queried selected by the user, and obtains the input information name corresponding to each item to be queried selected by the user according to the predetermined mapping relation between the item to be queried and the input information name (for example, X1 items to be queried correspond to three input information names a, b and c; X2 items to be queried correspond to two input information names b and d; and X3 items to be queried correspond to four input information names c, d, e and f).
Step S30, the information inquiry control system determines the input information name to be displayed in the form in each determined input information name, and generates a batch information input form template according to the determined input information name to be displayed in the form and the preset rule;
repeated input information names may exist in the input information names corresponding to the selected items to be queried determined according to the mapping relation table, so that a large amount of repeated input operation is performed when a subsequent user inputs query information, and the input burden of the user is increased; therefore, the information query control system performs deduplication processing on each determined input information name to determine the input information name to be tabular displayed. After the input information name representing the display is determined, the information query control system generates a batch information input form template according to the input information name to be displayed and determined by each form according to a preset rule for a user to input. The system comprises a batch information input form template, a form class file (for example, an excel form), wherein each determined input information name to be displayed in a form is displayed in the batch information input form template, and a user correspondingly inputs each query information at a corresponding position according to the distribution position of each input information name in the batch information input form template.
Step S40, after receiving batch inquiry information input by a user based on the batch information input form template, the information inquiry control system splits the received batch inquiry information into one or more single inquiry information;
the information query control system can directly generate a display area on the user operation interface to display the batch information input form template (or the information query control system can additionally generate a window to display the batch information input form template), and after a user can directly fill the batch information input form template on line and click through a 'completion' function key arranged on the user operation interface, the information query control system can store the filled batch information input form template, so that batch query information input by the user based on the batch information form template is received; in addition, the user can download and store the batch information input form template to the terminal, and after the completion of filling, the filled batch information form template is uploaded to the information query control system according to the uploading function on the user operation interface, so that the information query control system can receive the batch query information input by the user based on the batch information form template. The information query control system divides the received batch query information input into the batch query information in the form template into one or more single query information, and the single query information is the query information required by the information query control system for querying the selected item to be queried. Each single query message comprises a plurality of query messages, the query messages are in one-to-one correspondence with the input message names shown in the batch message input form template, and each single query message is the query message of a query object. When a user only inputs one query message for each input message name in a batch message input form template, the split query message is a single query message; when the user correspondingly inputs a plurality of query information for each input information name in the batch information input form template, the information query control system can divide the received batch query information into a plurality of single query information.
Step S50, obtaining query result data corresponding to each single query message from a predetermined database, and generating a query result report corresponding to each single query message and each selected item to be queried according to the query result data corresponding to each single query message.
The information query control system acquires query result data according to each piece of query information, wherein the query result data comprises query result data corresponding to each selected item to be queried; and the information query control system generates a query result report aiming at the query result data corresponding to each single piece of query information. Each query result report can be displayed on the user operation interface, and a result display area can be arranged on the user operation interface for displaying the query result reports. The information inquiry control system can provide the functions of downloading or printing the inquiry result report and the like on the user operation interface, so that the user can download or print the inquiry result report.
The information query control method of this embodiment can select a plurality of items to be queried (e.g., data products) at one time, and generate a batch information input form template for a user to fill in query information of a plurality of query objects, then obtain query result data according to each piece of query information split from the batch information input form template, and generate a query result report according to the query result data obtained by each piece of query information, that is, obtain query result reports on the selected items to be queried of each query object, respectively, so that the user completes the query result reports on the selected items to be queried (equivalent to a plurality of types of data products) of the plurality of objects through one-time query. Compared with the prior art, the technical scheme of the invention can complete the query of multiple data products of multiple query objects by only one query, and the user only needs to complete the input of one query message, thereby greatly improving the query speed and convenience.
As shown in fig. 2, fig. 2 is a schematic flow chart of a second embodiment of the information query control method of the present invention. The present embodiment is based on an embodiment, and in this embodiment, the step S30 includes:
step S301, the information query control system analyzes whether repeated input information names exist in the determined input information names;
repeated input information names may exist in the input information names corresponding to the selected items to be inquired and determined according to the mapping relation table; for example, the items to be queried selected by the user are X1 and X2, wherein the X1 items to be queried correspond to three information input boxes a, b and c; x2 item to be inquired corresponds to two information input boxes of b and d; the b information input box is the information input box in which the duplication exists. The repeated input information names can display the repeated input information names in the batch information input form template, so that a large amount of repeated input operation is performed when a subsequent user inputs query information, the repeated input operation has no practical significance, and only the input workload of the user is increased.
Step S302, if the repeated input information names exist, the information query control system reserves one repeated input information name, deletes other repeated input information names, and the reserved input information name and the input information name which does not exist are used as the input information name to be displayed in the form, or if the repeated input information names do not exist, the information query control system takes each determined input information name as the input information name to be displayed in the form;
after analysis, if the repeated input information names are obtained, the information query control system deletes each group of repeated input information names in an alternative mode, namely, one input information name is selected and reserved for each group of repeated input information names, other repeated input information names of the group are deleted, and the reserved input information name and the input information name which is not repeated in each group are selected and used as the input information name to be displayed in the form. And analyzing by the information query control system, and if the repeated input information names do not exist, taking all the determined input information names as the input information names representing all the displays.
Step S303, the information query control system generates a batch information input form template according to the input information name to be displayed and the preset rule.
And after analyzing and repeating the determined input information name to obtain the input information name to be displayed, the information query control system generates a batch information input form template according to a preset rule.
According to the method and the device, the input information names are enabled not to be repeatedly displayed in the batch information input form template through the de-duplication processing of the input information names, and the condition of extra input quantity caused to a user is avoided.
Preferably, in this embodiment, between the step S40 and the step S50, the information query control method further includes:
the information query control system analyzes whether repeated single query information exists in all the single query information obtained by splitting;
because a user can easily repeatedly input a single query message twice or more in the process of inputting a large amount of query messages, the query result data obtained by the information query control system according to the repeated single query message query is the same, which has no meaning for the user, and the information query control system usually charges according to the number of the query messages, the repeated single query message input can cause repeated calculation of the query cost, and the payment cost of the user is higher than the cost required by actual query. Therefore, the information query control system of the embodiment analyzes the single query information obtained by splitting before querying the result data to determine whether the repeated single query information exists.
And when the repeated single query information exists, one repeated single query information is reserved, and other repeated single query information is deleted.
When the repeated single query information is obtained through analysis, one repeated single query information is reserved, and the rest are deleted repeatedly, so that the condition that the information query control system performs repeated query on a certain single query information is avoided, and the condition of mischarge is prevented.
When there is no repeated single query message, the subsequent steps are continued.
Preferably, in the above embodiment, the preset rule is:
displaying the input information names to be displayed in the same row or column in the batch information input form template according to a random sequence, or finding out the sequencing priority corresponding to the input information names to be displayed in the form according to a mapping relation between the input information names and the sequencing priority, and displaying the input information names to be displayed in the form in the same column or the same row in the batch information input form template according to the corresponding sequencing priority sequence;
the table items corresponding to the input information names displayed in the batch information input table template comprise a plurality of blank table items to be input with information;
if the input information names to be displayed in the form are displayed in the same column in the batch information input form template, each blank form item included under the form item corresponding to the input information name to be displayed in the form is in the same row as the form item corresponding to the input information name to be displayed in the form. See, for example, table 1 below:
a x x x x
b y y y y
c z z z z
d w w w w
TABLE 1
In table 1 above, the 4 input information to be tabulated and displayed, that is, a, b, c, d, are in the same column, then the blank table item included under the table item corresponding to a is x in the table, the blank table item included under the table item corresponding to b is y, the blank table item included under the table item corresponding to c is z, the blank table item included under the table item corresponding to d is w, where x, y, z, w only refer to the position of the blank table item.
If the input information names to be displayed in the form are displayed in the same row in the batch information input form template, each blank form item included under the form item corresponding to the input information name to be displayed in the form is in the same column as the form item corresponding to the input information name to be displayed in the form. See, for example, table 2 below:
a b c d
x y z w
x y z w
x y z w
x y z w
TABLE 2
In table 2, a, b, c, and d are 4 input information to be tabulated and displayed in the same row, then a corresponding table entry includes a blank table entry x, b corresponds to a table entry includes a blank table entry y, c corresponds to a table entry includes a blank table entry z, d corresponds to a table entry includes a blank table entry w, where x, y, z, and w refer to only the position of the blank table entry.
Preferably, in this embodiment, the step S40 includes:
after receiving batch query information input by a user based on the batch information input form template, if the input information names to be displayed in each form are displayed in the same column in the batch information input form template, the information query control system divides the query information input in the blank form items in the same column as a single piece of query information, and divides the query information input in the blank form items in different columns as different single pieces of query information;
see, for example, table 3 below:
a x1 x2 x3 x4
b y1 y2 y3 y4
c z1 z2 z3 z4
d w1 w2 w3 w4
TABLE 3
In table 3, if the 4 input information names a, b, c, and d are in the same column of the batch information input table template, the query information input in the blank table entries in different columns is regarded as different single pieces of information, and the split single pieces of query information are x1y1z1w1, x2y2z2w2, x3y3z3w3, and x4y4z4w4, respectively.
After receiving batch query information input by a user based on the batch information input form template, if the input information names to be displayed in each form are displayed in the same row in the batch information input form template, the information query control system divides the query information input in the blank form items in the same row as a single piece of query information, and divides the query information input in the blank form items in different rows as different single pieces of query information.
See, for example, table 4 below:
a b c d
x1 y1 z1 w1
x2 y2 z2 w2
x3 y3 z3 w3
x4 y4 z4 w4
TABLE 4
In table 4, the 4 input information names a, b, c, and d are in the same row in the batch information input form template, and the query information input in the blank form items in different rows is taken as different single pieces of information, and the split single pieces of query information are x1y1z1w1, x2y2z2w2, x3y3z3w3, and x4y4z4w4, respectively.
The invention also provides an information query control system.
Please refer to fig. 3, which is a schematic diagram illustrating an operating environment of the system 10 according to a preferred embodiment of the present invention.
In the present embodiment, the information inquiry control system 10 is installed and operated in the electronic apparatus 1. The electronic device 1 may be a desktop computer, a notebook, a palm computer, a server, or other computing equipment. The electronic device 1 may include, but is not limited to, a memory 11, a processor 12, and a display 13. Fig. 3 only shows the electronic device 1 with components 11-13, but it is to be understood that not all of the shown components are required to be implemented, and that more or fewer components may alternatively be implemented.
The memory 11 may in some embodiments be an internal storage unit of the electronic device 1, such as a hard disk or a memory of the electronic device 1. The memory 11 may also be an external storage device of the electronic apparatus 1 in other embodiments, such as a plug-in hard disk provided on the electronic apparatus 1, a Smart Media Card (SMC), a Secure Digital (SD) Card, a Flash memory Card (Flash Card), and the like. Further, the memory 11 may also include both an internal storage unit and an external storage device of the electronic apparatus 1. The memory 11 is used for storing application software installed in the electronic device 1 and various data, such as program codes of the information query control system 10. The memory 11 may also be used to temporarily store data that has been output or is to be output.
Processor 12, which in some embodiments may be a Central Processing Unit (CPU), microprocessor or other data Processing chip, executes program code stored in memory 11 or processes data, such as executing kiosk control system 10.
The display 13 may be an LED display, a liquid crystal display, a touch-sensitive liquid crystal display, an OLED (Organic Light-Emitting Diode) touch panel, or the like in some embodiments. The display 13 is used for displaying information processed in the electronic apparatus 1 and for displaying a visualized user interface, such as a service customization interface or the like. The components 11-13 of the electronic device 1 communicate with each other via a system bus.
Please refer to fig. 4, which is a functional block diagram of the system 10 for controlling information query according to a preferred embodiment of the present invention. In this embodiment, the information query control system 10 may be divided into one or more modules, and the one or more modules are stored in the memory 11 and executed by one or more processors (in this embodiment, the processor 12) to complete the present invention. For example, in fig. 4, the information query control system 10 may be divided into a first generation module 101, a determination module 102, a second generation module 103, a splitting module 104, and a query module 105. The module referred to in the present invention refers to a series of computer program instruction segments capable of performing specific functions, and is more suitable than a program for describing the execution process of the information query control system 10 in the electronic device 1, wherein:
the system comprises a first generation module 101, configured to generate, when a batch query instruction is received, a user operation interface including preset items to be queried (e.g., a good credibility address, a mobile phone query, a good credibility bank score, etc.), where the user operation interface includes a selection item corresponding to each item to be queried (e.g., the user operation interface includes an item selection area to be queried, and the item selection area to be queried includes each item to be queried and a selection item corresponding to the item to be queried);
after the user selects the batch query function, the information query control system 10 enters the flow of the batch query function, the first generation module 101 generates a user operation interface, the user operation interface includes preset items to be queried (for example, the confidence level 21, the credit address 22, the mobile phone query 23, the credit bank score 24, and the like in the user operation interface shown in fig. 7), the user operation interface includes an item selection area to be queried, the item selection area to be queried includes each item to be queried and a corresponding selection item 25 (refer to fig. 7) thereof, and the user can select one or more items to be queried at a time.
A determining module 102, configured to, after receiving an item to be queried selected by a user based on the user operation interface, respectively determine, according to a mapping relationship between a predetermined item to be queried and input information names (e.g., name, authorization code, certificate number, etc.), input information names (e.g., three input information names a, b, and c corresponding to the item to be queried X1; two input information names b and d corresponding to the item to be queried X2; four input information names c, d, e, and f corresponding to the item to be queried X3);
the information query control system 10 queries the information data of each item to be queried according to query information input by a user, wherein the input information name is an attribute name of the corresponding query information, that is, the input information name indicates which query information the user needs to input; for example, the input information name of the query information "zhang san" is a name, the input information name of the query information "465312 × 3254" is a certificate number, the input information name of the query information "3845I 6NE712SU 2C" is an authorization code, and so on. The information query control system 10 has a mapping relationship table of items to be queried and names of input information, and when a user selects an item to be queried on the user operation interface, the determining module 102 receives the item to be queried selected by the user, and obtains the name of the input information corresponding to each item to be queried selected by the user according to a predetermined mapping relationship between the item to be queried and the name of the input information (for example, X1 corresponds to three names of a, b, and c of the input information for the item to be queried; X2 corresponds to two names of b and d of the input information for the item to be queried; and X3 corresponds to four names of c, d, e, and f of the input information for the item to be queried).
The second generation module 103 is configured to determine input information names to be displayed in a form from the determined input information names, generate a batch information input form template according to the determined input information names to be displayed in the form, and according to a preset rule;
repeated input information names may exist in the input information names corresponding to the selected items to be queried determined according to the mapping relation table, so that a large amount of repeated input operation is performed when a subsequent user inputs query information, and the input burden of the user is increased; therefore, the second generating module 103 performs a de-duplication process on each determined input information name to determine the input information name to be tabular displayed. After the input information name representing the display is determined, the second generation module 103 generates a batch information input form template according to the determined input information name to be form-displayed and a preset rule for the user to input. The system comprises a batch information input form template, a form class file (for example, an excel form), wherein each determined input information name to be displayed in a form is displayed in the batch information input form template, and a user correspondingly inputs each query information at a corresponding position according to the distribution position of each input information name in the batch information input form template.
The splitting module 104 is configured to split the received batch query information into one or more single query information after receiving the batch query information input by the user based on the batch information input form template;
the information query control system 10 may directly generate a display area on the user operation interface to display the batch information input form template (or the information query control system 10 may additionally generate a window to display the batch information input form template), and after the user directly fills in the batch information input form template on line, the user may click through a "complete" function key set on the user operation interface, and then the information query control system 10 may store the filled batch information input form template, thereby receiving the batch query information input by the user based on the batch information form template; in addition, the user may download and store the batch information input form template to the terminal, and after completion of filling, upload the filled batch information form template to the information query control system 10 according to the upload function on the user operation interface, so that the information query control system 10 receives the batch query information input by the user based on the batch information form template. The splitting module 104 splits the received batch query information input into the batch query information in the form template into one or more single query information, where the single query information is the query information required by the information query control system 10 to query the selected item to be queried. Each single query message comprises a plurality of query messages, the query messages are in one-to-one correspondence with the input message names shown in the batch message input form template, and each single query message is the query message of a query object. When a user only inputs one query message for each input message name in the batch message input form template, the splitting module 104 splits the input message into a single query message; when a user correspondingly inputs a plurality of query information for each input information name in the batch information input form template, the splitting module 104 may split the received batch query information into a plurality of single query information.
The query module 105 is configured to obtain query result data corresponding to each piece of query information from a predetermined database, and generate a query result report corresponding to each piece of query information and each selected item to be queried according to the query result data corresponding to each piece of query information.
The query module 105 obtains query result data according to each piece of query information, where the query result data includes query result data corresponding to each selected item to be queried; the query module 105 generates a query result report for the query result data corresponding to each single piece of query information. Each query result report can be displayed on the user operation interface, and a result display area can be arranged on the user operation interface for displaying the query result reports. The information query control system 10 may provide functions of downloading or printing the query result report on the user operation interface, so as to provide the user with downloading or printing the query result report.
The information query control system 10 of this embodiment can select a plurality of items to be queried (e.g., data products) at a time, and generate a batch information input form template for a user to fill in query information of a plurality of query objects, then obtain query result data according to each piece of query information split from the batch information input form template, and generate query result reports according to the query result data obtained by each piece of query information, that is, obtain query result reports on each selected item to be queried of each query object, so that the user completes query result reports on a plurality of selected items to be queried (equivalent to a plurality of data products) of the plurality of objects through one-time query. Compared with the prior art, the technical scheme of the invention can complete the query of multiple data products of multiple query objects by only one query, and the user only needs to complete the input of one query message, thereby greatly improving the query speed and convenience.
Preferably, as shown in fig. 5, the second generating module 103 includes:
an analysis unit 1031 for analyzing whether there is a duplicate input information name in the determined input information names;
repeated input information names may exist in the input information names corresponding to the selected items to be inquired and determined according to the mapping relation table; for example, the items to be queried selected by the user are X1 and X2, wherein the X1 items to be queried correspond to three information input boxes a, b and c; x2 item to be inquired corresponds to two information input boxes of b and d; the b information input box is the information input box in which the duplication exists. The repeated input information names may show the repeated input information names in the batch information input form template, which may cause a large amount of repeated input operations to be performed when the subsequent user inputs query information, and the repeated input operations have no practical meaning, and only may increase the input workload of the user, so that the information query control system 10 may analyze whether the determined input information names have the repeated input information names through the analysis unit 1031 before generating the batch information input form template.
A deduplication unit 1032, configured to reserve one duplicated input information name and delete other duplicated input information names when there are duplicated input information names, where the reserved input information name and the input information name that does not have duplication are used as input information names to be displayed in a form, or, when there are no duplicated input information names, each determined input information name is used as an input information name to be displayed in a form;
if the analysis unit 1031 analyzes that there are duplicate input information names, the deduplication unit 1032 deletes each duplicate input information name in an alternative manner, that is, selects one of the duplicate input information names for each duplicate input information name, deletes the other duplicate input information names of the duplicate input information name, and selects the retained input information name and the input information name without duplication in each duplicate input information name as the input information name to be displayed in the form. If the analyzing unit 1031 analyzes that there is no duplicate input information name, the deduplication unit 1032 sets all the determined input information names as the input information names representing the respective presentations.
The generating unit 1033 is configured to generate a batch information input form template according to each determined input information name to be displayed in a form and according to a preset rule.
After the information query control system 10 analyzes and repeats the determined input information name to obtain the input information name to be displayed in the form, the generation unit 1033 generates the batch information input form template according to the preset rule.
According to the method and the device, the input information names are enabled not to be repeatedly displayed in the batch information input form template through the de-duplication processing of the input information names, and the condition of extra input quantity caused to a user is avoided.
Preferably, the information query control system 10 further includes:
and the duplication removing module is used for analyzing whether the single duplicated query information exists in all the single query information obtained by splitting, and when the single duplicated query information exists, one of the single duplicated query information is reserved, and other single duplicated query information is deleted.
Since it is easy for a user to repeatedly input a single query message twice or more in the process of inputting a large amount of query messages, and the query result data obtained by the information query control system 10 according to the repeated single query message query is the same, which has no meaning to the user, the information query control system 10 usually charges according to the number of query messages, and thus, the repeated single query message input may cause repeated calculation of the query fee, resulting in the payment fee of the user being higher than the fee required by the actual query. Therefore, before querying result data, the information query control system 10 of this embodiment analyzes the single query information obtained by splitting through the duplication elimination module to determine whether there is repeated single query information, and deletes the repeated single query information in an alternative retention manner when it is determined that there is repeated single query information, that is, retains one piece of repeated single query information for each group of repeated single query information, and deletes other pieces of repeated single query information of the group. When it is confirmed that there is no repeated single query information, the subsequent process of querying the result data may be entered.
Preferably, the preset rule is:
displaying the input information names to be displayed in the same row or column in the batch information input form template according to a random sequence, or finding out the sequencing priority corresponding to the input information names to be displayed in the form according to a mapping relation between the input information names and the sequencing priority, and displaying the input information names to be displayed in the form in the same column or the same row in the batch information input form template according to the corresponding sequencing priority sequence;
the table items corresponding to the input information names displayed in the batch information input table template comprise a plurality of blank table items to be input with information;
if the input information names to be displayed in the form are displayed in the same column in the batch information input form template, each blank form item included under the form item corresponding to the input information name to be displayed in the form is in the same row as the form item corresponding to the input information name to be displayed in the form. See, for example, table 1 below:
a x x x x
b y y y y
c z z z z
d w w w w
TABLE 1
In table 1 above, the 4 input information to be tabulated and displayed, that is, a, b, c, d, are in the same column, then the blank table item included under the table item corresponding to a is x in the table, the blank table item included under the table item corresponding to b is y, the blank table item included under the table item corresponding to c is z, the blank table item included under the table item corresponding to d is w, where x, y, z, w only refer to the position of the blank table item.
If the input information names to be displayed in the form are displayed in the same row in the batch information input form template, each blank form item included under the form item corresponding to the input information name to be displayed in the form is in the same column as the form item corresponding to the input information name to be displayed in the form. See, for example, table 2 below:
a b c d
x y z w
x y z w
x y z w
x y z w
TABLE 2
In table 2, a, b, c, and d are 4 input information to be tabulated and displayed in the same row, then a corresponding table entry includes a blank table entry x, b corresponds to a table entry includes a blank table entry y, c corresponds to a table entry includes a blank table entry z, d corresponds to a table entry includes a blank table entry w, where x, y, z, and w refer to only the position of the blank table entry.
Preferably, as shown in fig. 6, the splitting module 104 includes:
the first splitting unit 1041, configured to, after receiving batch query information input by a user based on the batch information input form template, if the input information names to be displayed in each form are displayed in the same column of the batch information input form template, split the query information input in the blank form items in the same column as a single piece of query information by the information query control system 10, and split the query information input in the blank form items in different columns as different single pieces of query information;
see, for example, table 3 below:
a x1 x2 x3 x4
b y1 y2 y3 y4
c z1 z2 z3 z4
d w1 w2 w3 w4
TABLE 3
In table 3, if the 4 input information names a, b, c, and d are in the same column of the batch information input table template, the query information input in the blank table entries in different columns is regarded as different single pieces of information, and the split single pieces of query information are x1y1z1w1, x2y2z2w2, x3y3z3w3, and x4y4z4w4, respectively.
The second splitting unit 1042 is configured to, after receiving batch query information input by a user based on the batch information input form template, split query information input in blank form items in the same row as a single piece of query information and split query information input in blank form items in different rows as different single pieces of query information if the input information name to be displayed by each form is displayed in the same row in the batch information input form template.
See, for example, table 4 below:
a b c d
x1 y1 z1 w1
x2 y2 z2 w2
x3 y3 z3 w3
x4 y4 z4 w4
TABLE 4
In table 4, the 4 input information names a, b, c, and d are in the same row in the batch information input form template, and the query information input in the blank form items in different rows is taken as different single pieces of information, and the split single pieces of query information are x1y1z1w1, x2y2z2w2, x3y3z3w3, and x4y4z4w4, respectively.
The above description is only a preferred embodiment of the present invention, and is not intended to limit the scope of the present invention, and all modifications and equivalents of the present invention, which are made by the contents of the present specification and the accompanying drawings, or directly/indirectly applied to other related technical fields, are included in the scope of the present invention.

Claims (8)

1. An electronic device comprising a memory, a processor, and an information query control system stored on the memory and operable on the processor, wherein the information query control system when executed by the processor performs the steps of:
a1, when receiving a batch query instruction, the information query control system generates a user operation interface including preset items to be queried, wherein the user operation interface includes selection items corresponding to the items to be queried;
a2, after receiving the items to be queried selected by the user based on the user operation interface, the information query control system respectively determines the input information names corresponding to the selected items to be queried according to the predetermined mapping relation between the items to be queried and the input information names;
a3, the information query control system determines input information names to be displayed in a form in each determined input information name, the information query control system generates a batch information input form template according to each determined input information name to be displayed in the form and a preset rule, and the batch information input form template comprises an excel form;
a4, after receiving batch query information input by a user based on the batch information input form template, splitting the received batch query information into one or more single query information by the information query control system;
a5, obtaining query result data corresponding to each single piece of query information from a predetermined database, and generating a query result report of each single piece of query information corresponding to each selected item to be queried according to the query result data corresponding to each single piece of query information;
wherein the step A3 includes:
the information query control system analyzes whether repeated input information names exist in the determined input information names;
if the repeated input information names exist, the information query control system reserves one repeated input information name, deletes other repeated input information names, and uses the reserved input information name and the input information name which does not exist in a repeated way as the input information name to be displayed in the form, or if the repeated input information name does not exist, the information query control system uses each determined input information name as the input information name to be displayed in the form;
and the information query control system generates a batch information input form template according to each determined input information name to be displayed in a form and a preset rule.
2. The electronic device of claim 1, wherein between step a4 and step a5, the processor is further configured to execute the information query control system to implement the steps of:
the information query control system analyzes whether repeated single query information exists in all the single query information obtained by splitting;
and when the repeated single query information exists, one repeated single query information is reserved, and other repeated single query information is deleted.
3. The electronic device according to claim 1 or 2, wherein the preset rule is:
displaying the input information names to be displayed in the same row or column in the batch information input form template according to a random sequence, or finding out the sequencing priority corresponding to the input information names to be displayed in the form according to a mapping relation between the input information names and the sequencing priority, and displaying the input information names to be displayed in the form in the same column or the same row in the batch information input form template according to the corresponding sequencing priority sequence;
the table items corresponding to the input information names displayed in the batch information input table template comprise a plurality of blank table items to be input with information;
if the input information names to be displayed in the forms are displayed in the same column in the batch information input form template, each blank form item included under the form item corresponding to the input information name to be displayed in the forms is in the same row as the form item corresponding to the input information name to be displayed in the forms;
if the input information names to be displayed in the form are displayed in the same row in the batch information input form template, each blank form item included under the form item corresponding to the input information name to be displayed in the form is in the same column as the form item corresponding to the input information name to be displayed in the form.
4. The electronic device of claim 3, wherein the step A4 includes:
after receiving batch query information input by a user based on the batch information input form template, if the input information names to be displayed in each form are displayed in the same column in the batch information input form template, the information query control system divides the query information input in the blank form items in the same column as a single piece of query information, and divides the query information input in the blank form items in different columns as different single pieces of query information;
after receiving batch query information input by a user based on the batch information input form template, if the input information names to be displayed in each form are displayed in the same row in the batch information input form template, the information query control system divides the query information input in the blank form items in the same row as a single piece of query information, and divides the query information input in the blank form items in different rows as different single pieces of query information.
5. An information inquiry control method, characterized in that the method comprises the steps of:
a1, when receiving a batch query instruction, the information query control system generates a user operation interface including preset items to be queried, wherein the user operation interface includes selection items corresponding to the items to be queried;
a2, after receiving the items to be queried selected by the user based on the user operation interface, the information query control system respectively determines the input information names corresponding to the selected items to be queried according to the predetermined mapping relation between the items to be queried and the input information names;
a3, the information query control system determines input information names to be displayed in a form in each determined input information name, the information query control system generates a batch information input form template according to each determined input information name to be displayed in the form and a preset rule, and the batch information input form template comprises an excel form;
a4, after receiving batch query information input by a user based on the batch information input form template, splitting the received batch query information into one or more single query information by the information query control system;
a5, obtaining query result data corresponding to each single piece of query information from a predetermined database, and generating a query result report of each single piece of query information corresponding to each selected item to be queried according to the query result data corresponding to each single piece of query information;
wherein the step A3 includes:
the information query control system analyzes whether repeated input information names exist in the determined input information names;
if the repeated input information names exist, the information query control system reserves one repeated input information name, deletes other repeated input information names, and uses the reserved input information name and the input information name which does not exist in a repeated way as the input information name to be displayed in the form, or if the repeated input information name does not exist, the information query control system uses each determined input information name as the input information name to be displayed in the form;
and the information query control system generates a batch information input form template according to each determined input information name to be displayed in a form and a preset rule.
6. The information query control method according to claim 5, wherein the preset rule is:
displaying the input information names to be displayed in the same row or column in the batch information input form template according to a random sequence, or finding out the sequencing priority corresponding to the input information names to be displayed in the form according to a mapping relation between the input information names and the sequencing priority, and displaying the input information names to be displayed in the form in the same column or the same row in the batch information input form template according to the corresponding sequencing priority sequence;
the table items corresponding to the input information names displayed in the batch information input table template comprise a plurality of blank table items to be input with information;
if the input information names to be displayed in the forms are displayed in the same column in the batch information input form template, each blank form item included under the form item corresponding to the input information name to be displayed in the forms is in the same row as the form item corresponding to the input information name to be displayed in the forms;
if the input information names to be displayed in the form are displayed in the same row in the batch information input form template, each blank form item included under the form item corresponding to the input information name to be displayed in the form is in the same column as the form item corresponding to the input information name to be displayed in the form.
7. The information query control method according to claim 6, wherein said step a4 includes:
after receiving batch query information input by a user based on the batch information input form template, if the input information names to be displayed in each form are displayed in the same column in the batch information input form template, the information query control system divides the query information input in the blank form items in the same column as a single piece of query information, and divides the query information input in the blank form items in different columns as different single pieces of query information;
after receiving batch query information input by a user based on the batch information input form template, if the input information names to be displayed in each form are displayed in the same row in the batch information input form template, the information query control system divides the query information input in the blank form items in the same row as a single piece of query information, and divides the query information input in the blank form items in different rows as different single pieces of query information.
8. A computer-readable storage medium storing an information query control system executable by at least one processor to cause the at least one processor to perform the information query control method of any one of claims 5-7.
CN201710440290.5A 2017-06-12 2017-06-12 Electronic device, information inquiry control method, and computer-readable storage medium Active CN107908628B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201710440290.5A CN107908628B (en) 2017-06-12 2017-06-12 Electronic device, information inquiry control method, and computer-readable storage medium

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201710440290.5A CN107908628B (en) 2017-06-12 2017-06-12 Electronic device, information inquiry control method, and computer-readable storage medium

Publications (2)

Publication Number Publication Date
CN107908628A CN107908628A (en) 2018-04-13
CN107908628B true CN107908628B (en) 2021-06-22

Family

ID=61840519

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201710440290.5A Active CN107908628B (en) 2017-06-12 2017-06-12 Electronic device, information inquiry control method, and computer-readable storage medium

Country Status (1)

Country Link
CN (1) CN107908628B (en)

Family Cites Families (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101894160B (en) * 2010-07-21 2012-02-08 同方知网(北京)技术有限公司 Intelligent search method
CN102663114B (en) * 2012-04-17 2013-09-11 中国人民大学 Database inquiry processing method facing concurrency OLAP (On Line Analytical Processing)
CN104199855B (en) * 2014-08-13 2017-07-28 王和平 A kind of searching system and method for traditional Chinese medicine and pharmacy information
US10579589B2 (en) * 2014-11-06 2020-03-03 Sap Se Data filtering
CN105426516A (en) * 2015-11-30 2016-03-23 广东电网有限责任公司电力科学研究院 Power system data query method and system
CN106874325B (en) * 2016-06-29 2020-04-03 阿里巴巴集团控股有限公司 Data query method and device

Also Published As

Publication number Publication date
CN107908628A (en) 2018-04-13

Similar Documents

Publication Publication Date Title
CN108388599B (en) Electronic device, data migration and calling method and storage medium
CN110941614A (en) Form generation method and device, electronic equipment and computer readable storage medium
CN107656729B (en) List view updating apparatus, method and computer-readable storage medium
CN111475192B (en) Method, device, storage medium and system for performing thermal augmentation on game server
CN112347042A (en) File uploading method and device, electronic equipment and storage medium
CN107679056B (en) Method for generating SQL (structured query language) statement, electronic device and readable storage medium
CN110837366A (en) Form generation method, electronic device and computer readable storage medium
CN112115145A (en) Data acquisition method and device, electronic equipment and storage medium
CN112506486A (en) Search system establishing method and device, electronic equipment and readable storage medium
CN107729341B (en) Electronic device, information inquiry control method, and computer-readable storage medium
CN111258799A (en) Error reporting information processing method, electronic device and computer readable storage medium
CN104580375A (en) Method and equipment for determining UI style information of target application
CN111723077A (en) Data dictionary maintenance method and device and computer equipment
CN114398346A (en) Data migration method, device, equipment and storage medium
CN112527280A (en) Interface display method and device, server and readable storage medium
CN107908628B (en) Electronic device, information inquiry control method, and computer-readable storage medium
CN111985194A (en) Data storage method and device, electronic equipment and storage medium
CN112948380A (en) Data storage method and device based on big data, electronic equipment and storage medium
CN109753506B (en) Data distributed storage method, device, terminal and storage medium
CN112256472A (en) Distributed data calling method and device, electronic equipment and storage medium
CN112541645A (en) Data processing method and system along with vehicle product project development and related device
CN114611477A (en) Design recommendation method and device for data table, electronic equipment and medium
CN113515265B (en) Site configuration method, device, equipment and computer readable storage medium
CN115167728A (en) Menu bar merging and displaying method, device and computer readable storage medium
CN114115864A (en) Interface generation method and device and electronic equipment

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
TA01 Transfer of patent application right

Effective date of registration: 20180529

Address after: 518000 Room 201, building A, No. 1, Qian Wan Road, Qianhai Shenzhen Hong Kong cooperation zone, Shenzhen, Guangdong (Shenzhen Qianhai business secretary Co., Ltd.)

Applicant after: Shenzhen one ledger Intelligent Technology Co., Ltd.

Address before: 200030 Xuhui District, Shanghai Kai Bin Road 166, 9, 10 level.

Applicant before: Shanghai Financial Technologies Ltd

TA01 Transfer of patent application right
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
GR01 Patent grant
GR01 Patent grant