CN103324764A - Web implementation of multi-condition random keyword multi-field fuzzy query method - Google Patents
Web implementation of multi-condition random keyword multi-field fuzzy query method Download PDFInfo
- Publication number
- CN103324764A CN103324764A CN2013103063050A CN201310306305A CN103324764A CN 103324764 A CN103324764 A CN 103324764A CN 2013103063050 A CN2013103063050 A CN 2013103063050A CN 201310306305 A CN201310306305 A CN 201310306305A CN 103324764 A CN103324764 A CN 103324764A
- Authority
- CN
- China
- Prior art keywords
- web
- layer
- key word
- query
- user
- 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
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention relates to a Web implementation of multi-condition random keyword multi-field fuzzy query method, wherein the method is implemented mainly by the Struts and Hibernate architectures, a Tomcat server, a database and the JSP (Java Server Page) technology. The Web implementation mainly comprises a Hibernate architecture for performing persistent operation to the database, a Struts control layer for executing corresponding background programs according to the request of clients and displaying different pages according to the result, a JSP presentation layer for presenting data or binding system resource by a tag library of the Struts, and a service layer for providing business services. The Web implementation can realize that, when a user queries on a Web page, the user only needs to randomly input one or more keywords, and uses each keyword as one condition to perform fuzzy query with the multiple fields in the database, then, the user can get the result meeting the condition. Since the Hibernate architecture used in the Web implantation scheme has the second level cache mechanism, the query efficiency can be improved.
Description
Technical field
The present invention relates to the NSLOOKUP field, the Web that relates in particular to any key word multiword of a kind of many conditions section fuzzy query method realizes.
Background technology
Along with the development of Web (network) technology and database technology, the application that database and Web combine is more and more extensive.User inquiring system is a pith that is related to the application and development success or not, in general, the inquiry system of a practical application should allow that the user makes up Query Information according to various ways to the arbitrary fields in the database, and any changeless query pattern all is difficult to adapt to the changeable query demand of user.How flexible design, convenience, effectively polling routine is the major issue that the development data Database Management Information System is paid close attention to always.The appearance of many conditions fuzzy query method has effectively improved this problem.
So-called many condition queries, thus refer to that the user comes Query Database to dwindle query results according to many known information, to obtain more accurate object information.For the user, always wish to come Query Database according to known information combination together, to improve search efficiency.Student Information Management System for example, the user wonders the student information of entrance in 2012, surname Li, obviously, if want beguine more effective according to one of them condition query according to " date of matriculation " and " name " these two condition query databases.
So-called fuzzy query refers to come data in the matching database with known partial information.Owing to having a large amount of character string informations in the database, such as name, place name etc., if the user only remembers certain (a bit) word in the title, not knowing that even this word is in beginning of the sentence or sentence or the sentence tail, at this moment just needs the fuzzy matching inquiry.
Hibemate is the Open Framework of a data persistent layer, and its ORMaping thought makes the developer treat database with OO thought, has simplified the complexity of operating database.Because the L2 cache of Hibernate mechanism, the speed of inquiry will promote greatly.
Summary of the invention
The object of the present invention is to provide the Web implementation method of any key word multiword of a kind of many conditions section fuzzy query, it can be according to a plurality of any key word of user's input, each key word carries out fuzzy query as the multiword section in the independent conditions and data storehouse table, querying condition is unfamiliar with and the slow-footed problem of fuzzy query to solve the user.Mainly utilize Struts and Hibernate framework, the Tomcat server, database and JSP technology realize.
The technical solution adopted for the present invention to solve the technical problems is: a kind of Struts of utilization and Hibernate framework are realized the Web solution of any key word multiword of many conditions section fuzzy query, the key-course configuration file (struts-config.xml) that each assembly is configured; Carry out corresponding background program and show the key-course (Controller:ActionServlet) of the different pages according to the result according to the request of client; Carry out mutual client (Browser) with the user; The presentation layer (JSP) that shows Query Result; The operation layer (AlbumService) of service logic service is provided; Database is carried out the persistent layer (AlbumDAO Hibernate) of persistence operation.
When user to access pages, can have access to first presentation layer (JSP) or key-course (Controller:ActionServlet) by browser (Browser), key-course (Controller:ActionServlet) is filled into ActionForm with the content of the page, then obtain the data model of model layer (Model) by Action access service layer (AlbumService), can use tag library demonstrating data or the binding system resource of Struts at presentation layer (JSP).Operation layer (AlbumService) mainly provides the service of service logic, for calling of Web layer (Action), mainly uses two class: interface class IAlbumDAO and factory class DAOFactory.The object of factory class DAOFactory structure interface IAlbumDAO, object is handled the purpose that entity reaches business processing thus.IAlbumDAO (persistent layer interface class) calls AlbumDAO (Hibernate persistent layer) database (Database) is operated, and correlated results shows at presentation layer (JSP).
A kind of Web solution that adopts any key word multiword of the many conditions section fuzzy query of said method realization is characterized in that having following step:
1) user is according to the one or more any key words of prompting input, and each key word is as an independent condition;
2) each condition is utilized the sql statement obtain corresponding query statement, these query statements are connected into a hql statement with and;
3) according to hibernate.cgg.xml configuration file connection data storehouse, will inquire about in the hql query statement substitution querying method, the result puts into list;
4) obtain the corresponding page according to the struts-config.xml configuration file in conjunction with Query Result;
5) return client, display page;
Web implementation by any key word multiword of a kind of many conditions provided by the invention section fuzzy query method, can realize when the user when the Web page is inquired about, only need the arbitrarily one or more key words of input, each key word carries out fuzzy query as the multiword section in the conditions and data storehouse table, just can be with qualified result queries out.Because the Hibernate framework that adopts in this Web implementation has L2 cache mechanism, can improve search efficiency.
Description of drawings
The structural drawing that the web of any key word multiword of the many conditions of Fig. 1 the present invention section fuzzy query method realizes
The process flow diagram that the web of any key word multiword of the many conditions of Fig. 2 the present invention section fuzzy query method realizes
Embodiment
The present invention will be further described in detail by reference to the accompanying drawings now.These accompanying drawings are the schematic diagram of simplification, and only the mode with signal illustrates basic structure of the present invention, so it only shows the formation relevant with the present invention.
The object of the present invention is to provide a kind of Web implementation of the convenient, simple, fast any key word multiword of many conditions section fuzzy query.
Be illustrated in figure 1 as the Web implementation structure figure of any key word multiword of the many conditions of the present invention section fuzzy query method.Comprise the key-course configuration file (struts-config.xml) (1) that each assembly is configured; Carry out corresponding background program and show the key-course (Controller:ActionServlet) (2) of the different pages according to the result according to the request of client; Carry out mutual client (Browser) (3) with the user; The presentation layer (JSP) (4) that shows Query Result; Model layer (Model) (5); The operation layer (AlbumService) (6) of service logic service is provided, and operation layer (AlbumService) (6) mainly contains two classes: factory class (DAOFactory) (7) and interface class (IAlbumDAO) (8); Database (Database) (9) is carried out the persistent layer (AlbumDAO Hibernate) (10) of persistence operation.
Utilize the struts-config.xml file that each assembly is configured.When user to access pages, can have access to first presentation layer (JSP) or key-course (Controller:ActionServlet) by browser (Browser), key-course (Controller:ActionServlet) is filled into ActionForm with the content of the page, then obtain the data model of model layer (Model) by Action access service layer (AlbumService), can use tag library demonstrating data or the binding system resource of Struts at presentation layer (JSP).Operation layer (AlbumService) mainly provides the service of service logic, for calling of Web layer (Action), mainly uses two class: interface class IAlbumDAO and factory class DAOFactory.The object of factory class DAOFactory structure interface IAlbumDAO, object is handled the purpose that entity reaches business processing thus.IAlbumDAO (persistent layer interface class) calls AlbumDAO (Hibernate persistent layer) database (Database) is operated, and correlated results shows at presentation layer (JSP).
The process flow diagram of the Web realization of any key word multiword of the many conditions of the present invention section fuzzy query method as shown in Figure 2.At first, user's key word that input will be inquired about arbitrarily according to page prompts, each key word is as an independent condition (step S1); Then, each condition is utilized the combination of sql statement, obtain corresponding query statement, these query statements are connected into a hql query statement (S2) with and; According to hibernate.cfg.xml configuration file connection data storehouse, with inquiring about in the hql query statement substitution querying method, the result is put into list (S3); Obtain the corresponding page (S4) according to the struts-config.xml configuration file in conjunction with Query Result again; Return at last client, show respective page (S5).
Take an above-mentioned desirable embodiment of the present invention as enlightenment, by above-mentioned description, the relevant staff can in the scope that does not depart from this invention technological thought, carry out various change and modification fully.The technical scope of this invention is not limited to the content on the instructions, must determine its technical scope according to the claim scope.
Claims (6)
1. the Web of any key word multiword of condition more than kind section fuzzy query method realizes, it can be according to a plurality of any key word of user's input, each key word is carried out fuzzy query as the multiword section in the independent conditions and data storehouse table, querying condition is unfamiliar with and the slow-footed problem of fuzzy query to solve the user.
2. the Web of any key word multiword of a kind of many conditions as claimed in claim 1 section fuzzy query method realizes solution, it is characterized in that: described Web realizes mainly utilizing Struts and Hibernate framework, the Tomcat server, database and JSP technology realize.
3. the Web of any key word multiword of a kind of many conditions as claimed in claim 1 section fuzzy query method realizes it is characterized in that solution mainly comprising following part: the key-course configuration file (struts-config.xml) that each assembly is configured; Carry out corresponding background program and show the key-course (Controller:ActionServlet) of the different pages according to the result according to the request of client; Carry out mutual client (Browser) with the user; The presentation layer (JSP) that shows Query Result; The operation layer (AlbumService) of service logic service is provided; Database is carried out the persistent layer (AlbumDAO Hibernate) of persistence operation.
4. the Web of any key word multiword of a kind of many conditions as claimed in claim 1 section fuzzy query method realizes solution, it is characterized in that: when user to access pages, can have access to first presentation layer (JSP) or key-course (Controller:ActionServlet) by browser (Browser), key-course (Controller:ActionServlet) is filled into ActionForm with the content of the page, then obtain model layer (Model) data model by Action access service layer (AlbumService), can use tag library demonstrating data or the binding system resource of Struts at presentation layer (JSP).Operation layer (AlbumService) mainly provides the service of service logic, for calling of Web layer (Action), mainly uses two class: interface class IAlbumDAO and factory class DAOFactory.The object of factory class DAOFactory structure interface IAlbumDAO, object is handled the purpose that entity reaches business processing thus.IAlbumDAO calls AlbumDAO (Hibernate persistent layer) database is operated, and correlated results shows at presentation layer.
5. the Web of any key word multiword of a kind of many conditions as claimed in claim 4 section fuzzy query method realizes solution, it is characterized in that having following step:
1) user is according to the one or more any key words of prompting input, and each key word is as an independent condition;
2) each condition is utilized the sql statement obtain corresponding query statement, these query statements are connected into a hql statement with and
3) according to hibemate.cfg.xml configuration file connection data storehouse, will inquire about in the hql query statement substitution querying method, the result puts into list
4) obtain the corresponding page according to the struts-config.xml configuration file in conjunction with Query Result
5) return client, display page.
6. the Web of any key word multiword of a kind of many conditions as claimed in claim 1 section fuzzy query method realizes solution, it is characterized in that the Hibernate framework that adopts has L2 cache mechanism, can improve search efficiency.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2013103063050A CN103324764A (en) | 2013-07-22 | 2013-07-22 | Web implementation of multi-condition random keyword multi-field fuzzy query method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2013103063050A CN103324764A (en) | 2013-07-22 | 2013-07-22 | Web implementation of multi-condition random keyword multi-field fuzzy query method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN103324764A true CN103324764A (en) | 2013-09-25 |
Family
ID=49193507
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN2013103063050A Pending CN103324764A (en) | 2013-07-22 | 2013-07-22 | Web implementation of multi-condition random keyword multi-field fuzzy query method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103324764A (en) |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103488794A (en) * | 2013-10-10 | 2014-01-01 | 苏州灵巴巴网络科技有限公司 | Method for Web realization of operation of databases with any properties |
| CN107239517A (en) * | 2017-05-23 | 2017-10-10 | 中国联合网络通信集团有限公司 | Many condition searching method and device based on Hbase databases |
| CN107463623A (en) * | 2017-07-06 | 2017-12-12 | 积成电子股份有限公司 | A kind of dynamic query method of transformer station's historical events database |
| CN109063098A (en) * | 2018-07-27 | 2018-12-21 | 四川长虹电器股份有限公司 | Configurable data base query method |
| CN111858609A (en) * | 2020-07-27 | 2020-10-30 | 北京金山云网络技术有限公司 | Fuzzy query method and device for block chain |
| CN112000692A (en) * | 2020-09-02 | 2020-11-27 | 平安养老保险股份有限公司 | Page query feedback method and device, computer equipment and readable storage medium |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101013430A (en) * | 2007-01-29 | 2007-08-08 | 华为技术有限公司 | Searching method and apparatus |
| CN101976146A (en) * | 2010-10-12 | 2011-02-16 | 友达光电股份有限公司 | Method for manufacturing touch panel |
-
2013
- 2013-07-22 CN CN2013103063050A patent/CN103324764A/en active Pending
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101013430A (en) * | 2007-01-29 | 2007-08-08 | 华为技术有限公司 | Searching method and apparatus |
| CN101976146A (en) * | 2010-10-12 | 2011-02-16 | 友达光电股份有限公司 | Method for manufacturing touch panel |
Non-Patent Citations (4)
| Title |
|---|
| SHANLIANGLIUXING: ""jsp/servlet/struts/hibernate/spring内部实现机制"", 《HTTP://BLOG.CSDN.NET/SHANLIANGLIUXING/ARTICLE/DETAILS/6963702》 * |
| W156445045: ""Hibernate模糊查询"", 《HTTP://ENETQ.BLOG.51CTO.COM/479739/627847》 * |
| 佚名: ""教您如何实现MySQL单表多字段模糊查询"", 《HTTP://DATABASE.51CTO.COM/ART/201011/234803.HTM》 * |
| 邵腾 等: "基于Struts和Hibenate的遥感信息发布系统研究", 《计算机与信息技术》 * |
Cited By (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103488794A (en) * | 2013-10-10 | 2014-01-01 | 苏州灵巴巴网络科技有限公司 | Method for Web realization of operation of databases with any properties |
| CN107239517A (en) * | 2017-05-23 | 2017-10-10 | 中国联合网络通信集团有限公司 | Many condition searching method and device based on Hbase databases |
| CN107239517B (en) * | 2017-05-23 | 2020-09-29 | 中国联合网络通信集团有限公司 | Multi-condition searching method and device based on Hbase database |
| CN107463623A (en) * | 2017-07-06 | 2017-12-12 | 积成电子股份有限公司 | A kind of dynamic query method of transformer station's historical events database |
| CN107463623B (en) * | 2017-07-06 | 2020-06-09 | 积成电子股份有限公司 | Dynamic query method for historical item database of transformer substation |
| CN109063098A (en) * | 2018-07-27 | 2018-12-21 | 四川长虹电器股份有限公司 | Configurable data base query method |
| CN111858609A (en) * | 2020-07-27 | 2020-10-30 | 北京金山云网络技术有限公司 | Fuzzy query method and device for block chain |
| 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 |
|---|---|---|
| KR102185864B1 (en) | Server-side rendering method and system of native content for presentation | |
| US9418176B2 (en) | Graph-based system and method of information storage and retrieval | |
| CN107291523B (en) | Web front-end message bus system | |
| US9223865B2 (en) | Method and system for property-based indexing and/or querying of web services resources | |
| US8805834B2 (en) | Extensible system and method for information extraction in a data processing system | |
| CN103324764A (en) | Web implementation of multi-condition random keyword multi-field fuzzy query method | |
| US20120158655A1 (en) | Non-relational function-based data publication for relational data | |
| CN109033113B (en) | Data warehouse and data mart management method and device | |
| US20130166563A1 (en) | Integration of Text Analysis and Search Functionality | |
| US10120886B2 (en) | Database integration of originally decoupled components | |
| US10599654B2 (en) | Method and system for determining unique events from a stream of events | |
| US9824128B1 (en) | System for performing single query searches of heterogeneous and dispersed databases | |
| CN106294695A (en) | A kind of implementation method towards the biggest data search engine | |
| CN105354328B (en) | A kind of system and method solving the access conflict of NoSQL database concurrency | |
| CN106407170A (en) | Rapid generation method and system for data report | |
| GB2450989A (en) | Graphical user interface tool | |
| CN108228762B (en) | Method and system for configuring master database universal templates | |
| Zou et al. | From a stream of relational queries to distributed stream processing | |
| CN103488794A (en) | Method for Web realization of operation of databases with any properties | |
| US20150067089A1 (en) | Metadata driven declarative client-side session management and differential server side data submission | |
| Vidhya et al. | Research document search using elastic search | |
| US10599728B1 (en) | Metadata agent for query management | |
| Belyaev et al. | Towards efficient dissemination and filtering of XML data streams | |
| Liu et al. | The advanced data service architecture for modern enterprise information system | |
| Zdravković et al. | Model-based, client-side integration of heterogeneous data from REST services |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| DD01 | Delivery of document by public notice |
Addressee: Suzhou Lingbaba Network Technology Co., Ltd. Document name: Decision of Rejection |
|
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20130925 |