From ae0dc4f46b075b5eace5596a66f6b81e357ae05e Mon Sep 17 00:00:00 2001
From: ludc
Date: 星期二, 03 十二月 2024 17:24:06 +0800
Subject: [PATCH] 码值codeallcode查重改成一句分批次查询(500)一次执行查询改为and拼接的依据sql查询。
---
Source/UBCS/ubcs-service/ubcs-ddl/src/main/java/com/vci/ubcs/ddl/processor/dll/DllMapperProcessor.java | 13 ++-----------
1 files changed, 2 insertions(+), 11 deletions(-)
diff --git a/Source/UBCS/ubcs-service/ubcs-ddl/src/main/java/com/vci/ubcs/ddl/processor/dll/DllMapperProcessor.java b/Source/UBCS/ubcs-service/ubcs-ddl/src/main/java/com/vci/ubcs/ddl/processor/dll/DllMapperProcessor.java
index eab3885..7e4ee9d 100644
--- a/Source/UBCS/ubcs-service/ubcs-ddl/src/main/java/com/vci/ubcs/ddl/processor/dll/DllMapperProcessor.java
+++ b/Source/UBCS/ubcs-service/ubcs-ddl/src/main/java/com/vci/ubcs/ddl/processor/dll/DllMapperProcessor.java
@@ -16,6 +16,7 @@
import java.util.ArrayList;
import java.util.Collection;
import java.util.List;
+import java.util.Locale;
/**
* Description:DLL鐨勫鐞嗘帴鍙�
@@ -87,47 +88,37 @@
return mapper.createViewBySql(viewCreateSql);
}
-
public int createTableBySql(String tableName, String attributeSql) {
return mapper.createTableBySql(tableName, attributeSql);
}
-
public int commentTable(String tableName, String comment) {
return mapper.commentTable(tableName, comment);
}
-
public int commentColumnTable(String tableName, String columnName, String comment) {
return mapper.commentColumnTable(tableName, columnName, comment);
}
-
public int modifyTableBySql(String tableName, String attributeSql) {
return mapper.modifyTableBySql(tableName, attributeSql);
}
-
public int addColumn2TableBySql(String tableName, String attributeSql) {
return mapper.addColumn2TableBySql(tableName, attributeSql);
}
-
public int dropTable(String tableName) {
return mapper.dropTable(tableName);
}
-
public int checkTableExist(String tableName) {
return mapper.checkTableExist(tableName);
}
-
public int countAll(String tableName) {
return mapper.countAll(tableName);
}
-
-
/**
* 鑾峰彇瀛楁鍒涘缓sql
@@ -143,7 +134,7 @@
}
mappingBO.setNullable(attributeVO.isNullableFlag());
mappingBO.setDefaultValue(attributeVO.getDefaultValue());
- return mappingBO.toString() + (StringUtil.equals(attributeVO.getId(),"OID") ? StringPool.SPACE + "primary key" + StringPool.SPACE : "");
+ return mappingBO.toString() + (StringUtil.equals(attributeVO.getId().toLowerCase(Locale.ROOT),"OID".toLowerCase(Locale.ROOT)) ? StringPool.SPACE + "primary key" + StringPool.SPACE : "");
}
--
Gitblit v1.9.3