在java中索引文本文件

import java.io.BufferedReader;
import java.io.FileReader;
import java.io.IOException;
import java.io.InputStreamReader;

public class TextIndexing {
    public static void main(String[] args) {
        String fileName = "example.txt";

        try {
            BufferedReader reader = new BufferedReader(new FileReader(fileName));
            String line = reader.readLine();

            while (line != null) {
                System.out.println(line);
                line = reader.readLine();
            }

            reader.close();
        } catch (IOException e) {
            System.err.format("Exception occurred trying to read '%s'.", fileName);
            e.printStackTrace();
        }
    }
}

import java.io.BufferedReader;
import java.io.FileReader;
import java.io.IOException;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

public class TextIndexingWithDB {
    public static void main(String[] args) {
        String fileName = "example.txt";
        String dbUrl = "jdbc:mysql://localhost:3306/mydatabase";
        String dbUser = "username";
        String dbPassword = "password";

        try {
            Connection connection = DriverManager.getConnection(dbUrl, dbUser, dbPassword);
            PreparedStatement statement = connection.prepareStatement("INSERT INTO mytable (text) VALUES (?)");

            BufferedReader reader = new BufferedReader(new FileReader(fileName));
            String line = reader.readLine();

            while (line != null) {
                statement.setString(1, line);
                statement.addBatch();
                line = reader.readLine();
            }

            statement.executeBatch();
            connection.commit();

            reader.close();
            statement.close();
            connection.close();
        } catch (IOException e) {
            System.err.format("Exception occurred trying to read '%s'.", fileName);
            e.printStackTrace();
        }
    }
}