Option-3 (Batch insertion)

Option-3.java

public void insertStudents(List<Student> students) {
    String statement = "INSERT INTO student VALUES(?,?,?)";
    try (Connection connection = config.getConnection()) {
        try (PreparedStatement ps = connection.prepareStatement(statement)) {
            for (int i = 0; i < students.size(); i++) {
                Student student = students.get(i);
                int j = 0;
                ps.setString(++j, student.getGuid());
                ps.setString(++j, student.getName());
                ps.setInt(++j, student.getId());
                ps.addBatch();
                if (i % 1000 == 0) {
                    ps.executeBatch();
                }
            }
            ps.executeBatch();
            System.out.println("Batch successfully inserted");
        }
    } catch (SQLException e) {
        throw new RuntimeException(e);
    }
}