General data entry method and device based on data model, equipment and medium

Abstract

The invention provides a general data entry method, device and equipment based on a data model and a medium. The method comprises a configuration process, a data import process and a visual addition, deletion, modification and check process. In the configuration process, a series of configuration interfaces are provided for a user to specify a data source and a general input object table, confirm table information and configure table fields; in the data importing process, a configured general entry object table is selected, the data importing process mainly comprises the steps of uploading a file to be imported, analyzing an Excel file input by a user through an API provided by the Apache POI by a program, and converting the Excel file into Listt; mapgt, Mapgt; and storing. Performing data legality verification and primary key verification; and inserting into a database in batches. By using the method and the system, after a user completes configuration, addition, deletion, modification and check and Execl import data uploading can be easily completed on one page, for developers, the business table uses a general input function, a corresponding three-layer architecture code does not need to be generated for each data table to realize operation on a database, extra codes are not generated, and the development efficiency is greatly improved. And the work of developers is greatly reduced.

Description

technical field [0001] The present invention relates to the field of computer technology, in particular to a general data method, device, device and medium based on a data model. Background technique [0002] In the development of computer programs, large or small systems are inseparable from data models (that is, data tables). Maintaining and managing data models is very important for a system. So where does the data of a system come from? In addition to some data created by itself during system development, it is often necessary to import data from outside the system based on business needs. [0003] When importing data from outside the system, Excel is usually provided externally for large batches of data, and a single operation for small batches is directly completed on the corresponding operation page. However, the current import of external large batches of Excel data has the following shortcomings: [0004] (1) In terms of code implementation, it is necessary to gen...

AI Technical Summary

Problems solved by technology

[0004] (1) In terms of code implementation, it is necessary to generate corresponding three-tier architecture code for each data table to realize the operation of the database. Therefore, a large number of code rewriting tasks lead to heavy tasks for developers, poor independence of input modules, and inability to adapt to various project system;

[0005] (2) Data management operations, such as adding business tables that need to be maintained, can only be implemented by developers, and users cannot be involved, resulting in a significant increase in the workload of developers;

[0006] (3) The user's operation on the data is not a real-time visual operation, and it is impossible to obtain intuitive feedback in real time

Images