package com.sinosoft.mis.service;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.InputStream;
import java.io.OutputStream;
import java.nio.charset.Charset;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.Enumeration;
import java.util.List;
import java.util.Map;
import java.util.zip.ZipEntry;
import java.util.zip.ZipFile;
import javax.servlet.http.HttpServletRequest;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import com.jcraft.jsch.ChannelSftp;
import com.jcraft.jsch.Session;
import com.sinosoft.cms.common.util.SFTPUtil;
import com.sinosoft.cms.common.util.SystemParameters;
import com.sinosoft.transverse.common.Data;
public class Jun implements JunService {
private static Workbook wb;
private static ChannelSftp sftp;
private static Session session;
/** SFTP 登录用户名*/
private static String username;
/** SFTP 登录密码*/
private static String password;
/** 私钥 */
private static String privateKey;
/** SFTP 服务器地址IP地址*/
private static String host;
/** SFTP 端口*/
private static int port;
/**
* 下载文件
* @return
*/
public String downloadFile(){
Map params = Data.getParametersFromRequest(super.getRequest());
String ftpPathHead = SystemParameters.FTPpath;//FTP文件服务器基础路径
String ftpPathTail = (String) params.get("ftpPath");//FTP基础路径后路径
String ftpPath = ftpPathHead+ftpPathTail;//
ftpPath = ftpPath.replaceAll("//", "/");//FTP储存文件路径
String rootPath = super.getRequest().getSession().getServletContext().getRealPath("/");//项目根目录
String downloadPath = rootPath+"downloadFile/";
String returnPath = SFTPUtil.downloadFile(ftpPath,downloadPath);
returnPath = returnPath.substring(returnPath.lastIndexOf("vehiclesMIS"));
StringBuffer requestURL = super.getRequest().getRequestURL();
String url = requestURL.substring(0, requestURL.indexOf("vehiclesMIS"))+returnPath;
url = url.replaceAll("\\\\", "/");
StringBuffer sb = new StringBuffer();
sb.append("
sb.append("window.locati