Application development system and method based on database and spreadsheet software

Abstract

The embodiment of the invention provides an application development system and method based on a database and spreadsheet software. The system comprises an application designer, a processor and a database; the application designer is used for constructing a logical relationship of data and obtaining a table file with the logical relationship; the processor is used for managing and executing logicof the form file; and the database is used for storing the operation parameters in the application designer and the processor and storing the user data. By installing the application designer, the processor and the database, the processor and the application designer are authenticated, logic design is carried out on the application designer according to user requirements to generate a form file, and the form file generation application is released to process data of the database to obtain a processing result. The interface and logic can be separated, software design is specialized, compatibility is good, and secondary development of the application is facilitated; and cross-server operation and distributed calculation can be realized, complex applications can be constructed, and differentuse requirements of users can be met.

Description

technical field [0001] The invention relates to the field of computer technology, in particular to an application development system and method based on database and electronic form software. Background technique [0002] At present, the Excel office software has been deeply rooted in the hearts of the people, and its rich automatic office functions have brought great convenience to users' daily office life. However, the Excel file is a static file and cannot be automatically associated with other Excel files to form a logical loop structure and branch structure. To achieve this function, repeated manual operations are required; calling data from other computers, It needs to be manually called and transmitted multiple times, and the transmitted data often needs to be manually statistically adjusted before filling in the report, which cannot avoid human errors and increases the workload. [0003] In addition, the big data processing capability of the Excel office software is...

AI Technical Summary

Problems solved by technology

However, the Excel file is a static file and cannot be automatically associated with other Excel files to form a logical loop structure and branch structure. To achieve this function, repeated manual operations are required; calling data from other computers, It needs to be called and transferred multiple times manually, and the transferred data often needs to be manually adjusted by statistics before filling in the report, which cannot avoid human errors and increases the workload

[0003] In addition, the big data processing capability of Excel office software is limited

However, database software such as SQL with large data storage and processing capabilities can be accessed remotely, but its data processing is not as convenient as Excel

[0004] Using existing programming methods to develop an application with automatic data processing function often requires a structured programming language, which requires relatively high levels of English and logic for developers; during the development process, many storage variables need to be edited, The memory requirements for developers are also very high, and the threshold for application development is high; in addition, the data automatic processing applications developed in the existing technology are relatively closed, and often require complex interface languages ​​to be called by other applications, which do not have good compatibility

[0005] At present, the information system of engineering projects is biased towards data collection, and the collected data needs to be manually transmitted and sorted out many times. The efficiency of data utilization is low, and errors are unavoidable.

The compatibility between various systems is poor, and they cannot be effectively interlinked. Data not only cannot form wealth but is a heavy burden

At the same time, the life cycle of engineering projects is short, and the management mode of each project is different. The existing technical means cannot build an information system that extends to all aspects of construction.

Images