From ea2ce207cb45501831436c405df8c0ad4be35497 Mon Sep 17 00:00:00 2001
From: whycxzp <perryhsu@163.com>
Date: 星期二, 13 七月 2021 09:52:20 +0800
Subject: [PATCH] 更新表是否存在校验
---
src/main/java/com/whyc/service/ClearTableService.java | 18 ++++++++++++++++++
1 files changed, 18 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/whyc/service/ClearTableService.java b/src/main/java/com/whyc/service/ClearTableService.java
index 2e4efef..0a23b3d 100644
--- a/src/main/java/com/whyc/service/ClearTableService.java
+++ b/src/main/java/com/whyc/service/ClearTableService.java
@@ -130,6 +130,24 @@
tableList.add(new TableDTO("web_site","tb_devtmp_record"));
tableList.add(new TableDTO("web_site","tb_stationtraffic"));
+ //杩涜涓�娆¤繃婊�,鏌ヨ鍑烘潵鎵�鏈夌殑搴撲腑琛�
+ List<TableDTO> tableList2 = mapper.findAllTables();
+ for (int i = 0; i < tableList.size(); i++) {
+ boolean compareFlag = false;
+ for (int j = 0; j < tableList2.size(); j++) {
+ if((tableList.get(i).getDbName()+tableList.get(i).getTableName())
+ .equals(tableList2.get(j).getDbName()+tableList2.get(j).getTableName())){
+ compareFlag = true;
+ break;
+ }
+ }
+ //鍖归厤ok
+ if(!compareFlag){
+ tableList.remove(i);
+ i--;
+ }
+ }
+
mapper.clearTable(tableList);
}
--
Gitblit v1.9.1