Java String Quote quoted(String value, boolean addQuotes)

Description

Returns a string in quotes for use in a database query.

License

Open Source License

Parameter

Parameter	Description
value	value to be quoted
addQuotes	<code>true</code> if the returned string is to be enclosed in single quotes

Return

true if the user object was successfully deleted

Declaration

protected static String quoted(String value, boolean addQuotes) 

Method Source Code

//package com.java2s;
/*//  ww w.  ja  v a2  s.  c o m
 * LTIToolProvider - Classes to handle connections with an LTI 1 compliant tool consumer
 *     Copyright (C) 2013  Stephen P Vickers
 *
 *     This program is free software; you can redistribute it and/or modify
 *     it under the terms of the GNU Lesser General Public License as published by
 *     the Free Software Foundation; either version 3 of the License, or
 *     (at your option) any later version.
 *
 *     This program is distributed in the hope that it will be useful,
 *     but WITHOUT ANY WARRANTY; without even the implied warranty of
 *     MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 *     GNU Lesser General Public License for more details.
 *
 *     You should have received a copy of the GNU Lesser General Public License along
 *     with this program; if not, see <http://www.gnu.org/licences/>
 *
 *     Contact: stephen@spvsoftwareproducts.com
 */

public class Main {
    /**
     * Returns a string in quotes for use in a database query.
     * <p>
     * Any single quotes in the value passed will be replaced with two single quotes.  If a null value is passed, a string
     * of 'NULL' is returned (which will never be enclosed in quotes irrespective of the value of the $addQuotes parameter.
     *
     * @param value     value to be quoted
     * @param addQuotes <code>true</code> if the returned string is to be enclosed in single quotes
     * @return <code>true</code> if the user object was successfully deleted
     */
    protected static String quoted(String value, boolean addQuotes) {

        if (value == null) {
            value = "NULL";
        } else {
            value = value.replaceAll("'", "''");
            if (addQuotes) {
                value = "'" + value + "'";
            }
        }

        return value;

    }
}

Related

1. quoted(String s)
2. quoted(String str)
3. quoted(String text)
4. quoted(String val, boolean wrap)
5. quoted(String value)
6. quotedEscape(final String string)
7. quotedIndexOf(String text, int start, int limit, String setOfChars)
8. quotedJavaChar(char c, StringBuilder b)
9. quotedName(String name)