Index: ssts-basedata/src/main/java/com/forgon/disinfectsystem/systemsetting/service/HttpOptionManagerSSTSImpl.java =================================================================== diff -u -r34530 -r35338 --- ssts-basedata/src/main/java/com/forgon/disinfectsystem/systemsetting/service/HttpOptionManagerSSTSImpl.java (.../HttpOptionManagerSSTSImpl.java) (revision 34530) +++ ssts-basedata/src/main/java/com/forgon/disinfectsystem/systemsetting/service/HttpOptionManagerSSTSImpl.java (.../HttpOptionManagerSSTSImpl.java) (revision 35338) @@ -547,11 +547,7 @@ String sql = String.format("select max(po.sequence) from %s po where po.optionListId = '%s'", HttpOption.class.getSimpleName(), HttpOption.SYSTEMSETTING_STERILIZATIONPURPOSE); - int maxOrder = 0; - List list = objectDao.findByHql(sql); - if(CollectionUtils.isNotEmpty(list)){ - maxOrder = (int) list.get(0); - } + int maxOrder = objectDao.countBySql(sql); maxOrder += 1; httpOption.setSequence(maxOrder); }