Get all rows from SQLite

Question

I have been trying to get all rows from the SQLite database  But I got only last row from the following codes    FileChooser class   public ArrayList lt String gt  readFileFromSQLite        fileName   new ArrayList lt String gt        fileSQLiteAdapter   new FileSQLiteAdapter FileChooser this     fileSQLiteAdapter openToRead      cursor   fileSQLiteAdapter queueAll       if  cursor    null        if  cursor moveToFirst            do           fileName add cursor getString cursor getColumnIndex FileSQLiteAdapter KEY CONTENT1             while  cursor moveToNext                cursor close           fileSQLiteAdapter close      return fileName      FileSQLiteAdapter class   public Cursor queueAll       String   columns   new String     KEY ID  KEY CONTENT1       Cursor cursor   sqLiteDatabase query MYDATABASE TABLE  columns  null                  null  null  null  null     return cursor      Please tell me where is my incorrect  Appreciate

User · Answer

public List lt String gt  getAllData String email         db   this getReadableDatabase        String   projection  email        List lt String gt  list new ArrayList lt  gt          Cursor cursor   db query TABLE USER    Table to query             null       columns to return              user email              columns for the WHERE clause             projection           The values for the WHERE clause             null          group the rows             null          filter by row groups             null           cursor moveToFirst         if  cursor moveToFirst              do                list add cursor getString cursor getColumnIndex  user id                  list add cursor getString cursor getColumnIndex  user name                  list add cursor getString cursor getColumnIndex  user email                  list add cursor getString cursor getColumnIndex  user password                     cursor moveToNext               while  cursor moveToNext               return list

User · Answer

This is almost the same solution as the others  but I thought it might be good to look at different ways of achieving the same result and explain a little bit   Probably you have the table name String variable initialized at the time you called the DBHandler so it would be something like   private static final String MYDATABASE TABLE    anyTableName     Then  wherever you are trying to retrieve all table rows   SQLiteDatabase db   this getReadableDatabase    Cursor cursor   db rawQuery  select   from     MYDATABASE TABLE  null    List lt String gt  fileName   new ArrayList lt  gt     if  cursor moveToFirst        fileName add cursor getString cursor getColumnIndex COLUMN NAME        while cursor moveToNext           fileName add cursor getString cursor getColumnIndex COLUMN NAME            cursor close    db close      Honestly  there are many ways about doing this

User · Answer

Update queueAll   method as below   public Cursor queueAll           String selectQuery    SELECT   FROM     MYDATABASE TABLE       Cursor cursor   sqLiteDatabase rawQuery selectQuery  null         return cursor      Update readFileFromSQLite   method as below   public ArrayList lt String gt  readFileFromSQLite          fileName   new ArrayList lt String gt          fileSQLiteAdapter   new FileSQLiteAdapter FileChooser this       fileSQLiteAdapter openToRead         cursor   fileSQLiteAdapter queueAll         if  cursor    null            if  cursor moveToFirst                  do                                String name   cursor getString cursor getColumnIndex FileSQLiteAdapter KEY CONTENT1                    fileName add name                 while  cursor moveToNext                       cursor close               fileSQLiteAdapter close         return fileName

User · Answer

Using Android s built in method  If you want every column and every row  then just pass in null for the SQLiteDatabase column and selection parameters   Cursor cursor   db query TABLE NAME  null  null  null  null  null  null  null     More details  The other answers use rawQuery  but you can use Android s built in SQLiteDatabase  The documentation for query says that you can just pass in null to the selection parameter to get all the rows      selection Passing null will return all rows for the given table    And while you can also pass in null for the column parameter to get all of the columns  as in the one-liner above   it is better to only return the columns that you need  The documentation says     columns  Passing null will return all columns  which is discouraged to prevent reading data from storage that isn t going to be used    Example  SQLiteDatabase db   mHelper getReadableDatabase    String   columns             MyDatabaseHelper COLUMN 1          MyDatabaseHelper COLUMN 2          MyDatabaseHelper COLUMN 3   String selection   null     this will select all rows Cursor cursor   db query MyDatabaseHelper MY TABLE  columns  selection          null  null  null  null  null

User · Answer

Cursor cursor   myDb viewData             if  cursor moveToFirst                   do                    String itemname cursor getString cursor getColumnIndex myDb col 2                     String price cursor getString cursor getColumnIndex myDb col 3                     String quantity cursor getString cursor getColumnIndex myDb col 4                     String table no cursor getString cursor getColumnIndex myDb col 5                       while  cursor moveToNext                                         cursor requery

User · Answer

try   Cursor  cursor   db rawQuery  select   from table  null     AND  for List lt String gt    if  cursor moveToFirst        while   cursor isAfterLast          String name   cursor getString cursor getColumnIndex countyname         list add name       cursor moveToNext

User · Answer

I have been looking into the same problem  I think your problem is related to where you identify the variable that you use to populate the ArrayList that you return  If you define it inside the loop  then it will always reference the last row in the table in the database  In order to avoid this  you have to identify it outside the loop   String name  if  cursor moveToFirst               while  cursor isAfterLast      false                name   cursor getString cursor                      getColumnIndex countyname                 list add name               cursor moveToNext

[android] Get all rows from SQLite

Examples related to android

Examples related to sqlite