Data-driven low-code development methods, systems, devices, and media

Abstract

This invention discloses a data-based low-code development method, system, device, and medium, belonging to the field of database and low-code technology. The technical problem this invention aims to solve is how to build applications in low-code that are compatible with existing system data and enable rapid access to existing information system data. The technical solution adopted is as follows: Configuring database data to be retained: configuring the database connection URL, obtaining all tables in the corresponding database through the URL, creating a new database configuration table, and saving tables to be used later in the new system; Generating front-end pages based on database tables and SQL: embedding commonly used page templates in the low-code platform, selecting the database table to generate the front-end page, which has CRUD (Create, Read, Update, Delete) functions, and configuring the page's operation buttons and query conditions; configuring the front-end page style and reassembling the application menu information; configuring the application user center; generating the back-end framework and compilable front-end code; writing business code online and dynamically verifying it.

Description

Technical Field

[0001] This invention relates to the field of database and low-code development technology, specifically to a data-based low-code development method, system, device, and medium. Background Technology

[0002] Low-code development platforms significantly reduce the complexity of application development by deploying advanced visual development tools, enabling users with limited or no technical background to easily design and build applications. However, most enterprises already possess IT capabilities and, during IT upgrades, desire to retain existing data. Currently, many low-code platforms build applications based on new databases, making them incompatible with existing data.

[0003] Therefore, how to build low-code applications that are compatible with existing system data and enable rapid access to existing information system data is a technical problem that urgently needs to be solved. Summary of the Invention

[0004] The technical objective of this invention is to provide a data-based low-code development method, system, device, and medium to solve the problem of how to build applications in low code that are compatible with existing system data and enable rapid access to existing information system data.

[0005] The technical objective of this invention is achieved as follows: a data-based low-code development method, the specific details of which are as follows:

[0006] Configure the database data to be retained: Configure the database connection URL, retrieve all tables of the corresponding database through the URL, create a new database configuration table, and save the tables to be used in the new system; the table to be used will store the database URL, table name, table structure, and data to be retained; the data to be retained is saved using SQL statements;

[0007] Front-end pages are generated by reverse engineering based on database tables and SQL: Commonly used page templates are built into the low-code platform. The front-end page generated by selecting the database table has the functions of adding, deleting, modifying and querying, and the operation buttons and query conditions of the page are configured.

[0008] Configure the front-end page style and reassemble the application menu information: The application menu is a single-level menu by default, and the menu order is the default order. The initial sorting is based on the low-code platform's processing order. Users can configure menu groups, assign menus to corresponding menu groups, and modify menu sort numbers to adjust the menu order.

[0009] Configure the application user center: Configure roles and positions to control users' access to menu permissions, operation permissions, and data permissions, and configure different roles and positions to access pages to perform data operations and view data;

[0010] Generate the backend framework and compilable frontend code;

[0011] Write business code online and verify it dynamically.

[0012] As a preferred option, when configuring the database data to be retained, multiple databases and corresponding data tables should be configured.

[0013] If the original application is discontinued, data is extracted from multiple databases and placed into a new database for centralized processing.

[0014] As a preferred method, when generating the front-end page based on the database table and SQL, for related tables, a main and sub-pages are generated. Based on the main form, a CRUD (Create, Read, Update, Delete) page similar to a single form is generated. The difference from a single form is that on the corresponding details page, all data of the sub-form is queried and displayed based on the form data ID and the name of the associated sub-form table.

[0015] On the corresponding editing page, add CRUD operations for the sub-table and display the sub-form;

[0016] For query pages involving multiple tables, corresponding pages can be generated based on the SQL statement; the field names in the SQL statement serve as the displayed content of the page, and the WHERE clause serves as the query conditions for the page.

[0017] As a preferred option, when configuring the front-end page style and reassembling the application menu information, the components of the initially generated page, configured according to the data type, can be redefined by the user, and their order can be freely adjusted.

[0018] As a preferred option, the generated backend framework is as follows:

