Table data batch modification method and system

The invention provides a table data batch modification method and system, and the method comprises the steps: building a mapping table and a field information table, searching a place needing batch modification in a table through an incoming parameter, searching the field information table according...

Full description

Saved in:
Bibliographic Details
Main Authors HAO CHANGZHENG, LI CAIXIA, TIAN JIAFENG
Format Patent
LanguageChinese
English
Published 12.04.2024
Subjects
CALCULATING
COMPUTING
COUNTING
ELECTRIC DIGITAL DATA PROCESSING
PHYSICS
Online AccessGet full text

Cover

More Information
Summary:The invention provides a table data batch modification method and system, and the method comprises the steps: building a mapping table and a field information table, searching a place needing batch modification in a table through an incoming parameter, searching the field information table according to the type of a to-be-modified table in the incoming parameter, searching the information of a field which can be modified in the to-be-modified table, and carrying out the batch modification of the table data. And updating a database table corresponding to the to-be-modified table according to the i d list of the to-be-modified table data in the incoming parameter, the to-be-modified field and the modified field value key-value pair. According to the scheme, the field values of the multiple fields of the multiple pieces of data are modified at the same time, universality is achieved, only one set of codes needs to be written, the method can be used for all the list pages needing the table data batch modification
Bibliography:Application Number: CN202311753043