Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public void increaseMinionsAge() throws IOException, SQLException {
- BufferedReader br = new BufferedReader(new InputStreamReader(System.in));
- String[] input = br.readLine().split("\\s+");
- String idToChange = String.join(", ", input);
- ResultSet resultSet;
- Statement statement;
- statement = connection.createStatement();
- statement.executeUpdate(String.format("UPDATE minions SET age = age + 1, name = lower(name) WHERE id IN (%s);", idToChange));
- resultSet = statement.executeQuery("SELECT name, age FROM minions_db.minions;");
- while (resultSet.next()) {
- System.out.println(resultSet.getString(1) + " " + resultSet.getInt(2));
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement