CN104239368A - Form data inquiring method based on setting - Google Patents
Form data inquiring method based on setting Download PDFInfo
- Publication number
- CN104239368A CN104239368A CN201310253404.7A CN201310253404A CN104239368A CN 104239368 A CN104239368 A CN 104239368A CN 201310253404 A CN201310253404 A CN 201310253404A CN 104239368 A CN104239368 A CN 104239368A
- Authority
- CN
- China
- Prior art keywords
- database
- client
- query
- inquiring
- data
- 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.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2455—Query execution
- G06F16/24553—Query execution of query operations
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2453—Query optimisation
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/248—Presentation of query results
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2457—Query processing with adaptation to user needs
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Computational Linguistics (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention provides a form data inquiring method based on setting. The method includes the steps of S1, presetting the information and parameters of forms in a database; S2, by a client, transmitting an inquiry access request containing parameters; S3, by the client, initiating a form inquiring interface according to the request result returned by the database; S4, by the client, responding to the inquiring filter operation event performed by a user on the forms, and transmitting a data access request to the database; S5, by the database, executing inquiring statements to return data inquiring results conforming to conditions; S6, by the form inquiring interface, displaying the data inquiring results. The method has the advantages that the information and the parameters of the forms of the database are associated through presetting, condition inquiring of the forms of the database can be achieved by initiating the inquiring interface, different-condition inquiring of the same target form or the same group of target forms can be achieved, and the data inquiring diversification requirements of users are satisfied; meanwhile, compiling of a large amount of form inquiring display interface codes of different types is avoided, and work efficiency of programmers is increased.
Description
Technical field
The present invention relates to technical field of data processing, particularly based on the form data querying method arranged.
Background technology
Data play more and more important effect as the carrier of information instantly at rapid technological growth, and no matter be that tissue or individual are more and more stronger to the dependence of data, the extensive application system that they use will use the query function to database table.Existing inquiry mode mainly contains following several:
1) Query Result is obtained by writing query statement
This inquiry mode can obtain effective query result according to querying condition, but only has the programming personnel of specialty to realize, and domestic consumer does not have abundant computer programming knowledge, cannot adopt which; All need by writing code to realize for each query manipulation programming personnel, efficiency is low, and easily makes mistakes.
2) user is by the various ways such as input frame or combobox, according to inquiry object hoc queries condition
This inquiry mode by read conversion after query filter condition in database matching to suitable result, be then back to client.Relative to statement inquiry, the method is more suitable for domestic consumer, but adopts the method also to there is certain problem, and query interface initialization displaying contents is fixed, and backstage code is fixing, is suitable for when few for database table quantity.When the multiple table of database, developer will write a large amount of query interfaces for different tables, even if still likely omit some content that can inquire about like this, consuming time dumb again.
Summary of the invention
For Problems existing in existing form data inquiry, the present invention proposes the form data querying method based on arranging, pre-set the information of database table and the parameter of table correspondence, client sends the queried access request comprising parameter to database, obtain initialization list query interface, user performs the query filter Action Events to list at query interface, and client sends data access request to database, and client obtains data query result and shows.For realizing foregoing invention content, present invention employs following technical scheme, the program comprises the following steps:
S1. the parameter of information and the table correspondence shown in database is pre-set;
S2. client sends the queried access request comprising parameter;
S3. the request results that returns according to database of client, initialization list query interface;
S4. client end response user is to the query filter Action Events of list and to database transmission data access request;
S5. database performs query statement, returns qualified data query result;
S6. list query interface display data query result.
Further, pre-setting of step S1 comprises:
The main information of table is set, comprises the parameter of the title of table, table correspondence;
The field information of table is set, comprises field name, field type.
Further, the field name of table comprises the actual field name of field name and its correspondence named according to database object naming rule.
Further, the parameter that table is corresponding refers to the data message for being associated with database correlation table according to certain generate rule.
Further, in step S4, data access request is included in the performed query statement of client generation; Or
In step S4, data access request comprises the final querying condition of client tissue, and server needs to convert to and can perform query statement after this querying condition of reception.
Further, client can respond the one or many query filter Action Events of user to list.
The present invention adopts the mode pre-set, by the information of database table and parameter association, the condition query to database table can be realized behind initial interrogation interface, and the inquiry of different condition can be realized to same or one group of object table, meet the diversified demand of user data query; Meanwhile, without the need to writing a large amount of multi-form list query display GUI code, improve the work efficiency of programming personnel.
Accompanying drawing explanation
The process flow diagram based on the form data querying method arranged that Fig. 1 provides for the embodiment of the present invention;
The process flow diagram based on the form data querying method embodiment one arranged that Fig. 2 provides for the embodiment of the present invention;
The process flow diagram based on the form data querying method embodiment two arranged that Fig. 3 provides for the embodiment of the present invention;
The process flow diagram based on the form data querying method embodiment three arranged that Fig. 4 provides for the embodiment of the present invention.
Embodiment
The form data querying method based on setting mentioned to make the present invention and advantage thereof are clearly clear and definite, further describe in detail the present invention referring to accompanying drawing.
The process flow diagram based on the form data querying method arranged that Fig. 1 provides for the embodiment of the present invention, as shown in the figure, the method comprises the following steps:
Step 101, pre-sets the parameter of information and the table correspondence shown in database.
The information arranged comprises title, field name, the field type of table, and the parameter that table is corresponding.Wherein, parameter can be ID, also can be title or the ID of corresponding table, or other data types, arranges according to actual conditions.
Step 102, client sends the queried access request comprising parameter.
Client can adopt B/S pattern, sends request of access by browser to server; Client also can adopt C/S model, installs client-side program, then sends request of access to server; In some cases, client can direct accessing database.
Server can be the server in user's LAN (Local Area Network), can be the server be distributed within the scope of different geographical, also can be the cloud server by internet access.
Step 103, the request results that client returns according to database, initialization list query interface.
Server based on data request of access, perform corresponding program, corresponding program operates in a database, and database is back to server qualified data result, result is returned to client by server again, and client receives initialization list query interface after queried access result.
Or database root, according to the data access request of client, performs corresponding program, and qualified data result is back to client, client receives initialization list query interface after queried access result.
Step 104, client end response user is to the query filter Action Events of list and to database transmission data access request.
After initialization, utilize field and the related operation symbol of table, user carries out selection or the input of querying condition at list query interface.The Action Events of client end response user, and query filter condition is sent to server, has two kinds of situations, and a kind of be situation be the filtercondition that client sends is to perform query statement; One organizes querying condition according to user operation client, and server needs to convert executable query statement to after the receipt.
Step 105, database performs query statement, returns qualified data query result.
Step 106, list query interface display data query result.
Client can respond the query manipulation event at least one times of user at same query interface, and list query interface shows different Query Results under different query filter conditions.
The process flow diagram based on the form data querying method embodiment one arranged that Fig. 2 provides for the embodiment of the present invention, as shown in the figure, this embodiment comprises the following steps:
Step 201, pre-sets the parameter of information and the table correspondence shown in database.
Step 202, user end to server sends the queried access request comprising parameter.
Step 203, server obtains Query Result be back to client according to inquiry request at database.
Step 204, client according to the request results returned, initialization list query interface.
Wherein, the list query interface after initialization comprises the field title of literary name section.
Step 205, client end response user sends to the query filter Action Events of list and to server and comprises the queried access request of SQL query statement.
The query filter Action Events of response user to list directly produces SQL query statement or client needs to convert query filter conditional expression to SQL query statement.Wherein, type expression can be literal expression, numerical expression, character expression etc.
Step 206, database performs SQL query statement, returns qualified data query result.
Database performs SQL query statement, finds the data result that meets querying condition and is back to client.
Step 207, list query interface display data query result.
The process flow diagram based on the form data querying method embodiment two arranged that Fig. 3 provides for the embodiment of the present invention, as shown in the figure, this embodiment comprises the following steps:
Step 301, pre-sets the parameter of information and the table correspondence shown in database.
Step 302, user end to server sends the queried access request comprising parameter.
Step 303, server obtains Query Result be back to client according to inquiry request at database.
Step 304, client according to the request results returned, initialization list query interface.
Step 305, client end response user sends to the query filter Action Events of list and to server and comprises the queried access request that can perform query statement.
Wherein, can perform query statement can be SQL query statement, also can be HQL query statement, or the query statement of other types.
Step 306, whether server detection can perform query statement is SQL statement.
Server detects the performed query statement received, and sees whether be the executable SQL statement of database.If SQL statement, then forward step 308 to, otherwise, perform step 307.
Step 307, server carries out query statement conversion.
Server converts the non-SQL statement of step 306 to SQL statement.
Step 308, database performs query statement, returns qualified data query result.
Database performs SQL query statement, finds the data result that meets querying condition and is back to client.
Step 309, list query interface display data query result.
The process flow diagram based on the form data querying method embodiment three arranged that Fig. 4 provides for the embodiment of the present invention, as shown in the figure, this embodiment comprises the following steps:
Step 401, pre-sets the parameter of information and the table correspondence shown in database.
Step 402, user end to server sends the queried access request comprising parameter.
Step 403, server obtains Query Result be back to client according to inquiry request at database.
Step 404, client according to the request results returned, initialization list query interface.
Step 405, client end response user sends to the query filter Action Events of list and to server and comprises the request of access of the final querying condition of client tissue.
Step 406, server converts querying condition to SQL query statement.
Final querying condition is converted to the executable SQL query statement of database by server.
Step 407, database performs query statement, returns qualified data query result.
Database performs SQL query statement, finds the data result that meets querying condition and is back to client.
Step 408, list query interface display data query result.
Client can respond the query manipulation event at least one times of user at same query interface, and list query interface shows different Query Results under different query filter conditions.
The above is to preferably embodiment of the present invention, and the art personnel should be appreciated that described embodiment and non-limiting protection scope of the present invention.Do not departing under Spirit Essence of the present invention and principle, can carry out changing or revising in details, all should be encompassed within right of the present invention.
Claims (6)
1., based on the form data querying method arranged, it is characterized in that, the method comprises the following steps:
S1. the parameter of information and the table correspondence shown in database is pre-set;
S2. client sends the queried access request comprising parameter;
S3. the request results that returns according to database of client, initialization list query interface;
S4. client end response user is to the query filter Action Events of list and to database transmission data access request;
S5. database performs query statement, returns qualified data query result;
S6. list query interface display data query result.
2., as claimed in claim 1 based on the form data querying method arranged, it is characterized in that, pre-setting of step S1 comprises:
The main information of table is set, comprises the parameter of the title of table, table correspondence;
The field information of table is set, comprises field name, field type.
3. as claimed in claim 2 based on the form data querying method arranged, it is characterized in that, the field name of described table comprises the actual field name of field name and its correspondence named according to database object naming rule.
4. as claimed in claim 1 or 2 based on the form data querying method arranged, it is characterized in that, the parameter that described table is corresponding refers to the data message for being associated with database correlation table according to certain generate rule.
5. as claimed in claim 1 based on the form data querying method arranged, it is characterized in that, in step S4, data access request is included in the performed query statement that client generates; Or
In step S4, data access request comprises the final querying condition of client tissue, and server needs to convert to and can perform query statement after this querying condition of reception.
6., as claimed in claim 1 based on the form data querying method arranged, it is characterized in that, described client can respond the one or many query filter Action Events of user to list.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310253404.7A CN104239368A (en) | 2013-06-21 | 2013-06-21 | Form data inquiring method based on setting |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310253404.7A CN104239368A (en) | 2013-06-21 | 2013-06-21 | Form data inquiring method based on setting |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN104239368A true CN104239368A (en) | 2014-12-24 |
Family
ID=52227448
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201310253404.7A Pending CN104239368A (en) | 2013-06-21 | 2013-06-21 | Form data inquiring method based on setting |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN104239368A (en) |
Cited By (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104809254A (en) * | 2015-05-19 | 2015-07-29 | 郑州悉知信息技术有限公司 | Data query method and device |
| CN105069110A (en) * | 2015-08-10 | 2015-11-18 | 北京思特奇信息技术股份有限公司 | Inquiry display method and system for Hbase and Hive |
| CN105812430A (en) * | 2014-12-31 | 2016-07-27 | 金蝶软件（中国）有限公司 | Intelligent inquiry method for mobile terminal, mobile terminal and server |
| CN105868225A (en) * | 2015-11-18 | 2016-08-17 | 乐视体育文化产业发展（北京）有限公司 | Data query method, client, server and system |
| CN106815271A (en) * | 2015-12-02 | 2017-06-09 | 北京国双科技有限公司 | Querying condition generation method and device |
| CN107656926A (en) * | 2016-07-24 | 2018-02-02 | 平安科技（深圳）有限公司 | Data query method and device based on sql |
| CN108153808A (en) * | 2017-11-22 | 2018-06-12 | 链家网（北京）科技有限公司 | Big data data warehouse data access method and device |
| CN109710790A (en) * | 2018-11-19 | 2019-05-03 | 北京达佳互联信息技术有限公司 | Expression searching method and device, terminal device and storage medium |
| CN110362591A (en) * | 2018-04-02 | 2019-10-22 | 北京神州泰岳软件股份有限公司 | A kind of report form showing method and device |
| CN111339560A (en) * | 2020-02-26 | 2020-06-26 | 中国邮政储蓄银行股份有限公司 | Data isolation method, device and system |
| CN112000692A (en) * | 2020-09-02 | 2020-11-27 | 平安养老保险股份有限公司 | Page query feedback method and device, computer equipment and readable storage medium |
Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102567539A (en) * | 2011-12-31 | 2012-07-11 | 北京新媒传信科技有限公司 | Intelligent WEB report implementation method and intelligent WEB report implementation system |
-
2013
- 2013-06-21 CN CN201310253404.7A patent/CN104239368A/en active Pending
Patent Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102567539A (en) * | 2011-12-31 | 2012-07-11 | 北京新媒传信科技有限公司 | Intelligent WEB report implementation method and intelligent WEB report implementation system |
Cited By (16)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105812430A (en) * | 2014-12-31 | 2016-07-27 | 金蝶软件（中国）有限公司 | Intelligent inquiry method for mobile terminal, mobile terminal and server |
| CN105812430B (en) * | 2014-12-31 | 2019-12-13 | 金蝶软件（中国）有限公司 | Intelligent query method for mobile terminal, mobile terminal and server |
| CN104809254A (en) * | 2015-05-19 | 2015-07-29 | 郑州悉知信息技术有限公司 | Data query method and device |
| CN105069110A (en) * | 2015-08-10 | 2015-11-18 | 北京思特奇信息技术股份有限公司 | Inquiry display method and system for Hbase and Hive |
| CN105868225A (en) * | 2015-11-18 | 2016-08-17 | 乐视体育文化产业发展（北京）有限公司 | Data query method, client, server and system |
| CN106815271A (en) * | 2015-12-02 | 2017-06-09 | 北京国双科技有限公司 | Querying condition generation method and device |
| CN107656926A (en) * | 2016-07-24 | 2018-02-02 | 平安科技（深圳）有限公司 | Data query method and device based on sql |
| CN108153808A (en) * | 2017-11-22 | 2018-06-12 | 链家网（北京）科技有限公司 | Big data data warehouse data access method and device |
| CN110362591A (en) * | 2018-04-02 | 2019-10-22 | 北京神州泰岳软件股份有限公司 | A kind of report form showing method and device |
| CN110362591B (en) * | 2018-04-02 | 2022-02-22 | 北京神州泰岳软件股份有限公司 | Report form display method and device |
| CN109710790A (en) * | 2018-11-19 | 2019-05-03 | 北京达佳互联信息技术有限公司 | Expression searching method and device, terminal device and storage medium |
| CN109710790B (en) * | 2018-11-19 | 2020-12-11 | 北京达佳互联信息技术有限公司 | Expression searching method and device, terminal equipment and storage medium |
| CN111339560A (en) * | 2020-02-26 | 2020-06-26 | 中国邮政储蓄银行股份有限公司 | Data isolation method, device and system |
| CN111339560B (en) * | 2020-02-26 | 2023-06-13 | 中国邮政储蓄银行股份有限公司 | Data isolation method, device and system |
| CN112000692A (en) * | 2020-09-02 | 2020-11-27 | 平安养老保险股份有限公司 | Page query feedback method and device, computer equipment and readable storage medium |
| CN112000692B (en) * | 2020-09-02 | 2023-06-23 | 平安养老保险股份有限公司 | Page query feedback method and device, computer equipment and readable storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN104239368A (en) | Form data inquiring method based on setting | |
| CN108536761B (en) | Report data query method and server | |
| JP6761112B2 (en) | Methods and systems for server-side rendering of native content for presentation | |
| US8612486B2 (en) | Configuration management visualization | |
| CN104516979B (en) | A kind of data query method and system based on quadratic search | |
| KR102268934B1 (en) | Information Recommendation Methods and Devices | |
| CN105786808B (en) | A kind of method and apparatus for distributed execution relationship type computations | |
| CN107515878B (en) | Data index management method and device | |
| CN104123374A (en) | Method and device for aggregate query in distributed databases | |
| WO2019047441A1 (en) | Communication optimization method and system | |
| CN101408877A (en) | System and method for loading tree node | |
| US20170193036A1 (en) | Framework for joining datasets | |
| CN103186455A (en) | Method and system for generating automatic test script on page | |
| CN102456004B (en) | Query control method and system of page data | |
| CN106471501A (en) | The method of data query, the storage method data system of data object | |
| CN112182014A (en) | Database query method, device, equipment and storage medium | |
| CN103761102A (en) | Unified data service platform and implementation method thereof | |
| CN103488655A (en) | Method and system for processing composite model data | |
| CN103838781A (en) | Database access method and system | |
| CN104361040A (en) | Method and device for customized query | |
| CN103544211A (en) | General inquiry system and method for converting objects into SQL statements | |
| CN102929877B (en) | List data on webpage is generated method and the device of form document | |
| CN102402515A (en) | General custom query system and method | |
| CN102103606A (en) | Technology for realizing advanced search of commodities on mobile phone client | |
| US20130024483A1 (en) | Distribution of data within a database |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20141224 |
|
| WD01 | Invention patent application deemed withdrawn after publication |