Here you can find the source of addInClauseToQuery(StringBuilder query, Collection
public static StringBuilder addInClauseToQuery(StringBuilder query, Collection<Object> l)
//package com.java2s; /**/*from ww w . j a v a 2 s .c om*/ * The contents of this file are subject to the OpenMRS Public License * Version 1.0 (the "License"); you may not use this file except in * compliance with the License. You may obtain a copy of the License at * http://license.openmrs.org * * Software distributed under the License is distributed on an "AS IS" * basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. See the * License for the specific language governing rights and limitations * under the License. * * Copyright (C) OpenMRS, LLC. All Rights Reserved. */ import java.util.Collection; import java.util.Iterator; public class Main { public static StringBuilder addInClauseToQuery(StringBuilder query, Collection<Object> l) { query.append(" ("); for (Iterator<Object> i = l.iterator(); i.hasNext();) { Object columnValue = i.next(); if (columnValue instanceof String) { columnValue = "'" + columnValue + "'"; } query.append(columnValue).append(i.hasNext() ? "," : ""); } query.append(")"); return query; } }