CN108427554B - A table-driven cloud model software automatic construction method and system - Google Patents

Abstract

The invention discloses a method and a system for automatically constructing cloud mode software driven by a table, wherein the method comprises the following steps: the user fills in related demand information in the software system demand table and submits the related demand information, automatically reads all the related demand information in the received software system demand table through a Web software automatic construction framework, analyzes and checks all the read related demand information of the system, automatically constructs a Web software system matched with the demand according to the checked information of the software system demand table, and injects the Web software system into a cloud environment where the corresponding Web software framework is located. The automatic software construction method and system simplify complicated software development flow in the traditional mode, support the multi-tenant software as a service cloud mode, save programming and deployment links in the conventional information management system software development process for users, and enable the users to quickly and efficiently construct the Web software system meeting the requirements only by focusing on defining the system requirements, thereby greatly improving the software development efficiency.

Description

A table-driven cloud model software automatic construction method and system

Technical field

The invention relates to the technical field of software engineering, and specifically to a table-driven cloud model software automatic construction method and system.

Background technique

With the rapid development of the Internet and cloud computing technology, the needs for information and data collection, storage, and query have increasingly become normal needs in the information society. Whether enterprise-level application developers or non-enterprise-level application developers, they have designed and developed Web software systems with specific needs are a very common objective need. Under the traditional model, software usually goes through a relatively tedious development process from design to production, including requirements analysis, software design, program writing, testing and verification, and system deployment. Moreover, the needs given by each user are also different. If you have to go through such a complicated software development process for each need, it will obviously be very time-consuming and resource-consuming. However, general information system software has common characteristics around data collection, storage, addition, deletion, modification, and other operations, and the software-as-a-service cloud model also provides technical feasibility for real-time deployment of software. Therefore, the present invention transcends the programming and deployment links of traditional Web software development, and provides an automatic construction method for Web software systems that meets the specific needs of multiple users by extracting and constructing common features of general information system software, thereby greatly saving and improving software development and programming. cost; and embed this invention method into the cloud environment to improve the timeliness of software deployment and release.

Contents of the invention

The purpose of the present invention is to overcome the shortcomings and deficiencies in the prior art and provide a table-driven automatic cloud model software construction method that automatically reads and analyzes user fill-in through a Web software automatic construction framework (WSACF, referred to as Web software framework) software system requirements table, and then construct a Web software system based on the read demand information, and inject the corresponding Web software framework into the cloud environment where it is located, which is available for users to save time-consuming programming development and deployment work. You only need to focus on defining system requirements to quickly and efficiently construct a Web software system that meets the needs, greatly improving software production efficiency.

Another object of the present invention is to provide a table-driven cloud model software automatic construction system using the above-mentioned table-driven cloud model software automatic construction method.

In order to achieve the above objectives, the present invention adopts the following technical solutions:

A method for automatically constructing table-driven cloud model software, including the following steps:

S1. The user fills in the software system requirement information according to the form format provided or agreed upon by the Web software framework, and generates a software system information table; then submits the completed software system requirement form to the Web software framework online or offline; the software system requirements The information includes: system administrator information, user group information, user information, and model information; the Web software framework is an application deployed on the Web server;

S2. The Web software framework receives the storage path of the software system requirement table specified by the user through the data acquisition server, and obtains the software system requirement table according to the storage path, and then the Web software framework performs operations on the obtained software system requirement table. Traverse, read various information recorded in the software system requirement table, and transmit the read various software system requirement information to the data analysis server;

S3. The Web software framework uses the data analysis server to verify the data type and format of each software system requirement information in the software system requirement table to determine whether it meets the format filling requirements of the software system requirement table; if the verification fails, It prompts the user that the format is incorrect, please re-upload the software system requirements table, that is, repeat step S1, step S2 and the current step; if the verification is passed, proceed to the next step;

S4. The Web software framework constructs a Web software system based on the information in the verified software system requirement table, injects it into the cloud environment where the Web software framework is located, and then uses the constructed Web software system;

S41. Design the underlying code class of the Web software framework. The underlying code class is used to automatically construct the Web software system within the Web software framework;

S42. The Web software framework automatically constructs a Web software system through underlying code classes. Its external activity process is: the Web software framework registers and creates a software system based on the administrator information of the verified software system requirement table, and then determines the software system requirements in turn. Whether there is user group information, user information, model information or structure information within the model in the table? If so, the Web software framework reads the corresponding information that exists in the software system requirements table and generates user groups and users in the created software system. , model, or model field; when there are multiple models in the software system requirement table, the Web software framework repeatedly reads the model information until all the number of models have been read, and the final Web software system is generated;

S43. Inject the Web software system obtained in step S42 into the Web software framework through the software injection server, and automatically deploy and publish it in the cloud through the Web software framework for users to access and use;

S44. When the user wants to batch inject data into the created Web software system, the user fills in the data record exchange form, which includes model field information and data record information, and then submits it to the Web software framework. The Web software The framework reads the information in the data record exchange table, and then performs format verification on the read information. For the data exchange record table that passes the verification, the Web software framework reads the model field information and determines the information based on the model field information. The model to be exchanged for data is then injected into the model with data record information, that is, the data injection operation is completed.

As a preferred technical solution, in step S1, the software system requirement information includes: system administrator information, user group information, user information, and model information, specifically as follows:

The system administrator information includes: system administrator ID, system administrator password, and system title;

The user group information is the user group ID, and multiple user groups can be customized according to needs;

The user information includes: user ID, user name, user password, and group ID to which the user belongs;

The model information can be customized according to the needs of multiple models. The information included specifically includes: the read and write permissions of users in the group to which the user belongs, the read and write permissions of other users, model name, model entry person ID, group ID, Model field type, model field name, whether the field value is allowed to be empty, default value, and alternative value; the read and write permissions of users in the group to which the user belongs and the read and write permissions of other users include: readable, writable, and Read but not write, and neither read nor write; the model entry person ID is included in the user ID in the user information; the group ID is included in the user group ID in the user group; the model field type, its value includes : Text, Float, Integer, Link, Date, Datetime, and Boolean; whether the field value is allowed to be empty, its values include: TRUE, FALSE, where TRUE means that it is allowed to be empty, and FALSE means that it is not allowed to be empty;

The submission methods of the software system requirement form include: online submission and offline submission; the online submission: the user fills in the software system requirement information online according to the Web form format provided by the Web software framework and submits it to the Web software framework; the offline submission Submit: The user fills in the software system requirement information offline according to the offline form format template agreed by the Web software framework and submits it to the Web software framework through file upload.

