Index: ssts-diposablegoods/src/main/java/com/forgon/disinfectsystem/diposablegoods/service/DiposableGoodsManagerImpl.java =================================================================== diff -u -r13025 -r13031 --- ssts-diposablegoods/src/main/java/com/forgon/disinfectsystem/diposablegoods/service/DiposableGoodsManagerImpl.java (.../DiposableGoodsManagerImpl.java) (revision 13025) +++ ssts-diposablegoods/src/main/java/com/forgon/disinfectsystem/diposablegoods/service/DiposableGoodsManagerImpl.java (.../DiposableGoodsManagerImpl.java) (revision 13031) @@ -1005,6 +1005,9 @@ if (StringUtils.isBlank(name)) { return null; } + if(StringUtils.isBlank(specification)){ + specification = null; + } String sql = String.format(" where %s and %s", SqlUtils .getStringFieldPredicate("po.name", name), SqlUtils .getStringFieldPredicate("po.specification", specification));