[0019] According to the microservice framework and monolithic framework, import the corresponding JAR files for Spring Boot, Spring Cloud, MyBatis-Plus, Redis, and MinIO;

[0020] Create a new Maven project and include the corresponding dependencies for the JAR files in the pom file;

[0021] Create directories for controller, service, mapper, entity, config, and util. Import commonly used utility classes into the util directory and create a general configuration class into the config directory to generate the backend framework.

[0022] As a preferred method, generating compilable front-end code specifically involves: generating basic database operations based on MyBatis-Plus Generator technology, and generating compilable front-end code based on Vue.

[0023] Even better, writing business code online and dynamically verifying it is done by: using an online IDE, pre-setting the packages needed for business logic, writing incremental business logic through the online IDE, and having built-in compilation, packaging and publishing functions to verify the business logic in real time.

[0024] A data-based low-code development system for implementing the aforementioned data-based low-code development method; the system includes:

[0025] The database configuration module is used to configure the database connection URL, retrieve all tables in the corresponding database through the URL, create a new database configuration table, and save the tables to be used in the new system. The table to be used stores the database URL, table name, table structure, and data to be retained. The data to be retained is saved using SQL statements.

[0026] The front-end page generation module is used to embed commonly used page templates in low-code platforms. It generates front-end pages by selecting database tables. The front-end pages have CRUD (Create, Read, Update, Delete) functions and can also be configured with operation buttons and query conditions.

[0027] The assembly module is used to configure the front-end page style and reassemble the application menu information. Specifically, the application menu is a single-level menu by default, the menu order is the default order, the initial sorting is sorted according to the low-code platform processing order, users can configure menu groups, configure menus to corresponding menu groups, and users can modify the menu sort number and adjust the menu order.

[0028] The application user center configuration module is used to configure the menu permissions, operation permissions, and data permissions of the user for each role and position, and to configure the access pages for different roles and positions to perform data operations and view data.

[0029] The generation module is used to generate backend frameworks and compilable frontend code.

[0030] The write and dynamic module is used for writing business code online and performing dynamic verification.

[0031] An electronic device includes: a memory and at least one processor;

[0032] The memory contains computer programs;

[0033] The at least one processor executes the computer program stored in the memory, causing the at least one processor to perform the data-based low-code development method described above.

[0034] A computer-readable storage medium storing a computer program that can be executed by a processor to implement the data-based low-code development method described above.

[0035] The data-based low-code development method, system, device, and medium of the present invention have the following advantages:

[0036] (i) This invention enables rapid access to existing information system data, meets the requirement of low-code application building to be compatible with existing system data, improves the compatibility of the low-code platform with existing information systems, and also enhances the competitiveness of low-code platform products.

[0037] (ii) The new application built with low code in this invention does not require all the tables of the original system. According to the user's needs, the necessary data is selected and saved. The corresponding tables refer to the tables that are still needed in the new application. The table structure and table data corresponding to the required tables are saved. Attached Figure Description

[0038] The invention will be further described below with reference to the accompanying drawings.

[0039] Appendix Figure 1 A flowchart for a data-driven low-code development approach. Detailed Implementation

[0040] The data-based low-code development method, system, device, and medium of the present invention will be described in detail below with reference to the accompanying drawings and specific embodiments.

[0041] Example 1:

[0042] As attached Figure 1 As shown in the figure, this embodiment provides a data-based low-code development method, which is as follows:

[0043] S1. Configure the database data to be retained: Configure the database connection URL, obtain all tables of the corresponding database through the URL, create a new database configuration table, and save the tables to be used in the new system later; the table to be used saves the database URL, table name, table structure, and data to be retained; the data to be retained is saved through SQL statements;

[0044] S2. Reverse generation of front-end pages based on database tables and SQL: Commonly used page templates are built into the low-code platform. The front-end page generated by selecting the database table has the functions of adding, deleting, modifying and querying, and the operation buttons and query conditions of the page are configured.