As a preferred technical solution, in step S1, the Web software framework is an application deployed on a Web server with a system display interface; the system display interface includes: a system administrator interface and a user interface;

The system administrator interface includes user management, user group management, and model management; the user management is used to manage user information of the Web software system to be created, and the management functions include adding users, deleting users, and adding users to users. group information, and delete user group information for users; the user group management is used to manage the user group information of the Web software system to be created, and the management functions include adding user groups, deleting user groups, adding user information to user groups, And delete user information for the user group; the model management is used to manage the model information of the Web software system to be created, and the management functions include adding model information, deleting model information, adding model field information, deleting model field information, and modifying the model. Field information, and assigning different access rights to different user groups for the model;

The user interface includes data management, data statistics, import and export of Excel tables and other format tables, and advanced search; the data management is used to manage the records of the Web software system data table to be created, and the management functions include adding data Record, delete data records, modify data records, and obtain all data records; the data statistics are used to count the data table records of the Web software system to be created, and the statistical functions include recording number statistics for the integer fields of the data table , maximum value statistics, minimum value statistics, and average value statistics; the import and export of Excel tables and other format tables are used to import data in Excel tables and other format tables into corresponding tables of the created Web software system, And the data in the tables of the Web software system can be exported to Excel tables and other format tables; the advanced search is used to conduct a variety of logical combination searches on multiple fields of Excel tables and other format tables, and query the results that meet the search conditions. record information.

As a preferred technical solution, in step S2, the Web software framework automatically reads various system requirement information in the software system requirement table. Its automatic reading unit includes a software system requirement table traversal unit, a system administrator information reading unit, and a user Group information reading unit, user information reading unit, and model information reading unit;

The software system requirement table traversal unit is used to traverse the software system requirement table;

The system administrator information reading unit is used to read the system administrator ID, system administrator password, and system title when traversing the system administrator information;

The user group information reading unit is used to read user group ID information when traversing user group information;

The user information reading unit is used to read the user ID, user name, user password, and user group ID when traversing user information, where the user group ID is the user group ID contained in the user group information. ;

The model information reading unit is used to read the read and write permissions of users in the group to which the user belongs, the read and write permissions of other users, the model name, the ID of the model entry person, the ID of the group to which the user belongs, and the field type when traversing the model information. , field name, whether the field value is allowed to be empty, default value, and alternative value.

As a preferred technical solution, in step S3, the Web software framework performs data type and format verification on each software system requirement information in the software system requirement table. Specifically, it reads and writes the users in the group to which the user in the model information belongs. Permissions, read and write permissions of other users, model field types, and whether the field value allows empty values satisfy the filling requirements; if the group item to which the user belongs is not empty, determine whether the value filled in the item is included in the software system requirements table user group information.

As a preferred technical solution, in step S41, the Web software framework automatically constructs a Web software system through underlying code classes. The underlying code classes involve 5 classes and 4 interfaces. Among them, the 5 classes include: demand table reading class Read_Demand , user group management class Manage_Group, user management class Manage_User, model management class Manage_Schema, and data management class Manage_Data; 4 interfaces, including: user group management interface GManage_Group, user management interface GManage_User, model management interface GManage_Schema, and data management interface GManage_Data ; Automatically constructing a Web software system through the underlying code class, specifically including the following steps:

(1) Read the system administrator section in the software system demand table through the API used to process system administrator information in the demand table reading class Read_Demand, traverse its cells, and based on the system administrator ID, system administrator password and The system name registers the software system under the super administrator authority of the Web software framework, and creates the corresponding database entity of the software system in the underlying database of the Web software framework. At the same time, four Collections are created under the database, namely user group group, User user, model schema, data data; wherein the super administrator is the highest authority administrator of the Web software framework, used to receive the administrator information set by the user and register the software system in the Web framework; the Web software framework The underlying database is used by the Web software framework to store data;

(2) Read the user group information in the software system demand table through the API used to process user group information in the demand table reading class Read_Demand, traverse the filled in user group ID information cells, and based on the obtained user group ID information Generate a string in Json format and insert it into the user group collection of the database entity created in step (1);

(3) Read the user information in the software system demand table through the API used to process user information in the demand table reading class Read_Demand, traverse the user information filled in, read row by row and traverse the cells of each row, according to All the user information obtained is generated as a string in Json format and inserted into the user collection of the database entity created in step (1);

(4) Read the model information of the system demand table through the API used to process model information in the demand table reading class Read_Demand, traverse the filled model information cells, generate a Json format string based on the model information, and convert it Insert into the model schema collection of the database entity created in step (1);

(5) Operate the user group data in the user group group collection of the database entity in the underlying database through the user group management class Manage_Group, and return the operation results to the system display interface of the Web software framework. The user group management class Manage_Group Implement the user group management interface GManage_Group defined in the Web software framework;

(6) Operate the user data in the user collection of the database entity in the underlying database through the user management class Manage_User, and return the operation results to the system display interface of the Web software framework;

(7) Operate the model data in the schema collection of the database entities in the underlying database through the model management class Manage_Schema, and return the results to the interface of the Web software framework. The model management class Manage_Schema implements the model defined in the Web software framework. Management interface GManage_Schema;

(8) Operate the data records in the data collection of the database entity in the underlying database through the data management class Manage_Data, and return the results to the system display interface of the Web software framework. The data management class Manage_Data implements the Defined data management interface GManage_Data.

As a preferred technical solution, in step S42, the Web software framework automatically constructs a Web software system through underlying code classes. The specific process of its external activities is as follows:

S421. The Web software framework reads the administrator information in the software system requirement table that has passed the verification. The administrator information includes the system administrator user name, the system administrator password, and the information of the created software system name; according to the read Administrator information, register to create a software system;

S422. The Web software framework determines whether user group information exists in the software system requirement table. If there is user group information in the software system requirement table, and the user group information is the user group ID, then it is created in step S411 based on the read user group ID. Generate user groups in the software system; if the user group information does not exist in the software system requirements table, proceed to the next step;

S423. The Web software framework determines whether user information exists in the software system requirement table. If there is no user information in the software system requirement table, the user information includes user ID, user name, user password, and the group to which the user belongs. According to the read The user information is generated in the software system created in step S411; if user information exists in the software system requirement table, proceed to the next step;

