Judge if the specified querying string contain GROUP BY statement - Java java.lang

Description

Judge if the specified querying string contain GROUP BY statement

Demo Code

//package com.java2s;
import java.util.regex.Matcher;
import java.util.regex.Pattern;

public class Main {
    public static void main(String[] argv) {
        String ql = "java2s.com group          by";
        System.out.println(containsGroupByStatement(ql));
    }//from w  w w  . j ava 2 s.c om

    /**
     * Judge if the specified querying string contain GROUP BY statement
     * 
     * @param ql
     */
    public static boolean containsGroupByStatement(String ql) {
        String regEx = "group[\\s]+by";
        Pattern p = Pattern.compile(regEx);
        Matcher m = p.matcher(ql.toLowerCase());
        return m.find();
    }
}

• Previous
• Next

Related Tutorials

• Checks if String contains a search String irrespective of case, handling null.
• Checks if the String contains only whitespace. null will return false.
• Checks if a String contains a valid numeric, in this definition either 1 or more digits or 0 or more digits, followed by a dot (.), followed by 1 or more digits.
• Return a string that contains a description of how to use a class that calls this method.
• Converts a CSV(comma-separated value) list into a vector, containing all values as strings.