public class Application { public static void main(String[] args) throws SQLException { List<String> products = List.of("computer", "mobile phone", "tv", "kettle"); tr

Вопрос пользователя:

public class Application { public static void main(String[] args) throws SQLException { List<String> products = List.of("computer", "mobile phone", "tv", "kettle"); try (var conn = DriverManager.getConnection("jdbc:h2:mem:hexlet")) { var sql = "CREATE TABLE products " + "(id BIGINT PRIMARY KEY AUTO_INCREMENT, name VARCHAR(255))"; try (var statement = conn.createStatement()) { statement.execute(sql); } // BEGIN (write your solution here) // END var sql3 = "SELECT * FROM products ORDER BY name"; try (var statement3 = conn.createStatement()) { var resultSet = statement3.executeQuery(sql3); while (resultSet.next()) { System.out.println(resultSet.getString("name")); } } } } }

Ответ нейросети:

// BEGIN
String insertSql = "INSERT INTO products (name) VALUES (?)";
try (var insertStatement = conn.prepareStatement(insertSql)) {
    for (String product : products) {
        insertStatement.setString(1, product);
        insertStatement.executeUpdate();
    }
}
// END

Напишите нам, если в вопросе есть ваши персональные данные ([email protected])

Последние вопросы: