java 把字符串数组id拆分 ， 加上单引号。 java 拼接id sql 用于in 查询

public class SpiltString {
 public String spilt(String str) {
  StringBuffer sb = new StringBuffer();
  String[] temp = str.split(",");
  for (int i = 0; i < temp.length; i++) {
   if (!"".equals(temp[i]) && temp[i] != null)
    sb.append("'" + temp[i] + "',");
  }
  String result = sb.toString();
  String tp = result.substring(result.length() - 1, result.length());
  if (",".equals(tp))
   return result.substring(0, result.length() - 1);
  else
   return result;
 }

 public static void main(String[] arg) {
  SpiltString ss = new SpiltString();
  String str = ss.spilt("a,b,c,d,e,f");
  System.out.println(str);
 }
}

	  //得到单据model对象--------排除分录中其他的重复目标终端和品规id，防止携带时 产生重复的品规和终端----------------------------------------------------------------------------------
			  ModelMap modelMap = event.getReqeustContext().get(ModelMap.class);
			  IObjectValue  model = (IObjectValue) modelMap.get("model");
			  TargetterminalInfo info = (TargetterminalInfo) modelMap.get("model");
			  StringBuffer targetTermials=  new StringBuffer() ;
			  targetTermials.append(" ( ");
			  StringBuffer products=  new StringBuffer() ;
			  products.append("( ");
			  TargetterminalEntryCollection entrys = info.getEntrys();
			  for (int i = 0; i < entrys.size(); i++) {
				  TargetterminalEntryInfo targetterminalEntryInfo = entrys.get(i);
				  String productid = targetterminalEntryInfo.getBasedata2().getId().toString();//品规id
				  String targetTermialid = targetterminalEntryInfo.getTargetTermial().getId().toString();//终端id
				  products=products.append(" '"+productid+"'  ").append(" ,");
				  targetTermials=targetTermials.append(" '"+targetTermialid+"'  ").append(" ,");
			   }
 			  targetTermials=new  StringBuffer(targetTermials.substring(0, targetTermials.lastIndexOf(",")));
			  products=new StringBuffer(products.substring(0, products.lastIndexOf(",")));  
		      
			  targetTermials=targetTermials.append(" )");
			  products= products.append(" )");

    StringBuffer targetTermials=  new StringBuffer() ;
		targetTermials.append(" ( ");
	    while ( executeSQL.next()) {
			  String targetTermialid = executeSQL.getString("entryId");
			  targetTermials=targetTermials.append(" '"+targetTermialid+"'  ").append(" ,");
		   }
		  targetTermials=new  StringBuffer(targetTermials.substring(0, targetTermials.lastIndexOf(",")));
		  targetTermials=targetTermials.append(" )");
		  
		  Map map=  new  HashMap();
		  map.put("targetTermials", targetTermials);
	      JSONUtils.SUCCESS(map);