首頁 > 軟體

java讀取ftp中TXT檔案的案例

2020-09-24 06:00:54

最近在開發關於java讀取ftp中TXT檔案,其中有些坑踩了一下,再次做個記錄

1、讀取檔案時我會根據檔名稱去生成資料庫表,oracle資料庫對於表名的長度是有限制的,最多30個字元

2、對於多個檔案的ftp的讀取,每次獲取檔案後再次回去檔案的流會為空,即在迴圈中多次根據ftp獲取檔案的流

當出現這種情況時,需要在迴圈時每次開啟和關閉ftp的連結即可解決,否則在第二次獲取的時候inputsteam為null

3、讀取txt檔案時,如果檔案中包含中文,進行讀取時可能會出現亂碼,這是可設定讀取的字元集為UTF-8,如果不行,再試試

GB2312

4、java讀取TXT檔案:

InputStreamReader reader = new InputStreamReader(is, "GB2312");
BufferedReader br = new BufferedReader(reader);
String lineTxt = null; //每行資料
int rowNum = 0;
while ((lineTxt = br.readLine()) != null) {}

補充知識:Java實現從FTP獲取檔案下載到本地,並讀取檔案中的內容的成功方法

我就廢話不多說了,大家還是直接看程式碼吧~

package com.aof.web.servlet;
import java.io.BufferedReader;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.InputStreamReader;
import java.io.OutputStream;
import javax.jws.WebService;
import org.apache.commons.net.ftp.FTPClient;
import org.apache.commons.net.ftp.FTPFile;
@WebService(endpointInterface="com.aof.web.servlet.QualityComplainServices")
public class QualityComplainServicesImpl implements QualityComplainServices {
 //ftp物件
  private FTPClient ftp;
  //需要連線到的ftp端的ip
  private String ip = "10.46.249.7";
  //連線埠,預設21
  private int port = 21;
  //要連線到的ftp端的名字
  private String name = "DKEDI";
  //要連線到的ftp端的對應得密碼
  private String pwd = "P@ssw0rd";  
  
 //呼叫此方法,輸入對應得ip,埠,要連線到的ftp端的名字,要連線到的ftp端的對應得密碼。連線到ftp物件,並驗證登入進入fto
  public boolean ftp1() {
    ftp = new FTPClient();
    try {
//     ftp.connect(ip, port);
     if(!ftp.isConnected()){
     ftp.connect(ip, port);
   }
      System.out.println(ftp.login(name, pwd));
//     ftp.setCharset(Charset.forName("UTF-8"));
      ftp.setControlEncoding("UTF-8");
      return true;
    } catch (IOException e) {
      e.printStackTrace();
      return true;
    }
    
  }
  
  public void disconnect() throws Exception {
 if (ftp.isConnected()) {
  ftp.disconnect();
 }
 }
  
 // 下載檔案到本地
 public boolean download(FTPFile file) throws Exception {
  boolean result = true;
  // 本地檔案路徑
  File f = new File("E:crmFiles");
  if (!f.exists()) {
  f.getParentFile().mkdirs();
  }
  long lRemoteSize = file.getSize();
  try {// 下載過的不在下載了
  OutputStream out = new FileOutputStream(f);
  if (f.length() >= lRemoteSize) {
   System.out.println("~~~~~~~~~~~~~~~~~~~~~~~~本地已經存在,下載中止");
   out.flush();
   out.close();
  }
  boolean iss = ftp.retrieveFile(file.getName(), out);
  System.out.println("~~~~~~~~~~~~~~~~~~~~~~~~下載成功rn");
  out.close();
  } catch (Exception ex) {
  ex.printStackTrace();
  System.out.println("~~~~~~~~~~~~~~~~~~~~~~~~下載失敗rn");
  return false;
  }
  return result;
 }
 
 private InputStreamReader read;
 private BufferedReader reader;
 
 private String preRead(String filepath) throws Exception {
 File file = new File(filepath);
 String ordertype = null;
 if (file.isFile() && file.exists()) {
  try {
  read = new InputStreamReader(new FileInputStream(file), "GBK");
  reader = new BufferedReader(read);
  StringBuffer FileContent = new StringBuffer();
  String temp = null;
  while ((temp = reader.readLine()) != null) {
   FileContent.append(temp);
  }
  System.out.println("訂單內容為------------------>>>>> "+FileContent+" <<<<<------------------");
  } catch (FileNotFoundException e) {
  System.out.println("!!!!!!!!!!!!!!!!!沒有找到合適的訂單資訊!!!!!!!!!!!!!!!");
  e.printStackTrace();
  } finally {
  reader.close();
  read.close();
//  file.delete();
  }
 }
 return ordertype;
 }
  
  public void gmRead(String remote) throws Exception {
   boolean downloadResult = false;
 try {
  ftp.changeWorkingDirectory(remote);
  System.out.println("遠端路徑為*************************"+remote);
  FTPFile[] files = ftp.listFiles(remote); // 通過路徑得到檔案
  System.out.println("檔案數量為*************************"+files.length);
  for (int i = 0; i < files.length; i++) {
  FTPFile file = files[i];
  if (file.isFile()) {
   downloadResult = this.download(file);// 下載檔案 到本地讀取路徑
   if (downloadResult) {
   String ordertype = this.preRead("E:crmFiles");
   }
   /*//讀取檔案內容,將內容存資料庫
   InputStreamReader isr = new InputStreamReader(new FileInputStream(file), "utf-8");
   BufferedReader br = new BufferedReader(isr);
   String lineTxt = null;
   while ((lineTxt = br.readLine()) != null) {
   lineTxt+=lineTxt;
   }
   System.out.println(lineTxt);
   br.close();*/
  }else{
   System.out.println("************* 檔案不存在 ************");
  }
  }
 } catch (Exception e) {
  e.printStackTrace();
 }
 }
  
 @Override
 public String threeDAndEightDReports(String orderNum, String FTPUrl, String FileType) {
 //抱怨單號、FTP地址、3D/8D檔案型別
 System.out.println("1-------------"+orderNum);
 System.out.println("2-------------"+FTPUrl);
 System.out.println("3-------------"+FileType);
 if(null != orderNum && null != FTPUrl && null != FileType){
  //連線FTP
  boolean flag = this.ftp1();
  if(flag){
  try {
   //獲取檔案、解析檔案內容,進庫操作
   this.gmRead(FTPUrl);
   // 關閉連線
   this.disconnect();
  } catch (Exception e) {
   e.printStackTrace();
  }
  }else{
  System.out.println("!!!!!!!!!!!!!!!!!FTP連線失敗!!!!!!!!!!!!!!!!!");
  }
  
  return "success";
 }else{
  return "fail";
 }
 } 
 
 public static void main(String[] args) {
 QualityComplainServicesImpl q = new QualityComplainServicesImpl();
 q.threeDAndEightDReports("001","/CRMINTERFACE","3D");
 } 
}

以上這篇java讀取ftp中TXT檔案的案例就是小編分享給大家的全部內容了,希望能給大家一個參考,也希望大家多多支援it145.com。


IT145.com E-mail:sddin#qq.com