Java正则表达式：多场景查询的可选捕获组优化需求

需求场景 #

需匹配三种格式的查询语句：

• 基础查询：query: select * from People
• 带exclude选项的查询：query: select * from People exclude addresses
• 带include选项的查询：query: select * from People include department

现有正则的问题 #

• regex1：query[:\/]?(.*)((exclude|include)(.*))?
  可匹配所有三种场景，但无法正确捕获exclude addresses、include department这类分组内容，且不想通过额外字符串截取操作提取该内容。
• regex2：query[:\/]?(.*)((exclude|include)(.*))
  仅能匹配带exclude/include选项的查询，无法匹配基础查询，但可正确捕获主查询与包含/排除选项分组。

优化后的正则与实现代码 #

优化后的正则表达式可同时匹配所有场景，且通过捕获组明确区分是否带选项：

^query[:\\/]?\\s*(.*?)(?:\\s+(exclude|include)\\s+(.*))?$

对应的Java实现代码：

import java.util.regex.*;
public class QueryParser {
    public static void main(String[] args) {
        String[] tests = {
            "query:select * from People",
            "query: select * from People exclude addresses",
            "query/select * from People include department",
            "query select * from People",
            "non matching query"
        };

        String regex = "^query[:\\/]?\\s*(.*?)(?:\\s+(exclude|include)\\s+(.*))?$";
        Pattern pattern = Pattern.compile(regex, Pattern.CASE_INSENSITIVE);

        for (String test : tests) {
            Matcher matcher = pattern.matcher(test);
            if (matcher.matches()) {
                System.out.println("完整匹配内容: " + matcher.group(0));
                System.out.println("主查询语句: " + matcher.group(1));
                System.out.println("排除/包含关键字: " + matcher.group(2));
                System.out.println("排除/包含参数: " + matcher.group(3));
                System.out.println("---");
            } else {
                System.out.println("无匹配: " + test);
            }
        }
    }
}

正则逻辑说明 #

• ^query[:\\/]?\\s*：匹配开头的query标识，允许后跟:或/，忽略后续空白字符
• (.*?)：非贪婪匹配主查询内容，避免过度匹配到后面的exclude/include部分
• (?:\\s+(exclude|include)\\s+(.*))?$：可选的非捕获组，匹配exclude/include关键字及对应的参数；$确保匹配到字符串结尾，避免部分匹配

内容的提问来源于stack exchange，提问作者DayaMoon