Java List Create createWhereInClause(String field, List values, boolean isString)

Description

create Where In Clause

License

Open Source License

Declaration

public static String createWhereInClause(String field, List<String> values, boolean isString) 

Method Source Code

//package com.java2s;
/*/*from   w ww. j a v a  2 s  .com*/
 * Cerberus  Copyright (C) 2013  vertigo17
 * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
 *
 * This file is part of Cerberus.
 *
 * Cerberus is free software: you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation, either version 3 of the License, or
 * (at your option) any later version.
 *
 * Cerberus 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 General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License
 * along with Cerberus.  If not, see <http://www.gnu.org/licenses/>.
 */

import java.util.List;

public class Main {
    public static String createWhereInClause(String field, List<String> values, boolean isString) {

        if (field == null || field.isEmpty() || values == null || values.isEmpty()) {
            return "";
        }

        StringBuilder stringBuilder = new StringBuilder(field).append(" IN (");
        int index = 0;

        String separator;

        if (isString) {
            separator = "', '";
            stringBuilder.append("'");
        } else {
            separator = ", ";
        }

        for (String value : values) {
            if (value != null) {
                if (index > 0) {
                    stringBuilder.append(separator);
                }
                stringBuilder.append(value);
                index++;
            }
        }

        if (isString) {
            stringBuilder.append("')");
        } else {
            stringBuilder.append(")");
        }

        return stringBuilder.toString();
    }
}

Related

1. createTuple(List> tuples, List entries, List> lists)
2. createUniqueProducts(List list1, List list2)
3. createUnmodifiableList(Collection coll)
4. createUpdateMeasurementItemList(final String itemList, final String updateItem)
5. createValues(int barCount, String valueDigits, int distributionType, List valueCounts)
6. createWidList(int[][] widArray)
7. getOrCreateList(Map> map, K key)