批量修改txt每行内容格式

工具类如下:

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("执行完毕");
      }
 }

 

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值