Index: ssts-diposablegoods/src/main/java/com/forgon/disinfectsystem/diposablegoods/service/DisposableGoodsBatchManagerImpl.java =================================================================== diff -u -r12838 -r13189 --- ssts-diposablegoods/src/main/java/com/forgon/disinfectsystem/diposablegoods/service/DisposableGoodsBatchManagerImpl.java (.../DisposableGoodsBatchManagerImpl.java) (revision 12838) +++ ssts-diposablegoods/src/main/java/com/forgon/disinfectsystem/diposablegoods/service/DisposableGoodsBatchManagerImpl.java (.../DisposableGoodsBatchManagerImpl.java) (revision 13189) @@ -24,7 +24,7 @@ if (DatabaseUtil.isPoIdValid(disposableGoodsId)) { String sql = " where po.diposableGoods.id = " + disposableGoodsId; if(!StringTools.isBlank(spell)){ - sql += " and po.batchNumber like %" + spell + "%"; + sql += " and po.batchNumber like '%" + spell + "%'"; } return objectDao.findBySql(DisposableGoodsBatch.class.getSimpleName(), sql); }