Design And Implement Of An Auxiliary System For Database Teaching Base On JavaEE

In the morden database system, among all the SQL statements, the query statementis the most frequently used one. Nomater in the business application or in a databaseteaching course’s experiment, SQL query statement play the same import role. Studyinghow to validate the SQL statements syntax means very much to the execution of SQLand how to optimize it.In this dissertation, we proposed and designed a WEB based SQL statement syntaxcorrectness validation test platform. It is an automatic test system of SQL query syntax.And the automatic test platform can reduce the error rates and artificial judgmentteacher revises the experiment teachers greatly improve efficiency， Which would helpthe teacher focus on introducing more advanced database technique into the test.Students then could learn much more meaningful database technique in return.This dissertation introduces the whole process of how this system developed. Itcovered background of this system, development environment, the demands ofimplement such a platform, the design and the implementation. The whole developmentprocess is a typical WEB system process with structs and spring framwork, whichwould be helpful for those who want to learn them.This WEB system will validate the corecctnes of the SQL query syntax, the coreidea is to validate it via excuting it. By which, we would abtain not only the correctnessand the error information but also the security of the SQL statement. And we can alsobenefit from this WEB system if we want to expand the functionality to much moreSQL statement syntax check like insert or delete etc.This system is based on MVC mode, the purpose is to achieve code V M andseparation, and thereby the same program can use different forms of expression. Model,view, controller, reduce their separation system, easy extension and coupling andsecondary development. Development is based on SSH framework.