Perform a query with multiple WHERE clauses using SQLite in Android Studio

Question

Hi im very new to Android dev so i have this query that will look into my table and check whether a certain record is existing given the username and password to as of now i have this

public user getLOGusr(String uname, String pass)
{
    SQLiteDatabase db = this.getReadableDatabase();
    Cursor cursor = db.query(TABLE_USRS, new String[]{KEY_ID,KEY_NAME,KEY_E_ADDR,KEY_PASS} , KEY_NAME + "=?", KEY_PASS + "=?",
                    new String[]{String.valueOf(uname), String.valueOf(pass)});

    return somestuff;
}

but it is riddled with a lot of errors. any improvements on my code? thanks so much

earthw0rmjim · Accepted Answer · 2016-07-02 13:10:01Z

2

Something like this should work:

public user getLOGusr(String uname, String pass)
{
    SQLiteDatabase db = getReadableDatabase();

    // replace * with comma-separated column names
    // if you do not wish to return all columns
    String select = "SELECT * FROM " + TABLE_USRS + " WHERE " + KEY_NAME + " = ? AND " + KEY_PASS + " = ?";

    Cursor cursor = db.rawQuery(select, new String[]{uname, pass});

    // get the data from the Cursor and return stuff
}

edited Jul 2, 2016 at 13:10

answered Jul 2, 2016 at 12:58

earthw0rmjim

19.5k9 gold badges54 silver badges65 bronze badges

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

Comments

Clive Seebregts · Accepted Answer · 2016-07-02 13:19:46Z

2

Try this:

String[] tableColumns = new String[] {
  KEY_ID,KEY_NAME,KEY_E_ADDR,KEY_PASS
};
String whereClause = KEY_NAME + " = ? AND " + KEY_PASS  + " = ?";
String[] whereArgs = new String[] {
  uname,
  pass
};
Cursor c = db.query(TABLE_USRS, tableColumns, whereClause, whereArgs, null, null, null);

edited Jul 2, 2016 at 13:19

answered Jul 2, 2016 at 13:12

Clive Seebregts

2,05415 silver badges19 bronze badges

1 Comment

earthw0rmjim Over a year ago

What is the point of calling String.valueOf() when the params are both Strings?

Collectives™ on Stack Overflow

Perform a query with multiple WHERE clauses using SQLite in Android Studio

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