Advertisement
Guest User

Untitled

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