Table-based website page development method, device and equipment and storage medium

Abstract

The application is suitable for the technical field of page development, and provides a website page development method, device and equipment based on a table and a storage medium. The method obtains a table file input by a user, records components required for website page development in the table file, and pre-configures corresponding operation logic and logic analysis rules in a filling area for recording the components in the table file. The method performs logic analysis processing on the components recorded in the table file according to the logic analysis rules, obtains component operation logic corresponding to the components in the table file, and converts the component operation logic corresponding to each component in the table file into a structured query statement to generate a computer running logic file for developing a generated website page. The method triggers the system to run the computer running logic file to generate a website page corresponding to the computer running logic file. The method is simple to operate, can avoid field omission and code adjustment difficulty, is efficient, and is more suitable for the needs of agile development.

Description

TECHNICAL FIELD

[0001] The present application relates to the technical field of page development, and particularly relates to a website page development method and device based on a table, equipment and a storage medium. BACKGROUND

[0002] In website development, a website page is generally developed by using a SpringCloud combined with a mybatis technical framework in java (an object-oriented programming language). However, in the development process, the CRUD (add, read query, update, and delete) operation based on the website page basically accounts for most of the entire development activity, and the definition of a table field and the processing of the CRUD logic have gradually been converted into repetitive work of website page development. For the development of an urgent demand, in the process of generating a website page, the field omission and code adjustment difficulty are prone to occur, especially when the developer changes in the development process, the personnel who take over need to check and modify all the codes, which is time-consuming and laborious and low in efficiency. Some existing methods need to make a webpage template in advance, and then import the configuration data into the webpage template to generate a corresponding website page. For agile development, webpage modification or adjustment needs to be made every time, which is large in workload and low in efficiency. SUMMARY

[0003] Therefore, the embodiments of the present application provide a website page development method and device based on a table, equipment and a storage medium, which can quickly generate a website page based on a table, is simple to operate, and can avoid the field omission and code adjustment difficulty in website page development.

[0004] The first aspect of the embodiments of the present application provides a website page development method based on a table, comprising:

[0005] obtaining a table file input by a user, wherein the table file records components required for website page development, and a filling area for recording the components in the table file is pre-configured with corresponding operation logic and logic analysis rules;

[0006] performing logic analysis processing on the components recorded in the table file according to the logic analysis rules pre-configured in the filling area of the table file, obtaining component operation logic of the components in the table file, and converting the component operation logic of each component in the table file into a structured query statement to generate a computer running logic file for developing a website page;

[0007] triggering the system to run the computer running logic file to generate a website page corresponding to the computer running logic file.

[0008] In a first possible implementation manner of the first aspect, the table file is pre-configured with corresponding operation formats and format analysis rules for the filling area, the components recorded in the table file are logically analyzed according to the logical analysis rules pre-configured in the filling area of the table file, the component operation logic corresponding to the components in the table file is obtained, and before the step of converting the component operation logic corresponding to each component in the table file into a structured query language statement to generate a computer running logic file for developing a website page, the step of generating a running configuration file for running in cooperation with the computer running logic file is included.

[0009] The components recorded in the table file are format-analyzed according to the operation formats pre-configured in the filling area of the table file to generate a running configuration file for running in cooperation with the computer running logic file, the running configuration file including a static page file, a database script file and a data layer control file; wherein:

[0010] The static page file is used to generate a display interface of a website page.

[0011] The database script file is used to configure corresponding data sources for components required by a website page.

[0012] The data layer control file is used to configure corresponding data operation statements for components required by website page development.

[0013] In a second possible implementation manner of the first aspect, the step of generating a running configuration file for running in cooperation with the computer running logic file according to the operation formats pre-configured in the filling area of the table file includes:

[0014] Reading field information of the components recorded in the table file and object information corresponding to the field information;

[0015] Identifying data operation rules corresponding to the field information from the table file according to the object information, and generating data operation statements corresponding to the field information according to the data operation rules, wherein the data operation rules are built-in data operation rules of the table file.

[0016] Associating the data operation statements with the field information to generate corresponding data layer control files, the data layer control files being represented as extensible markup language files.

[0017] In a third possible implementation manner of the first aspect, in the step of performing logical analysis on the components recorded in the table file according to the logical analysis rule pre-configured according to the filling area in the table file to obtain the component operation logic of the components in the table file, and generating the computer running logic file for developing the website page by converting the component operation logic of each component in the table file into a structured query language statement, the step includes:

[0018] obtaining field information of the components recorded in the table file and object information corresponding to the field information;

[0019] creating an instance object for each component in the table file according to the field information and the object information corresponding to the field information;

[0020] generating a structured query language statement corresponding to the instance object according to the component operation logic of the components in the table file in combination with the database script file and the data layer control file;

