Java Array Convert to arrayToSqlInList(String... values)

Description

Erzeugt aus einem String Array einen String, welcher dem SQL Operator 'IN' übergeben werden kann.

License

Open Source License

Parameter

Parameter	Description
values	a parameter

Declaration

public static String arrayToSqlInList(String... values) 

Method Source Code

//package com.java2s;
/*******************************************************************************
 * HELIUM V, Open Source ERP software for sustained success
 * at small and medium-sized enterprises.
 * Copyright (C) 2004 - 2014 HELIUM V IT-Solutions GmbH
 * /*www. j  a va2 s  .c  o  m*/
 * This program is free software: you can redistribute it and/or modify
 * it under the terms of the GNU Affero General Public License as published 
 * by the Free Software Foundation, either version 3 of theLicense, or 
 * (at your option) any later version.
 * 
 * According to sec. 7 of the GNU Affero General Public License, version 3, 
 * the terms of the AGPL are supplemented with the following terms:
 * 
 * "HELIUM V" and "HELIUM 5" are registered trademarks of 
 * HELIUM V IT-Solutions GmbH. The licensing of the program under the 
 * AGPL does not imply a trademark license. Therefore any rights, title and
 * interest in our trademarks remain entirely with us. If you want to propagate
 * modified versions of the Program under the name "HELIUM V" or "HELIUM 5",
 * you may only do so if you have a written permission by HELIUM V IT-Solutions 
 * GmbH (to acquire a permission please contact HELIUM V IT-Solutions
 * at trademark@heliumv.com).
 * 
 * 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 Affero General Public License for more details.
 * 
 * You should have received a copy of the GNU Affero General Public License
 * along with this program.  If not, see <http://www.gnu.org/licenses/>.
 * 
 * Contact: developers@heliumv.com
 ******************************************************************************/

public class Main {
    /**
     * Erzeugt aus einem String Array einen String, welcher dem SQL Operator 'IN'
     * &uuml;bergeben werden kann. <br><br>
     * Bsp.: values = ["Angelegt"]["Offen"]["Storniert"]
     * returns "('Angelegt','Offen','Storniert')" ohne die doppelten Anf&uuml;hrungszeichen.
     * @param values
     * @return
     */
    public static String arrayToSqlInList(String... values) {
        String s = "(";
        for (String cnr : values) {
            s += "'" + cnr + "',";
        }
        return s.substring(0, s.length() - 1) + ")";

    }
}

Related

1. arrayToLowercase(String[] array)
2. arrayToMatlabStringArray(double da[])
3. arrayToOneLineSpaceDelimitedString(Object obj[])
4. arrayToQueryString(String key, Object[] arr)
5. arrayToSeparatedString(final String[] strings, final String separator)
6. arrayToSv(String as[], String s)
7. arrayToSVMLightString(int[] array)
8. arrayToUpper(String[] values)
9. arrayWithoutFirstsElement(final String[] array, final int elementsToRemove)