From 03b5cb36312b2cc4fadf5cc8b4a47b8616e464b6 Mon Sep 17 00:00:00 2001
From: tangzy <tangzy123456>
Date: Fri, 27 Aug 2021 17:07:24 +0800
Subject: [PATCH] 1.心里咨询

---
 src/main/java/org/springblade/modules/FTP/FtpUtil.java |   21 +++++++++++++++++++++
 1 files changed, 21 insertions(+), 0 deletions(-)

diff --git a/src/main/java/org/springblade/modules/FTP/FtpUtil.java b/src/main/java/org/springblade/modules/FTP/FtpUtil.java
index 03c1f99..c5c19ea 100644
--- a/src/main/java/org/springblade/modules/FTP/FtpUtil.java
+++ b/src/main/java/org/springblade/modules/FTP/FtpUtil.java
@@ -1,5 +1,6 @@
 package org.springblade.modules.FTP;
 
+import com.alibaba.fastjson.JSON;
 import org.apache.commons.logging.Log;
 import org.apache.commons.logging.LogFactory;
 import org.apache.commons.net.ftp.FTP;
@@ -8,6 +9,10 @@
 
 import java.io.*;
 import java.net.SocketException;
+import java.util.Date;
+
+import static org.springblade.common.constant.FtpConstant.*;
+import static org.springblade.common.constant.FtpConstant.ftpPath;
 
 /**
  * ftp工具类
@@ -282,5 +287,21 @@
 			}
 		}
 	}
+	/**
+	 * 执行sql 上传
+	 * @param s1 sql
+	 */
+	public static void sqlFileUpload(String s1){
+		String json1 = JSON.toJSONString(s1);
+		String response1 = String.valueOf((new Date()).getTime());
+		OutJson.createJsonFile(json1, localPath, "n"+response1);
+		FileInputStream in1 = null;
+		try {
+			in1 = new FileInputStream(new File(localPath + "n"+response1+".json"));
+		} catch (FileNotFoundException e) {
+			e.printStackTrace();
+		}
+		FtpUtil.uploadFile(ftpHost_dev, ftpPort, ftpUserName, ftpPassword, ftpPath, "/",  "n"+response1+".json", in1);
+	}
 
 }

--
Gitblit v1.9.3