From 11684f85ba0efefcb1b421af58e6f8284d51e716 Mon Sep 17 00:00:00 2001
From: lige <bestlige@outlook.com>
Date: 星期三, 15 十一月 2023 17:50:19 +0800
Subject: [PATCH] 备忘录
---
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..c941022 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 * 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