Data-based low-code development method, system, equipment and medium

Abstract

The invention discloses a data-based low-code development method, system and device and a medium, belongs to the technical field of databases and low codes, and aims to solve the technical problem of how to enable a low-code construction application to be compatible with original system data, realize quick access to original information system data and improve the development efficiency. According to the technical scheme, the method comprises the steps of configuring to-be-reserved database data: configuring a database connection url, obtaining all tables corresponding to a database through the url, creating a new database configuration table, and storing a subsequent to-be-used table of a new system; a common page template is built in the low-code platform, the front-end page generated by the database table is selected, the front-end page has the functions of addition, deletion, modification and query, and meanwhile operation buttons and query conditions of the page are configured; configuring a front-end page style, and reassembling application menu information; configuring an application user center; generating a rear-end framework and a front-end compilable code; business codes are written in online, and dynamic verification is carried out.

Description

Technical Field

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

[0002] Low-code development platforms greatly reduce the complexity of application development by deploying advanced visual development tools, allowing users with weak technical backgrounds or no background to easily design and build applications. However, most companies currently have informatization capabilities and hope to retain the original data during the informatization upgrade process. Currently, many low-code platforms complete application construction based on new databases and are not compatible with the original data.

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

[0004] The technical task of the present invention is to provide a data-based low-code development method, system, equipment and medium to solve the problem of how to build low-code applications compatible with the original system data and achieve rapid access to the original information system data.

[0005] The technical task of the present invention is achieved in the following way: a data-based low-code development method, which is specifically as follows:

[0006] 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; the contents saved in the tables to be used include the database URL, table name, table structure, and data to be retained; the data to be retained is saved through SQL statements;

[0007] Generate front-end pages based on database tables and SQL: Common page templates are built into the low-code platform, and the front-end pages generated by database tables are selected. The front-end pages have the functions of adding, deleting, modifying and querying, and the operation buttons and query conditions of the pages are configured;

[0008] Configure the front-end page style and reassemble the application menu information: the application menu defaults to a single-layer menu, the menu order is the default order, and the initial sorting is in the order of processing by the low-code platform. Allow users to configure menu groups and configure menus to corresponding menu groups. Allow users to modify menu sorting numbers and adjust the order of menus.

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

[0010] Generate backend framework and frontend compilable code;

[0011] Write business code online and verify dynamically.

[0012] Preferably, when configuring the database data to be retained, multiple databases and corresponding data tables are configured;

[0013] If the original application is disabled, data can be extracted from multiple databases and placed in a new database for centralized processing.

[0014] As a preferred method, when the front-end page is generated based on the database table and SQL reverse, for the associated table, a main sub-page is generated, and 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 detail page, all data display of the sub-form is queried based on the form data ID and the associated sub-form table name;

[0015] On the corresponding editing page, add the corresponding add, delete, modify and query operations for the subtable, and display the subform;

[0016] For query pages, multiple tables are involved, and corresponding pages can be generated based on SQL; the field names in the SQL statement are used as the display content of the page, and the where conditions are used as the query conditions of the page.

[0017] Preferably, when configuring the front-end page style and reassembling the application menu information, the components configured according to the data type of the initially generated page are allowed to be redefined by the user, and the order is allowed to be freely adjusted.

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

[0019] According to the microservice framework and the monolithic framework, introduce the corresponding jar packages of springboot, spring cloud, mybatis-plus, redis and minio;

[0020] Create a new Maven project and introduce the corresponding dependencies of the jar package in the pom file;

[0021] Create directories corresponding to controller, service, mapper, entity, config, and util, introduce commonly used tool classes into the util directory, and create common configuration classes into the config directory to generate the backend framework.

[0022] Preferably, generating the front-end compilable code is specifically as follows: basic operations on the database are generated based on the mybatis-plus generator technology, and the front-end generates compilable code based on vue.

