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 | 23 ++++++++++++++++++----- 1 files changed, 18 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 5ef0394..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,17 @@ } /** - * 鑾峰彇 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() + "%"; + } + + /** + * 鑾峰彇 鍙砽ike 瀛楃涓� + */ + public static String getRightLike(String str) { + return StringHelper.isEmpty(str) ? null : str.trim() + "%"; } /** @@ -164,6 +171,10 @@ * @return 鏄�/鍚� */ public static boolean isSqlInjection(String str) { + if (null == str) { + return false; + } + Matcher m = sqlPattern.matcher(str); return m.matches(); @@ -181,6 +192,7 @@ /** * 鑾峰彇GUID + * * @return */ public static String getGuid() { @@ -207,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