S424. The Web software framework determines whether model information exists in the software system requirement table. If model information exists in the software system requirement table, read the number of models in the software system requirement table, assign the current count value to 0, and then read the model information. , that is, the model name, model entry person, group ID, and user read and write permission information of the group to which the user belongs, and create the specified model in the software system created in step S411 based on the read model information; and then make a judgment Whether there is structural information in the model. If there is structural information in the model, read the structural information in the model, that is, the structure field name, field type, whether the field value is allowed to be empty, the default value, and the alternative value, and based on The read structural information in the model creates fields in the specified model that has been created. At the same time, the current model number count value is +1, and then it is judged whether the current count is less than the number of models. If the current count is less than the number of models, continue to read the next model. information, repeat this step; if the current count is greater than the number of models, the Web software framework completes the self-construction of the software system and generates a Web software system.

As a preferred technical solution, in step S5, the user fills in the data record exchange form and submits it to the Web software framework, as follows:

The information in the data exchange record table includes: model field information and data records; the model field information is all the field names of the model that the user sets according to the needs for data record exchange; the data records are the needs added by the user according to the needs All data record information injected into the model;

The submission methods of the data exchange record table include: online submission and offline submission; the online submission: when the user enters the Web software system constructed according to the Web software framework and enters the data provided by the Web software system into the Web page, the online entry is The information in the data exchange record table is submitted to the Web software system; the offline submission: when the user constructs a Web software system based on the Web software generation framework, the data record exchange table template format provided by the Web software system is used offline. Enter the model field information and data record information and submit it to the Web software system through file upload.

A software automatic construction system for a table-driven cloud model software automatic construction method, including a client, a data acquisition module, a data analysis module, a software construction module, a software injection module, and a Web server; the client is used for users to fill in software The system requirement table is submitted to the data acquisition module. The data acquisition module traverses the software system requirement table through the data acquisition server, classifies and reads the information recorded in the software system requirement table, and then classifies each software item after reading it. The system requirement information is transmitted to the data analysis module; the data analysis module performs format analysis and verification on the obtained software system requirement information through the data analysis server. If the format verification is incorrect, the user is reminded to refill the software system requirement form. If If the format verification is correct, the software system requirement information with correct format verification will be transmitted to the software construction module; the software construction module will automatically construct the software system requirement information with correct format verification based on the software construction server. Output the Web software system that matches the information, and then transfer the Web software system to the software injection module; the software injection module injects the Web software system into the Web software framework through the software injection server, and injects the Web software through the Web software framework The system is deployed on a Web server for users to access and use; the Web software framework is an application used to automatically construct software and is deployed on the Web server, with a system display interface.

As a preferred technical solution, the client, data acquisition server, data analysis server, software construction server, software injection server, and Web server are all PC computers, and HTTP communication is used between the client and the Web server. The communication protocol adopts TCP protocol; other servers adopt Socket communication method, and the communication protocol adopts TCP protocol.

The present invention has the following advantages and effects compared with the prior art:

The table-driven cloud mode software system automatic construction method proposed by the present invention not only simplifies the complicated software development process in the traditional mode, but also supports the multi-tenant software-as-a-service cloud mode, saving users time-consuming programming and development work. , so that users only need to focus on defining system requirements to quickly and efficiently construct a Web software system that meets their needs, which greatly improves software development efficiency and provides convenience for enterprise-level and non-enterprise-level users to customize information management systems that meet their own needs. sex.

Description of the drawings

Figure 1 is a flow chart of the automatic construction method of the table-driven cloud model software system in Embodiment 1;

Figure 2 is a specific workflow diagram of the automatic construction method of the table-driven cloud model software system in Embodiment 1;

Figure 3(a)-Figure 3(c) respectively show the user management interface, user group management interface, and model management interface under the system administrator interface of the University Town Automobile 4S Service Management Information System in this application example;

Figure 4 shows the system interface under the ordinary user interface of the University Town Automobile 4S Service Management Information System in this application example;

Figure 5 is a flow chart of table-driven automatic injection of data records in Embodiment 1;

Figure 6 is a use case diagram of the super administrator module of the automatically generated Web software system in Embodiment 1;

Figure 7 is a use case diagram of the system administrator module of the automatically generated Web software system in Embodiment 1;

Figure 8 is a use case diagram of the user module of the automatically generated Web software system in Embodiment 1;

Figure 9 is a UML class diagram of the automated construction process of Embodiment 1;

Figure 10 is an activity diagram of a Web software system application example constructed using the table-driven cloud model software system automatic construction method in Embodiment 1;

Figure 11 is a state diagram of a Web software system application example constructed using the table-driven cloud model software system automatic construction method in Embodiment 1;

Figure 12 is a table-driven cloud model software system automatic construction system in Embodiment 2.

In the text description of the above drawings, the system requirement table refers to the software system requirement table.

Detailed ways

In order to make the purpose, technical solutions and advantages of the present invention more clear, the present invention will be further described in detail below with reference to the drawings and embodiments. It should be understood that the specific embodiments described here are only used to explain the present invention and are not limited to the present invention.

Example 1

As shown in Figure 1, a table-driven cloud model software automatic construction method includes the following steps:

S1. The user fills in the software system requirement information according to the form format provided or agreed upon by the Web software framework, and generates a software system information table; then submits the completed software system requirement form to the Web software framework online or offline; the software system requirements The information includes: system administrator information, user group information, user information, and model information; the Web software framework is an application deployed on the Web server;

S2. The Web software framework receives the storage path of the software system requirement table specified by the user through the data acquisition server, and obtains the software system requirement table according to the storage path, and then the Web software framework performs operations on the obtained software system requirement table. Traverse, read various information recorded in the software system requirement table, and transmit the read various software system requirement information to the data analysis server;

S3. The Web software framework uses the data analysis server to verify the data type and format of each software system requirement information in the software system requirement table to determine whether it meets the format filling requirements of the software system requirement table; if the verification fails, It prompts the user that the format is incorrect, please re-upload the software system requirements table, that is, repeat step S1, step S2 and the current step; if the verification is passed, proceed to the next step;

S4, the Web software framework automatically constructs the Web software system and deploys and publishes it on the cloud, as well as updates the Web software system;

S41. Design the underlying code class of the Web software framework. The underlying code class is used to automatically construct the Web software system within the Web software framework. The underlying code class involves 5 classes and 4 interfaces, where the 5 classes include: Demand table reading class Read_Demand, user group management class Manage_Group, user management class Manage_User, model management class Manage_Schema, and data management class Manage_Data; 4 interfaces, including: user group management interface GManage_Group, user management interface GManage_User, model management interface GManage_Schema , and the data management interface GManage_Data; obtain various demand information in the system demand table through the Read_Demand class, and perform the corresponding operations of generating database entities and generating database entity collections; the Manage_Group class implements the GManage_Group interface, which controls users in the group collection of database entities. Manage_User implements the GManage_User interface to operate on user data in the user collection of database entities; Manage_Schema implements the GManage_Schema interface to operate on model data in the schema collection of database entities; Manage_Data implements the GManage_Data interface to operate on Operate the data records in the data collection of the database entity; the four classes Manage_Group, Manage_User, Manage_Schema, and Manage_Data all depend on the Read_Demand class;

