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-admin/src/main/java/com/ruoyi/web/controller/common/ApiController.java | 19 +++++++++++--------
1 files changed, 11 insertions(+), 8 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("琛ㄥ悕涓嶈兘涓虹┖");
}
}
+
}
--
Gitblit v1.9.3