String[] card_codes={"1111","222222"} StringBuffer insql = new StringBuffer(); insql.append('(');//一个字符 用单引号 for (int i = 0; i < card_codes.length; i++) { insql.append("'");//注:当字符串为单引号时用双引号 insql.append(card_codes[i]); insql.append("'"); insql.append(",");//注:当字符串为逗号时用双引号 } insql.deleteCharAt(insql.length() - 1);//删除字符串的最后一个字符 insql.append(')'); List<Map<String,Object>> retList = cityList(map); List<String> areaList=new ArrayList<>(); for (Map<String, Object> amap : retList) { areaList.add(amap.get("areaId").toString()); } StringBuffer insql = new StringBuffer(); for (int i=0;i<retList.size();i++) { if(i==1){ insql.append("'").append(areaList.get(i)).append("'"); }else{ insql.append(",").append("'").append(areaList.get(i)).append("'"); } }