//每组数据的个数
private static final int everyGroupNum=9;
public static StringBuffer getIn() {
//123,234,345,456,567,678,789
String patientAllId="123,234,345,456,567,678,789,8910,91011,101112";
String patientid="";
StringBuffer buffer=new StringBuffer();
if((patientAllId)){
String[] array=(",");
//数组总长度
int len=;
//分组数
int groupCount=len/everyGroupNum;
for(int k=0;k
patientid="";
for(int i=(k*everyGroupNum);i
if(i==k*everyGroupNum){
//每组的第一个数组
patient+array[i].trim()+"'";
}else{
patientid=patientid+","+"'"+array[i].trim()+"'";
}
}
(" and in("+patientid+")");
}
if(len%everyGroupNum != 0){
//未整除
patientid="";
//处理最后一组数据
for(int j=(groupCount*everyGroupNum);j
if(j==groupCount*everyGroupNum){
//每组的第一个数组
patient+array[j].trim()+"'";
}else{
patientid=patientid+","+"'"+array[j].trim()+"'";
}
}
(" and in("+patientid+")");
}
}
return buffer;
}