SQLite Query in Android to count rows

Question

I m trying to create a simple Login form  where I compare the login id and password entered at the login screen with that stored in the database   I m using the following query   final String DATABASE COMPARE    select count    from users where uname     loginname    and pwd     loginpass            The issue is  I don t know  how can I execute the above query and store the count returned   Here s how the database table looks like   I ve manged to create the database successfully using the execSQl method   private static final String DATABASE CREATE                create table users   id integer autoincrement                   name text not null  uname primary key text not null                    pwd text not null        phoneno text not null       Can someone kindly guide me as to how I can achieve this  If possible please provide a sample snippet to do the above task

User · Answer

how to get count column  final String DATABASE COMPARE    select count    from users where uname   loginname   and pwd   loginpass   int sometotal    int  DatabaseUtils longForQuery db  DATABASE COMPARE  null     This is the most concise and precise alternative  No need to handle cursors and their closing

User · Answer

If you want to get the count of records then you have to apply the group by on some field or apply the below query   Like  db rawQuery  select count field  as count record from tablename where field      condition  null

User · Answer

Use an SQLiteStatement   e g    SQLiteStatement s   mDb compileStatement   select count    from users where uname      loginname      and pwd      loginpass               long count   s simpleQueryForLong

User · Answer

int nombr   0  Cursor cursor   sqlDatabase rawQuery  SELECT column FROM table WHERE column   Value   null   nombr   cursor getCount

User · Answer

See rawQuery String  String    and the documentation for Cursor   Your DADABASE COMPARE SQL statement is currently invalid  loginname and loginpass won t be escaped  there is no space between loginname and the and  and you end the statement with    instead of   -- If you were logging in as bob with the password of password  that statement would end up as  select count    from users where uname boband pwd password     Also  you should probably use the selectionArgs feature  instead of concatenating loginname and loginpass   To use selectionArgs you would do something like  final String SQL STATEMENT    SELECT COUNT    FROM users WHERE uname   AND pwd      private void someMethod         Cursor c   db rawQuery SQL STATEMENT  new String     loginname  loginpass

User · Answer

Assuming you already have a Database  db  connection established  I think the most elegant way is to stick to the Cursor class  and do something like   String selection    uname     AND pwd       String   selectionArgs    loginname  loginpass   String tableName    YourTable   Cursor c   db query tableName  null  selection  selectionArgs  null  null  null   int result   c getCount    c close    return result

User · Answer

Another way would be using   myCursor getCount      on a Cursor like   Cursor myCursor   db query table Name  new String     row Username     row Username        AND     row Password          new String     entered Password  entered Password     null  null  null     If you can think of getting away from the raw query

User · Answer

If you are using ContentProvider then you can use   Cursor cursor   getContentResolver   query CONTENT URI  new String     count                   uname     loginname     and pwd     loginpass  null  null       cursor moveToFirst        int count   cursor getInt 0

User · Answer

DatabaseUtils queryNumEntries  since api 11  is useful alternative that negates the need for raw SQL yay      SQLiteDatabase db   getReadableDatabase    DatabaseUtils queryNumEntries db   users                    uname   AND pwd     new String    loginname loginpass

User · Answer

scottyab the parametrized DatabaseUtils queryNumEntries db  table  whereparams  exists at API 11    the one without the whereparams exists since API 1  The answer would have to be creating a Cursor with a db rawQuery   Cursor mCount  db rawQuery  select count    from users where uname      loginname      and pwd      loginpass       null   mCount moveToFirst    int count  mCount getInt 0   mCount close      I also like  Dre s answer  with the parameterized query

[android] SQLite Query in Android to count rows

Examples related to android

Examples related to sqlite

Examples related to count