From e26af85e049516e6ce2b082bc2bc90bf71643e95 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期五, 24 三月 2023 09:06:30 +0800
Subject: [PATCH] 1
---
src/main/java/com/lf/server/helper/StringHelper.java | 19 ++++++++++++-------
1 files changed, 12 insertions(+), 7 deletions(-)
diff --git a/src/main/java/com/lf/server/helper/StringHelper.java b/src/main/java/com/lf/server/helper/StringHelper.java
index fd87b7f..d9e83ba 100644
--- a/src/main/java/com/lf/server/helper/StringHelper.java
+++ b/src/main/java/com/lf/server/helper/StringHelper.java
@@ -123,16 +123,16 @@
}
/**
- * 鑾峰彇 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 瀛楃涓�
+ * 鑾峰彇 鍙砽ike 瀛楃涓�
*/
- public static String getLeftLike(String str) {
+ public static String getRightLike(String str) {
return StringHelper.isEmpty(str) ? null : str.trim() + "%";
}
@@ -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