Automatic Code Generation

Recently, I have been developing web applications and found that many jobs are repetitive. Here, the repetition is "similar" rather than "same". If it is the same, obviously, we will use componentized modular form to improve software reusability. however, we are not very good at Modular Design for similar jobs. in addition, the strength of computer is to do repetitive and regular work. Why don't we use it to free ourselves? So I am going to make a special topic in the blog and pay attention to the Automatic code generation technology.

The following lists some excellent existing generation tools.

Arcstyler (Tier Generator for full web application)

C # data tier generator (Code Munger for database)

Codesmith (Tier Generator for any code)

Codify (Mixed-Code Generator for any code)

Compilex (Tier Generator for full web application)

Constructor () (Tier Generator for full web application)

Data tier modeler (Tier Generator for database)

Dbhelper (Code Munger for database)

Dbmethods (Tier Generator for database)

Deklarit (Tier Generator for database)

Doxygen (Code Munger for Documentation)

Expert coder (partial class Generator for any code)

GSL (Tier Generator for any code)

Iqgen (Tier Generator for any code)

Iron speed designer (Tier Generator for full web application)

Ironworks (Tier Generator for full web application)

Juggernet (Tier Generator for database)

Lattice. spgen (Tier Generator for database)

Llblgen (Code Munger for database)

Mia-generation (Tier Generator for any code)

Monstarillo (Tier Generator for database)

Mygeneration (Tier Generator for database)

Ncodegen (Tier Generator for any code)

Ndevelopment (Tier Generator for database)

Ntiergen. Net code generator (Tier Generator for full web application)

Nvelocity (Tier Generator for any code)

Object Model generator (Tier Generator for other)

Olympus (Tier Generator for full web application)

Builds C # and ASP. NET applications using a tier generator model.

Persistence (r) plug-ins for eclipse (Tier Generator for database)

Pragmatier (Tier Generator for database)

Quickadmin (Tier Generator for database)

Raptier (Tier Generator for database)

Smartgenerator (Tier Generator for any code)

Sopromach (Tier Generator for any code)

Tangible generator ECT (Tier Generator for business logic)

Tcdesigner standard (Tier Generator for database)

Vbexpress. Net (Tier Generator for full web application)

Visible developer (Tier Generator for full web application)

Warp. Net developer Studio (Tier Generator for database)

X-code. Net (Tier Generator for any code)

Xcoder (Tier Generator for full web application)

Currently, Orm is widely used. it solves the problem of ing between the database and the object (entity), but it still needs to solve the problem of ing between the object and the UI interface. if dB --> entity --> UI can be synchronously associated. our workload will be much reduced. some of the above tools can generate the entire project according to the DB. it is estimated that in a few years, it will be a storm of laid-off in the IT industry.

A storage process Automatic Generator (sp_gen) was written a few days ago. Coincidentally, when tcdesigner was used to generate multiple n. SQL script. when I thought that SQL Server 2000 was used to query analyzer, I could select multiple executions at a time. The results were disappointing and there was no batch execution function. therefore, the automatic generator of the stored procedure is added with the SQL script batch execution function.

What can the Automatic Storage Process Generator (sp_gen) do?

1. You can select fields as needed.

2. Select Code can be generated (all or filtered based on the primary key)

3. insert code can be generated.

4. Update code can be generated.

5. The Delete Code can be generated.

6. You can import SQL scripts to SQL Server in batches.

The software is as follows:

Due to time constraints, the software interface is relatively crude and its functions are relatively thin.

But in normal times, it does increase productivity.

In the future, sp_gen may be improved in the following aspects:

1. Multi-Table Association is supported.

2. Simplify SQL operations. avoid hitting SQL code unless it is logical.

3 ....

Some Ideas about Automatic Generation of software code

1. Generate a database table based on the database design model. This step is provided by most data modeling tools (such as PD.

2. Generate entity classes based on database tables. Entity classes here are mainly used as parameters for passing and saving related beliefs.

3. Use the Stored Procedure generator to generate the stored procedure.

4. generate an intermediate layer similar to sqlhelp to interact with the stored procedure.

5. Generate the logic layer. query, modify, add, delete, and other operations are supported.

6. It may be better to Use ORM in the above steps, but the flexibility and efficiency of ORM should be considered, especially in multi-table queries.

7. Generate a web interface based on Step 2 and the object class. You need to place the interface control without coding, that is, the ing between the control value and the object.

8 ....

 

Appendix: Stored Procedure Automatic Generator (

Spgen

)