Calling hashmap map

Question

I have a hashmap method which is;

    public HashMap<String, String> getUserDetails(){
        HashMap<String,String> user = new HashMap<String,String>();
        String selectQuery = "SELECT  * FROM " + TABLE_LOGIN;

        SQLiteDatabase db = this.getReadableDatabase();
        Cursor cursor = db.rawQuery(selectQuery, null);
        // Move to first row
        cursor.moveToFirst();
        if(cursor.getCount() > 0){
            user.put("name", cursor.getString(1));
            user.put("email", cursor.getString(2));
            user.put("uid", cursor.getString(3));
            user.put("created_at", cursor.getString(4));
        }
        cursor.close();
        db.close();
        // return user
        return user;
    }

I have a string email and I want to get the email of the method where id=10. How can I set the email equal to that certain String basicly; String email = getUserDetails(email Where id=10) I know I'm way off, but you get the idea.

How do you think the extra tags and a somewhat ambiguous question will help? — Mark
– Mark, Commented Feb 8, 2014 at 9:07
SELECT name, email, uid, created_at FROM my_table WHERE id = 10? — Boris the Spider
– Boris the Spider, Commented Feb 8, 2014 at 9:07

Farvardin · Accepted Answer · 2014-02-08 10:17:08Z

2

public HashMap<String, String> getUserDetails(int id){
  HashMap<String,String> user = new HashMap<String,String>();
  String selectQuery = "SELECT  * FROM " + TABLE_LOGIN + " WHERE id=" + id + ";";
  SQLiteDatabase db = this.getReadableDatabase();
  Cursor cursor = db.rawQuery(selectQuery, null);
  // Move to first row
  cursor.moveToFirst();
  if(cursor.getCount() > 0){
      user.put("name", cursor.getString(1));
      user.put("email", cursor.getString(2));
      user.put("uid", cursor.getString(3));
      user.put("created_at", cursor.getString(4));
  }
  cursor.close();
  db.close();
  // return user
  return user;
}

to use it :

String email = getUserDetails(10).get("email");

answered Feb 8, 2014 at 10:17

Farvardin

5,4226 gold badges36 silver badges54 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

SoftwareEnthusiast Over a year ago

the first parameter is int, getUserDetails().get("email"); works but I get compiling errors.

Collectives™ on Stack Overflow

Calling hashmap map

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related