S42. The Web software framework automatically constructs a Web software system through underlying code classes. Its external activities are: the Web software framework registers and creates a software system based on the administrator information of the verified software system requirement table, and then determines the software system requirement table in turn. Whether there is user group information, user information, model information or structure information within the model. If it exists, the Web software framework reads the corresponding information in the software system requirements table and generates user groups, users, Model, or model field; when there are multiple models in the software system requirement table, the Web software framework repeatedly reads the model information until all the models have been read, and the final Web software system is generated; as shown in Figure 2, the The steps specifically include the following steps:

S421. The Web software framework reads the administrator information in the software system requirement table. The administrator information includes the system administrator user name, the system administrator password, and the information to create the software system name; according to the read administrator information , create a software system;

S422. The Web software framework determines whether user group information exists in the software system requirement table. If user group information exists in the software system requirement table, and the user group information is the user group ID, then step S411 is performed based on the read user group ID. Generate user groups in the created software system; if the user group information does not exist in the software system requirements table, proceed to the next step;

S423. The Web software framework determines whether user information exists in the software system requirement table. If there is no user information in the software system requirement table, the user information includes user ID, user name, user password, and the group to which the user belongs. According to the read The user information is generated in the software system created in step S411; if user information exists in the software system requirement table, proceed to the next step;

S424. The Web software framework determines whether model information exists in the software system requirement table. If model information exists in the software system requirement table, read the number of models in the software system requirement table, assign the current count value to 0, and then read the model information. , that is, the model name, the model entry person, the group ID to which the user belongs, and the user permission information of the group to which the user belongs, and creates the specified model in the software system created in step S411 based on the read model information; and then determines the model Whether there is structural information in the model. If there is structural information in the model, read the structural information in the model, that is, the structural field name, field type, and whether the field value is allowed to be empty in the model, and based on the read structural information in the model, Create a field in the specified model that has been created, and add 1 to the current model number count value, and then determine whether the current count is less than the number of models. If the current count is less than the number of models, continue to read the next model information and repeat this step; if the current count is less than the number of models, continue reading the next model information and repeat the step; If the count is greater than the number of models, the Web software framework completes the self-construction of the software system and generates a Web software system;

S43. Inject the Web software system obtained in step S42 into the Web software framework through the software injection server, and automatically deploy and publish it in the cloud through the Web software framework for user access; in this embodiment, the Web software framework supports Web software The System as a Service SAAS cloud model means that the Web software system generated by the Web software framework is automatically deployed and released in the cloud.

S44. When the user wants to batch inject data into the created Web software system, the user fills in the data record exchange form, which includes model field information and data record information, and then submits it to the Web software framework. The Web software The framework reads the information in the data record exchange table, and then performs format verification on the read information. For the data exchange record table that passes the verification, the Web software framework reads the model field information and determines the information based on the model field information. The model to be exchanged for data is then injected into the model with data record information, that is, the data injection operation is completed.

Table 1

In this embodiment 1, as shown in Table 1, the software system requirements table specifically includes the following:

1) System administrator information part, including: a) system administrator ID; b) system administrator password; c) system title;

2) User group information part, including: a) User group ID; multiple user groups can be filled in according to needs. If no user group is required, leave it blank; the user group ID information needs to be filled in the same row but in different columns;

3) User information part, including: a) user ID; b) user name; c) user password; d) group to which the user belongs; if a user belongs to multiple groups, separate them with commas; If the user does not belong to any group, leave it blank;

4) Model information part, including: a) The read and write permissions of users in the group to which the user belongs, including three types: read and write, read and write, not read and write; b) The read and write permissions of other users, including three Type: readable and writable, readable but not writable, not readable but not writable; c) model name; d) entry ID; e) group ID; f) structural information within the model, including: ① Field type, the value includes : Text, Float, Integer, Link, Date, Datetime, Boolean; ②Field name; ③Whether the field value is allowed to be empty, the value can be: TRUE, FALSE; TRUE means that it is allowed to be empty, and FALSE means that it is not allowed to be empty.

The following is a specific application example of the table-driven cloud model software automatic construction method and system in this embodiment, and the process of automatically producing a Web software system is explained in detail.

If the software construction method of the existing technology is used, realizing a Web software system with conventional functions requires going through conventional processes such as system requirements analysis, system overall design, system detailed design, and system specific implementation. The following will describe in detail how to construct a university town automobile 4S service management information system across the traditional development process based on a table-driven cloud model software system automatic construction method proposed in this embodiment;

1) Fill in the relevant demand information of the University Town Automobile 4S Service Management Information System according to the software system demand table format provided in this embodiment. In this example, the software system demand table takes an Excel table as an example. The software system requirements table for the University Town Automobile 4S Service Management Information System is filled in as shown in Table 2:

Table 2

As shown in Table 2:

a) The system administrator ID of this system is "liuyu2018", the password is "2018", and the system title is "University Town Automobile 4S Service Management Information System 1.0newmedia.lab.2018.Spring".

b) There are three user groups in this system: group1, group2, and group3.

c) There are three users in this system, namely: panshiying, whose user name is panshiying, user password is panshiying, and the group he belongs to is group1; lirunmin, whose user name is lirunmin, user password is lirunmin, and his group is group2; liuyu, The user name is liuyu, the user password is liuyu, and the groups it belongs to are group1 and group2.

d) There are three models in this system.

e) The first model: the model name is the basic information of the vehicle, the group it belongs to is group1, the permissions of the members of the group are readable and writable, the permissions of other users are readable and non-writable, the entry person is liuyu; there are eight in the model Field: The vehicle type number whose field type is Integer is not allowed to be empty; the vehicle model whose field type is Text is allowed to be empty; the vehicle engine model whose field type is Text is allowed to be empty; the vehicle body model whose field type is Text, Allowed to be empty; wheel model whose field type is Text, allowed to be empty; sales price whose field type is Float, allowed to be empty; vehicle color whose field type is Text, allowed to be empty; vehicle type whose field type is Text, allowed to be empty null.

f) The second model: the model name is customer information, the group it belongs to is group1, the permissions of the group members are readable and writable, the permissions of other users are readable and non-writable, the entry person is liuyu; there are 6 fields in the model : The customer number whose field type is Integer is not allowed to be empty; the customer name whose field type is Text is not allowed to be empty; the ID card number whose field type is Text is allowed to be empty; the service organization whose field type is Text is allowed to be empty Empty; if the field type is Text, the income status is allowed to be empty; if the field type is Integer, the age is allowed to be empty.

g) The third model: the model name is maintenance information, the group it belongs to is group2, the permissions of the group members are readable and writable, the permissions of other users are readable and non-writable, the entry person is liuyu; there are 7 fields in the model : The maintenance number whose field type is Integer is allowed to be empty; the customer name whose field type is Text is allowed to be empty; the vehicle name whose field type is Text is allowed to be empty; the vehicle number whose field type is Text is allowed to be empty; field The fault type of Text type is allowed to be empty; the maintenance record with field type of Text is allowed to be empty; the maintenance cost with field type of Text is allowed to be empty.

2) Name the software system requirements table in Excel format the same as the system administrator ID. In this application example, the name of the Excel file is "liuyu2018.xls".

3) The super administrator of the Web software framework reads the system administrator ID, system administrator password and system title in the software system requirement table, and registers the system administrator account in the background of the Web software framework.

4) The user uses the registered system administrator account to log in to the corresponding Web software framework, uploads the software system requirements table in Excel format defined by the user to the Web software framework, and injects the software system requirement information into the Web software framework; click to submit the Excel file After that, a Web software system that meets the requirements definition is generated;

5) After the display is successful, refresh the panel and you can view the generated University Town Automobile 4S Service Management Information System 1.0newmedia.lab.2018.Spring.

In the university town automobile 4S service management information system of this application example, the ordinary user interface is shown in Figure 4. The system administrator interface can find the user group management interface shown in Figure 3(a), Figure 3(b) ), and the model management interface shown in Figure 3(c).

table 3

Field name 1 Field name 2 Field name 3 Field name 4 Field name 5 Field name 6 ... ... ... ... ... ... ... ...

In this application example, the format of the data record exchange table is shown in Table 3, which is described as follows:

After users generate a Web software system by filling in the software system requirement form, they can fill in the data record exchange form to inject data into the Web software system in batches.

The data record exchange table includes the following two parts:

1) Field information part: The user fills in the model fields according to the data record to be injected.

2) Data recording part: Users add data recording information that needs to be injected into the model according to their needs.

As shown in Figure 5, automatic injection of data records specifically includes the following steps:

1) The customer fills in the data record exchange form in the format provided by the present invention according to the needs.

2) The Web software framework obtains the data record exchange table uploaded by the customer in 1) and verifies whether the format of the data record exchange table meets the requirements. If it does not meet the requirements, it will prompt the user that the format is incorrect and please re-upload it. If it meets the requirements, it will transfer to 3).

3) The Web software framework reads the model field information in the data record exchange table.

4) The Web software framework determines the model required for data exchange based on the model field information read in 3).

5) The Web software framework reads the data record information in the data record exchange table line by line, and injects it into the model determined in step 4) in turn.

In this application example, Figure 6 shows the automatically generated super administrator module use case diagram of the Web software system. The use case associated with the super administrator (this participant) is system management, where system management specifically includes new systems. There are three use cases: deleting system and getting system list.

Figure 7 shows the system administrator use case diagram of the automatically generated Web software system. The use cases associated with the system administrator (this participant) include three use cases: user management, user group management and model management, as follows:

1) The user management, this use case includes seven use cases, namely adding users, deleting users, editing users, obtaining user lists, obtaining user group list, adding users to user groups, and deleting users from user groups; among which ,

a) The described adding of users includes two use cases, adding users one by one in the system and adding users in batches according to the system requirement table;

b) The described adding users to user groups includes two use cases, adding users to user groups one by one in the system and adding users to user groups in batches according to the system requirement table;

2) The user group management, this use case includes eight use cases, namely adding user group, deleting user group, editing user group, getting user group list, getting user list of user group, adding user to user group, from user group Delete users and obtain the list of models that the user group has permissions from; among them,

a) The adding of user groups includes two use cases, namely adding user groups one by one in the system and adding user groups in batches according to the system requirements table;

b) The described adding users to user groups includes two use cases, namely adding users to user groups one by one in the system and adding users to user groups in batches according to the system requirements table;

3) The model management, this use case includes four use cases, namely adding model, deleting model, editing model, and obtaining system model list;

a) The added model includes two use cases, namely adding models one by one in the system and adding models in batches according to the system requirement table;

b) The editing model includes two use cases, namely editing model information and editing field information within the model.

Figure 8 shows the user interface use case diagram of the automatically generated Web software system. The specific description is as follows:

1) User, this participant is associated with five use cases, namely data management, data statistics, importing data records, exporting data records, and advanced search; among them,

a) The data management includes four use cases, namely obtaining all records of the model, adding data records, deleting data records, and modifying data records;

b) The data statistics use cases include four use cases, namely maximum value statistics, minimum value statistics, average value statistics, and record number statistics;

Figure 9 shows the UML class diagram of the automated construction software system process. The specific description is as follows:

The automated construction of the Web software system is implemented through underlying code classes. The underlying code classes mainly involve 5 classes and 4 interfaces. Among them, the 5 classes include: demand table reading class Read_Demand, user group management class Manage_Group, and user management class Manage_User. , model management class Manage_Schema, and data management class Manage_Data; 4 interfaces, including: user group management interface GManage_Group, user management interface GManage_User, model management interface GManage_Schema, and data management interface GManage_Data;

The Web software system is automatically constructed through the underlying code class, which specifically includes the following steps:

(1) Read the system administrator section in the software system demand table through the API used to process system administrator information in the demand table reading class Read_Demand, traverse its cells, and based on the system administrator ID, system administrator password and The system name registers the software system under the super administrator authority of the Web software framework, and creates the corresponding database entity of the software system in the underlying database of the Web software framework. At the same time, four Collections are created under the database, namely user group group, User user, model schema, data data; wherein the super administrator is the highest authority administrator of the Web software framework, used to receive the administrator information set by the user and register the software system in the Web framework; the Web software framework The underlying database is used by the Web software framework to store data;

(2) Read the user group information in the software system demand table through the API used to process user group information in the demand table reading class Read_Demand, traverse the filled in user group ID information cells, and based on the obtained user group ID information Generate a string in Json format and insert it into the user group collection of the database entity created in step (1);

(3) Read the user information in the software system demand table through the API used to process user information in the demand table reading class Read_Demand, traverse the user information filled in, read row by row and traverse the cells of each row, according to All the user information obtained is generated as a string in Json format and inserted into the user collection of the database entity created in step (1);

(4) Read the model information of the system demand table through the API used to process model information in the demand table reading class Read_Demand, traverse the filled model information cells, generate a Json format string based on the model information, and convert it Insert into the model schema collection of the database entity created in step (1);

(5) Operate the user group data in the user group group collection of the database entity in the underlying database through the user group management class Manage_Group, and return the operation results to the system display interface of the Web software framework. The user group management class Manage_Group Implement the user group management interface GManage_Group defined in the Web software framework;

(6) Operate the user data in the user collection of the database entity in the underlying database through the user management class Manage_User, and return the operation results to the system display interface of the Web software framework;

(7) Operate the model data in the schema collection of the database entities in the underlying database through the model management class Manage_Schema, and return the results to the interface of the Web software framework. The model management class Manage_Schema implements the model defined in the Web software framework. Management interface GManage_Schema;

(8) Operate the data records in the data collection of the database entity in the underlying database through the data management class Manage_Data, and return the results to the system display interface of the Web software framework. The data management class Manage_Data implements the Defined data management interface GManage_Data.

Figure 10 is an activity diagram of a Web software system application example constructed using the automatic software construction method of the present invention. The specific description is as follows:

1) The user fills in the software system requirement form and uploads it to the Web software framework;

2) The Web software framework obtains the system requirement table uploaded by the user and determines whether the format of the system requirement table uploaded by the user is correct. If the format is correct, it enters the activity of reading the system requirement table. Otherwise, it prompts the user that the format of the system requirement table is incorrect and asks the user to read it again. Upload.

3) The Web software framework reads the system administrator’s user name, password, system title and other information used to create the system, and the super administrator registers the system in the Web software framework.

4) Enter the judgment. If there is user group related information, enter the activity of reading the user group related information and create the user group, and then enter the activity of judging whether the user group related information exists. If there is no user group related information, the user group will not be created. , enter the activity of determining whether user-related information exists.

5) Enter the judgment. If there is user-related information, enter the activity of reading the user-related information and create the user, and then enter the activity of judging whether there is model-related information. If there is no user group-related information, the user will not be created, and enter the judgment whether Activities for which model-related information exists.

6) Enter the judgment. If there is model-related information, enter the activity of reading the number of models in the system requirement table and record the current number as 0, then enter the activity of reading the model-related information and create the model, and then enter the activity of judging whether there is a model in the The activity of field related information. If there is no user group related information, the model will not be created and the activity of generating the target system will be entered.

7) Enter judgment. If there is information related to fields in the model, enter the activity of reading field related information in the model and create fields in the model. Then enter the activity of adding the current model count by 1, and then enter the activity of judging whether the current model count is less than the number of models. If there is no field-related information in the model, it will directly enter the activity of determining whether the current model count is less than the number of models.

8) Enter judgment. If the current model count is less than the number of models, enter the activity of reading model-related information and create models. If the current model count is not less than the number of models, enter the activity of generating the target Web software system.

Figure 11 is a state diagram of a Web software system application example constructed using the automatic software construction method of the present invention. The specific description is as follows:

1) When the user uploads the system requirement table to the Web software framework, it enters judgment. If the format verification is correct, it enters the system requirement table format correct state. Otherwise, the state terminates and the system cannot be created.

2) If the system requirement table format is entered into the correct state, the super system administrator of the Web software framework registers the system in the Web software framework based on the system requirement information in the requirement table, and enters the registration system success state.

3) Entering the judgment, the Web software framework judges whether user group information exists in the system requirement table. If it exists, the user group is created and the user group creation success state is entered; if it does not exist, the user group is not created and the user group is not created.

4) Entering the judgment, the Web software framework judges whether user information exists in the system requirement table. If it exists, the user is created and the user creation success state is entered; if it does not exist, the user is not created and the user is not created.

5) Entering the judgment, the Web software framework judges whether model information exists in the system requirement table. If it exists, the model is created and the model creation success state is entered; if it does not exist, the model is not created and the model is not created.

6) If the model is not created in 5), the state will be terminated and the system will be created successfully. Otherwise jump to 7)

7) Entering the judgment, the Web software framework judges whether there are model fields and other information in the system requirements table. If it exists, create model fields, etc., and enter the model field creation success state; if it does not exist, do not create the model field, and enter the model field not created state.

8) The status is terminated and the system is created successfully.

Example 2

As shown in Figure 12, a software automatic construction system of a table-driven cloud model software automatic construction method includes a client, a data acquisition module, a data analysis module, a software construction module, a software injection module, and a Web server; the client The terminal is used for users to fill in the software system requirement form and submit it to the data acquisition module. The data acquisition module traverses the software system requirement form through the data acquisition server, classifies and reads the information recorded in the software system requirement form, and then reads the classified information The obtained software system requirement information is transmitted to the data analysis module; the data analysis module performs format analysis and verification on the obtained software system requirement information through the data analysis server. If the format verification is incorrect, the user is reminded to refill it. Software system requirements table, if the format verification is correct, then the software system requirement information with correct format verification is transmitted to the software construction module; the software construction module verifies the correct software system requirement information according to the format, and passes The software construction server automatically constructs a Web software system that matches the information, and then transmits the Web software system to the software injection module; the software injection module injects the Web software system into the Web software framework through the software injection server, and The Web software framework deploys the Web software system on the Web server for users to access and use; the Web software framework is an application used to automatically construct software and deploy it on the Web server, with a system display interface.

In this embodiment 2, the client, data acquisition server, data analysis server, software construction server, software injection server, and Web server are all PC computers, and HTTP communication is used between the client and the Web server. , the communication protocol adopts TCP protocol; other servers adopt Socket communication method, and the communication protocol adopts TCP protocol.

The above-mentioned embodiments only express several implementation modes of the present invention, and their descriptions are relatively specific and detailed, but they should not be construed as limiting the patent scope of the present invention. It should be noted that, for those of ordinary skill in the art, several modifications and improvements can be made without departing from the concept of the present invention, and these all belong to the protection scope of the present invention. Therefore, the protection scope of the patent of the present invention should be subject to the claims.

Claims (10)

1. The automatic construction method of the cloud mode software driven by the table is characterized by comprising the following steps of:

s1, filling in software system demand information according to a form format provided or agreed by a Web software framework by a user, and generating a software system demand form; then submitting the filled software system requirement list to a Web software framework on line or off line; the software system requirement information includes: system administrator information, user group information, user information, and model information; the Web software framework is an application deployed on a Web server;

S2, the Web software framework receives a storage path of the software system demand table appointed by a user through a data acquisition server, acquires the software system demand table according to the storage path, traverses the acquired software system demand table, reads various information recorded in the software system demand table, and transmits the read various software system demand information to a data analysis server;

s3, the Web software framework checks the data type and the format of each item of software system demand information in the software system demand table through the data analysis server, and judges whether the format filling requirement of the software system demand table is met or not; if the verification is not passed, prompting the user that the format of the software system needs to be uploaded again by mistake, namely repeating the step S1, the step S2 and the current step; if the verification is passed, performing the next operation;

s4, the Web software framework constructs a Web software system according to each item of information of the checked software system demand table, and the Web software system is injected into a cloud environment where the Web software framework is located, and then the constructed Web software system is used;

the step S4 specifically comprises the following steps:

s41, designing a bottom code class of the Web software framework, wherein the bottom code class is used for realizing automatic construction of a Web software system in the Web software framework;

S42, automatically constructing a Web software system by the Web software framework through the bottom code class, wherein the external activity process is as follows: the Web software framework establishes a software system according to the manager information registration of the software system demand table passing the verification, then judges whether the user group information, the user information and the model information exist in the software system demand table in sequence, if so, the Web software framework reads the information correspondingly existing in the software system demand table and generates a user group, a user, a model or a model field in the established software system; for the situation that a plurality of models exist in the software system demand table, the Web software framework repeatedly reads the model information until all the models are read, and a final Web software system is generated;

s43, injecting the Web software system obtained in the step S42 into a Web software framework through a software injection server, and automatically deploying and releasing the Web software framework in a cloud for a user to access;

s44, when the user is to inject data into the created Web software system in batches, the user fills in a data record exchange table, wherein the data record exchange table comprises model field information and data record information, and then the data record exchange table is submitted to a Web software framework, the Web software framework reads the information of the data record exchange table, then carries out format verification on the read information, reads the model field information in the data record exchange table passing the verification, determines a model to be subjected to data exchange according to the model field information, and then injects the data record information into the model, thus completing the data injection operation.

2. The method for automatically constructing table-driven cloud-mode software according to claim 1, wherein in step S1, the software system requirement information includes: system administrator information, user group information, user information, and model information, specifically as follows:

the system administrator information includes: system administrator ID, system administrator password, and system title;

the user group information is user group ID, and a plurality of user groups can be defined according to requirements;

the user information includes: user ID, user name, user password, and user belonging group ID;

the model information can customize a plurality of models according to requirements, and the included information specifically comprises: user read-write permission, other user read-write permission, model name, model entry member ID, belonging group ID, model field type, model field name, whether field value allows null, default value, and alternative value in the group to which the user belongs; the user read-write permission and the user read-write permission in the group to which the user belongs comprise: readable and writable, readable and non-writable, and non-readable and non-writable; the model entry member ID is contained in the user ID in the user information; the group ID is contained in the user group ID in the user group; the model field type, its value includes: text, float, integer, link, date, datetime and Boolean; whether the field value is allowed to be empty or not, the value of the field value comprises: TRUE, FALSE, where TRUE indicates allowed to be null and FALSE indicates not allowed to be null;

The submitting mode of the software system demand list comprises the following steps: online submitting and offline submitting; the online submission: the user fills in the software system demand information on line according to the Web form format provided by the Web software framework and submits the information to the Web software framework; the offline submission: and the user fills in the software system demand information offline according to the offline form format template agreed by the Web software framework and submits the software system demand information to the Web software framework in a file uploading mode.

3. The method for automatically constructing table-driven cloud-mode software according to claim 1, wherein in step S1, the Web software framework is an application deployed on a Web server with a system display interface; the system display interface includes: a system administrator interface and a user interface;

the system administrator interface comprises user management, user group management and model management; the user management is used for managing the user information of the Web software system to be created, and the management functions comprise adding users, deleting users, adding user group information for the users and deleting user group information for the users; the user group management is used for managing the user group information of the Web software system to be created, and the management functions comprise adding the user group, deleting the user group, adding the user information for the user group and deleting the user information for the user group; the model management is used for managing model information of a Web software system to be created, and the management functions comprise adding model information, deleting model information, adding model field information, deleting model field information, modifying model field information and distributing different access rights to different user groups aiming at the model;

The user interface comprises data management, data statistics, import and export Excel tables and other format tables, and advanced searching; the data management is used for managing records of a Web software system data table to be created, and the management functions comprise adding data records, deleting data records, modifying data records and acquiring all data records; the data statistics is used for counting the data table records of the Web software system to be created, and the statistics function comprises record number statistics, maximum value statistics, minimum value statistics and average value statistics aiming at the data table integer field; the importing and exporting Excel table and other format table are used for importing data in the Excel table and other format table into corresponding tables of the created Web software system, and exporting data in the tables of the Web software system into the Excel table and other format table; the advanced search is used for carrying out multiple logic combination searches on multiple fields of an Excel table and other format tables, and inquiring record information meeting search conditions.

4. The method according to claim 1, wherein in step S2, the Web software framework automatically reads each item of system requirement information in the software system requirement table, and the automatic reading unit includes a software system requirement table traversing unit, a system administrator information reading unit, a user group information reading unit, a user information reading unit, and a model information reading unit;

The software system demand table traversing unit is used for traversing the software system demand table;

the system manager information reading unit is used for reading the ID of the system manager, the password of the system manager and the system title when traversing the system manager information;

the user group information reading unit is used for reading user group ID information when traversing the user group information;

the user information reading unit is used for reading a user ID, a user name, a user password and a user belonging group ID when traversing the user information, wherein the user belonging group ID is a user group ID contained in the user group information;

the model information reading unit is used for reading user read-write permission, other user read-write permission, model name, model entry member ID, user belonging group ID, field type, field name, whether field value is allowed to be null, default value and alternative value in the group of the user when traversing the model information.

5. The method for automatically constructing the cloud model software driven by the table according to claim 1, wherein in step S3, the Web software framework performs data type and format verification on each item of software system requirement information in the software system requirement table, specifically, whether the values of the user read-write authority, the other user read-write authority, the model field type and the field value allowed to be empty in the group of the user in the model information meet filling requirements; if the group item to which the user belongs is not empty, judging whether the filled value of the item contains the user group information in the software system requirement table.