[0021] integrating the structured query language statements corresponding to the instance objects in the table file to generate the computer running logic file for developing the website page.

[0022] In a fourth possible implementation manner of the first aspect, in the step of triggering the system to run the computer running logic file to generate the website page corresponding to the computer running logic file, the step includes:

[0023] monitoring a system preset folder to check whether the system preset folder has a new version of the computer running logic file;

[0024] if it is monitored that the system preset folder has the new version of the computer running logic file, loading the new version of the computer running logic file from the system preset folder and calling a running configuration file matched with the computer running logic file to perform running processing to generate the corresponding website page.

[0025] In a fifth possible implementation manner of the first aspect, before the step of obtaining the table file input by the user, the step includes:

[0026] constructing a table template library, and the table file input by the user is generated by selecting a table template from the table template library and filling component information in the table template, wherein the table template library includes one or more of an object category type template, a database connection configuration information type template, and an execution state log type template.

[0027] The second aspect of the embodiment of the present application provides a table-based website page development device, which comprises:

[0028] An acquisition module is configured to acquire a table file input by a user, wherein the table file records components required for website page development, and a filling area for recording the components in the table file is pre-configured with corresponding operation logic and logic analysis rules;

[0029] An analysis module is configured to perform logic analysis processing on the components recorded in the table file according to the logic analysis rules pre-configured in the filling area of the table file, to acquire component operation logic corresponding to the components in the table file, and to generate a computer running logic file for developing a generated website page by converting the component operation logic corresponding to each component in the table file into a structured query statement;

[0030] A running module is configured to trigger the system to run the computer running logic file, to generate a website page corresponding to the computer running logic file.

[0031] In combination with the second aspect, in a possible implementation manner of the second aspect, the table-based website page development device further comprises:

[0032] A generation sub-module is configured to perform format analysis processing on the components recorded in the table file based on an operation format pre-set in the filling area of the table file, to generate a running configuration file for running in cooperation with the computer running logic file, wherein the running configuration file comprises a static page file, a database script file and a data layer control file; and wherein:

[0033] The static page file is configured to generate a display interface of a website page;

[0034] The database script file is configured to configure corresponding data sources for the components required for the website page;

[0035] The data layer control file is configured to configure corresponding data operation statements for the components required for the website page development.

[0036] The third aspect of the embodiment of the present application provides a computer device, which comprises a memory, a processor and a computer program stored in the memory and executable on the computer device, wherein the processor implements each step of the table-based website page development method provided in the first aspect when executing the computer program.

[0037] The fourth aspect of the embodiment of the present application provides a computer readable storage medium, which stores a computer program, wherein the computer program is executable by a processor to implement each step of the table-based website page development method provided in the first aspect.

[0038] The table-based website page development method, apparatus, device, and storage medium provided in this application have the following beneficial effects:

[0039] This application obtains a user-input form file containing the components required for website page development. The input fields for each component in the form file are pre-configured with corresponding operation logic and parsing rules. The system then parses the components in the form file according to these pre-configured rules to obtain their corresponding operation logic. This logic is then transformed into structured query statements to generate a computer runtime logic file for website page development. Finally, the system runs this file, generating the corresponding website page. For urgent development needs, users only need to fill in and input a form file in a specific format. The tool directly parses the form to obtain the website page's runtime configuration file, quickly generating the website page. This avoids issues such as missing fields and difficult code adjustments. Even those without a development background can easily generate the website page. Furthermore, the website page is automatically generated based on the computer runtime logic file, eliminating the need for pre-made page templates. This reduces the workload for developers, increases efficiency, and better meets the needs of agile development. Attached Figure Description

[0040] To more clearly illustrate the technical solutions in the embodiments of this application, the drawings used in the description of the embodiments or the prior art will be briefly introduced below. Obviously, the drawings described below are only some embodiments of this application. For those skilled in the art, other drawings can be obtained based on these drawings without creative effort.

[0041] Figure 1 A flowchart illustrating the implementation of a table-based website page development method provided in the first embodiment of this application;

[0042] Figure 2 A flowchart illustrating the implementation of a table-based website page development method provided in the second embodiment of this application;

[0043] Figure 3 A flowchart illustrating the implementation of a table-based website page development method provided in the third embodiment of this application;

[0044] Figure 4 A flowchart illustrating the implementation of a table-based website page development method provided in the fourth embodiment of this application;

[0045] Figure 5A system flow chart of a website page development process of a table-based website page development method provided by the fifth embodiment of the present application;

[0046] Figure 6 A structure schematic diagram of an object class type template provided by the sixth embodiment of the present application;

