Java Wildcard wildcardCriterionSQL(final String query)

Description

Replaces the query with the wildcards asterisk "*" and interrogation mark "?"

License

Apache License

Parameter

Parameter	Description
query	The String to replace the wildcards.

Return

The String with the new wildcards from SQL "%" and "_".

Declaration

public static String wildcardCriterionSQL(final String query) 

Method Source Code

//package com.java2s;
/**/*  w  w  w  . jav a 2 s.  c o m*/
 * Copyright (C) 2007 Asterios Raptis
 *
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *         http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */

public class Main {
    /**
     * Replaces the query with the wildcards asterisk "*" and interrogation mark "?" with the
     * corresponding wildcard from SQL.
     * 
     * @param query
     *            The String to replace the wildcards.
     * @return The String with the new wildcards from SQL "%" and "_".
     */
    public static String wildcardCriterionSQL(final String query) {

        String newQuery = query.replace('*', '%').replace('?', '_');
        return newQuery;
    }
}

Related

1. wildCard(final String _name)
2. wildCard(String _name)
3. wildCardBoth(String s)
4. wildcardCompare(String s, String z)
5. wildcardIfEmpty(String inString)
6. wildcardOrIsNullIfEmpty(String column, String inString)
7. wildcardSearchToRegex(final String wildcard)
8. wildcardSqlToUser(String exp)