From d3ae08fbd8634429150f8a54bc779efdfd9aa1e2 Mon Sep 17 00:00:00 2001
From: futian.liu <liufutianyoo@163.com>
Date: 星期三, 13 十二月 2023 19:02:03 +0800
Subject: [PATCH] Merge remote-tracking branch 'origin/master'

---
 consum-base/src/main/java/com/consum/base/service/SDictDataServiceImpl.java |   23 +++++++++++++----------
 1 files changed, 13 insertions(+), 10 deletions(-)

diff --git a/consum-base/src/main/java/com/consum/base/service/SDictDataServiceImpl.java b/consum-base/src/main/java/com/consum/base/service/SDictDataServiceImpl.java
index 4488427..32cac01 100644
--- a/consum-base/src/main/java/com/consum/base/service/SDictDataServiceImpl.java
+++ b/consum-base/src/main/java/com/consum/base/service/SDictDataServiceImpl.java
@@ -2,6 +2,7 @@
 
 import com.consum.model.po.SDictData;
 import com.walker.jdbc.service.BaseServiceImpl;
+import org.apache.commons.lang3.StringUtils;
 import org.springframework.stereotype.Service;
 import org.springframework.util.CollectionUtils;
 
@@ -12,11 +13,11 @@
 public class SDictDataServiceImpl extends BaseServiceImpl {
 
     /**
-     * @Description  鏍规嵁鎶ュ簾鍘熷洜code鏌ヨ鏁版嵁瀛楀吀
+     * @Description 鏍规嵁鎶ュ簾鍘熷洜code鏌ヨ鏁版嵁瀛楀吀
      * @Author 鍗㈠簡闃�
      * @Date 2023/11/2
      */
-    public List<SDictData> selectByScrappedCodeList(List<String> scrappedCodeList) {
+    public List<SDictData> selectByScrappedCodeList(List scrappedCodeList) {
         if (CollectionUtils.isEmpty(scrappedCodeList)) {
             log.error("鍙傛暟閿欒");
             return null;
@@ -24,14 +25,16 @@
         StringBuilder sql = new StringBuilder("SELECT * FROM s_dict_data WHERE 1 = 1 ");
         HashMap<String, Object> paramts = new HashMap<>();
 
-        sql.append(" and dict_code in ( ");
-        for (int i = 0; i < scrappedCodeList.size(); i++) {
-            sql.append(scrappedCodeList.get(i));
-            if (i < scrappedCodeList.size() - 1) {
-                sql.append(",");
-            }
-        }
-        sql.append(" ) ");
+        sql.append(" and dict_code in ( ").append(
+                StringUtils.join(scrappedCodeList, ",")).append(")");
+
+//        for (int i = 0; i < scrappedCodeList.size(); i++) {
+//            sql.append(scrappedCodeList.get(i));
+//            if (i < scrappedCodeList.size() - 1) {
+//                sql.append(",");
+//            }
+//        }
+//        sql.append(" ) ");
 
         return this.select(sql.toString(), paramts, new SDictData());
     }

--
Gitblit v1.9.1