CN101908063A - Universal report query tool - Google Patents
Universal report query tool Download PDFInfo
- Publication number
- CN101908063A CN101908063A CN2010102310517A CN201010231051A CN101908063A CN 101908063 A CN101908063 A CN 101908063A CN 2010102310517 A CN2010102310517 A CN 2010102310517A CN 201010231051 A CN201010231051 A CN 201010231051A CN 101908063 A CN101908063 A CN 101908063A
- Authority
- CN
- China
- Prior art keywords
- row
- mainly
- information
- tycx
- result
- 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
- 239000002131 composite material Substances 0.000 claims description 3
- 230000008676 import Effects 0.000 claims description 3
- 238000000034 method Methods 0.000 abstract description 8
- 238000012423 maintenance Methods 0.000 abstract 1
- 238000005516 engineering process Methods 0.000 description 3
- 238000010276 construction Methods 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention provides a universal report query tool. By analyzing various reports to sum up the common properties of the reports and adopting a mode of managing query condition and result display pages respectively, basic information setting, query condition setting and query result display setting are performed, wherein corresponding parameters can be flexibly set for each class of the reports and are used in the process of setting the conditions; the attribute of each representation column (field) in each report is recorded by a two-dimensional table and is not solidified in a program, so that the representation style can be controlled without modifying the program. Therefore, the page function expansion and database function expansion are separated, the complexity of the system expansion development is reduced, the system adaptability is improved, the programming efficiency is also improved, and the maintenance is convenient. The parameter information needed by representing each record and recorded by the two-dimensional table comprises parameter name, parameter type, parameter sequence, parameter input or not, and the like, and is not solidified in the program. Therefore, the processing flexibility is improved.
Description
Technical field
The present invention relates to a kind of Computer Applied Technology field, specifically a kind of general report query tool.
Background technology
The basic data of China's every field is all perfect at present, data utilize the demand of aspect increasing, the data of a large amount of statistical study classes need be presented to different users, how quick, become the shift in demand of business statistical table form pendulum in face of software company and customer efficiently, but existing software company still utilizes traditional thinking of developer's development sequence and method to handle this class demand obviously to fall behind, therefore, need a cover to compare scientific methods and instrument helper applications company and client and adapt to fast-changing demand, build application system fast.
Summary of the invention
The purpose of this invention is to provide a kind of general report query tool.
The objective of the invention is to realize in the following manner, according to the application scale and the application content analysis in each field at present, along with infotech constantly develops, application meeting in the future constantly increases, therefore the necessary emphasis of Technical Architecture is considered professional platform independence, security, reliability, dirigibility, stability and the ease of manageability of total system, Technical Architecture should have extraordinary expandability simultaneously, and meets the construction principle and the technical requirement of whole project.
By analyzing all kinds of forms, sum up the public nature of form, this scheme is the mode that adopts the querying condition and the display result page to manage respectively, mainly is divided into essential information setting, querying condition setting, Query Result and shows three parts are set:
The querying condition part: querying condition is carried out detailed classification, specifically be divided into 18 classes, the basic satisfied needs of inquiry at present,
By analyzing all kinds of forms, sum up the public nature of form, this scheme is the mode that adopts the querying condition and the display result page to manage respectively, mainly being divided into essential information setting, querying condition setting, Query Result shows three parts are set: every class can be provided with relevant parameters flexibly, when carrying out condition setting, use.
Essential information is provided with part: mainly be that Back ground Information to the needs of form is provided with, be divided into five zones and manage.
First zone is the heading message district, and the management of querying condition, results page, results page slug area mainly is set.
Whether second area is an attribute area as a result, mainly is whether paging of display result, every page to be set show how many row, and how many data are maximum get, base attributes such as display column number, row number.
The 3rd zone is that the result comes the source region, and the SQL statement of the required data acquisition of result mainly is set.
The 4th zone is table tail block of information, and table tail Zuo Qu, Zhong Qu, right district information mainly are set.
The 5th zone is the extend information district, mainly is whole form link and image credit are set.
Query Result shows: information of each row of Query Result mainly is set, comprises information such as single-row, composite column, row number, row name, column width, row type, column alignment mode, row chain.
Above-mentioned all is to store by the mode of two-dimentional relation table.
Native system is realized based on the J2EE technical design, adopts the exploitation of ORACLE 9I and above database and BEA WEBLOGICSERVER 8.1 middleware softwares to form, and the implementation step is as follows:
The first, readiness database environment
In database, create 1 table space and user, as following table
Second step, deployment system are used
1. under the user who sets up, import the data of having put in order.
2. acquisition system program: TYCX.
3. create territory: tycx_domain by default option.
4. start startWebLogic.cmd, enter the weblogic control desk:
Create connection pool tycxpool (usemame/password):
Create data source,, notice that JNDIName should be tycx_ds, use tycxpool to connect the pond as tycx_ds.
5. select WebApplicationModules, select tycx to use and dispose.
Excellent effect of the present invention is as follows:
One, writes down with bivariate table that each represents the attribute of column (field) in each form, rather than be solidificated in the program, thereby need not update routine and just can control show style, make expansion of page function and database function expansion separate, reduced the system extension complexity of developing, improved the adaptability of system, also improved programming efficiency and quality, be convenient to safeguard
Two, write down each form parameters needed information when representing with bivariate table, comprise parameter name, parameter type, parameter order and input parameter etc. whether, rather than be solidificated in the program, improved the dirigibility of handling;
Three, write down backstage inquiry storing process information that each form need call, corresponding system function module and relevant data processing with bivariate table when representing and handle storing process information, be convenient to safeguard, improved the dirigibility of programming efficiency and processing.Through facts have proved, data use represent aspect, the development efficiency that the efficiency ratio of utilizing this too development to use is traditional improves 80-90%.
Embodiment
The querying condition part: querying condition is carried out detailed classification, specifically be divided into 18 classes, the basic satisfied needs of inquiry at present specifically are classified as follows:
| Classification | Title | Remarks |
| 01 | Input 1:**** * * month * * day on date is to * * * * * * month * * day | The date input format: * * * * * * month * * day is to * * * * * * month * * day |
| 02 | The input 2:**** * * month on date is to the * * month | The date input format: the * * * * * * month is to the * * month |
| 03 | The input 3:**** * * month on date | Date input format: the * * * * * * month |
| 04 | Date input 4:**** | Date input format: * * * * |
| 05 | Linkage pulldown menu | The definition linkage pulldown menu |
| 06 | Drop-down menu | The definition drop-down list |
| 07 | Input frame | The definition of data frame |
| 08 | Radio box | The definition radio box |
| 09 | Do not show | Only make parameter and replace use, the page does not show |
| 10 | Input 5:**** * * month * * day on date | Date input format: * * * * * * month * * day |
| 11 | The input 6:**** * * month on date is to the * * * * * * month | The date input format: the * * * * * * month is to the * * * * * * month |
| 12 | The date input 7:**** * * month to the * * month (date of display Name) | Date input format: the * * * * * * month to the * * month (date of display Name) |
| 13 | Check box | The definition check box |
| 14 | Drop-down menu | Definition does not have the drop-down list of full choosing |
| 15 | Date input 8: the first half of the year or the second half year (form of radio box) | Date input format: the first half of the year or the second half year |
| 16 | Date input 9 | Date input format: only refer to ten days report |
| 17 | Season in year | Date input format: the whole year in season year |
| 18 | The whole year in month year | Date input format: the whole year in month year |
Every class can be provided with relevant parameters flexibly, when carrying out condition setting, uses.
Essential information is provided with part: mainly be that Back ground Information to the needs of form is provided with, be divided into five zones and manage.
First zone is the heading message district, and the management of querying condition, results page, results page slug area mainly is set.
Whether second area is an attribute area as a result, mainly is whether paging of display result, every page to be set show how many row, and how many data are maximum get, base attributes such as display column number, row number.
The 3rd zone is that the result comes the source region, and the SQL statement of the required data acquisition of result mainly is set.
The 4th zone is table tail block of information, and table tail Zuo Qu, Zhong Qu, right district information mainly are set.
The 5th zone is the extend information district, mainly is whole form link and image credit are set.
Query Result shows: information of each row of Query Result mainly is set, comprises information such as single-row, composite column, row number, row name, column width, row type, column alignment mode, row chain.
Above-mentioned all is to store by the mode of two-dimentional relation table.
Embodiment
Follow the principle of universalization, independent of service, tool design, carry out multianalysis, conclusion and summary, extract public model, now divide three parts to introduce method for designing through the query analysis class is used:
One, writes down with bivariate table that each represents the attribute of column (field) in each form, rather than be solidificated in the program, thereby need not update routine and just can control show style, make expansion of page function and database function expansion separate, reduced the system extension complexity of developing, improved the adaptability of system, also improved programming efficiency and quality, be convenient to safeguard
Two, write down each form parameters needed information when representing with bivariate table, comprise parameter name, parameter type, parameter order and input parameter etc. whether, rather than be solidificated in the program, improved the dirigibility of handling
Three, write down backstage inquiry storing process information that each form need call, corresponding system function module and relevant data processing with bivariate table when representing and handle storing process information, be convenient to safeguard, improved the dirigibility of programming efficiency and processing
Native system is realized based on the J2EE technical design, adopts the exploitation of ORACLE 9I and above database and BEA WEBLOGICSERVER 8.1 middleware softwares to form, and the implementation step is as follows:
The first, readiness database environment
In database, create 1 table space and user, as following table
Second step, deployment system are used
1. under the user who sets up, import the data of having put in order.
2. acquisition system program: TYCX.
3. create territory: tycx_domain by default option.
4. start startWebLogic.cmd, enter the weblogic control desk:
Create connection pool tycxpool (usemame/password):
Create data source,, notice that JNDIName should be tycx_ds, use tycxpool to connect the pond as tycx_ds.
5. select WebApplicationModules, select tycx to use and dispose.
Except that the described technical characterictic of instructions, be the known technology of those skilled in the art.
Claims (1)
1. general report query tool, it is characterized in that, by analyzing all kinds of forms, sum up the public nature of form, the mode that adopts the querying condition and the display result page to manage respectively, comprise that essential information setting, querying condition setting, Query Result demonstration are provided with three parts: every class can be provided with relevant parameters flexibly, uses when carrying out condition setting;
Essential information is provided with part: mainly be that Back ground Information to the needs of form is provided with, be divided into five zones and manage;
First zone is the heading message district, and the management of querying condition, results page, results page slug area mainly is set;
Whether second area is an attribute area as a result, mainly is whether paging of display result, every page to be set show how many row, and how many data are maximum get, base attributes such as display column number, row number;
The 3rd zone is that the result comes the source region, and the SQL statement of the required data acquisition of result mainly is set;
The 4th zone is table tail block of information, and table tail Zuo Qu, Zhong Qu, right district information mainly are set;
The 5th zone is the extend information district, mainly is whole form link and image credit are set;
Query Result shows: information of each row of Query Result mainly is set, comprises single-row, composite column, row number, row name, column width, row type, column alignment mode, row chain information;
Above-mentioned all is to store by the mode of two-dimentional relation table;
Native system is realized based on the J2EE technical design, adopts the exploitation of ORACLE 9I and above database and BEA WEBLOGICSERVER 8.1 middleware softwares to form, and the implementation step is as follows:
The first, readiness database environment
In database, create 1 table space and user, as following table
Second step, deployment system are used
1) under the user who sets up, imports the data of having put in order;
2) obtain system program: TYCX;
3) create territory: tycx_domain by default option;
4) start startWebLogic.cmd, enter the weblogic control desk:
Create connection pool tycxpool, usemame/password:
Create data source, comprise tycx_ds, notice that JNDIName should be tycx_ds, use tycxpool to connect the pond;
5) select WebApplicationModules, select tycx to use and dispose.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2010102310517A CN101908063A (en) | 2010-07-20 | 2010-07-20 | Universal report query tool |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2010102310517A CN101908063A (en) | 2010-07-20 | 2010-07-20 | Universal report query tool |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN101908063A true CN101908063A (en) | 2010-12-08 |
Family
ID=43263523
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN2010102310517A Pending CN101908063A (en) | 2010-07-20 | 2010-07-20 | Universal report query tool |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN101908063A (en) |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102789487A (en) * | 2012-06-29 | 2012-11-21 | 用友软件股份有限公司 | Data query and retrieval processing device and data query and retrieval processing method |
| CN103092622A (en) * | 2013-01-23 | 2013-05-08 | 浪潮齐鲁软件产业有限公司 | Intelligent report form and information desktop push tool |
| CN103810186A (en) * | 2012-11-08 | 2014-05-21 | 天津市国瑞数码安全系统有限公司 | Method for dynamically creating query scheme based on basic data of filing system |
| CN104239100A (en) * | 2014-09-11 | 2014-12-24 | 浪潮软件集团有限公司 | A general data processing method |
| CN109918631A (en) * | 2019-02-24 | 2019-06-21 | 辽宁工程技术大学 | A Method of Quickly Generating Accounting Statements |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6185560B1 (en) * | 1998-04-15 | 2001-02-06 | Sungard Eprocess Intelligance Inc. | System for automatically organizing data in accordance with pattern hierarchies therein |
| US20030212667A1 (en) * | 2002-05-10 | 2003-11-13 | International Business Machines Corporation | Systems, methods, and computer program products to browse database query information |
| CN101266545A (en) * | 2008-04-30 | 2008-09-17 | 武汉科兴达软件股份有限公司 | Electric power industry integral supporting platform |
-
2010
- 2010-07-20 CN CN2010102310517A patent/CN101908063A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6185560B1 (en) * | 1998-04-15 | 2001-02-06 | Sungard Eprocess Intelligance Inc. | System for automatically organizing data in accordance with pattern hierarchies therein |
| US20030212667A1 (en) * | 2002-05-10 | 2003-11-13 | International Business Machines Corporation | Systems, methods, and computer program products to browse database query information |
| CN101266545A (en) * | 2008-04-30 | 2008-09-17 | 武汉科兴达软件股份有限公司 | Electric power industry integral supporting platform |
Non-Patent Citations (1)
| Title |
|---|
| TUWEN: "《ASP.NET水晶报表从入门到灵活应用》", 28 December 2008, HTTP://BLOG.CSDN.NET/TUWEN/ARTICLE/DETAILS/3630226 * |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102789487A (en) * | 2012-06-29 | 2012-11-21 | 用友软件股份有限公司 | Data query and retrieval processing device and data query and retrieval processing method |
| CN102789487B (en) * | 2012-06-29 | 2015-09-02 | 用友软件股份有限公司 | Data query retrieval process device and data query search processing method |
| CN103810186A (en) * | 2012-11-08 | 2014-05-21 | 天津市国瑞数码安全系统有限公司 | Method for dynamically creating query scheme based on basic data of filing system |
| CN103092622A (en) * | 2013-01-23 | 2013-05-08 | 浪潮齐鲁软件产业有限公司 | Intelligent report form and information desktop push tool |
| CN104239100A (en) * | 2014-09-11 | 2014-12-24 | 浪潮软件集团有限公司 | A general data processing method |
| CN109918631A (en) * | 2019-02-24 | 2019-06-21 | 辽宁工程技术大学 | A Method of Quickly Generating Accounting Statements |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US20210365446A1 (en) | Dynamically updated data sheets using row links | |
| US11194793B1 (en) | Dynamically materialized views for sheets based data | |
| CN102541867A (en) | Data dictionary generating method and system | |
| Ruggles | Big microdata for population research | |
| Otten et al. | Deconstructing sustainable rubber production: contesting narratives in rural Sumatra | |
| Southall | Rebuilding the Great Britain Historical GIS, Part 1: Building an indefinitely scalable statistical database | |
| CN101908063A (en) | Universal report query tool | |
| CN111881660B (en) | Report generation method, device, computer equipment and storage medium | |
| Lange et al. | What are the characteristics of Canadian independent, scholarly journals? Results from a website analysis | |
| Juvan et al. | Towards a GIS analysis of literary cultures: The making of the Slovenian ethnoscape through literature | |
| Rees et al. | Census data resources in the United Kingdom | |
| CN102866985A (en) | Data formatting device and method for on-line analytical processing system | |
| Rexwhite et al. | The use of databases for information storage and retrieval in selected banks in Delta State, Nigeria | |
| Landry | National libraries’ functions: results from the 2016 survey of national libraries’ functions | |
| CN114265842A (en) | Audit data processing method, device, equipment and storage medium based on ERP system | |
| WO2022215276A1 (en) | Data extraction device, data extraction method, data extraction program, data extraction assistance device, data extraction assistance method, and data extraction assistance program | |
| Katzen | The application of computers in the humanities: A view from Britain | |
| Yeboah | Resource description and organization in academic libraries in Ghana: Evidence from the practice of three top universities | |
| CA2522254A1 (en) | Method and system for designing, implementing and documenting olap | |
| Conway et al. | The Directory of Institutions in the United States and Canada with Pre-1600 Manuscript Holdings: From its Origins to the Present, and its Role in Tracking the Migration of Manuscripts in North American Repositories | |
| US20070073765A1 (en) | Metadata-based schema generator | |
| CN114490568B (en) | Integration and migration methods and systems for cross-domain databases | |
| Sheng Han et al. | EMAPS–a GIS application in town council management in Singapore | |
| Isa et al. | Tourist satisfaction on natural environment within Islamic built environment context in the Shariah compliant hotel in Malaysia. | |
| Sharma et al. | Role of information technology in library automation and networking |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C12 | Rejection of a patent application after its publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20101208 |