CN103473316A - Data column dynamically displaying method and device - Google Patents
Data column dynamically displaying method and device Download PDFInfo
- Publication number
- CN103473316A CN103473316A CN2013104129411A CN201310412941A CN103473316A CN 103473316 A CN103473316 A CN 103473316A CN 2013104129411 A CN2013104129411 A CN 2013104129411A CN 201310412941 A CN201310412941 A CN 201310412941A CN 103473316 A CN103473316 A CN 103473316A
- Authority
- CN
- China
- Prior art keywords
- data
- background server
- dynamic
- report
- row
- 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
- 238000000034 method Methods 0.000 title claims abstract description 22
- 230000002123 temporal effect Effects 0.000 claims description 6
- 230000009286 beneficial effect Effects 0.000 description 3
- 238000011161 development Methods 0.000 description 3
- 230000027455 binding Effects 0.000 description 2
- 238000009739 binding Methods 0.000 description 2
- 238000005516 engineering process Methods 0.000 description 2
- 238000000605 extraction Methods 0.000 description 2
- 238000012423 maintenance Methods 0.000 description 2
- 238000012545 processing Methods 0.000 description 2
- 238000011156 evaluation Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000012546 transfer Methods 0.000 description 1
- 230000007704 transition Effects 0.000 description 1
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention relates to a data column dynamically displaying method and device. The method comprises the following steps that a website backstage server collects achievement detail data and creates a basic report according to the achievement detail data; a webpage sends a column display request to the website backstage server; the website backstage server generates target report header information according to the column display request and initializes the target report header information; the website backstage server establishes a dynamic report according to the target report header information, obtains a data column corresponding to a target report header from the basic report and stores the data column into the dynamic report to generate a dynamic data column report; the webpage calls the dynamic data column report for display. The data column dynamically displaying method and device can select the designated part of data columns for display according to various query conditions on the basis of displaying data and can avoid the appearance of redundant columns during data display.
Description
Technical field
The present invention relates to a kind of complex report forms Dynamic Display method, particularly a kind of data rows Dynamic Display method and device.
Background technology
Quickening along with UNICOM's business development speed, excavate and run potential 3G mobile network service in order to improve, good service provider makes the transition, the line of delegating power, realize the responsibility management and control, realizes the fine management management acted freely, now all kinds of Developing channels and personnel are carried out to the examination of business aspect, thereby realize the management and control to operation cost, transfer relevant speciality informant employee and make enthusiasm, therefore proposed the concept of checking system.
Existing evaluation method, by the examination responsible official, in fixed time per month, to extracting the data of all kinds of incomes and development in corresponding system, manually according to rule, carry out the calculating of achievement, and, now because the existence of checking system has been arranged, can solve the extraction problem of all kinds of income development datasets, realize the examination to personnel and unit from system.Yet due to the regular complicacy of examination, the diversity of examination object, when relevant responsible official checks score of the examination detail, if according to traditional form way, all index item need be showed as gauge outfit, will cause a large amount of redundant columns like this, show the index that index is listed as or certain districts and cities is not the examined row that some certain class objects do not have, this has just increased the difficulty of examination responsible official when checking data, and if sub-module is showed, a large amount of duplicated codes can in system, occur, increase the workload of later maintenance.
If can be in a form, show different row according to different condition, dynamic generating report forms, the checking of the score of the examination detail that can examine more intuitively, easily the responsible official to provide them to be concerned about, reduce the complicacy of operation, be beneficial to the associated maintenance of later stage for table simultaneously.
Summary of the invention
Technical matters to be solved by this invention is to provide a kind of the realization on the basis of display data, according to different querying conditions, selects the partial data of appointment to be listed as data rows Dynamic Display method and the device of being showed.
The technical scheme that the present invention solves the problems of the technologies described above is as follows: a kind of data rows Dynamic Display method comprises the following steps:
Step 1: the website background server gathers the achievement detailed data, and detailed data creates base report on merit;
Step 2: Webpage sends row to the website background server and shows request;
Step 3: the website background server is showed request according to row, generates the object table header, initialization object table header;
Step 4: the website background server builds dynamic statement according to the object table header, and obtains the data rows corresponding with the target gauge outfit from base report, and data rows is stored in dynamic statement, generates dynamic data row form;
Step 5: Webpage calls dynamic data row form and is shown.
The invention has the beneficial effects as follows: use the present invention can abandon in detail list, the nonsensical index item for certain class object, more intuitively, react effectively, accurately the Check of indices, reduced the appearance of redundant columns, improved the readability of detail list and traffic table, solved functional similarity, but the tables of data gauge outfit of showing can't be unified problem, the different problem of index item that will show different districts and cities different examination object, proposed a solution more flexibly.
On the basis of technique scheme, the present invention can also do following improvement.
Further, in described step 1, the website background server comprises data acquisition platform, by the sql statement, obtains the achievement detailed data in database.
In described step 2, row show that request comprises report name, examination time, examination object and type information.
In described step 3, the object table header comprises one or more in report name, examination time, examination object and type information.
Further, a kind of data rows Dynamic Display device, comprise Webpage 1 and website background server 2;
Described Webpage 1, show request for to website background server 2, sending row, and the dynamic data row form that calls 2 generations of website background server is shown;
Described website background server 2, for gathering the achievement detailed data, detailed data creates base report on merit; Receive row and show request, according to row, show request, generate the object table header, initialization object table header; The website background server builds dynamic statement according to the object table header, and obtains the data rows corresponding with the target gauge outfit from base report, and data rows is stored in dynamic statement, generates dynamic data row form.
The beneficial effect that adopts above-mentioned further scheme is to abandon in detail list, the nonsensical index item for certain class object, more intuitively, react effectively, accurately the Check of indices, reduced the appearance of redundant columns, improved the readability of detail list and traffic table, solved functional similarity, but the tables of data gauge outfit of showing can't be unified problem, the different problem of index item that will show different districts and cities different examination object, proposed a solution more flexibly.
Described website background server comprises data acquisition platform, and described data acquisition platform obtains the achievement detailed data in database by the sql statement.
The row that described Webpage 1 sends show that request comprises report name information, examination temporal information, examination object information and type information.
Described website background server 2 generate the object table header comprise one or more in report name information, examination temporal information, examination object information and type information.
The accompanying drawing explanation
Fig. 1 is the inventive method flow chart of steps;
Fig. 2 is apparatus of the present invention structural drawing.
In accompanying drawing, the list of parts of each label representative is as follows:
1, Webpage, 2, the website background server.
Embodiment
Below in conjunction with accompanying drawing, principle of the present invention and feature are described, example, only for explaining the present invention, is not intended to limit scope of the present invention.
As shown in Figure 1, be the inventive method flow chart of steps; Fig. 2 is apparatus of the present invention structural drawing.
A kind of data rows Dynamic Display method comprises the following steps:
Step 1: the website background server gathers the achievement detailed data, and detailed data creates base report on merit, and described website background server comprises data acquisition platform, by the sql statement, obtains the achievement detailed data in database;
Step 2: Webpage sends row to the website background server and shows request, and described row show that request comprises report name, examination time, examination object and type information.；
Step 3: the website background server is showed request according to row, generates the object table header, initialization object table header, and described object table header comprises one or more in report name, examination time, examination object and type information;
Step 4: the website background server builds dynamic statement according to the object table header, and obtains the data rows corresponding with the target gauge outfit from base report, and data rows is stored in dynamic statement, generates dynamic data row form;
Step 5: Webpage calls dynamic data row form and is shown.
A kind of data rows Dynamic Display device, comprise Webpage 1 and website background server 2;
Described Webpage 1, show request for to website background server 2, sending row, and the dynamic data row form that calls 2 generations of website background server is shown;
Described website background server 2, for gathering the achievement detailed data, detailed data creates base report on merit; Receive row and show request, according to row, show request, generate the object table header, initialization object table header; The website background server builds dynamic statement according to the object table header, and obtains the data rows corresponding with the target gauge outfit from base report, and data rows is stored in dynamic statement, generates dynamic data row form.
Described website background server comprises data acquisition platform, and described data acquisition platform obtains the achievement detailed data in database by the sql statement.The row that described Webpage 1 sends show that request comprises report name information, examination temporal information, examination object information and type information.Described website background server 2 generate the object table header comprise one or more in report name information, examination temporal information, examination object information and type information.
Realization of the present invention, the support of basic data need to be arranged, therefore special data acquisition platform need to be arranged, can write the extraction that the sql statement carries out data by database, calculating by the score of the examination is aggregated in correlation table, the list structure of this table pays particular attention to, and the row name of each row is the signs when the later stage, realization dynamically represented.
Under the prerequisite possessed in basic data, need to make a form the most basic, only show the fixing indivedual row that will show in form, but still all data rows in table as a result need be inquired about and obtained, utilize the javascript script to accept and transmit correlation parameter.In addition, also be required to be form configuration Event Handler Class, be used for dynamically controlling the displaying of form row in engineering.
Write the processing class in engineering, inherit the ReportEventAdapter class, rewrite the initialize method, in the method, obtain the parameter that function pages transmits, go out the gauge outfit that will show by these parameter queries, rewrite the beforeFactory method, corresponding with the row name by the gauge outfit name, extract these row in base report, dynamically be added to the page and showed, and pattern can be set.
In use, 1, newly-built simple form, when newly-built form, add and bind classify the fixedly row that must show as, be generally essential information, as object oriented and relevant department.But while writing the sql statement in DataSet, need all row are all checked out, only do not carry out the bindings of form row.2, process class for the form binding, determine the title of table, convenient in the java code, generate the object data of this table, thereby association attributes is set.In the EventHandlerClass item, make form when being called the position configuration at processing class place, can arrive to process in class and carry out associative operation, thereby realize the Dynamic Display of form.3, realize the displaying of dynamic column in the java code.
The foregoing is only preferred embodiment of the present invention, in order to limit the present invention, within the spirit and principles in the present invention not all, any modification of doing, be equal to replacement, improvement etc., within all should being included in protection scope of the present invention.
Claims (8)
1. a data rows Dynamic Display method, is characterized in that, comprises the following steps:
Step 1: the website background server gathers the achievement detailed data, and detailed data creates base report on merit;
Step 2: Webpage sends row to the website background server and shows request;
Step 3: the website background server is showed request according to row, generates the object table header, initialization object table header;
Step 4: the website background server builds dynamic statement according to the object table header, and obtains the data rows corresponding with the target gauge outfit from base report, and data rows is stored in dynamic statement, generates dynamic data row form;
Step 5: Webpage calls dynamic data row form and is shown.
2. data rows Dynamic Display method according to claim 1, it is characterized in that: in described step 1, the website background server comprises data acquisition platform, by the sql statement, obtains the achievement detailed data in database.
3. data rows Dynamic Display method according to claim 1, is characterized in that: be listed as in described step 2 and show that request comprises report name, examination time, examination object and type information.
4. data rows Dynamic Display method according to claim 1 is characterized in that: in described step 3, the object table header comprises one or more in report name, examination time, examination object and type information.
5. a data rows Dynamic Display device, is characterized in that: comprise Webpage (1) and website background server (2);
Described Webpage (1), show request for to website background server (2), sending row, and the dynamic data row form that calls website background server (2) generation is shown;
Described website background server (2), for gathering the achievement detailed data, detailed data creates base report on merit; Receive row and show request, according to row, show request, generate the object table header, initialization object table header; The website background server builds dynamic statement according to the object table header, and obtains the data rows corresponding with the target gauge outfit from base report, and data rows is stored in dynamic statement, generates dynamic data row form.
6. data rows Dynamic Display device according to claim 5, it is characterized in that: described website background server comprises data acquisition platform, described data acquisition platform obtains the achievement detailed data in database by the sql statement.
7. data rows Dynamic Display device according to claim 5 is characterized in that: the row that described Webpage (1) sends show that request comprises report name information, examination temporal information, examination object information and type information.
8. data rows Dynamic Display device according to claim 5 is characterized in that: described website background server (2) generate the object table header comprise one or more in report name information, examination temporal information, examination object information and type information.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2013104129411A CN103473316A (en) | 2013-09-11 | 2013-09-11 | Data column dynamically displaying method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2013104129411A CN103473316A (en) | 2013-09-11 | 2013-09-11 | Data column dynamically displaying method and device |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN103473316A true CN103473316A (en) | 2013-12-25 |
Family
ID=49798164
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN2013104129411A Pending CN103473316A (en) | 2013-09-11 | 2013-09-11 | Data column dynamically displaying method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103473316A (en) |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104317943A (en) * | 2014-10-31 | 2015-01-28 | 北京思特奇信息技术股份有限公司 | Graphical report displaying method and system for assessment system |
| CN105069665A (en) * | 2015-09-06 | 2015-11-18 | 北京京东尚科信息技术有限公司 | Sorting and display method and apparatus of multi-channel off-site advertisement report data |
| CN105426470A (en) * | 2015-11-16 | 2016-03-23 | 上海斐讯数据通信技术有限公司 | A system and method for dynamically generating tables |
| CN112667638A (en) * | 2020-12-31 | 2021-04-16 | 新奥数能科技有限公司 | Dynamic report generation method and device, terminal equipment and readable storage medium |
| CN113139013A (en) * | 2021-03-25 | 2021-07-20 | 北京思特奇信息技术股份有限公司 | Method and system for dynamically configuring view display |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6055541A (en) * | 1997-09-19 | 2000-04-25 | Sas Ip, Inc. | Automatic report generating system |
| CN102662962A (en) * | 2012-03-08 | 2012-09-12 | 北京神州数码思特奇信息技术股份有限公司 | Dynamic display method based on webpage elements |
| CN103019683A (en) * | 2012-11-20 | 2013-04-03 | 北京思特奇信息技术股份有限公司 | Method for dynamically configuring page view |
| CN103019684A (en) * | 2012-11-20 | 2013-04-03 | 北京思特奇信息技术股份有限公司 | Dynamic template-based business page configuring method |
| CN103019685A (en) * | 2012-11-20 | 2013-04-03 | 北京思特奇信息技术股份有限公司 | System and method for generating business interface based on page element |
| CN103064689A (en) * | 2013-01-04 | 2013-04-24 | 大唐软件技术股份有限公司 | Implementation method and system for dynamically generating report pages |
| CN103092580A (en) * | 2011-10-27 | 2013-05-08 | 镇江雅迅软件有限责任公司 | Ajax (asynchronous javascript and XML) technology based dynamic header control implementation |
-
2013
- 2013-09-11 CN CN2013104129411A patent/CN103473316A/en active Pending
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6055541A (en) * | 1997-09-19 | 2000-04-25 | Sas Ip, Inc. | Automatic report generating system |
| CN103092580A (en) * | 2011-10-27 | 2013-05-08 | 镇江雅迅软件有限责任公司 | Ajax (asynchronous javascript and XML) technology based dynamic header control implementation |
| CN102662962A (en) * | 2012-03-08 | 2012-09-12 | 北京神州数码思特奇信息技术股份有限公司 | Dynamic display method based on webpage elements |
| CN103019683A (en) * | 2012-11-20 | 2013-04-03 | 北京思特奇信息技术股份有限公司 | Method for dynamically configuring page view |
| CN103019684A (en) * | 2012-11-20 | 2013-04-03 | 北京思特奇信息技术股份有限公司 | Dynamic template-based business page configuring method |
| CN103019685A (en) * | 2012-11-20 | 2013-04-03 | 北京思特奇信息技术股份有限公司 | System and method for generating business interface based on page element |
| CN103064689A (en) * | 2013-01-04 | 2013-04-24 | 大唐软件技术股份有限公司 | Implementation method and system for dynamically generating report pages |
Non-Patent Citations (1)
| Title |
|---|
| 张文启: "基于AJAX的可复用Web报表系统的设计及实现", 《万方数据库》 * |
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104317943A (en) * | 2014-10-31 | 2015-01-28 | 北京思特奇信息技术股份有限公司 | Graphical report displaying method and system for assessment system |
| CN105069665A (en) * | 2015-09-06 | 2015-11-18 | 北京京东尚科信息技术有限公司 | Sorting and display method and apparatus of multi-channel off-site advertisement report data |
| CN105426470A (en) * | 2015-11-16 | 2016-03-23 | 上海斐讯数据通信技术有限公司 | A system and method for dynamically generating tables |
| CN105426470B (en) * | 2015-11-16 | 2019-06-18 | 上海斐讯数据通信技术有限公司 | System and method for dynamically generating table |
| CN112667638A (en) * | 2020-12-31 | 2021-04-16 | 新奥数能科技有限公司 | Dynamic report generation method and device, terminal equipment and readable storage medium |
| CN113139013A (en) * | 2021-03-25 | 2021-07-20 | 北京思特奇信息技术股份有限公司 | Method and system for dynamically configuring view display |
| CN113139013B (en) * | 2021-03-25 | 2024-03-19 | 北京思特奇信息技术股份有限公司 | Method and system for displaying dynamic configuration view |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103136335B (en) | A kind of data control method based on data platform | |
| US10009391B1 (en) | Apparatus and method for acquiring, managing, sharing, monitoring, analyzing and publishing web-based time series data | |
| US8874600B2 (en) | System and method for building a cloud aware massive data analytics solution background | |
| US10515386B2 (en) | System and method for performing cross-platform big data analytics | |
| CN106682150B (en) | Method and device for processing information | |
| US20140200988A1 (en) | System and method for normalizing campaign data gathered from a plurality of advertising platforms | |
| CN103605651A (en) | Data processing showing method based on on-line analytical processing (OLAP) multi-dimensional analysis | |
| CN104182506A (en) | Log management method | |
| US20180253754A1 (en) | System and method for tracking users across a plurality of media platforms | |
| CN114186000B (en) | Method, device and storage medium for monitoring business data based on Flink | |
| CN103473316A (en) | Data column dynamically displaying method and device | |
| CN106462559A (en) | Arbitrary size content item generation | |
| US20130196689A1 (en) | Location Analytics Systems and Methods | |
| CN110737706A (en) | Data management method, device, equipment and computer readable storage medium | |
| EP2974326A1 (en) | Methods and apparatus to integrate tagged media impressions with panelist information | |
| CN110955690A (en) | Self-service data labeling platform and self-service data labeling method based on big data technology | |
| CN106503274A (en) | A kind of Data Integration and searching method and server | |
| CN102073455B (en) | Database-based multi-screen data switching display method | |
| US8856179B2 (en) | Method to send a short message service (SMS) campaign to a related object by selecting the base object | |
| CN112115145A (en) | Data acquisition method and device, electronic equipment and storage medium | |
| CN105069665B (en) | Method and device for displaying sequencing of multi-channel off-site advertisement report data | |
| CN102819542A (en) | Method and device for presenting instance documents | |
| CN111553133B (en) | Report generation method and device, electronic equipment and storage medium | |
| US11308104B2 (en) | Knowledge graph-based lineage tracking | |
| CN102866985B (en) | For data formatter and the method for on-line analysing processing 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 | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20131225 |
|
| RJ01 | Rejection of invention patent application after publication |