1 files changed, 4 insertions, 0 deletions
diff --git a/src/main/java/net/geedge/handler/SqlHandler.java b/src/main/java/net/geedge/handler/SqlHandler.java
index 84011fa..dc5bbae 100644
--- a/src/main/java/net/geedge/handler/SqlHandler.java
+++ b/src/main/java/net/geedge/handler/SqlHandler.java
@@ -348,4 +348,8 @@ public class SqlHandler {
         log.info("transfer alert message data Run Time:{}", sw.prettyPrint());
     }
 
+    public void dropTable() throws SQLException {
+        Resource classPathResource = new ClassPathResource("db/dropUseLessTable.sql");
+        ScriptUtils.executeSqlScript(dataSource.getConnection(), classPathResource);
+    }
 }