[0045] S3. Configure the front-end page style and reassemble the application menu information: The application menu is a single-level menu by default, and the menu order is the default order. The initial sorting is based on the low-code platform processing order. Users can configure menu groups, assign menus to corresponding menu groups, and modify menu sorting numbers to adjust the menu order.

[0046] S4. Configure the application user center: Configure roles and positions to control users' access to menu permissions, operation permissions, and data permissions, and configure different roles and positions to access pages to perform data operations and view data;

[0047] S5 generates the backend framework and compilable frontend code;

[0048] S6. Write business code online and verify it dynamically.

[0049] In step S1 of this embodiment, when configuring the database data to be retained, multiple databases and corresponding data tables are configured.

[0050] If the original application is discontinued, data is extracted from multiple databases and placed into a new database for centralized processing.

[0051] In step S2 of this embodiment, when generating the front-end page based on the database table and SQL, for the related table, a main and sub-page are generated. Based on the main form, a CRUD page similar to a single form is generated. The difference from the single form is that on the corresponding details page, all data of the sub-form is queried and displayed based on the form data ID and the related sub-form table name.

[0052] On the corresponding editing page, add CRUD operations for the sub-table and display the sub-form;

[0053] For query pages involving multiple tables, corresponding pages can be generated based on the SQL statement; the field names in the SQL statement serve as the displayed content of the page, and the WHERE clause serves as the query conditions for the page.

[0054] In step S3 of this embodiment, when configuring the front-end page style and reassembling the application menu information, the initially generated page allows users to redefine the components configured according to the data type, and the order can be freely adjusted.

[0055] The specific steps for generating the backend framework in step S5 of this embodiment are as follows:

[0056] S501. According to the microservice framework and monolithic framework, import the corresponding JAR packages of Spring Boot, Spring Cloud, MyBatis-Plus, Redis and MinIO;

[0057] S502. Create a new Maven project and include the corresponding dependencies of the JAR files in the pom file;

[0058] S503. Create directories for controller, service, mapper, entity, config, and util. Import commonly used utility classes into the util directory and create a general configuration class into the config directory to generate the backend framework.

[0059] In this embodiment, step S5, generating compilable front-end code, specifically involves: generating basic database operations based on MyBatis-Plus Generator technology, and generating compilable front-end code based on Vue.

[0060] In step S6 of this embodiment, writing business code online and dynamically verifying it is done by: using an online IDE, pre-setting the packages needed for the business logic, writing incremental business logic through the online IDE, and having built-in compilation, packaging, and publishing functions to verify the business logic in real time.

[0061] Example 2:

[0062] This embodiment provides a data-based low-code development system, which is used to implement the data-based low-code development method in Embodiment 1; the system includes:

[0063] The database configuration module is used to configure the database connection URL, retrieve all tables in the corresponding database through the URL, create a new database configuration table, and save the tables to be used in the new system. The table to be used stores the database URL, table name, table structure, and data to be retained. The data to be retained is saved using SQL statements.

[0064] The front-end page generation module is used to embed commonly used page templates in low-code platforms. It generates front-end pages by selecting database tables. The front-end pages have CRUD (Create, Read, Update, Delete) functions and can also be configured with operation buttons and query conditions.

[0065] The assembly module is used to configure the front-end page style and reassemble the application menu information. Specifically, the application menu is a single-level menu by default, the menu order is the default order, the initial sorting is sorted according to the low-code platform processing order, users can configure menu groups, configure menus to corresponding menu groups, and users can modify the menu sort number and adjust the menu order.

[0066] The application user center configuration module is used to configure the menu permissions, operation permissions, and data permissions of the user for each role and position, and to configure the access pages for different roles and positions to perform data operations and view data.

[0067] The generation module is used to generate backend frameworks and compilable frontend code.

[0068] The write and dynamic module is used for writing business code online and performing dynamic verification.

[0069] Example 3:

[0070] This embodiment also provides an electronic device, including: a memory and a processor;

[0071] The memory stores the instructions executed by the computer.

[0072] The processor executes computer execution instructions stored in the memory, causing the processor to perform the data-based low-code development method in any embodiment of the present invention.

[0073] The processor can be a central processing unit (CPU), or other general-purpose processors, digital signal processors (DSPs), application-specific integrated circuits (ASICs), off-the-shelf programmable gate arrays (FPGAs), or other programmable logic devices, discrete gate or transistor logic devices, discrete hardware components, etc. The processor can be a microprocessor or any conventional processor.

[0074] Memory is used to store computer programs and / or modules. The processor implements various functions of the electronic device by running or executing the computer programs and / or modules stored in the memory, and by accessing data stored in the memory. Memory can mainly include a program storage area and a data storage area. The program storage area can store the operating system, at least one application program required for a function, etc.; the data storage area can store data created based on the use of the terminal, etc. In addition, memory can also include high-speed random access memory, and can also include non-volatile memory, such as hard disks, RAM, plug-in hard disks, smart memory cards (SMC), secure digital cards (SD cards), flash memory cards, at least one disk storage device, flash memory devices, or other volatile solid-state storage devices.

[0075] Example 4:

[0076] This embodiment also provides a computer-readable storage medium storing a plurality of instructions, which are loaded by a processor to cause the processor to execute the data-based low-code development method of any embodiment of the present invention. Specifically, a system or apparatus equipped with a storage medium may be provided, on which software program code implementing the functions of any of the above embodiments is stored, and the computer (or CPU or MPU) of the system or apparatus may read and execute the program code stored in the storage medium.

[0077] In this case, the program code read from the storage medium can itself implement the function of any of the above embodiments, and therefore the program code and the storage medium storing the program code constitute part of the present invention.

[0078] Storage media embodiments for providing program code include floppy disks, hard disks, magneto-optical disks, optical disks (such as CD-ROM, CD-R, CD-RW, DVD-ROM, DVD-RYM, DVD-RW, DVD+RW), magnetic tapes, non-volatile memory cards, and ROMs. Alternatively, program code can be downloaded from a server computer via a communication network.

[0079] Furthermore, it should be clear that not only can the program code read by the computer be executed, but also the operating system or other components operating on the computer can be instructed based on the program code to perform some or all of the actual operations, thereby realizing the function of any of the embodiments described above.

[0080] Furthermore, it is understood that the program code read from the storage medium is written to the memory set in the expansion board inserted into the computer or to the memory set in the expansion unit connected to the computer. Then, based on the instructions of the program code, the CPU or other components installed on the expansion board or expansion unit execute some and all of the actual operations, thereby realizing the function of any of the embodiments described above.

[0081] Finally, it should be noted that the above embodiments are only used to illustrate the technical solutions of the present invention, and not to limit them; although the present invention has been described in detail with reference to the foregoing embodiments, those skilled in the art should understand that modifications can still be made to the technical solutions described in the foregoing embodiments, or equivalent substitutions can be made to some or all of the technical features; and these modifications or substitutions do not cause the essence of the corresponding technical solutions to deviate from the scope of the technical solutions of the embodiments of the present invention.

Claims

1. A data-based low-code development method, characterized in that, The method is as follows: Configure the database data to be retained: Configure the database connection URL, retrieve all tables of the corresponding database through the URL, create a new database configuration table, and save the tables to be used in the new system; the table to be used will store the database URL, table name, table structure, and data to be retained; the data to be retained is saved using SQL statements; Front-end pages are generated by reverse engineering based on database tables and SQL: Commonly used page templates are built into the low-code platform. The front-end page generated by selecting the database table has the functions of adding, deleting, modifying and querying, and the operation buttons and query conditions of the page are configured. Configure the front-end page style and reassemble the application menu information: The application menu is a single-level menu by default, and the menu order is the default order. The initial sorting is based on the low-code platform's processing order. Users can configure menu groups, assign menus to corresponding menu groups, and modify menu sort numbers to adjust the menu order. Configure the application user center: Configure roles and positions to control users' access to menu permissions, operation permissions, and data permissions, and configure different roles and positions to access pages to perform data operations and view data; Generate the backend framework and compilable frontend code; Write business code online and verify it dynamically.

