From 4b4d5ef35c5a1db827db52bb448d7c5d56bf41e8 Mon Sep 17 00:00:00 2001
From: zyx <zyx123456>
Date: 星期一, 29 一月 2024 09:46:09 +0800
Subject: [PATCH] 修复卡顿Bug
---
src/main/java/com/zy/asrs/task/handler/ErrorStockHandler.java | 25 +++++--------------------
1 files changed, 5 insertions(+), 20 deletions(-)
diff --git a/src/main/java/com/zy/asrs/task/handler/ErrorStockHandler.java b/src/main/java/com/zy/asrs/task/handler/ErrorStockHandler.java
index 1a2cbb9..d398f8f 100644
--- a/src/main/java/com/zy/asrs/task/handler/ErrorStockHandler.java
+++ b/src/main/java/com/zy/asrs/task/handler/ErrorStockHandler.java
@@ -1,22 +1,19 @@
package com.zy.asrs.task.handler;
-import com.zy.asrs.entity.LocMast;
import com.zy.asrs.service.LocMastService;
import com.zy.asrs.task.AbstractHandler;
import com.zy.asrs.task.core.ReturnT;
+import lombok.extern.slf4j.Slf4j;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Service;
-import org.springframework.transaction.annotation.Transactional;
import org.springframework.transaction.interceptor.TransactionAspectSupport;
-
-import java.util.List;
-import java.util.Map;
/**
* Created by vincent on 2020/7/7
*/
@Service
+@Slf4j
public class ErrorStockHandler extends AbstractHandler<String> {
@Autowired
@@ -24,23 +21,11 @@
@Autowired
private LocMastService locMastService;
- @Transactional
+ //@Transactional
public ReturnT<String> start() {
try {
- String sql = "SELECT distinct a.loc_no as locNo FROM asr_loc_mast a,asr_loc_detl b where a.loc_no=b.loc_no and (a.loc_sts ='O' or a.loc_sts ='D')";
- List<Map<String, Object>> result = jdbcTemplate.queryForList(sql);
- if (!result.isEmpty()) {
- for (Map<String, Object> map : result) {
-
- LocMast locMast = locMastService.selectByLoc(map.get("locNo").toString());
- if (!locMast.getLocSts().equals("O")){
- continue;
- }
-
- int delCount = jdbcTemplate.update("delete from asr_loc_detl where loc_no=?;", map.get("locNo"));
- System.out.println(delCount);
- }
- }
+ int update = jdbcTemplate.update("DELETE asr_loc_detl FROM asr_loc_detl JOIN asr_loc_mast ON asr_loc_detl.loc_no = asr_loc_mast.loc_no WHERE asr_loc_mast.loc_sts = 'O'");
+ log.info("(ErrorStockHandler)鍒犻櫎鏉℃暟涓猴紱" + update);
} catch (Exception e) {
e.printStackTrace();
TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
--
Gitblit v1.9.1