Index: ssts-recyclingapplication/src/main/java/com/forgon/disinfectsystem/recyclingapplication/service/InvoicePlanManagerImpl.java =================================================================== diff -u -r23740 -r23783 --- ssts-recyclingapplication/src/main/java/com/forgon/disinfectsystem/recyclingapplication/service/InvoicePlanManagerImpl.java (.../InvoicePlanManagerImpl.java) (revision 23740) +++ ssts-recyclingapplication/src/main/java/com/forgon/disinfectsystem/recyclingapplication/service/InvoicePlanManagerImpl.java (.../InvoicePlanManagerImpl.java) (revision 23783) @@ -1600,7 +1600,7 @@ if(idList == null || idList.size()==0){ return null; } - String sql2 = String.format(" where po.id in(%s)", SqlUtils.joinToWhereInConditionForNonStringProperties(idList)); + String sql2 = String.format(" where %s", SqlUtils.getNonStringFieldInLargeCollectionsPredicate("po.id",idList)); // 锁定的方式批量查询 String queryString = String.format("from %s po inner join fetch po.applicationItems %s order by po.id asc", InvoicePlan.class.getSimpleName(),sql2); Session session = objectDao.getHibernateSession();