SFTPUtil

<dependency>
    <groupId>com.jcraft</groupId>
    <artifactId>jsch</artifactId>
</dependency>
package com.util;
 
import java.io.ByteArrayInputStream;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.InputStream;
import java.io.UnsupportedEncodingException;
import java.util.Iterator;
import java.util.Properties;
import java.util.Vector;
 
import org.apache.commons.io.IOUtils;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
 
import com.jcraft.jsch.Channel;
import com.jcraft.jsch.ChannelSftp;
import com.jcraft.jsch.JSch;
import com.jcraft.jsch.JSchException;
import com.jcraft.jsch.Session;
import com.jcraft.jsch.SftpException;
/**
 * 
 * @ClassName: SFTPUtil
 * @Description: sftp连接工具类
 * @date 2017年5月22日 下午11:17:21
 * @version 1.0.0
 */
public class SFTPUtil {
    
    private transient Logger log = LoggerFactory.getLogger(this.getClass());
    
    private ChannelSftp sftp;
      
    private Session session;
    /** FTP 登录用户名*/  
    private String username;
    /** FTP 登录密码*/  
    private String password;
    /** 私钥 */  
    private String privateKey;
    /** FTP 服务器地址IP地址*/  
    private String host;
    /** FTP 端口*/
    private int port;
      
  
    /** 
     * 构造基于密码认证的sftp对象 
     * @param userName 
     * @param password 
     * @param host 
     * @param port 
     */  
    public SFTPUtil(String username, String password, String host, int port) {
        this.username = username;
        this.password = password;
        this.host = host;
        this.port = port;
    }
  
    /** 
     * 构造基于秘钥认证的sftp对象
     * @param userName
     * @param host
     * @param port
     * @param privateKey
     */
    public SFTPUtil(String username, String host, int port, String privateKey) {
        this.username = username;
        this.host = host;
        this.port = port;
        this.privateKey = privateKey;
    }
  
    public SFTPUtil(){}
  
    /**
     * 连接sftp服务器
     *
     * @throws Exception 
     */
    public void login(){
        try {
            JSch jsch = new JSch();
            if (privateKey != null) {
                jsch.addIdentity(privateKey);// 设置私钥
                log.info("sftp connect,path of private key file:{}" , privateKey);
            }
            log.info("sftp connect by host:{} username:{}",host,username);
  
            session = jsch.getSession(username, host, port);
            log.info("Session is build");
            if (password != null) {
                session.setPassword(password);  
            }
            Properties config = new Properties();
            config.put("StrictHostKeyChecking", "no");
              
            session.setConfig(config);
            session.connect();
            log.info("Session is connected");
            
            Channel channel = session.openChannel("sftp");
            channel.connect();
            log.info("channel is connected");
  
            sftp = (ChannelSftp) channel;
            log.info(String.format("sftp server host:[%s] port:[%s] is connect successfull", host, port));
        } catch (JSchException e) {
            log.error("Cannot connect to specified sftp server : {}:{} \n Exception message is: {}", new Object[]{host, port, e.getMessage()});  
        }
    }  
  
    /**
     * 关闭连接 server 
     */
    public void logout(){
        if (sftp != null) {
            if (sftp.isConnected()) {
                sftp.disconnect();
                log.info("sftp is closed already");
            }
        }
        if (session != null) {
            if (session.isConnected()) {
                session.disconnect();
                log.info("sshSession is closed already");
            }
        }
    }
  
    /** 
     * 将输入流的数据上传到sftp作为文件 
     *  
     * @param directory 
     *            上传到该目录 
     * @param sftpFileName 
     *            sftp端文件名 
     * @param in 
     *            输入流 
     * @throws SftpException  
     * @throws Exception 
     */  
    public void upload(String directory, String sftpFileName, InputStream input) throws SftpException{
        try {  
            sftp.cd(directory);
        } catch (SftpException e) {
            log.warn("directory is not exist");
            sftp.mkdir(directory);
            sftp.cd(directory);
        }
        sftp.put(input, sftpFileName);
        log.info("file:{} is upload successful" , sftpFileName);
    }
  
    /** 
     * 上传单个文件
     *
     * @param directory 
     *            上传到sftp目录 
     * @param uploadFile
     *            要上传的文件,包括路径 
     * @throws FileNotFoundException
     * @throws SftpException
     * @throws Exception
     */
    public void upload(String directory, String uploadFile) throws FileNotFoundException, SftpException{
        File file = new File(uploadFile);
        upload(directory, file.getName(), new FileInputStream(file));
    }
  
    /**
     * 将byte[]上传到sftp,作为文件。注意:从String生成byte[]是,要指定字符集。
     * 
     * @param directory
     *            上传到sftp目录
     * @param sftpFileName
     *            文件在sftp端的命名
     * @param byteArr
     *            要上传的字节数组
     * @throws SftpException
     * @throws Exception
     */
    public void upload(String directory, String sftpFileName, byte[] byteArr) throws SftpException{
        upload(directory, sftpFileName, new ByteArrayInputStream(byteArr));
    }
  
    /** 
     * 将字符串按照指定的字符编码上传到sftp
     *  
     * @param directory
     *            上传到sftp目录
     * @param sftpFileName
     *            文件在sftp端的命名
     * @param dataStr
     *            待上传的数据
     * @param charsetName
     *            sftp上的文件,按该字符编码保存
     * @throws UnsupportedEncodingException
     * @throws SftpException
     * @throws Exception
     */
    public void upload(String directory, String sftpFileName, String dataStr, String charsetName) throws UnsupportedEncodingException, SftpException{  
        upload(directory, sftpFileName, new ByteArrayInputStream(dataStr.getBytes(charsetName)));  
    }
  
    /**
     * 下载文件 
     *
     * @param directory
     *            下载目录 
     * @param downloadFile
     *            下载的文件
     * @param saveFile
     *            存在本地的路径
     * @throws SftpException
     * @throws FileNotFoundException
     * @throws Exception
     */  
    public void download(String directory, String downloadFile, String saveFile) throws SftpException, FileNotFoundException{
        if (directory != null && !"".equals(directory)) {
            sftp.cd(directory);
        }
        File file = new File(saveFile);
        sftp.get(downloadFile, new FileOutputStream(file));
        log.info("file:{} is download successful" , downloadFile);
    }
    /** 
     * 下载文件
     * @param directory 下载目录
     * @param downloadFile 下载的文件名
     * @return 字节数组
     * @throws SftpException
     * @throws IOException
     * @throws Exception
     */
    public byte[] download(String directory, String downloadFile) throws SftpException, IOException{
        if (directory != null && !"".equals(directory)) {
            sftp.cd(directory);
        }
        InputStream is = sftp.get(downloadFile);
        
        byte[] fileData = IOUtils.toByteArray(is);
        
        log.info("file:{} is download successful" , downloadFile);
        return fileData;
    }
  
    /**
     * 删除文件
     *  
     * @param directory
     *            要删除文件所在目录
     * @param deleteFile
     *            要删除的文件
     * @throws SftpException
     * @throws Exception
     */
    public void delete(String directory, String deleteFile) throws SftpException{
        sftp.cd(directory);
        sftp.rm(deleteFile);
    }
    
    public void deleteDir(String directory) throws SftpException{
        sftp.rmdir(directory);
    }
    
  
    /**
     * 列出目录下的文件
     * 
     * @param directory
     *            要列出的目录
     * @param sftp
     * @return
     * @throws SftpException
     */
    public Vector<?> listFiles(String directory) throws SftpException {
        return sftp.ls(directory);
    }
    
    /**
     * 创建目录,如果存就不会创建
     * @param path 开头必须带/,结尾不能带/,否则后果自负
     * @throws SftpException
     * @throws IOException
     */
    public void mkdir(String path) throws SftpException {
	String pathArr[] = path.split("/");
	String p = "";
	for (int i = 1; i < pathArr.length; i++) {//0是空字符串,直接跳过
	    p += "/" + pathArr[i];
	    System.out.println(p);
	    try {
		sftp.cd(p);
	    }
	    catch (Exception e) {
		sftp.mkdir(p);
	    }
	}
    }
    
    //上传
    public void testUpload() throws Exception {
	SFTPUtil sftp = new SFTPUtil("vmuser", "Staryea!68", "192.168.2.172", 22);
    	sftp.login();
    	File file = new File("c:\\pom.txt");
    	InputStream is = new FileInputStream(file);
    	sftp.mkdir("/export/home/process/package/gatherPlug/base/a/b/c/d/e/f");
    	sftp.upload("/export/home/process/package/gatherPlug/base/a/b/c/d/e/f", "vvv", is);
	sftp.logout();
    }

    //下载
    public void testDownload() throws Exception {
	SFTPUtil sftp = new SFTPUtil("vmuser", "Staryea!68", "192.168.2.172", 22);
    	sftp.login();
    	byte[] b = sftp.download("/export/home/process/package/gatherPlug/base/b/v1.2", "22.conf");
    	System.out.println(new String(b));
    	sftp.logout();
    }

    //删除文件夹
    public void testDeleteDir() throws Exception {
	SFTPUtil sftp = new SFTPUtil("vmuser", "Staryea!68", "192.168.2.172", 22);
    	sftp.login();
    	
    	sftp.deleteDir("/export/home/process/package/gatherPlug/app/a6e03a7ca5754823aa1188a788126985/aa");
    	sftp.logout();
    }
    
    //获取文件夹中的文件
    @SuppressWarnings({ "rawtypes", "unchecked" })
    public void testListFiles() throws Exception {
	SFTPUtil sftp = new SFTPUtil("root", "xxxx", "127.0.0.1", 22);
    	sftp.login();
    	
    	Vector files = sftp.listFiles("/export/home/process/package/gatherPlug/app/a6e03a7ca5754823aa1188a788126985/uacpKafkaAnalyze");
    	for (Iterator<ChannelSftp.LsEntry> iterator = files.iterator(); iterator.hasNext();) {
            ChannelSftp.LsEntry str = iterator.next();
            String filename = str.getFilename();
            if (!filename.equals(".") && !filename.equals("..")) {
        	System.out.println(filename);
            }
    	}
    	sftp.logout();
    }
    
