CN104679880A - Device and method for dynamically storing and displaying dynamic input items and business data thereof - Google Patents
Device and method for dynamically storing and displaying dynamic input items and business data thereof Download PDFInfo
- Publication number
- CN104679880A CN104679880A CN201510110658.2A CN201510110658A CN104679880A CN 104679880 A CN104679880 A CN 104679880A CN 201510110658 A CN201510110658 A CN 201510110658A CN 104679880 A CN104679880 A CN 104679880A
- Authority
- CN
- China
- Prior art keywords
- input item
- input
- page
- data
- database
- 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
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a device and a method for dynamically storing and displaying dynamic input items and business data thereof. The aim of the invention is to use the same common pages and change original pages with a plurality of fixed input items into the uniform common pages; and the input items in the pages are generated dynamically by records inserted into a database and displayed by the method of the invention. When the data is stored and because the MongoDB database supports the storing of json (javascript object notation) objects, the page data are converted into json objects to store in the MongoDB database directly and the problem of changing the database structure once one field is added is solved; and therefore, when a basic data collection field is added newly or changed, the data storing and displaying method can be achieved without changing the code and the structural design of the database.
Description
Technical field
The present invention relates to areas of information technology, particularly the dynamic memory of a kind of dynamic input item and business datum thereof and the device that represents and method.
Background technology
Along with the development of infotech, business software and large data analysis enter every field, and in industry, basic data acquisition typing is ubiquitous for each system.Because the basic data of each business scenario is different, thus program development time to carry out customized development for the basic data acquisition typing field of each business scenario, definition specific format and the input page of type.But when practical application, the change of customer demand or business change causes the increase and decrease of basic data acquisition field to be again frequent generation in software project, even not evitable.How to solve field increase and decrease fast and effectively system is come and extra development amount can not be brought to be have challenging problem.
In existing software development, can be different according to business scenario, design multiple input page, in input page, the basic data acquisition typing field that need gather is previously defined in the page, and generate corresponding database structure and program maps structure, gathering basic data and these data are stored in a database, the row corresponding from database when inquiring about or analyze, taking out data exhibiting to user.What use the method advantage is simplicity of design, only the basic data field of required collection need be defined as row in relevant database, and complete corresponding program maps.But use the shortcoming of the method to be once business scenario change causes basic data acquisition field to change or will add new basic data acquisition field, program code and database design just have to make change to meet business need.
Therefore, a kind of data that just can reach that can need not change code and database structure design when basic data acquisition field increases newly or changes are needed to store and exhibiting method at present.
Summary of the invention
In order to overcome above-mentioned defect, the invention provides a kind of dynamic memory that just can reach data storage and the dynamic input item represented and business datum thereof and the device represented and the method that can need not change code and database structure design when basic data acquisition field increases newly or changes.
The present invention in order to the technical scheme solving its technical matters and adopt is: dynamic memory and the device represented of a kind of dynamic input item and business datum thereof, comprise
Page makeup unit, for according to page data to be restored, described page data comprises page input item collection;
Input item construction unit, for according to input item data to be restored, builds the input frame type (input frame, dat frame, combobox) of the display Name of input item, storage code, generation correspondence;
Data storage cell, for according to mating between input item data to be stored with input data, and is stored into matching relationship in database;
Data convert display unit, closes for building set of displayable data to be restored according to the matching relationship in database, searches corresponding data according to dynamic input item from database.
Dynamic memory and the method represented of dynamic input item and business datum thereof, comprise the following steps:
1) from database, find out json object according to page iden-tity, described json object structure is;
｛
" page iden-tity ": " page iden-tity number "
" input item code 1 ": " input value ",
" input item code 2 ": " input value 2 ",
……
" input item n ": " input value n "
｝
2) to search in database all input items under this page record according to page iden-tity, described input item attribute is the display title of this input field, the authentication code of input item, the type of input item;
3) in the page, title, storage code, input frame type is generated according to input item attribute;
4) according to the input value of page iden-tity, input item code reading and saving from json object.
As a further improvement on the present invention, described step 2) in the type of input item comprise input frame, combobox and dat frame.
The invention has the beneficial effects as follows: the present invention seeks to use same Universal page, originally making unified Universal page into by multiple fixing input item page, input item in the page is dynamically generated by the record inserted from database, and carry out representing of the page by the inventive method, when data store, because MongoDB database supports the storage of json object, therefore page data is converted to json object and is directly stored into MongoDB database, just solve often increase a field will incremental data library structure.Therefore solve the data that just can reach that need not change code and database structure design when basic data acquisition field increases newly or changes to store and exhibiting method.
Accompanying drawing explanation
Fig. 1 is the method flow schematic diagram that input item of the present invention dynamically generates;
Fig. 2 is the method flow schematic diagram that dynamic data of the present invention is preserved;
Fig. 3 is the method flow schematic diagram of dynamic data of the present invention reduction.
Embodiment
In order to deepen the understanding of the present invention, below in conjunction with embodiment and accompanying drawing, the invention will be further described, and this embodiment only for explaining the present invention, does not form limiting the scope of the present invention.
1) method that dynamically generates of input item, comprises
1.1 according to the mark of the page from input item attribute list, search the input item data belonging to Page Name " essential information ", described input item data comprise input item title, type, input item code.
1.1.1 as table " 1, input item attribute list "
1.2 according to the input item data acquisition found, and builds page data.
1.2.1 the display title of page dynamic field is shown as according to " input item title ".
1.2.2 page input item type is judged according to " input item type ", when type for " input frame " then this input item be imported, when type for " dat frame " then this input item type be date type, when " type " be " combobox " then this input item type be pulldown.
If 1.2.3 type is pulldown, then from combobox parameter list, uses " input item title " and " corresponding input item title " to do and mate according to the title of this input item, find all drop-down parameters.
There are 3 input items according in input frame attribute list then " essential information " page, are respectively " name ", " birthday ", " sex ".
Type " input " according to " name " uses input frame label in the page.
Type " date " according to " birthday " uses dat frame label in the page.
Type " drop-down " according to " sex " uses combobox label in the page, and according to the input item title of " sex " mate from drop-down parameter list " corresponding input item " name be called sex data acquisition (man, female), " man ", " female " is as the option value of combobox.
2) method of dynamic data preservation, comprises
2.1 obtain the identification data of the page according to the page.
2.2 obtain all dynamic input item data acquisitions according to page identification data, and described dynamic input item data acquisition comprises the display Name of input item, the input value of input item.
2.3 according to input item data acquisition, changes into database purchase object.Described storage object is json object, as " 3, page json object ".Each input item is become " key ": the structure of " value ".The value that Key is input item code, value is input item input.
" page iden-tity ", " name ", " sex " in 2.4 pages, " birthday " input item are assembled into following form:
｛
" page iden-tity ": " essential information "
" name ": " Zhang San ",
" birthday ": " 1980-01-01 ",
" sex ": " man "
｝
2.5 json objects are stored in MongoDB.
3) method of dynamic data reduction, comprises
3.1 find json object according to page iden-tity " essential information " from database.As follows
｛
" page iden-tity ": " essential information "
" name ": " Zhang San ",
" birthday ": " 1980-01-01 ",
" sex ": " man "
｝
3.2 obtain input item community set according to page iden-tity " essential information " from " table 1, input item attribute list ".
Input item title: " name " input item type: " input " input item code: " name "
Input item title: " birthday " input item type: " date " input item code: " birthday "
Input item title: " sex " input item type: " drop-down " input item code: " sex "
3.3 generate page input item according to input item property set, then have three input items in Basic Information Table
3.3.1 " name " is as the title of input frame, and the type of input item is input frame, carries out mating take out the data " Zhang San " that " key " is name according to the code of input item from the json object of 3.1.
3.3.2 " birthday " is as the title of input frame, and the type of input item is dat frame, carries out mating take out the data " 1980-01-01 " that " key " is the birthday according to the code of input item from the json object of 3.1.
3.3.3 " sex " is as the title of input frame, and the type of input item is input frame, carries out mating take out the data " man " that " key " is sex according to the code of input item from the json object of 3.1.
Table 1, input item attribute list
| Page Name | Input item title | Type | Input item code |
| Essential information | Name | Input | Name |
| Essential information | Birthday | Date | Birthday |
| Essential information | Sex | Drop-down | Sex |
Table 2, combobox parameter list
| Corresponding input item title | Drop-down option |
| Sex | Man |
| Sex | Female |
3, page json object is:
｛
" page iden-tity ": " essential information "
" name ": " Zhang San ",
" birthday ": " 1980-01-01 ",
" sex ": " man "
｝。
Claims (3)
1. the dynamic memory of dynamic input item and business datum thereof and the device that represents, is characterized in that: comprise
Page makeup unit, for according to page data to be restored, described page data comprises page input item collection;
Input item construction unit, for according to input item data to be restored, builds the input frame type of the display Name of input item, storage code, generation correspondence;
Data storage cell, for according to mating between input item data to be stored with input data, and is stored into matching relationship in database;
Data convert display unit, closes for building set of displayable data to be restored according to the matching relationship in database, searches corresponding data according to dynamic input item from database.
2. the dynamic memory of dynamic input item and business datum thereof and the method that represents, is characterized in that: comprise the following steps:
1) from database, find out json object according to page iden-tity, described json object structure is;
｛
" page iden-tity ": " page iden-tity number "
" input item code 1 ": " input value ",
" input item code 2 ": " input value 2 ",
……
" input item n ": " input value n "
｝
2) to search in database all input items under this page record according to page iden-tity, described input item attribute is the display title of this input field, the authentication code of input item, the type of input item;
3) in the page, title, storage code, input frame type is generated according to input item attribute;
4) according to the input value of page iden-tity, input item code reading and saving from json object.
3. the dynamic memory of dynamic input item according to claim 2 and business datum thereof and the method that represents, is characterized in that: described step 2) in the type of input item comprise input frame, combobox and dat frame.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510110658.2A CN104679880A (en) | 2015-03-13 | 2015-03-13 | Device and method for dynamically storing and displaying dynamic input items and business data thereof |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510110658.2A CN104679880A (en) | 2015-03-13 | 2015-03-13 | Device and method for dynamically storing and displaying dynamic input items and business data thereof |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN104679880A true CN104679880A (en) | 2015-06-03 |
Family
ID=53314922
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201510110658.2A Pending CN104679880A (en) | 2015-03-13 | 2015-03-13 | Device and method for dynamically storing and displaying dynamic input items and business data thereof |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN104679880A (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106649631A (en) * | 2016-12-07 | 2017-05-10 | 国云科技股份有限公司 | System and method for flexibly configuring additional field |
| CN111061787A (en) * | 2019-11-21 | 2020-04-24 | 新浪网技术(中国)有限公司 | Method and system for processing object relation in relational database |
| CN114265658A (en) * | 2021-12-24 | 2022-04-01 | 中国农业银行股份有限公司 | Page display method, device and equipment |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103024585A (en) * | 2012-12-28 | 2013-04-03 | Tcl集团股份有限公司 | Program recommendation system, program recommendation method and terminal equipment |
| CN103077185A (en) * | 2012-12-18 | 2013-05-01 | 厦门雅迅网络股份有限公司 | Object-based user-defined information-expanding method |
| US20130185624A1 (en) * | 2012-01-12 | 2013-07-18 | International Business Machines Corporation | Providing direct manipulation of an analytics data visualization within an analytics report |
-
2015
- 2015-03-13 CN CN201510110658.2A patent/CN104679880A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20130185624A1 (en) * | 2012-01-12 | 2013-07-18 | International Business Machines Corporation | Providing direct manipulation of an analytics data visualization within an analytics report |
| CN103077185A (en) * | 2012-12-18 | 2013-05-01 | 厦门雅迅网络股份有限公司 | Object-based user-defined information-expanding method |
| CN103024585A (en) * | 2012-12-28 | 2013-04-03 | Tcl集团股份有限公司 | Program recommendation system, program recommendation method and terminal equipment |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106649631A (en) * | 2016-12-07 | 2017-05-10 | 国云科技股份有限公司 | System and method for flexibly configuring additional field |
| CN111061787A (en) * | 2019-11-21 | 2020-04-24 | 新浪网技术(中国)有限公司 | Method and system for processing object relation in relational database |
| CN114265658A (en) * | 2021-12-24 | 2022-04-01 | 中国农业银行股份有限公司 | Page display method, device and equipment |
| CN114265658B (en) * | 2021-12-24 | 2024-03-01 | 中国农业银行股份有限公司 | Page display method, device and equipment |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110472068A (en) | Big data processing method, equipment and medium based on heterogeneous distributed knowledge mapping | |
| CN102521416B (en) | Data correlation query method and data correlation query device | |
| CN106909372B (en) | Method and system for calculating purchase path of mobile terminal user | |
| US8645421B2 (en) | Attribute based hierarchy management for estimation and forecasting | |
| CN107766309B (en) | Data table generation method and device, storage medium and electronic device | |
| CN103729337B (en) | report conversion method and device | |
| CN106933845B (en) | Method and device for realizing MDX query effect by using SQ L | |
| US11847170B2 (en) | Data visualization tool with guided visualization creation and secure publication features, and graphical user interface thereof | |
| US20080082908A1 (en) | Apparatus and method for data charting with adaptive learning | |
| CN108268565B (en) | Method and system for processing user browsing behavior data based on data warehouse | |
| US20180018402A1 (en) | Dynamic hierarchy generation based on graph data | |
| CN111367976B (en) | Method and device for exporting EXCEL file data based on JAVA reflection mechanism | |
| CN103778555A (en) | User attribute mining method and system based on user tags | |
| CN103902653A (en) | Method and device for creating data warehouse table blood relationship graph | |
| WO2019184228A1 (en) | Insurance product configuration method, device, computer apparatus, and storage medium | |
| CN103530379A (en) | Tree structure data display method and device | |
| CN105787051A (en) | Analysis method and device based on metadata model | |
| CN104679880A (en) | Device and method for dynamically storing and displaying dynamic input items and business data thereof | |
| CN107729330B (en) | Method and apparatus for acquiring data set | |
| CN102222076A (en) | Method and device for information comparison | |
| US10824803B2 (en) | System and method for logical identification of differences between spreadsheets | |
| US20070282804A1 (en) | Apparatus and method for extracting database information from a report | |
| CN103902511A (en) | Data conversion and amplifying display method and system for data table | |
| CN103605640B (en) | Form adaption method and device | |
| CN113570464B (en) | Digital currency transaction community identification method, system, equipment and storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| EXSB | Decision made by sipo to initiate substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20150603 |
|
| WD01 | Invention patent application deemed withdrawn after publication |