使用正则表达式验证 mysql 语句 [英] Using regular expressions for validating mysql statements

问题描述

我正在用 Java 编写程序.在对话框中，用户需要输入 MySQL SELECT 语句.程序必须验证语句并继续运行.我的问题是:有没有办法以及如何使用正则表达式验证语句.我需要仅"正则表达式模式.谢谢.

I am writing a program in java. In a dialog a user need to input MySQL SELECT statement. Program must to validate the statement an continue to run. My question is: Is there a way and how to validate the statement with regular expressions. I need "only" regular expression pattern. Thanks.

推荐答案

嗯，也许是为了扩展正则表达式，但是对于代表正则表达式"的regex"的本义，对于常规语言" - 否.

Well, maybe for extended regex, but for the original meaning of "regex" that stands for "Regular Expression", for "Regular Language" - no.

每个 SELECT 语句是:

Each SELECT statement is:

SELECT x FROM y WHERE z

然而，由于y本身可以是一个SELECT语句，这至少和不规则的平衡括号语言一样难.

However, since y itself can be a SELECT statement, this is at least as hard as the language of balanced parenthesis, which is irregular.

这篇关于使用正则表达式验证 mysql 语句的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！