java读文件，拼接sql

怼烎@ 2022-07-11 11:22 237阅读 0赞

package com.betawoo.portal.service;
    
    
    import java.io.*;
    
    public class temService{
            public static void main(String[] args) {
                try {
    
                    int count = 1;
                    String pre = "insert into portal_brand_info_extends values(replace(uuid(),'-',''),'d8c03abadec611e6ad56ec59f7ce1f";
    
                    //中间数字
                    //
    
                    String mid = "','label','";
    
                    //标签
                    //
    
                    //顺序
                    //
    
                    String last = ",now());";
    
    
                    InputStreamReader read = new InputStreamReader(new FileInputStream(new File("d://data.txt")),"gbk");
                    BufferedReader br = new BufferedReader(read);
    
                    String str = null;
    
                    // 拼接sql写入文本
                    FileWriter writer = new FileWriter("d://test2.txt", true);
                    BufferedWriter bw = new BufferedWriter(writer);
    
                    String[] labels = null;
                    String id = null;
                    while((str = br.readLine()) != null) {
                        labels = str.split(" ");
                        if (count <= 9){
                            id = "0"+count;
                        }else{id = count+"";}
                        for (int i = 0; i < labels.length; i++){
                            str = pre + id + mid + labels[i] +"'," + (i+1) + last;
                            System.out.println(str);
                        }
                        count++;
                        bw.write(str+"\n");
    
                    }
    
                    br.close();
                    read.close();
    
    
    
    
                    bw.close();
                    writer.close();
                }
                catch(FileNotFoundException e) {
                    e.printStackTrace();
                }
                catch(IOException e) {
                    e.printStackTrace();
                }
            }
    }