[java] view plain copy for (int i = 0; i < list.size(); i++) { if (i == (list.size() - 1)) { sqlString.append(list.get(i)); //SQL拼装,最后一条不加“,”。 }else if((i%999)==0 && i>0){ sqlString.append(list.get(i)).append(") or id in ("); //解决ORA-01795问题 }else{ sqlString.append(list.get(i)).append(","); } } [java] view plain copy hql = "from Table r where r.id in("+sqlString+") order by r.layerOrder";