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

Here you can find the source of 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)