Option-2 (Single insert with keeping a connection alive for all insertion)

Option-2.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.executeUpdate();
            }
        }
    } catch (SQLException e) {
        throw new RuntimeException(e);
    }
}