Escapes all necessary characters in the String so that it can be used in SQL

       

/**
 * $Revision: 10205 $
 * $Date: 2008-04-11 15:48:27 -0700 (Fri, 11 Apr 2008) $
 *
 * Copyright (C) 2004-2008 Jive Software. All rights reserved.
 *
 * This software is published under the terms of the GNU Public License (GPL),
 * a copy of which is included in this distribution, or a commercial license
 * agreement with Jive.
 */

import java.io.UnsupportedEncodingException;
import java.security.MessageDigest;
import java.security.NoSuchAlgorithmException;
import java.text.BreakIterator;
import java.util.*;
import java.util.concurrent.ConcurrentHashMap;

/**
 * Utility class to peform common String manipulation algorithms.
 */
public class StringUtils {

    // Constants used by escapeHTMLTags
    private static final char[] QUOTE_ENCODE = "&quot;".toCharArray();
    private static final char[] AMP_ENCODE = "&amp;".toCharArray();
    private static final char[] LT_ENCODE = "&lt;".toCharArray();
    private static final char[] GT_ENCODE = "&gt;".toCharArray();

    private StringUtils() {
        // Not instantiable.
    }

    /**
     * Escapes all necessary characters in the String so that it can be used in SQL
     *
     * @param string the string to escape.
     * @return the string with appropriate characters escaped.
     */
    public static String escapeForSQL(String string) {
        if (string == null) {
            return null;
        }
        else if (string.length() == 0) {
            return string;
        }

        char ch;
        char[] input = string.toCharArray();
        int i = 0;
        int last = 0;
        int len = input.length;
        StringBuilder out = null;
        for (; i < len; i++) {
            ch = input[i];

            if (ch == '\'') {
                if (out == null) {
                     out = new StringBuilder(len + 2);
                }
                if (i > last) {
                    out.append(input, last, i - last);
                }
                last = i + 1;
                out.append('\'').append('\'');
            }
        }

        if (out == null) {
            return string;
        }
        else if (i > last) {
            out.append(input, last, i - last);
        }

        return out.toString();
    }

}

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 an XML doc
32.	Adds zeros to the beginning of a value so that the total length matches the given precision, otherwise trims the right digits.
33.	Right justify string, ensuring that the string ends at the last character
34.	Makes the first letter caps and the rest lowercase.
35.	Quote a string so that it can be used as an identifier or a string literal in SQL statements.
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

Escapes all necessary characters in the String so that it can be used in SQL : String format « Data Type « Java

Related examples in the same category