Skip to content

Instantly share code, notes, and snippets.

@RobbeVW

RobbeVW/gist:89faedb21cdc974772cee97b07f02aab Secret

Created March 3, 2021 17:35
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save RobbeVW/89faedb21cdc974772cee97b07f02aab to your computer and use it in GitHub Desktop.
Save RobbeVW/89faedb21cdc974772cee97b07f02aab to your computer and use it in GitHub Desktop.
Download ZIP
a
Raw
gistfile1.txt
@Override
public List<User> findByIds(Set<Long> ids) {
if (ids.isEmpty()) {
return List.of();
}
var query = "SELECT * FROM users WHERE id IN (" + "?,".repeat(ids.size() -1 ) + "?) ORDER BY name";
return template.query(query, userMapper, ids.toArray());
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment