CN104615602A - Automatic generation device and method thereof for query interface - Google Patents

Automatic generation device and method thereof for query interface Download PDF

Info

Publication number
CN104615602A
CN104615602A CN201310541749.2A CN201310541749A CN104615602A CN 104615602 A CN104615602 A CN 104615602A CN 201310541749 A CN201310541749 A CN 201310541749A CN 104615602 A CN104615602 A CN 104615602A
Authority
CN
China
Prior art keywords
query
interface
condition
input
information
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Granted
Application number
CN201310541749.2A
Other languages
Chinese (zh)
Other versions
CN104615602B (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.)
Shenzhen ZTE Netview Technology Co Ltd
Original Assignee
Shenzhen ZTE Netview Technology Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Shenzhen ZTE Netview Technology Co Ltd filed Critical Shenzhen ZTE Netview Technology Co Ltd
Priority to CN201310541749.2A priority Critical patent/CN104615602B/en
Publication of CN104615602A publication Critical patent/CN104615602A/en
Application granted granted Critical
Publication of CN104615602B publication Critical patent/CN104615602B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Landscapes

  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
  • User Interface Of Digital Computer (AREA)

Abstract

The invention belongs to the technical field of computer application, and discloses an automatic generation device and a method thereof for a query interface. The generation device and method solves the problems in the prior art that the workload of query interface development is heavy and the development workload of developers is further increased since the development of the query interface is synchronously updated when a computer application system carries out operations including alteration, updating and dilatation. When the generation device and method is adopted, the development workload of the query interface of a C/S (Client/Server) and B/S (Brower/Server) system which is provided with a great quantity of query objects, query objects can be queried on batch only by one-time design, and the style of the query interface is highly uniform. In addition, after the computer application system carries out business alternation, updating and dilation, the developers only need to update a database to increase, delete and revise the query objects instead of updating a client side, and therefore, the development workload of the developers can be reduced to a certain degree.

Description

