CN110134687A - A kind of method and system changing control inventory element by the dynamic increasing of literary name section - Google Patents
A kind of method and system changing control inventory element by the dynamic increasing of literary name section Download PDFInfo
- Publication number
- CN110134687A CN110134687A CN201910394812.1A CN201910394812A CN110134687A CN 110134687 A CN110134687 A CN 110134687A CN 201910394812 A CN201910394812 A CN 201910394812A CN 110134687 A CN110134687 A CN 110134687A
- Authority
- CN
- China
- Prior art keywords
- field
- name
- dynamic
- user
- changing control
- 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
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
Abstract
Increase the method and system for changing control inventory element the present invention relates to a kind of dynamic by literary name section, when needing newly-increased or one element of modification, the element field attribute of user's filling is saved to allocation list, it is currently modification according to the name of element field and state judgement, newly-increased or deletion element, read the type of database defined in configuration, the sql sentence for the disparate databases that Auto-matching has been finished writing, the field attribute that will fill in and target table name are combined into the word that parameter is increased by sql sentence dynamic, modifies or modify factor data table.The present invention can dynamically change the structure of tables of data.
Description
Technical field
It is especially a kind of that control inventory element is changed by the dynamic increasing of literary name section the present invention relates to E-Government technical field
Method and system.
Background technique
In the prior art, it is managed collectively the factor data of all users by creating general factor data table, passed through
The increasing of management essentials is come to the upgrading of table structure, deletes, change, specific steps are as follows:
1, factor data table is created, each field of table is defined.
2, Yong Huzeng, delete, change, looking into factor data table, to belonging to oneself data management.
If 3, having increasing, deleting, change element, need to upgrade factor data table structure.
It is in the prior art the disadvantage is that can not dynamically increase, delete, changing element, the change of element, requires to data each time
Table structure is upgraded.
Summary of the invention
In view of this, increasing the method for changing control inventory element the purpose of the present invention is to propose to a kind of dynamic by literary name section
And system, it can dynamically change the structure of tables of data.
The present invention is realized using following scheme: a method of control inventory element is changed by the dynamic increasing of literary name section, when
When needing newly-increased or one element of modification, the element field attribute of user's filling is saved to allocation list, according to element field
Name and state judgement are currently modifications, increase or delete element newly, read the type of database defined in configuration, Auto-matching
It is dynamic by sql sentence that the sql sentence for the disparate databases finished writing, the field attribute that will fill in and target table name are combined into parameter
The field of state increase, modification or modification factor data table.
Further, when saving the element field attribute of user's filling to allocation list, if field name has had presence, and
It is not deleted by logic, then prompts field name to repeat, do not can be reserved for；If field name has existed and deleted by logic, prompt to use
Whether family deletes original field, and all data that original field storage can be removed after deletion can be deleted first after user confirms deletion
Except original field, then create a same file-name field.
Further, further includes: judge whether operating result succeeds, is returned the result if operating successfully, if operation failure,
Then all data manipulations of rollback, and return the result.
It is based on what the dynamic increasing described above by literary name section changed control inventory element the present invention also provides a kind of
It unites, including memory and actuator, the instruction of method described in claim 1, the actuator is stored in the memory
The method instruction in memory is executed at runtime.
Further, in the memory also storage there are as below methods instruction: save user filling element field category
When property is to allocation list, if field name has had presence, and is not deleted by logic, then field name is prompted to repeat, do not can be reserved for；If word
Section name has existed and is deleted by logic, then prompts the user whether to delete original field, original field can be removed after deletion and is deposited
All data of storage after user confirms deletion, can first delete original field, then create a same file-name field.
Further, in the memory also storage there are as below methods instruction: judge whether operating result succeeds, if operate
It is successful then return the result, if operation failure, all data manipulations of rollback, and return the result.
Preferably, the level of key element application can also be arranged in the present invention.
Compared with prior art, the invention has the following beneficial effects: the present invention can dynamically change the structure of tables of data.Together
When, for the present invention by element as in data deposit allocation list, user can manage the element of oneself creation.The last present invention can be with
The level of key element application is set, the element that the subordinate subscriber made may be created directly using higher level user.
Detailed description of the invention
Fig. 1 is the schematic illustration of the embodiment of the present invention.
Specific embodiment
The present invention will be further described with reference to the accompanying drawings and embodiments.
It is noted that described further below be all exemplary, it is intended to provide further instruction to the application.Unless another
It indicates, all technical and scientific terms used herein has usual with the application person of an ordinary skill in the technical field
The identical meanings of understanding.
It should be noted that term used herein above is merely to describe specific embodiment, and be not intended to restricted root
According to the illustrative embodiments of the application.As used herein, unless the context clearly indicates otherwise, otherwise singular
Also it is intended to include plural form, additionally, it should be understood that, when in the present specification using term "comprising" and/or " packet
Include " when, indicate existing characteristics, step, operation, device, component and/or their combination.
As shown in Figure 1, a kind of method for changing control inventory element by the dynamic increasing of literary name section is present embodiments provided, when
When needing newly-increased or one element of modification, the element field attribute of user's filling is saved to allocation list, according to element field
Name and state judgement are currently modifications, increase or delete element newly, read the type of database defined in configuration, Auto-matching
It is dynamic by sql sentence that the sql sentence for the disparate databases finished writing, the field attribute that will fill in and target table name are combined into parameter
The field of state increase, modification or modification factor data table.
In the present embodiment, when saving the element field attribute of user's filling to allocation list, if field name is deposited
, and do not deleted by logic, then it prompts field name to repeat, not can be reserved for；If field name has existed and deleted by logic, mention
Show whether user deletes original field, all data of original field storage, after user confirms deletion, meeting can be removed after deletion
Original field is first deleted, then creates a same file-name field.
In the present embodiment, further includes: judge whether operating result succeeds, returned the result if operating successfully, if operation
Failure, then all data manipulations of rollback, and return the result.
The present embodiment is additionally provided a kind of increased based on the dynamic described above by literary name section and changes control inventory element
System, including memory and actuator are stored with the instruction of method described in claim 1, the execution in the memory
Device executes the instruction of the method in memory at runtime.
In the present embodiment, in the memory also storage there are as below methods instruction: save user filling element word
When section attribute is to allocation list, if field name has had presence, and is not deleted by logic, then prompt field name to repeat, not can be reserved for；
If field name has existed and deleted by logic, prompts the user whether to delete original field, original word can be removed after deletion
All data of section storage after user confirms deletion, can first delete original field, then create a same file-name field.
In the present embodiment, in the memory also storage there are as below methods instruction: judge whether operating result succeeds, if
It operates and successfully then returns the result, if operation failure, all data manipulations of rollback, and return the result.
Preferably, the level of key element application can also be arranged in the present embodiment.
It should be understood by those skilled in the art that, embodiments herein can provide as method, system or computer program
Product.Therefore, complete hardware embodiment, complete software embodiment or reality combining software and hardware aspects can be used in the application
Apply the form of example.Moreover, it wherein includes the computer of computer usable program code that the application, which can be used in one or more,
The computer program implemented in usable storage medium (including but not limited to magnetic disk storage, CD-ROM, optical memory etc.) produces
The form of product.
The application is referring to method, the process of equipment (system) and computer program product according to the embodiment of the present application
Figure and/or block diagram describe.It should be understood that every one stream in flowchart and/or the block diagram can be realized by computer program instructions
The combination of process and/or box in journey and/or box and flowchart and/or the block diagram.It can provide these computer programs
Instruct the processor of general purpose computer, special purpose computer, Embedded Processor or other programmable data processing devices to produce
A raw machine, so that being generated by the instruction that computer or the processor of other programmable data processing devices execute for real
The device for the function of being specified in present one or more flows of the flowchart and/or one or more blocks of the block diagram.
These computer program instructions, which may also be stored in, is able to guide computer or other programmable data processing devices with spy
Determine in the computer-readable memory that mode works, so that it includes referring to that instruction stored in the computer readable memory, which generates,
Enable the manufacture of device, the command device realize in one box of one or more flows of the flowchart and/or block diagram or
The function of being specified in multiple boxes.
These computer program instructions also can be loaded onto a computer or other programmable data processing device, so that counting
Series of operation steps are executed on calculation machine or other programmable devices to generate computer implemented processing, thus in computer or
The instruction executed on other programmable devices is provided for realizing in one or more flows of the flowchart and/or block diagram one
The step of function of being specified in a box or multiple boxes.
The above described is only a preferred embodiment of the present invention, being not that the invention has other forms of limitations, appoint
What those skilled in the art changed or be modified as possibly also with the technology contents of the disclosure above equivalent variations etc.
Imitate embodiment.But without departing from the technical solutions of the present invention, according to the technical essence of the invention to above embodiments institute
Any simple modification, equivalent variations and the remodeling made, still fall within the protection scope of technical solution of the present invention.
Claims (6)
1. a kind of dynamic by literary name section increases the method for changing control inventory element, which is characterized in that increase newly or repair when needing
When changing an element, the element field attribute of user's filling is saved to allocation list, is judged according to the name of element field and state
It is currently modification, newly-increased or deletion element, reads the type of database defined in configuration, the different numbers that Auto-matching has been finished writing
According to the sql sentence in library, the field attribute that will fill in and target table name be combined into parameter increased by sql sentence dynamic, modification or
The field of person's modification factor data table.
2. a kind of dynamic by literary name section according to claim 1 increases the method for changing control inventory element, feature exists
In, when saving the element field attribute of user's filling to allocation list, if field name has had presence, and do not deleted by logic,
Then field name is prompted to repeat, can be reserved for；If field name has existed and deleted by logic, prompt the user whether to delete original
Field, all data of original field storage can be removed after deletion, user confirms delete after, can first delete original field,
A same file-name field is created again.
3. a kind of dynamic by literary name section according to claim 1 increases the method for changing control inventory element, feature exists
In, further includes: judge whether operating result succeeds, is returned the result if operating successfully, if operation failure, all data of rollback
Operation, and return the result.
4. a kind of increase the system for changing control inventory element based on the dynamic described in claim 1 by literary name section, feature exists
In including memory and actuator are stored with the instruction of method described in claim 1, the actuator in the memory
The method instruction in memory is executed at runtime.
5. the dynamic according to claim 4 by literary name section increases the system for changing control inventory element, which is characterized in that institute
State in memory also storage there are as below methods instruction: when the element field attribute for saving user's filling is to allocation list, and not by
Logic is deleted, then prompts field name to repeat, not can be reserved for；If field name has existed and deleted by logic, user is prompted to be
It is no to delete original field, all data of original field storage can be removed after deletion, after user confirms deletion, can first be deleted former
The field come, then create a same file-name field.
6. the dynamic according to claim 4 by literary name section increases the system for changing control inventory element, which is characterized in that institute
It states in memory also storage there are as below methods instruction: judge whether operating result succeeds, returned the result if operating successfully, if grasping
Work fails, then all data manipulations of rollback, and returns the result.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910394812.1A CN110134687A (en) | 2019-05-13 | 2019-05-13 | A kind of method and system changing control inventory element by the dynamic increasing of literary name section |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910394812.1A CN110134687A (en) | 2019-05-13 | 2019-05-13 | A kind of method and system changing control inventory element by the dynamic increasing of literary name section |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN110134687A true CN110134687A (en) | 2019-08-16 |
Family
ID=67573628
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910394812.1A Pending CN110134687A (en) | 2019-05-13 | 2019-05-13 | A kind of method and system changing control inventory element by the dynamic increasing of literary name section |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110134687A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112287644A (en) * | 2020-09-30 | 2021-01-29 | 成都新潮传媒集团有限公司 | Data submission method and device, computer equipment and readable storage medium |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105701201A (en) * | 2016-01-12 | 2016-06-22 | 浪潮通用软件有限公司 | Data processing method and device |
| WO2016188240A1 (en) * | 2016-01-07 | 2016-12-01 | 中兴通讯股份有限公司 | Method and device for configuring multiple network cards |
| CN106897285A (en) * | 2015-12-17 | 2017-06-27 | 北京宸瑞国新科技有限公司 | Data Elements extract analysis system and Data Elements extract analysis method |
| CN108268615A (en) * | 2018-01-02 | 2018-07-10 | 中国工商银行股份有限公司 | A kind of data processing method, device and system |
| CN108334534A (en) * | 2017-10-27 | 2018-07-27 | 平安普惠企业管理有限公司 | Operation system field configuration method, apparatus, server and readable storage medium storing program for executing |
| CN109634984A (en) * | 2018-12-13 | 2019-04-16 | 中国银行股份有限公司 | A kind of data source configuration is converted into the method and system of SQL |
| CN109669949A (en) * | 2018-12-27 | 2019-04-23 | 广州云趣信息科技有限公司 | A kind of dynamic report generation method and system realization based on data model |
-
2019
- 2019-05-13 CN CN201910394812.1A patent/CN110134687A/en active Pending
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106897285A (en) * | 2015-12-17 | 2017-06-27 | 北京宸瑞国新科技有限公司 | Data Elements extract analysis system and Data Elements extract analysis method |
| WO2016188240A1 (en) * | 2016-01-07 | 2016-12-01 | 中兴通讯股份有限公司 | Method and device for configuring multiple network cards |
| CN105701201A (en) * | 2016-01-12 | 2016-06-22 | 浪潮通用软件有限公司 | Data processing method and device |
| CN108334534A (en) * | 2017-10-27 | 2018-07-27 | 平安普惠企业管理有限公司 | Operation system field configuration method, apparatus, server and readable storage medium storing program for executing |
| CN108268615A (en) * | 2018-01-02 | 2018-07-10 | 中国工商银行股份有限公司 | A kind of data processing method, device and system |
| CN109634984A (en) * | 2018-12-13 | 2019-04-16 | 中国银行股份有限公司 | A kind of data source configuration is converted into the method and system of SQL |
| CN109669949A (en) * | 2018-12-27 | 2019-04-23 | 广州云趣信息科技有限公司 | A kind of dynamic report generation method and system realization based on data model |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112287644A (en) * | 2020-09-30 | 2021-01-29 | 成都新潮传媒集团有限公司 | Data submission method and device, computer equipment and readable storage medium |
| CN112287644B (en) * | 2020-09-30 | 2024-01-30 | 成都新潮传媒集团有限公司 | Data submitting method, device, computer equipment and readable storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US6714949B1 (en) | Dynamic file system configurations | |
| US11755825B2 (en) | Method, system, and computing device for facilitating private drafting | |
| US8464229B2 (en) | Creation of form-based software application in a graphical user interface (GUI) environment | |
| US7895156B2 (en) | Method, system, and computer program product for implementing a model exchange framework generating a synchronization record in response to a model exchange request using fusion technology | |
| US8438534B2 (en) | Transformation of data between hierarchical data formats | |
| KR101597780B1 (en) | Method and apparatus for visually implementing software code | |
| CN108319656A (en) | Realize the method, apparatus and calculate node and system that gray scale is issued | |
| US11443054B2 (en) | Referenced access control list | |
| WO2006089092A2 (en) | Hierarchal data management | |
| CN104360892B (en) | Create the system and method for virtual machine | |
| WO2017213846A1 (en) | Automating feature graduation | |
| Swierstra et al. | The semantics of version control | |
| US7975247B2 (en) | Method and system for organizing data generated by electronic design automation tools | |
| US9595014B1 (en) | System and method for executing workflow instance and modifying same during execution | |
| CN110377610A (en) | A kind of database update method, apparatus, equipment and medium based on cloud platform | |
| KR101989074B1 (en) | Migration based on replication log in database sharding environment | |
| CN110134687A (en) | A kind of method and system changing control inventory element by the dynamic increasing of literary name section | |
| CN108984236A (en) | A kind of implementation method and equipment of virtual management platform | |
| CN112988701A (en) | Database management method, device, system and storage medium | |
| CN106778298A (en) | A kind of forced access control method and device towards real time operating system | |
| CN107861958A (en) | A kind of metadata synchronization method and device | |
| US7987443B2 (en) | Declarative association of dialog fields | |
| US9009731B2 (en) | Conversion of lightweight object to a heavyweight object | |
| US8560572B2 (en) | System for lightweight objects | |
| JP4846736B2 (en) | Parallel processing support device |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20190816 |