Index: ssts-tousse/src/main/java/com/forgon/disinfectsystem/tousse/toussedefinition/service/TousseDefinitionManagerImpl.java =================================================================== diff -u -r16216 -r16225 --- ssts-tousse/src/main/java/com/forgon/disinfectsystem/tousse/toussedefinition/service/TousseDefinitionManagerImpl.java (.../TousseDefinitionManagerImpl.java) (revision 16216) +++ ssts-tousse/src/main/java/com/forgon/disinfectsystem/tousse/toussedefinition/service/TousseDefinitionManagerImpl.java (.../TousseDefinitionManagerImpl.java) (revision 16225) @@ -808,6 +808,9 @@ public List searchTousseDefinitions(String searchString,String tousseType, String handlerDepartCodes,String supplierName,boolean showDisableGoods,boolean showForeignTousseAncestorDefinition) { + + searchString = SqlUtils.filterIllegalCharachers(searchString); + String sql = createQuerySQL(searchString); if (TousseDefinition.PACKAGE_TYPE_INSIDE.equals(tousseType)) {// 内部器械包 Index: forgon-tools/src/main/java/com/forgon/tools/util/SqlUtils.java =================================================================== diff -u -r14586 -r16225 --- forgon-tools/src/main/java/com/forgon/tools/util/SqlUtils.java (.../SqlUtils.java) (revision 14586) +++ forgon-tools/src/main/java/com/forgon/tools/util/SqlUtils.java (.../SqlUtils.java) (revision 16225) @@ -216,4 +216,21 @@ } return sql; } + + /** + * 过滤掉无效的查询字符,避免查询报错的问题,包括单引号等符号 + * @param queryString 查询的字符串 + * @return 过滤掉无效字符后的字符串 + */ + public static String filterIllegalCharachers(String queryString){ + + if (StringUtils.isNotBlank(queryString)){ + if (queryString.indexOf("'") >= 0){ + queryString = queryString.replace("'", ""); + } + } + + return queryString; + + } }