Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- String minionQuery = "UPDATE minions\n" +
- "SET name = LOWER(name) AND age = age + 1\n" +
- "WHERE id IN (?);";
- PreparedStatement statement = this.connection.prepareStatement(minionQuery);
- List<Integer> inputId = Arrays.stream(this.scan.nextLine().split("\\s+"))
- .mapToInt(Integer::parseInt).boxed().collect(Collectors.toList());
- Array array = this.connection.createArrayOf("INT",inputId.toArray());
- statement.setArray(1,array);
- statement.executeUpdate();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement