Option-4 (Multi rows batch insertion)

Option-4.java

public void insertStudents(List<Student> students) {
    String initialInsertStatement = "INSERT INTO student VALUES";
    StringBuilder query = new StringBuilder(initialInsertStatement);
    try (Connection connection = config.getConnection()) {
        try (Statement statement = connection.createStatement()) {
            for (int i = 0; i < students.size(); i++) {
                if (i == 0) {
                    query.append(asSqlQuery(students.get(i)));
                } else if (i % 200 != 0) {
                    query.append(",")
                        .append(asSqlQuery(students.get(i)));
                } else {
                    statement.addBatch(query.toString());
                    query = new StringBuilder(initialInsertStatement);
                    query.append(asSqlQuery(students.get(i)));
                }
                if (i % 1000 == 0) {
                    statement.executeBatch();
                    System.out.println("Batch successfully inserted");
                }
                i++;
            }
            statement.addBatch(query.toString());
            statement.executeBatch();
        }
    } catch (SQLException e) {
        throw new RuntimeException(e);
    }
}

private static String asSqlQuery(Student student) {
        return String.format("('%s','%s', %s)", student.getGuid(), student.getName(), student.getId());
}