SQLite Android Cursor sql statement

Question

I am trying to write a SQL query like this

SELECT * 
FROM TABLE_USER 
WHERE theUser = userID;

but Android uses Cursor, and I'm not sure if I am doing this right. Can someone confirm? This is the header for the Cursor query function:

public Cursor query (String table, String[] columns, String selection, String[] selectionArgs, String groupBy, String having, String orderBy)

selection: A filter declaring which rows to return, formatted as an SQL WHERE clause (excluding the WHERE itself). Passing null will return all rows for the given table.

And this is my code:

public ArrayList<Goal> getAllGoals(User user) {

    int currentUserID = user.getUserID();
    String theUser = Integer.toString(currentUserID);

    String[] columns = new String[] {userID, goal, activityType, target_steps, completed_steps};

    Cursor c = db.query(TABLE_GOAL, columns, theUser, null, null, null, null);

    ArrayList<Goal> allGoals = new ArrayList<Goal>();


    while(c.moveToNext()){
        c.getInt(currentUserID);
        c.getInt()
    }
    c.close();


    return allGoals;
}

You are forgetting the 4th argument, it is your argument parameter. Should be something like userId. — zgc7009
– zgc7009, Commented Dec 4, 2014 at 20:37

Community · Accepted Answer · 2017-05-23 12:01:05Z

2

selectionArgs replace any question marks in the selection string.

for example:

String[] args = { "first string", "[email protected]" };
Cursor cursor = db.query("TABLE_NAME", null, "name=? AND email=?", args, null);

reference:

Using String[] selectionArgs in SQLiteDatabase.query()

edited May 23, 2017 at 12:01

CommunityBot

11 silver badge

answered Dec 4, 2014 at 20:50

dxiong4

663 bronze badges

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

Collectives™ on Stack Overflow

SQLite Android Cursor sql statement

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related