CN101989278A - Database inquiry device with automatic splicing function - Google Patents
Database inquiry device with automatic splicing function Download PDFInfo
- Publication number
- CN101989278A CN101989278A CN2009100560074A CN200910056007A CN101989278A CN 101989278 A CN101989278 A CN 101989278A CN 2009100560074 A CN2009100560074 A CN 2009100560074A CN 200910056007 A CN200910056007 A CN 200910056007A CN 101989278 A CN101989278 A CN 101989278A
- Authority
- CN
- China
- Prior art keywords
- data
- page
- tables
- querying condition
- table element
- 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 discloses a database inquiry device with the automatic splicing function, which is coupled to a database and comprises a data table generation device, a table element generation device, an inquiry condition collection device, an inquiry condition splicing device, a data matching device and a result display device, wherein the data table generation device is used for selecting a data table; the table element generation device is used for looking up corresponding table element content in the database according to the selected data table, displaying the table element content and receiving inquiry condition information, wherein the displayed table element content comprises a group of classification elements related to the data table; the inquiry condition collection device is used for collecting the inquiry condition information and saving; the inquiry condition splicing device is used for splicing the saved inquiry conditions; the data matching device is used for inquiring in the database according to the spliced inquiry conditions, feeding back matched data if the matched data is found, and feeding back failure information if the matched data is not found; and the result display device is used for displaying the matched data which is fed back, and displaying the failure information which is fed back.
Description
Technical field
The present invention relates to database technology, relate in particular to data base querying device with automatic splicing function.
Background technology
New century arrives, and in today that the electronic computer technology development is maked rapid progress, the application of computer software has been deep into all trades and professions already, and is bringing into play their great potential.Along with enterprise, series of reforms such as door, all are all developing towards socialization.
At present, though domestic convenient database has been obtained certain progress in theory and practice, but as a general product development and application platform, domestic available outstanding product also is not a lot, simultaneously because the IT technical development is rapid, cause a lot of research units and enterprise not to carry out the research and development and the accumulation of continuation, cause some convenient data base querying product function location ambiguities, most of product does not all have to put into practice widely in industry simultaneously, sector application is single, and present development still is in the junior stage.
Up to now, database is generally used by panoramic enterprise.On the one hand, database can be deposited the relevant information of a large amount of enterprises, the more important thing is, uses database to be convenient to information is managed and controls.This has just caused first: need each enterprise all will have grasp how to grasp and use the people of database; Secondly: the intellectuality that database uses and this notion of easy will be paid attention to by increasing people.Therefore, association uses database to become more and more users' new problem, at this problem, wish for the user separate will never SQL statement worry.
Summary of the invention
The present invention proposes a kind of data base querying device with automatic splicing function.
The present invention proposes a kind of data base querying device with automatic splicing function, be coupled to a database, this data base querying device with automatic splicing function comprises:
The tables of data generating apparatus, newly-built one first page also generates one group of selective tables of data, and receive an option information based on first page on first page, and this option information is selected a tables of data;
The table element generating apparatus, be coupled to the tables of data generating apparatus, in database, search corresponding table element content according to the tables of data that option information is selected, the table element generating apparatus switches first page to the second newly-built page and the table element content that shows on second page, and receive querying condition information based on second page, wherein, the table element content that shows on second page of table element generating apparatus comprises one group of branch dvielement that is associated with tables of data;
The querying condition harvester is coupled to the table element generating apparatus, gathers querying condition information and preservation;
The querying condition splicing apparatus is coupled to the querying condition harvester, the querying condition that splicing is preserved, and wherein, splicing is based on the branch dvielement that is associated with tables of data and carries out;
The Data Matching device is coupled to the querying condition splicing apparatus, according to inquiring about in database through the querying condition of splicing, if find matched data then feed back matched data, if do not find matched data then feeding back unsuccessful information;
Device displaying result is coupled to the Data Matching device, for the matched data of being fed back, shows this matched data, and the failure information for feedback shows this failure information, and wherein, the matched data of this feedback or this failure information are to be presented on second page.
Wherein, the input window that the table element content that shows on second page of table element generating apparatus also comprises and each divides dvielement to be associated.
Comprise the querying condition input window that is used to receive based on the querying condition of second page with each input window that divides dvielement to be associated.
The querying condition preserved of splicing comprises based on the branch dvielement that is associated with tables of data the querying condition information of being gathered is carried out logical operation.
The matched data that shows feedback comprises based on the branch dvielement demonstration matched data that is associated with tables of data.
Adopt technical scheme of the present invention, can provide data query mode more easily for the user, use data base querying device of the present invention can enter the inner and use SQL statement data query table of database, and be to use the mutual form of the page to realize, thereby obtain the result by backstage splicing query statement and link data library inquiry, this can allow the user that do not grasp query statement also can well directly accomplish the inquiry of wanting by the data of interaction page dereference lane database.
Description of drawings
Fig. 1 has disclosed the structural drawing of the data base querying device that has automatic splicing function according to the present invention.
Fig. 2-Fig. 5 has disclosed an example that utilizes the data base querying device with automatic splicing function of the present invention to inquire about.
Embodiment
At first introduce and realize environment of the present invention, in the implementation procedure of the data base querying device with automatic splicing function of the present invention, can be applied to some following software environments.
The MyEclipse development environment
But Eclipse is an open source code, based on the regarded as output controlling platform of Java.In itself, it is a framework and one group of service, is used for making up environment by plug in component.Fortunately, Eclipse has attached the plug set of a standard, comprise the Java developing instrument (JavaDevelopment Tools, JDT).
Though most of users are very glad to be used as Eclipse as Java IDE and to use, Eclipse is not limited only to this.Eclipse comprises that also (Plug-in DevelopmentEnvironment, PDE), this assembly is primarily aimed at the software developer who wishes expansion Eclipse to the developing plug environment, because it allows them to make up and the seamless integrated instrument of Eclipse environment.Because the every sample thing among the Eclipse all is a plug-in unit, for providing plug-in unit, and provide the unified Integrated Development Environment of making peace, so the too development personnel have the equal place of having given play to the user to Eclipse.
And MyEclipse is the plug-in unit of Eclipse, also is a powerful J2EE Integrated Development Environment, and support code is write, disposed, test and debug.
The TOMCAT container
Tomcat is a free Serlvet container of increasing income, and is different with traditional multipad, and the application program among the Tomcat is a WAR (WebArchive) file.WAR is a kind of web application form that Sun proposes, and is similar with JAR, also is a compressed package of many files.File in this bag is organized by certain bibliographic structure: the catalogue that includes Html and Jsp file usually under its root directory or comprise these two kinds of files, also have a WEB-INF catalogue in addition, and this catalogue is very important.A web.xml file and a classes catalogue are arranged under the WEB-INF catalogue usually, web.xml is the configuration file of this application, comprises other class (as JavaBean) that compiled Servlet class and Jsp or Servlet are relied on and the classes catalogue is next.Usually these classes that relied on also can be packaged into JAR and are put under lib catalogue WEB-INF under, can certainly be put among the CLASSPATH of system the inconvenience but such migration and management is got up.
Tomcat is not only a Servlet container, and it also has the function of traditional Web server: handle the Html page.But compare with Apache, the ability of the static Html of its processing is just not as Apache.Tomcat and Apache can be integrated into one, allow Apache handle static Html, and Tomcat handles Jsp and Servlet.This integrated needs are revised, and the configuration file of Apache and Tomcat gets final product.
1. client (all being browser usually) visit Web server sends the HTTP request.
2. after Web server receives request, pass to the Servlet container.
3. the Servlet container loads Servlet, behind the generation Servlet example, transmits the object of expression request and response to it.
4. the Servlet example uses request object to obtain the solicited message of client, handles accordingly then.
5. the Servlet example sends it back client with result by response object, and container is responsible for guaranteeing responding and is correctly sent, and simultaneously control is returned to Web server.
In Tomcat, the interface of each assembly is provided and has realized class, if you will replace certain assembly among the Tomcat, only need rewrite this assembly, and be configured and get final product according to the interface of this assembly or the explanation of class.
The JSP technology
JSP is writing a Chinese character in simplified form of JavaServer Pages.The JSP technology can allow Web developer and Web designer develop the Dynamic Web homepage of easy maintenance apace.Web application with the JSP exploitation is cross-platform, can move under Linux, also can move on other operating systems.
At traditional webpage html file (* .htm, * add java applet fragment (Scriptlet) and JSP mark (tag) .html), just constituted JSP webpage (* .jsp), Web server is when running into the request of visit JSP webpage, at first carry out usability of program fragments wherein, then execution result is returned to the client with html format.Usability of program fragments can operating database, can redirect webpage, can send email or the like, and Here it is sets up the needed function of dynamic website.All procedure operation are all carried out at server end, and sending client on the network to only is the result who obtains, to client browser require minimumly, can realize No Plugin, No ActiveX,, No Java Applet, even No Frame.～formally issue JSP (JavaServer Pages) afterwards at Sun, this new Web applicating developing technology has caused people's attention very soon.JSP uses the development environment that a uniqueness is provided for creating highly dynamic Web.
The ASP technology of JSP and Microsoft is closely similar.The programming language of ASP is the script of VBScript and so on, and that JSP uses is Java, and this is both the most tangible differences.In addition, ASP and JSP also have a more essential difference: the bilingual engine is with the program code that embeds in the diverse mode processing page.Under ASP, the VBScript code is explained by the ASP engine and is carried out; Under JSP, code is compiled into Servlet and is carried out by Java Virtual Machine, and this compilation operations only takes place when asked the first time of the JSP page.
Fact proved that Java Servlet is the desirable framework that a kind of Web of exploitation uses.JSP has done improvement again in many aspects based on the Servlet technology.Utilize the JavaBean assembly of cross-platform operation, JSP provides remarkable solution for separating treatment logical and Show Styles.JSP will become the strong rival of ASP technology.
With reference to shown in Figure 1, Fig. 1 has disclosed the structural drawing of the data base querying device that has automatic splicing function according to the present invention, this data base querying device is coupled to a database, comprising: tables of data generating apparatus 10, table element generating apparatus 11, querying condition harvester 12, querying condition splicing apparatus 13, Data Matching device 14 and device displaying result 15.Fig. 2-Fig. 5 has disclosed an example that utilizes the data base querying device with automatic splicing function of the present invention to inquire about.
Tables of data generating apparatus 10 newly-built one first pages also generate one group of selective tables of data on first page, tables of data generating apparatus 10 also receives an option information based on first page, and this option information is selected a tables of data.With reference to shown in Figure 2, Fig. 2 has disclosed an example that utilizes the data base querying device with automatic splicing function of the present invention to inquire about, and has disclosed first page of an example.Tables of data generating apparatus 10 is newly-built first page generates one group of selective tables of data on first page, comprise " inquire about every month expenditure ", " inquiring about the subject mark ", " inquiring about employee's wage ".Also provide a selector button in each optional tables of data front, be considered as a option information for the selection of selector button based on first page, tables of data generating apparatus 10 also receives an option information based on first page, to select corresponding tables of data.
Table element generating apparatus 11 is coupled to tables of data generating apparatus 10, in database, search corresponding table element content according to the tables of data that option information is selected, table element generating apparatus 11 switches the second extremely newly-built page of first page and indicator gauge element content on second page, the querying condition information that table element generating apparatus 11 receives based on second page, wherein, the table element content that shows on second page of table element generating apparatus 11 comprises one group of branch dvielement that is associated with tables of data.With reference to shown in Figure 3, Fig. 3 has disclosed an example that utilizes the data base querying device with automatic splicing function of the present invention to inquire about, and has disclosed second page of an example.This tables of data correspondence be " inquiry subject mark " in first page.In second page, table element generating apparatus 11 has shown one group of branch dvielement that is associated with tables of data " inquiry subject mark ": " name ", " subject ", " mark ".On each right side of dividing dvielement, also provide and each input window that divides dvielement to be associated.In the embodiment shown in fig. 3, comprise the querying condition input window that is used to receive based on the querying condition of second page with each input window that divides dvielement to be associated.The content of input inquiry in data window, promptly being considered as is a querying condition based on the querying condition of second page.For example, in Fig. 3, with input window that " mark " is associated in imported " 1222 ", represent that a querying condition based on the querying condition of second page is that " mark " is " 1222 ".
Querying condition harvester 12 is coupled to table element generating apparatus 11, gathers querying condition information and preservation.
Querying condition splicing apparatus 13 is coupled to querying condition harvester 12, the querying condition that splicing is preserved, and wherein, this splicing is based on the branch dvielement that is associated with tables of data and carries out.In one embodiment, the querying condition preserved of splicing comprises based on the branch dvielement that is associated with tables of data the querying condition information of being gathered is carried out logical operation.For example, in two querying condition input windows, imported two conditions, these two conditions can by querying condition splicing apparatus 13 according to " with " logical relation splice.
Adopt technical scheme of the present invention, can provide data query mode more easily for the user, use data base querying device of the present invention can enter the inner and use SQL statement data query table of database, and be to use the mutual form of the page to realize, thereby obtain the result by backstage splicing query statement and link data library inquiry, this can allow the user that do not grasp query statement also can well directly accomplish the inquiry of wanting by the data of interaction page dereference lane database.
Claims (5)
1. have the data base querying device of automatic splicing function, be coupled to a database, it is characterized in that, this data base querying device with automatic splicing function comprises:
The tables of data generating apparatus, newly-built one first page also generates one group of selective tables of data, and receive an option information based on described first page on first page, and this option information is selected a tables of data;
The table element generating apparatus, be coupled to described tables of data generating apparatus, in database, search corresponding table element content according to the tables of data that described option information is selected, described table element generating apparatus switches first page and shows described table element content to the second newly-built page and on second page, and receive querying condition information based on second page, wherein, the table element content that shows on second page of table element generating apparatus comprises one group of branch dvielement that is associated with described tables of data;
The querying condition harvester is coupled to described table element generating apparatus, gathers described querying condition information and preservation;
The querying condition splicing apparatus is coupled to described querying condition harvester, the querying condition that splicing is preserved, and wherein, described splicing is based on the branch dvielement that is associated with described tables of data and carries out;
The Data Matching device is coupled to described querying condition splicing apparatus, according to inquiring about in described database through the querying condition of splicing, if find matched data then feed back matched data, if do not find matched data then feeding back unsuccessful information;
Device displaying result is coupled to described Data Matching device, for the matched data of being fed back, show this matched data, the failure information for feedback shows this failure information, wherein, the matched data of this feedback or this failure information are to be presented on second page.
2. the data base querying device with automatic splicing function as claimed in claim 1 is characterized in that, the table element content that described table element generating apparatus shows on second page also comprises and each input window that divides dvielement to be associated.
3. the data base querying device with automatic splicing function as claimed in claim 2 is characterized in that,
Described input window that is associated with each branch dvielement comprises the querying condition input window that is used to receive based on the querying condition of second page.
4. the data base querying device with automatic splicing function as claimed in claim 1 is characterized in that,
The querying condition preserved of splicing comprises based on the branch dvielement that is associated with described tables of data the querying condition information of being gathered is carried out logical operation.
5. the data base querying device with automatic splicing function as claimed in claim 1 is characterized in that,
The matched data that shows feedback comprises based on the branch dvielement that is associated with tables of data and shows described matched data.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2009100560074A CN101989278A (en) | 2009-08-06 | 2009-08-06 | Database inquiry device with automatic splicing function |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2009100560074A CN101989278A (en) | 2009-08-06 | 2009-08-06 | Database inquiry device with automatic splicing function |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN101989278A true CN101989278A (en) | 2011-03-23 |
Family
ID=43745815
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN2009100560074A Pending CN101989278A (en) | 2009-08-06 | 2009-08-06 | Database inquiry device with automatic splicing function |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN101989278A (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103856498A (en) * | 2012-11-29 | 2014-06-11 | 腾讯科技（深圳）有限公司 | Method and device for displaying information |
| CN104572666A (en) * | 2013-10-15 | 2015-04-29 | 镇江雅迅软件有限责任公司 | Method for analyzing and importing Excel into database in batch based on Jxl |
| CN105095056A (en) * | 2015-08-14 | 2015-11-25 | 焦点科技股份有限公司 | Method for monitoring data in data warehouse |
-
2009
- 2009-08-06 CN CN2009100560074A patent/CN101989278A/en active Pending
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103856498A (en) * | 2012-11-29 | 2014-06-11 | 腾讯科技（深圳）有限公司 | Method and device for displaying information |
| CN103856498B (en) * | 2012-11-29 | 2017-03-29 | 腾讯科技（深圳）有限公司 | A kind of method and device of presentation of information |
| CN104572666A (en) * | 2013-10-15 | 2015-04-29 | 镇江雅迅软件有限责任公司 | Method for analyzing and importing Excel into database in batch based on Jxl |
| CN105095056A (en) * | 2015-08-14 | 2015-11-25 | 焦点科技股份有限公司 | Method for monitoring data in data warehouse |
| CN105095056B (en) * | 2015-08-14 | 2018-01-12 | 焦点科技股份有限公司 | A kind of method of data warehouse data monitoring |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107844299B (en) | Method for implementing Web application development tool | |
| US8260844B2 (en) | Information messaging and collaboration system | |
| KR100380586B1 (en) | Method, apparatus and article of manufacture for customizing a document interface for display on a computer monitor and apparatus thereof | |
| CA2684822C (en) | Data transformation based on a technical design document | |
| US20090204883A1 (en) | Method, Program and System for the Dynamic, Template-Based Generation of Internet Pages | |
| US9495280B2 (en) | Operation verifying apparatus, operation verifying method and operation verifying system | |
| JP6043342B2 (en) | Extensibility function for electronic communication | |
| CN110059282A (en) | A kind of acquisition methods and system of interactive class data | |
| US20120216104A1 (en) | System and method for preparing excel(tm)-based analysis reports | |
| US10402310B1 (en) | Systems and methods for reducing storage required for code coverage results | |
| EP0875823A3 (en) | Method and structure for tokenized message logging system | |
| EP3418918A1 (en) | Generation and graphical display of data transform provenance metadata | |
| MXPA04001295A (en) | Declarative sequenced report parameterization. | |
| US20090198668A1 (en) | Apparatus and method for displaying documents relevant to the content of a website | |
| US8615733B2 (en) | Building a component to display documents relevant to the content of a website | |
| US7716033B2 (en) | Web load test program | |
| US11868708B2 (en) | Method and system for labeling and organizing data for summarizing and referencing content via a communication network | |
| CN101989278A (en) | Database inquiry device with automatic splicing function | |
| CN101470705A (en) | Dynamic web page translation system and method | |
| CN112037074B (en) | Visualization-based data file analysis method and device | |
| US20080059429A1 (en) | Integrated search processing method and device | |
| CN112818070A (en) | Data query method and device based on global data dictionary and electronic equipment | |
| Oh et al. | Automated transformation of template-based web applications into single-page applications | |
| Nguyen et al. | BabelRef: detection and renaming tool for cross-language program entities in dynamic web applications | |
| US20190228075A1 (en) | Changing a language for a user session replay |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C02 | Deemed withdrawal of patent application after publication (patent law 2001) | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20110323 |