[0047] Figure 7 A structure schematic diagram of a database connection configuration information type template provided by the sixth embodiment of the present application;

[0048] Figure 8 A structure block diagram of a table-based website page development device provided by the seventh embodiment of the present application;

[0049] Figure 9 A system flow chart of a table-based website page development device provided by the seventh embodiment of the present application applied to a system to execute a website page development process;

[0050] Figure 10 A structure block diagram of a computer device provided by the eighth embodiment of the present application. DETAILED DESCRIPTION

[0051] In order to make the purpose, technical solutions and advantages of the present application clearer, the present application is further described in detail below in combination with the drawings and embodiments. It should be understood that the specific embodiments described herein are only used to explain the present application, and are not used to limit the present application.

[0052] Please refer to Figure 1 , Figure 1 An implementation flow chart of a table-based website page development method provided by the first embodiment of the present application. The details are as follows:

[0053] Step S11: obtaining a table file input by a user, wherein the table file records components required by website page development, and wherein a filling area in the table file for recording the components is pre-configured with corresponding operation logic and logic analysis rules.

[0054] In this embodiment, a tool for quickly developing website pages by using the functions of adding, deleting, modifying and inquiring of Excel table is constructed in advance in the backend system. A user can create an Excel table file filled with component information based on the development requirements of website pages and input the Excel table file into the tool. The component information filled in the Excel table file is the information of components required for the website page development at this time, and the filling area for recording components in the Excel table file is pre-configured with corresponding operation logic and logic analysis rules, that is, based on the field information of components and the filling position of the field information in the Excel table file, the operation logic corresponding to each component in the website page can be determined. Thus, the tool for quickly developing website pages can directly develop and generate corresponding website pages according to the Excel table file.

[0055] Step S12: performing logic analysis processing on the components recorded in the table file according to the logic analysis rules pre-configured in the filling area of the table file, obtaining the component operation logic corresponding to the components in the table file, and generating a computer running logic file for developing and generating website pages by converting the component operation logic corresponding to each component in the table file into a structured query statement.

[0056] In this embodiment, after obtaining the Excel table file filled by the user according to his requirements by using the tool for quickly developing website pages, the logic analysis processing is performed on the components recorded in the table file according to the logic analysis rules pre-configured in the filling area of the table file, the component operation logic corresponding to the components in the table file is obtained, and then the component operation logic corresponding to each component in the table file is converted into a structured query statement. The structured query statement is a statement generated based on a structured query language (SQL) of a relational database, which includes data definition, data query, data operation, data control and other functions, and is embodied as source code. After performing logic analysis processing on all the components recorded in the table file, the structured query statements corresponding to each component in the table file can be obtained, and then the computer running logic file for developing and generating website pages can be generated by integrating the structured query statements corresponding to these components. In this embodiment, the computer running logic file is represented as a source code control file.

[0057] Step S13: triggering the system to run the computer running logic file to generate a website page corresponding to the computer running logic file.

[0058] In this embodiment, when the tool for quickly developing a website page parses a computer running logic file for developing a generated website page, the system can be triggered to run the parsed computer running logic file by a website page generation instruction, so as to develop and generate a corresponding website page in the system. The website page is a website page developed and generated according to an Excel table file created by a user and meeting the development needs of the user. In this embodiment, the website page generation instruction can be generated by a start operation of the system, or the system can monitor the tool for quickly developing a website page to monitor whether a new version of the computer running logic file for developing a generated website page is generated by the tool, and generate the website page generation instruction if the new version is generated. When the system generates the website page generation instruction, the tool for quickly developing a website page responds to the website page generation instruction generated by the system, triggers the system to load and run the parsed computer running logic file, so that the system generates a corresponding website page based on the computer running logic file.

[0059] As can be seen from the above, the table-based website page development method provided in this embodiment obtains a table file input by a user, the table file records components required for website page development, and a filling area in the table file for recording the components is preconfigured with corresponding operation logic and logic analysis rules; the components recorded in the table file are subjected to logic analysis processing according to the logic analysis rules preconfigured in the filling area in the table file, the component operation logic corresponding to the components in the table file is obtained, and the component operation logic corresponding to each component in the table file is converted into a structured query statement to generate a computer running logic file for developing a generated website page; and the system is triggered to run the computer running logic file to generate a website page corresponding to the computer running logic file. For urgent development needs, a user only needs to fill in and input a table file in a specific format, and a tool directly parses a running configuration file of a website page to quickly generate a website page, which can avoid situations such as field omission and code adjustment difficulty, and a non-development background personnel can also perform related operations to generate a corresponding website page, and the operation is simple. Moreover, the website page is automatically generated based on a computer running logic file, and a page template does not need to be pre-prepared, which can reduce the development workload of a developer, is efficient, and is more in line with the needs of agile development.

