From 6cd2d32a724d7c3414e00a0866acf45ade2e5bfe Mon Sep 17 00:00:00 2001
From: zjh <1084500556@qq.com>
Date: 星期二, 29 七月 2025 17:40:49 +0800
Subject: [PATCH] zjh20250729-1
---
ltkj-admin/src/main/java/com/ltkj/web/controller/his/HisApiGetMethodService.java | 28 ++++++++++++++++------------
1 files changed, 16 insertions(+), 12 deletions(-)
diff --git a/ltkj-admin/src/main/java/com/ltkj/web/controller/his/HisApiGetMethodService.java b/ltkj-admin/src/main/java/com/ltkj/web/controller/his/HisApiGetMethodService.java
index 9aa67d2..7103967 100644
--- a/ltkj-admin/src/main/java/com/ltkj/web/controller/his/HisApiGetMethodService.java
+++ b/ltkj-admin/src/main/java/com/ltkj/web/controller/his/HisApiGetMethodService.java
@@ -91,7 +91,7 @@
try {
Class.forName("com.mysql.cj.jdbc.Driver");
} catch (ClassNotFoundException e) {
- e.printStackTrace();
+ log.error(String.valueOf(e),e.getMessage());
}
// try {
// InputStreamReader reader = new InputStreamReader(new FileInputStream(url), StandardCharsets.UTF_8);
@@ -236,6 +236,7 @@
for (Object resultDatum : resultData) {
JSONObject object = (JSONObject) resultDatum;
ajaxResult = save(object, type,hisApiConfig,JSONUtil.toJsonStr(params));
+// save(object, type,hisApiConfig,JSONUtil.toJsonStr(params));
Map<String, String> map = new HashMap<>();
for (String key : object.keySet()) {
String defaultVal = object.get(key).toString();
@@ -251,7 +252,7 @@
}
} catch (Exception e) {
// throw new RuntimeException(e);
- log.error(String.valueOf(e));
+ log.error(String.valueOf(e),e.getMessage());
return AjaxResult.error();
}
}
@@ -335,16 +336,18 @@
try {
creatTable(object, tabName, connection);
} catch (SQLException e) {
- e.printStackTrace();
- return AjaxResult.error();
+ log.error(String.valueOf(e),e.getMessage());
+// return AjaxResult.error();
}
}
//鎻掑叆鏁版嵁
try {
+ //TODO 鎶ラ敊
+ // 17:05:33.949 [http-nio-5000-exec-15] ERROR c.l.w.c.h.HisApiGetMethodService - [save,347] - java.sql.SQLDataException: Value '4294967295' is outside of valid range for type java.lang.Integer
operationTable(object,connection,hisApiConfig,paramsJson,code);
} catch (SQLException e) {
- e.printStackTrace();
- return AjaxResult.error();
+ log.error(String.valueOf(e),e.getMessage());
+// return AjaxResult.error();
}finally {
try {
connection.close();
@@ -480,7 +483,7 @@
String key = entry.getKey().trim().toLowerCase();
if (StrUtil.isBlank(defaultVal) || defaultVal.equals("null"))
continue;
- String val = defaultVal.trim().replaceAll("\\s+", "");
+ String val = defaultVal.trim().replaceAll("\\s+", "").replaceAll("[^\\x00-\\x7F]", "");
if (primaryKesList.contains(key)) {
deleteSqlBuilder.append(key).append(" = '").append(val).append("' and ");
}
@@ -502,9 +505,9 @@
}
deleteSqlBuilder.delete(deleteSqlBuilder.length() - 5, deleteSqlBuilder.length());
Statement statement = connection.prepareStatement(deleteSqlBuilder.toString());
- log.info("HIS鏁版嵁淇濆瓨绫� 鎵ц鍒犻櫎 ->{}",deleteSqlBuilder.toString());
+// log.info("HIS鏁版嵁淇濆瓨绫� 鎵ц鍒犻櫎 ->{}",deleteSqlBuilder.toString());
int i = statement.executeUpdate(deleteSqlBuilder.toString());
- log.info("HIS鏁版嵁淇濆瓨绫� 鍒犻櫎鏉℃暟 ->{}",i);
+// log.info("HIS鏁版嵁淇濆瓨绫� 鍒犻櫎鏉℃暟 ->{}",i);
statement.close();
insertSqlBuilder.append("insert_time, ");
insertSqlBuilder.append("request_params, ");
@@ -542,11 +545,11 @@
// break;
// }
statement = connection.createStatement();
- log.info("HIS鏁版嵁淇濆瓨绫� 鎵ц鎻掑叆 ->{}",insertSqlBuilder.toString());
+// log.info("HIS鏁版嵁淇濆瓨绫� 鎵ц鎻掑叆 ->{}",insertSqlBuilder.toString());
boolean execute = statement.execute(insertSqlBuilder.toString());
if (!execute){
int updateCount = statement.getUpdateCount();
- log.info("HIS鏁版嵁淇濆瓨绫� 鎵ц鎻掑叆鎴愬姛 褰卞搷琛屾暟->{}",updateCount);
+// log.info("HIS鏁版嵁淇濆瓨绫� 鎵ц鎻掑叆鎴愬姛 褰卞搷琛屾暟->{}",updateCount);
}
statement.close();
}
@@ -682,8 +685,9 @@
statement.close();
return next;
} catch (SQLException throwables) {
- throwables.printStackTrace();
+ log.error(String.valueOf(throwables),throwables.getMessage());
}
+ log.error("鏌ヨ琛ㄦ墽琛宻ql杩斿洖涓簄ull ->{},{},{}",tabSql,DB_NAME,tableName);
return null;
}
--
Gitblit v1.8.0