[0023] Better yet, write the business code online and perform dynamic verification as follows: pre-set the packages needed for the business logic based on the online IDE, write incremental business logic through the online IDE, and use the built-in compilation, packaging, and publishing functions to verify the business logic in real time.

[0024] A data-based low-code development system, which is used to implement the above-mentioned data-based low-code development method; the system includes:

[0025] The database data configuration module is used to configure the database connection URL, obtain all the 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 contents saved in the tables to be used include the database URL, table name, table structure and data to be retained; the data to be retained is saved through SQL statements;

[0026] The front-end page generation module is used to build common page templates into the low-code platform and select the front-end page generated by the database table. The front-end page has the functions of adding, deleting, modifying and querying, and configures the operation buttons and query conditions of the page;

[0027] The assembly module is used to configure the front-end page style and reassemble the application menu information. Specifically, the application menu defaults to a single-layer menu, the menu order is the default order, and the initial sorting is in the order of processing by the low-code platform. It allows users to configure menu groups and configure menus to corresponding menu groups. It allows users to modify the menu sorting number and adjust the order of the menus.

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

[0029] Generate module, used to generate backend framework and frontend compilable code

[0030] Writing and dynamic modules are used to write business codes online and conduct dynamic verification.

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

[0032] Wherein, the memory stores a computer program;

[0033] The at least one processor executes the computer program stored in the memory, so that the at least one processor performs the data-based low-code development method as described above.

[0034] A computer-readable storage medium having a computer program stored therein, wherein the computer program can be executed by a processor to implement the data-based low-code development method as described above.

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

[0036] (1) The present invention quickly accesses the original information system data, meets the requirements of low-code application construction and compatibility with the original system data, improves the compatibility of the low-code platform with the original information system, and also improves the competitiveness of the low-code platform products;

[0037] (ii) The new application constructed with low code of the present invention does not require all tables of the original system. According to user needs, necessary data is selected for saving. The corresponding tables refer to the tables still needed in the new application, and the table structures and table data corresponding to the required tables are saved. BRIEF DESCRIPTION OF THE DRAWINGS

[0038] The present invention is further described below in conjunction with the accompanying drawings.

[0039] Attached Figure 1 A flowchart for a data-based low-code development approach. DETAILED DESCRIPTION

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

[0041] Embodiment 1:

[0042] As attached Figure 1 As shown, this embodiment provides a data-based low-code development method, which is specifically 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; the contents of the table to be used include the database URL, table name, table structure and data to be retained; the data to be retained is saved through SQL statements;

[0044] S2. Generate the front-end page based on the database table and SQL reversely: In the low-code platform, common page templates are built in, and the front-end page generated by the database table is selected. The front-end page 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 defaults to a one-layer menu, the menu order is the default order, and the initial sorting is sorted according to the processing order of the low-code platform. Users are allowed to configure menu groups and configure menus to corresponding menu groups. Users are allowed to modify the menu sorting number and adjust the order of the menus.

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

[0047] S5, generate backend framework and frontend compilable code;

[0048] S6. Write business code online and verify 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 disabled, data can be extracted from multiple databases and placed in a new database for centralized processing.

[0051] When the front-end page is generated based on the database table and SQL in reverse in step S2 of this embodiment, for the associated table, a main sub-page is generated, and a CRUD page similar to a single form is generated according to the main form. The difference from the single form is that on the corresponding detail page, all data display of the sub-form is queried according to the form data ID and the associated sub-form table name;

[0052] On the corresponding editing page, add the corresponding add, delete, modify and query operations for the subtable, and display the subform;

[0053] For query pages, multiple tables are involved, and corresponding pages can be generated based on SQL; the field names in the SQL statement are used as the display content of the page, and the where conditions are used as the query conditions of the page.

[0054] In the configuration of the front-end page style in step S3 of this embodiment, when reassembling the application menu information, the components configured according to the data type of the initially generated page are allowed to be redefined by the user, and the order is allowed to be freely adjusted.

