java读取ftp中TXT文件的案例
作者:zhang06105586 时间:2022-07-07 20:10:11
最近在开发关于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("~~~~~~~~~~~~~~~~~~~~~~~~下载成功\r\n");
out.close();
} catch (Exception ex) {
ex.printStackTrace();
System.out.println("~~~~~~~~~~~~~~~~~~~~~~~~下载失败\r\n");
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");
}
}
来源:https://blog.csdn.net/zhang06105586/article/details/105410803
标签:java,ftp,TXT
![](/images/zang.png)
![](/images/jiucuo.png)
猜你喜欢
超简洁java实现双色球若干注随机号码生成(实例代码)
2023-12-03 22:39:08
![](https://img.aspxhome.com/file/2023/9/91119_0s.png)
Kotlin协程概念原理与使用万字梳理
2023-03-28 21:29:32
![](https://img.aspxhome.com/file/2023/7/94287_0s.png)
SpringBoot 3.0 新特性内置声明式HTTP客户端实例详解
2022-11-25 13:47:20
![](https://img.aspxhome.com/file/2023/9/84289_0s.png)
Logback 使用TurboFilter实现日志级别等内容的动态修改操作
2022-06-10 04:17:53
springboot自动扫描添加的BeanDefinition源码实例详解
2023-11-24 15:15:22
![](https://img.aspxhome.com/file/2023/3/59943_0s.png)
ChatGPT介绍及Java API调用
2021-07-06 07:53:55
Springboot集成spring data elasticsearch过程详解
2023-04-16 00:42:16
![](https://img.aspxhome.com/file/2023/4/70484_0s.png)
Spring如何基于注解配置使用ehcache
2022-08-16 03:24:32
修改idea的这些启动参数,令你的idea健步如飞
2021-11-14 14:48:11
![](https://img.aspxhome.com/file/2023/2/77402_0s.jpg)
JAVA实现基于Tcp协议的简单Socket通信实例
2022-07-07 21:44:36
![](https://img.aspxhome.com/file/2023/1/99761_0s.jpg)
基于SpringBoot实现用户身份验证工具
2022-05-08 18:37:29
C#实现简易计算器功能(1)(窗体应用)
2022-09-30 16:59:16
![](https://img.aspxhome.com/file/2023/5/91255_0s.jpg)
Java基础之String类使用与字符串比较
2023-11-09 23:46:51
Java权重随机的实现方法
2021-10-05 14:27:50
windows如何使用bat脚本后台启动/停止和重启jar包服务
2022-02-27 12:28:36
Java事件机制要素及实例详解
2022-11-27 07:10:53
Dagger2 Android依赖注入学习笔记
2021-11-27 17:15:54
![](https://img.aspxhome.com/file/2023/7/96747_0s.png)
WinForm拖拽控件生成副本的解决方法
2022-07-02 13:28:26
![](https://img.aspxhome.com/file/2023/5/76385_0s.png)
Intellij IDEA中启动多个微服务(开启Run Dashboard管理)
2022-01-11 02:25:00
![](https://img.aspxhome.com/file/2023/8/62708_0s.png)
scala 读取txt文件的方法示例
2022-09-30 19:21:10
![](https://img.aspxhome.com/file/2023/3/75493_0s.png)