Index: ssts-basedata/src/main/java/com/forgon/disinfectsystem/basedata/becleanitem/service/BeCleanItemManagerImpl.java =================================================================== diff -u -r16249 -r16296 --- ssts-basedata/src/main/java/com/forgon/disinfectsystem/basedata/becleanitem/service/BeCleanItemManagerImpl.java (.../BeCleanItemManagerImpl.java) (revision 16249) +++ ssts-basedata/src/main/java/com/forgon/disinfectsystem/basedata/becleanitem/service/BeCleanItemManagerImpl.java (.../BeCleanItemManagerImpl.java) (revision 16296) @@ -408,8 +408,8 @@ */ public ClassifyBasket getUnWashedBasketByBarcode(String barcode) { if (StringUtils.isNotBlank(barcode)) { - String sql = "select po,r from " + ClassifyBasket.class.getSimpleName() + " po left join po.washAndDisinfectRecords r where r.id is null and po.containerBarcode like '%" - + barcode + "%'"; + String sql = String.format("select po,r from %s po left join po.washAndDisinfectRecords r " + + "where r.id is null and po.containerBarcode = '%s'", ClassifyBasket.class.getSimpleName(),barcode); List list = objectDao.findByHql(sql); if(list.size() > 0) { Object[] objArray = (Object[]) list.get(0);