1 files changed, 24 insertions, 0 deletions
diff --git a/src/main/java/com/mesasoft/cn/dao/sqlprovider/CommonSqlProvider.java b/src/main/java/com/mesasoft/cn/dao/sqlprovider/CommonSqlProvider.java
new file mode 100644
index 0000000..ad2d024
--- /dev/null
+++ b/src/main/java/com/mesasoft/cn/dao/sqlprovider/CommonSqlProvider.java
@@ -0,0 +1,24 @@
+package com.mesasoft.cn.dao.sqlprovider;
+
+import org.apache.ibatis.jdbc.SQL;
+
+/**
+ * @author pantao
+ * @since 2018/1/19
+ */
+public class CommonSqlProvider {
+
+    private CommonSqlProvider() {}
+
+    public static String updateAuthById(String table) {
+        return new SQL() {{
+            UPDATE(table);
+            SET("is_downloadable=#{isDownloadable}");
+            SET("is_uploadable=#{isUploadable}");
+            SET("is_deletable=#{isDeletable}");
+            SET("is_updatable=#{isUpdatable}");
+            SET("is_visible=#{isVisible}");
+            WHERE("id=#{id}");
+        }}.toString();
+    }
+}