From e567d284a005086e549ccd3b38b8a8e760517a88 Mon Sep 17 00:00:00 2001
From: jiangping <jp@doumee.com>
Date: 星期二, 12 十一月 2024 09:26:10 +0800
Subject: [PATCH] 最新版本541200007
---
server/visits/admin_timer/src/main/java/com/doumee/api/DatabaseController.java | 35 +++++++++++++++++++++++++++++++----
1 files changed, 31 insertions(+), 4 deletions(-)
diff --git a/server/visits/admin_timer/src/main/java/com/doumee/api/DatabaseController.java b/server/visits/admin_timer/src/main/java/com/doumee/api/DatabaseController.java
index e2c58ae..eeb60bf 100644
--- a/server/visits/admin_timer/src/main/java/com/doumee/api/DatabaseController.java
+++ b/server/visits/admin_timer/src/main/java/com/doumee/api/DatabaseController.java
@@ -18,10 +18,11 @@
import java.io.File;
import java.io.IOException;
import java.io.InputStreamReader;
-import java.util.ArrayList;
-import java.util.Collections;
-import java.util.Comparator;
-import java.util.List;
+import java.sql.Connection;
+import java.sql.DriverManager;
+import java.sql.Statement;
+import java.text.SimpleDateFormat;
+import java.util.*;
/**
* @author 姹熻箘韫�
@@ -75,10 +76,36 @@
deleteOldFiles(path,7);//淇濈暀鏈�杩�7涓枃浠�
} catch (Exception e) {
e.printStackTrace();
+
log.error("鏁版嵁搴撳浠藉け璐�."+e.getMessage());
}
return ApiResponse.failed("鏁版嵁搴撳浠藉け璐�" );
}
+ public void run() {
+ SimpleDateFormat dateFormat = new SimpleDateFormat("yyyyMMddHHmmss");
+ String currentDateTime = dateFormat.format(new Date());
+ String fileName = "backup_" + currentDateTime + ".sql";
+
+ try {
+ Class.forName("com.mysql.cj.jdbc.Driver");
+ Connection connection = DriverManager.getConnection("localhost:3306/antaiwuliu", "root", "Atwl@2024");
+ Statement statement = connection.createStatement();
+
+ String query = "SELECT * INTO OUTFILE '" + fileName + "' FROM your_table";
+ statement.execute(query);
+
+ System.out.println("Database backup successful to " + fileName);
+
+ statement.close();
+ connection.close();
+ } catch (Exception e) {
+ e.printStackTrace();
+ }
+ }
+
+ public static void main(String[] args) {
+ new DatabaseController().run();;
+ }
static class ProcessHandleRunnable implements Runnable {
private Process process;
--
Gitblit v1.9.3