将可分割字段导入数据库进行统计

public class ReadFile {
    public static void main(String[] args) {
        String filePath = "D:\\kdl.txt";
        ReadFile readFile = new ReadFile();
        readTxtFile(filePath);
    }

    public static void readTxtFile(String filePath) {
        try {
            String encoding = "GBK";
            File file = new File(filePath);
            if (file.isFile() && file.exists()) { //判断文件是否存在
                InputStreamReader read = new InputStreamReader(
                        new FileInputStream(file), encoding);//考虑到编码格式
                BufferedReader bufferedReader = new BufferedReader(read);
                String lineTxt = null;
                while ((lineTxt = bufferedReader.readLine()) != null) {
                    if(lineTxt.split(">").length == 1) {
                        System.out.println("insert into table_name(first) values('" +lineTxt.split(">")[0].trim()+"');");

                    } else if (lineTxt.split(">").length == 2) {
                        System.out.println("insert into table_name(first,second) values('"+lineTxt.split(">")[0].trim()+"','"+lineTxt.split
                                (">")
                                [1].trim()+"');");
                    } else if (lineTxt.split(">").length == 3) {
                        System.out.println("insert into table_name(first,second,third) values('"+lineTxt.split(">")[0].trim() + "','"+lineTxt.split(">")[1].trim() + "','" +lineTxt.split(">")[2].trim()+"');");
                    }
                }
                read.close();
            } else {
                System.out.println("找不到指定的文件");
            }
        } catch (Exception e) {
            System.out.println("读取文件内容出错");
            e.printStackTrace();
        }

    }
}

注意：需要创建 

table_name表，有三个字段first second third