From d6b13e04801d7fcff082e08d6f63630d7ab5b5d9 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期三, 15 二月 2023 17:12:54 +0800
Subject: [PATCH] 1
---
src/main/java/com/lf/server/service/show/DataLibService.java | 68 ++++++++++++++++++++++++++++++++++
1 files changed, 68 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/lf/server/service/show/DataLibService.java b/src/main/java/com/lf/server/service/show/DataLibService.java
index e239b16..0239259 100644
--- a/src/main/java/com/lf/server/service/show/DataLibService.java
+++ b/src/main/java/com/lf/server/service/show/DataLibService.java
@@ -257,4 +257,72 @@
return rows > 0 ? downloadEntity.getGuid() : null;
}
+
+ /**
+ * 澶勭悊缂栫爜
+ */
+ public static String copeCodes(String codes, String field) {
+ if (StringHelper.isEmpty(codes) || StringHelper.isSqlInjection(codes)) {
+ return null;
+ }
+
+ List<String> list = codesAsList(codes);
+ removeDuplicate(list);
+ setRightLike(list, field);
+
+ return StringHelper.join(list, " or ");
+ }
+
+ /**
+ * 鍗曚綅缂栫爜杞泦鍚�
+ */
+ private static List<String> codesAsList(String codes) {
+ List<String> list = Arrays.asList(codes.split(","));
+ Set set = new HashSet(list);
+
+ List<String> newList = new ArrayList<>(set);
+ Collections.sort(newList);
+
+ return newList;
+ }
+
+ /**
+ * 鍘婚櫎閲嶅
+ */
+ private static void removeDuplicate(List<String> list) {
+ int i = 0;
+ while (i < list.size()) {
+ int j = findStr(list, i);
+ if (j > -1) {
+ list.remove(j);
+ continue;
+ }
+
+ i++;
+ }
+ }
+
+ /**
+ * 鏌ユ壘瀛楃涓�
+ */
+ private static int findStr(List<String> list, int i) {
+ String source = list.get(i);
+ for (int j = i + 1, c = list.size(); j < c; j++) {
+ if (list.get(j).startsWith(source)) {
+ return j;
+ }
+ }
+
+ return -1;
+ }
+
+ /**
+ * 璁剧疆 鍙砽ike
+ */
+ private static void setRightLike(List<String> list, String field) {
+ for (int i = 0, c = list.size(); i < c; i++) {
+ String str = String.format("%s like '%s%%'", field, list.get(i));
+ list.set(i, str);
+ }
+ }
}
--
Gitblit v1.9.3