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/mapper/DdlMySqlMapper.java | 119 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 119 insertions(+), 0 deletions(-)
diff --git a/Source/UBCS/ubcs-service/ubcs-ddl/src/main/java/com/vci/ubcs/ddl/mapper/DdlMySqlMapper.java b/Source/UBCS/ubcs-service/ubcs-ddl/src/main/java/com/vci/ubcs/ddl/mapper/DdlMySqlMapper.java
new file mode 100644
index 0000000..561e833
--- /dev/null
+++ b/Source/UBCS/ubcs-service/ubcs-ddl/src/main/java/com/vci/ubcs/ddl/mapper/DdlMySqlMapper.java
@@ -0,0 +1,119 @@
+package com.vci.ubcs.ddl.mapper;
+
+import com.vci.ubcs.ddl.bo.DdlTableBO;
+import com.vci.ubcs.ddl.bo.DdlTableInDataBaseBO;
+import org.apache.ibatis.annotations.*;
+import org.springframework.stereotype.Repository;
+
+import java.util.List;
+
+/**
+ * Description: MySql鏁版嵁搴撴搷浣滅被
+ *
+ * @author LiHang
+ * @date 2023/4/24
+ */
+@Repository
+public interface DdlMySqlMapper extends DdlMapper{
+ /**
+ * 鍒涘缓鏁版嵁搴撹〃
+ * @param tableName 琛ㄦ牸鐨勫悕绉�
+ * @param attributeSql 灞炴�х殑sql
+ * @return 褰卞搷鐨勮鏁�
+ */
+ @Update("create table ${tableName} ( ${attributeSql} )")
+ @ResultType(Integer.class)
+ int createTableBySql(@Param("tableName") String tableName, @Param("attributeSql") String attributeSql);
+
+ /**
+ * 涓鸿〃鏍兼坊鍔犳敞閲婂唴瀹�
+ * @param tableName 琛ㄦ牸鐨勫悕绉�
+ * @param comment 娉ㄩ噴鐨勫唴瀹�
+ * @return 鍙楀奖鍝嶇殑琛屾暟
+ */
+ @Update("COMMENT ON TABLE ${tableName} IS '${comment}' ")
+ @ResultType(Integer.class)
+ int commentTable(@Param("tableName") String tableName, @Param("comment") String comment);
+
+
+ /**
+ * 涓鸿〃鏍肩殑鍒楁坊鍔犳敞閲婂唴瀹�
+ * @param tableName 琛ㄦ牸鐨勫悕绉�
+ * @param columnName 鍒�
+ * @param comment 娉ㄩ噴鐨勫唴瀹�
+ * @return 鍙楀奖鍝嶇殑琛屾暟
+ */
+ @Update("COMMENT ON column ${tableName}.${columnName} IS '${comment}' ")
+ @ResultType(Integer.class)
+ int commentColumnTable(@Param("tableName") String tableName,@Param("columnName")String columnName, @Param("comment") String comment);
+
+
+ /**
+ * 鎵归噺淇敼鏁版嵁搴撶殑瀛楁--
+ * @param tableName 琛ㄦ牸鐨勫悕绉�
+ * @param attributeSql 灞炴�ф柊鐨剆ql
+ * @return 褰卞搷鐨勮鏁�
+ */
+ @Update("alter table ${tableName} ${attributeSql} ")
+ @ResultType(Integer.class)
+ int modifyTableBySql(@Param("tableName") String tableName, @Param("attributeSql") String attributeSql);
+
+ /**
+ * 鍚戞暟鎹簱琛ㄤ腑鎵归噺娣诲姞瀛楁
+ * @param tableName 琛ㄦ牸鐨勫悕绉�
+ * @param attributeSql 瑕佹坊鍔犵殑鏂扮殑sql
+ * @return 褰卞搷鐨勮鏁�
+ */
+ @Update("alter table ${tableName} ${attributeSql} ")
+ @ResultType(Integer.class)
+ int addColumn2TableBySql(@Param("tableName") String tableName, @Param("attributeSql") String attributeSql);
+
+ /**
+ * 鍒犻櫎琛ㄦ牸
+ * @param tableName 琛ㄦ牸鍚嶇О
+ * @return 褰卞搷鐨勮鏁�
+ */
+ @Update("drop table if exists ${tableName}")
+ @ResultType(Integer.class)
+ int dropTable(@Param("tableName") String tableName);
+
+ /**
+ * 鏍￠獙鏁版嵁搴撹〃鎴栬�呰鍥�
+ * @param tableName 琛ㄦ牸鍚嶇О
+ * @return 瀛樺湪鐨勪釜鏁�
+ */
+ @Select("use information_scheam;select count(table_name) from tables where table_name = #{tableName,jdbcType=VARCHAR}")
+ @ResultType(Integer.class)
+ int checkTableExist(@Param("tableName") String tableName);
+
+ /**
+ * 鏌ヨ琛ㄦ牸鐨勫瓧娈典俊鎭�--sql server
+ * @param tableName 琛ㄦ牸鐨勫悕绉�
+ * @return 鏁版嵁搴撹〃鐨勫瓧娈典俊鎭�
+ */
+ List<DdlTableInDataBaseBO> selectTableColumnInfo(@Param("tableName")String tableName);
+
+ /**
+ * 鍒犻櫎琛ㄦ牸涓殑鍒�
+ * @param tableName 琛ㄥ悕绉�
+ * @param columnName 鍒楀悕绉�
+ * @return 鍙楀奖鍝嶇殑琛屾暟
+ */
+ int dropTableColumn(@Param("tableName")String tableName, @Param("columnName")String columnName);
+
+
+ /**
+ * 鑾峰彇鎵�鏈夌殑琛ㄦ牸鍚嶇О
+ * @return 琛ㄦ牸鍚嶇О
+ */
+ @Select("use information_scheam;select table_name from tables")
+ List<String> selectAllTableName();
+
+ /**
+ * 鏌ヨ琛ㄦ牸鐨勪腑鏂囧悕绉�
+ * @param tableName 琛ㄦ牸鍚嶇О
+ * @return 琛ㄦ牸鍚嶇О鍜岃〃鏍间腑鏂囧悕绉�
+ */
+ DdlTableBO selectTableComment(@Param("tableName")String tableName);
+
+}
--
Gitblit v1.9.3