From e71d3d823093bafe0283a57aa640928709d09434 Mon Sep 17 00:00:00 2001
From: ‘liusuyi’ <1951119284@qq.com>
Date: 星期一, 25 九月 2023 11:51:01 +0800
Subject: [PATCH] 优化sql框架使用mybatis-plus代替mybatis
---
src/main/java/com/ard/alarm/camera/service/impl/ArdCamerasServiceImpl.java | 38 ++++++++++++++------------------------
1 files changed, 14 insertions(+), 24 deletions(-)
diff --git a/src/main/java/com/ard/alarm/camera/service/impl/ArdCamerasServiceImpl.java b/src/main/java/com/ard/alarm/camera/service/impl/ArdCamerasServiceImpl.java
index 7513cd8..af9336f 100644
--- a/src/main/java/com/ard/alarm/camera/service/impl/ArdCamerasServiceImpl.java
+++ b/src/main/java/com/ard/alarm/camera/service/impl/ArdCamerasServiceImpl.java
@@ -12,6 +12,8 @@
import com.ard.alarm.external.domain.ArdEquipExternal;
import com.ard.alarm.external.mapper.ArdEquipExternalMapper;
import com.ard.utils.hiksdk.service.impl.HikClientUtil;
+import com.baomidou.mybatisplus.core.conditions.Wrapper;
+import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import lombok.extern.slf4j.Slf4j;
import org.springframework.boot.ApplicationArguments;
import org.springframework.boot.ApplicationRunner;
@@ -34,34 +36,31 @@
private final static ScheduledExecutorService scheduler = Executors.newScheduledThreadPool(1);
public static List<ArdCameras> ardCameraList = new ArrayList<>();
-
@Resource
private ArdCamerasMapper ardCamerasMapper;
+ //鍒濆鍖栨墽琛�
@Override
public void run(ApplicationArguments args) {
//鍔犺浇sdk搴�
HikClientUtil.loadHCNetSDKLib();
//鑾峰彇灏忓厜鐢靛皾璇曠櫥褰�
- ArdCameras ardCamera=new ArdCameras();
- ardCamera.setGdtype("0");
- ardCameraList = ardCamerasMapper.selectArdCamerasList(ardCamera);
+ ardCameraList = selectArdCamerasList(new ArdCameras());
HikClientUtil.loginAllCamera(ardCameraList);
- syncTask();
+ syncCameraListTask();
}
/**
- * 鍚屾浠诲姟
+ * 鍚屾鐩告満鍒楄〃浠诲姟
+ * 瀹炴椂鑾峰彇鍦ㄧ嚎鐨勫皬鍏夌數
* 鍒樿嫃涔�
* 2023/8/11 9:09:27
*/
- private void syncTask() {
+ private void syncCameraListTask() {
scheduler.scheduleAtFixedRate(() -> {
try {
//region 瀹氭椂鍚屾灏忓厜鐢�
- ArdCameras ardCamera=new ArdCameras();
- ardCamera.setGdtype("0");
- List<ArdCameras> newArdCameraList = ardCamerasMapper.selectArdCamerasList(ardCamera);
+ List<ArdCameras> newArdCameraList = selectArdCamerasList(new ArdCameras());
//闇�瑕佹洿鏂扮殑鏁版嵁
List<ArdCameras> updateList = sameListWithDifferent(ardCameraList, newArdCameraList);
if (updateList.size() > 0) {
@@ -94,25 +93,16 @@
}
/**
- * 鏌ヨ鐩告満璁惧
- *
- * @param id 鐩告満璁惧涓婚敭
- * @return 鐩告満璁惧
- */
- @Override
- public ArdCameras selectArdCamerasById(String id) {
- return ardCamerasMapper.selectArdCamerasById(id);
- }
-
- /**
* 鏌ヨ鐩告満璁惧鍒楄〃
*
- * @param ardCameras 鐩告満璁惧
+ * @param ardCamera 鐩告満璁惧
* @return 鐩告満璁惧
*/
@Override
- public List<ArdCameras> selectArdCamerasList(ArdCameras ardCameras) {
- return ardCamerasMapper.selectArdCamerasList(ardCameras);
+ public List<ArdCameras> selectArdCamerasList(ArdCameras ardCamera) {
+ ardCamera.setGdType("0");
+ Wrapper<ArdCameras> queryWrapper=new QueryWrapper<>(ardCamera);
+ return ardCamerasMapper.selectList(queryWrapper);
}
--
Gitblit v1.9.3