Relational database based generation method of J2EE code

[0026] The J2EE code generation method based on relational database of the present invention is characterized in that it comprises the following steps:

[0027] The first step is to set the target code template definition steps:

[0028] According to the existing framework, the unchanging code is defined as a template, and the variable code is defined as a macro;

[0029] That is: First, the J2EE architect designs the logical architecture for the entire project, configures the target code template according to the requirements of the engineering design logical architecture, defines the variable part of the target code as a macro, and writes the unchanging part directly in the template.

[0030] The second step, external data acquisition steps:

[0031] Obtain relational database table structure parameters, database object annotation information, structured query commands, code generation configuration parameters, and operating system parameters;

[0032] Namely: the database engineer designs the database object structure, and adds notes to all tables and columns; after starting the application haivDb4J2ee, the application connects to the database according to the last successful connection configuration; or the user manually adds various database connections by inputting parameters; The application automatically reads the table space, database object name, and object comment of the database, and displays these contents in front of the user in the form of a two-dimensional table; the programmer can use this tool to easily edit the comment of the database object, or Enter the corresponding command in the SQL statement input area to complete the interaction with the database. The user opens a table and displays the column name, column type, column comment, and other attributes. The user enters a structured query command in the SQL statement input area or selects an object in the database object list to enter the J2EE generation wizard. The data in this step is all obtained from the database, and no additional input from the user is required.

[0033] The third step, logical operation steps:

[0034] From the acquired parameters, a macro related to the target code is obtained through logical operations;

[0035] Namely: Generate the default Java object default settings according to the structured query command input by the user or the database object structure, automatically split the module name and submodule name according to the table name, generate the java class name and configuration path that conform to the Hungarian nomenclature according to the table name, Generate each member variable name in the class according to the field name in the table, generate the member variable type according to the field type, generate the class comment according to the table comment, generate the member variable comment according to the column comment, generate the document comment according to the system time, and complete the goal according to the operating system login name Code signing; basically, this series of operations can be completed according to the default rules without user intervention. In the process of completing these tasks, the user can manually adjust the unreasonable points found, and the tool will follow the specified settings according to these settings Method to calculate the macro value required by the target code.

[0036] The fourth step, the code generation step: apply the macro to the code template to generate the target code of the MVC three-tier architecture;

[0037] That is: the user selects the template used by the target code; the system combines the macro generated in the previous step with the template to generate the target code; the user selects the path where the target code is saved, and outputs the target code to the specified path. The generated files include hibernate Configuration files, struts configuration files, spring configuration files, MVC three-tier Java classes, three-tier Java packages, JSP additions, deletions, and changes to check files, and at the same time output generated logs, file lists and instructions for use; after generating the target code, the programmer puts the files and files The folder and the entire java package are copied and pasted into the project to realize the addition, deletion, modification, and checking function of a table, and then the development of a module can be completed by modifying and perfecting the logic part.