From 242f84dd49ac771e92d9d4fa9a52108a30d57982 Mon Sep 17 00:00:00 2001
From: yuxc <653031404@qq.com>
Date: 星期二, 05 九月 2023 13:08:50 +0800
Subject: [PATCH] 处理关键字段删除报错问题，进行转义
---
Source/UBCS/ubcs-service/ubcs-ddl/src/main/java/com/vci/ubcs/ddl/mapper/DdlDmMapper.java | 2 +-
Source/UBCS/ubcs-service/ubcs-ddl/src/main/java/com/vci/ubcs/ddl/processor/ddl/DdlMapperProcessor.java | 2 +-
2 files changed, 2 insertions(+), 2 deletions(-)
diff --git a/Source/UBCS/ubcs-service/ubcs-ddl/src/main/java/com/vci/ubcs/ddl/mapper/DdlDmMapper.java b/Source/UBCS/ubcs-service/ubcs-ddl/src/main/java/com/vci/ubcs/ddl/mapper/DdlDmMapper.java
index e19a148..fe85517 100644
--- a/Source/UBCS/ubcs-service/ubcs-ddl/src/main/java/com/vci/ubcs/ddl/mapper/DdlDmMapper.java
+++ b/Source/UBCS/ubcs-service/ubcs-ddl/src/main/java/com/vci/ubcs/ddl/mapper/DdlDmMapper.java
@@ -17,7 +17,7 @@
* @param columnName 鍒楀悕绉�
* @return 鍙楀奖鍝嶇殑琛屾暟
*/
- @Update("alter table ${tableName} DROP COLUMN ${columnName}")
+ @Update("alter table ${tableName} DROP COLUMN \"${columnName}\"")
@Override
int dropTableColumn(@Param("tableName")String tableName, @Param("columnName")String columnName);
diff --git a/Source/UBCS/ubcs-service/ubcs-ddl/src/main/java/com/vci/ubcs/ddl/processor/ddl/DdlMapperProcessor.java b/Source/UBCS/ubcs-service/ubcs-ddl/src/main/java/com/vci/ubcs/ddl/processor/ddl/DdlMapperProcessor.java
index 94a78d2..296c988 100644
--- a/Source/UBCS/ubcs-service/ubcs-ddl/src/main/java/com/vci/ubcs/ddl/processor/ddl/DdlMapperProcessor.java
+++ b/Source/UBCS/ubcs-service/ubcs-ddl/src/main/java/com/vci/ubcs/ddl/processor/ddl/DdlMapperProcessor.java
@@ -152,6 +152,6 @@
* @return 鍙楀奖鍝嶇殑琛屾暟
*/
public int dropTableColumn(String tableName,String columnName){
- return mapper.dropTableColumn(tableName,columnName);
+ return mapper.dropTableColumn(tableName,columnName.toUpperCase());
}
}
--
Gitblit v1.9.3