From 7ff441cde857c41ae9908100de9c469ed5ab76be Mon Sep 17 00:00:00 2001
From: zc <zc>
Date: 星期一, 29 七月 2024 19:11:56 +0800
Subject: [PATCH] 视图sql
---
src/main/java/com/zy/asrs/controller/StaDescController.java | 10 +++++++---
1 files changed, 7 insertions(+), 3 deletions(-)
diff --git a/src/main/java/com/zy/asrs/controller/StaDescController.java b/src/main/java/com/zy/asrs/controller/StaDescController.java
index c39a65e..c743311 100644
--- a/src/main/java/com/zy/asrs/controller/StaDescController.java
+++ b/src/main/java/com/zy/asrs/controller/StaDescController.java
@@ -34,6 +34,7 @@
@RequestMapping(value = "/staDesc/init/auth")
@ManagerAuth(memo = "鍒濆鍖栫珯鐐硅矾寰�")
public R init(StaDescInitParam param) {
+ SqlSession sqlSession = null;
try{
if (param.getTypeDesc()==1){
staDescService.delete(new EntityWrapper<>());
@@ -41,7 +42,7 @@
String[] startStaList = param.getStartStaList().split(";");
String[] endStaList = param.getEndStaList().split(";");
List<StaDesc> staDescList = new ArrayList<>();
- SqlSession sqlSession = sqlSessionFactory.openSession(ExecutorType.BATCH,false);
+ sqlSession = sqlSessionFactory.openSession(ExecutorType.BATCH,false);
StaDescMapper sqlSessionMapper = sqlSession.getMapper(StaDescMapper.class);
for (String startSta : startStaList){
for (String endSta : endStaList){
@@ -68,11 +69,14 @@
}
}
}
- sqlSession.commit();
- sqlSession.close();
+ sqlSession.flushStatements();
+ sqlSession.clearCache();
+
// staDescService.insertBatch(staDescList);
}catch (Exception e){
return R.error(e.getMessage());
+ }finally {
+ sqlSession.close();
}
return R.ok("ok1").add("ok2");
--
Gitblit v1.9.1