How to check sql query syntax?

Question

java 1.4 Sql 2000 server

I take the input of the sql query (to check the value of the field against the values ​​obtained when executing the SQL query) from the administrator user, which will be stored in the database, and then I will execute the SQL query corresponding to the field. Before inserting a sql query into a database I want to check its syntax in Java code.

Fields         Sql Query

stateCode      select statecode from states
district code  select district code from districts

Answer 1

I don't think there is any (simple) way to check sql

Sql syntax is complex and allows you to use different ways to enter instructions.

, sql statent, SQl, , , .

sql,

SET NOEXEC ON

Answer 2

PreparedStatement ; , ( )

Answer 3

sql-?

.

, . .

Answer 4

, , , , . , .

Answer 5

SET FMTONLY ON, , . SET FMTONLY OFF finally, .

Answer 6

SQL-, ​​ SQL- .

, Java #:

http://www.dpriver.com/blog/list-of-demos-illustrate-how-to-use-general-sql-parser/vendor-specific-offline-sql-syntax-check/