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 | 21 ---------------------
ruoyi-admin/src/main/java/com/ruoyi/web/controller/common/ApiController.java | 19 +++++++++++--------
2 files changed, 11 insertions(+), 29 deletions(-)
diff --git a/ruoyi-admin/src/main/java/com/ruoyi/web/controller/common/ApiController.java b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/common/ApiController.java
index 11d74eb..bcf0fa1 100644
--- a/ruoyi-admin/src/main/java/com/ruoyi/web/controller/common/ApiController.java
+++ b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/common/ApiController.java
@@ -1,5 +1,6 @@
package com.ruoyi.web.controller.common;
+import com.alibaba.fastjson2.JSON;
import com.ruoyi.common.core.domain.AjaxResult;
import com.ruoyi.common.core.page.TableDataInfo;
import com.ruoyi.project.domain.BaseAnnextype;
@@ -26,20 +27,21 @@
private IApiService service;
@ApiOperation("API->api鏌ヨ鍒楄〃")
@PostMapping("/{path}")
- public AjaxResult getApiList(@PathVariable("path") String path, @RequestBody ApiDTO DTO){
- List<Map<String,Object>> lists=new ArrayList<>();
- if(ObjectUtils.isNotEmpty(path)) {
- GiApi tempSql= service.getCode(path);
- if(tempSql!=null&&ObjectUtils.isNotEmpty(tempSql.getApiSql())) {
+ public AjaxResult getApiList(@PathVariable("path") String path, @RequestBody ApiDTO DTO) {
+ List<Map<String, Object>> lists = new ArrayList<>();
+ if (ObjectUtils.isNotEmpty(path)) {
+ GiApi tempSql = service.getCode(path);
+ if (tempSql != null && ObjectUtils.isNotEmpty(tempSql.getApiSql())) {
String SQL_REG_EXP = ".*(\\b(insert|into|update|delete|trancate" +
"|drop|execute|grant|use)\\b).*";
if (tempSql.getApiSql().toLowerCase().matches(SQL_REG_EXP)) {
return AjaxResult.error("sql涓湁闈炴硶瀛楃,鍙簲璁竤elect");
}
- return AjaxResult.success(service.getListSql(tempSql.getApiSql(),DTO));
- }else
+ lists = service.getListSql(tempSql.getApiSql(), DTO);
+ return AjaxResult.success(JSON.toJSON(lists));
+ } else
return AjaxResult.error("sql浠ｇ爜娌℃湁瀵瑰簲鐨剆ql璇锋牳瀵�");
- }else {
+ } else {
return AjaxResult.error("琛ㄥ悕涓嶈兘涓虹┖");
}
}
@@ -65,4 +67,5 @@
return AjaxResult.error("琛ㄥ悕涓嶈兘涓虹┖");
}
}
+
}
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
index af5ba86..0999ae9 100644
--- 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
@@ -31,27 +31,6 @@
return mapper.selectOne(wrapper);
}
- public String buildSql(HttpServletRequest request, String sql) {
-
-// JSONArray requestParams = JSON.parseArray(config.getParams());
-// for (int i = 0; i < requestParams.size(); i++) {
-// JSONObject jo = requestParams.getJSONObject(i);
-// String name = jo.getString("name");
-// String type = jo.getString("type");
-// String old = '$' + name;
-//
-// String value = request.getParameter(name);
-//
-// //涓嶆槸鏁板瓧绫诲瀷鐨勫�艰鍔犲崟寮曞彿
-// if (!"number".equals(type)) {
-// value = String.format("'%s'", value);
-// }
-//
-// sql = sql.replace(old, value);
-// }
-
- return sql;
- }
/**
* 鏌ヨ鏁版嵁鍒楄〃
--
Gitblit v1.9.3