From d2570148ec3884de3af721bd99c4b7acbbdee075 Mon Sep 17 00:00:00 2001
From: 田源 <lastanimals@163.com>
Date: 星期二, 09 五月 2023 17:07:26 +0800
Subject: [PATCH] 前端代码提交
---
Source/UBCS/ubcs-service/ubcs-ddl/src/main/java/com/vci/ubcs/ddl/processor/ddl/DdlMySqlMapperProcessor.java | 73 ++++++++++++++++++++++++++++++++++++
1 files changed, 73 insertions(+), 0 deletions(-)
diff --git a/Source/UBCS/ubcs-service/ubcs-ddl/src/main/java/com/vci/ubcs/ddl/processor/ddl/DdlMySqlMapperProcessor.java b/Source/UBCS/ubcs-service/ubcs-ddl/src/main/java/com/vci/ubcs/ddl/processor/ddl/DdlMySqlMapperProcessor.java
new file mode 100644
index 0000000..d7e8ca5
--- /dev/null
+++ b/Source/UBCS/ubcs-service/ubcs-ddl/src/main/java/com/vci/ubcs/ddl/processor/ddl/DdlMySqlMapperProcessor.java
@@ -0,0 +1,73 @@
+package com.vci.ubcs.ddl.processor.ddl;
+
+
+import com.vci.ubcs.ddl.mapper.DdlMapper;
+import com.vci.ubcs.ddl.mapper.DdlMySqlMapper;
+import com.vci.ubcs.starter.util.VciSpringUtil;
+import com.vci.ubcs.starter.web.util.VciBaseUtil;
+import org.springframework.stereotype.Component;
+import org.springframework.stereotype.Repository;
+import org.springframework.util.CollectionUtils;
+
+import javax.annotation.PostConstruct;
+import javax.annotation.Resource;
+import java.util.List;
+
+/**
+ * Description:MySql鐨勬暟鎹簱鎿嶄綔
+ *
+ * @author LiHang
+ * @date 2023/4/24
+ */
+@Component
+public class DdlMySqlMapperProcessor extends DdlMapperProcessor{
+
+ private static DdlMapper mapper = VciSpringUtil.getBean(DdlMySqlMapper.class);
+
+ public DdlMySqlMapperProcessor() {
+ super(mapper);
+ System.out.println("-----------------");
+ if (mapper != null){
+ System.out.println("[success]::鍔犺浇MySql鏁版嵁搴揇DL鎿嶄綔鏈嶅姟鎴愬姛");
+ }else {
+ System.out.println("[fail]::鍔犺浇MySql鏁版嵁搴揇DL鎿嶄綔鏈嶅姟澶辫触");
+ }
+ }
+
+ @Override
+ public boolean support(String url) {
+ return "com.mysql.cj.jdbc.Driver".equals(url);
+ }
+
+ @Override
+ public void modifyTableBySqlBase(String tableName, String attributeSql) {
+ StringBuilder sb = new StringBuilder();
+ List<String> modifyColumnSqlList = VciBaseUtil.str2List(attributeSql);
+ if (!CollectionUtils.isEmpty(modifyColumnSqlList)) {
+ modifyColumnSqlList.stream().forEach(s -> {
+ sb.append(SPACE).append("modify").append(SPACE).append(s).append(SPACE).append(",");
+ });
+ }
+ modifyTableBySql(tableName,sb.substring(0, sb.lastIndexOf(",")));
+ }
+
+ /**
+ * 鍚戞暟鎹簱琛ㄤ腑娣诲姞鍗曚釜瀛楁
+ *
+ * @param tableName 琛ㄦ牸鐨勫悕绉�
+ * @param attributeSql 瑕佹坊鍔犵殑鏂扮殑sql
+ * @return 褰卞搷鐨勮鏁�
+ */
+ @Override
+ public int addColumn2TableBySql(String tableName, String attributeSql) {
+ StringBuilder sb = new StringBuilder();
+ List<String> modifyColumnSqlList = VciBaseUtil.str2List(attributeSql);
+ if (!CollectionUtils.isEmpty(modifyColumnSqlList)) {
+ modifyColumnSqlList.stream().forEach(s -> {
+ sb.append(SPACE).append("add").append(SPACE).append(s).append(SPACE).append(",");
+ });
+ return mapper.addColumn2TableBySql(tableName, sb.substring(0, sb.lastIndexOf(",")));
+ }
+ return 0;
+ }
+}
--
Gitblit v1.9.3