Advertisement
Guest User

Untitled

a guest
Apr 28th, 2017
57
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.80 KB | None | 0 0
  1. // Reb
  2. @Override
  3. public Result<Map<String, String>> getUsers() {
  4. final String SQL = "SELECT name, username FROM Person";
  5.  
  6. try (PreparedStatement p = c.prepareStatement(SQL)) {
  7.  
  8. ResultSet r = p.executeQuery();
  9. Map<String, String> userlist = new HashMap<String, String> ();
  10.  
  11. while (r.next()) {
  12. String name = r.getString("name");
  13. String username = r.getString("username");
  14. userlist.put = (name, username);
  15. }
  16. if (!userlist.isEmpty()) {
  17. return Result.success(userlist);
  18.  
  19. }else {
  20. return Result.failure("No users exist");
  21. }
  22.  
  23. }catch (SQLException e){
  24. throw new UnsupportedOperationException("This should get some users." + e);
  25. }
  26. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement