如何验证sql查询语法？ [英] How to validate sql query syntax?

问题描述

java 1.4
Sql server 2000

java 1.4 Sql server 2000

我正在从管理员那里输入sql查询（对于通过执行sql查询检索的值来验证字段值）将存储在数据库中的用户以后我将执行对应于field的sql查询。在数据库中插入sql查询之前，我想在java代码中验证其语法。

i am taking input of sql query (for validation of field value against values retrieved by executing sql query) from admin user which will be stored in database and later i will executing sql query corresponding to field.Before inserting sql query in database i want to validate its syntax in java code.

Fields         Sql Query

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

推荐答案

不要认为有任何（简单）方法验证sql

dont think there is any (easy) way to validate sql

Sql语法很复杂，允许多种不同的方式输入语句。

Sql syntax is complex and allows for alot of different ways to enter a statement.

认为你最好的方法是执行sql statent，如果你有一个SQl异常，看看它是否是一个导致它的错误语法。

Think you best shot would be to just execute the sql statent and if you have a SQl exception see if its a bad syntax thats causing it.

你可以预先添加一些sql来避免实际上在sybase中执行查询

you can prepend some sql to avoid from actually executing the query

它将是
SET NOEXEC ON

in sybase it would be SET NOEXEC ON

这篇关于如何验证sql查询语法？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！