From ac20dc99bf1f463365dba071973e08fffbd294b4 Mon Sep 17 00:00:00 2001 From: 13693261870 <252740454@qq.com> Date: 星期五, 14 七月 2023 14:12:21 +0800 Subject: [PATCH] 1 --- src/main/java/com/lf/server/helper/StringHelper.java | 15 ++++++++++----- 1 files changed, 10 insertions(+), 5 deletions(-) diff --git a/src/main/java/com/lf/server/helper/StringHelper.java b/src/main/java/com/lf/server/helper/StringHelper.java index 2c89b55..d9e83ba 100644 --- a/src/main/java/com/lf/server/helper/StringHelper.java +++ b/src/main/java/com/lf/server/helper/StringHelper.java @@ -123,10 +123,10 @@ } /** - * 鑾峰彇 like 瀛楃涓�-2 + * 鑾峰彇 like 瀛楃涓� */ - public static String getLikeStr2(String str) { - return StringHelper.isEmpty(str) ? "%" : "%" + str.trim() + "%"; + public static String getLikeUpperStr(String str) { + return StringHelper.isEmpty(str) ? null : "%" + str.trim().toUpperCase() + "%"; } /** @@ -171,6 +171,10 @@ * @return 鏄�/鍚� */ public static boolean isSqlInjection(String str) { + if (null == str) { + return false; + } + Matcher m = sqlPattern.matcher(str); return m.matches(); @@ -215,8 +219,9 @@ } } - if (sb.length() > 0 && sb.lastIndexOf(join) == sb.length() - 1) { - sb.deleteCharAt(sb.length() - 1); + if (sb.length() > 0 && sb.lastIndexOf(join) == sb.length() - join.length()) { + // 鍒犻櫎浠庣储寮� start 寮�濮嬪埌 end 涔嬮棿鐨勫瓧绗︼紝鍗� 鍓嶅寘鎷� 鍚庝笉鍖呮嫭銆� + sb.delete(sb.length() - join.length(), sb.length()); } return sb.toString(); -- Gitblit v1.9.3