From c16518d773c92f3a9092ed7c2d813adfec9eb280 Mon Sep 17 00:00:00 2001
From: zjh <1084500556@qq.com>
Date: 星期二, 12 十二月 2023 17:13:58 +0800
Subject: [PATCH] zjh 2023/12/12--3
---
ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjAdviceMapper.java | 9 +++++++++
1 files changed, 9 insertions(+), 0 deletions(-)
diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjAdviceMapper.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjAdviceMapper.java
index 57c3fc2..bd4f772 100644
--- a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjAdviceMapper.java
+++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjAdviceMapper.java
@@ -73,4 +73,13 @@
"</foreach>",
"</script>" })
public String getAdviceStringByIds(@Param("aList") List<String> aList);
+
+
+
+ @Select({"<script>", "select GROUP_CONCAT(a.title Separator ';') from tj_advice a where a.id in",
+ "<foreach collection='aList' item='id' open='(' separator=',' close=')'>",
+ "#{id}",
+ "</foreach>",
+ "</script>" })
+ List<TjAdvice> getAdviceStringByIds(@Param("aList") String[] aList);
}
--
Gitblit v1.8.0