SFTP工具类
package com.fastech.monitor_ui.util;
import java.io.BufferedReader;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.io.InputStreamReader;
import java.lang.reflect.Field;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import java.util.Map;
import java.util.zip.GZIPInputStream;
import org.apache.commons.collections.map.HashedMap;
import org.apache.http.client.HttpClient;
import org.apache.http.client.methods.HttpPost;
import org.apache.http.impl.client.DefaultHttpClient;
import com.fastech.util.SftpConnection;
import com.fastech.util.SftpConnectionPool;
import com.jcraft.jsch.ChannelSftp;
import sun.net.ftp.impl.FtpClient;
public class ReadFileData {
/**
* 链接服务器
* */
public String connectServer(String ip, int port, String user, String password, String path,String filename){
SftpConnectionPool sftpPool = SftpConnectionPool.getInstance();
SftpConnection sftpConnection = sftpPool.getFtpConnecttion(ip,user,password,port);
ChannelSftp sftp = (ChannelSftp) sftpConnection.getChannel();
String result=null;
String ss=null;
String pathgen=System.getProperty("user.dir");
String saveFile=pathgen+"\\upload";
//String saveFile="upload";
try {
sftpConnection.download(path, filename, saveFile, sftp);
//result=readFile(saveFile+"\\"+filename);
deleteFile(saveFile+"\\"+filename);
//ss=sftpConnection.loadStream2String(path,filename, sftp);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return result;
//return null;
}
public void deleteFile(String pash){
// 根据路径获取文件对象
File file = new File(pash);
// 判断文件是否存在
if (file.exists()) {
// 文件删除
file.delete();
}
}
public List<Map<String, Object>> putInStrage(String result,Class<?> classname) throws FileNotFoundException{
//String result=readFile(urlString);
String[] dataline=result.split("\n");
List<Map<String, Object>> listmap=new ArrayList<Map<String,Object>>();
List<String> resultlist=getField(classname);
for(int i=0;i<dataline.length;i++){
if(dataline[i].length()!=0&&dataline[i]!=null&&!"".equals(dataline[i].trim())){
Map<String, Object> mapp=new HashedMap();
String [] datastring=dataline[i].split("@#");
for(int j=0;j<datastring.length&&j<resultlist.size();j++){
mapp.put(resultlist.get(j),datastring[j]);
}
listmap.add(mapp);
}else{
continue;
}
}
return listmap;
}
public void getFiel(String logString){
String path="192.168.0.204";
HttpClient client =new DefaultHttpClient();
HttpPost post=new HttpPost(path);
}
FtpClient ftpClient;
/**
* connectServer
* 连接ftp服务器
* @throws java.io.IOException
* @param path 文件夹，空代表根目录
* @param password 密码
* @param user 登陆用户
* @param server 服务器地址
*/
/*public void connectServer(String server, String user, String password, String path)
throws IOException
{
// server：FTP服务器的IP地址；user:登录FTP服务器的用户名
// password：登录FTP服务器的用户名的口令；path：FTP服务器上的路径
ftpClient = new FtpClient();
ftpClient.openServer(server);
ftpClient.login(user, password);
//path是ftp服务下主目录的子目录
if (path.length() != 0) ftpClient.cd(path);
//用2进制上传、下载
ftpClient.binary();
}
*/
private Object getValue(String fieldname,String value, Class<?> classname) {
Object valuetype=value;
Class c=classname;
Field field = null;
try {
field = c.getDeclaredField(fieldname.toUpperCase());
} catch (NoSuchFieldException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
} catch (SecurityException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}//获取字段
String type = field.getGenericType().toString();
if (type.equals("class java.lang.String")){
field.setAccessible(true);
if(value!=null){
valuetype = value.replaceAll("\r|\n", "");
}else{
valuetype=value;
}
}else if(type.equals("int")){
if(value == null||value.trim().length()==0){
value = "0";
}
field.setAccessible(true);
valuetype=Integer.valueOf(value);
}else if(type.equals("long")){
if(value == null||value.trim().length()==0){
value = "0";
}
field.setAccessible(true);
valuetype=Long.valueOf(value.trim());//为字段赋值
}else if("double".equals(type)){
if(value == null||value.trim().length()==0){
value = "0";
}
field.setAccessible(true);
valuetype=Double.valueOf(value);
}else if(type.equals("class java.util.Date")){
Date date = new Date();
if(value==null||value.trim().length()==0){
date = null;
}else{
value = value.replaceAll("\n","");
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
field.setAccessible(true);
try {
date = sdf.parse(value.trim());
} catch (ParseException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
valuetype=date;//为字段赋值
}
return valuetype;
}
public List<String> getField(Class<?> classname){
List<String> resultlist=new ArrayList<>();
Field[] fields=classname.getDeclaredFields( );
for ( Field field : fields ){
resultlist.add(field.getName()) ;
}
return resultlist;
}
// public static void main(String[] args) throws IOException, ClassNotFoundException {
// /*ReadFileData rfd=new ReadFileData();
// String path="upload/d_rnt_irm_iv_mscpool_d_20170619000000_20170619000000-0.csv";
// rfd.putInStrage(path,D_RNT_IRM_IV_MSCPOOL_D.class);*/
// //rfd.getField(D_RNT_IRM_IV_MSCPOOL_D.class);
// /*String path="upload/d_rnt_irm_iv_hlr_d_20170619000000_20170619000000-0.csv.gz";
// ReadFileData rfd=new ReadFileData();
// String result=rfd.readFile(path);
// System.out.println(result);*/
// //String ss=";;;;";
// //String logstring="2017-06-23 12:08:18.994 DEBUG 24818 --- [nio-8022-exec-1] c.f.monitor.controller.AlarmController : msgContentBody is: {"DataCatalog":"d.rnt.irm.iv.hlr.d","SystemID":"ODC","SessionID":"d491c7d0-b2a7-47f4-a56c-2cc9d037f84e","ConnectionString":"ftp://gxpt:dnt@123@10.78.134.83:21/","Path":"/ds/re/ba/exchange","userName":"gxpt","password":"dnt@123","FileList":"d_rnt_irm_iv_hlr_d_20170623000000_20170623000000-0.csv.gz","files":[{"recordCount":15,"FileSize":17059,"fileName":"d_rnt_irm_iv_hlr_d_20170623000000_20170623000000-0.csv.gz","IsCompressed":"true","FieldSeparator":"@#"}]}";
// //System.out.println(ss.split(";").length);
// //Map<String,Object> logstring1="{'DataCatalog':'d.rnt.irm.iv.hlr.d','SystemID':'ODC','SessionID':'b376a80d-ba9d-4935-b997-f6a3157b9257','ConnectionString':'ftp://gxpt:dnt@123@10.78.134.83:21/','Path':'/ds/re/ba/exchange','userName':'gxpt','password':'dnt@123','FileList':'d_rnt_irm_iv_hlr_d_20170623000000_20170623000000-end.csv.gz','files':[{'recordCount':0,'FileSize':0,'fileName':'d_rnt_irm_iv_hlr_d_20170623000000_20170623000000-end.csv.gz','IsCompressed':'true','FieldSeparator':'@#'}]}";
// //String logstring="{'DataCatalog':'d.rnt.irm.iv.hlr.d','SystemID':'ODC','SessionID':'b376a80d-ba9d-4935-b997-f6a3157b9257','ConnectionString':'192.168.0.205','Path':'/ds/re/ba/exchange','userName':'root','password':'fastech!QAZ','FileList':'d_rnt_irm_iv_hlr_d_20170619000000_20170619000000-0.csv.gz','files':[{'recordCount':0,'FileSize':0,'fileName':'d_rnt_irm_iv_hlr_d_20170623000000_20170623000000-end.csv.gz','IsCompressed':'true','FieldSeparator':'@#'}]}";
// /*String[] mapString=logstring.split(",");
// List<Map<String, String>> listmap=new ArrayList<>();
// Map<String,String> strMap=new HashMap<>();
// for(int i=0;i<mapString.length;i++){
// String[] string=mapString[i].split(":");
// strMap.put(string[0],string[1]);
// }*/
// String logstring="{'DataCatalog':'d.rnt.irm.iv.hlr.d','SystemID':'ODC','SessionID':'b376a80d-ba9d-4935-b997-f6a3157b9257','ConnectionString':'192.168.0.205','Path':'/ds/re/ba/exchange','userName':'root','password':'fastech!QAZ','FileList':'d_rnt_irm_iv_hlr_d_20170619000000_20170619000000-0.csv.gz','files':[{'recordCount':0,'FileSize':0,'fileName':'d_rnt_irm_iv_hlr_d_20170623000000_20170623000000-end.csv.gz','IsCompressed':'true','FieldSeparator':'@#'}]}";
// Map<String,Object> strMap=new HashMap<>();
// strMap=JsonUtil.jsonToMap(logstring);
// String ip=strMap.get("ConnectionString").toString();
// String username=strMap.get("userName").toString();
// String password=strMap.get("password").toString();
// String path="/data"+strMap.get("Path").toString();
// String filename=strMap.get("FileList").toString();
// if(filename.endsWith("-0.csv.gz")){
// String classname=filename.substring(0,filename.length()-39).toUpperCase();
// Class clazz = Class.forName("D_RNT_IRM_IV_HLR_D");
// int port=22;
// ReadFileData rfd=new ReadFileData();
// String result=rfd.connectServer(ip,port,username, password, path,filename);
// rfd.putInStrage(result, clazz);
// }
//
// // List<Map<String, Object>> files=(List<Map<String, Object>>) strMap.get("files");
// //String fieldSeparator=strMap.get("files").toString();
// System.out.println(ip+"\n"+username+"\n"+password+"\n"+path+"\n"+filename);
// /*ReadFileData rfd=new ReadFileData();
// String ip="192.168.0.205";
// String username="root";
// String password="fastech!QAZ";
// String path="/data/ds/re/ba/exchange";
// String filename="d_rnt_irm_iv_hlr_d_20170619000000_20170619000000-0.csv.gz";
// int port=22;
// rfd.connectServer(ip,port,username, password, path,filename);*/
//
// }
}
