CN101620636A - Method and apparatus for displaying tabular data - Google Patents
Method and apparatus for displaying tabular data Download PDFInfo
- Publication number
- CN101620636A CN101620636A CN200910162948A CN200910162948A CN101620636A CN 101620636 A CN101620636 A CN 101620636A CN 200910162948 A CN200910162948 A CN 200910162948A CN 200910162948 A CN200910162948 A CN 200910162948A CN 101620636 A CN101620636 A CN 101620636A
- Authority
- CN
- China
- Prior art keywords
- data
- node
- array
- gauge outfit
- data line
- 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.)
- Granted
Links
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a method for displaying tabular data, comprising the following steps: extracting data line array from tubular data, and converting the data line array into leveling data without nesting relationship inside; traversing header elements in the data line array to obtain the relationship between the header elements; and displaying the header and leveling data corresponding to the header according to the relationship, wherein the header is formed by the header elements. In the invention, a header structure is generated adaptively, the complexity level relationship of the data is clearly displayed in the header and the data portion is displayed smoothly, thereby greatly improving the production efficiency. The invention also discloses an apparatus applying the method.
Description
Technical field
The present invention relates to technical field of data processing, relate in particular to a kind of method and apparatus that shows list data.
Background technology
Along with the development of infotech, the list data treatment technology is widely used in industries such as plan, finance and statistics.Use the list data treatment technology, the form output of lot of data with form can be very easy to demonstration and processing to data.
List data can be divided into simple table data and complicated table data, and wherein, the structure of simple table data is smooth, does not have the nest relation of data acquisition in the data line.For example:
Table(
Array(Number1＝＞1，Number2＝＞2，Number3＝＞3，Number4＝＞4，Number5＝＞5，Number6＝＞6)，
Array(Number1＝＞1，Number2＝＞2，Number3＝＞3，Number4＝＞4，Number5＝＞5，Number6＝＞6)
)
As shown in table 1, be the demonstration form of above-mentioned simple table data.
The demonstration form of table 1 simple table data
| Number1 | ?Number2 | ?Number3 | ?Number4 | ?Number5 | ?Number6 |
| ????1 | ????2 | ????3 | ????4 | ????5 | ????6 |
| ????1 | ????2 | ????3 | ????4 | ????5 | ????6 |
Complicated table data are corresponding with non-simple array, have the nest relation more than 2 layers or 2 layers in the data line of list structure.Shown in the following table data, the each row of data level of nesting that haves three layers.
Table
(?Array
(
“Name”＝＞”Jenney”，
”Work?Hours”＝＞Array
(
“Day”＝＞Array(
“Monday”＝＞6，
“Tuesday”＝＞6，
“Wednesday”＝＞6，
“Thursday”＝＞6，
“Friday”＝＞6
)，
“Actural”＝＞30，
“Plan”＝＞40
)，
“Team”＝＞”A”
)，
Array
(
“Name”＝＞”Paul”，
”Work?Hours”＝＞Array
(
“Day”＝＞Array(
“Monday”＝＞6，
“Tuesday”＝＞6，
“Wednesday”＝＞6，
“Thursday”＝＞6，
“Friday”＝＞6
)，
“Actural”＝＞30，
“Plan”＝＞40
)，
“Team”＝＞”A”
)，
Array
(
“Name”＝＞”Mike”，
”Work?Hours”＝＞Array
(
“Day”＝＞Array(
“Monday”＝＞8，
“Tuesday”＝＞8，
“Wednesday”＝＞8，
“Thursday”＝＞8，
“Friday”＝＞8
)，
“Actural”＝＞40，
“Plan”＝＞40
)，
“Team”＝＞”B”
)，
Array
(
“Name”＝＞”Tracy”，
”Work?Hours”＝＞Array
(
“Day”＝＞Array(
“Monday”＝＞8，
“Tuesday”＝＞8，
“Wednesday”＝＞8，
“Thursday”＝＞8，
“Friday”＝＞8
)，
“Actural”＝＞40，
“Plan”＝＞40
)，
“Team”＝＞”B”
)
)
As shown in table 2, be the demonstration form of above-mentioned complicated table data.
The demonstration form of the complicated table of table 2 data
In the prior art, for the processing of complexity table data, on the one hand, traditional method can first specified data be formed structure or application scenarios, and design template is last in the needs video data again, is inserted in data and finishes demonstration in template; On the other hand, use the .Net of Microsoft kit, can be with arbitrary XML (Extensible Markup Language, extend markup language) data conversion of form is the Dataset object, this object has comprised several forms, each form is a simple data table, presents the XML data by a plurality of forms, can show complex data.
The inventor finds that there is following defective at least in prior art in realizing process of the present invention:
The way of traditional design masterplate can only be adapted to single scene, when application scenarios or data layout need change, whether need manually readjust template, and test by hand inspection and to confirm wrongly, this process is loaded down with trivial details, poor efficiency, shortcoming dirigibility; And use the method for the .Net of Microsoft kit, and sometimes data are splitted into a plurality of forms to show, can't realize the purpose of data presentation in the same form, and this method open source code not, can only be used for the .Net environment, be not easy to study and transplant.
Summary of the invention
The invention provides a kind of method and apparatus that shows list data, improved the efficient of video data form.
The invention provides a kind of method that shows list data, may further comprise the steps:
From list data, extract the data line array, described data line array is converted to the inner smooth data that do not have nest relation;
Travel through the gauge outfit element in the described data line array, obtain the corresponding relation between the described gauge outfit element, according to the smooth data of described corresponding relation display gauge head and described gauge outfit correspondence, described gauge outfit is made of described gauge outfit element.
The present invention also provides a kind of device that shows list data, comprising:
Modular converter is used for extracting the data line array from list data, and described data line array is converted to the inner smooth data that do not have nest relation;
Acquisition module is used for traveling through the gauge outfit element of described data line array, obtains the corresponding relation between the described gauge outfit element;
Display module is used for the described smooth data that the described modular converter of the described corresponding relation display gauge head that obtains according to described acquisition module and described gauge outfit correspondence obtains, and described gauge outfit is made of described gauge outfit element.
The present invention is in the process that shows from the list data to the user interface, use adaptive form display algorithm, the restriction that breaks away from template, generate gauge head structure adaptively, the complicated hierarchical relationship of data is clearly illustrated in gauge outfit, and the smooth demonstration of data division, reduced the sweep time of operating personnel to data, in the demonstration work of business datum, save the priori data that must manual carry out in the conventional operation and formed and write the step of modification template, improved production efficiency significantly.
Description of drawings
In order to be illustrated more clearly in the present invention or technical scheme of the prior art, to do to introduce simply to the accompanying drawing of required use in the present invention or the description of the Prior Art below, apparently, accompanying drawing in describing below only is some embodiments of the present invention, for those of ordinary skills, under the prerequisite of not paying creative work, can also obtain other accompanying drawing according to these accompanying drawings.
Fig. 1 is a kind of method flow diagram that shows list data among the present invention;
Fig. 2 is a kind of concrete application scenarios process flow diagram that shows list data among the present invention;
Fig. 3 is the node tree structure synoptic diagram among the present invention;
Fig. 4 is a kind of apparatus structure synoptic diagram that shows list data among the present invention;
Fig. 5 shows the apparatus structure synoptic diagram of list data for the another kind among the present invention.
Embodiment
In the technical scheme provided by the invention, its core concept is for passing through intellectual analysis, and Automatic Combined goes out suitable gauge outfit, and the data line of nested complexity is adjusted into simple smooth data line, and output shows; In addition, all right configuration file is that special key word or special level are applied mechanically display styles automatically automatically.
Below in conjunction with the accompanying drawing among the present invention, technical scheme of the present invention is clearly and completely described, obviously, described embodiment is the present invention's part embodiment, rather than whole embodiment.Based on the embodiment among the present invention, those of ordinary skills belong to the scope of protection of the invention not making the every other embodiment that is obtained under the creative work prerequisite.
As shown in Figure 1, a kind of method flow diagram that shows list data among the present invention may further comprise the steps:
Step 101 is extracted the data line array from list data, this data line array is converted to the inner smooth data that do not have nest relation.
Particularly, the data element in can ergodic data line number group if the type of this data element is not an array type, then is saved in array as a result with this data element; If the type of this data element is an array type, then recurrence travels through the subdata element in this data element, finishes up to recurrence, with the data of preserving in the array as a result smooth data as data line array correspondence.
From list data, extract after the data line array, can also obtain the checking character string of this data line array correspondence, use this checking character string checking list data whether to meet call format, if list data does not meet call format, then report an error or this list data is handled as the data line of form.
Step 102, the gauge outfit element in the ergodic data line number group obtains the corresponding relation between the gauge outfit element, according to the smooth data of this corresponding relation display gauge head and gauge outfit correspondence.
Particularly, can set up the node object of gauge outfit element correspondence; According to corresponding relation between the gauge outfit element and node object structure node tree, by the output parameter of this node tree record node object; Successively travel through node tree, according to the output parameter display gauge head, this gauge outfit is made of the gauge outfit element.
Wherein, the pointer of storage father node and the pointer of child node in the node object, the pointer of father node is used for the output parameter of computing node object, and the pointer of child node is used to travel through the node tree at node object place.
The present invention is in the process that shows from the list data to the user interface, use adaptive form display algorithm, the restriction that breaks away from template, generate gauge head structure adaptively, the complicated hierarchical relationship of data is clearly illustrated in gauge outfit, and the smooth demonstration of data division, reduced the sweep time of operating personnel to data, in the demonstration work of business datum, save the priori data that must manual carry out in the conventional operation and formed and write the step of modification template, improved production efficiency significantly.
As shown in Figure 2, a kind of concrete application scenarios process flow diagram that shows list data among the present invention may further comprise the steps:
Step 201 is extracted the data line array from list data, this data line array is handled as complex data, compatible simultaneously simple smooth data layout.
Particularly, call the Travel method, the data element in the ergodic data line number group if the type of the data element of data line array is not an array type, then outputs to the data element of data line array as a result among the array RetAry as simple elements; If the type of the data element of data line array is an array type, then with this data element as input parameter, recursive call Travel method, the subdata element in the ergodic data element.After recursive call finished, all data elements of data line array were all traveled through one time, and RetAry stores the smooth data of data line array correspondence.
Step 202 is obtained the Ukey (unique key) of data line array correspondence, and uses the legitimacy of Ukey checking list data.
Wherein, Ukey is used for the character string of the composition structure of data of description line number group, if two data line number groups have identical gauge head structure, then has identical Ukey, and Ukey is initialized as null character string.
Particularly, depth-first recurrence ergodic data line number group whenever has access to the element of data line array, then the key assignments of this element is added to the afterbody of Ukey, the key-value pair of this element is answered each element among the PHP (HypertextPreprocessor, supertext pre-service language).When having access to array, import the key assignments of this array into recursion method as prefix, the daughter element key assignment combination under this array is joined tail of string as the key assignments of deep layer element.
For example, after the data line array of traversal list 2 correspondences, can be as follows obtain Ukey: " Name-WorkHours[Day[Monday-Tuesday-Wednesday-Thursday-Fri day]-Actrual-Plan]-Team ".Wherein, " " expression brotgher of node relation, the corresponding array element of " [] " expression is the member's of array element a key assignments in " [] ".
Ukey can adopt different algorithm computation to obtain, and the difference between can the unique identification data content for example, can obtain Ukey by MD5 (Message-digest Algorithm 5, the md5-challenge) value of calculating each row of data.Because algorithm is to be based upon on the basis of importing the data fit certain format, be that input parameter is an array type, and each daughter element of input parameter also is an array type, therefore, need the input parameter of verified users whether to meet the requirements,, then report an error or carry out special processing if undesirable, for example, whole data can be handled as the data line of form.
The verification method of list data comprises: the Ukey that extracts a data line number group in the list data is as reference standard, relatively whether other data line arrays have identical Ukey, if comparative result is for being that then this list data meets the requirements, otherwise this list data is undesirable.
Step 203 is obtained the corresponding relation between the gauge outfit element in the data line array, and according to the peaceful entire data of the gauge outfit of this corresponding relation output data line number group correspondence.
Wherein, the gauge outfit element is used for showing form on the interface, is the direct embodiment of data nest relation.Particularly, can extract data line array in the list data as sampled value, degree of depth ergodic data line number group, when whenever having access to a gauge outfit element, set up a node object of this gauge outfit element correspondence, and the node tree of forming by node object according to the original hierarchical relationship of data line array structure, this node tree writes down key parameter how to export gauge outfit, comprises colspan value and rowspan value; Successively travel through node tree, colspan value and rowspan value are outputed in the syntactic structure of HTML table label, just can realize the correct demonstration of gauge outfit.
Wherein, each node object in the node tree stores the corresponding father node and the pointer of child node, and the node of each layer calculates the key parameter value of oneself by the information of father node and the information of self pairing element; The pointer of child node is used to travel through the node tree at this node object place.
The calculating of key parameter rowspan and colspan is divided into following two kinds of situations: present node does not have child node, when promptly not being the array type element, colspan=1, the floor height of the rowspan=height of tree-currentElement+1, wherein, the height of tree is the maximum floor height that each node had in the tree, and the floor height of each node is the shortest path length of this node to HeadNode; Present node has child node, when being array type, and rowspan=1, the summation of the colspan value of all child nodes of colspan=, colspan value all can obtain to upgrade when having new node to be affiliated to node tree at every turn.
As shown in Figure 3, be the node tree structure synoptic diagram among the present invention, this node tree corresponding data line number group array (a1=＞a, a2=＞array (b1=＞b, b2=＞c), a3=＞d), the foundation of the node in the node tree is in proper order: HeadNode, a1, a2, b1, b2, a3, the degree of depth of node tree is 2, the floor height of HeadNode is 0, and the floor height of node a1, a2 and a3 is 1, the floor height 2 of all the other nodes.Wherein, node a1 does not have child node, colspan=1, and rowspan=sets the degree of depth-floor height+1, is 2-1+1=2; Node a2 has child node, rowspan=1, and colspan value initialization is 0, when node b1 was affiliated to node a2, node a2 was as the father node of node b1, and the colspan value can be updated, the colspan value addition of each child node of node a2 is the colspan value of node a2; When node b2 was affiliated to node a2, the colspan value of node a2 was updated once more, was the colspan value of node b1 and the colspan value sum of node b2, was 2.The situation and the above-mentioned situation of node a3 and node a1 node are similar, do not repeat them here.
As shown in table 3, be the form of the corresponding output of the node tree among Fig. 3, wherein, colspan value and rowspan value are not included in the gauge outfit as the extra value of information that adds.
The form of the corresponding output of table 3 node tree
Need to prove that the inventive method can be adjusted each sequence of steps according to actual needs.
The present invention is in the process that shows from the list data to the user interface, use adaptive form display algorithm, the restriction that breaks away from template, generate gauge head structure adaptively, the complicated hierarchical relationship of data is clearly illustrated in gauge outfit, and the smooth demonstration of data division, reduced the sweep time of operating personnel to data, in the demonstration work of business datum, save the priori data that must manual carry out in the conventional operation and formed and write the step of modification template, not unique in data structure especially, under the diverse situation, making the time consumption of performance history drop to from general several days only need write less than 5 line codes, be almost 0 time consumption, improved production efficiency significantly, avoided exploitation.In addition, realize with the PHP code, compatible good, can be transplanted in other programming languages, the form of array is adopted in the data input, the input data can be JSON, the data of XML or common array form, output interface can be webpage, Excel or text document etc., be applicable to (Hyper Text Mark-up Language in any and HTML, HTML (Hypertext Markup Language)), XML and text language etc. can show as the scene of form, and has extraordinary portability, can be applied to can not be divided into a plurality of forms to data in the various program development language, show more comprehensive, saved and switched the trouble that shows form, the nest relation of easier representation of data.
The present invention provides the methods and applications scene that shows list data in the above-described embodiment, and correspondingly, the present invention also provides the device of the method for using above-mentioned demonstration list data.
As shown in Figure 4, a kind of apparatus structure synoptic diagram that shows list data among the present invention comprises:
Above-mentioned modular converter 410 specifically is used for traveling through the data element of described data line array, if the type of described data element is not an array type, then described data element is saved in array as a result; If the type of described data element is an array type, then recurrence travels through the subdata element in the described data element, finishes up to recurrence, with the data of preserving in the described array as a result smooth data as described data line array correspondence.
Above-mentioned display module 430 specifically is used to set up the node object of described gauge outfit element correspondence; According to corresponding relation between the described gauge outfit element and described node object structure node tree, write down the output parameter of described node object by described node tree; Successively travel through described node tree, show described gauge outfit according to described output parameter.
Wherein, the pointer of storage father node and the pointer of child node in the node object, the pointer of described father node is used to calculate the output parameter of described node object, and the pointer of described child node is used to travel through the node tree at described node object place.
The present invention is in the process that shows from the list data to the user interface, use adaptive form display algorithm, the restriction that breaks away from template, generate gauge head structure adaptively, the complicated hierarchical relationship of data is clearly illustrated in gauge outfit, and the smooth demonstration of data division, reduced the sweep time of operating personnel to data, in the demonstration work of business datum, save the priori data that must manual carry out in the conventional operation and formed and write the step of modification template, improved production efficiency significantly.
As shown in Figure 5, the apparatus structure synoptic diagram for the demonstration of the another kind among the present invention list data comprises:
Particularly, modular converter 510 calls the Travel method, data element in the ergodic data line number group if the type of the data element of data line array is not an array type, then outputs to the data element of data line array as a result among the array RetAry as simple elements; If the type of the data element of data line array is an array type, then with this data element as input parameter, recursive call Travel method, the subdata element in the ergodic data element.After recursive call finished, all data elements of data line array were all traveled through one time, and RetAry stores the smooth data of data line array correspondence.
Particularly, authentication module 520 obtains the Ukey (unique key) of data line array correspondence, and uses the legitimacy of Ukey checking list data.Wherein, Ukey is used for the character string of the composition structure of data of description line number group, if two data line number groups have identical gauge head structure, then has identical Ukey, and Ukey is initialized as null character string.
For example, after the data line array of traversal list 2 correspondences, can be as follows obtain Ukey: " Name-WorkHours[Day[Monday-Tuesday-Wednesday-Thursday-Fri day]-Actrual-Plan]-Team ".Wherein, " " expression brotgher of node relation, the corresponding array element of " [] " expression is the member's of array element a key assignments in " [] ".
Ukey can adopt different algorithm computation to obtain, the difference between can the unique identification data content, for example, can be by calculating the MD5 value acquisition Ukey of each row of data.Because algorithm is to be based upon on the basis of importing the data fit certain format, be that input parameter is an array type, and each daughter element of input parameter also is an array type, therefore, need the input parameter of verified users whether to meet the requirements,, then report an error or carry out special processing if undesirable, for example, whole data can be handled as the data line of form.
The verification method of list data comprises: the Ukey that extracts a data line number group in the list data is as reference standard, relatively whether other data line arrays have identical Ukey, if comparative result is for being that then this list data meets the requirements, otherwise this list data is undesirable.
Wherein, the gauge outfit element is used for showing form on the interface, is the direct embodiment of data nest relation.Particularly, can extract data line array in the list data as sampled value, degree of depth ergodic data line number group, when whenever having access to a gauge outfit element, set up a node object of this gauge outfit element correspondence, and the node tree of forming by node object according to the original hierarchical relationship of data line array structure, this node tree writes down key parameter how to export gauge outfit, comprises colspan value and rowspan value; Successively travel through node tree, colspan value and rowspan value are outputed in the syntactic structure of HTML table label, just can realize the correct demonstration of gauge outfit.
Wherein, each node object in the node tree stores the corresponding father node and the pointer of child node, and the node of each layer calculates the key parameter value of oneself by the information of father node and the information of self pairing element; The pointer of child node is used to travel through the node tree at this node object place.
The calculating of key parameter rowspan and colspan is divided into following two kinds of situations: present node does not have child node, when promptly not being the array type element, colspan=1, the floor height of the rowspan=height of tree-currentElement+1, wherein, the height of tree is the maximum floor height that each node had in the tree, and the floor height of each node is the shortest path length of this node to HeadNode; Present node has child node, when being array type, and rowspan=1, the summation of the colspan value of all child nodes of colspan=, colspan value all can obtain to upgrade when having new node to be affiliated to node tree at every turn.
With reference to the node tree structure among Fig. 3, this node tree corresponding data line number group array (a1=＞a, a2=＞array (b1=＞b, b2=＞c), a3=＞d), the foundation of the node in the node tree is in proper order: HeadNode, a1, a2, b1, b2, a3, the degree of depth of node tree is 2, the floor height of HeadNode is 0, the floor height of node a1, a2 and a3 is 1, the floor height 2 of all the other nodes.Wherein, node a1 does not have child node, colspan=1, and rowspan=sets the degree of depth-floor height+1, is 2-1+1=2; Node a2 has child node, rowspan=1, and colspan value initialization is 0, when node b1 was affiliated to node a2, node a2 was as the father node of node b1, and the colspan value can be updated, the colspan value addition of each child node of node a2 is the colspan value of node a2; When node b2 was affiliated to node a2, the colspan value of node a2 was updated once more, was the colspan value of node b1 and the colspan value sum of node b2, was 2.The situation and the above-mentioned situation of node a3 and node a1 node are similar, do not repeat them here.
The form of the corresponding output of the node tree among Fig. 3, as shown in table 3.Wherein, colspan value and rowspan value are not included in the gauge outfit as the extra value of information that adds.
The present invention is in the process that shows from the list data to the user interface, use adaptive form display algorithm, the restriction that breaks away from template, generate gauge head structure adaptively, the complicated hierarchical relationship of data is clearly illustrated in gauge outfit, and the smooth demonstration of data division, reduced the sweep time of operating personnel to data, in the demonstration work of business datum, save the priori data that must manual carry out in the conventional operation and formed and write the step of modification template, not unique in data structure especially, under the diverse situation, making the time consumption of performance history drop to from general several days only need write less than 5 line codes, be almost 0 time consumption, improved production efficiency significantly, avoided exploitation.In addition, realize with the PHP code, compatible good, can be transplanted in other programming languages, the form of array is adopted in the data input, the input data can be JSON, the data of XML or common array form, output interface can be webpage, Excel or text document etc., be applicable in any and HTML, XML and text language etc. can show as the scene of form, and have extraordinary portability, can be applied in the various program development language, can not be divided into a plurality of forms to data, show more comprehensively, saved and switched the trouble that shows form, the nest relation of easier representation of data.
Through the above description of the embodiments, those skilled in the art can be well understood to the present invention and can realize by the mode that software adds essential general hardware platform, can certainly pass through hardware, but the former is better embodiment under a lot of situation.Based on such understanding, the part that technical scheme of the present invention contributes to prior art in essence in other words can embody with the form of software product, this computer software product is stored in the storage medium, comprise that some instructions are with so that a station terminal equipment (can be mobile phone, personal computer, server, the perhaps network equipment etc.) carry out the described method of each embodiment of the present invention.
The above only is a preferred implementation of the present invention; should be pointed out that for those skilled in the art, under the prerequisite that does not break away from the principle of the invention; can also make some improvements and modifications, these improvements and modifications also should be looked protection scope of the present invention.
It will be appreciated by those skilled in the art that the module in the device among the embodiment can be distributed in the device of embodiment according to the embodiment description, also can carry out respective change and be arranged in the one or more devices that are different from present embodiment.The module of the foregoing description can be integrated in one, and also can separate deployment; A module can be merged into, also a plurality of submodules can be further split into.
The invention described above embodiment sequence number is not represented the quality of embodiment just to description.
More than disclosed only be several specific embodiment of the present invention, still, the present invention is not limited thereto, any those skilled in the art can think variation all should fall into protection scope of the present invention.
Claims (10)
1, a kind of method that shows list data is characterized in that, may further comprise the steps:
From list data, extract the data line array, described data line array is converted to the inner smooth data that do not have nest relation;
Travel through the gauge outfit element in the described data line array, obtain the corresponding relation between the described gauge outfit element, according to the smooth data of described corresponding relation display gauge head and described gauge outfit correspondence, described gauge outfit is made of described gauge outfit element.
2, the method for claim 1 is characterized in that, described data line is converted to the inner smooth data that do not have nest relation, specifically comprises:
Travel through the data element in the described data line array,, then described data element is saved in array as a result if the type of described data element is not an array type; If the type of described data element is an array type, then recurrence travels through the subdata element in the described data element, finishes up to recurrence, with the data of preserving in the described array as a result smooth data as described data line array correspondence.
3, the method for claim 1 is characterized in that, the described extraction from list data after the data line array also comprises:
Obtain the checking character string of described data line array correspondence;
Use described checking character string to verify whether described list data meets call format,, then report an error or described list data is handled as the data line of form if described list data does not meet call format.
4, the method for claim 1 is characterized in that, the described corresponding relation that obtains between the gauge outfit element according to the corresponding relation display gauge head, specifically comprises:
Set up the node object of described gauge outfit element correspondence;
According to corresponding relation between the described gauge outfit element and described node object structure node tree, write down the output parameter of described node object by described node tree;
Successively travel through described node tree, show described gauge outfit according to described output parameter.
5, method as claimed in claim 4, it is characterized in that, the pointer of storage father node and the pointer of child node in the described node object, the pointer of described father node is used to calculate the output parameter of described node object, and the pointer of described child node is used to travel through the node tree at described node object place.
6, a kind of device that shows list data is characterized in that, comprising:
Modular converter is used for extracting the data line array from list data, and described data line array is converted to the inner smooth data that do not have nest relation;
Acquisition module is used for traveling through the gauge outfit element of described data line array, obtains the corresponding relation between the described gauge outfit element;
Display module is used for the described smooth data that the described modular converter of the described corresponding relation display gauge head that obtains according to described acquisition module and described gauge outfit correspondence obtains, and described gauge outfit is made of described gauge outfit element.
7, device as claimed in claim 6 is characterized in that,
Described modular converter specifically is used for traveling through the data element of described data line array, if the type of described data element is not an array type, then described data element is saved in array as a result; If the type of described data element is an array type, then recurrence travels through the subdata element in the described data element, finishes up to recurrence, with the data of preserving in the described array as a result smooth data as described data line array correspondence.
8, device as claimed in claim 6 is characterized in that, also comprises:
Authentication module is used to obtain the checking character string of described data line array correspondence; Use described checking character string to verify whether described list data meets call format,, then report an error or described list data is handled as the data line of form if described list data does not meet call format.
9, device as claimed in claim 6 is characterized in that,
Described display module specifically is used to set up the node object of described gauge outfit element correspondence; According to corresponding relation between the described gauge outfit element and described node object structure node tree, write down the output parameter of described node object by described node tree; Successively travel through described node tree, show described gauge outfit according to described output parameter.
10, device as claimed in claim 9, it is characterized in that, the pointer of storage father node and the pointer of child node in the described node object, the pointer of described father node is used to calculate the output parameter of described node object, and the pointer of described child node is used to travel through the node tree at described node object place.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2009101629486A CN101620636B (en) | 2009-08-21 | 2009-08-21 | Method and apparatus for displaying tabular data |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2009101629486A CN101620636B (en) | 2009-08-21 | 2009-08-21 | Method and apparatus for displaying tabular data |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN101620636A true CN101620636A (en) | 2010-01-06 |
| CN101620636B CN101620636B (en) | 2012-05-30 |
Family
ID=41513870
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN2009101629486A Active CN101620636B (en) | 2009-08-21 | 2009-08-21 | Method and apparatus for displaying tabular data |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN101620636B (en) |
Cited By (14)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103218365A (en) * | 2012-01-20 | 2013-07-24 | 阿里巴巴集团控股有限公司 | SS Table file data processing method and system |
| CN103853588A (en) * | 2012-12-05 | 2014-06-11 | 苏州精易会信息技术有限公司 | Method for resolving HTML (Hypertext Markup Language) table column operation by use of browser kernel |
| CN105117378A (en) * | 2015-08-05 | 2015-12-02 | 联动优势电子商务有限公司 | Method and apparatus for converting JSON file into EXCEL file |
| CN105488073A (en) * | 2014-09-26 | 2016-04-13 | 北京神州泰岳软件股份有限公司 | Method and device for generating report header |
| CN106708792A (en) * | 2016-12-01 | 2017-05-24 | 北京奇虎科技有限公司 | Method and apparatus for displaying report in webpage |
| CN108763546A (en) * | 2018-05-31 | 2018-11-06 | 北京五八信息技术有限公司 | A kind of conversion method of data format, device, storage medium and terminal |
| CN110019224A (en) * | 2017-12-21 | 2019-07-16 | 天津数观科技有限公司 | A kind of crosstab head generation method based on tree search |
| CN110110153A (en) * | 2018-01-24 | 2019-08-09 | 北京京东尚科信息技术有限公司 | A kind of method and apparatus of node searching |
| CN110941949A (en) * | 2019-11-21 | 2020-03-31 | 望海康信(北京)科技股份公司 | Data table rendering control method and device, computer equipment and storage medium |
| CN111831572A (en) * | 2020-07-24 | 2020-10-27 | 北京思特奇信息技术股份有限公司 | Batch comparison test method and device for realizing XML-JSON |
| CN112434491A (en) * | 2020-11-27 | 2021-03-02 | 杭州信雅达泛泰科技有限公司 | HTML table parsing system and parsing method thereof for JSON |
| CN114021536A (en) * | 2021-11-17 | 2022-02-08 | 广州天维信息技术股份有限公司 | Processing method, device, equipment and storage medium of multi-level header report |
| CN115001829A (en) * | 2022-06-07 | 2022-09-02 | 中国软件评测中心(工业和信息化部软件与集成电路促进中心) | Protocol vulnerability mining method, device, equipment and storage medium |
| CN115186640A (en) * | 2022-07-08 | 2022-10-14 | 中科星图智慧科技安徽有限公司 | Multilayer header statistical table generation algorithm and device |
-
2009
- 2009-08-21 CN CN2009101629486A patent/CN101620636B/en active Active
Cited By (18)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103218365A (en) * | 2012-01-20 | 2013-07-24 | 阿里巴巴集团控股有限公司 | SS Table file data processing method and system |
| CN103853588A (en) * | 2012-12-05 | 2014-06-11 | 苏州精易会信息技术有限公司 | Method for resolving HTML (Hypertext Markup Language) table column operation by use of browser kernel |
| CN105488073A (en) * | 2014-09-26 | 2016-04-13 | 北京神州泰岳软件股份有限公司 | Method and device for generating report header |
| CN105117378A (en) * | 2015-08-05 | 2015-12-02 | 联动优势电子商务有限公司 | Method and apparatus for converting JSON file into EXCEL file |
| CN105117378B (en) * | 2015-08-05 | 2017-10-31 | 联动优势电子商务有限公司 | A kind of JSON files are converted to the method and device of EXCEL file |
| CN106708792A (en) * | 2016-12-01 | 2017-05-24 | 北京奇虎科技有限公司 | Method and apparatus for displaying report in webpage |
| CN110019224A (en) * | 2017-12-21 | 2019-07-16 | 天津数观科技有限公司 | A kind of crosstab head generation method based on tree search |
| CN110110153A (en) * | 2018-01-24 | 2019-08-09 | 北京京东尚科信息技术有限公司 | A kind of method and apparatus of node searching |
| CN108763546A (en) * | 2018-05-31 | 2018-11-06 | 北京五八信息技术有限公司 | A kind of conversion method of data format, device, storage medium and terminal |
| CN110941949A (en) * | 2019-11-21 | 2020-03-31 | 望海康信(北京)科技股份公司 | Data table rendering control method and device, computer equipment and storage medium |
| CN110941949B (en) * | 2019-11-21 | 2020-12-11 | 望海康信(北京)科技股份公司 | Data table rendering control method and device, computer equipment and storage medium |
| CN111831572A (en) * | 2020-07-24 | 2020-10-27 | 北京思特奇信息技术股份有限公司 | Batch comparison test method and device for realizing XML-JSON |
| CN112434491A (en) * | 2020-11-27 | 2021-03-02 | 杭州信雅达泛泰科技有限公司 | HTML table parsing system and parsing method thereof for JSON |
| CN114021536A (en) * | 2021-11-17 | 2022-02-08 | 广州天维信息技术股份有限公司 | Processing method, device, equipment and storage medium of multi-level header report |
| CN114021536B (en) * | 2021-11-17 | 2022-08-09 | 广州天维信息技术股份有限公司 | Processing method, device, equipment and storage medium of multi-level header report |
| CN115001829A (en) * | 2022-06-07 | 2022-09-02 | 中国软件评测中心(工业和信息化部软件与集成电路促进中心) | Protocol vulnerability mining method, device, equipment and storage medium |
| CN115001829B (en) * | 2022-06-07 | 2024-06-07 | 中国软件评测中心(工业和信息化部软件与集成电路促进中心) | Protocol vulnerability discovery method, device, equipment and storage medium |
| CN115186640A (en) * | 2022-07-08 | 2022-10-14 | 中科星图智慧科技安徽有限公司 | Multilayer header statistical table generation algorithm and device |
Also Published As
| Publication number | Publication date |
|---|---|
| CN101620636B (en) | 2012-05-30 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN101620636B (en) | Method and apparatus for displaying tabular data | |
| US9904694B2 (en) | NoSQL relational database (RDB) data movement | |
| US8935575B2 (en) | Test data generation | |
| CN107807982B (en) | Consistency checking method and device for heterogeneous database | |
| US20070124318A1 (en) | System and method for schemaless data mapping with nested tables | |
| EP3022659A1 (en) | Systems and methods for extracting table information from documents | |
| CN106503268B (en) | Data comparison methods, devices and systems | |
| CN105389184B (en) | The configuration method and device of Product Interface information | |
| CN109086126B (en) | Task scheduling processing method and device, server, client and electronic equipment | |
| CN106557307A (en) | The processing method and processing system of business datum | |
| CN106326363A (en) | Matching method based on regular expressions and device thereof | |
| CN102707948B (en) | Source code generation method | |
| US20170199912A1 (en) | Behavior topic grids | |
| US9781065B2 (en) | Lightweight application integration for mobile cloud computing | |
| CN106126299B (en) | Service plug-in processing method and device | |
| CN105450656A (en) | APP data configuration method, device, server and system | |
| CN111046640A (en) | Dynamic generation method and device of certification document | |
| CN113271307B (en) | Data assembling method, device, computer system and storage medium | |
| CN107766519B (en) | Method for visually configuring data structure | |
| CN112926008A (en) | Method and device for generating form page, electronic equipment and storage medium | |
| CN112947944B (en) | Business work order processing method and device | |
| CN101727483A (en) | Disambiguation of tabular data | |
| CN106503162B (en) | SAP platform based page dynamic generation method and system | |
| CN109145307A (en) | User portrait recognition method, pushing method, device, equipment and storage medium | |
| CN111813769A (en) | Data processing method and device |
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 |