6. The automatic construction method of table-driven cloud-mode software according to claim 1, wherein in step S41, the Web software framework automatically constructs the Web software system through an underlying code class, the underlying code class involving 5 classes, 4 interfaces, wherein the 5 classes include: the method comprises the steps of a Demand table reading class read_demand, a User Group management class management_group, a User management class management_user, a model management class management_schema and a Data management class management_data; 4 interfaces, comprising: a User Group management interface GMage_group, a User management interface GMage_user, a model management interface GMage_schema, and a Data management interface GMage_data; automatically constructing a Web software system through the bottom code class, and specifically comprising the following steps:

(1) Reading a system administrator plate in a software system Demand table through an API (application program interface) for processing system administrator information in a Demand table read_demand, traversing unit grids of the system administrator plate, registering a software system under the super administrator authority of a Web software framework according to a system administrator ID, a system administrator password and a system name, creating a corresponding database entity of the software system in a bottom database of the Web software framework, and simultaneously creating 4 collections under the database, wherein the Collection is respectively a user group, a user, a model schema and data; the super manager is the highest authority manager of the Web software framework, and is used for receiving the manager information set by the user and registering the software system in the Web framework; the bottom database of the Web software framework is used for storing data by the Web software framework;

(2) Reading user group information in a software system Demand table through an API (application program interface) for processing the user group information in the Demand table reading type read_demand, traversing filled user group ID information cells, generating a character string in a Json format according to the obtained user group ID information, and inserting the character string into a user group set of a database entity created in the step (1);

(3) Reading user information in a software system Demand table through an API (application program interface) for processing the user information in the Demand table reading type read_demand, traversing the filled user information, reading and traversing the cells of each row according to the rows, generating a Json format character string according to all the obtained user information, and inserting the Json format character string into a user set of a database entity created in the step (1);

(4) Reading model information of a system Demand table through an API (application program interface) for processing model information in a Demand table reading class read_demand, traversing model information cells filled in the model information cells, generating a character string in a Json format according to the model information, and inserting the character string into a model schema set of a database entity created in the step (1);

(5) Operating user Group data in a user Group set of a database entity in a bottom database through a user Group management class management_group, and returning an operation result to a system display interface of a Web software framework, wherein the user Group management class management_group realizes a user Group management interface GMage_group defined in the Web software framework;

(6) Operating the User data in the User set of the database entity in the bottom database through the User management class management_user, and returning an operation result to a system display interface of the Web software framework;

(7) Operating model data in a Schema set of database entities in a bottom database through a model management class Manage_schema, and returning a result to an interface of a Web software framework, wherein the model management class Manage_schema realizes a model management interface GMage_schema defined in the Web software framework;

(8) And operating the Data records in the Data set of the database entity in the bottom database through a Data management class Manage_Data, and returning the result to a system display interface of the Web software framework, wherein the Data management class Manage_Data realizes a Data management interface GMage_Data defined in the Web software framework.

7. The automatic construction method of table-driven cloud-mode software according to claim 1, wherein in step S42, the Web software framework automatically constructs a Web software system through underlying code class, and the specific process of its external activity is as follows:

s421, the Web software framework reads the manager information in the software system demand table passing verification, wherein the manager information comprises a system manager user name, a system manager password and information for creating a software system name; registering and creating a software system according to the read manager information;

S422, the Web software framework judges whether user group information exists in the software system demand table, if the user group information exists in the software system demand table, the user group information is a user group ID, and a user group is generated in the software system created in the step S421 according to the read user group ID; if the user group information does not exist in the software system demand table, performing the next operation;

s423, the Web software framework judges whether user information exists in the software system demand table, if the user information does not exist in the software system demand table, the user information comprises a user ID, a user name, a user password and a group to which the user belongs, and a user is generated in the software system created in the step S421 according to the read user information; if the user information exists in the software system demand table, performing the next operation;

s424, the Web software framework judges whether model information exists in the software system demand table, if the model information exists in the software system demand table, the number of models in the software system demand table is read, the current count value is assigned to be 0, then the model information, namely the model name, the model entry member, the belonging group ID and the user read-write authority information in the group to which the user belongs, is read, and a designated model is created in the software system created in the step S421 according to the read model information; then judging whether structural information exists in the model, if so, reading the structural information in the model, namely whether the field name, the field type and the field value of the structural information in the model are allowed to be null, a default value and an alternative value, creating a field in the created appointed model according to the read structural information in the model, meanwhile, judging whether the current count is smaller than the number of the models or not by the count value +1 of the current model, if so, continuing to read the next model information, and repeating the operation of the step; if the current count is greater than the number of models, the Web software framework completes self-construction of the software system, and the Web software system is generated.

8. The method for automatically constructing table-driven cloud-mode software according to claim 1, wherein in step S44, the model field information is all field names of a model to be subjected to data record exchange set by a user according to a need; the data records are all data record information which is needed to be injected into the model by a user according to the requirement;

the submitting mode of the data exchange record table comprises the following steps: online submitting and offline submitting; the online submission: when a user enters a Web software system constructed according to a Web software framework through data provided by the Web software system, entering information in a data exchange record table on line and submitting the information to the Web software system; the offline submission: when a user constructs a Web software system according to a Web software generation frame, the model field information and the data record information are input offline through a data record exchange table template format provided by the Web software system and submitted to the Web software system in a file uploading mode.

9. A software automatic construction system using the table-driven cloud mode software automatic construction method according to any one of claims 1 to 8, characterized by comprising a client, a data acquisition module, a data analysis module, a software construction module, a software injection module, and a Web server; the client is used for filling in a software system demand table by a user and submitting the software system demand table to the data acquisition module, the data acquisition module traverses the software system demand table through the data acquisition server, carries out classified reading on information recorded in the software system demand table, and then transmits all software system demand information after classified reading to the data analysis module; the data analysis module performs format analysis and verification on the acquired various software system demand information through the data analysis server, if the format verification is wrong, a user is reminded to refill a software system demand table, and if the format verification is correct, various software system demand information with the correct format verification is transmitted to the software construction module; the software construction module verifies correct software system demand information according to the format, automatically constructs a Web software system matched with the information through a software construction server, and then transmits the Web software system to the software injection module; the software injection module injects the Web software system into a Web software framework through a software injection server, and deploys the Web software system on the Web server through the Web software framework for users to access; the Web software framework is an application for automatically constructing software and deployed on a Web server with a system display interface.

10. The automatic construction system of table-driven cloud-mode software according to claim 9, wherein the client, the data acquisition server, the data analysis server, the software construction server, the software injection server and the Web server are all PC computers, http communication is adopted between the client and the Web server, and TCP is adopted as the communication protocol; socket communication mode is adopted among other servers, and TCP protocol is adopted as communication protocol.