//获取字符串分割
String[] roomstr = roomids.split(",");
String str ="''";
List<String> datalist = new ArrayList();
//拼接多个长度1000的字符串
if(roomstr.length>1000){
for(int i = 0;i<roomstr.length;i++){
if((i+1)%1000==1){
if(!roomstr[i].equals("''")){
str = roomstr[i] ;
}
}else{
str = str +","+roomstr[i];
}
if((i+1)%1000==0||i==roomstr.length-1){
datalist.add(str);
}
}
}else{
str = roomids;
datalist.add(str);
}
//拼接多sql 用and in or in or in 类型解决
StringBuffer querySql = new StringBuffer();
querySql.append(" select a.building_id, b.buildingnumber, a.roomid, a.cell, a.room_number, b.district||b.estrada||b.buildingnumber||a.cell||a.room_number location, ");
querySql.append(" c.proprietorid, c.name, c.paper_type, c.paper_id, a.area, 0 shouldshareamt ");
querySql.append(" from ev_info_room a ");
querySql.append(" left join ev_info_building b on b.buildingid=a.building_id and b.validflag='1' ");
querySql.append(" left join ev_info_proprietor c on c.room_id=a.roomid and c.validflag='1' ");