Design And Application Of Automate The Generation Of Stored Procedures Of Customization Based On J2EE

With the advancement of social and the development of science, it has become a trend and cognition in most people's mind that machine would replace worker and computer would replace brain. So, it becomes a dream of human being that automation in any domain and people is working hard for the dream all through. Nowadays, the automation of many domains has realized. Such as OA, Management Automation, Production Automation, Service Automation etc. At the same time, however, human also begin to think the Code Automation. In the domain of Database, we write SQL and PL/SQL with handwork. But the disadvantages of it are inefficient and mistakable. For avoid them, automate the generation of SQL and PL/SQL is becoming urgently.As mentioned above, this paper describes the theory of code generation and actuality and lacks of tools of PL/SQL generation in existence. It also analyses the SQL syntax and PL/SQL structure and combines requires of PL/SQL in 1104 system. Based on that mentioned above, I design and implement a tool of Automate the Generation of Stored Procedures of Customization—My PL/SQL Coder. This paper describes the application of the tool in 1104 system too.Finally, it gained a success in the Application of 1104 system.