From 4a2244dc29d72e2a994d2288e3731d29ecb7fead Mon Sep 17 00:00:00 2001
From: sinake <sinake1@qq.com>
Date: 星期三, 18 三月 2026 14:22:00 +0800
Subject: [PATCH] 动态查询API接口修改
---
ruoyi-project/src/main/java/com/ruoyi/project/service/impl/ApiServiceImpl.java | 62 +++++++++++++++++++++++++++++++
1 files changed, 62 insertions(+), 0 deletions(-)
diff --git a/ruoyi-project/src/main/java/com/ruoyi/project/service/impl/ApiServiceImpl.java b/ruoyi-project/src/main/java/com/ruoyi/project/service/impl/ApiServiceImpl.java
new file mode 100644
index 0000000..0999ae9
--- /dev/null
+++ b/ruoyi-project/src/main/java/com/ruoyi/project/service/impl/ApiServiceImpl.java
@@ -0,0 +1,62 @@
+package com.ruoyi.project.service.impl;
+
+import com.alibaba.fastjson.JSON;
+import com.alibaba.fastjson.JSONArray;
+import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
+import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
+import com.ruoyi.project.domain.GiApi;
+import com.ruoyi.project.domain.dto.ApiDTO;
+import com.ruoyi.project.mapper.ApiMapper;
+import com.ruoyi.project.service.IApiService;
+import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.stereotype.Service;
+
+import javax.servlet.http.HttpServletRequest;
+import java.util.ArrayList;
+import java.util.List;
+import java.util.Map;
+
+@Service
+public class ApiServiceImpl extends ServiceImpl<ApiMapper, GiApi> implements IApiService {
+ @Autowired
+ ApiMapper mapper;
+ /**
+ * 涓婚敭鏌ヨ璇︾粏
+ * @param code
+ * @return
+ */
+ public GiApi getCode(String code){
+ QueryWrapper <GiApi> wrapper=new QueryWrapper<>();
+ wrapper.eq("api_Code",code);
+ return mapper.selectOne(wrapper);
+ }
+
+
+ /**
+ * 鏌ヨ鏁版嵁鍒楄〃
+ * @param DTO
+ * @return
+ */
+ public List<Map<String,Object>> getListSql(String sql, ApiDTO DTO) {
+ if(DTO.getParams()!=null) {
+ for (String key : DTO.getParams().keySet()) {
+ sql = sql.replace("@" + key, DTO.getParams().get(key) + "");
+ }
+ }
+ return mapper.executeSql(sql);
+ }
+
+ /**
+ * 鏌ヨ鏁版嵁鍒楄〃
+ * @param DTO
+ * @return
+ */
+ public String getStringSql(String sql, ApiDTO DTO) {
+ if(DTO.getParams()!=null) {
+ for (String key : DTO.getParams().keySet()) {
+ sql = sql.replace("@" + key, DTO.getParams().get(key) + "");
+ }
+ }
+ return mapper.getClob(sql);
+ }
+}
--
Gitblit v1.9.3