Advertisement
Guest User

Untitled

a guest
Jun 16th, 2019
77
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.54 KB | None | 0 0
  1. String minionQuery = "UPDATE minions\n" +
  2. "SET name = LOWER(name) AND age = age + 1\n" +
  3. "WHERE id IN (?);";
  4.  
  5. PreparedStatement statement = this.connection.prepareStatement(minionQuery);
  6.  
  7. List<Integer> inputId = Arrays.stream(this.scan.nextLine().split("\\s+"))
  8. .mapToInt(Integer::parseInt).boxed().collect(Collectors.toList());
  9.  
  10. Array array = this.connection.createArrayOf("INT",inputId.toArray());
  11.  
  12. statement.setArray(1,array);
  13.  
  14. statement.executeUpdate();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement