字符串用逗号隔开

public String composeInSQLStatement(List strList){
if(strList==null || strList.isEmpty()){
return "";
}
StringBuffer buffer = new StringBuffer();
for(Iterator it = strList.iterator(); it.hasNext();){
buffer.append("'");
buffer.append(it.next());
buffer.append("',");
}
if(buffer.length() > 0){
buffer.deleteCharAt(buffer.length() - 1);
}

return buffer.toString();
}

public String composeInSQLStatementForInt(List integerStrList){
if(integerStrList == null || integerStrList.isEmpty()){
return "";
}
StringBuffer buffer = new StringBuffer();
for(Iterator it = integerStrList.iterator(); it.hasNext();){
buffer.append(it.next());
buffer.append(",");
}
if(buffer.length() > 0){
buffer.deleteCharAt(buffer.length() - 1);
}
return buffer.toString();
}