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

     
import java.io.IOException;
import java.io.InputStream;
import java.util.Enumeration;
import java.util.Properties;

/*

   Derby - Class org.apache.derby.iapi.util.PropertyUtil

   Licensed to the Apache Software Foundation (ASF) under one or more
   contributor license agreements.  See the NOTICE file distributed with
   this work for additional information regarding copyright ownership.
   The ASF licenses this file to you 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 {



  /**
   * 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 &quot;)
   * @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();
  }

  /**
   * Quote a string so that it can be used as a string literal in an
   * SQL statement.
   *
   * @param string the string to quote
   * @return the string surrounded by single quotes and with proper escaping
   * of any single quotes inside the string
   */
  public static String quoteStringLiteral(String string) {
      return quoteString(string, '\'');
  }

}

Related examples in the same category

1.	Fmt - format text (like Berkeley UNIX fmt)
2.	Demonstrate some usage patterns and format-code examples of the Formatter
3.	String.format(): right pad a string
4.	String.format(): left pad a string
5.	Format a String (JDK1.5)
6.	Pass value array to String.format()
7.	Format Calendar with String.format()
8.	Abbreviates a String using ellipses in both sides.
9.	Abbreviates a String using ellipses.
10.	Abbreviate string
11.	Word Wrap
12.	Centers a String in a larger String of size size using the space character (' ').
13.	Centers a String in a larger String of size size. Uses a supplied String as the value to pad the String with.
14.	Centers a String in a larger String of size size. Uses a supplied character as the value to pad the String with.
15.	Capitalize the first character of the given string
16.	Capitalize the first letter but leave the rest as they are.
17.	Capitalizes a String changing the first letter to title case as Character.toTitleCase(char). No other letters are changed.
18.	Format strings into table
19.	Center the contents of the string.
20.	Truncate the supplied string to be no more than the specified length.
21.	Replace, remove, format strings
22.	Adds spaces in suitable locations of the input string
23.	Blank string: empty or white space
24.	Capital and uncapital strings
25.	Capitalizes the first character of the given string
26.	Utilities for String formatting, manipulation, and queries
27.	Fast lower case conversion
28.	Format a percentage for presentation to the user
29.	Left justify the contents of the string, ensuring that the supplied string begins at the first character and that the resulting string is of the desired length.
30.	Transforms words to singular, plural, humanized (human readable), underscore, camel case, or ordinal form
31.	Escapes all necessary characters in the String so that it can be used in SQL
32.	Escapes all necessary characters in the String so that it can be used in an XML doc
33.	Adds zeros to the beginning of a value so that the total length matches the given precision, otherwise trims the right digits.
34.	Right justify string, ensuring that the string ends at the last character
35.	Makes the first letter caps and the rest lowercase.
36.	Remove the hyphens from the begining of str and return the new String.
37.	Swaps the case of a String changing upper and title case to lower case, and lower case to upper case.
38.	Uncapitalizes a String changing the first letter to title case as per Character.toLowerCase(char). No other letters are changed.
39.	Capitlize each word in a string (journal titles, etc)
40.	Uncapitalize String
41.	Utility inserts a space before every caps in a string
42.	convert String array To Comma Delimited
43.	Constructs a method name from element's bean name for a given prefix
44.	break Lines
45.	Limit the string to a certain number of characters, adding "..." if it was truncated
46.	Capicalizes the first letter of a string
47.	Add delimiters to a string.
48.	Get Truncated String
49.	Convert to $(Dollars) string
50.	Convert string to multiline
51.	Deletes all whitespace from a String.
52.	Trim string from left or right
53.	implode and explode string
54.	To Upper Case First Char
55.	Left trim and right trim
56.	capitalize and uncapitalize

Quote a string so that it can be used as an identifier or a string literal in SQL statements. : String format « Data Type « Java

Related examples in the same category