From ab2cece286ca61cc126e41ae75428a7865484ade Mon Sep 17 00:00:00 2001
From: zhaowenxuan <chacca165@163.com>
Date: 星期三, 31 七月 2024 10:56:51 +0800
Subject: [PATCH] 修改数据插入
---
ltkj-admin/src/main/java/com/ltkj/web/controller/his/HisApiGetMethodService.java | 33 +++++++++++++++++++++++++--------
1 files changed, 25 insertions(+), 8 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 6d1c214..d85acb7 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
@@ -14,6 +14,7 @@
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.factory.annotation.Value;
import org.springframework.stereotype.Component;
+import org.springframework.transaction.annotation.Propagation;
import org.springframework.transaction.annotation.Transactional;
import java.io.FileInputStream;
@@ -202,7 +203,7 @@
}
}
- @Transactional
+ @Transactional(propagation = Propagation.REQUIRES_NEW)
public AjaxResult getHISDataNew(String type, Map<String, Object> params){
LambdaQueryWrapper<HisApiConfig> lambdaQueryWrapper = new LambdaQueryWrapper<>();
lambdaQueryWrapper.eq(HisApiConfig::getApiMethod, type);
@@ -264,10 +265,11 @@
} catch (SQLException e) {
e.printStackTrace();
return AjaxResult.error();
- }
- try {
- connection.close();
- } catch (SQLException ignored) {
+ }finally {
+ try {
+ connection.close();
+ } catch (SQLException ignored) {
+ }
}
return AjaxResult.success();
}
@@ -407,9 +409,9 @@
}
deleteSqlBuilder.delete(deleteSqlBuilder.length() - 5, deleteSqlBuilder.length());
Statement statement = connection.prepareStatement(deleteSqlBuilder.toString());
-// log.info("鎵ц鍒犻櫎 ->{}",deleteSqlBuilder.toString());
+ log.info("HIS鏁版嵁淇濆瓨绫� 鎵ц鍒犻櫎 ->{}",deleteSqlBuilder.toString());
int i = statement.executeUpdate(deleteSqlBuilder.toString());
-// log.info("鍒犻櫎鏉℃暟 ->{}",i);
+ log.info("HIS鏁版嵁淇濆瓨绫� 鍒犻櫎鏉℃暟 ->{}",i);
statement.close();
insertSqlBuilder.append("insert_time, ");
insertSqlBuilder.append("request_params, ");
@@ -436,8 +438,23 @@
insertSqlBuilder.append(") values (").append(valueBuilder).append(")");
// log.info("鎵ц鎻掑叆 ->{}",insertSqlBuilder.toString());
// 鎻掑叆鏁版嵁
+// boolean execute = statement.execute(insertSqlBuilder.toString());
+// for (int j = 0; j < 10; j++) {
+// statement = connection.createStatement();
+// log.info("HIS鏁版嵁淇濆瓨绫� 鎵ц鎻掑叆 ->{}",insertSqlBuilder.toString());
+// boolean execute = statement.execute(insertSqlBuilder.toString());
+// log.info("HIS鏁版嵁淇濆瓨绫� 鎵ц鎻掑叆鐘舵�� ->{},娆℃暟->{}",execute,(j+1));
+// statement.close();
+// if (execute)
+// break;
+// }
statement = connection.createStatement();
- statement.execute(insertSqlBuilder.toString());
+ log.info("HIS鏁版嵁淇濆瓨绫� 鎵ц鎻掑叆 ->{}",insertSqlBuilder.toString());
+ boolean execute = statement.execute(insertSqlBuilder.toString());
+ if (!execute){
+ int updateCount = statement.getUpdateCount();
+ log.info("HIS鏁版嵁淇濆瓨绫� 鎵ц鎻掑叆鎴愬姛 褰卞搷琛屾暟->{}",updateCount);
+ }
statement.close();
}
--
Gitblit v1.8.0