From 38e378391b355cc35d7c757956910abcc373b0d7 Mon Sep 17 00:00:00 2001
From: ZY <zc857179121@qq.com>
Date: 星期三, 18 九月 2024 13:59:00 +0800
Subject: [PATCH] 调整
---
src/main/java/com/zy/asrs/controller/StaDescController.java | 21 ++++++++++++++++++---
1 files changed, 18 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 e6030da..c743311 100644
--- a/src/main/java/com/zy/asrs/controller/StaDescController.java
+++ b/src/main/java/com/zy/asrs/controller/StaDescController.java
@@ -7,6 +7,7 @@
import com.baomidou.mybatisplus.plugins.Page;
import com.zy.asrs.entity.StaDesc;
import com.zy.asrs.entity.param.StaDescInitParam;
+import com.zy.asrs.mapper.StaDescMapper;
import com.zy.asrs.service.StaDescService;
import com.zy.common.web.BaseController;
import com.core.annotations.ManagerAuth;
@@ -14,6 +15,9 @@
import com.core.common.Cools;
import com.core.common.DateUtils;
import com.core.common.R;
+import org.apache.ibatis.session.ExecutorType;
+import org.apache.ibatis.session.SqlSession;
+import org.apache.ibatis.session.SqlSessionFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;
@@ -24,10 +28,13 @@
@Autowired
private StaDescService staDescService;
+ @Autowired
+ private SqlSessionFactory sqlSessionFactory;
@RequestMapping(value = "/staDesc/init/auth")
@ManagerAuth(memo = "鍒濆鍖栫珯鐐硅矾寰�")
public R init(StaDescInitParam param) {
+ SqlSession sqlSession = null;
try{
if (param.getTypeDesc()==1){
staDescService.delete(new EntityWrapper<>());
@@ -35,6 +42,8 @@
String[] startStaList = param.getStartStaList().split(";");
String[] endStaList = param.getEndStaList().split(";");
List<StaDesc> staDescList = new ArrayList<>();
+ sqlSession = sqlSessionFactory.openSession(ExecutorType.BATCH,false);
+ StaDescMapper sqlSessionMapper = sqlSession.getMapper(StaDescMapper.class);
for (String startSta : startStaList){
for (String endSta : endStaList){
for (Integer type:param.getType()){
@@ -55,13 +64,19 @@
staDesc.setModiTime(new Date());
staDesc.setAppeUser(getUserId());
staDesc.setAppeTime(new Date());
- staDescList.add(staDesc);
+ sqlSessionMapper.insert(staDesc);
+// staDescList.add(staDesc);
}
}
}
- staDescService.insertBatch(staDescList);
+ sqlSession.flushStatements();
+ sqlSession.clearCache();
+
+// staDescService.insertBatch(staDescList);
}catch (Exception e){
- return R.error();
+ return R.error(e.getMessage());
+ }finally {
+ sqlSession.close();
}
return R.ok("ok1").add("ok2");
--
Gitblit v1.9.1