CODEWITHSUNDEEP
androidsqlite
emreturka
emreturka

Reputation: 876

Retrieving all of data from sqlite

I will show data which is in sqlite db to spinner. Showing is easy but I can't retrieve the datas that I added to db.Here is my codes;

public class MainActivity extends Activity {

private Spinner spinner;
private SQLiteDBOlustur sqlnesne;
private SQLiteDatabase db;
private ContentValues cv;
private Cursor cursor;
private ArrayList<String> arr;

@Override
protected void onCreate(Bundle savedInstanceState) {
    super.onCreate(savedInstanceState);
    setContentView(R.layout.activity_main);
    spinner = (Spinner) findViewById(R.id.spinnerIller);
    arr = new ArrayList<String>();
    veriEkle();

    db = sqlnesne.getReadableDatabase();
    cursor = db.rawQuery("select * from iller", null);

    if (cursor.moveToFirst()) {
        do {
            arr.add(cursor.getString(cursor.getColumnIndex("adsoyad")));
        } while (cursor.moveToPrevious());
    }


    for (int i = 0; i < arr.size(); i++) {
        System.out.println(arr.get(i));
    }

}

Only I can see the last added data.So how to get all of data in my sqlite db?

Also these are adding data method.

  private void veriEkle() {
   sqlnesne = new SQLiteDBOlustur(getApplicationContext());
   db = sqlnesne.getWritableDatabase();
   cv = new ContentValues();

       cv.put("il_adi", "Yalova");
   cv.put("il_adi", "Karabük");
   cv.put("il_adi", "Kilis");
   cv.put("il_adi", "Osmaniye");
   cv.put("il_adi", "Düzce");

    try {
        db.insert("iller", null, cv);
        Toast.makeText(getApplicationContext(), "Veriler eklendi!",
                Toast.LENGTH_SHORT).show();
    } catch (Exception e) {
        e.printStackTrace();
    }
}

Upvotes: 0

Views: 124

Answers (3)

Sanket Shah
Sanket Shah

Reputation: 4382

Try this

@Override
protected void onCreate(Bundle savedInstanceState) {
    super.onCreate(savedInstanceState);
    setContentView(R.layout.activity_main);

    spinner = (Spinner) findViewById(R.id.spinnerIller);
    arr = new ArrayList<String>();

    veriEkle();

        String Table_Name="name of table";

        String selectQuery = "SELECT  * FROM " + Table_Name;
        SQLiteDatabase db = this.getReadableDatabase();

        Cursor cursor = db.rawQuery(selectQuery, null);
        String[] data = null;

        if (cursor.moveToFirst()) {
            do {
               // get  the  data into array,or class variable
              // process your data here.
            } while (cursor.moveToNext());
        }
}

Hope it will help you.

Upvotes: 0

miten joshi
miten joshi

Reputation: 185

if (cursor != null && cursor.moveToFirst()) {
        while (cursor.isAfterLast() == false) {
            arr.add(cursor.getString(cursor.getColumnIndex("adsoyad")));
            cursor.moveToNext();
        }
    }   
    cursor.close();

Try this way!!

Upvotes: 0

Paul Blessing
Paul Blessing

Reputation: 3845

Try replacing cursor.moveToPrevious() with cursor.moveToNext() so that you step forward through the cursor rather than back.

Upvotes: 1

Related Questions