    public static void main(String[] args) throws Exception {
   	SFTPUtil sftp = new SFTPUtil();
   	sftp.testListFiles();
       }
}

 

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
<h1>上传/下载文件</h1> <form method="post" action="/file/upload" enctype="multipart/form-data"> <input type="file" name="file" id="fileInput"/> <input type="submit" value="上传" /> </form> <hr> <form method="post" action="/file/download" > <input type="text" name="fileName" placeholder="请输入文件名" /> <input type="submit" value="下载" id="downloadBtn" /> </form> public class SFTPUtil { private static final String host = "10.60.0.160"; private static final int port = 22; private static final String username = "root"; private static final String password = "Z20"; private static Session session = null; public static void connect() throws Exception { } public static void upload(MultipartFile file, String path, String fileName) throws Exception { } public static boolean download(HttpServletResponse response, String path, String fileName) throws Exception { } @Controller @RequestMapping("/file") public class FileController { private static final String UPLOAD_PATH = "/data/sftp/adtuser1/upload/winbidding/"; private static final String DOWNLOAD_PATH = "/data/sftp/adtuser1/upload/winbidding/"; @PostMapping("/upload") @ResponseBody public ModelAndView upload(@RequestParam("file") MultipartFile file) { } @PostMapping("/download") public ModelAndView download(@RequestParam("fileName") String fileName, HttpServletResponse response) throws Exception { } 数据库有host port username password UPLOAD_PATH DOWNLOAD_PATH csmc字段,把上边写死的改成数据库查询,前台页面增加csmc字段下拉框,根据csmc字段把查出来的配置数据完成上传下载功能,用的mysql数据库,把代码改好写出来
05-05
首先需要在数据库中创建一个表,用于存储SFTP连接的相关信息: ```sql CREATE TABLE sftp_config ( id INT PRIMARY KEY AUTO_INCREMENT, csmc VARCHAR(50), host VARCHAR(50), port INT, username VARCHAR(50), password VARCHAR(50), upload_path VARCHAR(255), download_path VARCHAR(255) ); ``` 然后在Spring Boot项目中创建一个SFTPUtil类,用于实现SFTP上传和下载功能: ```java import com.jcraft.jsch.*; import org.springframework.web.multipart.MultipartFile; import java.io.*; import java.util.Properties; public class SFTPUtil { private String host; private int port; private String username; private String password; private String uploadPath; private String downloadPath; private Session session; public SFTPUtil(String host, int port, String username, String password, String uploadPath, String downloadPath) { this.host = host; this.port = port; this.username = username; this.password = password; this.uploadPath = uploadPath; this.downloadPath = downloadPath; } public void connect() throws Exception { JSch jsch = new JSch(); session = jsch.getSession(username, host, port); session.setPassword(password); Properties config = new Properties(); config.put("StrictHostKeyChecking", "no"); session.setConfig(config); session.connect(); } public void upload(MultipartFile file, String fileName) throws Exception { ChannelSftp channel = (ChannelSftp) session.openChannel("sftp"); channel.connect(); channel.cd(uploadPath); InputStream inputStream = file.getInputStream(); channel.put(inputStream, fileName); inputStream.close(); channel.disconnect(); } public boolean download(HttpServletResponse response, String fileName) throws Exception { ChannelSftp channel = (ChannelSftp) session.openChannel("sftp"); channel.connect(); channel.cd(downloadPath); SftpATTRS attrs = channel.lstat(fileName); if (attrs == null) { channel.disconnect(); return false; } response.setHeader("Content-Disposition", "attachment; filename=\"" + fileName + "\""); OutputStream outputStream = response.getOutputStream(); channel.get(fileName, outputStream); outputStream.flush(); outputStream.close(); channel.disconnect(); return true; } } ``` 然后在Spring Boot项目中创建一个FileController类,用于处理文件上传和下载请求: ```java import org.springframework.beans.factory.annotation.Autowired; import org.springframework.jdbc.core.JdbcTemplate; import org.springframework.stereotype.Controller; import org.springframework.web.bind.annotation.*; import org.springframework.web.multipart.MultipartFile; import javax.servlet.http.HttpServletResponse; import java.util.List; import java.util.Map; @Controller @RequestMapping("/file") public class FileController { @Autowired private JdbcTemplate jdbcTemplate; @PostMapping("/upload") @ResponseBody public String upload(@RequestParam("file") MultipartFile file, @RequestParam("csmc") String csmc) { try { // 从数据库中获取SFTP连接配置信息 String sql = "SELECT * FROM sftp_config WHERE csmc = ?"; Map<String, Object> map = jdbcTemplate.queryForMap(sql, csmc); String host = (String) map.get("host"); int port = (int) map.get("port"); String username = (String) map.get("username"); String password = (String) map.get("password"); String uploadPath = (String) map.get("upload_path"); String fileName = file.getOriginalFilename(); // 使用SFTP上传文件 SFTPUtil sftpUtil = new SFTPUtil(host, port, username, password, uploadPath, null); sftpUtil.connect(); sftpUtil.upload(file, fileName); return "上传成功"; } catch (Exception e) { e.printStackTrace(); return "上传失败"; } } @PostMapping("/download") public void download(@RequestParam("fileName") String fileName, @RequestParam("csmc") String csmc, HttpServletResponse response) throws Exception { // 从数据库中获取SFTP连接配置信息 String sql = "SELECT * FROM sftp_config WHERE csmc = ?"; Map<String, Object> map = jdbcTemplate.queryForMap(sql, csmc); String host = (String) map.get("host"); int port = (int) map.get("port"); String username = (String) map.get("username"); String password = (String) map.get("password"); String downloadPath = (String) map.get("download_path"); // 使用SFTP下载文件 SFTPUtil sftpUtil = new SFTPUtil(host, port, username, password, null, downloadPath); sftpUtil.connect(); boolean result = sftpUtil.download(response, fileName); if (!result) { response.getWriter().write("文件不存在"); } } @GetMapping("/csmcList") @ResponseBody public List<String> getCsmcList() { // 从数据库中获取所有的csmc字段 String sql = "SELECT DISTINCT csmc FROM sftp_config"; List<String> csmcList = jdbcTemplate.queryForList(sql, String.class); return csmcList; } } ``` 最后,在HTML页面中加入下面的代码,即可实现文件上传和下载: ```html <h1>上传/下载文件</h1> <form method="post" action="/file/upload" enctype="multipart/form-data"> <input type="file" name="file" id="fileInput"/> <select name="csmc" id="csmcSelect"></select> <input type="submit" value="上传"/> </form> <hr> <form method="post" action="/file/download"> <input type="text" name="fileName" placeholder="请输入文件名"/> <select name="csmc" id="csmcSelect"></select> <input type="submit" value="下载" id="downloadBtn"/> </form> <script> // 获取csmc列表 $.get("/file/csmcList", function (data) { var csmcSelect = $("#csmcSelect"); for (var i = 0; i < data.length; i++) { var option = $("<option>").val(data[i]).text(data[i]); csmcSelect.append(option); } }); </script> ```

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值