Query interface generates implement device and method thereof automatically
Technical field
The present invention relates to Computer Applied Technology field, particularly relate to a kind of query interface inquired about by query interface and show data and automatically generate implement device and method thereof.
Background technology
At present, being inquired about by query interface and showing data is a kind of very common computer utilitys, in existing computer application system, the query object of this query interface normally for known is pre-designed, instead of automatically generate in query script.For this kind of method, if be used in the computer application system having a large amount of query object, then developer is often very large for the development amount of query interface.Such as reporting system, the often kind of form generated in system all needs inquiry character to unify the data set of fixed condition, and form as requested presents, and the work of its interface development has:
1, in order to tell which form is custom system provide, interface to show available all form kinds.
2, in order to obtain the data that a certain selected form will present, needing the data set of inquiry character unification group specified conditions, at this moment needing design interface input this group specified conditions to allow user, namely designing querying condition interface.Because the querying condition of various different form is not quite similar, therefore often kind of form all will design separately corresponding querying condition interface separately.
3, often kind of report tableau format is all different, and such as, for different forms, its row content is not quite similar, even not same its different style of form, therefore also needs for often kind of Report Form Design corresponding display interface separately.
As everyone knows, the kind One's name is legion of various form in reporting system, is not difficult to learn by above-mentioned interface development work, adopts the query interface method for designing that prior art provides, in the report interface performance history of reporting system, the development amount of developer is huge.
In addition, along with the change, upgrading, dilatation etc. of computer application system business, query object is also faced with the demand of increase, amendment, deletion, such as, just there is the demand needing sporadically to increase, delete some form or revise some forms by user's requirement in reporting system.Now then may need all to upgrade above-mentioned three actions for query interface, further increase the workload of developer thus undoubtedly, and for C/S(Client/Server, client/server configuration) computer application system, also have to be faced with the problem of upgrading to client.
Summary of the invention
Large in order to solve query interface development amount in prior art, and changing computer application system, upgrade, the operation such as dilatation time need that synchronized update is done to the exploitation of query interface, the problem of the development amount that causes strengthening further developer, the object of the embodiment of the present invention is to provide a kind of query interface inquired about by query interface and show data automatically to generate implement device and method thereof.
In order to reach object of the present invention, the present invention realizes by the following technical solutions:
A kind of query interface generates implement device automatically, and it comprises:
Database, its inputoutput list maintaining the object structure table that is associated by external key one and query object table and associated with described query object table by external key two;
Enquiry module, for the object structure table in the Query Database when computer application system starts and query object table, to obtain all query objects and bibliographic structure information; Be further used for after user selects query object by user interface, the inputoutput list accordingly in Query Database, to obtain the input/output information of query object; And be further used for according to the query object table in the query argument Query Database received, to obtain Query Result;
Interface generation module, is presented for all query objects obtained from enquiry module and bibliographic structure information organizing and present strategy with at least one preset catalogue; The input/output information be further used for according to the query object obtained from enquiry module generates the interface element receiving user input query condition, and according to this interface element generated query condition UI; And be further used for triggering query manipulation after user is by querying condition inputting interface input inquiry condition, and convert this querying condition to corresponding query argument and pass to enquiry module; And
Result display module, for obtaining described Query Result from enquiry module and showing.
Preferably, described object structure table saves the bibliographic structure information of query object; Described query object table saves the one-to-one relationship of each query object and its storing process; And described inputoutput list saves the input parameter of each query object and exports column information, wherein, described input parameter information represents on querying condition inputting interface for receiving choice box or the input frame form of user input query condition.
Preferably, described interface generation module generates the interface element of reception user input query condition by the mode of reflection according to the input parameter of the query object obtained from enquiry module, and in conjunction with other attribute information generated query condition UIs of this interface element and this query object.
Preferably, described query object table also saving Query Result display type attribute information, and founder's attribute information and creation-time attribute information.
Preferably, result display module is used for being shown by described Query Result according to the Query Result display type attribute information corresponding with respective queries object.
A kind ofly apply query interface as above and automatically generate implement device and realize the method that query interface generates automatically, the inputoutput list safeguarded the object structure table that is associated by external key one and query object table in a database and associated with described query object table by external key two, described method comprises:
The object structure table of enquiry module when computer application system starts in Query Database and query object table, to obtain all query objects and bibliographic structure information, all query objects obtained from enquiry module and bibliographic structure information are organized and are presented strategy with at least one preset catalogue to present by interface generation module;
After user selects query object by user interface, the inputoutput list of enquiry module accordingly in Query Database, to obtain the input/output information of query object, interface generation module generates according to the input/output information of the query object obtained from enquiry module the interface element receiving user input query condition, and according to this interface element generated query condition UI;
Query manipulation is triggered after user is by querying condition inputting interface input inquiry condition, interface generation module converts this querying condition to corresponding query argument and passes to enquiry module, query object table in the query argument Query Database that enquiry module foundation receives, to obtain Query Result;
And the described Query Result obtained from enquiry module is shown by result display module.
Preferably, described object structure table saves the bibliographic structure information of query object; Described query object table saves the one-to-one relationship of each query object and its storing process; And described inputoutput list saves the input parameter of each query object and exports column information, wherein, described input parameter information represents on querying condition inputting interface for receiving choice box or the input frame form of user input query condition.
Preferably, described interface generation module generates the interface element of reception user input query condition by the mode of reflection according to the input parameter of the query object obtained from enquiry module, and in conjunction with other attribute information generated query condition UIs of this interface element and this query object.
Preferably, described query object table also saving Query Result display type attribute information, and founder's attribute information and creation-time attribute information.
Preferably, result display module is used for being shown by described Query Result according to the Query Result display type attribute information corresponding with respective queries object.
Compared with prior art, the invention enables C/S and B/S(Browser/Server having a large amount of query object, Browser/Server Mode) the query interface development amount of system greatly reduces, only need once design, just can realize the inquiry of batch query object, and query interface style high unity.And after the business change of computer application system, upgrading, dilatation, developer only needs upgrade database, just can realize query object to increase, delete, revise, and without the need to client upgrading, therefore decrease the development amount of developer to a certain extent.
Accompanying drawing explanation
Fig. 1 is that the query interface that the embodiment of the present invention provides generates implement device structural representation automatically;
Fig. 2 is that the query interface that the embodiment of the present invention provides generates implementation method schematic flow sheet automatically;
Fig. 3 is that the query interface that the present invention one specific embodiment provides generates implementation method schematic flow sheet automatically;
The realization of the object of the invention, functional characteristics and excellent effect, be described further below in conjunction with specific embodiment and accompanying drawing.
Embodiment
Below in conjunction with the drawings and specific embodiments, technical scheme of the present invention is described in further detail, can better understand the present invention to make those skilled in the art and can be implemented, but illustrated embodiment is not as a limitation of the invention.
Should be appreciated that in the description of the embodiment of the present invention, described " first " " second " only for describing object, and is not used in instruction or hint relative importance or implies the quantity indicating indicated technical characteristic.
As shown in Figure 1, a kind of query interface that the embodiment of the present invention provides generates implement device automatically, and it comprises:
Database 50, its inputoutput list 503 maintaining the object structure table 501 that is associated by external key 1 and query object table 502 and associated with described query object table 502 by external key 2 505; Object structure table 501 is associated with query object table 502 by external key 1, represents the object directory belonging to query object.Inputoutput list 503 have recorded the input and output column information of all query objects, and is associated with inputoutput list 503 by external key 2 505, points out the I/O corresponding with query object.Wherein, major key is used for unique record indicated in table, and described external key is the copy of the major key created in sublist, is used in reference to back record unique in parent table.
Enquiry module 30, for obtaining the information (information such as the storing process such as associated and result display requirement) of query object bibliographic structure and all query objects from database 50 when computer application system starts, selection operation based on user obtains the querying condition of single query object from database 50, Output rusults describes and result display requirement, and based on the querying condition storing process that Automatically invoked is corresponding with query object from database 50 of user's input to obtain Query Result.Particularly, for the object structure table 501 in the Query Database 50 when computer application system starts and query object table 502, to obtain all query objects and bibliographic structure information; Be further used for after user selects query object by user interface 10, the inputoutput list 503 accordingly in Query Database 50, to obtain the input/output information of query object; And be further used for according to the query object table 502 in the query argument Query Database 50 received, to obtain Query Result, particularly, in the present embodiment, enquiry module 30 obtains according to the query argument received the storing process associated with query object, and perform dynamic sql (StructuredQuery Language accordingly, Structured Query Language (SQL)) Query Database 50, to obtain Query Result, wherein, described storing process is exactly a function, and it for receiving input parameter, and returns results.
Interface generation module 20, for generating the bibliographic structure interface presenting all query objects, the querying condition inputting interface of the querying condition of single query object reception user input, and single query Object Query result display interface; Particularly, presented for all query objects obtained from enquiry module 30 and bibliographic structure information organizing and presenting strategy (such as tree construction presents) with at least one preset catalogue; The input/output information be further used for according to the query object obtained from enquiry module 30 generates the interface element receiving user input query condition, and according to this interface element generated query condition UI; And be further used for triggering query manipulation after user is by querying condition inputting interface input inquiry condition, and convert this querying condition to corresponding query argument and pass to enquiry module 30.
And result display module 40, for obtaining described Query Result from enquiry module 30 and showing.Particularly, its inquiry based on query object exports and describes and Query Result display requirement, shows Query Result in a desired manner.In the present embodiment, as shown in Figure 1, when described Query Result is shown by described result display module 40, finally still specifically presented by described user interface 10.
In the present embodiment, described database 50, except record data, also saving the storing process corresponding to query manipulation of the bibliographic structure of query object, the querying condition of query object, the description of Query Result, the display requirement of Query Result, query object.Such as, described object structure table 501 saves the bibliographic structure information of query object, have higher level's catalogue of individual field record catalogue in described object structure table 501, enquiry module 30 can form the bibliographic structure of query object by inquiring about all object directory accordingly; In described database 50, the corresponding storing process of each query object is to respond the query manipulation of user, and therefore described query object table 502 saves the one-to-one relationship of each query object and its storing process; And described inputoutput list 503 saves the input parameter of each query object and exports column information.
In database 50, each query object can have input parameter and export row.These attributes are all kept in this data structure of inputoutput list 503.A corresponding multiple input parameter of query object, or there is no input parameter, and a query object is certain to one or more output should be had to arrange.And the form of expression that input parameter and output are listed in interface is different, wherein, described input parameter information represents for receiving choice box or the input frame form of user input query condition on querying condition inputting interface, and output listing is now the row in result indicator gauge.So in the present embodiment, input and output attribute field can be defined to distinguish input parameter and to export row.
Input parameter is different, and it has the different forms of expression on interface, and selection of time frame, numerical range choice box are still according to the interface control of some other receptions user input of application definition in this way.Therefore, in the present embodiment, " column data type " field can be defined to distinguish various different input parameter.
Exporting row also has some attributes to determine the form of expression at interface, and whether as sorted, add up, screen, it all can be represented by corresponding field.And in the present embodiment, export row and can also have the mark whether an expression exists subreport, if there is subreport, then on interface, click this output row, system can arrange according to input parameter and this output the condition generated as subreport, produces a new subreport.
Correspondingly, in the present embodiment, described interface generation module 20 generates according to the input parameter of the query object obtained from enquiry module 30 interface element receiving user input query condition by the mode of reflection, and in conjunction with other attribute information generated query condition UIs of this interface element and this query object, as binding time choice box, the interface element that all input parameters are corresponding (may have one or more, may not have) yet, other information of query object, as title, describe, founder, and trigger the interface element (as button) of query manipulation, generated query condition UI.
In addition, described query object table 502 also describes other attributes of query object, such as, also saving Query Result display type attribute information, and founder's attribute information and creation-time attribute information.These attribute informations describe query object and present information on interfaces, as Query Result display type attribute information is then pointed out show Query Result with list, form or other modes, wherein, described list, form also can continue the list or the form that are subdivided into which kind of respective type.
In the present embodiment, result display module 40 is for showing described Query Result according to the Query Result display type attribute information corresponding with respective queries object.Result display module 40 is based on the Query Result display type of query object, select a kind of result presentation mode (list, form etc.), and according to the output column information of query object, generate gauge outfit, and the form of expression (whether can sort, screen, statistics etc.) of each row in table, receive the Query Result that database 50 returns, padding data.
Composition graphs 1, and with reference to shown in figure 2, the embodiment of the present invention additionally provides a kind ofly to be applied query interface as above and automatically generates implement device and realize the method that query interface generates automatically, the inputoutput list 503 safeguarded the object structure table 501 that is associated by external key 1 and query object table 502 and associated with described query object table 502 by external key 2 505 in database 50, described method comprises:
S10, the enquiry module 30 object structure table 501 when computer application system starts in Query Database 50 and query object table 502, to obtain all query objects and bibliographic structure information, all query objects obtained from enquiry module 30 and bibliographic structure information are organized and are presented strategy with at least one preset catalogue to present by interface generation module 20;
S20, after user selects query object by user interface 10, the inputoutput list 503 of enquiry module 30 accordingly in Query Database 50, to obtain the input/output information of query object, interface generation module 20 generates according to the input/output information of the query object obtained from enquiry module 30 interface element receiving user input query condition, and according to this interface element generated query condition UI;
S30, after user is by querying condition inputting interface input inquiry condition, trigger query manipulation, interface generation module 20 converts this querying condition to corresponding query argument and passes to enquiry module 30, enquiry module 30 according to receive query argument Query Database 50 in query object table 502, to obtain Query Result;
S40 and, the described Query Result obtained from enquiry module 30 is shown by result display module 40.
In the present embodiment, described object structure table 501 saves the bibliographic structure information of query object; Described query object table 502 saves the one-to-one relationship of each query object and its storing process; And described inputoutput list 503 saves the input parameter of each query object and exports column information, wherein, described input parameter information represents on querying condition inputting interface for receiving choice box or the input frame form of user input query condition.
In the present embodiment, described interface generation module 20 generates according to the input parameter of the query object obtained from enquiry module 30 interface element receiving user input query condition by the mode of reflection, and in conjunction with other attribute information generated query condition UIs of this interface element and this query object.
In the present embodiment, described query object table 502 also saving Query Result display type attribute information, and founder's attribute information and creation-time attribute information.
In the present embodiment, result display module 40 is for showing described Query Result according to the Query Result display type attribute information corresponding with respective queries object.
Composition graphs 1 is also with reference to shown in figure 3, and it illustrates the schematic flow sheet realizing the method that query interface generates automatically that the application embodiment of the present invention provides, particularly, it comprises the steps:
When step 1, computer application system start, the bibliographic structure in enquiry module 30 Automatic inquirying database 50 and the information of all query objects, organize all query objects with bibliographic structure;
Step 2, interface generation module 20 are shown to the query object organized the user interface 10 of client with tree structure form, certainly, except adopting tree structure Display directory, also can adopt other structure, so that user finds query object;
Step 3, user select a query object, such as, adopt the form of mouse-click left button to choose a query object;
Step 4, enquiry module 30 start the input parameter of query object from database 50 based on the selection of user and export row;
Step 5, interface generation module 20 generate interface element corresponding to input parameter in the mode of reflection, and organize other interface elements, and generated query condition UI is also shown to user interface 10;
Querying condition inputting interface in step 6, user interface 10 receives the querying condition input of user, and accepts the querying triggering action of user's input;
Step 7, interface generation module 20 based on the input of user, generated query parameter;
Step 8, enquiry module 30 receive query argument, call storing process corresponding to query object and carry out inquiry acquisition Query Result;
Step 9, result display module 40 display type based on query object and data presentation mode (such as list, form etc.), the generation gauge outfit of output column information selection correspondence, and determine the form of expression (such as whether can sort, screen, statistics etc.) of each row, fill Query Result data, and result is presented in user interface 10.
The foregoing is only the preferred embodiments of the present invention; not thereby the scope of the claims of the present invention is limited; every utilize instructions of the present invention and accompanying drawing content to do equivalent structure or equivalent flow process conversion; or be directly or indirectly used in other relevant technical fields, be all in like manner included in scope of patent protection of the present invention.

