getting data from database table using cursor in android

Question

I have one employee table which has column values

("store_loc_id","name","password","address_id","role_id",
"retailer_id").

I want to get the name and password from this table using cursor. how can i do??

Have you checked javadocs? developer.android.com/reference/android/database/sqlite/… #query method — denis.solonenko
– denis.solonenko, Commented Jun 2, 2011 at 13:37

AMI CHARADAVA · Accepted Answer · 2017-01-19 14:44:16Z

1

Haven't check this code, but the idiom should be understandable.

Cursor cursor = db.query(...);
if(cursor !=null && cursor.moveToFirst()) {
   do {
     String name = cursor.getString(cursor.getColumnIndex("name"));
   } while (cursor.moveToNext());
}

edited Jan 19, 2017 at 14:44

AMI CHARADAVA

3133 silver badges9 bronze badges

answered Jun 2, 2011 at 13:37

Vladimir Ivanov

43.2k19 gold badges80 silver badges103 bronze badges

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

Comments

Nikhil · Accepted Answer · 2011-06-02 13:38:03Z

0

public Cursor getEmployee() {
    try {
        return db.query(employee, new String[] { "name", "password" },
                null, null, null, null, null);
    } catch (SQLException e) {
        Log.e("Exception on query", e.toString());
        return null;
    }
}


Cursor c = db.getEmployee();
    if (c == null) {
        // do nothing
    } else {
        if (c.getCount() > 0) {
            if (c.moveToFirst()) {
                do {
                    String Name = c.getString(0);
                    String Password = c.getString(1);
                } while (c.moveToNext());
            }
        } 
}

answered Jun 2, 2011 at 13:38

Nikhil

16.2k20 gold badges66 silver badges81 bronze badges

1 Comment

Arindam Mukherjee Over a year ago

I need the values of user name and password. Bu using db.getValues() i want to get the values. But what i have to write inside the getValues() that i am not getting.

Collectives™ on Stack Overflow

getting data from database table using cursor in android

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related