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/DdlMSMapper.java | 126 ++++++++++++++++++++++++++++++++++++++++++
1 files changed, 126 insertions(+), 0 deletions(-)
diff --git a/Source/UBCS/ubcs-service/ubcs-ddl/src/main/java/com/vci/ubcs/ddl/mapper/DdlMSMapper.java b/Source/UBCS/ubcs-service/ubcs-ddl/src/main/java/com/vci/ubcs/ddl/mapper/DdlMSMapper.java
new file mode 100644
index 0000000..316ee29
--- /dev/null
+++ b/Source/UBCS/ubcs-service/ubcs-ddl/src/main/java/com/vci/ubcs/ddl/mapper/DdlMSMapper.java
@@ -0,0 +1,126 @@
+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: SqlServer鏁版嵁搴撴搷浣滅被
+ *
+ * @author LiHang
+ * @date 2023/4/24
+ */
+@Repository
+public interface DdlMSMapper extends DdlMapper{
+
+ /**
+ * 鍚戞暟鎹簱琛ㄤ腑娣诲姞鍗曚釜瀛楁
+ * @param tableName 琛ㄦ牸鐨勫悕绉�
+ * @param attributeSql 瑕佹坊鍔犵殑鏂扮殑sql
+ * @return 褰卞搷鐨勮鏁�
+ */
+ @Update("alter table ${tableName} add ${attributeSql} ")
+ @ResultType(Integer.class)
+ @Override
+ int addColumn2TableBySql(@Param("tableName") String tableName, @Param("attributeSql") String attributeSql);
+
+ /**
+ * 鍗曚釜淇敼鏁版嵁琛ㄧ殑瀛楁
+ * @param tableName 琛ㄦ牸鐨勫悕绉�
+ * @param attributeSql 灞炴�ф柊鐨剆ql
+ * @return 褰卞搷鐨勮鏁�
+ */
+ @Update("alter table ${tableName} ALTER COLUMN ${attributeSql} ")
+ @ResultType(Integer.class)
+ @Override
+ int modifyTableBySql(@Param("tableName") String tableName, @Param("attributeSql") String attributeSql);
+
+ /**
+ * 鍒犻櫎琛ㄦ牸
+ * @param tableName 琛ㄦ牸鍚嶇О
+ * @return 褰卞搷鐨勮鏁�
+ */
+ @Update("drop table if exists ${tableName}")
+ @ResultType(Integer.class)
+ @Override
+ int dropTable(@Param("tableName") String tableName);
+
+ /**
+ * 鏍￠獙鏁版嵁搴撹〃鎴栬�呰鍥炬槸鍚﹀瓨鍦�--ms sql
+ * @param tableName 琛ㄦ牸鍚嶇О
+ * @return 瀛樺湪鐨勪釜鏁�
+ */
+ @Select("select count(name) from sysobjects where type in ('U','V') and upper(name) = upper(#{tableName,jdbcType=VARCHAR})")
+ @ResultType(Integer.class)
+ @Override
+ int checkTableExist(@Param("tableName") String tableName);
+
+ /**
+ * 鏌ヨ琛ㄦ牸鐨勫瓧娈典俊鎭�--sql server
+ * @param tableName 琛ㄦ牸鐨勫悕绉�
+ * @return 鏁版嵁搴撹〃鐨勫瓧娈典俊鎭�
+ */
+ List<DdlTableInDataBaseBO> selectTableColumnInfo(@Param("tableName") String tableName);
+
+ /**
+ * 鍒犻櫎琛ㄦ牸涓殑鍒�
+ * @param tableName 琛ㄥ悕绉�
+ * @param columnName 鍒楀悕绉�
+ * @return 鍙楀奖鍝嶇殑琛屾暟
+ */
+ @Override
+ int dropTableColumn(@Param("tableName")String tableName, @Param("columnName")String columnName);
+
+
+ /**
+ * 鑾峰彇鎵�鏈夌殑琛ㄦ牸鍚嶇О
+ * @return 琛ㄦ牸鍚嶇О
+ */
+ @Select("select name from sysobjects where type in ('U','V')")
+ List<String> selectAllTableName();
+
+ /**
+ * 鏌ヨ琛ㄦ牸鐨勪腑鏂囧悕绉�
+ * @param tableName 琛ㄦ牸鍚嶇О
+ * @return 琛ㄦ牸鍚嶇О鍜岃〃鏍间腑鏂囧悕绉�
+ */
+ DdlTableBO selectTableComment(@Param("tableName")String tableName);
+
+
+ /**
+ * 鍒涘缓鏁版嵁搴撹〃
+ * @param tableName 琛ㄦ牸鐨勫悕绉�
+ * @param attributeSql 灞炴�х殑sql
+ * @return 褰卞搷鐨勮鏁�
+ */
+ @Update("create table ${tableName} ( ${attributeSql} )")
+ @ResultType(Integer.class)
+ @Override
+ 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)
+ @Override
+ 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)
+ @Override
+ int commentColumnTable(@Param("tableName") String tableName,@Param("columnName")String columnName, @Param("comment") String comment);
+}
--
Gitblit v1.9.3