Android: sqlite querying based on username

Question

public ArrayList < PatientInfo > getAllPatients(String username) {
    ArrayList < PatientInfo > patients = new ArrayList < PatientInfo > ();

    open();

    Cursor cursor = db.query(UserTable, null, null, null, null, null, AccessedDate);
    while (cursor != null && cursor.moveToNext()) {
        try {

        } catch (Exception ex) {
            //Log.e("XXX", ex.getMessage());
        }
    }
    if (cursor != null)
        cursor.close();
    close();

    Collections.reverse(patients);
    return patients;
}

I am getting username as argument in my method, how can i query out my table based on username and get the user specific result.

Graham Borland · Accepted Answer · 2013-05-01 21:23:20Z

2

As you can see from the documentation, the third and fourth parameters to query() are the selection and selection args.

So you want something like this:

 Cursor cursor = db.query(UserTable, null, 
                          "username=?", new String[] {username}, 
                          null, null, AccessedDate);

Edit the third parameter as needed to match the actual name of the relevant column in your table.

answered May 1, 2013 at 21:23

Graham Borland

60.8k21 gold badges144 silver badges183 bronze badges

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

Collectives™ on Stack Overflow

Android: sqlite querying based on username

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related