CN104615602B - Device and method for automatically generating query interface - Google Patents

Abstract

The invention belongs to the technical field of computer applications, and discloses a device for automatically generating a query interface and a method thereof, which solves the problem of the large workload of developing the query interface in the prior art, and the problems of changing, upgrading, and expanding the computer application system. The development of the query interface needs to be updated synchronously, which further increases the development workload of developers. By adopting the invention, the development workload of the query interface of the C/S and B/S systems with a large number of query objects is greatly reduced, only one design is needed to realize the query of batch query objects, and the style of the query interface is highly unified. And after the business change, upgrade, and expansion of the computer application system, the developer only needs to upgrade the database to realize the addition, deletion, and modification of query objects without upgrading the client, so the development work of the developer is reduced to a certain extent quantity.

Description

Device and method for automatically generating query interface

technical field

The invention relates to the field of computer application technology, in particular to a device and method for automatically generating and realizing a query interface for querying and displaying data through the query interface.

Background technique

At present, querying and displaying data through a query interface is a very common computer application. In existing computer application systems, such query interfaces are usually pre-designed for known query objects, rather than being automatically processed during the query process. Generated. For this method, if it is used in a computer application system with a large number of query objects, developers often have a lot of work to develop the query interface. For example, taking the report system as an example, each report generated in the system needs to query data sets that meet certain conditions and present them in the required format. The interface development work includes:

1. In order to tell the user which reports the system provides, all types of reports that can be provided should be displayed on the interface.

2. In order to obtain the data to be presented by a selected report, it is necessary to query a data set that meets a set of specific conditions. At this time, it is necessary to design an interface to allow users to input this set of specific conditions, that is, to design the query condition interface. Since the query conditions of various reports are not the same, each type of report needs to design its own corresponding query condition interface.

3. The format of each report is different. For example, for different reports, the column content is different, and even different reports have different styles. Therefore, it is necessary to design a corresponding display interface for each report.

As we all know, there are many types of reports in the report system. It is not difficult to know through the above-mentioned interface development work. Using the query interface design method provided by the existing technology, in the process of developing the report interface of the report system, the developer's development workload is huge.

In addition, with the change, upgrade, and expansion of the computer application system business, the query objects are also faced with the need to add, modify, and delete. Or modify the requirements of some reports. At this time, for the query interface, it may be necessary to update the above three work contents, which undoubtedly further increases the workload of the developer, and for the C/S (Client/Server, client/server structure) As far as the computer application system is concerned, it has to face the problem of upgrading the client.

Contents of the invention

In order to solve the problem that the development workload of the query interface in the prior art is large, and the development of the query interface needs to be updated synchronously when the computer application system is changed, upgraded, and expanded, which further increases the development workload of the developer. , The object of the embodiments of the present invention is to provide a device and method for automatically generating and realizing a query interface for querying and displaying data through a query interface.

In order to achieve the purpose of the present invention, the present invention adopts the following technical solutions to realize:

A device for automatically generating an inquiry interface, comprising:

A database, which maintains the object structure table and the query object table associated through the foreign key one, and the input and output tables associated with the query object table through the foreign key two;

The query module is used to query the object structure table and query object table in the database when the computer application system is started, so as to obtain all query objects and directory structure information; it is further used to query the database accordingly after the user selects the query object through the user interface The input and output table in to obtain the input and output information of the query object; and further used to query the query object table in the database according to the received query parameters to obtain the query result;

The interface generation module is used to organize all query objects and directory structure information obtained from the query module and present them with at least one preset directory presentation strategy; further used to generate query object input and output information obtained from the query module The interface element that receives the query condition input by the user, and generates the query condition input interface according to the interface element; and is further used to trigger the query operation after the user enters the query condition through the query condition input interface, and converts the query condition into corresponding query parameters and passed to the query module; and

The result display module is used to obtain and display the query result from the query module.

Preferably, the object structure table saves the directory structure information of the query object; the query object table saves the one-to-one correspondence between each query object and its stored procedure; and the input-output table saves the input parameters of each query object And output column information, wherein the input parameter information represents a selection box or an input box form on the query condition input interface for receiving user input of query conditions.

Preferably, the interface generation module generates an interface element for receiving user input query conditions through reflection according to the input parameters of the query object obtained from the query module, and generates query condition input in combination with the interface elements and other attribute information of the query object interface.

Preferably, the query object table also stores query result display type attribute information, creator attribute information, and creation time attribute information.

Preferably, the result display module is configured to display the query result according to the query result display type attribute information corresponding to the corresponding query object.

A method for automatically generating a query interface by using the device for automatically generating the query interface as described above, maintaining in the database the object structure table and the query object table associated with the foreign key one, and the query object through the foreign key two The input and output tables associated with the tables, the method includes:

The query module queries the object structure table and query object table in the database when the computer application system is started to obtain all query objects and directory structure information, and the interface generation module organizes all query objects and directory structure information obtained from the query module and forms Presenting at least one preset directory presentation strategy;

After the user selects the query object through the user interface, the query module queries the input and output tables in the database accordingly to obtain the input and output information of the query object, and the interface generation module generates and receives user input based on the input and output information of the query object obtained from the query module. The interface element of the query condition, and generate the query condition input interface according to the interface element;

After the user enters the query condition through the query condition input interface, the query operation is triggered, and the interface generation module converts the query condition into corresponding query parameters and passes it to the query module, and the query module queries the query object table in the database according to the received query parameters, to Get query results;

And, the result display module displays the query result obtained from the query module.

Preferably, the object structure table saves the directory structure information of the query object; the query object table saves the one-to-one correspondence between each query object and its stored procedure; and the input-output table saves the input parameters of each query object And output column information, wherein the input parameter information represents a selection box or an input box form on the query condition input interface for receiving user input of query conditions.

Preferably, the interface generation module generates an interface element for receiving user input query conditions through reflection according to the input parameters of the query object obtained from the query module, and generates query condition input in combination with the interface elements and other attribute information of the query object interface.

Preferably, the query object table also stores query result display type attribute information, creator attribute information, and creation time attribute information.

Preferably, the result display module is configured to display the query result according to the query result display type attribute information corresponding to the corresponding query object.

Compared with the prior art, the present invention greatly reduces the development workload of the query interface of the C/S and B/S (Browser/Server, browser/server mode) systems with a large number of query objects, only needs one design, and can Realize the query of batch query objects, and the query interface style is highly unified. And after the business change, upgrade, and expansion of the computer application system, the developer only needs to upgrade the database to realize the addition, deletion, and modification of query objects without upgrading the client, thus reducing the development work of the developer to a certain extent quantity.

Description of drawings

Fig. 1 is a schematic structural diagram of a device for automatically generating a query interface provided by an embodiment of the present invention;

Fig. 2 is a schematic flowchart of a method for automatically generating a query interface provided by an embodiment of the present invention;

Fig. 3 is a schematic flow diagram of a method for realizing the automatic generation of a query interface provided by a specific embodiment of the present invention;

The realization of the purpose of the present invention, functional characteristics and excellent effects will be further described below in conjunction with specific embodiments and accompanying drawings.

Detailed ways

The technical scheme of the present invention will be described in further detail below in conjunction with the accompanying drawings and specific examples, so that those skilled in the art can better understand the present invention and implement it, but the examples given are not intended to limit the present invention .

It should be understood that in the description of the embodiments of the present invention, the "first" and "second" are used for description purposes only, and are not used to indicate or imply relative importance or implicitly indicate the quantity of indicated technical features.

As shown in Figure 1, a device for automatically generating and implementing a query interface provided by an embodiment of the present invention includes:

The database 50 maintains the object structure table 501 associated with the query object table 502 through the foreign key one 504, and the input-output table 503 associated with the query object table 502 through the foreign key two 505; the object structure table 501 is passed A foreign key one 504 is associated with the query object table 502 and indicates the object directory to which the query object belongs. The input-output table 503 records the input-output column information of all query objects, and is associated with the input-output table 503 through a foreign key 2 505, indicating the input/output corresponding to the query object. Wherein, the primary key is used to uniquely mark a record in the table, and the foreign key is a copy of the primary key created in the child table, and is used to point back to the unique record in the parent table.

The query module 30 is used to obtain the query object directory structure and information of all query objects (such as associated stored procedures and result display requirements) from the database 50 when the computer application system is started, and obtain a single query from the database 50 based on the user's selection operation. The query condition of the query object, the description of the output result and the display requirement of the result, and the stored procedure corresponding to the query object are automatically invoked from the database 50 based on the query condition input by the user to obtain the query result. Specifically, it is used to query the object structure table 501 and the query object table 502 in the database 50 when the computer application system is started, so as to obtain all query objects and directory structure information; According to this, query the input and output table 503 in the database 50 to obtain the input and output information of the query object; and further use it to query the query object table 502 in the database 50 according to the received query parameters to obtain the query results. Specifically, this implementation In an example, the query module 30 obtains the stored procedure associated with the query object according to the received query parameters, and executes dynamic SQL (Structured Query Language, Structured Query Language) query database 50 accordingly to obtain query results, wherein the stored A procedure is a function that takes input parameters and returns a result.

The interface generating module 20 is used to generate a directory structure interface that presents all query objects, a query condition input interface for a single query object to receive user-input query conditions, and a query result display interface for a single query object; 30. Organize and present all query objects and directory structure information obtained by at least one preset directory presentation strategy (such as tree structure presentation); Input the interface element of the query condition, and generate the query condition input interface according to the interface element; and further be used to trigger the query operation after the user enters the query condition through the query condition input interface, and convert the query condition into the corresponding query parameter and pass it on To query module 30.

And, the result display module 40 is configured to obtain and display the query result from the query module 30 . Specifically, it displays the query results in a required manner based on the query output description of the query object and the display requirements of the query results. In this embodiment, as shown in FIG. 1 , when the result display module 40 displays the query result, it is finally presented through the user interface 10 .

In this embodiment, in addition to recording data, the database 50 also saves the directory structure of the query object, the query condition of the query object, the description of the query result, the display requirement of the query result, and the stored procedure corresponding to the query operation of the query object. For example, the object structure table 501 stores the directory structure information of the query object, and there is a field recording the upper-level directory of the directory in the object structure table 501, so that the query module 30 can form the directory of the query object by querying all object directories structure; in the database 50, each query object corresponds to a stored procedure to respond to the user's query operation, so the query object table 502 stores the one-to-one correspondence between each query object and its stored procedure; and the input and output Table 503 saves the input parameters and output column information of each query object.

In the database 50, each query object will have input parameters and output columns. These attributes are all stored in the data structure of the input-output table 503 . A query object corresponds to multiple input parameters, or no input parameters, and a query object must correspond to one or more output columns. In addition, the input parameters and output columns have different forms of expression on the interface, wherein the input parameter information represents a selection box or input box form for receiving user input query conditions on the query condition input interface, and the output column is a result display table A column in . Therefore, in this embodiment, an input and output flag field can be defined to distinguish input parameters and output columns.

Different input parameters have different forms on the interface, such as a time selection box, a value range selection box, or some other interface controls defined by the application to receive user input. Therefore, in this embodiment, a "column data type" field can be defined to distinguish various input parameters.

The output column also has some attributes that determine the display form of the interface, such as whether it can be sorted, counted, and filtered, which can be represented by corresponding fields. And in this embodiment, the output column can also have a flag indicating whether there is a sub-report, if there is a sub-report, click the output column on the interface, and the system will use the input parameters and the output column as the conditions for generating the sub-report , generating a new subreport.

Correspondingly, in this embodiment, the interface generation module 20 generates an interface element for receiving user input query conditions according to the input parameters of the query object obtained from the query module 30 through reflection, and combines the interface element and the query object Other attribute information generates query condition input interface, such as combining time selection box, interface elements corresponding to all input parameters (maybe one or more, or none), other information of query object, such as name, description, creator, and An interface element (such as a button) that triggers a query operation to generate a query condition input interface.

In addition, the query object table 502 also describes other attributes of the query object, for example, attribute information of query result display type, creator attribute information, and creation time attribute information are stored. These attribute information describe the presentation information of the query object on the interface. For example, the query result display type attribute information indicates whether the query result should be displayed in a list, report or other ways. The list and report can be further subdivided into what kind of corresponding Types of lists or reports.

In this embodiment, the result display module 40 is configured to display the query result according to the query result display type attribute information corresponding to the corresponding query object. The result display module 40 selects a result presentation mode (list, report, etc.) based on the query result display type of the query object, and generates a table header and the expression form of each column in the table (whether it is possible or not) according to the output column information of the query object. Sorting, screening, statistics, etc.), receiving the query results returned by the database 50, and filling the data.

In conjunction with Fig. 1, and with reference to Fig. 2, the embodiment of the present invention also provides a method for automatically generating a query interface using the device for automatically generating a query interface as described above, and maintains in the database 50 a correlation through a foreign key-504. Linked object structure table 501 and query object table 502, and the input-output table 503 associated with the query object table 502 through foreign key two 505, the method includes:

S10, the query module 30 queries the object structure table 501 and the query object table 502 in the database 50 when the computer application system starts, to obtain all query objects and directory structure information, and the interface generation module 20 will obtain all query objects from the query module 30 and directory structure information are organized and presented with at least one preset directory presentation strategy;

S20, after the user selects the query object through the user interface 10, the query module 30 queries the input and output table 503 in the database 50 accordingly to obtain the input and output information of the query object, and the interface generation module 20 obtains the query object according to the query module 30 The input and output information generates an interface element that receives user input query conditions, and generates a query condition input interface based on the interface elements;

S30, after the user inputs the query condition through the query condition input interface, the query operation is triggered, the interface generation module 20 converts the query condition into corresponding query parameters and transmits them to the query module 30, and the query module 30 queries the database 50 according to the received query parameters The query object table 502 to obtain the query result;

S40, and, the result display module 40 displays the query result obtained from the query module 30 .

In this embodiment, the object structure table 501 saves the directory structure information of the query object; the query object table 502 saves the one-to-one correspondence between each query object and its stored procedure; and the input-output table 503 saves each The input parameters and output column information of the query object, wherein the input parameter information represents a selection box or an input box form on the query condition input interface for receiving user input query conditions.

In this embodiment, the interface generation module 20 generates an interface element that receives the query condition input by the user through reflection according to the input parameters of the query object obtained from the query module 30, and combines the interface element and other attribute information of the query object Generate query condition input interface.

In this embodiment, the query object table 502 also stores the query result display type attribute information, creator attribute information, and creation time attribute information.

In this embodiment, the result display module 40 is configured to display the query result according to the query result display type attribute information corresponding to the corresponding query object.

Referring to FIG. 1 and referring to FIG. 3 , it shows a schematic flowchart of a method for automatically generating a query interface provided by an embodiment of the present invention. Specifically, it includes the following steps:

Step 1, when the computer application system starts, the query module 30 automatically queries the directory structure in the database 50 and the information of all query objects, and organizes all query objects with the directory structure;

Step 2, the interface generation module 20 displays the organized query object in a tree structure to the user interface 10 of the client. Of course, in addition to using a tree structure to display the directory, other structures can also be used so that the user can find the query object ;

Step 3, the user selects a query object, for example, selects a query object by clicking the left button of the mouse;

Step 4, the query module 30 starts to query the input parameters and output columns of the object from the database 50 based on the user's selection;

Step 5, the interface generation module 20 generates the interface elements corresponding to the input parameters in a reflective manner, and organizes other interface elements, generates the query condition input interface and displays it on the user interface 10;

Step 6, the query condition input interface on the user interface 10 receives the user's query condition input, and accepts the query trigger action input by the user;

Step 7, the interface generation module 20 generates query parameters based on the user's input;

Step 8, the query module 30 receives the query parameters, calls the stored procedure corresponding to the query object to query and obtain the query results;

Step 9, the result display module 40 selects the corresponding data presentation method (such as list, report, etc.) based on the display type of the query object and the output column information, generates the table header, and determines the presentation form of each column (such as whether it can be sorted, filtered, statistics, etc.), fill in the query result data, and display the result on the user interface 10.

