From 83d6be1ca1ee0197993e76e46d4e99e805c057b0 Mon Sep 17 00:00:00 2001
From: lty <876263681@qq.com>
Date: 星期五, 14 三月 2025 09:30:04 +0800
Subject: [PATCH] #初始化
---
src/main/java/com/zy/asrs/controller/StaDescController.java | 24 +++++++++++++++---------
1 files changed, 15 insertions(+), 9 deletions(-)
diff --git a/src/main/java/com/zy/asrs/controller/StaDescController.java b/src/main/java/com/zy/asrs/controller/StaDescController.java
index c743311..15b5713 100644
--- a/src/main/java/com/zy/asrs/controller/StaDescController.java
+++ b/src/main/java/com/zy/asrs/controller/StaDescController.java
@@ -18,6 +18,8 @@
import org.apache.ibatis.session.ExecutorType;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
+import org.slf4j.Logger;
+import org.slf4j.LoggerFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;
@@ -25,6 +27,7 @@
@RestController
public class StaDescController extends BaseController {
+ private static final Logger log = LoggerFactory.getLogger(StaDescController.class);
@Autowired
private StaDescService staDescService;
@@ -34,7 +37,6 @@
@RequestMapping(value = "/staDesc/init/auth")
@ManagerAuth(memo = "鍒濆鍖栫珯鐐硅矾寰�")
public R init(StaDescInitParam param) {
- SqlSession sqlSession = null;
try{
if (param.getTypeDesc()==1){
staDescService.delete(new EntityWrapper<>());
@@ -42,7 +44,7 @@
String[] startStaList = param.getStartStaList().split(";");
String[] endStaList = param.getEndStaList().split(";");
List<StaDesc> staDescList = new ArrayList<>();
- sqlSession = sqlSessionFactory.openSession(ExecutorType.BATCH,false);
+ SqlSession sqlSession = sqlSessionFactory.openSession(ExecutorType.BATCH,false);
StaDescMapper sqlSessionMapper = sqlSession.getMapper(StaDescMapper.class);
for (String startSta : startStaList){
for (String endSta : endStaList){
@@ -64,24 +66,28 @@
staDesc.setModiTime(new Date());
staDesc.setAppeUser(getUserId());
staDesc.setAppeTime(new Date());
- sqlSessionMapper.insert(staDesc);
// staDescList.add(staDesc);
+ sqlSessionMapper.insert(staDesc);
+
}
}
}
- sqlSession.flushStatements();
- sqlSession.clearCache();
-
+ try{
+ sqlSession.commit();
+ sqlSession.close();
+ }catch (Exception e){
+ log.error("鍒濆鍖栫珯鐐硅矾寰勫紓甯�===>sql寮傚父锛歿}",e.getMessage());
+ }
// staDescService.insertBatch(staDescList);
}catch (Exception e){
- return R.error(e.getMessage());
- }finally {
- sqlSession.close();
+ log.error("鍒濆鍖栫珯鐐硅矾寰勫紓甯革細{}",e.getMessage());
+ return R.error("鍒濆鍖栫珯鐐硅矾寰勫紓甯革細"+e.getMessage());
}
return R.ok("ok1").add("ok2");
}
+
@RequestMapping(value = "/staDesc/{id}/auth")
@ManagerAuth
public R get(@PathVariable("id") String id) {
--
Gitblit v1.9.1