From 445acb921e3886b2c2012e5343c4e4c7ad5bc6e9 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期五, 25 十一月 2022 08:22:09 +0800
Subject: [PATCH] 1
---
src/main/java/com/lf/server/controller/data/MetaController.java | 4 ++--
data/db_fn.sql | 2 +-
src/main/java/com/lf/server/service/data/MetaService.java | 6 ++++++
src/main/java/com/lf/server/mapper/data/MetaMapper.java | 9 +++++++++
src/main/resources/mapper/data/MetaMapper.xml | 7 +++++++
5 files changed, 25 insertions(+), 3 deletions(-)
diff --git a/data/db_fn.sql b/data/db_fn.sql
index 6cc3d5b..df045ba 100644
--- a/data/db_fn.sql
+++ b/data/db_fn.sql
@@ -346,7 +346,7 @@
select * from lf.sys_meta; -- delete from lf.sys_meta;
select * from lf.sys_meta_file; -- delete from lf.sys_meta_file;
-
+select * from lf.sys_meta_file a where metaid in (99,100,101)
diff --git a/src/main/java/com/lf/server/controller/data/MetaController.java b/src/main/java/com/lf/server/controller/data/MetaController.java
index 990e923..494e1e4 100644
--- a/src/main/java/com/lf/server/controller/data/MetaController.java
+++ b/src/main/java/com/lf/server/controller/data/MetaController.java
@@ -7,6 +7,7 @@
import com.lf.server.entity.ctrl.DownloadReqEntity;
import com.lf.server.entity.data.DownloadEntity;
import com.lf.server.entity.data.MetaEntity;
+import com.lf.server.entity.data.MetaFileEntity;
import com.lf.server.entity.sys.UserEntity;
import com.lf.server.helper.Md5Helper;
import com.lf.server.helper.RsaHelper;
@@ -275,8 +276,7 @@
return fail("瀵嗙爜涓嶇鍚堣姹�");
}
- String ids = StringHelper.join(reqEntity.getIds(), ",");
-
+ List<MetaFileEntity> list = metaService.selectMetaFiles(reqEntity.getIds());
return success(true);
} catch (Exception ex) {
diff --git a/src/main/java/com/lf/server/mapper/data/MetaMapper.java b/src/main/java/com/lf/server/mapper/data/MetaMapper.java
index 1277de2..a3bed32 100644
--- a/src/main/java/com/lf/server/mapper/data/MetaMapper.java
+++ b/src/main/java/com/lf/server/mapper/data/MetaMapper.java
@@ -1,6 +1,7 @@
package com.lf.server.mapper.data;
import com.lf.server.entity.data.MetaEntity;
+import com.lf.server.entity.data.MetaFileEntity;
import org.apache.ibatis.annotations.Mapper;
import org.springframework.stereotype.Repository;
@@ -71,6 +72,14 @@
public MetaEntity selectById(int id);
/**
+ * 鏌ヨ鍏冩暟鎹枃浠�
+ *
+ * @param ids 鍏冩暟鎹甀D闆嗗悎
+ * @return 鍏冩暟鎹枃浠堕泦鍚�
+ */
+ public List<MetaFileEntity> selectMetaFiles(List<Integer> ids);
+
+ /**
* 鎻掑叆涓�鏉�
*
* @param entity
diff --git a/src/main/java/com/lf/server/service/data/MetaService.java b/src/main/java/com/lf/server/service/data/MetaService.java
index f5b193c..3205514 100644
--- a/src/main/java/com/lf/server/service/data/MetaService.java
+++ b/src/main/java/com/lf/server/service/data/MetaService.java
@@ -1,6 +1,7 @@
package com.lf.server.service.data;
import com.lf.server.entity.data.MetaEntity;
+import com.lf.server.entity.data.MetaFileEntity;
import com.lf.server.helper.StringHelper;
import com.lf.server.mapper.data.MetaMapper;
import org.springframework.beans.factory.annotation.Autowired;
@@ -56,6 +57,11 @@
}
@Override
+ public List<MetaFileEntity> selectMetaFiles(List<Integer> ids) {
+ return metaMapper.selectMetaFiles(ids);
+ }
+
+ @Override
public Integer insert(MetaEntity entity) {
return metaMapper.insert(entity);
}
diff --git a/src/main/resources/mapper/data/MetaMapper.xml b/src/main/resources/mapper/data/MetaMapper.xml
index aeb5af2..211f050 100644
--- a/src/main/resources/mapper/data/MetaMapper.xml
+++ b/src/main/resources/mapper/data/MetaMapper.xml
@@ -62,6 +62,13 @@
from lf.sys_meta a where id = #{id}
</select>
+ <select id="selectMetaFiles" resultType="com.lf.server.entity.data.MetaFileEntity">
+ select a.* from lf.sys_meta_file a where metaid in
+ <foreach item="id" collection="ids" index="index" open="(" separator="," close=")">
+ #{id}
+ </foreach>
+ </select>
+
<insert id="insert" parameterType="com.lf.server.entity.data.MetaEntity">
<selectKey resultType="java.lang.Integer" order="AFTER" keyProperty="id">
select currval('lf.sys_meta_id_seq'::regclass) as id
--
Gitblit v1.9.3