[0055] The generation of the backend framework in step S5 of this embodiment is specifically as follows:

[0056] S501. According to the microservice framework and the monolithic framework, introduce the corresponding jar packages of springboot, spring cloud, mybatis-plus, redis and minio;

[0057] S502. Create a new Maven project and introduce the corresponding dependencies of the jar package in the pom file;

[0058] S503. Create directories corresponding to controller, service, mapper, entity, config, and util, introduce commonly used tool classes into the util directory, and create common configuration classes into the config directory, thereby generating a backend framework.

[0059] The generation of the front-end compilable code in step S5 of this embodiment is specifically: basic operations on the database are generated based on the mybatis-plus generator technology, and the front-end generates compilable code based on vue.

[0060] The online writing of business code in step S6 of this embodiment is dynamically verified as follows: based on the online IDE, the packages required for the business logic are preset in advance, the incremental business logic is written through the online IDE, and the built-in compilation, packaging and publishing functions are used to verify the business logic in real time.

[0061] Embodiment 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 data configuration module is used to configure the database connection URL, obtain all the 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 contents saved in the tables to be used include the database URL, table name, table structure and data to be retained; the data to be retained is saved through SQL statements;

[0064] The front-end page generation module is used to build common page templates into the low-code platform and select the front-end page generated by the database table. The front-end page has the functions of adding, deleting, modifying and querying, and configures the operation buttons and query conditions of the page;

[0065] The assembly module is used to configure the front-end page style and reassemble the application menu information. Specifically, the application menu defaults to a single-layer menu, the menu order is the default order, and the initial sorting is in the order of processing by the low-code platform. It allows users to configure menu groups and configure menus to corresponding menu groups. It allows users to modify the menu sorting number and adjust the order of the menus.

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

[0067] Generate module, used to generate backend framework and frontend compilable code

[0068] Writing and dynamic modules are used to write business codes online and conduct dynamic verification.

[0069] Embodiment 3:

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

[0071] Wherein, the memory stores computer-executable instructions;

[0072] The processor executes the computer-executable instructions stored in the memory, so that the processor executes the data-based low-code development method in any embodiment of the present invention.

[0073] The processor may be a central processing unit (CPU), or other general-purpose processors, digital signal processors (DSP), application-specific integrated circuits (ASIC), field-programmable gate arrays (FPGA) or other programmable logic devices, discrete gate or transistor logic devices, discrete hardware components, etc. The processor may be a microprocessor or any conventional processor, etc.

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

[0075] Embodiment 4:

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

[0077] In this case, the program code itself read from the storage medium can realize the function of any one of the above-mentioned embodiments, and thus the program code and the storage medium storing the program code constitute a part of the present invention.

[0078] The storage medium embodiments for providing the program code include a floppy disk, a hard disk, a magneto-optical disk, an optical disk (such as CD-ROM, CD-R, CD-RW, DVD-ROM, DVD-RYM, DVD-RW, DVD+RW), a magnetic tape, a non-volatile memory card, and a ROM. Alternatively, the program code can be downloaded from a server computer via a communication network.

[0079] In addition, it should be clear that the functions of any of the above embodiments can be implemented not only by executing the program code read by the computer, but also by enabling an operating system operating on the computer to complete part or all of the actual operations based on instructions from the program code.

[0080] In addition, it can be understood that the program code read from the storage medium is written to a memory provided in an expansion board inserted into the computer or written to a memory provided in an expansion unit connected to the computer, and then based on the instructions of the program code, a CPU installed on the expansion board or the expansion unit is enabled to perform part or all of the actual operations, thereby realizing the functions of any of the above-mentioned embodiments.

