Java String Quote quoteString(String source, char quote)

Here you can find the source of quoteString(String source, char quote)

Description

Quote a string so that it can be used as an identifier or a string literal in SQL statements.

License

Apache License

Parameter

Parameter Description
source the string to quote
quote the character to quote the string with (' or ")

Return

a string quoted with the specified quote character

Declaration

static String quoteString(String source, char quote) 

Method Source Code

//package com.java2s;
/*//from w  w w  .  j av a 2  s.c  o  m
 * #%L
 * ch-commons-util
 * %%
 * Copyright (C) 2012 Cloudhopper by Twitter
 * %%
 * 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.
 * #L%
 */

public class Main {
    /**
     * Quote a string so that it can be used as an identifier or a string
     * literal in SQL statements. Identifiers are surrounded by double quotes
     * and string literals are surrounded by single quotes. If the string
     * contains quote characters, they are escaped.
     *
     * @param source the string to quote
     * @param quote the character to quote the string with (' or ")
     * @return a string quoted with the specified quote character
     * @see #quoteStringLiteral(String)
     * @see IdUtil#normalToDelimited(String)
     */
    static String quoteString(String source, char quote) {
        // Normally, the quoted string is two characters longer than the source
        // string (because of start quote and end quote).
        StringBuffer quoted = new StringBuffer(source.length() + 2);
        quoted.append(quote);
        for (int i = 0; i < source.length(); i++) {
            char c = source.charAt(i);
            // if the character is a quote, escape it with an extra quote
            if (c == quote)
                quoted.append(quote);
            quoted.append(c);
        }
        quoted.append(quote);
        return quoted.toString();
    }
}

Related

  1. quoteString(String s)
  2. quoteString(String s)
  3. quoteString(String s)
  4. quoteString(String s)
  5. QuoteString(String source)
  6. quoteString(String src)
  7. quoteString(String str)
  8. quoteString(String string)
  9. quoteString(String strVal)