Insert rows to a database using regular and prepared statement utilizing one-by-one and batch mode

Insert.java

package org.jdbc.test;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.sql.Statement;

import static java.lang.String.format;

public class Insert {
    private final Connection connection;

    public Insert(Connection connection) {
        this.connection = connection;
    }

    public void insert(String[] texts) throws SQLException {
        for (int i = 0; i < texts.length; i++) {
            try (Statement statement = connection.createStatement()) {
                statement.executeUpdate(format(
                        "insert into my_table (id, text) values (%d, '%s')",
                        i + 1,
                        texts[i]));
            }
        }


        try (Statement statement = connection.createStatement()) {
            for (int i = 0; i < texts.length; i++) {
                statement.addBatch(format(
                        "insert into my_table (id, text) values (%d, '%s')",
                        i + 1,
                        texts[i]));
            }
            statement.executeBatch();
        }

        try (PreparedStatement ps = connection.prepareStatement(
                "insert into my_table (id, text) values (?, ?)")) {
            for (int i = 0; i < texts.length; i++) {
                ps.setInt(1, i + 1);
                ps.setString(2, texts[i]);
            }
            ps.executeUpdate();
        }

        try (PreparedStatement ps = connection.prepareStatement(
                "insert into my_table (id, text) values (?, ?)")) {
            for (int i = 0; i < texts.length; i++) {
                ps.setInt(1, i + 1);
                ps.setString(2, texts[i]);
                ps.addBatch();
            }
            ps.executeUpdate();
        }
    }
}