[0081] Finally, it should be noted that the above embodiments are only used to illustrate the technical solutions of the present invention, rather than to limit it. Although the present invention has been described in detail with reference to the aforementioned embodiments, those skilled in the art should understand that they can still modify the technical solutions described in the aforementioned embodiments, or replace some or all of the technical features therein with equivalents. However, these modifications or replacements 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, 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; the contents saved in the tables to be used include the database URL, table name, table structure, and data to be retained; the data to be retained is saved through SQL statements; Generate front-end pages based on database tables and SQL: Common page templates are built into the low-code platform, and the front-end pages generated by database tables are selected. The front-end pages have the functions of adding, deleting, modifying and querying, and the operation buttons and query conditions of the pages are configured; Configure the front-end page style and reassemble the application menu information: the application menu defaults to a single-layer menu, the menu order is the default order, and the initial sorting is in the order of processing by the low-code platform. Allow users to configure menu groups and configure menus to corresponding menu groups. Allow users to modify menu sorting numbers and adjust the order of menus. Configure the application user center: configure roles and positions to control the menu permissions, operation permissions, and data permissions of users, and configure different roles and positions to access pages to perform data operations and view data; Generate backend framework and frontend compilable code; Write business code online and verify 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 corresponding data tables; If the original application is disabled, data can be extracted from multiple databases and placed in a new database for centralized processing.

3. The data-based low-code development method according to claim 1, characterized in that: When the front-end page is generated based on the database table and SQL, for the associated table, the main sub-page is generated, and the add, delete, modify and query page similar to the single form is generated according to the main form. On the corresponding detail page, all data display of the sub-form is queried according to the form data ID and the associated sub-form table name; On the corresponding editing page, add the corresponding add, delete, modify and query operations for the subtable, and display the subform; For query pages, multiple tables are involved, allowing corresponding pages to be generated based on SQL; The field name in the SQL statement is used as the display content of the page, and the where condition is used as the query condition of 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 components configured according to the data type on the initially generated page allow users to redefine them, and the order allows free adjustment.

5. The data-based low-code development method according to claim 1, characterized in that: Generate the backend framework as follows: According to the microservice framework and the monolithic framework, introduce the corresponding jar packages of springboot, spring cloud, mybatis-plus, redis and minio; Create a new Maven project and introduce the corresponding dependencies of the jar package in the pom file; Create directories corresponding to controller, service, mapper, entity, config, and util, introduce commonly used tool classes into the util directory, and create common configuration classes into the config directory to generate the backend framework.

6. The data-based low-code development method according to claim 1, characterized in that: Generate front-end compilable code specifically: Generate basic operations on the database based on mybatis-plus generator technology, and generate compilable code based on vue on the front end.

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

8. A data-based low-code development system, characterized in that: The system is used to implement the data-based low-code development method described in any one of claims 1 to 7; the system includes: The database data configuration module is used to configure the database connection URL, obtain all the 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 contents saved in the tables to be used include the database URL, table name, table structure and data to be retained; the data to be retained is saved through SQL statements; The front-end page generation module is used to build common page templates into the low-code platform and select the front-end page generated by the database table. The front-end page has the functions of adding, deleting, modifying and querying, and configures the operation buttons and query conditions of the page; The assembly module is used to configure the front-end page style and reassemble the application menu information. Specifically, the application menu defaults to a single-layer menu, the menu order is the default order, and the initial sorting is in the order of processing by the low-code platform. It allows users to configure menu groups and configure menus to corresponding menu groups. It allows users to modify the menu sorting number and adjust the order of the menus. The application user center configuration module is used to configure the menu permissions, operation permissions, and data permissions of the roles and positions to control user access, and configure different roles and positions to access pages to perform data operations and view data; Generate module, used to generate backend framework and frontend compilable code Writing and dynamic modules are used to write business codes online and conduct dynamic verification.

9. An electronic device, characterized in that: include: memory and at least one processor; Wherein, the memory stores a computer program; The at least one processor executes the computer program stored in the memory, so that the at least one processor executes 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, which 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