新增流程节点进程查询接口

zhongrj

2023-09-17 8853292babb2ad94de4a3207966f1e83b767cd2d

 src/main/java/org/springblade/modules/FTP/FtpUtil.java

@@ -1,13 +1,15 @@
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;
import org.apache.commons.net.ftp.FTPClient;
import org.apache.commons.net.ftp.FTPReply;

import java.io.*;
import java.net.SocketException;
import java.util.Date;
import static org.springblade.common.config.FtpConfig.*;

/**
 * ftp工具类
@@ -283,4 +285,22 @@
      }
   }

   /**
    * 执行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, "w"+response1);
      FileInputStream in1 = null;
      try {
         in1 = new FileInputStream(new File(localPath + "w"+response1+".json"));
      } catch (FileNotFoundException e) {
         e.printStackTrace();
      }
      FtpUtil.uploadFile(ftpHost, ftpPort, ftpUserName, ftpPassword, ftpPath, "/",  "w"+response1+".json", in1);
      MysqlCenlint.deletess("w"+response1+".json");
   }

}