From b6d6d654ebbd46ff0c428f323c0007ba1e99e99f Mon Sep 17 00:00:00 2001
From: qfrjava <13402782+qfrjava@user.noreply.gitee.com>
Date: 星期五, 25 四月 2025 17:31:36 +0800
Subject: [PATCH] light fix
---
JAVA/SMTAIServer/src/main/java/com/smtaiserver/smtaiserver/control/SMTSystemManagerControl.java | 69 +++++++++++++++++++++++++++++++++-
1 files changed, 67 insertions(+), 2 deletions(-)
diff --git a/JAVA/SMTAIServer/src/main/java/com/smtaiserver/smtaiserver/control/SMTSystemManagerControl.java b/JAVA/SMTAIServer/src/main/java/com/smtaiserver/smtaiserver/control/SMTSystemManagerControl.java
index 0b0f542..ecdb822 100644
--- a/JAVA/SMTAIServer/src/main/java/com/smtaiserver/smtaiserver/control/SMTSystemManagerControl.java
+++ b/JAVA/SMTAIServer/src/main/java/com/smtaiserver/smtaiserver/control/SMTSystemManagerControl.java
@@ -167,8 +167,65 @@
{
db.close();
}
- }
-
+ }
+
+ public ModelAndView addRoleInfo(SMTAIServerRequest tranReq) throws Exception {
+ String roleId = tranReq.convParamToString("role_id", true);
+ String roleTitle = tranReq.convParamToString("role_title", true);
+
+ SMTDatabase db = SMTAIServerApp.getApp().allocDatabase();
+
+ try {
+ // 妫�鏌ヨ鑹睮D鏄惁宸插瓨鍦�
+ String selectSql = "SELECT * FROM ai_sys.sys_role_info WHERE role_id = ?";
+ Object[] selectParams = {roleId};
+ if (db.querySQL(selectSql, selectParams).getRowCount() > 0) {
+ return tranReq.returnJsonState(false, "瑙掕壊ID宸插瓨鍦�", null);
+ }
+
+ // 鎻掑叆鏂拌鑹�
+ String insertSql = "INSERT INTO ai_sys.sys_role_info (role_id, role_title) VALUES (?, ?)";
+ Object[] insertParams = {roleId, roleTitle};
+
+ db.executeSQL(insertSql, insertParams);
+
+ // 杩斿洖 JSON 缁撴灉
+ SMTJsonWriter jsonWr = tranReq.newReturnJsonWriter(true, null, null);
+ return tranReq.returnJson(jsonWr);
+ } finally {
+ db.close();
+ }
+ }
+
+ public ModelAndView updateRoleInfo(SMTAIServerRequest tranReq) throws Exception {
+ String roleId = tranReq.convParamToString("role_id", true);
+ String roleTitle = tranReq.convParamToString("role_title", false);
+
+ SMTDatabase db = SMTAIServerApp.getApp().allocDatabase();
+
+ try {
+ // 妫�鏌ヨ鑹睮D鏄惁瀛樺湪
+ String selectSql = "SELECT * FROM ai_sys.sys_role_info WHERE role_id = ?";
+ Object[] selectParams = {roleId};
+ if (db.querySQL(selectSql, selectParams).getRowCount() == 0) {
+ return tranReq.returnJsonState(false, "瑙掕壊ID涓嶅瓨鍦�", null);
+ }
+
+ // 鏇存柊瑙掕壊淇℃伅
+ String updateSql = "UPDATE ai_sys.sys_role_info SET role_title = ? WHERE role_id = ?";
+ Object[] updateParams = {roleTitle, roleId};
+
+ db.executeSQL(updateSql, updateParams);
+
+ // 杩斿洖 JSON 缁撴灉
+ SMTJsonWriter jsonWr = tranReq.newReturnJsonWriter(true, null, null);
+ return tranReq.returnJson(jsonWr);
+ } finally {
+ db.close();
+ }
+ }
+
+
public ModelAndView addUserInfo(SMTAIServerRequest tranReq) throws Exception
{
String userName = tranReq.convParamToString("user_name", true);
@@ -972,5 +1029,13 @@
}
}
+ public ModelAndView getResourceUsage(SMTAIServerRequest tranReq) throws Exception
+ {
+ SMTJsonWriter jsonWr = tranReq.newReturnJsonWriter(true, null, null);
+
+ SMTAIServerApp.getApp().getDatasourceUsgaeToJson(jsonWr);
+
+ return tranReq.returnJson(jsonWr);
+ }
}
--
Gitblit v1.9.3