[0060] In some embodiments of the present application, the user input table file has a corresponding operation format and format analysis rule preset for the filling area. In this embodiment, the components recorded in the table file can be format analyzed based on the operation format preset for the filling area of the table file to generate a running configuration file for running the computer running logic file. The running configuration file includes a static page file, a database script file and a data layer control file. The static page file represents a website page presentation layer file (html file), based on which a website page display interface can be generated to realize the functions of website page display, request receiving and request distribution. In this embodiment, when the static page file is obtained, the information of the components recorded in the Excel table file can be recognized to extract the name information of each component to establish a module label, and then the page layout is performed according to a certain arrangement mode to generate the static page file. The database script file and the data layer control file are both background logic files, which are used to realize a series of operations such as data extraction, data processing and processing result output according to the request received by the website page. The database script file is used to configure a corresponding data source for the components required by the website page; and the data layer control file is used to configure a corresponding data operation statement for the components required by the website page development. The structured query statement in the computer running logic file is generated based on the data source provided by the database script file and the data operation statement provided by the data layer control file.

[0061] For the database script file, please refer to Figure 2 , Figure 2 An implementation flowchart of a table-based website page development method provided by the second embodiment of the present application is provided. The table-based website page development method provided by this embodiment includes steps S21-S23 before step S12. Details are as follows:

[0062] S21: reading the field information of the components recorded in the table file;

[0063] S22: obtaining a data source matching the field information from a preset database;

[0064] S23: mapping and associating the field information and the data source information through a script to generate a corresponding database script file, wherein the database script file represents a field-data source correspondence table.

[0065] In this embodiment, the database script file is a field-data source correspondence table created by a script. In this embodiment, when the database script file is obtained by performing format analysis processing on the components filled in by the user in the Excel table file based on the Excel table file input by the user, the field information of the components filled in by the user in the format and position corresponding to the position of the components in the Excel table file can be read, and then a data source matching the field information is obtained from a preset database. In the Excel table file, each specified position in the fill-in area is pre-configured with a related data source from the preset database, so that the specified position has a specific format. Thus, based on the Excel table file, the data source corresponding to the field can be obtained according to the position of the field filled in by the user in the Excel table file. When each field filled in by the user corresponds to a data source, the field-data source correspondence table is created by mapping each field filled in by the user in the Excel table file to the data source corresponding to the field based on the script.

[0066] For the data layer control file, refer to Figure 3 , Figure 3 An implementation flowchart of a table-based website page development method provided by the third embodiment of the present application is provided. The table-based website page development method provided by the present embodiment includes steps S31-S33 before step S12. Details are as follows.

[0067] S31: reading field information of components recorded in the table file and object information corresponding to the field information;

[0068] S32: identifying a data operation rule corresponding to the field information from the table file according to the object information, and generating a data operation statement corresponding to the field information according to the data operation rule, wherein the data operation rule is a data operation rule built in the table file;

[0069] S33: associating the data operation statement with the field information to generate a corresponding data layer control file, and the data layer control file is represented as an extensible markup language file.

[0070] In the embodiment, when developing a website page, the data layer control file is a file for marking data and defining data, and is characterized as an extensible markup language file (xml file). In the embodiment, the corresponding operation format is preset for the fill-in area based on the table file, and the data operation rule for marking and defining is configured for each specified position in the fill-in area of the Excel table file. For example, a column is configured as an operation information column in the Excel table file, and four data operation rules of addition, deletion, modification, and query are configured in the operation information column. After obtaining the Excel table file, all field information filled in by the user in the table file and object information corresponding to the field information are read out, and each field information has object information corresponding thereto. Then, based on the row position of the object information in the Excel table file, it is confirmed that the data operation rule corresponding to the row position in the operation information column is which rule, and based on the corresponding relationship between the field information and the object information in the Excel table file, the data operation rule corresponding to each field information in the Excel table file is obtained, and a data operation statement, that is, a DML statement, corresponding to the field information is generated according to the data operation rule. For each field information filled in by the user in the Excel file table, a corresponding data operation statement is generated according to the data operation rule corresponding to the position of the field information, and the data operation statement is associated with the field information, so as to determine the object to which each data operation statement is directed. All data operation statements are written in an xml file, so as to generate a data layer control file. In the embodiment, the generation of the data operation statement is based on the data operation rule configured in the Excel file table, so that each data operation statement in the xml file is uniform in style, and is convenient to maintain.

[0071] For the control code file, refer to Figure 4 , Figure 4 An implementation flowchart of a table-based website page development method provided in the fourth embodiment of the application is provided. The table-based website page development method provided in the embodiment includes steps S41-S44 in step S12. Details are as follows.