The above descriptions are only preferred embodiments of the present invention, and are not intended to limit the patent scope of the present invention. Any equivalent structure or equivalent process transformation made by using the description of the present invention and the contents of the accompanying drawings, or directly or indirectly used in other related All technical fields are equally included in the scope of patent protection of the present invention.

Claims (10)

1. a kind of query interface automatically generates realization device characterized by comprising

Database, maintain by the associated object structure table of external key one and query object table and by external key two with The input/output list that the query object table associates；

Enquiry module, for inquiring object structure table and query object table in database when computer application system starts, To obtain all query objects and catalog structure information；It is further used for after user selects query object by user interface, The input/output list in database is inquired, accordingly to obtain the input/output information of query object；And it is further used for foundation Query object table in received query argument inquiry database, to obtain query result；

Interface generation module, for by all query objects and catalog structure information that are obtained from enquiry module give tissue and with At least one preset catalogue is presented strategy and is presented；It is further used for the input according to the query object obtained from enquiry module Output information generates the interface element for receiving user input query condition, and generates querying condition according to the interface element and input boundary Face；And it is further used for triggering inquiry operation after user is by querying condition input interface input inquiry condition, and should Querying condition is converted into corresponding query argument and passes to enquiry module；And

Result display module, for obtaining the query result from enquiry module and showing.

2. query interface as described in claim 1 automatically generates realization device, which is characterized in that the object structure table saves The catalog structure information of query object；The query object table saves each query object and a pair for its storing process It should be related to；And the input/output list saves the input parameter and output column information of each query object, wherein described Input paramete information indicates on querying condition input interface for receiving the choice box or input frame shape of user input query condition Formula.

3. query interface as claimed in claim 2 automatically generates realization device, which is characterized in that the interface generation module according to It is generated by way of reflection according to the input parameter of the query object obtained from enquiry module and receives user input query condition Interface element, and other attribute informations of the interface element and the query object is combined to generate querying condition input interface.

4. query interface as claimed in claim 3 automatically generates realization device, which is characterized in that the query object table is also protected Query result display type attribute information and founder's attribute information and creation time attribute information are deposited.

5. query interface as claimed in claim 4 automatically generates realization device, which is characterized in that result display module be used for according to The query result is shown according to query result display type attribute information corresponding with respective queries object.

6. a kind of method that query interface automatically generates, which is applied to query interface as described in claim 1, automatically generates realization dress In setting, which is characterized in that maintenance passes through the associated object structure table of external key one and query object table, Yi Jitong in the database Cross the input/output list that external key two associates with the query object table, which comprises

Object structure table and query object table of the enquiry module when computer application system starts in inquiry database, to obtain All query objects and catalog structure information, interface generation module is by all query objects obtained from enquiry module and catalogue knot Structure information is given tissue and is presented at least one preset catalogue presentation strategy；

After user selects query object by user interface, enquiry module inquires the input/output list in database accordingly, with Obtain the input/output information of query object, input and output of the interface generation module according to the query object obtained from enquiry module Information generates the interface element for receiving user input query condition, and generates querying condition input interface according to the interface element；

In user by triggering inquiry operation after querying condition input interface input inquiry condition, interface generation module is by the inquiry Condition is converted into corresponding query argument and passes to enquiry module, and enquiry module inquires database according to received query argument In query object table, to obtain query result；

And result display module is shown the query result obtained from enquiry module.

7. method as claimed in claim 6, which is characterized in that the object structure table saves the bibliographic structure of query object Information；The query object table saves the one-to-one relationship of each query object Yu its storing process；And the input Output table saves the input parameter and output column information of each query object, wherein the input paramete information expression is looked into Ask the choice box or input box form on condition UI for receiving user input query condition.

8. the method for claim 7, which is characterized in that the interface generation module is looked into according to what is obtained from enquiry module The input parameter for asking object generates the interface element for receiving user input query condition by way of reflection, and combines the interface Other of element and the query object attribute information generate querying condition input interface.

9. method according to claim 8, which is characterized in that the query object table also saves query result display type Attribute information and founder's attribute information and creation time attribute information.

10. method as claimed in claim 9, which is characterized in that result display module is used for foundation and respective queries object pair The query result display type attribute information answered shows the query result.