Design And Implementation Of General Data Maintenance System

With the common use of data maintenance systems,more and more data maintenance system development works are needed.Traditional data maintenance system is not flexible and development efficiency is low.How to reduce the development workload becomes an important problem.We design and implement a general data maintenance system which is based on general template technology.The operation mode is template definition-system generation-data operation,which can customize the data maintenance system parameters,generate specific data maintenance system by loading and parsing parameters,and then complete the corresponding database operation.The system includes the template definition module,the system generation module,and the data operation module.The template definition module can set parameters of database,login authentication,user management,and data maintenance.The module also save the defined parameters to the configuration file.The generation module is responsible for loading and analyzing the system parameters.Further,the generation module generates interfaces of the user management,the data addition and the data maintenance,and associate the system with the implementation function.For the data operation module,the foreground interface submits the operation data to the background,and then the backend returns results of the operation to the front desk.The system adopts B/S architecture.Users only need to visit the web site in the browser.The development language uses Java,JavaScript and HTML.The user has the freedom to fill in the label name.And select the corresponding table and column.The system generates a specific operation interface by reading tag names and generates SQL statements to operate the database automatically.The test results show that the general data maintenance system can generate the corresponding data maintenance system effectively and complete data maintenance work according to the user-defined parameters.There is no need to generate the special system according to the specific database.When the database structure is changed,the system only need to adjust the corresponding configuration parameters rather than develop a new system.