From 64decfa5272a6b068c3afb6ea5f071a0fdbb9b21 Mon Sep 17 00:00:00 2001
From: ludc
Date: 星期五, 16 六月 2023 17:50:46 +0800
Subject: [PATCH] 修改bug,添加高级查询SQL拼接方法

---
 Source/UBCS/ubcs-service-api/ubcs-util-api/src/main/java/com/vci/ubcs/starter/util/UBCSSqlKeyword.java |    7 +++++--
 1 files changed, 5 insertions(+), 2 deletions(-)

diff --git a/Source/UBCS/ubcs-service-api/ubcs-util-api/src/main/java/com/vci/ubcs/starter/util/UBCSSqlKeyword.java b/Source/UBCS/ubcs-service-api/ubcs-util-api/src/main/java/com/vci/ubcs/starter/util/UBCSSqlKeyword.java
index e9e9392..71ae42e 100644
--- a/Source/UBCS/ubcs-service-api/ubcs-util-api/src/main/java/com/vci/ubcs/starter/util/UBCSSqlKeyword.java
+++ b/Source/UBCS/ubcs-service-api/ubcs-util-api/src/main/java/com/vci/ubcs/starter/util/UBCSSqlKeyword.java
@@ -2,6 +2,7 @@
 
 import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
 import com.github.yulichang.wrapper.MPJLambdaWrapper;
+import com.vci.ubcs.starter.web.util.VciDateUtil;
 import org.springblade.core.tool.utils.DateUtil;
 import org.springblade.core.tool.utils.Func;
 import org.springblade.core.tool.utils.StringUtil;
@@ -35,6 +36,7 @@
 	private static final String IS_NULL = "_null";
 	private static final String NOT_NULL = "_notnull";
 	private static final String IGNORE = "_ignore";
+
 
 	public UBCSSqlKeyword() {
 	}
@@ -234,13 +236,14 @@
 	 * @param keyword
 	 * @return
 	 */
-	private static String getColumn(String column, String keyword) {
+	public static String getColumn(String column, String keyword) {
 		//娌℃湁杞笅鍒掔嚎鏄犲皠
-		return StringUtil.removeSuffix(column, keyword).toLowerCase(Locale.ROOT);
+		return StringUtil.removeSuffix(column, keyword).toLowerCase(Locale.ROOT).trim();
 	}
 
 	public static String filter(String param) {
 		return param == null ? null : param.replaceAll("(?i)'|%|--|insert|delete|select|count|group|union|drop|truncate|alter|grant|execute|exec|xp_cmdshell|call|declare|sql", "");
 	}
 
+
 }

--
Gitblit v1.9.3