java script的验证输入,验证用户使用Java Script输入的SQL Query

I have a textarea in my jsp, where in the user will enter a sql query of select or insert or update or delete.I have to validate that entered data and say whether the query is syntatically correct or not.For Example if User enters,

Select * from Tab..:

like this, it has to throw an alert message saying that, sql query is invalid as the user entered ..: at the end of the query.

I have to do this in javascript.

Can any one help me out?

Thanks&Regards

Anuradha

解决方案

Since you have to do this in JavaScript, it is not a Java problem, now is it? On the other hand, what if the user turns off scripting in their browser?

This is not a trivial task! You will have to parse the input and check for mis-spellings, syntax errors and lots more. Perhaps you should make a few basic checks instead.

what if the user turns off scripting in their browser?

You can make checks on the client-side as a backup (and it saves a trip to the server just to be met with an error message). The real checking should always be made on the server-side, of course.