[0072] S41: Obtain field information of a component recorded in the table file and object information corresponding to the field information;

[0073] S42: Create an instance object for each component in the table file according to the field information and the object information corresponding to the field information;

[0074] S43: Generate a structured query statement corresponding to the instance object based on the component operation logic of the component corresponding to the table file, in combination with a database script file and a data layer control file;

[0075] S44: integrating the structured query statements corresponding to the instance objects in the table file to generate a computer running logic file for developing the website page.

[0076] In the embodiment, the computer running logic file is used to run the operations of the components in the website page during the development of the website page. In the embodiment, the field information of the components recorded in the Excel table file forms a mapping relationship with the object names of the components. When the computer running logic file is obtained by analyzing the Excel table file input by the user, the mapping relationship between the field information and the object information corresponding to the field information is used to create the instance objects corresponding to each component recorded in the Excel table file. In the embodiment, one instance object represents the mapping relationship between one field in the Excel table file and the object name corresponding to the field. By creating an instance object corresponding to each field in the Excel table file, the structured query statements corresponding to the instance objects are generated for each component recorded in the Excel table file according to the component operation logic of the component in the table file, in combination with the database script file and the data layer control file. Further, the computer running logic file for developing the website page can be obtained by integrating the structured query statements.

[0077] In some embodiments of the present application, refer to Figure 5 , Figure 5 A system flowchart of the website page development process in the table-based website page development method provided by the fifth embodiment of the present application. The table-based website page development method provided by the embodiment includes steps S51-S52 in step S13. Details are as follows:

[0078] S51: monitoring a system preset folder to check whether the system preset folder has a new version of the computer running logic file;

[0079] S52: if the system preset folder is found to have the new version of the computer running logic file, loading the new version of the computer running logic file from the system preset folder and calling the running configuration file matched with the computer running logic file to perform running processing to generate the corresponding website page.

[0080] In the embodiment, the computer running logic file obtained after the analysis process can be stored in a preset folder designated by the system for execution. The computer running logic file is a control source code file (Java file). In the embodiment, the system preset folder is monitored to determine whether the system preset folder has a new version of the computer running logic file. If the system preset folder is found to have a new version of the computer running logic file, the new version of the computer running logic file can be loaded from the system preset folder by restarting the website service page and the like, and a running configuration file matched with the computer running logic file is called to perform running processing to generate a corresponding website page.

[0081] In some specific implementations, the computer running logic file is a control source code file (Java file) of a website page, such as UserController.java, UserService.java, UserServiceMapper.java, and the like. The Java file is written according to certain programming language specifications and is a human-readable text file. Further, after obtaining the Java file, the Java file needs to be subjected to binary compilation processing to be converted into a computer-readable and executable binary code file (class file). After the computer running logic file (Java file) is compiled to be displayed in the form of a class file, the computer running logic file is run by calling a running configuration file matched with the computer running logic file, and the system can generate a corresponding website page. In the embodiment, the computer running logic in the class file is generated by using operation numbers on an Excel table, mainly including service layer logic and controller layer logic of CRUD (Create, Retrieve, Update, and Delete). The Service layer is mainly responsible for the logical application design of a business module. Similarly, an interface is designed first, and then a class for implementing the interface is designed. The Controller layer is responsible for the control of a specific business module process, and the interface of the Service layer is called in the layer to control the business process. The configuration of the control is performed in a Spring configuration file, and different controllers are used for different business processes. In the embodiment, when a website page needs to be repeatedly developed, a user only needs to perform operations such as adding, deleting, modifying, and inquiring on the field contents filled in the originally created Excel table file, and the system can generate a new website page with the same running logic style as the original website page according to the Excel table file after the user operations, thereby realizing the standardized development of the website page.

[0082] In the sixth embodiment of this application, a table template library can be pre-built, storing various Excel table templates. Each Excel table template has a pre-defined format and corresponding operation logic for its input area on the website page. The user-input table file is generated by selecting an Excel table template from the library and filling in the required component information. By filling in the relevant information of the component to be defined in the corresponding position in the Excel table template, the user has determined the corresponding operation logic of that component on the website page. The tool for rapidly developing website pages only needs to parse the running logic corresponding to the component from the Excel table file to develop and generate the corresponding website page.

[0083] The table template library includes at least one or more of the following: object category type templates, database connection configuration information type templates, and execution status log type templates. Among them:

[0084] In this embodiment, please refer to Figure 6 , Figure 6 This is a schematic diagram of a structure for an object category type template provided in the sixth embodiment of this application. For example... Figure 6 As shown, the input area in the object category type template can include component serial number information, object information, row position information, column position information, display name information, physical name information, data type information, length information, default value information, validation method information, operation information, etc. Taking operation information as an example, in this embodiment, operation information includes adding, deleting, modifying, etc. If a user enters a component in this table, and the operation information corresponding to that component is entered as "delete", then the tool for rapidly developing website pages can identify that the running logic corresponding to that component is deletion logic when parsing the table file. Therefore, when developing the website page, the tool for rapidly developing website pages will delete that component in the WanZhan page.

[0085] In this embodiment, please refer to Figure 7 , Figure 7 This is a schematic diagram of a database connection configuration information type template provided in the sixth embodiment of this application. Figure 7 As shown, the input area in the database connection configuration information type template can include database serial number information, database type information, database name information, driver class information, server IP information, port number information, connection URL information, username information, password information, and description information.

[0086] In this embodiment, the field to be filled in the execution status log type template only needs to record execution log information.

[0087] Please see Figure 8, Figure 8 This is a structural block diagram of a table-based website page development apparatus provided in the seventh embodiment of this application. In this embodiment, the apparatus includes units used to perform the steps described in embodiments one through four above. Please refer to the relevant descriptions in embodiments one through four above for details. For ease of explanation, only the parts relevant to this embodiment are shown. Figure 8 As shown, the table-based website page development device includes: an acquisition module 81, a parsing module 82, and a running module 83. Specifically: the acquisition module 81 acquires a table file input by the user. The table file records the components required for website page development. The input areas for recording components in the table file are pre-configured with corresponding operation logic and logic parsing rules. The parsing module 82 performs logical parsing processing on the components recorded in the table file according to the pre-configured logic parsing rules in the input areas, generating structured query statements corresponding to the components. By integrating the structured query statements corresponding to each component in the table file, a computer runtime logic file for developing and generating the website page is obtained. The running module 83 triggers the system to run the computer runtime logic file, generating a website page corresponding to the computer runtime logic file. For details, please refer to [further details]. Figure 9 , Figure 9 This document provides a system flowchart illustrating a table-based website page development apparatus used in a system to perform a website page development process, as described in the seventh embodiment of this application. Figure 9 As shown, the system uses its built-in tool for rapid website development to parse an Excel spreadsheet file, obtaining the aforementioned HTML file, database script file, XML file, and class file. Based on the computer's operational logic within the class file, it calls the HTML, database script, and XML files to ensure the normal operation of the computer's logic, thereby generating the website page. This embodiment, based on the system's built-in tool for rapid website development, parses the Excel spreadsheet file according to predetermined rules to obtain the website page's operational configuration file. This ensures a consistent and fixed style of the website page's logic code. For further development or iteration of the website page, the tool built into the backend system, utilizing the CRUD (Create, Read, Update, Delete) functions of Excel spreadsheets, directly generates the corresponding website page from the Excel spreadsheet file, facilitating code maintenance and improving development efficiency.

[0088] Furthermore, in this embodiment, the table-based website page development device may further include a generation submodule. This generation submodule is used to perform format parsing processing on the components recorded in the table file based on a pre-defined operation format in the table file's input area, generating a runtime configuration file for operation in conjunction with the computer's runtime logic file. The runtime configuration file includes a static page file, a database script file, and a data layer control file. Specifically: the static page file is used to generate the website page's display interface; the database script file is used to configure corresponding data sources for the components required by the website page; and the data layer control file is used to configure corresponding data operation statements for the components required for website page development.

[0089] It should be understood that the above-mentioned table-based website page development device corresponds one-to-one with the above-mentioned table-based website page development method, and will not be described again here.

[0090] Please see Figure 10 , Figure 10 This is a structural block diagram of a computer device provided in the eighth embodiment of this application. Figure 10 As shown, the computer device 10 in this embodiment includes a processor 1001, a memory 1002, and a computer program 1003 stored in the memory 1002 and executable on the processor 1001, such as a program for a table-based website page development method. When the processor 1001 executes the computer program 1003, it implements the steps in each embodiment of the table-based website page development method described above. Alternatively, when the processor 1001 executes the computer program 1003, it implements the functions of each module in the embodiment corresponding to the table-based website page development apparatus described above. Please refer to the relevant descriptions in the embodiments for details, which will not be repeated here.

[0091] For example, the computer program 1003 can be divided into one or more modules (units), which are stored in the memory 1002 and executed by the processor 1001 to complete this application. The one or more modules can be a series of computer program instruction segments capable of performing specific functions, which describe the execution process of the computer program 1003 in the computer device 10. For example, the computer program 1003 can be divided into an acquisition module, a processing module, and an execution module, with the specific functions of each module as described above.

