A method and system for bulk modification of tabular data
By establishing a mapping table and a field information table, and combining the input parameters, rapid batch modification of table data is achieved, solving the problem of modifying multiple rows and fields of table data in existing technologies, and improving operational efficiency and convenience.
CN117874023BActive Publication Date: 2026-06-09中孚安全技术有限公司
Patent Information
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- 中孚安全技术有限公司
- Filing Date
- 2023-12-18
- Publication Date
- 2026-06-09
Smart Images
Figure CN117874023B_ABST
Abstract
The application provides a table data batch modification method and system, which establishes a mapping table and a field information table, finds a place needing batch modification in a table through an input parameter, finds field information of a table to be modified according to a type of the table to be modified in the input parameter, finds out information of a field capable of being modified of the table to be modified, and updates a database table corresponding to the table to be modified according to an id list of table data to be modified, a field to be modified and a field value key value pair after modification in the input parameter. The above scheme can simultaneously modify field values of multiple fields of multiple data, has universality, and only needs to write a set of codes, so that the codes can be used for a list page of all table data functions needing batch modification in a system, and quick batch modification of a table is realized.
Need to check novelty before this filing date? Find Prior Art