From 96b26f52bbb9fbc89bbbd33919eb5655acab5f9b Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期日, 10 九月 2023 10:04:01 +0800
Subject: [PATCH] 添加根据名称查询目录id接口
---
src/main/java/com/moon/server/service/data/DirService.java | 6 ++++++
src/main/resources/mapper/data/DirMapper.xml | 4 ++++
src/main/java/com/moon/server/mapper/data/DirMapper.java | 8 ++++++++
3 files changed, 18 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/moon/server/mapper/data/DirMapper.java b/src/main/java/com/moon/server/mapper/data/DirMapper.java
index b69d475..5be37ca 100644
--- a/src/main/java/com/moon/server/mapper/data/DirMapper.java
+++ b/src/main/java/com/moon/server/mapper/data/DirMapper.java
@@ -115,4 +115,12 @@
* @return
*/
public List<DirEntity> selectDirsForPrj();
+
+ /**
+ * 鏍规嵁鍚嶇О鏌ヨID
+ *
+ * @param name 鍚嶇О
+ * @return ID
+ */
+ public Integer selectIdByName(String name);
}
diff --git a/src/main/java/com/moon/server/service/data/DirService.java b/src/main/java/com/moon/server/service/data/DirService.java
index 61ed8db..e3ca975 100644
--- a/src/main/java/com/moon/server/service/data/DirService.java
+++ b/src/main/java/com/moon/server/service/data/DirService.java
@@ -94,6 +94,12 @@
return dirMapper.selectDirsForPrj();
}
+ @Override
+ public Integer selectIdByName(String name) {
+ Integer id = dirMapper.selectIdByName(name);
+ return null == id ? 0 : id;
+ }
+
/**
* 鍒涘缓鏁版嵁鐩綍
*/
diff --git a/src/main/resources/mapper/data/DirMapper.xml b/src/main/resources/mapper/data/DirMapper.xml
index 89253c9..67ce590 100644
--- a/src/main/resources/mapper/data/DirMapper.xml
+++ b/src/main/resources/mapper/data/DirMapper.xml
@@ -53,6 +53,10 @@
select a.* from lf.sys_dir a where code not like '00%' order by code;
</select>
+ <select id="selectIdByName" resultType="java.lang.Integer">
+ select id from lf.sys_dir where name = #{name};
+ </select>
+
<!-- 鎻掑叆涓�鏉� -->
<insert id="insert" parameterType="com.moon.server.entity.data.DirEntity">
<selectKey resultType="java.lang.Integer" order="AFTER" keyProperty="id">
--
Gitblit v1.9.3