工具类如下:
package com.ict.importdata;
import sun.misc.IOUtils;
import java.io.*;
import java.util.ArrayList;
import java.util.List;
import java.util.Map;
/**
* @author: DevRongTai
* @description: TXTUtil
* @date: 2020/12/31 14:12
*/
public class TXTUtil {
/**
* @Description 读取txt中的内容
* @return void
* @throws
**/
public static List<String> txt2String(File file){
List<String> txtList = new ArrayList<>();
try{
//构造一个BufferedReader类来读取文件
BufferedReader br = new BufferedReader(new FileReader(file));
String s = null;
while((s = br.readLine())!=null){
txtList.add(s);
}
br.close();
}catch(Exception e){
e.printStackTrace();
}
return txtList;
}
//执行插入
public static void writeTxt(List<String> txtList,String name) throws FileNotFoundException {
String fileName = "C://Users/Lenovo/Desktop/"+name+".sql";
String sql = "";
BufferedWriter bufferedWriter = null;
try{
bufferedWriter = new BufferedWriter(new OutputStreamWriter(new FileOutputStream(new File(fileName)),"UTF-8"));
for (String txt:txtList) {
String[] txtArr = txt.split("~");
sql = "txt修改成sql语句";
bufferedWriter.write(sql);
bufferedWriter.newLine();
}
bufferedWriter.flush();
}catch (Exception e){
System.out.println("写出csv文件时错误");
}finally {
try {
bufferedWriter.close();
} catch (IOException e) {
e.printStackTrace();
}
}
}
public static void main(String[] args) throws FileNotFoundException {
String fileName = "文件名称";
File file = new File("文件存放位置"+fileName+".txt");
List<String> txtList = txt2String(file);
writetxt(txtList,fileName);
/*JDBCUtil.getConnection();
JDBCUtil.executeInsert(txtList);*/
System.out.println("执行完毕");
}
}