Claims (10)

1. query interface generates an implement device automatically, it is characterized in that, comprising:
Database, its inputoutput list maintaining the object structure table that is associated by external key one and query object table and associated with described query object table by external key two;
Enquiry module, for the object structure table in the Query Database when computer application system starts and query object table, to obtain all query objects and bibliographic structure information; Be further used for after user selects query object by user interface, the inputoutput list accordingly in Query Database, to obtain the input/output information of query object; And be further used for according to the query object table in the query argument Query Database received, to obtain Query Result;
Interface generation module, is presented for all query objects obtained from enquiry module and bibliographic structure information organizing and present strategy with at least one preset catalogue; The input/output information be further used for according to the query object obtained from enquiry module generates the interface element receiving user input query condition, and according to this interface element generated query condition UI; And be further used for triggering query manipulation after user is by querying condition inputting interface input inquiry condition, and convert this querying condition to corresponding query argument and pass to enquiry module; And
Result display module, for obtaining described Query Result from enquiry module and showing.
2. query interface as claimed in claim 1 generates implement device automatically, and it is characterized in that, described object structure table saves the bibliographic structure information of query object; Described query object table saves the one-to-one relationship of each query object and its storing process; And described inputoutput list saves the input parameter of each query object and exports column information, wherein, described input parameter information represents on querying condition inputting interface for receiving choice box or the input frame form of user input query condition.
3. query interface as claimed in claim 2 generates implement device automatically, it is characterized in that, described interface generation module generates the interface element of reception user input query condition by the mode of reflection according to the input parameter of the query object obtained from enquiry module, and in conjunction with other attribute information generated query condition UIs of this interface element and this query object.
4. query interface as claimed in claim 3 generates implement device automatically, and it is characterized in that, described query object table also saving Query Result display type attribute information, and founder's attribute information and creation-time attribute information.
5. query interface as claimed in claim 4 generates implement device automatically, it is characterized in that, result display module is used for being shown by described Query Result according to the Query Result display type attribute information corresponding with respective queries object.
6. an application query interface as claimed in claim 1 automatically generates implement device and realizes the method that query interface generates automatically, it is characterized in that, the inputoutput list safeguarded the object structure table that is associated by external key one and query object table in a database and associated with described query object table by external key two, described method comprises:
The object structure table of enquiry module when computer application system starts in Query Database and query object table, to obtain all query objects and bibliographic structure information, all query objects obtained from enquiry module and bibliographic structure information are organized and are presented strategy with at least one preset catalogue to present by interface generation module;
After user selects query object by user interface, the inputoutput list of enquiry module accordingly in Query Database, to obtain the input/output information of query object, interface generation module generates according to the input/output information of the query object obtained from enquiry module the interface element receiving user input query condition, and according to this interface element generated query condition UI;
Query manipulation is triggered after user is by querying condition inputting interface input inquiry condition, interface generation module converts this querying condition to corresponding query argument and passes to enquiry module, query object table in the query argument Query Database that enquiry module foundation receives, to obtain Query Result;
And the described Query Result obtained from enquiry module is shown by result display module.
7. method as claimed in claim 6, it is characterized in that, described object structure table saves the bibliographic structure information of query object; Described query object table saves the one-to-one relationship of each query object and its storing process; And described inputoutput list saves the input parameter of each query object and exports column information, wherein, described input parameter information represents on querying condition inputting interface for receiving choice box or the input frame form of user input query condition.
8. method as claimed in claim 7, it is characterized in that, described interface generation module generates the interface element of reception user input query condition by the mode of reflection according to the input parameter of the query object obtained from enquiry module, and in conjunction with other attribute information generated query condition UIs of this interface element and this query object.
9. method as claimed in claim 8, it is characterized in that, described query object table also saving Query Result display type attribute information, and founder's attribute information and creation-time attribute information.
10. method as claimed in claim 9, is characterized in that, result display module is used for being shown by described Query Result according to the Query Result display type attribute information corresponding with respective queries object.
CN201310541749.2A 2013-11-05 2013-11-05 Query interface automatically generates realization device and its method Active CN104615602B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201310541749.2A CN104615602B (en) 2013-11-05 2013-11-05 Query interface automatically generates realization device and its method

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201310541749.2A CN104615602B (en) 2013-11-05 2013-11-05 Query interface automatically generates realization device and its method