[0092] The turntable device may include, but is not limited to, a processor 1001 and a memory 1002. Those skilled in the art will understand that... Figure 10The computer device 10 is only an example and does not constitute a limitation on the computer device 10, which can include more or fewer components than shown, or combine some components, or have different components, for example, the turntable device can also include an input / output device, a network access device, a bus, etc.

[0093] The processor 1001 can be a central processing unit (CPU), and can also be other general-purpose processors, a digital signal processor (DSP), an application specific integrated circuit (ASIC), a field-programmable gate array (FPGA) or other programmable logic devices, discrete gate or transistor logic devices, discrete hardware components, etc. The general-purpose processor can be a microprocessor or the processor can also be any conventional processor.

[0094] The memory 1002 can be an internal storage unit of the computer device 10, for example, a hard disk or a memory of the computer device 10. The memory 1002 can also be an external storage device of the computer device 10, for example, a plug-in hard disk, a smart media card (SMC), a secure digital (SD) card, a flash card, etc. Further, the memory 1002 can include both the internal storage unit and the external storage device of the computer device 10. The memory 1002 is used to store the computer program and other programs and data required by the turntable device. The memory 1002 can also be used to temporarily store data that has been output or will be output.

[0095] It should be noted that the information interaction, execution process, etc. between the above-mentioned devices / units, since based on the same concept as the method embodiments of the present application, the specific functions and the technical effects brought by them can be referred to the method embodiment part, and will not be repeated here.

[0096] The computer readable storage medium stores a computer program, and the computer program is executed by a processor to implement the steps in each of the above-mentioned method embodiments. In this embodiment, the computer readable storage medium can be non-volatile or volatile.

[0097] The embodiment of the present application provides a computer program product, when the computer program product runs on the mobile terminal, causes the mobile terminal to execute the steps in the above-mentioned various method embodiments.

[0098] Those skilled in the art can clearly understand that, for the convenience and brevity of description, only the division of the above-mentioned functional units and modules is exemplified, and in actual application, the above-mentioned functions can be completed by different functional units and modules according to needs, that is, the internal structure of the device is divided into different functional units or modules to complete all or part of the functions described above. The functional units and modules in the embodiments can be integrated in one processing unit, or each unit can be physically present separately, or two or more units can be integrated in one unit. The integrated unit can be realized in the form of hardware or software. In addition, the specific names of the functional units and modules are only for easy distinction, and do not limit the protection scope of the present application. The specific working process of the units and modules in the system can refer to the corresponding process in the foregoing method embodiments, which will not be described here.

[0099] The integrated modules / units, if realized in the form of software functional units and sold or used as independent products, can be stored in a computer readable storage medium. Based on this understanding, all or part of the processes in the above-mentioned embodiment methods can also be completed by a computer program to instruct related hardware, and the computer program can be stored in a computer readable storage medium. When the processor executes the computer program, the steps of the various method embodiments can be implemented. The computer program includes computer program code, which can be in the form of source code, object code, executable file or some intermediate form. The computer readable medium can include any entity or device, recording medium, U disk, mobile hard disk, magnetic disk, optical disk, computer memory, read-only memory (ROM), random access memory (RAM), electric carrier signal, telecommunication signal and software distribution medium, etc. that can carry the computer program code. It should be noted that the content included in the computer readable medium can be appropriately increased or decreased according to the requirements of legislation and patent practice in the jurisdiction, for example, in some jurisdictions, according to legislation and patent practice, the computer readable medium does not include electric carrier signal and telecommunication signal.

[0100] In the above embodiments, the description of each embodiment has its own emphasis, and the parts not described or recorded in detail in a certain embodiment can be referred to the relevant description of other embodiments.

[0101] The above-described embodiments are only used to illustrate the technical solutions of the present application, but not limit them; although the present application is described in detail with reference to the foregoing embodiments, those skilled in the art should understand that: it can still modify the technical solutions recorded in the foregoing embodiments, or make equivalent replacement to part of the technical features; and these modifications or replacements do not make the essence of the corresponding technical solutions deviate from the spirit and scope of the technical solutions of the embodiments of the present application, and should be included in the protection scope of the present application.

Claims