2. The data-based low-code development method according to claim 1, characterized in that, When configuring the database data to be retained, configure multiple databases and their corresponding data tables; If the original application is discontinued, data is extracted from multiple databases and placed into a new database for centralized processing.

3. The data-based low-code development method according to claim 1, characterized in that, When generating front-end pages based on database tables and SQL, for related tables, main and sub-pages are generated. Based on the main form, CRUD pages similar to those of a single form are generated. On the corresponding details page, all data of the sub-form is displayed by querying based on the form data ID and the name of the related sub-form table. On the corresponding editing page, add CRUD operations for the sub-table and display the sub-form; For query pages involving multiple tables, it is permissible to generate corresponding pages based on the SQL query. The field names in the SQL statement are used as the content displayed on the page, and the WHERE clause is used as the query conditions for the page.

4. The data-based low-code development method according to claim 1, characterized in that, When configuring the front-end page style and reassembling the application menu information, the initially generated page allows users to redefine the components configured according to the data type, and the order can be freely adjusted.

5. The data-based low-code development method according to claim 1, characterized in that, The backend framework is generated as follows: According to the microservice framework and monolithic framework, import the corresponding JAR files for Spring Boot, Spring Cloud, MyBatis-Plus, Redis, and MinIO; Create a new Maven project and include the corresponding dependencies for the JAR files in the pom file; Create directories for controller, service, mapper, entity, config, and util. Import commonly used utility classes into the util directory and create a general configuration class into the config directory to generate the backend framework.

6. The data-based low-code development method according to claim 1, characterized in that, The process of generating compilable front-end code involves: generating basic database operations based on MyBatis-Plus Generator technology, and generating compilable front-end code based on Vue.

7. The data-based low-code development method according to any one of claims 1-6, characterized in that, Write business code online and verify it dynamically: Based on an online IDE, pre-configure the packages needed for business logic, write incremental business logic through the online IDE, and use built-in compilation, packaging and deployment functions to verify the business logic in real time.

8. A data-based low-code development system, characterized in that, This system is used to implement the data-based low-code development method according to any one of claims 1-7; the system comprises: The database configuration module is used to configure the database connection URL, retrieve all tables in the corresponding database through the URL, create a new database configuration table, and save the tables to be used in the new system. The table to be used stores the database URL, table name, table structure, and data to be retained. The data to be retained is saved using SQL statements. The front-end page generation module is used to embed commonly used page templates in low-code platforms. It generates front-end pages by selecting database tables. The front-end pages have CRUD (Create, Read, Update, Delete) functions and can also be configured with operation buttons and query conditions. The assembly module is used to configure the front-end page style and reassemble the application menu information. Specifically, the application menu is a single-level menu by default, the menu order is the default order, the initial sorting is sorted according to the low-code platform processing order, users can configure menu groups, configure menus to corresponding menu groups, and users can modify the menu sort number and adjust the menu order. The application user center configuration module is used to configure the menu permissions, operation permissions, and data permissions of the user for each role and position, and to configure the access pages for different roles and positions to perform data operations and view data. The generation module is used to generate backend frameworks and compilable frontend code. The write and dynamic module is used for writing business code online and performing dynamic verification.

9. An electronic device, characterized in that, include: Memory and at least one processor; The memory contains computer programs; The at least one processor executes the computer program stored in the memory, causing the at least one processor to perform the data-based low-code development method as described in any one of claims 1 to 7.

10. A computer-readable storage medium, characterized in that, The computer-readable storage medium stores a computer program that can be executed by a processor to implement the data-based low-code development method as described in any one of claims 1 to 7.

Images