Publications (2)

Publication Number Publication Date
CN104615602A true CN104615602A (en) 2015-05-13
CN104615602B CN104615602B (en) 2019-09-20

Family

ID=53150052

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201310541749.2A Active CN104615602B (en) 2013-11-05 2013-11-05 Query interface automatically generates realization device and its method

Country Status (1)

Country Link
CN (1) CN104615602B (en)

Cited By (8)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN105824637A (en) * 2016-03-17 2016-08-03 中国银行股份有限公司 Customized query method and system
CN106776638A (en) * 2015-11-24 2017-05-31 大唐软件技术股份有限公司 Database operation method and device
CN106776644A (en) * 2015-11-24 2017-05-31 大唐软件技术股份有限公司 A kind of reporting system collocation method and device
CN106815271A (en) * 2015-12-02 2017-06-09 北京国双科技有限公司 Querying condition generation method and device
CN106874321A (en) * 2016-06-24 2017-06-20 阿里巴巴集团控股有限公司 A kind of pluggable data retrieval method and device
CN107665228A (en) * 2017-05-10 2018-02-06 平安科技(深圳)有限公司 A kind of related information querying method, terminal and equipment
CN108984623A (en) * 2018-06-14 2018-12-11 东软集团股份有限公司 Data query conditions generation method, device, storage medium and electronic equipment
CN109614098A (en) * 2017-09-30 2019-04-12 北京国双科技有限公司 The generation method and device of configuration interface

Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN1806241A (en) * 2003-06-13 2006-07-19 微软公司 Database query user interface
CN102110161A (en) * 2011-02-24 2011-06-29 中兴通讯股份有限公司 Method and device for backing up and recovering multi-service database
US20110161343A1 (en) * 2009-12-28 2011-06-30 International Business Machines Corporation Method and system to dynamically create queries to find related records in a database
CN102855250A (en) * 2011-06-30 2013-01-02 北京新媒传信科技有限公司 Method and system for display output of user information
CN103365646A (en) * 2012-04-11 2013-10-23 怡丰联合(北京)科技有限责任公司 Form user-defined, logical definition and processing method based on script engine