1. A table-based website page development method, characterized by, The application comprises the following steps: obtaining a table file filled by a user, wherein the table file records components required for website page development, and the filling area for recording components in the table file is pre-configured with corresponding operation logic and logic analysis rules; performing logic analysis processing on the components recorded in the table file according to the logic analysis rules pre-configured in the filling area of the table file, obtaining the component operation logic of the components in the table file, and generating a computer running logic file for developing a website page by converting the component operation logic of each component in the table file into a structured query statement; triggering the system to run the computer running logic file to generate a website page corresponding to the computer running logic file; The table file is pre-configured with corresponding operation formats and format analysis rules for the filling area. Before the step of performing logic analysis processing on the components recorded in the table file according to the logic analysis rules pre-configured in the filling area of the table file, obtaining the component operation logic of the components in the table file, and generating a computer running logic file for developing a website page by converting the component operation logic of each component in the table file into a structured query statement, the application comprises the following steps: performing format analysis processing on the components recorded in the table file based on the operation formats pre-configured in the filling area of the table file, and generating a running configuration file for running in cooperation with the computer running logic file, wherein the running configuration file comprises a static page file, a database script file and a data layer control file; The static page file is used to generate a display interface of a website page. The database script file is used to configure corresponding data sources for the components required for website page development. The data layer control file is used to configure corresponding data operation statements for the components required for website page development. The step of performing logic analysis processing on the components recorded in the table file according to the logic analysis rules pre-configured in the filling area of the table file, obtaining the component operation logic of the components in the table file, and generating a computer running logic file for developing a website page by converting the component operation logic of each component in the table file into a structured query statement comprises the following steps: obtaining field information of the components recorded in the table file and object information corresponding to the field information; creating instance objects for each component in the table file according to the field information and the object information corresponding to the field information; generating structured query statements corresponding to the instance objects according to the component operation logic of the components in the table file in combination with the database script file and the data layer control file; integrating the structured query statements corresponding to each instance object in the table file to generate a computer running logic file for developing a website page.

2. The table-based website page development method of claim 1, wherein, The step of performing format analysis processing on the components recorded in the table file based on the operation formats pre-configured in the filling area of the table file, and generating a running configuration file for running in cooperation with the computer running logic file comprises the following steps: reading field information of components recorded in the table file and object information corresponding to the field information; identifying a data operation rule corresponding to the field information from the table file according to the object information, and generating a data operation statement corresponding to the field information according to the data operation rule, wherein the data operation rule is a data operation rule built in the table file; associating the data operation statement with the field information, and generating a corresponding data layer control file, the data layer control file being represented as an extensible markup language file.

3. The table-based website page development method of claim 1, wherein, The step of triggering the system to run the computer running logic file to generate a website page corresponding to the computer running logic file includes: monitoring a system preset folder to check whether the system preset folder has a new version of the computer running logic file; if the system preset folder is found to have the new version of the computer running logic file, loading the new version of the computer running logic file from the system preset folder and calling a running configuration file matched with the computer running logic file to run and process, so as to generate a corresponding website page.

4. The table-based website page development method of claim 1, wherein, Before the step of obtaining the table file input by the user, the method includes: constructing a table template library, and the table file input by the user is generated by selecting a table template from the table template library and filling in component information in the table template, wherein the table template library at least includes one or more of an object category type template, a database connection configuration information type template, and an execution state log type template.

5. A table-based website page development apparatus, characterized by comprising: The method includes: an obtaining module configured to obtain a table file input by a user, the table file recording components required for website page development, wherein a filling area in the table file for recording components is preconfigured with corresponding operation logic and logic analysis rules; an analysis module configured to perform logic analysis processing on the components recorded in the table file according to the logic analysis rules preconfigured in the filling area of the table file, to obtain component operation logic of the components in the table file, and to generate a computer running logic file for developing a website page by converting the component operation logic of each component in the table file into a structured query language statement; a running module configured to trigger the system to run the computer running logic file to generate a website page corresponding to the computer running logic file; The table file is preconfigured with corresponding operation formats and format analysis rules for the filling area, and the website page development device further includes a generation module configured to, before triggering the analysis module to execute, perform format analysis processing on the components recorded in the table file based on the operation formats preconfigured for the filling area of the table file, to generate a running configuration file for running in cooperation with the computer running logic file, the running configuration file including a static page file, a database script file, and a data layer control file; wherein: the static page file is used to generate a display interface of a website page. ​ The database script file is used for configuring a corresponding data source for a component required by a website page; The data layer control file is used for configuring a corresponding data operation statement for a component required by website page development; Correspondingly, the parsing module is specifically configured to: obtain field information of the components recorded in the table file and object information corresponding to the field information; create instance objects for each component in the table file according to the field information and the object information corresponding to the field information; generate structured query statements corresponding to the instance objects according to component operation logic of the components in the table file, in combination with the database script file and the data layer control file; integrate the structured query statements corresponding to each instance object in the table file to generate a computer running logic file used for developing a website page.

6. A computer device comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, characterized in that, The processor executes the computer program to implement the steps of the method according to any one of claims 1 to 4.

7. A computer-readable storage medium storing a computer program, the computer program comprising instructions that, when executed by a computer, cause the computer to perform the method of any one of claims 1 to 6. The computer program is executed by the processor to implement the steps of the method according to any one of claims 1 to 4.

Images