CN1328687C - Centralized broad spectrum report generation method based on expandable sign language - Google Patents
Centralized broad spectrum report generation method based on expandable sign language Download PDFInfo
- Publication number
- CN1328687C CN1328687C CNB031318924A CN03131892A CN1328687C CN 1328687 C CN1328687 C CN 1328687C CN B031318924 A CNB031318924 A CN B031318924A CN 03131892 A CN03131892 A CN 03131892A CN 1328687 C CN1328687 C CN 1328687C
- Authority
- CN
- China
- Prior art keywords
- report form
- configuration file
- markup language
- database
- generation method
- 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.)
- Expired - Fee Related
Links
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present invention discloses a centralized broad spectrum report form generation method based on an expandable markup language. The present invention aims to provide a report form generation method of centralized report form manufacture points and high report form manufacture efficiency. The method comprises the following steps: step 1, a configuration file of the extensible markup language of a report form is read; step 2, the required format information of the report form is analyzed and manufactured; step 3, a database is invoked; step 4, the database information for connection is extracted; step 5, the database is connected to obtain a data result set; step 6, a COM object instance of EXCEL is created by a COM component object model technology; step 7, the obtained result set is written in the EXCEL according to an appointed report form format in the extensible markup language to generate the report form; step 8, the COM object instance generated in the step 6 is released; step 9, the database connection generated in the step 5 is released. When the report form is assisted to be generated by an execution file or a dynamic connection library, the report form and the extensible markup language file are taken as an insert to be embedded in a system seamlessly.
Description
Technical field
The present invention relates to a kind of report form generation method, in particular, relating to a kind of is the centralized wide spectrum report form generation method of extend markup language based on XML.
Background technology
Form offers the data that the user is concerned about and some analysis results that produce at these data with the form of form, the form that provides with respect to other data, have characteristics such as simple and clear, directly perceived and standard, be used widely at field of telecommunications, but the statement form that present equipment vendor offers operator is various, and report output point disperses, the user is in order to make a form, need operate in a plurality of places, especially when the user is unfamiliar with the system that uses, can feel to have no way of doing it.Present in addition report making kind is confined in the scope that equipment vendor provides, if there is new demand in operator, can only waiting facilities merchant upgraded version, and give up this and have nothing for it.
Summary of the invention
The present invention is in order to overcome weak point of the prior art, provides a kind of report making point to concentrate, and report making efficient height can satisfy the centralized wide spectrum report form generation method based on extend markup language of multiple user's needs.
The present invention is achieved through the following technical solutions:
A kind of centralized wide spectrum report form generation method based on extend markup language comprises the following steps:
1) reads the extend markup language configuration file of form;
2) from the form configuration file, resolve the required format information of making form;
3) from the form configuration file, extract the Structured Query Language (SQL) statement that is used to obtain data;
4) from the form configuration file, extract the database information that will connect;
5) connect database, execution in step 3) the Structured Query Language (SQL) statement that extracts, obtain the data result collection;
6) utilize the The Component Object Model technology, create the The Component Object Model object instance of EXCEL;
7) result set that obtains is write EXCEL according to the statement form of appointment in the form configuration file, generate form;
8) release steps 6) the The Component Object Model object instance that produces;
9) release steps 5) database that produces connects.
As required, can be provided with the following step between step 4) and step 5): extraction conditions is provided with parameter from the form configuration file, and formation condition is provided with the interface, and described parameter is set.
In addition, when needs executable file or dynamic link library assist to generate form, executable file or dynamic link library in the form configuration file as in the seamless embedded system of plug-in unit.
The present invention has following beneficial effect: report making point of the present invention is concentrated, and has improved report making efficient.Can add the form that satisfies customer requirements at any time according to user's requirement in addition, realize the wide spectrumization of report making, flexibility is oversimplified in centralization.
Description of drawings
Fig. 1 is the process flow diagram of an embodiment of the centralized wide spectrum report form generation method based on XML of the present invention.
Fig. 2 is the XML configuration specification of form.
Fig. 3 is the form condition setting interface that embodiment generates according to the XML configuration file.
Fig. 4 utilizes the present invention to make the case effect figure of a short message service work report A table.
Embodiment
A kind of form is corresponding to an XML form configuration file, and this XML file comes out form so that OO method is abstract.Form is divided into appearance form and two parts of data.
The appearance form part is main to be described:
A) whether form is the report form template that has operator to provide, and report form template has been stipulated the mode that data are filled in.
B) if template is arranged, to point out that also fixed point writes or write line by line, to point out also that for row-by-row system report data fills in interval (promptly from what row of what row, to what what row end of row).
C) whether the generation of form will pass through other modules (as executable program, dynamic link library etc.), can not obtain under the situation of data result at report program self in other words, can provide to obtain the module that data result helps.
Data division is divided into data source again and data pick-up reaches and two parts of form corresponding field:
A) for the data source part, it is mainly described:
Data source;
Account number (username and password);
B) reach and form corresponding field part for data pick-up, it is mainly described:
The field part of inquiry (comprise the field in the data source, corresponding form grid is presented to the prefix of form, for there being template form prefix information just can not have, and for the aggregate function of this field, as suing for peace, asks average etc.);
The condition part (comprising the interface display title, the position on the interface, condition classification etc.) of inquiry;
Table set part in the data source of inquiry;
The ordering part (this part that fixed point is write do not need) of result set.
Two parts to top object-oriented description, by third-party software, can resolve such as MSXML (the XML document parser of Microsoft), obtain generating the enough information of a form, just can carry out the connection of database, the extraction of data then, according to the form presentation information, data are outputed among the EXCEL (the electronic spreadsheet instrument of Microsoft) at last, generate the form of an EXCEL form.When the user has new form demand, can claim to the equipment supplier, the equipment supplier correspondingly provides XML form configuration file as plug-in unit, and operator can add this plug-in unit in the concentrated report generating system, without equipment vendor's upgraded version dynamically.If equipment vendor also needs executable file or dynamic link library to assist to generate form, also can provide together, with XML form configuration file as in the seamless embedded system of plug-in unit.
Be that specific embodiment elaborates to the present invention to make a short message service work report A table below.
The form standards of 2 regulations are with reference to the accompanying drawings used the XML file of the XML Notepad customization short message service work report A table of Microsoft, want to comprise in clear and definite in this document:
The database that connects, user's name and password;
Because this form, operator provides template, thus to specify the title of template file, from writing of that row and those row beginning data;
Specify with this form related from database the field of those tables of data;
Specify zero-time and the concluding time and the time segment information of report form statistics;
Specific font, whether want information such as report form preview.
The XML file is a text-only file, as long as support the editing machine of text can be used for writing XML form configuration file, and such as the notepad under the WINDOWS, can certainly be with the special editing machine of setting up the XML file, as the XML Notepad of Microsoft.
1) report program reads the short message service work report A table configuration file of describing with XML.
2) resolve required relevant information such as the gauge outfit of making form in the configuration file, format informations such as font.
3) Structured Query Language (SQL) of extracting and putting in order out the return data result set is a SQL statement, and by this SQL statement, report program will obtain to be used to make the required data result of form.
4) extract the database information that will connect.
5) extraction conditions is provided with parameter, and formation condition is provided with the interface, as accompanying drawing 3.From date and time and date of expiry and time are arranged on this interface, four time periods, correlation parameter (as the start time, zero-time, time period etc.) is set on this interface.After condition setting is good, report program will generate the SQL statement that extracts result set.
6) connect database, carry out SQL statement, obtain the data result collection.
7) utilizing COM is the The Component Object Model technology, creates the com object example of EXCEL, and the com object example is exactly to create an EXCEL component object in calculator memory, and this component object provides number of C OM interface, uses for the program of creating this object.
8) data result of Huo Deing writes EXCEL (the electronic spreadsheet instrument of Microsoft) according to the statement form (such as specifying grid, writing line by line etc.) of appointment in the XML form configuration file, generates the short message service work report A table as accompanying drawing 4.
9) release steps 7) the com object example that produces.
1) release steps 6) database that produces connects.
Although the disclosed centralized wide spectrum report form generation method that relates to based on XML has been carried out special description with reference to embodiment, those skilled in the art can understand, under the situation that does not depart from scope and spirit of the present invention, can carry out all conspicuous modification of form and details to it, method for expressing as query portion, increase or the needed content of deletion generation database SQL statement, increase the regulation of EXCEL font etc.Therefore, embodiment described above is illustrative and not restrictive, and under the situation that does not break away from the spirit and scope of the present invention, all variations and modification are all within the scope of the present invention.
Claims (3)
1. the centralized wide spectrum report form generation method based on extend markup language is characterized in that, comprises the following steps:
1) reads the form configuration file of describing with extend markup language;
2) from described form configuration file, resolve the required format information of making form;
3) from described form configuration file, extract the Structured Query Language (SQL) statement that is used to obtain data;
4) from described form configuration file, extract the database information that will connect;
5) connect database, carry out the Structured Query Language (SQL) statement that described step 3) is extracted, obtain the data result collection;
6) utilize the The Component Object Model technology, create the The Component Object Model object instance of EXCEL;
7) result set that obtains is write EXCEL according to the statement form of appointment in the described form configuration file, generate form;
8) release steps 6) the The Component Object Model object instance that produces;
9) release steps 5) database that produces connects.
2. the centralized wide spectrum report form generation method based on extend markup language according to claim 1, it is characterized in that, be provided with the following step between step 4) and step 5): extraction conditions is provided with parameter from described form configuration file, and formation condition is provided with the interface, and described parameter is set.
3. the centralized wide spectrum report form generation method based on extend markup language according to claim 1 and 2, it is characterized in that, when needs executable file or dynamic link library assist to generate form, executable file or dynamic link library with described form configuration file as plug-in unit seamless embedding adopt in the system of this form.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNB031318924A CN1328687C (en) | 2003-06-11 | 2003-06-11 | Centralized broad spectrum report generation method based on expandable sign language |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNB031318924A CN1328687C (en) | 2003-06-11 | 2003-06-11 | Centralized broad spectrum report generation method based on expandable sign language |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN1567287A CN1567287A (en) | 2005-01-19 |
| CN1328687C true CN1328687C (en) | 2007-07-25 |
Family
ID=34469802
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CNB031318924A Expired - Fee Related CN1328687C (en) | 2003-06-11 | 2003-06-11 | Centralized broad spectrum report generation method based on expandable sign language |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN1328687C (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103150380A (en) * | 2013-03-13 | 2013-06-12 | 河海大学 | Table format customizable Excel table analysis method |
Families Citing this family (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102163188A (en) * | 2011-04-07 | 2011-08-24 | 北京数码大方科技有限公司 | Generation method and device thereof for EXCEL report in application system |
| US9483456B2 (en) | 2011-09-19 | 2016-11-01 | Jeffrey Dean Honsowetz | Grid data management |
| CN103294691A (en) * | 2012-02-24 | 2013-09-11 | 镇江华扬信息科技有限公司 | XML (extensive makeup language)-based EXCEL report generation method in JAVA environment |
| CN103631764B (en) * | 2013-12-18 | 2016-09-14 | 用友网络科技股份有限公司 | Report design method based on extension mechanism |
| CN104978331B (en) * | 2014-04-04 | 2019-02-19 | 北京北方华创微电子装备有限公司 | Increase the method and system of data acquisition item |
| CN105095453A (en) * | 2015-07-27 | 2015-11-25 | 浪潮通用软件有限公司 | Method and device for obtaining data |
| CN106570037A (en) * | 2015-10-12 | 2017-04-19 | 中兴通讯股份有限公司 | Data processing method and device |
| CN105893053B (en) * | 2016-04-21 | 2020-01-31 | 国网上海市电力公司 | report generation method based on Excel annotation |
| CN106339361A (en) * | 2016-08-18 | 2017-01-18 | 北京天创星图信息技术有限公司 | Method for flexibly configuring field survey data record form |
| CN106874247B (en) * | 2017-01-03 | 2021-02-12 | 北京神州绿盟信息安全科技股份有限公司 | Report generation method and device |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2001063446A2 (en) * | 2000-02-25 | 2001-08-30 | Ocwen Technology Xchange, Inc. | Method for workflow processing through computer network |
| JP2002169836A (en) * | 2000-11-30 | 2002-06-14 | Sharp Corp | Support system for integration and rearrangement of information |
| CN1414485A (en) * | 2001-10-26 | 2003-04-30 | 日本电气株式会社 | Contents conversion system, automatic pattern table selection method and its program |
-
2003
- 2003-06-11 CN CNB031318924A patent/CN1328687C/en not_active Expired - Fee Related
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2001063446A2 (en) * | 2000-02-25 | 2001-08-30 | Ocwen Technology Xchange, Inc. | Method for workflow processing through computer network |
| JP2002169836A (en) * | 2000-11-30 | 2002-06-14 | Sharp Corp | Support system for integration and rearrangement of information |
| CN1414485A (en) * | 2001-10-26 | 2003-04-30 | 日本电气株式会社 | Contents conversion system, automatic pattern table selection method and its program |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103150380A (en) * | 2013-03-13 | 2013-06-12 | 河海大学 | Table format customizable Excel table analysis method |
Also Published As
| Publication number | Publication date |
|---|---|
| CN1567287A (en) | 2005-01-19 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN101122899B (en) | Report generation method and device | |
| US6442714B1 (en) | Web-based integrated testing and reporting system | |
| CN111079047B (en) | Web-oriented page construction system | |
| CN101599067B (en) | Method of self-customizing report forms for users | |
| CN1328687C (en) | Centralized broad spectrum report generation method based on expandable sign language | |
| CN103077185A (en) | Object-based user-defined information-expanding method | |
| CA2539474A1 (en) | System and method for dynamic generation and customization of web service client applications for terminals | |
| US20040015782A1 (en) | Templating method for automated generation of print product catalogs | |
| CN102968306A (en) | Method and system for automatically generating code based on data model drive | |
| CN109710250B (en) | Visualization engine system and method for constructing user interface | |
| CN101751382A (en) | Data acquisition method based on labels and system thereof | |
| CN103530407B (en) | Method and device for generating rich text document | |
| CN102945287A (en) | Java server page (JSP) data automatic paging java standard tag library (JSTL) label technology and application | |
| CN108170409B (en) | Development method and system of WEB front-end control | |
| CN101609399A (en) | Intelligent website development system and method based on modeling | |
| CN105786505A (en) | Json based complex web page component self-defining method and device | |
| CN111158687B (en) | Interface generation method and device of JAVA plugin, computer equipment and storage medium | |
| CN111324390A (en) | Device and method for realizing APP content configuration and real-time update | |
| CN105007539A (en) | HTML template-based method, equipment and system for releasing graphics and text information via television | |
| CN101727327B (en) | Development method for visual JSP interface based on GEF technology | |
| CN109445775A (en) | One key activity inline code method, apparatus and computer readable storage medium | |
| CN100433023C (en) | Method and system for drawing schematic diagram design document | |
| CN114707474A (en) | Report generation method and device, electronic equipment and computer readable storage medium | |
| CA2733456A1 (en) | System and method for designing and generating online stationery | |
| CN110148019B (en) | Information flow operation template creating method and information flow operation template creating system |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant | ||
| CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20070725 Termination date: 20140611 |
|
| EXPY | Termination of patent right or utility model |