Patent Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN1806241A (en) * 2003-06-13 2006-07-19 微软公司 Database query user interface
US20110161343A1 (en) * 2009-12-28 2011-06-30 International Business Machines Corporation Method and system to dynamically create queries to find related records in a database
CN102110161A (en) * 2011-02-24 2011-06-29 中兴通讯股份有限公司 Method and device for backing up and recovering multi-service database
CN102855250A (en) * 2011-06-30 2013-01-02 北京新媒传信科技有限公司 Method and system for display output of user information
CN103365646A (en) * 2012-04-11 2013-10-23 怡丰联合(北京)科技有限责任公司 Form user-defined, logical definition and processing method based on script engine

Cited By (13)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN106776638A (en) * 2015-11-24 2017-05-31 大唐软件技术股份有限公司 Database operation method and device
CN106776644A (en) * 2015-11-24 2017-05-31 大唐软件技术股份有限公司 A kind of reporting system collocation method and device
CN106776644B (en) * 2015-11-24 2019-11-29 大唐软件技术股份有限公司 A kind of reporting system configuration method and device
CN106815271A (en) * 2015-12-02 2017-06-09 北京国双科技有限公司 Querying condition generation method and device
CN105824637B (en) * 2016-03-17 2019-03-12 中国银行股份有限公司 Method for inquiring customization and system
CN105824637A (en) * 2016-03-17 2016-08-03 中国银行股份有限公司 Customized query method and system
CN106874321A (en) * 2016-06-24 2017-06-20 阿里巴巴集团控股有限公司 A kind of pluggable data retrieval method and device
CN106874321B (en) * 2016-06-24 2020-04-21 阿里巴巴集团控股有限公司 Pluggable data retrieval method and device
WO2018205376A1 (en) * 2017-05-10 2018-11-15 平安科技(深圳)有限公司 Association information querying method, terminal, server management system, and computer readable storage medium
CN107665228B (en) * 2017-05-10 2019-12-20 平安科技(深圳)有限公司 Associated information query method, terminal and equipment
CN107665228A (en) * 2017-05-10 2018-02-06 平安科技(深圳)有限公司 A kind of related information querying method, terminal and equipment
CN109614098A (en) * 2017-09-30 2019-04-12 北京国双科技有限公司 The generation method and device of configuration interface
CN108984623A (en) * 2018-06-14 2018-12-11 东软集团股份有限公司 Data query conditions generation method, device, storage medium and electronic equipment

Also Published As

Publication number Publication date
CN104615602B (en) 2019-09-20

Similar Documents

Publication Publication Date Title
CN104615602A (en) Automatic generation device and method thereof for query interface
CN106528129B (en) A kind of Web application interface generation system and method
CN111259303B (en) System and method for automatically generating front-end page of WEB information system
CN102521416B (en) Data correlation query method and data correlation query device
US8667405B2 (en) Browser-based development tools and methods for developing the same
RU2536390C2 (en) Automated report generation method
US8010530B2 (en) Presentation of multilingual metadata
US20050102284A1 (en) Dynamic graphical user interface and query logic SQL generator used for developing Web-based database applications
CN110688117B (en) Interface designer and platform based on JavaWeb and page configuration method thereof
US7818328B2 (en) API for obtaining unambiguous representation of objects in a relational database
CN102012945B (en) User-oriented database management system
CN101667171A (en) Method for generating report and report generating device
US7673245B2 (en) Converting user interface panels
US20080263142A1 (en) Meta Data Driven User Interface System and Method
US20230102947A1 (en) Providing operations in accordance with worksheet relationships and data object relationships
US20050086638A1 (en) Method and system for editing column oriented programming language statements
US20080263018A1 (en) Method and System for Mapping Business Objects to Relational Database Tables
CN113515564A (en) Data access method, device, equipment and storage medium based on J2EE
CN112631591A (en) Table element linkage method, device, equipment and computer readable storage medium
US20140114916A1 (en) Code generation and implementation method, system, and storage medium for delivering bidirectional data aggregation and updates
López et al. A component-based approach for engineering enterprise mashups
KR102490941B1 (en) An online report creation system using Excel tool
CN105573769A (en) Visual configuration method and device of remote control of cement production
EP2690563A1 (en) Method and device for reporting on data of documents generated from templates
US7617236B2 (en) Method and system for displaying results of a dynamic search

Legal Events

Date Code Title Description
C06 Publication
PB01 Publication
C10 Entry into substantive examination
SE01 Entry into force of request for substantive examination
CB02 Change of applicant information
CB02 Change of applicant information

Address after: 518057 Energy Storage Building, 3099 South Keyuan Road, Yuehai Street, Nanshan District, Shenzhen City, Guangdong Province

Applicant after: Shenzhen Liwei Zhilian Technology Co., Ltd.

Address before: 518057 Nanshan District science and technology zone, Guangdong, Zhejiang Province, South Road, building W1-A, the first floor of the building, building two

Applicant before: Shenzhen ZTE NetView Technology Co., Ltd.

GR01 Patent grant
GR01 Patent grant